Return to bug43925.phpt CVS log

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

Annotation of embedaddon/php/ext/pdo_pgsql/tests/bug43925.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: Bug #43925 (Incorrect argument counter in prepared statements with pgsql)
                      3: --SKIPIF--
                      4: <?php
                      5: if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded');
                      6: require dirname(__FILE__) . '/config.inc';
                      7: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
                      8: PDOTest::skip();
                      9: ?>
                     10: --FILE--
                     11: <?php
                     12: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
                     13: $dbh = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
                     14: 
                     15: @$dbh->query('DROP TABLE nodes');
                     16: 
                     17: $dbh->query('
                     18: CREATE TABLE nodes
                     19: (
                     20:    id   integer NOT NULL PRIMARY KEY
                     21:  , root integer NOT NULL
                     22:  , lft  integer NOT NULL
                     23:  , rgt  integer NOT NULL
                     24: );');
                     25: 
                     26: $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (1, 1, 1, 6);');
                     27: $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (2, 1, 2, 3);');
                     28: $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (3, 1, 4, 5);');
                     29: 
                     30: 
                     31: $stmt = $dbh->prepare('
                     32:        SELECT * 
                     33:        FROM nodes 
                     34:        WHERE (:rootId > 0 OR lft > :left OR rgt > :left) 
                     35:                AND (root = :rootId OR root  = :left)
                     36:                AND (1 > :left OR 1 < :left OR 1 = :left) 
                     37:                AND (:x > 0 OR :x < 10 OR :x > 100) 
                     38:                OR :y = 1 OR :left = 1
                     39: ');
                     40: 
                     41: $stmt->bindValue('left',   1, PDO::PARAM_INT);
                     42: $stmt->bindValue('rootId', 3, PDO::PARAM_INT);
                     43: $stmt->bindValue('x', 5, PDO::PARAM_INT);
                     44: $stmt->bindValue('y', 50, PDO::PARAM_INT);
                     45: 
                     46: $stmt->execute();
                     47: 
                     48: foreach ($stmt->fetchAll() as $row) {
                     49:        print implode(' - ', $row);
                     50:        print "\n";
                     51: }
                     52: 
                     53: $dbh->query('DROP TABLE nodes');
                     54: 
                     55: ?>
                     56: --EXPECTF--
                     57: 1 - 1 - 1 - 1 - 1 - 1 - 6 - 6
                     58: 2 - 2 - 1 - 1 - 2 - 2 - 3 - 3
                     59: 3 - 3 - 1 - 1 - 4 - 4 - 5 - 5