On Tue, 20 Mar 2012 22:31:55 +0530, Mohit Srivastava <[email protected]> wrote: > I got "Transactional DDL not supported" when Create table query is > executing through execute.run() . Any solution to run this query > successfully .
If you are in an explicit transaction, you can't currently execute DDL. This differs from MySQL behaviour (MySQL would *implicitly* commit current txn). If using EXECUTE(), it will run everything in an explicit transaction, so you may need to "COMMIT; CREATE TABLE". If using Drizzle via a normal connector, it means you've got an open transaction and the error message is letting you know that you should work out if you want to commit it or not before performing DDL. -- Stewart Smith _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
