From: jehoshua02 at gmail dot com Operating system: Ubuntu 12.10 Desktop 64bit PHP version: 5.4.13 Package: PDO related Bug Type: Bug Bug description:PDO CREATE TRIGGER
Description: ------------ I'm using PDO in some simple script to do database migrations and realized that my triggers weren't being created. I checked to make sure the triggers were correct by first copying and pasting them into mysql interactive console, then by using `SOURCE ...`, then by passing the file name into mysql command, each time verifying the trigger was created by using "SHOW TRIGGERS WHERE `Trigger` = :trigger". I concluded that the problem was not with my trigger statements, or with mysql, but with PDO. The actual PHP version is 5.4.6-1ubuntu1.2 so I chose the closest one. Test script: --------------- https://gist.github.com/jehoshua02/5297332 Expected result: ---------------- I would expect to see the trigger printed as an associative array. Actual result: -------------- The trigger is not created even though the script completes without any errors or exceptions. -- Edit bug report at https://bugs.php.net/bug.php?id=64571&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=64571&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=64571&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=64571&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=64571&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=64571&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=64571&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=64571&r=needscript Try newer version: https://bugs.php.net/fix.php?id=64571&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=64571&r=support Expected behavior: https://bugs.php.net/fix.php?id=64571&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=64571&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=64571&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=64571&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=64571&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=64571&r=dst IIS Stability: https://bugs.php.net/fix.php?id=64571&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=64571&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=64571&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=64571&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=64571&r=mysqlcfg
