Return to bug_44861.phpt CVS log

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

Annotation of embedaddon/php/ext/pdo/tests/bug_44861.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: PDO Common: Bug #44861 (scrollable cursor don't work with pgsql)
        !             3: --SKIPIF--
        !             4: <?php # vim:ft=php
        !             5: if (!extension_loaded('pdo')) die('skip');
        !             6: $dir = getenv('REDIR_TEST_DIR');
        !             7: if (false == $dir) die('skip no driver');
        !             8: $allowed = array('oci', 'pgsql');
        !             9: $ok = false;
        !            10: foreach ($allowed as $driver) {
        !            11:        if (!strncasecmp(getenv('PDOTEST_DSN'), $driver, strlen($driver))) {
        !            12:                $ok = true;
        !            13:        }
        !            14: }
        !            15: if (!$ok) {
        !            16:        die("skip Scrollable cursors not supported");
        !            17: }
        !            18: require_once $dir . 'pdo_test.inc';
        !            19: PDOTest::skip();
        !            20: ?>
        !            21: --FILE--
        !            22: <?php
        !            23: if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.dirname(__FILE__) . '/../../pdo/tests/');
        !            24: require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc';
        !            25: $db = PDOTest::factory();
        !            26: 
        !            27: $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        !            28: 
        !            29: if ($db->getAttribute(PDO::ATTR_DRIVER_NAME) == 'oci') {
        !            30:        $from = 'FROM DUAL';
        !            31:        $ob = '1';
        !            32: } else {
        !            33:        $from = '';
        !            34:        $ob = 'r';
        !            35: }
        !            36: 
        !            37: $query = "SELECT 'row1' AS r $from UNION SELECT 'row2' $from UNION SELECT 'row3' $from UNION SELECT 'row4' $from ORDER BY $ob";
        !            38: $aParams = array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL);
        !            39: 
        !            40: $res = $db->prepare($query, $aParams);
        !            41: $res->execute();
        !            42: var_dump($res->fetchColumn());
        !            43: var_dump($res->fetchColumn());
        !            44: var_dump($res->fetchColumn());
        !            45: var_dump($res->fetchColumn());
        !            46: var_dump($res->fetchColumn());
        !            47: 
        !            48: var_dump($res->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_ABS, 3));
        !            49: var_dump($res->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_PRIOR));
        !            50: var_dump($res->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_FIRST));
        !            51: var_dump($res->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_LAST));
        !            52: var_dump($res->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_REL, -1));
        !            53: 
        !            54: var_dump($res->fetchAll(PDO::FETCH_ASSOC));
        !            55: 
        !            56: // Test binding params via emulated prepared query
        !            57: $res = $db->prepare("SELECT ? $from", $aParams);
        !            58: $res->execute(array("it's working"));
        !            59: var_dump($res->fetch(PDO::FETCH_NUM));
        !            60: 
        !            61: 
        !            62: // Test bug #48188, trying to execute again
        !            63: $res->execute(array("try again"));
        !            64: var_dump($res->fetchColumn());
        !            65: var_dump($res->fetchColumn());
        !            66: 
        !            67: ?>
        !            68: --EXPECT--
        !            69: string(4) "row1"
        !            70: string(4) "row2"
        !            71: string(4) "row3"
        !            72: string(4) "row4"
        !            73: bool(false)
        !            74: array(1) {
        !            75:   [0]=>
        !            76:   string(4) "row3"
        !            77: }
        !            78: array(1) {
        !            79:   [0]=>
        !            80:   string(4) "row2"
        !            81: }
        !            82: array(1) {
        !            83:   [0]=>
        !            84:   string(4) "row1"
        !            85: }
        !            86: array(1) {
        !            87:   [0]=>
        !            88:   string(4) "row4"
        !            89: }
        !            90: array(1) {
        !            91:   [0]=>
        !            92:   string(4) "row3"
        !            93: }
        !            94: array(1) {
        !            95:   [0]=>
        !            96:   array(1) {
        !            97:     ["r"]=>
        !            98:     string(4) "row4"
        !            99:   }
        !           100: }
        !           101: array(1) {
        !           102:   [0]=>
        !           103:   string(12) "it's working"
        !           104: }
        !           105: string(9) "try again"
        !           106: bool(false)