| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.8.6 |
| Bug #11696 | getDefinitionFromDatabase() ends with ROLLBACK, without START TRANSACTION | ||
|---|---|---|---|
| Submitted: | 2007-07-28 13:19 UTC | ||
| From: | floele | Assigned: | |
| Status: | Open | Package: | MDB2_Schema (version CVS) |
| PHP Version: | Irrelevant | OS: | Irrelevant |
| Roadmaps: | (Not assigned) | ||
[2007-07-28 13:19 UTC] floele
(Florian Schmitz)
Description:
------------
Hi once again ;)
I hope that I got an MDB2_Schema bug instead of an MDB2 one this time at least...
I recently submitted 11692 which already mentions my problem, but now I realised that this bug is in fact unrelated to it.
So what I am doing is thw following:
$db->supports('transactions') && $db->beginTransaction();
$db->query(...);
$previous_schema = $schema->getDefinitionFromDatabase();
die(); // usually I'd continue with updateDatabase() and a few more queries and then commit it all together, but that won't work either so I have this for simplicity.
Interestingly, the query log shows a ROLLBACK at the bottom, without a START TRANSACTION at the beginning.
See: http://pastebin.ca/637004
I highlighted the important parts.
Expected result:
----------------
Either no ROLLBACK at the end, or a new nested transaction at the beginning.
Actual result:
--------------
ROLLBACK at the end, without starting a new transaction.
Comments
[2007-08-29 16:32 UTC] ifeghali
(Igor Feghali)
Hello Florian,
I still have no clue on this one... Will investigate this later.
regards,
iGor.
[2008-01-30 12:36 UTC] ifeghali
(Igor Feghali)
Weird getDefinitionFromDatabase() doesn't end any transaction directly. It may be somewhat related to Bug #11692. Let's wait for it.