On 25/01/13 7:40 PM, markus.hoeni...@mhoenicka.de wrote: > Markus Hoenicka writes: > > Another possible reason for problems is the table type. If someone > > uses MyISAM tables, the result I got would be expected. However, MySQL > > uses InnoDB tables as default these days, and I double-checked that > > they were used in my tests. > > Turns out that InnoDB is the default engine only in versions 5.5.5 and > later. On my box, MyISAM tables were created by default. The test
Yes, you just found out the hard way that it's wise to include ENGINE specifications in MySQL CREATE TABLE's. They took far too long to change the default engine to InnoDB. --Toby > correctly found out that the latter don't support transactions :-( > > I've changed the CREATE TABLE statement on my box to ask for InnoDB > tables instead. This eliminates the failure of the rollback test. > > I'll try and finish the test suite asap. The transaction tests require > some polish as they should run only if the driver supports > transactions. > > regards, > Markus > ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. ON SALE this month only -- learn more at: http://p.sf.net/sfu/learnnow-d2d _______________________________________________ libdbi-users mailing list libdbi-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-users
