Return to bug_mysql_49406.phpt CVS log

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

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

1.1       misho       1: --TEST--
                      2: MySQL Bug #49406 (Binding params doesn't work when selecting a date inside a CASE-WHEN, http://bugs.mysql.com/bug.php?id=49406)
                      3: --SKIPIF--
                      4: <?php
                      5: require_once('skipif.inc');
                      6: require_once('skipifconnectfailure.inc');
                      7: ?>
                      8: --FILE--
                      9: <?php
                     10:        require_once("connect.inc");
                     11: 
                     12:        if (!($link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)))
                     13:                printf("[001] 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: 
                     16:        $query = "SELECT CASE  WHEN 0 THEN CAST('2009-12-03' AS DATE)  ELSE CAST('2009-12-03' AS DATE) END";
                     17: 
                     18:        if (!$res = $link->query($query))
                     19:                printf("[002] [%d] %s\n", $link->errno, $link->error);
                     20: 
                     21:        if (!$row = $res->fetch_row())
                     22:                printf("[003] No result, [%d] %s\n", $link->errno, $link->error);
                     23: 
                     24:        $res->free();
                     25: 
                     26:        if ($row[0] != '2009-12-03') {
                     27:                printf("[004] Expecting '2009-12-03' got '%s'\n", $row[0]);
                     28:        }
                     29: 
                     30:        if (!$stmt = $link->prepare($query))
                     31:                printf("[005] [%d] %s\n", $link->errno, $link->error);
                     32: 
                     33:        if (!$stmt->execute() || !$stmt->store_result())
                     34:                printf("[006] [%d] %s\n", $stmt->errno, $stmt->error);
                     35: 
                     36: 
                     37:        $datatypes = array(
                     38:                MYSQLI_TYPE_TINY => "TINY",
                     39:                MYSQLI_TYPE_SHORT => "SHORT",
                     40:                MYSQLI_TYPE_LONG => "LONG",
                     41:                MYSQLI_TYPE_FLOAT => "FLOAT",
                     42:                MYSQLI_TYPE_DOUBLE => "DOUBLE",
                     43:                MYSQLI_TYPE_TIMESTAMP => "TIMESTAMP",
                     44:                MYSQLI_TYPE_LONGLONG => "LONGLONG",
                     45:                MYSQLI_TYPE_INT24 => "INT24",
                     46:                MYSQLI_TYPE_DATE => "DATE",
                     47:                MYSQLI_TYPE_TIME => "TIME",
                     48:                MYSQLI_TYPE_DATETIME => "DATETIME",
                     49:                MYSQLI_TYPE_YEAR => "YEAR",
                     50:                MYSQLI_TYPE_ENUM => "ENUM",
                     51:                MYSQLI_TYPE_SET => "SET",
                     52:                MYSQLI_TYPE_TINY_BLOB => "TINYBLOB",
                     53:                MYSQLI_TYPE_MEDIUM_BLOB => "MEDIUMBLOB",
                     54:                MYSQLI_TYPE_LONG_BLOB => "LONGBLOB",
                     55:                MYSQLI_TYPE_BLOB => "BLOB",
                     56:                MYSQLI_TYPE_VAR_STRING => "VAR_STRING",
                     57:                MYSQLI_TYPE_STRING => "STRING",
                     58:                MYSQLI_TYPE_NULL => "NULL",
                     59:                MYSQLI_TYPE_NEWDATE => "NEWDATE",
                     60:                MYSQLI_TYPE_INTERVAL => "INTERVAL",
                     61:                MYSQLI_TYPE_GEOMETRY => "GEOMETRY",
                     62:        );
                     63: 
                     64:        $meta_res = $stmt->result_metadata();
                     65:        for ($field_idx = 0; $field_idx < $meta_res->field_count; $field_idx++) {
                     66:                $field = $meta_res->fetch_field();
                     67:                printf("Field        : %d\n", $field_idx);
                     68:                printf("Name         : %s\n", $field->name);
                     69:                printf("Orgname      : %s\n", $field->orgname);
                     70:                printf("Table        : %s\n", $field->table);
                     71:                printf("Orgtable     : %s\n", $field->orgtable);
                     72:                printf("Maxlength    : %d\n", $field->max_length);
                     73:                printf("Length       : %d\n", $field->length);
                     74:                printf("Charsetnr    : %d\n", $field->charsetnr);
                     75:                printf("Flags        : %d\n", $field->flags);
                     76:                printf("Type         : %d (%s)\n", $field->type, (isset($datatypes[$field->type])) ? $datatypes[$field->type] : 'unknown');
                     77:                printf("Decimals     : %d\n", $field->decimals);
                     78:        }
                     79: 
                     80:        $row_stmt = null;
                     81:        if (!$stmt->bind_result($row_stmt) || !$stmt->fetch())
                     82:                printf("[007] [%d] %s\n", $stmt->errno, $stmt->error);
                     83: 
                     84:        if ($row[0] != $row_stmt) {
                     85:                printf("[008] PS and non-PS results differ, dumping data\n");
                     86:                var_dump($row[0]);
                     87:                var_dump($row_stmt);
                     88:        }
                     89: 
                     90:        $stmt->close();
                     91:        $link->close();
                     92: 
                     93:        echo "done";
                     94: ?>
                     95: --EXPECTF--
                     96: Field        : %s
                     97: Name         : %s
                     98: Orgname      :%s
                     99: Table        :%s
                    100: Orgtable     :%s
                    101: Maxlength    : %d
                    102: Length       : %d
                    103: Charsetnr    : %d
                    104: Flags        : %d
                    105: Type         : %d (%s)
                    106: Decimals     : %d
                    107: done