Return to bug54929.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / pdo_mysql / tests

Annotation of embedaddon/php/ext/pdo_mysql/tests/bug54929.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: Bug #54929 (Parse error with single quote in sql comment (pdo-mysql))
        !             3: --SKIPIF--
        !             4: <?php
        !             5: require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'skipif.inc');
        !             6: require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
        !             7: MySQLPDOTest::skip();
        !             8: 
        !             9: ?>
        !            10: --FILE--
        !            11: <?php
        !            12: 
        !            13: require_once(dirname(__FILE__) . DIRECTORY_SEPARATOR . 'mysql_pdo_test.inc');
        !            14: 
        !            15: $pdodb = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
        !            16: 
        !            17: 
        !            18: function testQuery($query) {
        !            19:        global $pdodb;
        !            20:        $stmt = $pdodb->prepare($query);
        !            21:        
        !            22:        if (!$stmt->execute(array("foo"))) {
        !            23:                var_dump($stmt->errorInfo());
        !            24:        } else{
        !            25:                var_dump($stmt->fetch(PDO::FETCH_ASSOC));
        !            26:        }
        !            27: }
        !            28: 
        !            29: testQuery("/* ' */ select ? as f1 /* ' */");
        !            30: testQuery("/* '-- */ select ? as f1 /* *' */");
        !            31: testQuery("/* ' */ select ? as f1 --';");
        !            32: testQuery("/* ' */ select ? as f1 -- 'a;");
        !            33: testQuery("/*'**/ select ? as f1 /* ' */");
        !            34: testQuery("/*'***/ select ? as f1 /* ' */");
        !            35: testQuery("/*'**a ***b / ****
        !            36: ******
        !            37: **/ select ? as f1 /* ' */");
        !            38: 
        !            39: ?>
        !            40: --EXPECTF--
        !            41: array(1) {
        !            42:   ["f1"]=>
        !            43:   string(3) "foo"
        !            44: }
        !            45: array(1) {
        !            46:   ["f1"]=>
        !            47:   string(3) "foo"
        !            48: }
        !            49: 
        !            50: 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
        !            51: array(3) {
        !            52:   [0]=>
        !            53:   string(5) "42000"
        !            54:   [1]=>
        !            55:   int(1064)
        !            56:   [2]=>
        !            57:   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"
        !            58: }
        !            59: array(1) {
        !            60:   ["f1"]=>
        !            61:   string(3) "foo"
        !            62: }
        !            63: array(1) {
        !            64:   ["f1"]=>
        !            65:   string(3) "foo"
        !            66: }
        !            67: array(1) {
        !            68:   ["f1"]=>
        !            69:   string(3) "foo"
        !            70: }
        !            71: array(1) {
        !            72:   ["f1"]=>
        !            73:   string(3) "foo"
        !            74: }