Two interesting but ultimately trivial errors.
The documentation merely has USER_CREATE() but this will error if the
schema context is not DB.DBA. A trivial enough issue.
create procedure test.test.testUserDrop ( )
{
DB.DBA.USER_CREATE('testUser','badpassword');
};
test.test.testUserDrop();
user_drop('testUser');
The statement execution did not return a result set.
SQLState: 42000
Message: U0002: The object "testUser" does not exist.
user_drop('testUser')
This is more trivial than it looks. The user really was deleted but an
exception was thrown anyway. The effect is more annoying than serious
though if the user_drop is done from a function, it would cause that
function to exit prematurely which could be serious.
Interestingly, this code works without error:
user_create('testUser','badpassword);
user_drop('testUser');
The debug log doesn't offer any clues.
Version 7.1.1-dev.3207-pthreads as of Feb 17 2014
Compiled for Linux (x86_64-unknown-linux-gnu)
--
Quentin | Clear Blue Water Pty Ltd
quent...@clearbluewater.com.au
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users