Return to bug66124.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: Bug #66124 (mysqli under mysqlnd loses precision when bind_param with 'i')
                      3: --SKIPIF--
                      4: <?php
                      5: require_once('skipif.inc');
                      6: require_once('connect.inc');
                      7: require_once('skipifconnectfailure.inc');
                      8: ?>
                      9: --FILE--
                     10: <?php
                     11: $table_drop = "DROP TABLE IF EXISTS `bug66124`";
                     12: $table_create = "CREATE TABLE `bug66124` (
                     13:   `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                     14:   PRIMARY KEY (`id`)
                     15: ) ENGINE=InnoDB DEFAULT CHARSET=utf8";
                     16: 
                     17: $table_insert = "INSERT INTO `bug66124` SET `id`=?";
                     18: $table_select = "SELECT * FROM `bug66124`";
                     19: $table_delete = "DELETE FROM `bug66124`";
                     20: $id = '1311200011005001566';
                     21: 
                     22: 
                     23: require_once('connect.inc');
                     24: 
                     25: if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
                     26:        printf("Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
                     27:                $host, $user, $db, $port, $socket);
                     28:        exit(1);
                     29: }
                     30: 
                     31: $link->query($table_drop);
                     32: $link->query($table_create);
                     33: 
                     34: $stmt = $link->prepare($table_insert);
                     35: if (!$stmt) {
                     36:        printf("Can't prepare\n");
                     37:        exit(1);
                     38: }
                     39: 
                     40: echo "Using 'i':\n";
                     41: $stmt->bind_param('i', $id);
                     42: 
                     43: if ($stmt->execute()){
                     44:     echo "insert id:{$id}=>{$stmt->insert_id}\n";
                     45: } else {
                     46:        printf("Can't execute\n");
                     47:        exit(1);
                     48: }
                     49: 
                     50: 
                     51: $result = $link->query($table_select);
                     52: 
                     53: if ($result){
                     54:     while ($row = $result->fetch_assoc()) {
                     55:         echo "fetch  id:{$row['id']}\n";
                     56:     }
                     57: } else {
                     58:        printf("Can't select\n");
                     59:        exit(1);
                     60: }
                     61: 
                     62: $stmt->close();
                     63: 
                     64: $link->query($table_drop);
                     65: $link->query($table_create);
                     66: 
                     67: 
                     68: $stmt = $link->prepare($table_insert);
                     69: $stmt->bind_param('s', $id);
                     70: 
                     71: echo "Using 's':\n";
                     72: 
                     73: if ($stmt->execute()){
                     74:     echo "insert id:{$id}\n";
                     75: } else{
                     76:        printf("Can't execute\n");
                     77:        exit(1);
                     78: }
                     79: 
                     80: $result = $link->query($table_select);
                     81: 
                     82: if ($result){
                     83:     while ($row = $result->fetch_assoc()) {
                     84:         echo "fetch  id:{$row['id']}\n";
                     85:     }
                     86: } else {
                     87:        printf("Can't select\n");
                     88:        exit(1);
                     89: }
                     90: 
                     91: $link->close();
                     92: ?>
                     93: done
                     94: --EXPECTF--
                     95: Using 'i':
                     96: insert id:1311200011005001566=>1311200011005001566
                     97: fetch  id:1311200011005001566
                     98: Using 's':
                     99: insert id:1311200011005001566
                    100: fetch  id:1311200011005001566
                    101: done