Bug #64571 [NEW]: PDO CREATE TRIGGER
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
Thread (4 messages)
- jehoshua02 at gmail dot com