Return to bug44897.phpt CVS log

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

Annotation of embedaddon/php/ext/mysqli/tests/bug44897.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: Bug #44879 (failed to prepare statement)
                      3: --SKIPIF--
                      4: <?php
                      5: require_once('skipif.inc');
                      6: 
                      7: if (!stristr(mysqli_get_client_info(), 'mysqlnd'))
                      8:        die("skip: only available in mysqlnd");
                      9: 
                     10: require_once('skipifconnectfailure.inc');
                     11: require_once('connect.inc');
                     12: 
                     13: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
                     14:        die(sprintf('skip Cannot connect to MySQL, [%d] %s.', mysqli_connect_errno(), mysqli_connect_error()));
                     15: }
                     16: if (mysqli_get_server_version($link) <= 50000) {
                     17:        die(sprintf('skip Needs MySQL 5.0+, found version %d.', mysqli_get_server_version($link)));
                     18: }
                     19: ?>
                     20: --FILE--
                     21: <?php
                     22:        require_once("table.inc");
                     23: 
                     24:        if (!$link->query('DROP PROCEDURE IF EXISTS p'))
                     25:                printf("[001] [%d] %s\n", $link->errno, $link->error);
                     26: 
                     27:        if (!$link->query('CREATE PROCEDURE p(IN new_id INT, IN new_label CHAR(1)) BEGIN INSERT INTO test(id, label) VALUES (new_id, new_label); SELECT new_label; END;'))
                     28:                printf("[002] [%d] %s\n", $link->errno, $link->error);
                     29: 
                     30:        $new_id = 100;
                     31:        $new_label = 'z';
                     32: 
                     33:        if (!$stmt = $link->prepare('CALL p(?, ?)'))
                     34:                printf("[003] [%d] %s\n", $link->errno, $link->error);
                     35: 
                     36:        if (!$stmt->bind_param('is', $new_id, $new_label) || !$stmt->execute())
                     37:                printf("[004] [%d] %s\n", $stmt->errno, $stmt->error);
                     38: 
                     39:        $out_new_label = null;
                     40:        if (!$stmt->bind_result($out_new_label) || !$stmt->fetch())
                     41:                printf("[005] [%d] %s\n", $stmt->errno, $stmt->error);
                     42: 
                     43:        if ($out_new_label != $new_label)
                     44:                printf("[006] IN value and returned value differ. Expecting %s/%s got %s/%s\n",
                     45:                        $new_label, gettype($new_label), $out_new_label, gettype($out_new_label));
                     46: 
                     47:        $stmt->close();
                     48: 
                     49:        $stmt2 = $link->prepare('SELECT label FROM test WHERE id = ?');
                     50:        if (!is_object($stmt2)) {
                     51: 
                     52:                printf("[007] Failed to create new statement object, [%d] %s\n",
                     53:                        $link->errno, $link->error);
                     54: 
                     55:        } else {
                     56: 
                     57:                if (!$stmt2->bind_param("i", $new_id) || !$stmt2->execute())
                     58:                        printf("[008] [%d] %s\n", $stmt2->errno, $stmt2->error);
                     59: 
                     60:                $out_new_label = null;
                     61:                if (!$stmt2->bind_result($out_new_label) || !$stmt2->fetch())
                     62:                        printf("[009] [%d] %s\n", $stmt2->errno, $stmt2->error);
                     63: 
                     64:                if ($out_new_label != $new_label)
                     65:                        printf("[010] IN value and returned value differ. Expecting %s/%s got %s/%s\n",
                     66:                                $new_label, gettype($new_label), $out_new_label, gettype($out_new_label));
                     67: 
                     68:        }
                     69: 
                     70:        $link->close();
                     71: 
                     72:        print "done!";
                     73: ?>
                     74: --CLEAN--
                     75: <?php
                     76: require_once("connect.inc");
                     77: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
                     78:    printf("[c001] [%d] %s\n", mysqli_connect_errno(), mysqli_connect_error());
                     79: 
                     80: if (!mysqli_query($link, "DROP TABLE IF EXISTS test"))
                     81:        printf("[c002] Cannot drop table, [%d] %s\n", mysqli_errno($link), mysqli_error($link));
                     82: 
                     83: mysqli_query($link, "DROP PROCEDURE IF EXISTS p");
                     84: 
                     85: mysqli_close($link);
                     86: ?>
                     87: 
                     88: --EXPECTF--
                     89: done!