Return to mysql_info.phpt CVS log

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

Annotation of embedaddon/php/ext/mysql/tests/mysql_info.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: mysql_info()
        !             3: --SKIPIF--
        !             4: <?php
        !             5: require_once('skipif.inc');
        !             6: require_once('skipifconnectfailure.inc');
        !             7: ?>
        !             8: --FILE--
        !             9: <?php
        !            10: include "connect.inc";
        !            11: 
        !            12: if (false !== ($tmp = @mysql_info()))
        !            13:        printf("[001] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
        !            14: 
        !            15: if (NULL !== ($tmp = @mysql_info(NULL)))
        !            16:        printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
        !            17: 
        !            18: require "table.inc";
        !            19: if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (100, 'a')", $link))
        !            20:        printf("[003] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            21: 
        !            22: if (false !== ($tmp = mysql_info($link)))
        !            23:        printf("[004] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
        !            24: 
        !            25: if (!$res = mysql_query("INSERT INTO test(id, label) VALUES (101, 'a'), (102, 'b')", $link))
        !            26:        printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            27: 
        !            28: if (!is_string($tmp = mysql_info($link)) || ('' == $tmp))
        !            29:        printf("[006] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp);
        !            30: 
        !            31: if (!$res = mysql_query('INSERT INTO test(id, label) SELECT id + 200, label FROM test', $link))
        !            32:        printf("[007] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            33: 
        !            34: if (!is_string($tmp = mysql_info($link)) || ('' == $tmp))
        !            35:        printf("[008] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp);
        !            36: 
        !            37: if (!$res = mysql_query('ALTER TABLE test MODIFY label CHAR(2)', $link))
        !            38:        printf("[009] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            39: 
        !            40: if (!is_string($tmp = mysql_info($link)) || ('' == $tmp))
        !            41:        printf("[010] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp);
        !            42: 
        !            43: if (!$res = mysql_query("UPDATE test SET label = 'b' WHERE id >= 100", $link))
        !            44:        printf("[011] [%d] %s\n", mysql_errno($link), mysql_error($link));
        !            45: 
        !            46: if (!is_string($tmp = mysql_info($link)) || ('' == $tmp))
        !            47:        printf("[012] Expecting string/any_non_empty, got %s/%s\n", gettype($tmp), $tmp);
        !            48: 
        !            49: if ((version_compare(PHP_VERSION, '5.9.9', '>') == 1) && !is_unicode($tmp)) {
        !            50:        printf("[013] Expecting Unicode!\n");
        !            51:        var_inspect($info);
        !            52: }
        !            53: 
        !            54: if (!is_string($def_tmp = mysql_info()) || ('' == $def_tmp))
        !            55:        printf("[014] Expecting string/any_non_empty, got %s/%s\n", gettype($def_tmp), $def_tmp);
        !            56: 
        !            57: if ($def_tmp !== $tmp) {
        !            58:        printf("[015] Results differ for default link and specified link, [%d] %s\n",
        !            59:                mysql_errno(), mysql_error());
        !            60:        var_inspect($tmp);
        !            61:        var_inspect($def_tmp);
        !            62: }
        !            63: 
        !            64: // NOTE: no LOAD DATA INFILE test
        !            65: 
        !            66: print "done!";
        !            67: ?>
        !            68: --CLEAN--
        !            69: <?php
        !            70: require_once("clean_table.inc");
        !            71: ?>
        !            72: --EXPECTF--
        !            73: done!