Bugs item #2837594, was opened at 2009-08-14 14:54 Message generated for change (Comment added) made by mr-meltdown You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2837594&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL "stable" >Status: Closed Resolution: Rejected Priority: 5 Private: No Submitted By: Wouter Alink (vzzzbx) Assigned to: Fabian (mr-meltdown) Summary: SQL: "create user" not transactional Initial Comment: When adding a user in a transaction... it is created regardless of the transaction outcome. (see example below) (on the May2009 branch). I assume it should obey the transaction outcome. $ mclient -lsql -dtest3 sql>START TRANSACTION; 0 tuples sql>CREATE USER "aap" WITH PASSWORD 'aap' NAME 'AAP user' SCHEMA "aap"; 0 tuples sql>ROLLBACK; 0 tuples sql>CREATE USER "aap" WITH PASSWORD 'aap' NAME 'AAP user' SCHEMA "aap"; !CREATE USER: user 'aap' already exists 0 tuples sql> ---------------------------------------------------------------------- >Comment By: Fabian (mr-meltdown) Date: 2009-08-16 10:49 Message: agreed ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2009-08-16 10:32 Message: users are m5 objects, ie not controlled by m5/sql. As users are outside the sql standard we can consider this a feature. ---------------------------------------------------------------------- Comment By: Wouter Alink (vzzzbx) Date: 2009-08-14 14:58 Message: oops, replaced to many values in the given example, the example below works on a clean database (using schema 'sys' instead of 'aap') START TRANSACTION; CREATE USER "aap" WITH PASSWORD 'aap' NAME 'AAP user' SCHEMA "sys"; ROLLBACK; CREATE USER "aap" WITH PASSWORD 'aap' NAME 'AAP user' SCHEMA "sys"; ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2837594&group_id=56967 ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
