Test: /ext/pdo_mysql/tests/bug54929.phpt - Version 5.6.0-dev        

Bug #54929 Parse error with single quote in sql comment
Submitted: 2011-05-25 20:00:25 Modified: 2011-06-05 00:54:06
From: hencke Assigned: felipe
Status: Closed Package: PDO related
PHP Version: 5.2.17 OS: linux (centos 5.5)

There are 2 different diffs reported by users for this test.

Count Diff
1 (50%)
010+ Warning: PDOStatement::execute(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '--'' at line 1 in %s/bug54929.php on line 12
010- Warning: PDOStatement::execute(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--'' at line 1 in %s on line %d
017+ string(151) "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '--'' at line 1"
017- string(149) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--'' at line 1"
1 (50%)
010+ Warning: PDO::prepare(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--'' at line 1 in %s/bug54929.php on line 10
011+
012+ Fatal error: Call to a member function execute() on a non-object in %s/bug54929.php on line 12
010- Warning: PDOStatement::execute(): SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--'' at line 1 in %s on line %d
011- array(3) {
012- [0]=>
013- string(5) "42000"
014- [1]=>
015- int(1064)
016- [2]=>
017- string(149) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--'' at line 1"
018- }
019- array(1) {
020- ["f1"]=>
021- string(3) "foo"
022- }
023- array(1) {
024- ["f1"]=>
025- string(3) "foo"
026- }
027- array(1) {
028- ["f1"]=>
029- string(3) "foo"
030- }
031- array(1) {
032- ["f1"]=>
033- string(3) "foo"
034- }