Return to mysqli_stmt_datatype_change.phpt CVS log

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

Annotation of embedaddon/php/ext/mysqli/tests/mysqli_stmt_datatype_change.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: Playing with datatype change between prepare and execute
        !             3: --SKIPIF--
        !             4: <?php
        !             5: require_once('skipif.inc');
        !             6: require_once('skipifemb.inc');
        !             7: require_once('skipifconnectfailure.inc');
        !             8: ?>
        !             9: --FILE--
        !            10: <?php
        !            11:        require_once("connect.inc");
        !            12:        if (!$c1 = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
        !            13:                printf("Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
        !            14:                        $host, $user, $db, $port, $socket);
        !            15:                exit(1);
        !            16:        }
        !            17:        if (!$c2 = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
        !            18:                printf("Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
        !            19:                        $host, $user, $db, $port, $socket);
        !            20:                exit(1);
        !            21:        }
        !            22: 
        !            23:        $c1->query("use $db");
        !            24:        $c2->query("use $db");
        !            25:        $c1->query("drop table if exists type_change");
        !            26:        $c1->query("create table type_change(a int, b char(10)) ENGINE = " . $engine);
        !            27:        $c1->query("insert into type_change values (1, 'one'), (2, 'two')");
        !            28:        $s1 = $c1->prepare("select a from type_change order by a");
        !            29:        var_dump($s1->execute(), $s1->bind_result($col1));
        !            30:        echo "---- Row 1\n";
        !            31:        var_dump($s1->fetch());
        !            32:        var_dump($col1);
        !            33:        echo "---- Row 2\n";
        !            34:        var_dump($s1->fetch());
        !            35:        var_dump($col1);
        !            36:        echo "---- Row 3\n";
        !            37:        var_dump($s1->fetch());
        !            38:        echo "----\n";
        !            39: 
        !            40:        echo "ALTER\n";
        !            41:        var_dump($c2->query("alter table type_change drop a"));
        !            42:        var_dump($s1->execute());
        !            43:        var_dump($c1->error);
        !            44: 
        !            45:        echo "---- Row 1\n";
        !            46:        var_dump($s1->fetch());
        !            47:        var_dump($col1);
        !            48:        echo "---- Row 2\n";
        !            49:        var_dump($s1->fetch());
        !            50:        var_dump($col1);
        !            51:        echo "---- Row 3\n";
        !            52:        var_dump($s1->fetch());
        !            53:        echo "----\n";
        !            54: 
        !            55:        echo "done!";
        !            56: ?>
        !            57: --CLEAN--
        !            58: <?php
        !            59: require_once("connect.inc");
        !            60: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
        !            61:    printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
        !            62: 
        !            63: if (!mysqli_query($link, "DROP TABLE IF EXISTS type_change"))
        !            64:        printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
        !            65: 
        !            66: mysqli_close($link);
        !            67: ?>
        !            68: 
        !            69: --EXPECTF--
        !            70: bool(true)
        !            71: bool(true)
        !            72: ---- Row 1
        !            73: bool(true)
        !            74: int(1)
        !            75: ---- Row 2
        !            76: bool(true)
        !            77: int(2)
        !            78: ---- Row 3
        !            79: NULL
        !            80: ----
        !            81: ALTER
        !            82: bool(true)
        !            83: bool(false)
        !            84: %unicode|string%(34) "Unknown column 'a' in 'field list'"
        !            85: ---- Row 1
        !            86: bool(false)
        !            87: int(2)
        !            88: ---- Row 2
        !            89: bool(false)
        !            90: int(2)
        !            91: ---- Row 3
        !            92: bool(false)
        !            93: ----
        !            94: done!