/home/spunkmeyer/src/mysql-5.0.82/tests/mysql_client_test --no-defaults --testcase --user=root --port=9306 --socket=/home/spunkmeyer/src/mysql-5.0.82/mysql-test/var/tmp/master.sock --vardir=/home/spunkmeyer/src/mysql-5.0.82/mysql-test/var ##################################### client_connect ##################################### Establishing a connection to '' ... OK Connected to MySQL server version: 5.0.82-log (50082) Creating a test database 'client_test_db' ... OK ##################################### 1 of (1/1): test_view_sp_list_fields ##################################### ##################################### 2 of (1/1): client_query ##################################### [MySQL-5.0.82-log][1050] Table 't1' already exists [MySQL-5.0.82-log][1062] Duplicate entry '3' for key 1 ##################################### 3 of (1/1): test_prepare_insert_update ##################################### Running query: CREATE TABLE t1 (a INT, b INT, c INT, UNIQUE (A), UNIQUE(B)) total parameters in stmt: `0` (expected: `0`) Running query: INSERT t1 VALUES (1,2,10), (3,4,20) total parameters in stmt: `0` (expected: `0`) Running query: INSERT t1 VALUES (5,6,30), (7,4,40), (8,9,60) ON DUPLICATE KEY UPDATE c=c+100 total parameters in stmt: `0` (expected: `0`) Running query: SELECT * FROM t1 total parameters in stmt: `0` (expected: `0`) Running query: INSERT t1 SET a=5 ON DUPLICATE KEY UPDATE b=0 total parameters in stmt: `0` (expected: `0`) Running query: SELECT * FROM t1 total parameters in stmt: `0` (expected: `0`) Running query: INSERT t1 VALUES (2,1,11), (7,4,40) ON DUPLICATE KEY UPDATE c=c+VALUES(a) total parameters in stmt: `0` (expected: `0`) Executing last statement again Executing last statement again Executing last statement again ##################################### 4 of (1/1): test_fetch_seek ##################################### row 0: 1, venu, 2009-05-28 11:40:23 row 2: 2, mysql, 2009-05-28 11:40:23 row 2: 2, mysql, 2009-05-28 11:40:23 row 0: 1, venu, 2009-05-28 11:40:23 ##################################### 5 of (1/1): test_fetch_nobuffs ##################################### total rows : 1 CURRENT_DATABASE(): client_test_db CURRENT_USER() : root@localhost CURRENT_DATE() : 2009-05-28 CURRENT_TIME() : 11:40:23 total rows : 1 ##################################### 6 of (1/1): test_open_direct ##################################### +------+------+ | id | name | +------+------+ 0 rows returned total affected rows: `1` (expected: `1`) +------+-------+ | id | name | +------+-------+ | 10 | mysql | +------+-------+ 1 row returned total affected rows: `1` (expected: `1`) +------+-------+ | id | name | +------+-------+ | 10 | mysql | | 10 | mysql | +------+-------+ 2 rows returned [MySQL-5.0.82-log][2014] Commands out of sync; you can't run this command now ##################################### 7 of (1/1): test_fetch_null ##################################### SELECT * FROM test_fetch_null +------+--------+-------------+-----------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------+-------+--------+ | col1 | col2 | col3 | col4 | col5 | col6 | col7 | col8 | col9 | col10 | col11 | +------+--------+-------------+-----------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------+-------+--------+ | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 1000 | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 88 | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 389789 | +------+--------+-------------+-----------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------+------------+------+-------+--------+ 3 rows returned data[0] : NULL data[1] : NULL data[2] : NULL data[3] : NULL data[4] : NULL data[5] : NULL data[6] : NULL data[7] : NULL data[8] : NULL data[9] : NULL data[10]: 1000 data[0] : NULL data[1] : NULL data[2] : NULL data[3] : NULL data[4] : NULL data[5] : NULL data[6] : NULL data[7] : NULL data[8] : NULL data[9] : NULL data[10]: 88 data[0] : NULL data[1] : NULL data[2] : NULL data[3] : NULL data[4] : NULL data[5] : NULL data[6] : NULL data[7] : NULL data[8] : NULL data[9] : NULL data[10]: 389789 ##################################### 8 of (1/1): test_null_ps_param_in_result ##################################### total parameters in stmt: `1` (expected: `1`) total parameters in stmt: `1` (expected: `1`) total parameters in stmt: `1` (expected: `1`) ##################################### 9 of (1/1): test_fetch_date ##################################### SELECT * FROM test_bind_result +------------+------------+--------------------------------+--------+--------------------------------+--------------------------------+--------------------------------+ | c1 | c2 | c3 | c4 | c5 | c6 | c7 | +------------+------------+--------------------------------+--------+--------------------------------+--------------------------------+--------------------------------+ | 2002-01-02 | 12:49:00 | 2002-01-02 17:46:59 | 2010 | 2010-07-10 00:00:00 | 0000-00-00 00:00:00 | 1999-12-29 00:00:00 | +------------+------------+--------------------------------+--------+--------------------------------+--------------------------------+--------------------------------+ 1 row returned date : 2002-01-02(10) time : 12:49:00(8) ts : 2002-01-02 17:46:59(19) year : 2010(4) dt : 2010-07-10 00:00:00(19) ts(4) : 0000-00-00 00:00:00(19) ts(6) : 1999-12-29 00:00:00(19) ##################################### 10 of (1/1): test_fetch_str ##################################### total parameters in stmt: `7` (expected: `7`) SELECT * FROM test_bind_fetch +------+------+------+------+------+------+------+ | c1 | c2 | c3 | c4 | c5 | c6 | c7 | +------+------+------+------+------+------+------+ | 12 | 25 | 38 | 51 | 64 | 77 | 90 | | 11 | 24 | 37 | 50 | 63 | 76 | 89 | | 10 | 23 | 36 | 49 | 62 | 75 | 88 | +------+------+------+------+------+------+------+ 3 rows returned tiny : 12(1) short : 25(2) int : 38(4) longlong : 51(8) float : 64.000000(4) double : 77(8) char : 90(2) tiny : 11(1) short : 24(2) int : 37(4) longlong : 50(8) float : 63.000000(4) double : 76(8) char : 89(2) tiny : 10(1) short : 23(2) int : 36(4) longlong : 49(8) float : 62.000000(4) double : 75(8) char : 88(2) ##################################### 11 of (1/1): test_fetch_long ##################################### total parameters in stmt: `7` (expected: `7`) SELECT * FROM test_bind_fetch +-------------+-------------+-------------+-------------+-------------+-------------+-------------+ | c1 | c2 | c3 | c4 | c5 | c6 | c7 | +-------------+-------------+-------------+-------------+-------------+-------------+-------------+ | 13 | 26 | 39 | 52 | 65 | 78 | 91 | | 12 | 25 | 38 | 51 | 64 | 77 | 90 | | 11 | 24 | 37 | 50 | 63 | 76 | 89 | | 10 | 23 | 36 | 49 | 62 | 75 | 88 | +-------------+-------------+-------------+-------------+-------------+-------------+-------------+ 4 rows returned tiny : 13(1) short : 26(2) int : 39(4) longlong : 52(8) float : 65.000000(4) double : 78(8) char : 91(2) tiny : 12(1) short : 25(2) int : 38(4) longlong : 51(8) float : 64.000000(4) double : 77(8) char : 90(2) tiny : 11(1) short : 24(2) int : 37(4) longlong : 50(8) float : 63.000000(4) double : 76(8) char : 89(2) tiny : 10(1) short : 23(2) int : 36(4) longlong : 49(8) float : 62.000000(4) double : 75(8) char : 88(2) ##################################### 12 of (1/1): test_fetch_short ##################################### total parameters in stmt: `7` (expected: `7`) SELECT * FROM test_bind_fetch +--------+--------+--------+--------+--------+--------+--------+ | c1 | c2 | c3 | c4 | c5 | c6 | c7 | +--------+--------+--------+--------+--------+--------+--------+ | 14 | 27 | 40 | 53 | 66 | 79 | 92 | | 13 | 26 | 39 | 52 | 65 | 78 | 91 | | 12 | 25 | 38 | 51 | 64 | 77 | 90 | | 11 | 24 | 37 | 50 | 63 | 76 | 89 | | 10 | 23 | 36 | 49 | 62 | 75 | 88 | +--------+--------+--------+--------+--------+--------+--------+ 5 rows returned tiny : 14(1) short : 27(2) int : 40(4) longlong : 53(8) float : 66.000000(4) double : 79(8) char : 92(2) tiny : 13(1) short : 26(2) int : 39(4) longlong : 52(8) float : 65.000000(4) double : 78(8) char : 91(2) tiny : 12(1) short : 25(2) int : 38(4) longlong : 51(8) float : 64.000000(4) double : 77(8) char : 90(2) tiny : 11(1) short : 24(2) int : 37(4) longlong : 50(8) float : 63.000000(4) double : 76(8) char : 89(2) tiny : 10(1) short : 23(2) int : 36(4) longlong : 49(8) float : 62.000000(4) double : 75(8) char : 88(2) ##################################### 13 of (1/1): test_fetch_tiny ##################################### total parameters in stmt: `7` (expected: `7`) SELECT * FROM test_bind_fetch +------+------+------+------+------+------+------+ | c1 | c2 | c3 | c4 | c5 | c6 | c7 | +------+------+------+------+------+------+------+ | 12 | 25 | 38 | 51 | 64 | 77 | 90 | | 11 | 24 | 37 | 50 | 63 | 76 | 89 | | 10 | 23 | 36 | 49 | 62 | 75 | 88 | +------+------+------+------+------+------+------+ 3 rows returned tiny : 12(1) short : 25(2) int : 38(4) longlong : 51(8) float : 64.000000(4) double : 77(8) char : 90(2) tiny : 11(1) short : 24(2) int : 37(4) longlong : 50(8) float : 63.000000(4) double : 76(8) char : 89(2) tiny : 10(1) short : 23(2) int : 36(4) longlong : 49(8) float : 62.000000(4) double : 75(8) char : 88(2) ##################################### 14 of (1/1): test_fetch_bigint ##################################### total parameters in stmt: `7` (expected: `7`) SELECT * FROM test_bind_fetch +-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+ | c1 | c2 | c3 | c4 | c5 | c6 | c7 | +-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+ | 11 | 24 | 37 | 50 | 63 | 76 | 89 | | 10 | 23 | 36 | 49 | 62 | 75 | 88 | +-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+-----------------------+ 2 rows returned tiny : 11(1) short : 24(2) int : 37(4) longlong : 50(8) float : 63.000000(4) double : 76(8) char : 89(2) tiny : 10(1) short : 23(2) int : 36(4) longlong : 49(8) float : 62.000000(4) double : 75(8) char : 88(2) ##################################### 15 of (1/1): test_fetch_float ##################################### total parameters in stmt: `7` (expected: `7`) SELECT * FROM test_bind_fetch +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | c1 | c2 | c3 | c4 | c5 | c6 | c7 | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 11 | 24 | 37 | 50 | 63 | 76 | 89 | | 10 | 23 | 36 | 49 | 62 | 75 | 88 | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 2 rows returned tiny : 11(1) short : 24(2) int : 37(4) longlong : 50(8) float : 63.000000(4) double : 76(8) char : 89(2) tiny : 10(1) short : 23(2) int : 36(4) longlong : 49(8) float : 62.000000(4) double : 75(8) char : 88(2) ##################################### 16 of (1/1): test_fetch_double ##################################### total parameters in stmt: `7` (expected: `7`) SELECT * FROM test_bind_fetch +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | c1 | c2 | c3 | c4 | c5 | c6 | c7 | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 12.00 | 25 | 38 | 51 | 64 | 77 | 90 | | 11.00 | 24 | 37 | 50 | 63 | 76 | 89 | | 10.00 | 23 | 36 | 49 | 62 | 75 | 88 | +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 3 rows returned tiny : 12(1) short : 25(2) int : 38(4) longlong : 51(8) float : 64.000000(4) double : 77(8) char : 90(2) tiny : 11(1) short : 24(2) int : 37(4) longlong : 50(8) float : 63.000000(4) double : 76(8) char : 89(2) tiny : 10(1) short : 23(2) int : 36(4) longlong : 49(8) float : 62.000000(4) double : 75(8) char : 88(2) ##################################### 17 of (1/1): test_bind_result_ext ##################################### data (tiny) : 19 data (short) : 2999 data (int) : 3999 data (big) : 4999999 data (float) : 2345.600098 data (double) : 5678.895630 data (str) : venu(4) data (bin) : mysql(5) ##################################### 18 of (1/1): test_bind_result_ext1 ##################################### rc=0 data (tiny) : 120(3) data (short) : 2999.000000(4) data (int) : 3999(2) data (big) : 54(1) data (float) : 2(4) data (double) : 58.89(5) data (bin) : 206(4) data (str) : 6.7(8) ##################################### 19 of (1/1): test_select_direct ##################################### +------+------+------+------+------+ | id | id1 | id2 | id3 | name | +------+------+------+------+------+ | 10 | 5 | 2.3 | 4.5 | venu | +------+------+------+------+------+ 1 row returned ##################################### 20 of (1/1): test_select_prepare ##################################### +-------------+------+ | id | name | +-------------+------+ | 10 | venu | +-------------+------+ 1 row returned +------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+ | id | id1 | id2 | id3 | name | +------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+ | 10 | 5 | 2.3 | NULL | venu | +------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+ 1 row returned ##################################### 21 of (1/1): test_select ##################################### total parameters in stmt: `2` (expected: `2`) +-------------+------+ | id | name | +-------------+------+ | 10 | venu | +-------------+------+ 1 row returned ##################################### 22 of (1/1): test_select_version ##################################### total parameters in stmt: `0` (expected: `0`) +------------+ | @@version | +------------+ | 5.0.82-log | +------------+ 1 row returned ##################################### 23 of (1/1): test_ps_conj_select ##################################### total parameters in stmt: `2` (expected: `2`) +-------------+--------+ | id1 | value1 | +-------------+--------+ | 1 | hh | | 2 | hh | | 1 | ii | +-------------+--------+ 3 rows returned ##################################### 24 of (1/1): test_select_show_table ##################################### total parameters in stmt: `0` (expected: `0`) +---------------------------+ | Tables_in_mysql | +---------------------------+ | columns_priv | | db | | func | | help_category | | help_keyword | | help_relation | | help_topic | | host | | proc | | procs_priv | | tables_priv | | time_zone | | time_zone_leap_second | | time_zone_name | | time_zone_transition | | time_zone_transition_type | | user | +---------------------------+ 17 rows returned ##################################### 25 of (1/1): test_func_fields ##################################### table name: `test_dateformat` (expected: `test_dateformat`) table name: `` (expected: ``) field name: `YEAR` (expected: `YEAR`) field org name: `` (expected: ``) ##################################### 26 of (1/1): test_long_data ##################################### total parameters in stmt: `3` (expected: `3`) mysql_stmt_execute() returned 0 +------+--------------------------+------+ | col1 | col2 | col3 | +------+--------------------------+------+ | 999 | Michael 'Monty' Widenius | Venu | +------+--------------------------+------+ 1 row returned SELECT col1 FROM test_long_data LIMIT 1 SELECT col2 FROM test_long_data LIMIT 1 SELECT col3 FROM test_long_data LIMIT 1 ##################################### 27 of (1/1): test_insert ##################################### total parameters in stmt: `2` (expected: `2`) +------+--------+ | col1 | col2 | +------+--------+ | 0 | MySQL0 | | 1 | MySQL1 | | 2 | MySQL2 | +------+--------+ 3 rows returned ##################################### 28 of (1/1): test_set_variable ##################################### max_error_count(default): 64 max_error_count : 31 max_error_count(default): 64 ##################################### 29 of (1/1): test_select_show ##################################### total parameters in stmt: `0` (expected: `0`) +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | id | int(4) | NO | PRI | NULL | | | name | char(2) | YES | | NULL | | +-------+---------+------+-----+---------+-------+ 2 rows returned +--------------------------------------+ | Tables_in_client_test_db (test_show) | +--------------------------------------+ | test_show | +--------------------------------------+ 1 row returned +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | id | int(4) | NO | PRI | NULL | | | name | char(2) | YES | | NULL | | +-------+---------+------+-----+---------+-------+ 2 rows returned +-----------+-----------------------+----------+-----------------------+-------------+-----------+-----------------------+-----------------------+--------+------+------------+---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +-----------+-----------------------+----------+-----------------------+-------------+-----------+-----------------------+-----------------------+--------+------+------------+---------+ | test_show | 0 | PRIMARY | 1 | id | A | 0 | NULL | NULL | | BTREE | | +-----------+-----------------------+----------+-----------------------+-------------+-----------+-----------------------+-----------------------+--------+------+------------+---------+ 1 row returned ##################################### 30 of (1/1): test_prepare_noparam ##################################### total parameters in stmt: `0` (expected: `0`) +------+------+ | col1 | col2 | +------+------+ | 10 | venu | +------+------+ 1 row returned ##################################### 31 of (1/1): test_bind_result ##################################### row 1: 10, venu(4) row 2: 20, MySQL(5) row 3: NULL, monty(5) ##################################### 32 of (1/1): test_prepare_simple ##################################### total parameters in stmt: `2` (expected: `2`) total parameters in stmt: `3` (expected: `3`) total parameters in stmt: `0` (expected: `0`) total parameters in stmt: `1` (expected: `1`) total parameters in stmt: `2` (expected: `2`) ##################################### 33 of (1/1): test_prepare ##################################### total parameters in stmt: `7` (expected: `7`) SELECT * FROM my_prepare +------+-----------+-------------+--------+-----------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | col1 | col2 | col3 | col4 | col5 | col6 | col7 | +------+-----------+-------------+--------+-----------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 0 | MySQL320 | 320 | 1867 | 1000 | 2 | 6578.001 | | 1 | MySQL345 | 345 | 1877 | 1100 | 3 | 6588.091 | | 2 | MySQL370 | 370 | 1887 | 1200 | 4 | 6598.181 | | 3 | MySQL395 | 395 | 1897 | 1300 | 5 | 6608.271 | | 4 | MySQL420 | 420 | 1907 | 1400 | 6 | 6618.361 | | 5 | MySQL445 | 445 | 1917 | 1500 | 7 | 6628.451 | | 6 | MySQL470 | 470 | 1927 | 1600 | 8 | 6638.541 | | 7 | MySQL495 | 495 | 1937 | 1700 | 9 | 6648.631 | | 8 | MySQL520 | 520 | 1947 | 1800 | 10 | 6658.721 | | 9 | MySQL545 | 545 | 1957 | 1900 | 11 | 6668.811 | | 10 | MySQL570 | 570 | 1967 | 2000 | 12 | 6678.901 | | 11 | MySQL595 | 595 | 1977 | 2100 | 13 | 6688.991 | | 12 | MySQL620 | 620 | 1987 | 2200 | 14 | 6699.081 | | 13 | MySQL645 | 645 | 1997 | 2300 | 15 | 6709.171 | | 14 | MySQL670 | 670 | 2007 | 2400 | 16 | 6719.261 | | 15 | MySQL695 | 695 | 2017 | 2500 | 17 | 6729.351 | | 16 | MySQL720 | 720 | 2027 | 2600 | 18 | 6739.441 | | 17 | MySQL745 | 745 | 2037 | 2700 | 19 | 6749.531 | | 18 | MySQL770 | 770 | 2047 | 2800 | 20 | 6759.621 | | 19 | MySQL795 | 795 | 2057 | 2900 | 21 | 6769.711 | | 20 | MySQL820 | 820 | 2067 | 3000 | 22 | 6779.801 | | 21 | MySQL845 | 845 | 2077 | 3100 | 23 | 6789.891 | | 22 | MySQL870 | 870 | 2087 | 3200 | 24 | 6799.981 | | 23 | MySQL895 | 895 | 2097 | 3300 | 25 | 6810.071 | | 24 | MySQL920 | 920 | 2107 | 3400 | 26 | 6820.161 | | 25 | MySQL945 | 945 | 2117 | 3500 | 27 | 6830.251 | | 26 | MySQL970 | 970 | 2127 | 3600 | 28 | 6840.341 | | 27 | MySQL995 | 995 | 2137 | 3700 | 29 | 6850.431 | | 28 | MySQL1020 | 1020 | 2147 | 3800 | 30 | 6860.521 | | 29 | MySQL1045 | 1045 | 2157 | 3900 | 31 | 6870.611 | | 30 | MySQL1070 | 1070 | 2167 | 4000 | 32 | 6880.701 | | 31 | MySQL1095 | 1095 | 2177 | 4100 | 33 | 6890.791 | | 32 | MySQL1120 | 1120 | 2187 | 4200 | 34 | 6900.881 | | 33 | MySQL1145 | 1145 | 2197 | 4300 | 35 | 6910.97100000001 | | 34 | MySQL1170 | 1170 | 2207 | 4400 | 36 | 6921.06100000001 | | 35 | MySQL1195 | 1195 | 2217 | 4500 | 37 | 6931.15100000001 | | 36 | MySQL1220 | 1220 | 2227 | 4600 | 38 | 6941.24100000001 | | 37 | MySQL1245 | 1245 | 2237 | 4700 | 39 | 6951.33100000001 | | 38 | MySQL1270 | 1270 | 2247 | 4800 | 40 | 6961.42100000001 | | 39 | MySQL1295 | 1295 | 2257 | 4900 | 41 | 6971.51100000001 | | 40 | MySQL1320 | 1320 | 2267 | 5000 | 42 | 6981.60100000001 | | 41 | MySQL1345 | 1345 | 2277 | 5100 | 43 | 6991.69100000001 | | 42 | MySQL1370 | 1370 | 2287 | 5200 | 44 | 7001.78100000001 | | 43 | MySQL1395 | 1395 | 2297 | 5300 | 45 | 7011.87100000001 | | 44 | MySQL1420 | 1420 | 2307 | 5400 | 46 | 7021.96100000001 | | 45 | MySQL1445 | 1445 | 2317 | 5500 | 47 | 7032.05100000001 | | 46 | MySQL1470 | 1470 | 2327 | 5600 | 48 | 7042.14100000001 | | 47 | MySQL1495 | 1495 | 2337 | 5700 | 49 | 7052.23100000001 | | 48 | MySQL1520 | 1520 | 2347 | 5800 | 50 | 7062.32100000001 | | 49 | MySQL1545 | 1545 | 2357 | 5900 | 51 | 7072.41100000001 | | 50 | MySQL1570 | 1570 | 2367 | 6000 | 52 | 7082.50100000001 | | 51 | MySQL1595 | 1595 | 2377 | 6100 | 53 | 7092.59100000001 | | 52 | MySQL1620 | 1620 | 2387 | 6200 | 54 | 7102.68100000001 | | 53 | MySQL1645 | 1645 | 2397 | 6300 | 55 | 7112.77100000001 | | 54 | MySQL1670 | 1670 | 2407 | 6400 | 56 | 7122.86100000001 | | 55 | MySQL1695 | 1695 | 2417 | 6500 | 57 | 7132.95100000001 | | 56 | MySQL1720 | 1720 | 2427 | 6600 | 58 | 7143.04100000001 | | 57 | MySQL1745 | 1745 | 2437 | 6700 | 59 | 7153.13100000001 | | 58 | MySQL1770 | 1770 | 2447 | 6800 | 60 | 7163.22100000001 | | 59 | MySQL1795 | 1795 | 2457 | 6900 | 61 | 7173.31100000001 | | 60 | MySQL1820 | 1820 | 2467 | 7000 | 62 | 7183.40100000001 | | 61 | MySQL1845 | 1845 | 2477 | 7100 | 63 | 7193.49100000001 | | 62 | MySQL1870 | 1870 | 2487 | 7200 | 64 | 7203.58100000001 | | 63 | MySQL1895 | 1895 | 2497 | 7300 | 65 | 7213.67100000001 | | 64 | MySQL1920 | 1920 | 2507 | 7400 | 66 | 7223.76100000001 | | 65 | MySQL1945 | 1945 | 2517 | 7500 | 67 | 7233.85100000001 | | 66 | MySQL1970 | 1970 | 2527 | 7600 | 68 | 7243.94100000001 | | 67 | MySQL1995 | 1995 | 2537 | 7700 | 69 | 7254.03100000001 | | 68 | MySQL2020 | 2020 | 2547 | 7800 | 70 | 7264.12100000001 | | 69 | MySQL2045 | 2045 | 2557 | 7900 | 71 | 7274.21100000001 | | 70 | MySQL2070 | 2070 | 2567 | 8000 | 72 | 7284.30100000001 | | 71 | MySQL2095 | 2095 | 2577 | 8100 | 73 | 7294.39100000001 | | 72 | MySQL2120 | 2120 | 2587 | 8200 | 74 | 7304.48100000001 | | 73 | MySQL2145 | 2145 | 2597 | 8300 | 75 | 7314.57100000001 | | 74 | MySQL2170 | 2170 | 2607 | 8400 | 76 | 7324.66100000001 | | 75 | MySQL2195 | 2195 | 2617 | 8500 | 77 | 7334.75100000001 | | 76 | MySQL2220 | 2220 | 2627 | 8600 | 78 | 7344.84100000001 | | 77 | MySQL2245 | 2245 | 2637 | 8700 | 79 | 7354.93100000001 | | 78 | MySQL2270 | 2270 | 2647 | 8800 | 80 | 7365.02100000001 | | 79 | MySQL2295 | 2295 | 2657 | 8900 | 81 | 7375.11100000001 | | 80 | MySQL2320 | 2320 | 2667 | 9000 | 82 | 7385.20100000001 | | 81 | MySQL2345 | 2345 | 2677 | 9100 | 83 | 7395.29100000001 | | 82 | MySQL2370 | 2370 | 2687 | 9200 | 84 | 7405.38100000001 | | 83 | MySQL2395 | 2395 | 2697 | 9300 | 85 | 7415.47100000001 | | 84 | MySQL2420 | 2420 | 2707 | 9400 | 86 | 7425.56100000001 | | 85 | MySQL2445 | 2445 | 2717 | 9500 | 87 | 7435.65100000001 | | 86 | MySQL2470 | 2470 | 2727 | 9600 | 88 | 7445.74100000001 | | 87 | MySQL2495 | 2495 | 2737 | 9700 | 89 | 7455.83100000001 | | 88 | MySQL2520 | 2520 | 2747 | 9800 | 90 | 7465.92100000001 | | 89 | MySQL2545 | 2545 | 2757 | 9900 | 91 | 7476.01100000001 | | 90 | MySQL2570 | 2570 | 2767 | 10000 | 92 | 7486.10100000001 | | 91 | MySQL2595 | 2595 | 2777 | 10100 | 93 | 7496.19100000001 | | 92 | MySQL2620 | 2620 | 2787 | 10200 | 94 | 7506.28100000001 | | 93 | MySQL2645 | 2645 | 2797 | 10300 | 95 | 7516.37100000001 | | 94 | MySQL2670 | 2670 | 2807 | 10400 | 96 | 7526.46100000001 | | 95 | MySQL2695 | 2695 | 2817 | 10500 | 97 | 7536.55100000001 | | 96 | MySQL2720 | 2720 | 2827 | 10600 | 98 | 7546.64100000001 | | 97 | MySQL2745 | 2745 | 2837 | 10700 | 99 | 7556.73100000001 | | 98 | MySQL2770 | 2770 | 2847 | 10800 | 100 | 7566.82100000001 | | 99 | MySQL2795 | 2795 | 2857 | 10900 | 101 | 7576.91100000001 | +------+-----------+-------------+--------+-----------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 100 rows returned tiny : 0 (1) short : 1867 (2) int : 320 (4) big : 1000 (8) float : 2.000000 (4) double : 6578.001000 (8) str : MySQL320 (8) tiny : 1 (1) short : 1877 (2) int : 345 (4) big : 1100 (8) float : 3.000000 (4) double : 6588.091000 (8) str : MySQL345 (8) tiny : 2 (1) short : 1887 (2) int : 370 (4) big : 1200 (8) float : 4.000000 (4) double : 6598.181000 (8) str : MySQL370 (8) tiny : 3 (1) short : 1897 (2) int : 395 (4) big : 1300 (8) float : 5.000000 (4) double : 6608.271000 (8) str : MySQL395 (8) tiny : 4 (1) short : 1907 (2) int : 420 (4) big : 1400 (8) float : 6.000000 (4) double : 6618.361000 (8) str : MySQL420 (8) tiny : 5 (1) short : 1917 (2) int : 445 (4) big : 1500 (8) float : 7.000000 (4) double : 6628.451000 (8) str : MySQL445 (8) tiny : 6 (1) short : 1927 (2) int : 470 (4) big : 1600 (8) float : 8.000000 (4) double : 6638.541000 (8) str : MySQL470 (8) tiny : 7 (1) short : 1937 (2) int : 495 (4) big : 1700 (8) float : 9.000000 (4) double : 6648.631000 (8) str : MySQL495 (8) tiny : 8 (1) short : 1947 (2) int : 520 (4) big : 1800 (8) float : 10.000000 (4) double : 6658.721000 (8) str : MySQL520 (8) tiny : 9 (1) short : 1957 (2) int : 545 (4) big : 1900 (8) float : 11.000000 (4) double : 6668.811000 (8) str : MySQL545 (8) tiny : 10 (1) short : 1967 (2) int : 570 (4) big : 2000 (8) float : 12.000000 (4) double : 6678.901000 (8) str : MySQL570 (8) tiny : 11 (1) short : 1977 (2) int : 595 (4) big : 2100 (8) float : 13.000000 (4) double : 6688.991000 (8) str : MySQL595 (8) tiny : 12 (1) short : 1987 (2) int : 620 (4) big : 2200 (8) float : 14.000000 (4) double : 6699.081000 (8) str : MySQL620 (8) tiny : 13 (1) short : 1997 (2) int : 645 (4) big : 2300 (8) float : 15.000000 (4) double : 6709.171000 (8) str : MySQL645 (8) tiny : 14 (1) short : 2007 (2) int : 670 (4) big : 2400 (8) float : 16.000000 (4) double : 6719.261000 (8) str : MySQL670 (8) tiny : 15 (1) short : 2017 (2) int : 695 (4) big : 2500 (8) float : 17.000000 (4) double : 6729.351000 (8) str : MySQL695 (8) tiny : 16 (1) short : 2027 (2) int : 720 (4) big : 2600 (8) float : 18.000000 (4) double : 6739.441000 (8) str : MySQL720 (8) tiny : 17 (1) short : 2037 (2) int : 745 (4) big : 2700 (8) float : 19.000000 (4) double : 6749.531000 (8) str : MySQL745 (8) tiny : 18 (1) short : 2047 (2) int : 770 (4) big : 2800 (8) float : 20.000000 (4) double : 6759.621000 (8) str : MySQL770 (8) tiny : 19 (1) short : 2057 (2) int : 795 (4) big : 2900 (8) float : 21.000000 (4) double : 6769.711000 (8) str : MySQL795 (8) tiny : 20 (1) short : 2067 (2) int : 820 (4) big : 3000 (8) float : 22.000000 (4) double : 6779.801000 (8) str : MySQL820 (8) tiny : 21 (1) short : 2077 (2) int : 845 (4) big : 3100 (8) float : 23.000000 (4) double : 6789.891000 (8) str : MySQL845 (8) tiny : 22 (1) short : 2087 (2) int : 870 (4) big : 3200 (8) float : 24.000000 (4) double : 6799.981000 (8) str : MySQL870 (8) tiny : 23 (1) short : 2097 (2) int : 895 (4) big : 3300 (8) float : 25.000000 (4) double : 6810.071000 (8) str : MySQL895 (8) tiny : 24 (1) short : 2107 (2) int : 920 (4) big : 3400 (8) float : 26.000000 (4) double : 6820.161000 (8) str : MySQL920 (8) tiny : 25 (1) short : 2117 (2) int : 945 (4) big : 3500 (8) float : 27.000000 (4) double : 6830.251000 (8) str : MySQL945 (8) tiny : 26 (1) short : 2127 (2) int : 970 (4) big : 3600 (8) float : 28.000000 (4) double : 6840.341000 (8) str : MySQL970 (8) tiny : 27 (1) short : 2137 (2) int : 995 (4) big : 3700 (8) float : 29.000000 (4) double : 6850.431000 (8) str : MySQL995 (8) tiny : 28 (1) short : 2147 (2) int : 1020 (4) big : 3800 (8) float : 30.000000 (4) double : 6860.521000 (8) str : MySQL1020 (9) tiny : 29 (1) short : 2157 (2) int : 1045 (4) big : 3900 (8) float : 31.000000 (4) double : 6870.611000 (8) str : MySQL1045 (9) tiny : 30 (1) short : 2167 (2) int : 1070 (4) big : 4000 (8) float : 32.000000 (4) double : 6880.701000 (8) str : MySQL1070 (9) tiny : 31 (1) short : 2177 (2) int : 1095 (4) big : 4100 (8) float : 33.000000 (4) double : 6890.791000 (8) str : MySQL1095 (9) tiny : 32 (1) short : 2187 (2) int : 1120 (4) big : 4200 (8) float : 34.000000 (4) double : 6900.881000 (8) str : MySQL1120 (9) tiny : 33 (1) short : 2197 (2) int : 1145 (4) big : 4300 (8) float : 35.000000 (4) double : 6910.971000 (8) str : MySQL1145 (9) tiny : 34 (1) short : 2207 (2) int : 1170 (4) big : 4400 (8) float : 36.000000 (4) double : 6921.061000 (8) str : MySQL1170 (9) tiny : 35 (1) short : 2217 (2) int : 1195 (4) big : 4500 (8) float : 37.000000 (4) double : 6931.151000 (8) str : MySQL1195 (9) tiny : 36 (1) short : 2227 (2) int : 1220 (4) big : 4600 (8) float : 38.000000 (4) double : 6941.241000 (8) str : MySQL1220 (9) tiny : 37 (1) short : 2237 (2) int : 1245 (4) big : 4700 (8) float : 39.000000 (4) double : 6951.331000 (8) str : MySQL1245 (9) tiny : 38 (1) short : 2247 (2) int : 1270 (4) big : 4800 (8) float : 40.000000 (4) double : 6961.421000 (8) str : MySQL1270 (9) tiny : 39 (1) short : 2257 (2) int : 1295 (4) big : 4900 (8) float : 41.000000 (4) double : 6971.511000 (8) str : MySQL1295 (9) tiny : 40 (1) short : 2267 (2) int : 1320 (4) big : 5000 (8) float : 42.000000 (4) double : 6981.601000 (8) str : MySQL1320 (9) tiny : 41 (1) short : 2277 (2) int : 1345 (4) big : 5100 (8) float : 43.000000 (4) double : 6991.691000 (8) str : MySQL1345 (9) tiny : 42 (1) short : 2287 (2) int : 1370 (4) big : 5200 (8) float : 44.000000 (4) double : 7001.781000 (8) str : MySQL1370 (9) tiny : 43 (1) short : 2297 (2) int : 1395 (4) big : 5300 (8) float : 45.000000 (4) double : 7011.871000 (8) str : MySQL1395 (9) tiny : 44 (1) short : 2307 (2) int : 1420 (4) big : 5400 (8) float : 46.000000 (4) double : 7021.961000 (8) str : MySQL1420 (9) tiny : 45 (1) short : 2317 (2) int : 1445 (4) big : 5500 (8) float : 47.000000 (4) double : 7032.051000 (8) str : MySQL1445 (9) tiny : 46 (1) short : 2327 (2) int : 1470 (4) big : 5600 (8) float : 48.000000 (4) double : 7042.141000 (8) str : MySQL1470 (9) tiny : 47 (1) short : 2337 (2) int : 1495 (4) big : 5700 (8) float : 49.000000 (4) double : 7052.231000 (8) str : MySQL1495 (9) tiny : 48 (1) short : 2347 (2) int : 1520 (4) big : 5800 (8) float : 50.000000 (4) double : 7062.321000 (8) str : MySQL1520 (9) tiny : 49 (1) short : 2357 (2) int : 1545 (4) big : 5900 (8) float : 51.000000 (4) double : 7072.411000 (8) str : MySQL1545 (9) tiny : 50 (1) short : 2367 (2) int : 1570 (4) big : 6000 (8) float : 52.000000 (4) double : 7082.501000 (8) str : MySQL1570 (9) tiny : 51 (1) short : 2377 (2) int : 1595 (4) big : 6100 (8) float : 53.000000 (4) double : 7092.591000 (8) str : MySQL1595 (9) tiny : 52 (1) short : 2387 (2) int : 1620 (4) big : 6200 (8) float : 54.000000 (4) double : 7102.681000 (8) str : MySQL1620 (9) tiny : 53 (1) short : 2397 (2) int : 1645 (4) big : 6300 (8) float : 55.000000 (4) double : 7112.771000 (8) str : MySQL1645 (9) tiny : 54 (1) short : 2407 (2) int : 1670 (4) big : 6400 (8) float : 56.000000 (4) double : 7122.861000 (8) str : MySQL1670 (9) tiny : 55 (1) short : 2417 (2) int : 1695 (4) big : 6500 (8) float : 57.000000 (4) double : 7132.951000 (8) str : MySQL1695 (9) tiny : 56 (1) short : 2427 (2) int : 1720 (4) big : 6600 (8) float : 58.000000 (4) double : 7143.041000 (8) str : MySQL1720 (9) tiny : 57 (1) short : 2437 (2) int : 1745 (4) big : 6700 (8) float : 59.000000 (4) double : 7153.131000 (8) str : MySQL1745 (9) tiny : 58 (1) short : 2447 (2) int : 1770 (4) big : 6800 (8) float : 60.000000 (4) double : 7163.221000 (8) str : MySQL1770 (9) tiny : 59 (1) short : 2457 (2) int : 1795 (4) big : 6900 (8) float : 61.000000 (4) double : 7173.311000 (8) str : MySQL1795 (9) tiny : 60 (1) short : 2467 (2) int : 1820 (4) big : 7000 (8) float : 62.000000 (4) double : 7183.401000 (8) str : MySQL1820 (9) tiny : 61 (1) short : 2477 (2) int : 1845 (4) big : 7100 (8) float : 63.000000 (4) double : 7193.491000 (8) str : MySQL1845 (9) tiny : 62 (1) short : 2487 (2) int : 1870 (4) big : 7200 (8) float : 64.000000 (4) double : 7203.581000 (8) str : MySQL1870 (9) tiny : 63 (1) short : 2497 (2) int : 1895 (4) big : 7300 (8) float : 65.000000 (4) double : 7213.671000 (8) str : MySQL1895 (9) tiny : 64 (1) short : 2507 (2) int : 1920 (4) big : 7400 (8) float : 66.000000 (4) double : 7223.761000 (8) str : MySQL1920 (9) tiny : 65 (1) short : 2517 (2) int : 1945 (4) big : 7500 (8) float : 67.000000 (4) double : 7233.851000 (8) str : MySQL1945 (9) tiny : 66 (1) short : 2527 (2) int : 1970 (4) big : 7600 (8) float : 68.000000 (4) double : 7243.941000 (8) str : MySQL1970 (9) tiny : 67 (1) short : 2537 (2) int : 1995 (4) big : 7700 (8) float : 69.000000 (4) double : 7254.031000 (8) str : MySQL1995 (9) tiny : 68 (1) short : 2547 (2) int : 2020 (4) big : 7800 (8) float : 70.000000 (4) double : 7264.121000 (8) str : MySQL2020 (9) tiny : 69 (1) short : 2557 (2) int : 2045 (4) big : 7900 (8) float : 71.000000 (4) double : 7274.211000 (8) str : MySQL2045 (9) tiny : 70 (1) short : 2567 (2) int : 2070 (4) big : 8000 (8) float : 72.000000 (4) double : 7284.301000 (8) str : MySQL2070 (9) tiny : 71 (1) short : 2577 (2) int : 2095 (4) big : 8100 (8) float : 73.000000 (4) double : 7294.391000 (8) str : MySQL2095 (9) tiny : 72 (1) short : 2587 (2) int : 2120 (4) big : 8200 (8) float : 74.000000 (4) double : 7304.481000 (8) str : MySQL2120 (9) tiny : 73 (1) short : 2597 (2) int : 2145 (4) big : 8300 (8) float : 75.000000 (4) double : 7314.571000 (8) str : MySQL2145 (9) tiny : 74 (1) short : 2607 (2) int : 2170 (4) big : 8400 (8) float : 76.000000 (4) double : 7324.661000 (8) str : MySQL2170 (9) tiny : 75 (1) short : 2617 (2) int : 2195 (4) big : 8500 (8) float : 77.000000 (4) double : 7334.751000 (8) str : MySQL2195 (9) tiny : 76 (1) short : 2627 (2) int : 2220 (4) big : 8600 (8) float : 78.000000 (4) double : 7344.841000 (8) str : MySQL2220 (9) tiny : 77 (1) short : 2637 (2) int : 2245 (4) big : 8700 (8) float : 79.000000 (4) double : 7354.931000 (8) str : MySQL2245 (9) tiny : 78 (1) short : 2647 (2) int : 2270 (4) big : 8800 (8) float : 80.000000 (4) double : 7365.021000 (8) str : MySQL2270 (9) tiny : 79 (1) short : 2657 (2) int : 2295 (4) big : 8900 (8) float : 81.000000 (4) double : 7375.111000 (8) str : MySQL2295 (9) tiny : 80 (1) short : 2667 (2) int : 2320 (4) big : 9000 (8) float : 82.000000 (4) double : 7385.201000 (8) str : MySQL2320 (9) tiny : 81 (1) short : 2677 (2) int : 2345 (4) big : 9100 (8) float : 83.000000 (4) double : 7395.291000 (8) str : MySQL2345 (9) tiny : 82 (1) short : 2687 (2) int : 2370 (4) big : 9200 (8) float : 84.000000 (4) double : 7405.381000 (8) str : MySQL2370 (9) tiny : 83 (1) short : 2697 (2) int : 2395 (4) big : 9300 (8) float : 85.000000 (4) double : 7415.471000 (8) str : MySQL2395 (9) tiny : 84 (1) short : 2707 (2) int : 2420 (4) big : 9400 (8) float : 86.000000 (4) double : 7425.561000 (8) str : MySQL2420 (9) tiny : 85 (1) short : 2717 (2) int : 2445 (4) big : 9500 (8) float : 87.000000 (4) double : 7435.651000 (8) str : MySQL2445 (9) tiny : 86 (1) short : 2727 (2) int : 2470 (4) big : 9600 (8) float : 88.000000 (4) double : 7445.741000 (8) str : MySQL2470 (9) tiny : 87 (1) short : 2737 (2) int : 2495 (4) big : 9700 (8) float : 89.000000 (4) double : 7455.831000 (8) str : MySQL2495 (9) tiny : 88 (1) short : 2747 (2) int : 2520 (4) big : 9800 (8) float : 90.000000 (4) double : 7465.921000 (8) str : MySQL2520 (9) tiny : 89 (1) short : 2757 (2) int : 2545 (4) big : 9900 (8) float : 91.000000 (4) double : 7476.011000 (8) str : MySQL2545 (9) tiny : 90 (1) short : 2767 (2) int : 2570 (4) big : 10000 (8) float : 92.000000 (4) double : 7486.101000 (8) str : MySQL2570 (9) tiny : 91 (1) short : 2777 (2) int : 2595 (4) big : 10100 (8) float : 93.000000 (4) double : 7496.191000 (8) str : MySQL2595 (9) tiny : 92 (1) short : 2787 (2) int : 2620 (4) big : 10200 (8) float : 94.000000 (4) double : 7506.281000 (8) str : MySQL2620 (9) tiny : 93 (1) short : 2797 (2) int : 2645 (4) big : 10300 (8) float : 95.000000 (4) double : 7516.371000 (8) str : MySQL2645 (9) tiny : 94 (1) short : 2807 (2) int : 2670 (4) big : 10400 (8) float : 96.000000 (4) double : 7526.461000 (8) str : MySQL2670 (9) tiny : 95 (1) short : 2817 (2) int : 2695 (4) big : 10500 (8) float : 97.000000 (4) double : 7536.551000 (8) str : MySQL2695 (9) tiny : 96 (1) short : 2827 (2) int : 2720 (4) big : 10600 (8) float : 98.000000 (4) double : 7546.641000 (8) str : MySQL2720 (9) tiny : 97 (1) short : 2837 (2) int : 2745 (4) big : 10700 (8) float : 99.000000 (4) double : 7556.731000 (8) str : MySQL2745 (9) tiny : 98 (1) short : 2847 (2) int : 2770 (4) big : 10800 (8) float : 100.000000 (4) double : 7566.821000 (8) str : MySQL2770 (9) tiny : 99 (1) short : 2857 (2) int : 2795 (4) big : 10900 (8) float : 101.000000 (4) double : 7576.911000 (8) str : MySQL2795 (9) ##################################### 34 of (1/1): test_null ##################################### total parameters in stmt: `2` (expected: `2`) SELECT * FROM test_null +-------------+------+ | col1 | col2 | +-------------+------+ | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | | NULL | NULL | +-------------+------+ 20 rows returned ##################################### 35 of (1/1): test_debug_example ##################################### +----+------+------+ | id | name | xxx | +----+------+------+ | 1 | mysql | NULL | +----+------+------+ 1 row returned ##################################### 36 of (1/1): test_update ##################################### total parameters in stmt: `2` (expected: `2`) total affected rows: `1` (expected: `1`) total parameters in stmt: `2` (expected: `2`) total affected rows: `1` (expected: `1`) +------+--------------+------+ | col1 | col2 | col3 | +------+--------------+------+ | 1 | updated-data | 100 | +------+--------------+------+ 1 row returned ##################################### 37 of (1/1): test_simple_update ##################################### total affected rows: `1` (expected: `1`) total parameters in stmt: `2` (expected: `2`) total affected rows: `1` (expected: `1`) +------+--------------+------+ | col1 | col2 | col3 | +------+--------------+------+ | 1 | updated-data | 100 | +------+--------------+------+ 1 row returned ##################################### 38 of (1/1): test_simple_delete ##################################### total affected rows: `1` (expected: `1`) total parameters in stmt: `2` (expected: `2`) total affected rows: `1` (expected: `1`) +------+------+------+ | col1 | col2 | col3 | +------+------+------+ 0 rows returned ##################################### 39 of (1/1): test_double_compare ##################################### total parameters in stmt: `3` (expected: `3`) total affected rows: `0` (expected: `0`) +------+------+------+ | col1 | col2 | col3 | +------+------+------+ | 1 | 10.2 | 34.5 | +------+------+------+ 1 row returned ##################################### 40 of (1/1): client_store_result ##################################### +-----+--------+--------+ | id1 | value2 | value1 | +-----+--------+--------+ | 1 | hh | hh | | 2 | hh | hh | | 1 | ii | ii | | 2 | ii | ii | +-----+--------+--------+ 4 rows returned ##################################### 41 of (1/1): client_use_result ##################################### +-----+--------+--------+ | id1 | value2 | value1 | +-----+--------+--------+ | 1 | hh | hh | | 2 | hh | hh | | 1 | ii | ii | | 2 | ii | ii | +-----+--------+--------+ 4 rows returned ##################################### 42 of (1/1): test_tran_bdb ##################################### +------+-------+ | col1 | col2 | +------+-------+ | 20 | mysql | +------+-------+ 1 row returned ##################################### 43 of (1/1): test_tran_innodb ##################################### +------+------+ | col1 | col2 | +------+------+ | 10 | venu | +------+------+ 1 row returned ##################################### 44 of (1/1): test_prepare_ext ##################################### total parameters in stmt: `6` (expected: `6`) +------+--------+-----------+-------------+-------------+-----------------------+ | c1 | c2 | c3 | c4 | c5 | c6 | +------+--------+-----------+-------------+-------------+-----------------------+ | 1 | 10 | 0 | 0 | 0 | 20 | | 2 | 11 | 1 | 1 | 1 | 21 | | 3 | 12 | 2 | 2 | 2 | 22 | | 4 | 13 | 3 | 3 | 3 | 23 | | 5 | 14 | 4 | 4 | 4 | 24 | | 6 | 15 | 5 | 5 | 5 | 25 | | 7 | 16 | 6 | 6 | 6 | 26 | | 8 | 17 | 7 | 7 | 7 | 27 | | 9 | 18 | 8 | 8 | 8 | 28 | | 10 | 19 | 9 | 9 | 9 | 29 | +------+--------+-----------+-------------+-------------+-----------------------+ 10 rows returned ##################################### 45 of (1/1): test_prepare_syntax ##################################### ##################################### 46 of (1/1): test_field_names ##################################### 0, 14, 247 +----------+ | id-alias | +----------+ 0 rows returned +----------+------+ | id-alias | name | +----------+------+ 0 rows returned ##################################### 47 of (1/1): test_field_flags ##################################### field:0 NOT_NULL_FLAG PRI_KEY_FLAG AUTO_INCREMENT_FLAG field:1 NOT_NULL_FLAG field:2 UNIQUE_KEY_FLAG field:3 MULTIPLE_KEY_FLAG field:4 NOT_NULL_FLAG field:5 ##################################### 48 of (1/1): test_long_data_str ##################################### total parameters in stmt: `2` (expected: `2`) mysql_stmt_execute() returned 0 +-----------------+----------------------+ | LENGTH(longstr) | longstr | +-----------------+----------------------+ | 20 | MySQLMySQLMySQLMySQL | +-----------------+----------------------+ 1 row returned SELECT LENGTH(longstr) FROM test_long_data_str LIMIT 1 SELECT longstr FROM test_long_data_str LIMIT 1 ##################################### 49 of (1/1): test_long_data_str1 ##################################### total parameters in stmt: `2` (expected: `2`) mysql_stmt_execute() returned 0 +-----------------+--------------------------+-------------+--------+ | LENGTH(longstr) | longstr | LENGTH(blb) | blb | +-----------------+--------------------------+-------------+--------+ | 24 | MySQL ABMySQL ABMySQL AB | 6 | MyMyMy | +-----------------+--------------------------+-------------+--------+ 1 row returned SELECT length(longstr) FROM test_long_data_str LIMIT 1 SELECT length(blb) FROM test_long_data_str LIMIT 1 total parameters in stmt: `0` (expected: `0`) ##################################### 50 of (1/1): test_long_data_bin ##################################### total parameters in stmt: `2` (expected: `2`) mysql_stmt_execute() returned 0 +-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | LENGTH(longbin) | longbin | +-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 400 | MySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQMySQ | +-----------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row returned ##################################### 51 of (1/1): test_warnings ##################################### total warnings: 1 +-------+------+---------------------------------+ | Level | Code | Message | +-------+------+---------------------------------+ | Note | 1051 | Unknown table 'test_non_exists' | +-------+------+---------------------------------+ 1 row returned ##################################### 52 of (1/1): test_errors ##################################### [MySQL-5.0.82-log][1051] Unknown table 'test_non_exists' +-------+------+---------+ | Level | Code | Message | +-------+------+---------+ 0 rows returned ##################################### 53 of (1/1): test_prepare_resultset ##################################### total parameters in stmt: `0` (expected: `0`) +------+------+-------+ | id | name | extra | +------+------+-------+ ##################################### 54 of (1/1): test_stmt_close ##################################### Establishing a test connection ... OK total parameters in stmt: `0` (expected: `0`) total parameters in stmt: `1` (expected: `1`) total parameters in stmt: `2` (expected: `2`) total parameters in stmt: `1` (expected: `1`) mysql_close_stmt(1) returned: 0 total affected rows: `1` (expected: `1`) mysql_close_stmt(x) returned: 0 +------+ | id | +------+ | 100 | +------+ 1 row returned ##################################### 55 of (1/1): test_prepare_field_result ##################################### total parameters in stmt: `1` (expected: `1`) +-------+-------+------+------+--------+ | int_c | var_c | date | ts_c | char_c | +-------+-------+------+------+--------+ field attributes: field[0]: name :`int_c` (expected: `int_c`) org_name :`int_c` (expected: `int_c`) type :`3` (expected: `3`) table :`t1` (expected: `t1`) org_table:`test_prepare_field_result` (expected: `test_prepare_field_result`) database :`client_test_db` (expected: `client_test_db`) length :`11` (expected: `11`) maxlength:`5` charsetnr:`63` default :`(null)` (expected: `(null)`) field[1]: name :`var_c` (expected: `var_c`) org_name :`var_c` (expected: `var_c`) type :`253` (expected: `253`) table :`t1` (expected: `t1`) org_table:`test_prepare_field_result` (expected: `test_prepare_field_result`) database :`client_test_db` (expected: `client_test_db`) length :`50` (expected: `50`) maxlength:`5` charsetnr:`8` default :`(null)` (expected: `(null)`) field[2]: name :`date` (expected: `date`) org_name :`date_c` (expected: `date_c`) type :`10` (expected: `10`) table :`t1` (expected: `t1`) org_table:`test_prepare_field_result` (expected: `test_prepare_field_result`) database :`client_test_db` (expected: `client_test_db`) length :`10` (expected: `10`) maxlength:`4` charsetnr:`63` default :`(null)` (expected: `(null)`) field[3]: name :`ts_c` (expected: `ts_c`) org_name :`ts_c` (expected: `ts_c`) type :`7` (expected: `7`) table :`t1` (expected: `t1`) org_table:`test_prepare_field_result` (expected: `test_prepare_field_result`) database :`client_test_db` (expected: `client_test_db`) length :`19` (expected: `19`) maxlength:`4` charsetnr:`63` default :`(null)` (expected: `(null)`) field[4]: name :`char_c` (expected: `char_c`) org_name :`char_c` (expected: `char_c`) type :`254` (expected: `254`) table :`t1` (expected: `t1`) org_table:`test_prepare_field_result` (expected: `test_prepare_field_result`) database :`client_test_db` (expected: `client_test_db`) length :`4` (expected: `4`) maxlength:`6` charsetnr:`8` default :`(null)` (expected: `(null)`) total fields in the result set: `5` (expected: `5`) ##################################### 56 of (1/1): test_multi_stmt ##################################### total parameters in stmt: `1` (expected: `1`) int_data: 10(4) str_data: mysql(5) total parameters in stmt: `2` (expected: `2`) total affected rows: `1` (expected: `1`) int_data: 10(4) str_data: updated(7) total affected rows: `1` (expected: `1`) SELECT * FROM test_multi_table +-------------+------+ | id | name | +-------------+------+ 0 rows returned ##################################### 57 of (1/1): test_multi_statements ##################################### [MySQL-5.0.82-log][1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE test_multi_tab(id int, name char(20));INSERT INTO test_multi_tab(id' at line 1 Query 0: OK, 0 row(s) affected, 1 warning(s) Query 1: OK, 0 row(s) affected, 0 warning(s) Query 2: OK, 2 row(s) affected, 0 warning(s) Query 3: OK, 1 row(s) affected, 0 warning(s) Query 4: +------+--------------+ | id | name | +------+--------------+ | 10 | NULL | | 20 | NULL | | 20 | insert;comma | +------+--------------+ 3 rows returned Query 5: OK, 2 row(s) affected, 0 warning(s) Query 6: OK, 2 row(s) affected, 0 warning(s) Query 7: +------+------+ | id | name | +------+------+ | 10 | NULL | +------+------+ 1 row returned Query 8: OK, 1 row(s) affected, 0 warning(s) Query 9: +------+------+ | id | name | +------+------+ 0 rows returned Query 10: OK, 0 row(s) affected, 0 warning(s) Query 11: +---+ | 1 | +---+ | 1 | +---+ 1 row returned Query 12: OK, 0 row(s) affected, 1 warning(s) +-------+ | 1+1+1 | +-------+ | 3 | +-------+ 1 row returned ##################################### 58 of (1/1): test_prepare_multi_statements ##################################### ##################################### 59 of (1/1): test_store_result ##################################### row 1: 10, venu(4) row 2: 20, mysql(5) row 3: NULL, monty(5) row 1: 10, venu(4) row 2: 20, mysql(5) row 3: NULL, monty(5) ##################################### 60 of (1/1): test_store_result1 ##################################### total rows: 3 total rows: 3 ##################################### 61 of (1/1): test_store_result2 ##################################### row 1: 10 row 1: 20 ##################################### 62 of (1/1): test_subselect ##################################### total affected rows: `1` (expected: `1`) total affected rows: `0` (expected: `0`) SELECT * FROM test_sub2 +-------------+-------------+ | id | id1 | +-------------+-------------+ | 1 | 7 | | 2 | 7 | | 2 | NULL | +-------------+-------------+ 3 rows returned SELECT ROW(1, 7) IN (select id, id1 from test_sub2 WHERE id1= 8) +-----------------------------------------------------------+ | ROW(1, 7) IN (select id, id1 from test_sub2 WHERE id1= 8) | +-----------------------------------------------------------+ | 0 | +-----------------------------------------------------------+ 1 row returned SELECT ROW(1, 7) IN (select id, id1 from test_sub2 WHERE id1= 7) +-----------------------------------------------------------+ | ROW(1, 7) IN (select id, id1 from test_sub2 WHERE id1= 7) | +-----------------------------------------------------------+ | 1 | +-----------------------------------------------------------+ 1 row returned row 1: 1 row 1: 0 ##################################### 63 of (1/1): test_date ##################################### total parameters in stmt: `4` (expected: `4`) SELECT * FROM test_date +--------------------------------+------------+--------------------------------+------------+ | c1 | c2 | c3 | c4 | +--------------------------------+------------+--------------------------------+------------+ | 2000-01-10 11:16:20 | 11:16:20 | 2000-01-10 11:16:20 | 2000-01-10 | | 2001-02-11 12:17:21 | 12:17:21 | 2001-02-11 12:17:21 | 2001-02-11 | | 2002-03-12 13:18:22 | 13:18:22 | 2002-03-12 13:18:22 | 2002-03-12 | | 2003-04-13 14:19:23 | 14:19:23 | 2003-04-13 14:19:23 | 2003-04-13 | | 2004-05-14 15:20:24 | 15:20:24 | 2004-05-14 15:20:24 | 2004-05-14 | +--------------------------------+------------+--------------------------------+------------+ 5 rows returned time[0]: 2000-01-10 11:16:20.00 time[1]: 00-00-00 11:16:20.00 time[2]: 2000-01-10 11:16:20.00 time[3]: 2000-01-10 00:00:00.00 time[0]: 2001-02-11 12:17:21.00 time[1]: 00-00-00 12:17:21.00 time[2]: 2001-02-11 12:17:21.00 time[3]: 2001-02-11 00:00:00.00 time[0]: 2002-03-12 13:18:22.00 time[1]: 00-00-00 13:18:22.00 time[2]: 2002-03-12 13:18:22.00 time[3]: 2002-03-12 00:00:00.00 time[0]: 2003-04-13 14:19:23.00 time[1]: 00-00-00 14:19:23.00 time[2]: 2003-04-13 14:19:23.00 time[3]: 2003-04-13 00:00:00.00 time[0]: 2004-05-14 15:20:24.00 time[1]: 00-00-00 15:20:24.00 time[2]: 2004-05-14 15:20:24.00 time[3]: 2004-05-14 00:00:00.00 ##################################### 64 of (1/1): test_date_date ##################################### total parameters in stmt: `4` (expected: `4`) SELECT * FROM test_date +------------+------------+------------+------------+ | c1 | c2 | c3 | c4 | +------------+------------+------------+------------+ | 2000-01-10 | 0000-00-00 | 2000-01-10 | 2000-01-10 | | 2001-02-11 | 0000-00-00 | 2001-02-11 | 2001-02-11 | | 2002-03-12 | 0000-00-00 | 2002-03-12 | 2002-03-12 | +------------+------------+------------+------------+ 3 rows returned time[0]: 2000-01-10 00:00:00.00 time[1]: 00-00-00 00:00:00.00 time[2]: 2000-01-10 00:00:00.00 time[3]: 2000-01-10 00:00:00.00 time[0]: 2001-02-11 00:00:00.00 time[1]: 00-00-00 00:00:00.00 time[2]: 2001-02-11 00:00:00.00 time[3]: 2001-02-11 00:00:00.00 time[0]: 2002-03-12 00:00:00.00 time[1]: 00-00-00 00:00:00.00 time[2]: 2002-03-12 00:00:00.00 time[3]: 2002-03-12 00:00:00.00 ##################################### 65 of (1/1): test_date_time ##################################### total parameters in stmt: `4` (expected: `4`) SELECT * FROM test_date +------------+------------+------------+------------+ | c1 | c2 | c3 | c4 | +------------+------------+------------+------------+ | 11:16:20 | 11:16:20 | 11:16:20 | 00:00:00 | | 12:17:21 | 12:17:21 | 12:17:21 | 00:00:00 | | 13:18:22 | 13:18:22 | 13:18:22 | 00:00:00 | +------------+------------+------------+------------+ 3 rows returned time[0]: 00-00-00 11:16:20.00 time[1]: 00-00-00 11:16:20.00 time[2]: 00-00-00 11:16:20.00 time[3]: 00-00-00 00:00:00.00 time[0]: 00-00-00 12:17:21.00 time[1]: 00-00-00 12:17:21.00 time[2]: 00-00-00 12:17:21.00 time[3]: 00-00-00 00:00:00.00 time[0]: 00-00-00 13:18:22.00 time[1]: 00-00-00 13:18:22.00 time[2]: 00-00-00 13:18:22.00 time[3]: 00-00-00 00:00:00.00 ##################################### 66 of (1/1): test_date_ts ##################################### total parameters in stmt: `4` (expected: `4`) SELECT * FROM test_date +--------------------------------+--------------------------------+--------------------------------+--------------------------------+ | c1 | c2 | c3 | c4 | +--------------------------------+--------------------------------+--------------------------------+--------------------------------+ | 2000-01-10 11:16:20 | 0000-00-00 00:00:00 | 2000-01-10 11:16:20 | 2000-01-10 00:00:00 | | 2001-02-11 12:17:21 | 0000-00-00 00:00:00 | 2001-02-11 12:17:21 | 2001-02-11 00:00:00 | +--------------------------------+--------------------------------+--------------------------------+--------------------------------+ 2 rows returned time[0]: 2000-01-10 11:16:20.00 time[1]: 00-00-00 00:00:00.00 time[2]: 2000-01-10 11:16:20.00 time[3]: 2000-01-10 00:00:00.00 time[0]: 2001-02-11 12:17:21.00 time[1]: 00-00-00 00:00:00.00 time[2]: 2001-02-11 12:17:21.00 time[3]: 2001-02-11 00:00:00.00 ##################################### 67 of (1/1): test_date_dt ##################################### total parameters in stmt: `4` (expected: `4`) SELECT * FROM test_date +--------------------------------+--------------------------------+--------------------------------+------------+ | c1 | c2 | c3 | c4 | +--------------------------------+--------------------------------+--------------------------------+------------+ | 2000-01-10 11:16:20 | 0000-00-00 00:00:00 | 2000-01-10 11:16:20 | 2000-01-10 | | 2001-02-11 12:17:21 | 0000-00-00 00:00:00 | 2001-02-11 12:17:21 | 2001-02-11 | +--------------------------------+--------------------------------+--------------------------------+------------+ 2 rows returned time[0]: 2000-01-10 11:16:20.00 time[1]: 00-00-00 00:00:00.00 time[2]: 2000-01-10 11:16:20.00 time[3]: 2000-01-10 00:00:00.00 time[0]: 2001-02-11 12:17:21.00 time[1]: 00-00-00 00:00:00.00 time[2]: 2001-02-11 12:17:21.00 time[3]: 2001-02-11 00:00:00.00 ##################################### 68 of (1/1): test_prepare_alter ##################################### total parameters in stmt: `1` (expected: `1`) in thread_query(ALTER TABLE test_prep_alter change id id_new varchar(20)) SELECT * FROM test_prep_alter +--------+-------+ | id_new | name | +--------+-------+ | 10 | venu | | 20 | mysql | | 30 | monty | | NULL | monty | +--------+-------+ 4 rows returned ##################################### 69 of (1/1): test_manual_sample ##################################### prepare, insert successful total parameters in insert: 3 total affected rows: 1 total affected rows: 1 SELECT * FROM test_table +-------------+----------------------------------------------------+--------+--------------------------------+ | col1 | col2 | col3 | col4 | +-------------+----------------------------------------------------+--------+--------------------------------+ | 10 | MySQL | NULL | 2009-05-28 11:40:24 | | 1000 | The most popular open source database | 1000 | 2009-05-28 11:40:24 | +-------------+----------------------------------------------------+--------+--------------------------------+ 2 rows returned Success !!! ##################################### 70 of (1/1): test_pure_coverage ##################################### [MySQL-5.0.82-log][2036] Using unsupported buffer type: 255 (parameter: 1) [MySQL-5.0.82-log][2036] Using unsupported buffer type: 3 (parameter: 1) [MySQL-5.0.82-log][2014] Commands out of sync; you can't run this command now ##################################### 71 of (1/1): test_buffers ##################################### data: MX (5) data: Database (8) data: Open-Source (11) data: Populaource (7) ##################################### 72 of (1/1): test_ushort_bug ##################################### ushort : 35999 (2) ulong : 35999 (4) longlong : 35999 (8) tinyint : 200 (1) ##################################### 73 of (1/1): test_sshort_bug ##################################### sshort : -5999 (2) slong : -5999 (4) longlong : 35999 (8) tinyint : 200 (1) ##################################### 74 of (1/1): test_stiny_bug ##################################### sshort : -128 (2) slong : -127 (4) longlong : 255 (8) tinyint : 0 (1) ##################################### 75 of (1/1): test_field_misc ##################################### +--------------+ | @@autocommit | +--------------+ | 1 | +--------------+ 1 row returned field[0]: name :`@@autocommit` (expected: `@@autocommit`) org_name :`` (expected: ``) type :`8` (expected: `8`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`1` (expected: `1`) maxlength:`12` charsetnr:`63` default :`(null)` (expected: `(null)`) +-----------------------+ | @@autocommit | +-----------------------+ | 1 | +-----------------------+ 1 row returned field[0]: name :`@@autocommit` (expected: `@@autocommit`) org_name :`` (expected: ``) type :`8` (expected: `8`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`1` (expected: `1`) maxlength:`21` charsetnr:`63` default :`(null)` (expected: `(null)`) default table type: MyISAM(6) +--------------+ | @@table_type | +--------------+ | MyISAM | +--------------+ 1 row returned field[0]: name :`@@table_type` (expected: `@@table_type`) org_name :`` (expected: ``) type :`253` (expected: `253`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`6` (expected: `6`) maxlength:`12` charsetnr:`8` default :`(null)` (expected: `(null)`) +-----------------------+ | @@max_error_count | +-----------------------+ | 64 | +-----------------------+ 1 row returned field[0]: name :`@@max_error_count` (expected: `@@max_error_count`) org_name :`` (expected: ``) type :`8` (expected: `8`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`10` (expected: `10`) maxlength:`21` charsetnr:`63` default :`(null)` (expected: `(null)`) +-----------------------+ | @@max_allowed_packet | +-----------------------+ | 1048576 | +-----------------------+ 1 row returned field[0]: name :`@@max_allowed_packet` (expected: `@@max_allowed_packet`) org_name :`` (expected: ``) type :`8` (expected: `8`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`10` (expected: `10`) maxlength:`21` charsetnr:`63` default :`(null)` (expected: `(null)`) +-----------------------+ | @@sql_warnings | +-----------------------+ | 0 | +-----------------------+ 1 row returned field[0]: name :`@@sql_warnings` (expected: `@@sql_warnings`) org_name :`` (expected: ``) type :`8` (expected: `8`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`1` (expected: `1`) maxlength:`21` charsetnr:`63` default :`(null)` (expected: `(null)`) ##################################### 76 of (1/1): test_set_option ##################################### with SQL_SELECT_LIMIT= 2 (direct) +------+ | a | +------+ | 10 | | 20 | +------+ 2 rows returned with SQL_SELECT_LIMIT=2 (prepare) +------+ | a | +------+ | 10 | | 20 | +------+ 2 rows returned with SQL_SELECT_LIMIT=DEFAULT (prepare) +------+ | a | +------+ | 10 | | 20 | | 30 | | 40 | +------+ 4 rows returned ##################################### 77 of (1/1): test_prepare_grant ##################################### Establishing a test connection ... OK total affected rows: `1` (expected: `1`) total affected rows: `1` (expected: `1`) total affected rows: `1` (expected: `1`) SELECT a FROM test_grant +------+ | a | +------+ | 2 | | 3 | | 4 | | 9 | +------+ 4 rows returned [MySQL-5.0.82-log][1142] DELETE command denied to user 'test_grant'@'localhost' for table 'test_grant' SELECT * FROM test_grant +------+ | a | +------+ | 2 | | 3 | | 4 | | 9 | +------+ 4 rows returned ##################################### 78 of (1/1): test_frm_bug ##################################### data directory: /home/spunkmeyer/src/mysql-5.0.82/mysql-test/var/master-data/ test_frm: /home/spunkmeyer/src/mysql-5.0.82/mysql-test/var/master-data//client_test_db/test_frm_bug.frm +--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+--------------------------------------------------------------------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+--------------------------------------------------------------------+ | test_frm_bug | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Incorrect information in file: './client_test_db/test_frm_bug.frm' | +--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+--------------------------------------------------------------------+ 1 row returned Comment: Incorrect information in file: './client_test_db/test_frm_bug.frm' ##################################### 79 of (1/1): test_explain_bug ##################################### +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | id | int(11) | YES | | NULL | | | name | char(2) | YES | | NULL | | +-------+---------+------+-----+---------+-------+ 2 rows returned total fields in the result: 6 field[0]: name :`Field` (expected: `Field`) org_name :`COLUMN_NAME` (expected: `COLUMN_NAME`) type :`253` (expected: `253`) database :`` (expected: ``) length :`64` (expected: `64`) maxlength:`5` charsetnr:`8` default :`(null)` (expected: `(null)`) field[1]: name :`Type` (expected: `Type`) org_name :`COLUMN_TYPE` (expected: `COLUMN_TYPE`) type :`252` (expected: `252`) database :`` (expected: ``) length :`196605` (expected: `0`) maxlength:`7` charsetnr:`8` default :`(null)` (expected: `(null)`) field[2]: name :`Null` (expected: `Null`) org_name :`IS_NULLABLE` (expected: `IS_NULLABLE`) type :`253` (expected: `253`) database :`` (expected: ``) length :`3` (expected: `3`) maxlength:`4` charsetnr:`8` default :`(null)` (expected: `(null)`) field[3]: name :`Key` (expected: `Key`) org_name :`COLUMN_KEY` (expected: `COLUMN_KEY`) type :`253` (expected: `253`) database :`` (expected: ``) length :`3` (expected: `3`) maxlength:`3` charsetnr:`8` default :`(null)` (expected: `(null)`) field[4]: name :`Default` (expected: `Default`) org_name :`COLUMN_DEFAULT` (expected: `COLUMN_DEFAULT`) type :`252` (expected: `252`) database :`` (expected: ``) length :`196605` (expected: `0`) maxlength:`7` charsetnr:`8` default :`(null)` (expected: `(null)`) field[5]: name :`Extra` (expected: `Extra`) org_name :`EXTRA` (expected: `EXTRA`) type :`253` (expected: `253`) database :`` (expected: ``) length :`20` (expected: `20`) maxlength:`5` charsetnr:`8` default :`(null)` (expected: `(null)`) +-----------------------+-------------+--------------+--------+---------------+------+---------+------+-----------------------+---------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +-----------------------+-------------+--------------+--------+---------------+------+---------+------+-----------------------+---------------------+ | 1 | SIMPLE | test_explain | system | NULL | NULL | NULL | NULL | 0 | const row not found | +-----------------------+-------------+--------------+--------+---------------+------+---------+------+-----------------------+---------------------+ 1 row returned total fields in the result: 10 field[0]: name :`id` (expected: `id`) org_name :`` (expected: ``) type :`8` (expected: `8`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`3` (expected: `3`) maxlength:`21` charsetnr:`63` default :`(null)` (expected: `(null)`) field[1]: name :`select_type` (expected: `select_type`) org_name :`` (expected: ``) type :`253` (expected: `253`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`19` (expected: `19`) maxlength:`11` charsetnr:`8` default :`(null)` (expected: `(null)`) field[2]: name :`table` (expected: `table`) org_name :`` (expected: ``) type :`253` (expected: `253`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`64` (expected: `64`) maxlength:`12` charsetnr:`8` default :`(null)` (expected: `(null)`) field[3]: name :`type` (expected: `type`) org_name :`` (expected: ``) type :`253` (expected: `253`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`10` (expected: `10`) maxlength:`6` charsetnr:`8` default :`(null)` (expected: `(null)`) field[4]: name :`possible_keys` (expected: `possible_keys`) org_name :`` (expected: ``) type :`253` (expected: `253`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`4096` (expected: `4096`) maxlength:`13` charsetnr:`8` default :`(null)` (expected: `(null)`) field[5]: name :`key` (expected: `key`) org_name :`` (expected: ``) type :`253` (expected: `253`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`64` (expected: `64`) maxlength:`4` charsetnr:`8` default :`(null)` (expected: `(null)`) field[6]: name :`key_len` (expected: `key_len`) org_name :`` (expected: ``) type :`253` (expected: `253`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`4096` (expected: `4096`) maxlength:`7` charsetnr:`8` default :`(null)` (expected: `(null)`) field[7]: name :`ref` (expected: `ref`) org_name :`` (expected: ``) type :`253` (expected: `253`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`1024` (expected: `1024`) maxlength:`4` charsetnr:`8` default :`(null)` (expected: `(null)`) field[8]: name :`rows` (expected: `rows`) org_name :`` (expected: ``) type :`8` (expected: `8`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`10` (expected: `10`) maxlength:`21` charsetnr:`63` default :`(null)` (expected: `(null)`) field[9]: name :`Extra` (expected: `Extra`) org_name :`` (expected: ``) type :`253` (expected: `253`) table :`` (expected: ``) org_table:`` (expected: ``) database :`` (expected: ``) length :`255` (expected: `255`) maxlength:`19` charsetnr:`8` default :`(null)` (expected: `(null)`) ##################################### 80 of (1/1): test_decimal_bug ##################################### data: 8.00 data: 5.61 data: 10.22 ##################################### 81 of (1/1): test_nstmts ##################################### stmt: 0 stmt: 1 stmt: 2 stmt: 3 stmt: 4 stmt: 5 stmt: 6 stmt: 7 stmt: 8 stmt: 9 stmt: 10 stmt: 11 stmt: 12 stmt: 13 stmt: 14 stmt: 15 stmt: 16 stmt: 17 stmt: 18 stmt: 19 stmt: 20 stmt: 21 stmt: 22 stmt: 23 stmt: 24 stmt: 25 stmt: 26 stmt: 27 stmt: 28 stmt: 29 stmt: 30 stmt: 31 stmt: 32 stmt: 33 stmt: 34 stmt: 35 stmt: 36 stmt: 37 stmt: 38 stmt: 39 stmt: 40 stmt: 41 stmt: 42 stmt: 43 stmt: 44 stmt: 45 stmt: 46 stmt: 47 stmt: 48 stmt: 49 stmt: 50 stmt: 51 stmt: 52 stmt: 53 stmt: 54 stmt: 55 stmt: 56 stmt: 57 stmt: 58 stmt: 59 stmt: 60 stmt: 61 stmt: 62 stmt: 63 stmt: 64 stmt: 65 stmt: 66 stmt: 67 stmt: 68 stmt: 69 stmt: 70 stmt: 71 stmt: 72 stmt: 73 stmt: 74 stmt: 75 stmt: 76 stmt: 77 stmt: 78 stmt: 79 stmt: 80 stmt: 81 stmt: 82 stmt: 83 stmt: 84 stmt: 85 stmt: 86 stmt: 87 stmt: 88 stmt: 89 stmt: 90 stmt: 91 stmt: 92 stmt: 93 stmt: 94 stmt: 95 stmt: 96 stmt: 97 stmt: 98 stmt: 99 stmt: 100 stmt: 101 stmt: 102 stmt: 103 stmt: 104 stmt: 105 stmt: 106 stmt: 107 stmt: 108 stmt: 109 stmt: 110 stmt: 111 stmt: 112 stmt: 113 stmt: 114 stmt: 115 stmt: 116 stmt: 117 stmt: 118 stmt: 119 stmt: 120 stmt: 121 stmt: 122 stmt: 123 stmt: 124 stmt: 125 stmt: 126 stmt: 127 stmt: 128 stmt: 129 stmt: 130 stmt: 131 stmt: 132 stmt: 133 stmt: 134 stmt: 135 stmt: 136 stmt: 137 stmt: 138 stmt: 139 stmt: 140 stmt: 141 stmt: 142 stmt: 143 stmt: 144 stmt: 145 stmt: 146 stmt: 147 stmt: 148 stmt: 149 stmt: 150 stmt: 151 stmt: 152 stmt: 153 stmt: 154 stmt: 155 stmt: 156 stmt: 157 stmt: 158 stmt: 159 stmt: 160 stmt: 161 stmt: 162 stmt: 163 stmt: 164 stmt: 165 stmt: 166 stmt: 167 stmt: 168 stmt: 169 stmt: 170 stmt: 171 stmt: 172 stmt: 173 stmt: 174 stmt: 175 stmt: 176 stmt: 177 stmt: 178 stmt: 179 stmt: 180 stmt: 181 stmt: 182 stmt: 183 stmt: 184 stmt: 185 stmt: 186 stmt: 187 stmt: 188 stmt: 189 stmt: 190 stmt: 191 stmt: 192 stmt: 193 stmt: 194 stmt: 195 stmt: 196 stmt: 197 stmt: 198 stmt: 199 stmt: 200 stmt: 201 stmt: 202 stmt: 203 stmt: 204 stmt: 205 stmt: 206 stmt: 207 stmt: 208 stmt: 209 stmt: 210 stmt: 211 stmt: 212 stmt: 213 stmt: 214 stmt: 215 stmt: 216 stmt: 217 stmt: 218 stmt: 219 stmt: 220 stmt: 221 stmt: 222 stmt: 223 stmt: 224 stmt: 225 stmt: 226 stmt: 227 stmt: 228 stmt: 229 stmt: 230 stmt: 231 stmt: 232 stmt: 233 stmt: 234 stmt: 235 stmt: 236 stmt: 237 stmt: 238 stmt: 239 stmt: 240 stmt: 241 stmt: 242 stmt: 243 stmt: 244 stmt: 245 stmt: 246 stmt: 247 stmt: 248 stmt: 249 stmt: 250 stmt: 251 stmt: 252 stmt: 253 stmt: 254 stmt: 255 stmt: 256 stmt: 257 stmt: 258 stmt: 259 stmt: 260 stmt: 261 stmt: 262 stmt: 263 stmt: 264 stmt: 265 stmt: 266 stmt: 267 stmt: 268 stmt: 269 stmt: 270 stmt: 271 stmt: 272 stmt: 273 stmt: 274 stmt: 275 stmt: 276 stmt: 277 stmt: 278 stmt: 279 stmt: 280 stmt: 281 stmt: 282 stmt: 283 stmt: 284 stmt: 285 stmt: 286 stmt: 287 stmt: 288 stmt: 289 stmt: 290 stmt: 291 stmt: 292 stmt: 293 stmt: 294 stmt: 295 stmt: 296 stmt: 297 stmt: 298 stmt: 299 stmt: 300 stmt: 301 stmt: 302 stmt: 303 stmt: 304 stmt: 305 stmt: 306 stmt: 307 stmt: 308 stmt: 309 stmt: 310 stmt: 311 stmt: 312 stmt: 313 stmt: 314 stmt: 315 stmt: 316 stmt: 317 stmt: 318 stmt: 319 stmt: 320 stmt: 321 stmt: 322 stmt: 323 stmt: 324 stmt: 325 stmt: 326 stmt: 327 stmt: 328 stmt: 329 stmt: 330 stmt: 331 stmt: 332 stmt: 333 stmt: 334 stmt: 335 stmt: 336 stmt: 337 stmt: 338 stmt: 339 stmt: 340 stmt: 341 stmt: 342 stmt: 343 stmt: 344 stmt: 345 stmt: 346 stmt: 347 stmt: 348 stmt: 349 stmt: 350 stmt: 351 stmt: 352 stmt: 353 stmt: 354 stmt: 355 stmt: 356 stmt: 357 stmt: 358 stmt: 359 stmt: 360 stmt: 361 stmt: 362 stmt: 363 stmt: 364 stmt: 365 stmt: 366 stmt: 367 stmt: 368 stmt: 369 stmt: 370 stmt: 371 stmt: 372 stmt: 373 stmt: 374 stmt: 375 stmt: 376 stmt: 377 stmt: 378 stmt: 379 stmt: 380 stmt: 381 stmt: 382 stmt: 383 stmt: 384 stmt: 385 stmt: 386 stmt: 387 stmt: 388 stmt: 389 stmt: 390 stmt: 391 stmt: 392 stmt: 393 stmt: 394 stmt: 395 stmt: 396 stmt: 397 stmt: 398 stmt: 399 stmt: 400 stmt: 401 stmt: 402 stmt: 403 stmt: 404 stmt: 405 stmt: 406 stmt: 407 stmt: 408 stmt: 409 stmt: 410 stmt: 411 stmt: 412 stmt: 413 stmt: 414 stmt: 415 stmt: 416 stmt: 417 stmt: 418 stmt: 419 stmt: 420 stmt: 421 stmt: 422 stmt: 423 stmt: 424 stmt: 425 stmt: 426 stmt: 427 stmt: 428 stmt: 429 stmt: 430 stmt: 431 stmt: 432 stmt: 433 stmt: 434 stmt: 435 stmt: 436 stmt: 437 stmt: 438 stmt: 439 stmt: 440 stmt: 441 stmt: 442 stmt: 443 stmt: 444 stmt: 445 stmt: 446 stmt: 447 stmt: 448 stmt: 449 stmt: 450 stmt: 451 stmt: 452 stmt: 453 stmt: 454 stmt: 455 stmt: 456 stmt: 457 stmt: 458 stmt: 459 stmt: 460 stmt: 461 stmt: 462 stmt: 463 stmt: 464 stmt: 465 stmt: 466 stmt: 467 stmt: 468 stmt: 469 stmt: 470 stmt: 471 stmt: 472 stmt: 473 stmt: 474 stmt: 475 stmt: 476 stmt: 477 stmt: 478 stmt: 479 stmt: 480 stmt: 481 stmt: 482 stmt: 483 stmt: 484 stmt: 485 stmt: 486 stmt: 487 stmt: 488 stmt: 489 stmt: 490 stmt: 491 stmt: 492 stmt: 493 stmt: 494 stmt: 495 stmt: 496 stmt: 497 stmt: 498 stmt: 499 stmt: 500 stmt: 501 stmt: 502 stmt: 503 stmt: 504 stmt: 505 stmt: 506 stmt: 507 stmt: 508 stmt: 509 stmt: 510 stmt: 511 stmt: 512 stmt: 513 stmt: 514 stmt: 515 stmt: 516 stmt: 517 stmt: 518 stmt: 519 stmt: 520 stmt: 521 stmt: 522 stmt: 523 stmt: 524 stmt: 525 stmt: 526 stmt: 527 stmt: 528 stmt: 529 stmt: 530 stmt: 531 stmt: 532 stmt: 533 stmt: 534 stmt: 535 stmt: 536 stmt: 537 stmt: 538 stmt: 539 stmt: 540 stmt: 541 stmt: 542 stmt: 543 stmt: 544 stmt: 545 stmt: 546 stmt: 547 stmt: 548 stmt: 549 stmt: 550 stmt: 551 stmt: 552 stmt: 553 stmt: 554 stmt: 555 stmt: 556 stmt: 557 stmt: 558 stmt: 559 stmt: 560 stmt: 561 stmt: 562 stmt: 563 stmt: 564 stmt: 565 stmt: 566 stmt: 567 stmt: 568 stmt: 569 stmt: 570 stmt: 571 stmt: 572 stmt: 573 stmt: 574 stmt: 575 stmt: 576 stmt: 577 stmt: 578 stmt: 579 stmt: 580 stmt: 581 stmt: 582 stmt: 583 stmt: 584 stmt: 585 stmt: 586 stmt: 587 stmt: 588 stmt: 589 stmt: 590 stmt: 591 stmt: 592 stmt: 593 stmt: 594 stmt: 595 stmt: 596 stmt: 597 stmt: 598 stmt: 599 stmt: 600 stmt: 601 stmt: 602 stmt: 603 stmt: 604 stmt: 605 stmt: 606 stmt: 607 stmt: 608 stmt: 609 stmt: 610 stmt: 611 stmt: 612 stmt: 613 stmt: 614 stmt: 615 stmt: 616 stmt: 617 stmt: 618 stmt: 619 stmt: 620 stmt: 621 stmt: 622 stmt: 623 stmt: 624 stmt: 625 stmt: 626 stmt: 627 stmt: 628 stmt: 629 stmt: 630 stmt: 631 stmt: 632 stmt: 633 stmt: 634 stmt: 635 stmt: 636 stmt: 637 stmt: 638 stmt: 639 stmt: 640 stmt: 641 stmt: 642 stmt: 643 stmt: 644 stmt: 645 stmt: 646 stmt: 647 stmt: 648 stmt: 649 stmt: 650 stmt: 651 stmt: 652 stmt: 653 stmt: 654 stmt: 655 stmt: 656 stmt: 657 stmt: 658 stmt: 659 stmt: 660 stmt: 661 stmt: 662 stmt: 663 stmt: 664 stmt: 665 stmt: 666 stmt: 667 stmt: 668 stmt: 669 stmt: 670 stmt: 671 stmt: 672 stmt: 673 stmt: 674 stmt: 675 stmt: 676 stmt: 677 stmt: 678 stmt: 679 stmt: 680 stmt: 681 stmt: 682 stmt: 683 stmt: 684 stmt: 685 stmt: 686 stmt: 687 stmt: 688 stmt: 689 stmt: 690 stmt: 691 stmt: 692 stmt: 693 stmt: 694 stmt: 695 stmt: 696 stmt: 697 stmt: 698 stmt: 699 stmt: 700 stmt: 701 stmt: 702 stmt: 703 stmt: 704 stmt: 705 stmt: 706 stmt: 707 stmt: 708 stmt: 709 stmt: 710 stmt: 711 stmt: 712 stmt: 713 stmt: 714 stmt: 715 stmt: 716 stmt: 717 stmt: 718 stmt: 719 stmt: 720 stmt: 721 stmt: 722 stmt: 723 stmt: 724 stmt: 725 stmt: 726 stmt: 727 stmt: 728 stmt: 729 stmt: 730 stmt: 731 stmt: 732 stmt: 733 stmt: 734 stmt: 735 stmt: 736 stmt: 737 stmt: 738 stmt: 739 stmt: 740 stmt: 741 stmt: 742 stmt: 743 stmt: 744 stmt: 745 stmt: 746 stmt: 747 stmt: 748 stmt: 749 stmt: 750 stmt: 751 stmt: 752 stmt: 753 stmt: 754 stmt: 755 stmt: 756 stmt: 757 stmt: 758 stmt: 759 stmt: 760 stmt: 761 stmt: 762 stmt: 763 stmt: 764 stmt: 765 stmt: 766 stmt: 767 stmt: 768 stmt: 769 stmt: 770 stmt: 771 stmt: 772 stmt: 773 stmt: 774 stmt: 775 stmt: 776 stmt: 777 stmt: 778 stmt: 779 stmt: 780 stmt: 781 stmt: 782 stmt: 783 stmt: 784 stmt: 785 stmt: 786 stmt: 787 stmt: 788 stmt: 789 stmt: 790 stmt: 791 stmt: 792 stmt: 793 stmt: 794 stmt: 795 stmt: 796 stmt: 797 stmt: 798 stmt: 799 stmt: 800 stmt: 801 stmt: 802 stmt: 803 stmt: 804 stmt: 805 stmt: 806 stmt: 807 stmt: 808 stmt: 809 stmt: 810 stmt: 811 stmt: 812 stmt: 813 stmt: 814 stmt: 815 stmt: 816 stmt: 817 stmt: 818 stmt: 819 stmt: 820 stmt: 821 stmt: 822 stmt: 823 stmt: 824 stmt: 825 stmt: 826 stmt: 827 stmt: 828 stmt: 829 stmt: 830 stmt: 831 stmt: 832 stmt: 833 stmt: 834 stmt: 835 stmt: 836 stmt: 837 stmt: 838 stmt: 839 stmt: 840 stmt: 841 stmt: 842 stmt: 843 stmt: 844 stmt: 845 stmt: 846 stmt: 847 stmt: 848 stmt: 849 stmt: 850 stmt: 851 stmt: 852 stmt: 853 stmt: 854 stmt: 855 stmt: 856 stmt: 857 stmt: 858 stmt: 859 stmt: 860 stmt: 861 stmt: 862 stmt: 863 stmt: 864 stmt: 865 stmt: 866 stmt: 867 stmt: 868 stmt: 869 stmt: 870 stmt: 871 stmt: 872 stmt: 873 stmt: 874 stmt: 875 stmt: 876 stmt: 877 stmt: 878 stmt: 879 stmt: 880 stmt: 881 stmt: 882 stmt: 883 stmt: 884 stmt: 885 stmt: 886 stmt: 887 stmt: 888 stmt: 889 stmt: 890 stmt: 891 stmt: 892 stmt: 893 stmt: 894 stmt: 895 stmt: 896 stmt: 897 stmt: 898 stmt: 899 stmt: 900 stmt: 901 stmt: 902 stmt: 903 stmt: 904 stmt: 905 stmt: 906 stmt: 907 stmt: 908 stmt: 909 stmt: 910 stmt: 911 stmt: 912 stmt: 913 stmt: 914 stmt: 915 stmt: 916 stmt: 917 stmt: 918 stmt: 919 stmt: 920 stmt: 921 stmt: 922 stmt: 923 stmt: 924 stmt: 925 stmt: 926 stmt: 927 stmt: 928 stmt: 929 stmt: 930 stmt: 931 stmt: 932 stmt: 933 stmt: 934 stmt: 935 stmt: 936 stmt: 937 stmt: 938 stmt: 939 stmt: 940 stmt: 941 stmt: 942 stmt: 943 stmt: 944 stmt: 945 stmt: 946 stmt: 947 stmt: 948 stmt: 949 stmt: 950 stmt: 951 stmt: 952 stmt: 953 stmt: 954 stmt: 955 stmt: 956 stmt: 957 stmt: 958 stmt: 959 stmt: 960 stmt: 961 stmt: 962 stmt: 963 stmt: 964 stmt: 965 stmt: 966 stmt: 967 stmt: 968 stmt: 969 stmt: 970 stmt: 971 stmt: 972 stmt: 973 stmt: 974 stmt: 975 stmt: 976 stmt: 977 stmt: 978 stmt: 979 stmt: 980 stmt: 981 stmt: 982 stmt: 983 stmt: 984 stmt: 985 stmt: 986 stmt: 987 stmt: 988 stmt: 989 stmt: 990 stmt: 991 stmt: 992 stmt: 993 stmt: 994 stmt: 995 stmt: 996 stmt: 997 stmt: 998 stmt: 999 stmt: 1000 stmt: 1001 stmt: 1002 stmt: 1003 stmt: 1004 stmt: 1005 stmt: 1006 stmt: 1007 stmt: 1008 stmt: 1009 stmt: 1010 stmt: 1011 stmt: 1012 stmt: 1013 stmt: 1014 stmt: 1015 stmt: 1016 stmt: 1017 stmt: 1018 stmt: 1019 stmt: 1020 stmt: 1021 stmt: 1022 stmt: 1023 stmt: 1024 stmt: 1025 stmt: 1026 stmt: 1027 stmt: 1028 stmt: 1029 stmt: 1030 stmt: 1031 stmt: 1032 stmt: 1033 stmt: 1034 stmt: 1035 stmt: 1036 stmt: 1037 stmt: 1038 stmt: 1039 stmt: 1040 stmt: 1041 stmt: 1042 stmt: 1043 stmt: 1044 stmt: 1045 stmt: 1046 stmt: 1047 stmt: 1048 stmt: 1049 stmt: 1050 stmt: 1051 stmt: 1052 stmt: 1053 stmt: 1054 stmt: 1055 stmt: 1056 stmt: 1057 stmt: 1058 stmt: 1059 stmt: 1060 stmt: 1061 stmt: 1062 stmt: 1063 stmt: 1064 stmt: 1065 stmt: 1066 stmt: 1067 stmt: 1068 stmt: 1069 stmt: 1070 stmt: 1071 stmt: 1072 stmt: 1073 stmt: 1074 stmt: 1075 stmt: 1076 stmt: 1077 stmt: 1078 stmt: 1079 stmt: 1080 stmt: 1081 stmt: 1082 stmt: 1083 stmt: 1084 stmt: 1085 stmt: 1086 stmt: 1087 stmt: 1088 stmt: 1089 stmt: 1090 stmt: 1091 stmt: 1092 stmt: 1093 stmt: 1094 stmt: 1095 stmt: 1096 stmt: 1097 stmt: 1098 stmt: 1099 stmt: 1100 stmt: 1101 stmt: 1102 stmt: 1103 stmt: 1104 stmt: 1105 stmt: 1106 stmt: 1107 stmt: 1108 stmt: 1109 stmt: 1110 stmt: 1111 stmt: 1112 stmt: 1113 stmt: 1114 stmt: 1115 stmt: 1116 stmt: 1117 stmt: 1118 stmt: 1119 stmt: 1120 stmt: 1121 stmt: 1122 stmt: 1123 stmt: 1124 stmt: 1125 stmt: 1126 stmt: 1127 stmt: 1128 stmt: 1129 stmt: 1130 stmt: 1131 stmt: 1132 stmt: 1133 stmt: 1134 stmt: 1135 stmt: 1136 stmt: 1137 stmt: 1138 stmt: 1139 stmt: 1140 stmt: 1141 stmt: 1142 stmt: 1143 stmt: 1144 stmt: 1145 stmt: 1146 stmt: 1147 stmt: 1148 stmt: 1149 stmt: 1150 stmt: 1151 stmt: 1152 stmt: 1153 stmt: 1154 stmt: 1155 stmt: 1156 stmt: 1157 stmt: 1158 stmt: 1159 stmt: 1160 stmt: 1161 stmt: 1162 stmt: 1163 stmt: 1164 stmt: 1165 stmt: 1166 stmt: 1167 stmt: 1168 stmt: 1169 stmt: 1170 stmt: 1171 stmt: 1172 stmt: 1173 stmt: 1174 stmt: 1175 stmt: 1176 stmt: 1177 stmt: 1178 stmt: 1179 stmt: 1180 stmt: 1181 stmt: 1182 stmt: 1183 stmt: 1184 stmt: 1185 stmt: 1186 stmt: 1187 stmt: 1188 stmt: 1189 stmt: 1190 stmt: 1191 stmt: 1192 stmt: 1193 stmt: 1194 stmt: 1195 stmt: 1196 stmt: 1197 stmt: 1198 stmt: 1199 stmt: 1200 stmt: 1201 stmt: 1202 stmt: 1203 stmt: 1204 stmt: 1205 stmt: 1206 stmt: 1207 stmt: 1208 stmt: 1209 stmt: 1210 stmt: 1211 stmt: 1212 stmt: 1213 stmt: 1214 stmt: 1215 stmt: 1216 stmt: 1217 stmt: 1218 stmt: 1219 stmt: 1220 stmt: 1221 stmt: 1222 stmt: 1223 stmt: 1224 stmt: 1225 stmt: 1226 stmt: 1227 stmt: 1228 stmt: 1229 stmt: 1230 stmt: 1231 stmt: 1232 stmt: 1233 stmt: 1234 stmt: 1235 stmt: 1236 stmt: 1237 stmt: 1238 stmt: 1239 stmt: 1240 stmt: 1241 stmt: 1242 stmt: 1243 stmt: 1244 stmt: 1245 stmt: 1246 stmt: 1247 stmt: 1248 stmt: 1249 stmt: 1250 stmt: 1251 stmt: 1252 stmt: 1253 stmt: 1254 stmt: 1255 stmt: 1256 stmt: 1257 stmt: 1258 stmt: 1259 stmt: 1260 stmt: 1261 stmt: 1262 stmt: 1263 stmt: 1264 stmt: 1265 stmt: 1266 stmt: 1267 stmt: 1268 stmt: 1269 stmt: 1270 stmt: 1271 stmt: 1272 stmt: 1273 stmt: 1274 stmt: 1275 stmt: 1276 stmt: 1277 stmt: 1278 stmt: 1279 stmt: 1280 stmt: 1281 stmt: 1282 stmt: 1283 stmt: 1284 stmt: 1285 stmt: 1286 stmt: 1287 stmt: 1288 stmt: 1289 stmt: 1290 stmt: 1291 stmt: 1292 stmt: 1293 stmt: 1294 stmt: 1295 stmt: 1296 stmt: 1297 stmt: 1298 stmt: 1299 stmt: 1300 stmt: 1301 stmt: 1302 stmt: 1303 stmt: 1304 stmt: 1305 stmt: 1306 stmt: 1307 stmt: 1308 stmt: 1309 stmt: 1310 stmt: 1311 stmt: 1312 stmt: 1313 stmt: 1314 stmt: 1315 stmt: 1316 stmt: 1317 stmt: 1318 stmt: 1319 stmt: 1320 stmt: 1321 stmt: 1322 stmt: 1323 stmt: 1324 stmt: 1325 stmt: 1326 stmt: 1327 stmt: 1328 stmt: 1329 stmt: 1330 stmt: 1331 stmt: 1332 stmt: 1333 stmt: 1334 stmt: 1335 stmt: 1336 stmt: 1337 stmt: 1338 stmt: 1339 stmt: 1340 stmt: 1341 stmt: 1342 stmt: 1343 stmt: 1344 stmt: 1345 stmt: 1346 stmt: 1347 stmt: 1348 stmt: 1349 stmt: 1350 stmt: 1351 stmt: 1352 stmt: 1353 stmt: 1354 stmt: 1355 stmt: 1356 stmt: 1357 stmt: 1358 stmt: 1359 stmt: 1360 stmt: 1361 stmt: 1362 stmt: 1363 stmt: 1364 stmt: 1365 stmt: 1366 stmt: 1367 stmt: 1368 stmt: 1369 stmt: 1370 stmt: 1371 stmt: 1372 stmt: 1373 stmt: 1374 stmt: 1375 stmt: 1376 stmt: 1377 stmt: 1378 stmt: 1379 stmt: 1380 stmt: 1381 stmt: 1382 stmt: 1383 stmt: 1384 stmt: 1385 stmt: 1386 stmt: 1387 stmt: 1388 stmt: 1389 stmt: 1390 stmt: 1391 stmt: 1392 stmt: 1393 stmt: 1394 stmt: 1395 stmt: 1396 stmt: 1397 stmt: 1398 stmt: 1399 stmt: 1400 stmt: 1401 stmt: 1402 stmt: 1403 stmt: 1404 stmt: 1405 stmt: 1406 stmt: 1407 stmt: 1408 stmt: 1409 stmt: 1410 stmt: 1411 stmt: 1412 stmt: 1413 stmt: 1414 stmt: 1415 stmt: 1416 stmt: 1417 stmt: 1418 stmt: 1419 stmt: 1420 stmt: 1421 stmt: 1422 stmt: 1423 stmt: 1424 stmt: 1425 stmt: 1426 stmt: 1427 stmt: 1428 stmt: 1429 stmt: 1430 stmt: 1431 stmt: 1432 stmt: 1433 stmt: 1434 stmt: 1435 stmt: 1436 stmt: 1437 stmt: 1438 stmt: 1439 stmt: 1440 stmt: 1441 stmt: 1442 stmt: 1443 stmt: 1444 stmt: 1445 stmt: 1446 stmt: 1447 stmt: 1448 stmt: 1449 stmt: 1450 stmt: 1451 stmt: 1452 stmt: 1453 stmt: 1454 stmt: 1455 stmt: 1456 stmt: 1457 stmt: 1458 stmt: 1459 stmt: 1460 stmt: 1461 stmt: 1462 stmt: 1463 stmt: 1464 stmt: 1465 stmt: 1466 stmt: 1467 stmt: 1468 stmt: 1469 stmt: 1470 stmt: 1471 stmt: 1472 stmt: 1473 stmt: 1474 stmt: 1475 stmt: 1476 stmt: 1477 stmt: 1478 stmt: 1479 stmt: 1480 stmt: 1481 stmt: 1482 stmt: 1483 stmt: 1484 stmt: 1485 stmt: 1486 stmt: 1487 stmt: 1488 stmt: 1489 stmt: 1490 stmt: 1491 stmt: 1492 stmt: 1493 stmt: 1494 stmt: 1495 stmt: 1496 stmt: 1497 stmt: 1498 stmt: 1499 stmt: 1500 stmt: 1501 stmt: 1502 stmt: 1503 stmt: 1504 stmt: 1505 stmt: 1506 stmt: 1507 stmt: 1508 stmt: 1509 stmt: 1510 stmt: 1511 stmt: 1512 stmt: 1513 stmt: 1514 stmt: 1515 stmt: 1516 stmt: 1517 stmt: 1518 stmt: 1519 stmt: 1520 stmt: 1521 stmt: 1522 stmt: 1523 stmt: 1524 stmt: 1525 stmt: 1526 stmt: 1527 stmt: 1528 stmt: 1529 stmt: 1530 stmt: 1531 stmt: 1532 stmt: 1533 stmt: 1534 stmt: 1535 stmt: 1536 stmt: 1537 stmt: 1538 stmt: 1539 stmt: 1540 stmt: 1541 stmt: 1542 stmt: 1543 stmt: 1544 stmt: 1545 stmt: 1546 stmt: 1547 stmt: 1548 stmt: 1549 stmt: 1550 stmt: 1551 stmt: 1552 stmt: 1553 stmt: 1554 stmt: 1555 stmt: 1556 stmt: 1557 stmt: 1558 stmt: 1559 stmt: 1560 stmt: 1561 stmt: 1562 stmt: 1563 stmt: 1564 stmt: 1565 stmt: 1566 stmt: 1567 stmt: 1568 stmt: 1569 stmt: 1570 stmt: 1571 stmt: 1572 stmt: 1573 stmt: 1574 stmt: 1575 stmt: 1576 stmt: 1577 stmt: 1578 stmt: 1579 stmt: 1580 stmt: 1581 stmt: 1582 stmt: 1583 stmt: 1584 stmt: 1585 stmt: 1586 stmt: 1587 stmt: 1588 stmt: 1589 stmt: 1590 stmt: 1591 stmt: 1592 stmt: 1593 stmt: 1594 stmt: 1595 stmt: 1596 stmt: 1597 stmt: 1598 stmt: 1599 stmt: 1600 stmt: 1601 stmt: 1602 stmt: 1603 stmt: 1604 stmt: 1605 stmt: 1606 stmt: 1607 stmt: 1608 stmt: 1609 stmt: 1610 stmt: 1611 stmt: 1612 stmt: 1613 stmt: 1614 stmt: 1615 stmt: 1616 stmt: 1617 stmt: 1618 stmt: 1619 stmt: 1620 stmt: 1621 stmt: 1622 stmt: 1623 stmt: 1624 stmt: 1625 stmt: 1626 stmt: 1627 stmt: 1628 stmt: 1629 stmt: 1630 stmt: 1631 stmt: 1632 stmt: 1633 stmt: 1634 stmt: 1635 stmt: 1636 stmt: 1637 stmt: 1638 stmt: 1639 stmt: 1640 stmt: 1641 stmt: 1642 stmt: 1643 stmt: 1644 stmt: 1645 stmt: 1646 stmt: 1647 stmt: 1648 stmt: 1649 stmt: 1650 stmt: 1651 stmt: 1652 stmt: 1653 stmt: 1654 stmt: 1655 stmt: 1656 stmt: 1657 stmt: 1658 stmt: 1659 stmt: 1660 stmt: 1661 stmt: 1662 stmt: 1663 stmt: 1664 stmt: 1665 stmt: 1666 stmt: 1667 stmt: 1668 stmt: 1669 stmt: 1670 stmt: 1671 stmt: 1672 stmt: 1673 stmt: 1674 stmt: 1675 stmt: 1676 stmt: 1677 stmt: 1678 stmt: 1679 stmt: 1680 stmt: 1681 stmt: 1682 stmt: 1683 stmt: 1684 stmt: 1685 stmt: 1686 stmt: 1687 stmt: 1688 stmt: 1689 stmt: 1690 stmt: 1691 stmt: 1692 stmt: 1693 stmt: 1694 stmt: 1695 stmt: 1696 stmt: 1697 stmt: 1698 stmt: 1699 stmt: 1700 stmt: 1701 stmt: 1702 stmt: 1703 stmt: 1704 stmt: 1705 stmt: 1706 stmt: 1707 stmt: 1708 stmt: 1709 stmt: 1710 stmt: 1711 stmt: 1712 stmt: 1713 stmt: 1714 stmt: 1715 stmt: 1716 stmt: 1717 stmt: 1718 stmt: 1719 stmt: 1720 stmt: 1721 stmt: 1722 stmt: 1723 stmt: 1724 stmt: 1725 stmt: 1726 stmt: 1727 stmt: 1728 stmt: 1729 stmt: 1730 stmt: 1731 stmt: 1732 stmt: 1733 stmt: 1734 stmt: 1735 stmt: 1736 stmt: 1737 stmt: 1738 stmt: 1739 stmt: 1740 stmt: 1741 stmt: 1742 stmt: 1743 stmt: 1744 stmt: 1745 stmt: 1746 stmt: 1747 stmt: 1748 stmt: 1749 stmt: 1750 stmt: 1751 stmt: 1752 stmt: 1753 stmt: 1754 stmt: 1755 stmt: 1756 stmt: 1757 stmt: 1758 stmt: 1759 stmt: 1760 stmt: 1761 stmt: 1762 stmt: 1763 stmt: 1764 stmt: 1765 stmt: 1766 stmt: 1767 stmt: 1768 stmt: 1769 stmt: 1770 stmt: 1771 stmt: 1772 stmt: 1773 stmt: 1774 stmt: 1775 stmt: 1776 stmt: 1777 stmt: 1778 stmt: 1779 stmt: 1780 stmt: 1781 stmt: 1782 stmt: 1783 stmt: 1784 stmt: 1785 stmt: 1786 stmt: 1787 stmt: 1788 stmt: 1789 stmt: 1790 stmt: 1791 stmt: 1792 stmt: 1793 stmt: 1794 stmt: 1795 stmt: 1796 stmt: 1797 stmt: 1798 stmt: 1799 stmt: 1800 stmt: 1801 stmt: 1802 stmt: 1803 stmt: 1804 stmt: 1805 stmt: 1806 stmt: 1807 stmt: 1808 stmt: 1809 stmt: 1810 stmt: 1811 stmt: 1812 stmt: 1813 stmt: 1814 stmt: 1815 stmt: 1816 stmt: 1817 stmt: 1818 stmt: 1819 stmt: 1820 stmt: 1821 stmt: 1822 stmt: 1823 stmt: 1824 stmt: 1825 stmt: 1826 stmt: 1827 stmt: 1828 stmt: 1829 stmt: 1830 stmt: 1831 stmt: 1832 stmt: 1833 stmt: 1834 stmt: 1835 stmt: 1836 stmt: 1837 stmt: 1838 stmt: 1839 stmt: 1840 stmt: 1841 stmt: 1842 stmt: 1843 stmt: 1844 stmt: 1845 stmt: 1846 stmt: 1847 stmt: 1848 stmt: 1849 stmt: 1850 stmt: 1851 stmt: 1852 stmt: 1853 stmt: 1854 stmt: 1855 stmt: 1856 stmt: 1857 stmt: 1858 stmt: 1859 stmt: 1860 stmt: 1861 stmt: 1862 stmt: 1863 stmt: 1864 stmt: 1865 stmt: 1866 stmt: 1867 stmt: 1868 stmt: 1869 stmt: 1870 stmt: 1871 stmt: 1872 stmt: 1873 stmt: 1874 stmt: 1875 stmt: 1876 stmt: 1877 stmt: 1878 stmt: 1879 stmt: 1880 stmt: 1881 stmt: 1882 stmt: 1883 stmt: 1884 stmt: 1885 stmt: 1886 stmt: 1887 stmt: 1888 stmt: 1889 stmt: 1890 stmt: 1891 stmt: 1892 stmt: 1893 stmt: 1894 stmt: 1895 stmt: 1896 stmt: 1897 stmt: 1898 stmt: 1899 stmt: 1900 stmt: 1901 stmt: 1902 stmt: 1903 stmt: 1904 stmt: 1905 stmt: 1906 stmt: 1907 stmt: 1908 stmt: 1909 stmt: 1910 stmt: 1911 stmt: 1912 stmt: 1913 stmt: 1914 stmt: 1915 stmt: 1916 stmt: 1917 stmt: 1918 stmt: 1919 stmt: 1920 stmt: 1921 stmt: 1922 stmt: 1923 stmt: 1924 stmt: 1925 stmt: 1926 stmt: 1927 stmt: 1928 stmt: 1929 stmt: 1930 stmt: 1931 stmt: 1932 stmt: 1933 stmt: 1934 stmt: 1935 stmt: 1936 stmt: 1937 stmt: 1938 stmt: 1939 stmt: 1940 stmt: 1941 stmt: 1942 stmt: 1943 stmt: 1944 stmt: 1945 stmt: 1946 stmt: 1947 stmt: 1948 stmt: 1949 stmt: 1950 stmt: 1951 stmt: 1952 stmt: 1953 stmt: 1954 stmt: 1955 stmt: 1956 stmt: 1957 stmt: 1958 stmt: 1959 stmt: 1960 stmt: 1961 stmt: 1962 stmt: 1963 stmt: 1964 stmt: 1965 stmt: 1966 stmt: 1967 stmt: 1968 stmt: 1969 stmt: 1970 stmt: 1971 stmt: 1972 stmt: 1973 stmt: 1974 stmt: 1975 stmt: 1976 stmt: 1977 stmt: 1978 stmt: 1979 stmt: 1980 stmt: 1981 stmt: 1982 stmt: 1983 stmt: 1984 stmt: 1985 stmt: 1986 stmt: 1987 stmt: 1988 stmt: 1989 stmt: 1990 stmt: 1991 stmt: 1992 stmt: 1993 stmt: 1994 stmt: 1995 stmt: 1996 stmt: 1997 stmt: 1998 stmt: 1999 total rows: 2000 ##################################### 82 of (1/1): test_logs ##################################### id : 9876 name : MySQL - Open Source (20) name : '(1) name : "(1) name : my'sql'(7) name : my"sql"(7) ##################################### 83 of (1/1): test_cuted_rows ##################################### total warnings: 0 total warnings: 2 +---------+------+----------------------------+ | Level | Code | Message | +---------+------+----------------------------+ | Warning | 1048 | Column 'c1' cannot be null | | Warning | 1048 | Column 'c1' cannot be null | +---------+------+----------------------------+ 2 rows returned total warnings: 2 +---------+------+----------------------------------------------------------+ | Level | Code | Message | +---------+------+----------------------------------------------------------+ | Warning | 1366 | Incorrect integer value: 'junk' for column 'c1' at row 1 | | Warning | 1264 | Out of range value adjusted for column 'c1' at row 2 | +---------+------+----------------------------------------------------------+ 2 rows returned ##################################### 84 of (1/1): test_fetch_offset ##################################### [MySQL-5.0.82-log][2051] Attempt to read column without prior row fetch col 1: abcdefghij (10) col 1: fghij (10) col 0: j (10) [MySQL-5.0.82-log][2051] Attempt to read column without prior row fetch ##################################### 85 of (1/1): test_fetch_column ##################################### [MySQL-5.0.82-log][2051] Attempt to read column without prior row fetch row 0: 1, venu col 1: venu(4) col 1: venu(4) col 0: 1(4) row 1: 2, mysql col 1: mysql(5) col 1: mysqli(5) col 0: 2(4) [MySQL-5.0.82-log][2051] Attempt to read column without prior row fetch ##################################### 86 of (1/1): test_mem_overun ##################################### +------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+ | c0 | c1 | c2 | c3 | c4 | c5 | c6 | c7 | c8 | c9 | c10 | c11 | c12 | c13 | c14 | c15 | c16 | c17 | c18 | c19 | c20 | c21 | c22 | c23 | c24 | c25 | c26 | c27 | c28 | c29 | c30 | c31 | c32 | c33 | c34 | c35 | c36 | c37 | c38 | c39 | c40 | c41 | c42 | c43 | c44 | c45 | c46 | c47 | c48 | c49 | c50 | c51 | c52 | c53 | c54 | c55 | c56 | c57 | c58 | c59 | c60 | c61 | c62 | c63 | c64 | c65 | c66 | c67 | c68 | c69 | c70 | c71 | c72 | c73 | c74 | c75 | c76 | c77 | c78 | c79 | c80 | c81 | c82 | c83 | c84 | c85 | c86 | c87 | c88 | c89 | c90 | c91 | c92 | c93 | c94 | c95 | c96 | c97 | c98 | c99 | c100 | c101 | c102 | c103 | c104 | c105 | c106 | c107 | c108 | c109 | c110 | c111 | c112 | c113 | c114 | c115 | c116 | c117 | c118 | c119 | c120 | c121 | c122 | c123 | c124 | c125 | c126 | c127 | c128 | c129 | c130 | c131 | c132 | c133 | c134 | c135 | c136 | c137 | c138 | c139 | c140 | c141 | c142 | c143 | c144 | c145 | c146 | c147 | c148 | c149 | c150 | c151 | c152 | c153 | c154 | c155 | c156 | c157 | c158 | c159 | c160 | c161 | c162 | c163 | c164 | c165 | c166 | c167 | c168 | c169 | c170 | c171 | c172 | c173 | c174 | c175 | c176 | c177 | c178 | c179 | c180 | c181 | c182 | c183 | c184 | c185 | c186 | c187 | c188 | c189 | c190 | c191 | c192 | c193 | c194 | c195 | c196 | c197 | c198 | c199 | c200 | c201 | c202 | c203 | c204 | c205 | c206 | c207 | c208 | c209 | c210 | c211 | c212 | c213 | c214 | c215 | c216 | c217 | c218 | c219 | c220 | c221 | c222 | c223 | c224 | c225 | c226 | c227 | c228 | c229 | c230 | c231 | c232 | c233 | c234 | c235 | c236 | c237 | c238 | c239 | c240 | c241 | c242 | c243 | c244 | c245 | c246 | c247 | c248 | c249 | c250 | c251 | c252 | c253 | c254 | c255 | c256 | c257 | c258 | c259 | c260 | c261 | c262 | c263 | c264 | c265 | c266 | c267 | c268 | c269 | c270 | c271 | c272 | c273 | c274 | c275 | c276 | c277 | c278 | c279 | c280 | c281 | c282 | c283 | c284 | c285 | c286 | c287 | c288 | c289 | c290 | c291 | c292 | c293 | c294 | c295 | c296 | c297 | c298 | c299 | c300 | c301 | c302 | c303 | c304 | c305 | c306 | c307 | c308 | c309 | c310 | c311 | c312 | c313 | c314 | c315 | c316 | c317 | c318 | c319 | c320 | c321 | c322 | c323 | c324 | c325 | c326 | c327 | c328 | c329 | c330 | c331 | c332 | c333 | c334 | c335 | c336 | c337 | c338 | c339 | c340 | c341 | c342 | c343 | c344 | c345 | c346 | c347 | c348 | c349 | c350 | c351 | c352 | c353 | c354 | c355 | c356 | c357 | c358 | c359 | c360 | c361 | c362 | c363 | c364 | c365 | c366 | c367 | c368 | c369 | c370 | c371 | c372 | c373 | c374 | c375 | c376 | c377 | c378 | c379 | c380 | c381 | c382 | c383 | c384 | c385 | c386 | c387 | c388 | c389 | c390 | c391 | c392 | c393 | c394 | c395 | c396 | c397 | c398 | c399 | c400 | c401 | c402 | c403 | c404 | c405 | c406 | c407 | c408 | c409 | c410 | c411 | c412 | c413 | c414 | c415 | c416 | c417 | c418 | c419 | c420 | c421 | c422 | c423 | c424 | c425 | c426 | c427 | c428 | c429 | c430 | c431 | c432 | c433 | c434 | c435 | c436 | c437 | c438 | c439 | c440 | c441 | c442 | c443 | c444 | c445 | c446 | c447 | c448 | c449 | c450 | c451 | c452 | c453 | c454 | c455 | c456 | c457 | c458 | c459 | c460 | c461 | c462 | c463 | c464 | c465 | c466 | c467 | c468 | c469 | c470 | c471 | c472 | c473 | c474 | c475 | c476 | c477 | c478 | c479 | c480 | c481 | c482 | c483 | c484 | c485 | c486 | c487 | c488 | c489 | c490 | c491 | c492 | c493 | c494 | c495 | c496 | c497 | c498 | c499 | c500 | c501 | c502 | c503 | c504 | c505 | c506 | c507 | c508 | c509 | c510 | c511 | c512 | c513 | c514 | c515 | c516 | c517 | c518 | c519 | c520 | c521 | c522 | c523 | c524 | c525 | c526 | c527 | c528 | c529 | c530 | c531 | c532 | c533 | c534 | c535 | c536 | c537 | c538 | c539 | c540 | c541 | c542 | c543 | c544 | c545 | c546 | c547 | c548 | c549 | c550 | c551 | c552 | c553 | c554 | c555 | c556 | c557 | c558 | c559 | c560 | c561 | c562 | c563 | c564 | c565 | c566 | c567 | c568 | c569 | c570 | c571 | c572 | c573 | c574 | c575 | c576 | c577 | c578 | c579 | c580 | c581 | c582 | c583 | c584 | c585 | c586 | c587 | c588 | c589 | c590 | c591 | c592 | c593 | c594 | c595 | c596 | c597 | c598 | c599 | c600 | c601 | c602 | c603 | c604 | c605 | c606 | c607 | c608 | c609 | c610 | c611 | c612 | c613 | c614 | c615 | c616 | c617 | c618 | c619 | c620 | c621 | c622 | c623 | c624 | c625 | c626 | c627 | c628 | c629 | c630 | c631 | c632 | c633 | c634 | c635 | c636 | c637 | c638 | c639 | c640 | c641 | c642 | c643 | c644 | c645 | c646 | c647 | c648 | c649 | c650 | c651 | c652 | c653 | c654 | c655 | c656 | c657 | c658 | c659 | c660 | c661 | c662 | c663 | c664 | c665 | c666 | c667 | c668 | c669 | c670 | c671 | c672 | c673 | c674 | c675 | c676 | c677 | c678 | c679 | c680 | c681 | c682 | c683 | c684 | c685 | c686 | c687 | c688 | c689 | c690 | c691 | c692 | c693 | c694 | c695 | c696 | c697 | c698 | c699 | c700 | c701 | c702 | c703 | c704 | c705 | c706 | c707 | c708 | c709 | c710 | c711 | c712 | c713 | c714 | c715 | c716 | c717 | c718 | c719 | c720 | c721 | c722 | c723 | c724 | c725 | c726 | c727 | c728 | c729 | c730 | c731 | c732 | c733 | c734 | c735 | c736 | c737 | c738 | c739 | c740 | c741 | c742 | c743 | c744 | c745 | c746 | c747 | c748 | c749 | c750 | c751 | c752 | c753 | c754 | c755 | c756 | c757 | c758 | c759 | c760 | c761 | c762 | c763 | c764 | c765 | c766 | c767 | c768 | c769 | c770 | c771 | c772 | c773 | c774 | c775 | c776 | c777 | c778 | c779 | c780 | c781 | c782 | c783 | c784 | c785 | c786 | c787 | c788 | c789 | c790 | c791 | c792 | c793 | c794 | c795 | c796 | c797 | c798 | c799 | c800 | c801 | c802 | c803 | c804 | c805 | c806 | c807 | c808 | c809 | c810 | c811 | c812 | c813 | c814 | c815 | c816 | c817 | c818 | c819 | c820 | c821 | c822 | c823 | c824 | c825 | c826 | c827 | c828 | c829 | c830 | c831 | c832 | c833 | c834 | c835 | c836 | c837 | c838 | c839 | c840 | c841 | c842 | c843 | c844 | c845 | c846 | c847 | c848 | c849 | c850 | c851 | c852 | c853 | c854 | c855 | c856 | c857 | c858 | c859 | c860 | c861 | c862 | c863 | c864 | c865 | c866 | c867 | c868 | c869 | c870 | c871 | c872 | c873 | c874 | c875 | c876 | c877 | c878 | c879 | c880 | c881 | c882 | c883 | c884 | c885 | c886 | c887 | c888 | c889 | c890 | c891 | c892 | c893 | c894 | c895 | c896 | c897 | c898 | c899 | c900 | c901 | c902 | c903 | c904 | c905 | c906 | c907 | c908 | c909 | c910 | c911 | c912 | c913 | c914 | c915 | c916 | c917 | c918 | c919 | c920 | c921 | c922 | c923 | c924 | c925 | c926 | c927 | c928 | c929 | c930 | c931 | c932 | c933 | c934 | c935 | c936 | c937 | c938 | c939 | c940 | c941 | c942 | c943 | c944 | c945 | c946 | c947 | c948 | c949 | c950 | c951 | c952 | c953 | c954 | c955 | c956 | c957 | c958 | c959 | c960 | c961 | c962 | c963 | c964 | c965 | c966 | c967 | c968 | c969 | c970 | c971 | c972 | c973 | c974 | c975 | c976 | c977 | c978 | c979 | c980 | c981 | c982 | c983 | c984 | c985 | c986 | c987 | c988 | c989 | c990 | c991 | c992 | c993 | c994 | c995 | c996 | c997 | c998 | c999 | +------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+ | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | +------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+ 1 row returned total fields : 1000 ##################################### 87 of (1/1): test_list_fields ##################################### +----+------+ | c1 | c2 | +----+------+ 0 rows returned field[0]: name :`c1` (expected: `c1`) org_name :`c1` (expected: `c1`) type :`3` (expected: `3`) table :`t1` (expected: `t1`) org_table:`t1` (expected: `t1`) database :`client_test_db` (expected: `client_test_db`) length :`11` (expected: `11`) maxlength:`2` charsetnr:`63` default :`0` (expected: `0`) field[1]: name :`c2` (expected: `c2`) org_name :`c2` (expected: `c2`) type :`254` (expected: `254`) table :`t1` (expected: `t1`) org_table:`t1` (expected: `t1`) database :`client_test_db` (expected: `client_test_db`) length :`10` (expected: `10`) maxlength:`4` charsetnr:`8` default :`mysql` (expected: `mysql`) ##################################### 88 of (1/1): test_free_result ##################################### col 0: 1(1) col 0: 2(4) [MySQL-5.0.82-log][2014] Commands out of sync; you can't run this command now ##################################### 89 of (1/1): test_free_store_result ##################################### col 1: 1(1) col 0: 2(4) ##################################### 90 of (1/1): test_sqlmode ##################################### With SET SQL_MODE= "PIPES_AS_CONCAT" query: INSERT INTO test_piping VALUES(?||?) total parameters: 2 SELECT name FROM test_piping LIMIT 1 query: SELECT connection_id () With SET SQL_MODE= "ANSI" query: INSERT INTO test_piping VALUES(?||?) total parameters: 2 SELECT name FROM test_piping LIMIT 1 query: SELECT connection_id () returned 1 row With SET SQL_MODE= "IGNORE_SPACE" query: SELECT connection_id () returned 1 row ##################################### 91 of (1/1): test_ts ##################################### SELECT a FROM test_ts LIMIT 1 SELECT b FROM test_ts LIMIT 1 SELECT c FROM test_ts LIMIT 1 +------------+------------+--------------------------------+ | a | b | c | +------------+------------+--------------------------------+ | 2003-07-12 | 21:07:46 | 2003-07-12 21:07:46 | | 2003-07-12 | 21:07:46 | 2003-07-12 21:07:46 | +------------+------------+--------------------------------+ 2 rows returned SELECT a, b, c FROM test_ts WHERE a=CAST(? AS DATE) returned '2' rows SELECT a, b, c FROM test_ts WHERE b=? returned '2' rows SELECT a, b, c FROM test_ts WHERE c=? returned '2' rows ##################################### 92 of (1/1): test_bug1115 ##################################### total parameters in stmt: `1` (expected: `1`) +------------+-------------+-------------+-------------+--------------------------------+ | session_id | a | b | c | d | +------------+-------------+-------------+-------------+--------------------------------+ | abc | 1 | 2 | 3 | 0000-00-00 00:00:00 | +------------+-------------+-------------+-------------+--------------------------------+ 1 row returned +------------+-------------+-------------+-------------+--------------------------------+ | session_id | a | b | c | d | +------------+-------------+-------------+-------------+--------------------------------+ 0 rows returned +------------+-------------+-------------+-------------+--------------------------------+ | session_id | a | b | c | d | +------------+-------------+-------------+-------------+--------------------------------+ | abc | 1 | 2 | 3 | 0000-00-00 00:00:00 | +------------+-------------+-------------+-------------+--------------------------------+ 1 row returned ##################################### 93 of (1/1): test_select_bug ##################################### total parameters in stmt: `1` (expected: `1`) +------------+ | session_id | +------------+ 0 rows returned +------------+ | session_id | +------------+ | abc | +------------+ 1 row returned +------------+ | session_id | +------------+ 0 rows returned ##################################### 94 of (1/1): test_bug1500 ##################################### total parameters in stmt: `3` (expected: `3`) +-------------+ | i | +-------------+ | 2 | +-------------+ 1 row returned total parameters in stmt: `1` (expected: `1`) +-------------+ | s | +-------------+ | Hollow Dogs | +-------------+ 1 row returned total parameters in stmt: `1` (expected: `1`) +-------------+ | s | +-------------+ | Gravedigger | +-------------+ 1 row returned ##################################### 95 of (1/1): test_bug1644 ##################################### total parameters in stmt: `4` (expected: `4`) +------+------+------+------+ | col1 | col2 | col3 | col4 | +------+------+------+------+ | 22 | 22 | 22 | 22 | | NULL | NULL | NULL | NULL | | 88 | 88 | 88 | 88 | +------+------+------+------+ 3 rows returned ##################################### 96 of (1/1): test_bug1946 ##################################### Got error (as expected): [MySQL-5.0.82-log][1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?)' at line 1 ##################################### 97 of (1/1): test_bug2248 ##################################### [MySQL-5.0.82-log][2053] Attempt to read a row while there is no result set associated with the statement [MySQL-5.0.82-log][2014] Commands out of sync; you can't run this command now [MySQL-5.0.82-log][2053] Attempt to read a row while there is no result set associated with the statement ##################################### 98 of (1/1): test_parse_error_and_bad_length ##################################### Got error (as expected): 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATABAAAA' at line 1' Got error (as expected): 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1' Got error (as expected): '' Got error (as expected): 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1' ##################################### 99 of (1/1): test_bug2247 ##################################### Checking if stmt_affected_rows is not affected by mysql_query ... OK ##################################### 100 of (1/1): test_subqueries ##################################### +----------+-----------------------+-----------------------+-----------------------+ | scalar_s | exists_s | in_s | in_row_s | +----------+-----------------------+-----------------------+-----------------------+ | 2 | 1 | 0 | 0 | | 4 | 1 | 0 | 1 | | 6 | 0 | 0 | 1 | | 8 | 0 | 1 | 1 | | 10 | 0 | 1 | 1 | +----------+-----------------------+-----------------------+-----------------------+ 5 rows returned +----------+-----------------------+-----------------------+-----------------------+ | scalar_s | exists_s | in_s | in_row_s | +----------+-----------------------+-----------------------+-----------------------+ | 2 | 1 | 0 | 0 | | 4 | 1 | 0 | 1 | | 6 | 0 | 0 | 1 | | 8 | 0 | 1 | 1 | | 10 | 0 | 1 | 1 | +----------+-----------------------+-----------------------+-----------------------+ 5 rows returned +----------+-----------------------+-----------------------+-----------------------+ | scalar_s | exists_s | in_s | in_row_s | +----------+-----------------------+-----------------------+-----------------------+ | 2 | 1 | 0 | 0 | | 4 | 1 | 0 | 1 | | 6 | 0 | 0 | 1 | | 8 | 0 | 1 | 1 | | 10 | 0 | 1 | 1 | +----------+-----------------------+-----------------------+-----------------------+ 5 rows returned ##################################### 101 of (1/1): test_bad_union ##################################### ##################################### 102 of (1/1): test_distinct ##################################### +-----------------------+-----------------+ | 2+count(distinct b) | group_concat(a) | +-----------------------+-----------------+ | 4 | 1,1 | | 4 | 2,2 | | 4 | 3,3 | | 4 | 4,4 | | 4 | 5,5 | +-----------------------+-----------------+ 5 rows returned +-----------------------+-----------------+ | 2+count(distinct b) | group_concat(a) | +-----------------------+-----------------+ | 4 | 1,1 | | 4 | 2,2 | | 4 | 3,3 | | 4 | 4,4 | | 4 | 5,5 | +-----------------------+-----------------+ 5 rows returned +-----------------------+-----------------+ | 2+count(distinct b) | group_concat(a) | +-----------------------+-----------------+ | 4 | 1,1 | | 4 | 2,2 | | 4 | 3,3 | | 4 | 4,4 | | 4 | 5,5 | +-----------------------+-----------------+ 5 rows returned ##################################### 103 of (1/1): test_subqueries_ref ##################################### +-------------+ | ccc | +-------------+ | 1 | +-------------+ 1 row returned +-------------+ | ccc | +-------------+ | 1 | +-------------+ 1 row returned +-------------+ | ccc | +-------------+ | 1 | +-------------+ 1 row returned ##################################### 104 of (1/1): test_union ##################################### +---------------+ | name | +---------------+ | Ja | | Ede | | Haag | | Kabul | | Almere | | Utrecht | | Qandahar | | Amsterdam | | Amersfoort | | Constantine | | Guam | | Aruba | | Angola | | Albania | | Anguilla | | Argentina | | Azerbaijan | | Afghanistan | | Burkina Faso | | Faroe Islands | +---------------+ 20 rows returned ##################################### 105 of (1/1): test_bug3117 ##################################### LAST_INSERT_ID()= 1 ok LAST_INSERT_ID()= 2 ok ##################################### 106 of (1/1): test_join ##################################### +-------------+-------------+-------------+-------------+ | a | c | a | b | +-------------+-------------+-------------+-------------+ | 1 | 1 | 1 | 1 | | 2 | 2 | 2 | 2 | | 3 | 3 | 3 | 3 | | 4 | 4 | 4 | 4 | | 5 | 5 | 5 | 5 | +-------------+-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+-------------+ | a | c | a | b | +-------------+-------------+-------------+-------------+ | 1 | 1 | 1 | 1 | | 2 | 2 | 2 | 2 | | 3 | 3 | 3 | 3 | | 4 | 4 | 4 | 4 | | 5 | 5 | 5 | 5 | +-------------+-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+-------------+ | a | c | a | b | +-------------+-------------+-------------+-------------+ | 1 | 1 | 1 | 1 | | 2 | 2 | 2 | 2 | | 3 | 3 | 3 | 3 | | 4 | 4 | 4 | 4 | | 5 | 5 | 5 | 5 | +-------------+-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | c | b | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | c | b | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | c | b | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | c | b | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | c | b | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | c | b | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+-------------+ | a | c | a | b | +-------------+-------------+-------------+-------------+ | 1 | 1 | 1 | 1 | | 2 | 2 | 2 | 2 | | 3 | 3 | 3 | 3 | | 4 | 4 | 4 | 4 | | 5 | 5 | 5 | 5 | +-------------+-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+-------------+ | a | c | a | b | +-------------+-------------+-------------+-------------+ | 1 | 1 | 1 | 1 | | 2 | 2 | 2 | 2 | | 3 | 3 | 3 | 3 | | 4 | 4 | 4 | 4 | | 5 | 5 | 5 | 5 | +-------------+-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+-------------+ | a | c | a | b | +-------------+-------------+-------------+-------------+ | 1 | 1 | 1 | 1 | | 2 | 2 | 2 | 2 | | 3 | 3 | 3 | 3 | | 4 | 4 | 4 | 4 | | 5 | 5 | 5 | 5 | +-------------+-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | c | b | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | c | b | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | c | b | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | c | b | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | c | b | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | c | b | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+-------------+ | a | c | a | b | +-------------+-------------+-------------+-------------+ | 1 | 1 | 1 | 1 | | 2 | 2 | 2 | 2 | | 3 | 3 | 3 | 3 | | 4 | 4 | 4 | 4 | | 5 | 5 | 5 | 5 | +-------------+-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+-------------+ | a | c | a | b | +-------------+-------------+-------------+-------------+ | 1 | 1 | 1 | 1 | | 2 | 2 | 2 | 2 | | 3 | 3 | 3 | 3 | | 4 | 4 | 4 | 4 | | 5 | 5 | 5 | 5 | +-------------+-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+-------------+ | a | c | a | b | +-------------+-------------+-------------+-------------+ | 1 | 1 | 1 | 1 | | 2 | 2 | 2 | 2 | | 3 | 3 | 3 | 3 | | 4 | 4 | 4 | 4 | | 5 | 5 | 5 | 5 | +-------------+-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | b | c | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | b | c | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | b | c | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | b | c | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | b | c | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned +-------------+-------------+-------------+ | a | b | c | +-------------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | | 3 | 3 | 3 | | 4 | 4 | 4 | | 5 | 5 | 5 | +-------------+-------------+-------------+ 5 rows returned ##################################### 107 of (1/1): test_select_tmp ##################################### +-------------+-----------------------------------------------------------------------------------------------------------------------------------+ | a | (select count(distinct t1.b) as sum from t1, t2 where t1.a=t2.a and t2.b > 0 and t1.a <= t3.b group by t1.a order by sum limit 1) | +-------------+-----------------------------------------------------------------------------------------------------------------------------------+ | 3 | 1 | | 2 | 2 | | 1 | 2 | +-------------+-----------------------------------------------------------------------------------------------------------------------------------+ 3 rows returned +-------------+-----------------------------------------------------------------------------------------------------------------------------------+ | a | (select count(distinct t1.b) as sum from t1, t2 where t1.a=t2.a and t2.b > 0 and t1.a <= t3.b group by t1.a order by sum limit 1) | +-------------+-----------------------------------------------------------------------------------------------------------------------------------+ | 3 | 1 | | 2 | 2 | | 1 | 2 | +-------------+-----------------------------------------------------------------------------------------------------------------------------------+ 3 rows returned +-------------+-----------------------------------------------------------------------------------------------------------------------------------+ | a | (select count(distinct t1.b) as sum from t1, t2 where t1.a=t2.a and t2.b > 0 and t1.a <= t3.b group by t1.a order by sum limit 1) | +-------------+-----------------------------------------------------------------------------------------------------------------------------------+ | 3 | 1 | | 2 | 2 | | 1 | 2 | +-------------+-----------------------------------------------------------------------------------------------------------------------------------+ 3 rows returned ##################################### 108 of (1/1): test_table_manipulation ##################################### created 0 +-------------------------+ | a in (select a from t2) | +-------------------------+ 0 rows returned dropped 0 created select 0 +-------------------------+ | a in (select a from t2) | +-------------------------+ | 1 | | 1 | | 1 | +-------------------------+ 3 rows returned dropped 0 created 1 +-------------------------+ | a in (select a from t2) | +-------------------------+ 0 rows returned dropped 1 created select 1 +-------------------------+ | a in (select a from t2) | +-------------------------+ | 1 | | 1 | | 1 | +-------------------------+ 3 rows returned dropped 1 created 2 +-------------------------+ | a in (select a from t2) | +-------------------------+ 0 rows returned dropped 2 created select 2 +-------------------------+ | a in (select a from t2) | +-------------------------+ | 1 | | 1 | | 1 | +-------------------------+ 3 rows returned dropped 2 ##################################### 109 of (1/1): test_table_manipulation ##################################### [MySQL-5.0.82-log][1017] Can't find file: './client_test_db/t3.frm' (errno: 2) rename without t3 rename with t3 [MySQL-5.0.82-log][1050] Table 't2' already exists rename renamed rename reverted ##################################### 110 of (1/1): test_do_set ##################################### do 0 set 0 do 1 set 1 do 2 set 2 ##################################### 111 of (1/1): test_multi ##################################### update 1 delete 1 +-------------+-------------+ | a | b | +-------------+-------------+ | 3 | 3 | | 2 | 2 | +-------------+-------------+ 2 rows returned +-------------+-------------+ | a | b | +-------------+-------------+ | 3 | 3 | | 2 | 2 | +-------------+-------------+ 2 rows returned update 2 delete 2 +-------------+-------------+ | a | b | +-------------+-------------+ | 3 | 3 | +-------------+-------------+ 1 row returned +-------------+-------------+ | a | b | +-------------+-------------+ | 3 | 3 | +-------------+-------------+ 1 row returned update 3 delete 3 +-------------+-------------+ | a | b | +-------------+-------------+ 0 rows returned +-------------+-------------+ | a | b | +-------------+-------------+ 0 rows returned ##################################### 112 of (1/1): test_insert_select ##################################### insert 0 +-------------+ | a | +-------------+ | 1 | +-------------+ 1 row returned insert 1 +-------------+ | a | +-------------+ | 1 | | 1 | +-------------+ 2 rows returned insert 2 +-------------+ | a | +-------------+ | 1 | | 1 | | 1 | +-------------+ 3 rows returned ##################################### 113 of (1/1): test_insert_select ##################################### ##################################### 114 of (1/1): test_derived ##################################### +-----------------------+ | count(1) | +-----------------------+ | 1 | +-----------------------+ 1 row returned +-----------------------+ | count(1) | +-----------------------+ | 1 | +-----------------------+ 1 row returned +-----------------------+ | count(1) | +-----------------------+ | 1 | +-----------------------+ 1 row returned ##################################### 115 of (1/1): test_xjoin ##################################### +-------------+-------+-------+-------+-------+ | id | value | value | value | value | +-------------+-------+-------+-------+-------+ | 1 | aaa | Name1 | ccc | NULL | +-------------+-------+-------+-------+-------+ 1 row returned +-------------+-------+-------+-------+-------+ | id | value | value | value | value | +-------------+-------+-------+-------+-------+ | 1 | aaa | Name1 | ccc | NULL | +-------------+-------+-------+-------+-------+ 1 row returned +-------------+-------+-------+-------+-------+ | id | value | value | value | value | +-------------+-------+-------+-------+-------+ | 1 | aaa | Name1 | ccc | NULL | +-------------+-------+-------+-------+-------+ 1 row returned ##################################### 116 of (1/1): test_bug3035 ##################################### Truncation mask: 000000001000 ##################################### 117 of (1/1): test_union2 ##################################### +-------------+ | col1 | +-------------+ 0 rows returned +-------------+ | col1 | +-------------+ 0 rows returned +-------------+ | col1 | +-------------+ 0 rows returned ##################################### 118 of (1/1): test_bug1664 ##################################### total parameters in stmt: `2` (expected: `2`) SELECT col1 FROM test_long_data LIMIT 1 SELECT col2 FROM test_long_data LIMIT 1 SELECT col1 FROM test_long_data LIMIT 1 SELECT col2 FROM test_long_data LIMIT 1 SELECT col1 FROM test_long_data LIMIT 1 SELECT col2 FROM test_long_data LIMIT 1 SELECT col1 FROM test_long_data LIMIT 1 SELECT col2 FROM test_long_data LIMIT 1 SELECT col1 FROM test_long_data LIMIT 1 SELECT col2 FROM test_long_data LIMIT 1 ##################################### 119 of (1/1): test_union_param ##################################### +--------+ | my_col | +--------+ | abc | +--------+ 1 row returned +--------+ | my_col | +--------+ | abc | +--------+ 1 row returned +--------+ | my_col | +--------+ | abc | +--------+ 1 row returned ##################################### 120 of (1/1): test_order_param ##################################### ##################################### 121 of (1/1): test_ps_i18n ##################################### ##################################### 122 of (1/1): test_bug3796 ##################################### Concat result: 'concat_with_ONE' Concat result: 'concat_with_TWO' ##################################### 123 of (1/1): test_bug4026 ##################################### 23:59:59.123456 2003-12-31 23:59:59.123456 ##################################### 124 of (1/1): test_bug4079 ##################################### Got error from mysql_stmt_fetch (as expected): Subquery returns more than 1 row ##################################### 125 of (1/1): test_bug4296 ##################################### ##################################### 126 of (1/1): test_bug4030 ##################################### 23:59:59.123456 2003-12-31 2003-12-31 23:59:59.123456 ##################################### 127 of (1/1): test_bug5126 ##################################### 8386608, 1 ##################################### 128 of (1/1): test_bug4231 ##################################### ##################################### 129 of (1/1): test_bug5399 ##################################### 97 statements prepared. ##################################### 130 of (1/1): test_bug5194 ##################################### Insert: query length= 197044, row count= 262, param count= 65500 Failed to prepare a statement with 65750 placeholders (as expected). ##################################### 131 of (1/1): test_bug5315 ##################################### Got error (as expected): Lost connection to MySQL server during query ##################################### 132 of (1/1): test_bug6049 ##################################### Result from query: -25:12:12 Result from prepared statement: -25:12:12 ##################################### 133 of (1/1): test_bug6058 ##################################### Result from query: 0000-00-00 Result from prepared statement: 0000-00-00 ##################################### 134 of (1/1): test_bug6059 ##################################### ##################################### 135 of (1/1): test_bug6046 ##################################### ##################################### 136 of (1/1): test_bug6081 ##################################### [MySQL-5.0.82-log][1008] Can't drop database 'client_test_db'; database doesn't exist [MySQL-5.0.82-log][1007] Can't create database 'client_test_db'; database exists ##################################### 137 of (1/1): test_bug6096 ##################################### ------------------------------------------------------------ | Metadata ------------------------------------------------------------ | Query | Prepared statement ------------------------------------------------------------ field name | length | max_length | length | max_length ------------------------------------------------------------ c_tinyint | 4 | 4 | 4 | 4 c_smallint | 6 | 6 | 6 | 6 c_mediumint | 9 | 7 | 9 | 9 c_int | 11 | 1 | 11 | 11 c_bigint | 20 | 1 | 20 | 21 c_float | 12 | 1 | 12 | 331 c_double | 22 | 1 | 22 | 331 c_varchar | 20 | 3 | 20 | 3 c_char | 20 | 3 | 20 | 3 c_time | 8 | 8 | 8 | 10 c_date | 10 | 10 | 10 | 10 c_datetime | 19 | 19 | 19 | 30 --------------------------------------------------------------- ##################################### 138 of (1/1): test_datetime_ranges ##################################### total parameters in stmt: `6` (expected: `6`) SELECT year FROM t1 LIMIT 1 SELECT month FROM t1 LIMIT 1 SELECT day FROM t1 LIMIT 1 SELECT hour FROM t1 LIMIT 1 SELECT min FROM t1 LIMIT 1 SELECT sec FROM t1 LIMIT 1 total parameters in stmt: `3` (expected: `3`) SELECT year FROM t1 LIMIT 1 SELECT month FROM t1 LIMIT 1 SELECT day FROM t1 LIMIT 1 total parameters in stmt: `5` (expected: `5`) SELECT day_ovfl FROM t1 LIMIT 1 SELECT day FROM t1 LIMIT 1 SELECT hour FROM t1 LIMIT 1 SELECT min FROM t1 LIMIT 1 SELECT sec FROM t1 LIMIT 1 ##################################### 139 of (1/1): test_bug4172 ##################################### Binary protocol: float=12345.1, double=123456.123456, decimal(10,4)=123456.1234 Text protocol: float=12345.1, double=123456.123456, decimal(10,4)=123456.1234 ##################################### 140 of (1/1): test_conversion ##################################### ##################################### 141 of (1/1): test_rewind ##################################### fetched result:2 fetched result:3 fetched result:4 fetched result after seek:2 fetched result after seek:3 fetched result after seek:4 ##################################### 142 of (1/1): test_bug6761 ##################################### ##################################### 143 of (1/1): test_view ##################################### +-----------------------+ | COUNT(*) | +-----------------------+ | 0 | +-----------------------+ 1 row returned +-----------------------+ | COUNT(*) | +-----------------------+ | 0 | +-----------------------+ 1 row returned +-----------------------+ | COUNT(*) | +-----------------------+ | 0 | +-----------------------+ 1 row returned ##################################### 144 of (1/1): test_view_where ##################################### +-------------+-------------+ | c | c | +-------------+-------------+ | 2 | 10 | | 3 | 10 | | 4 | 10 | | 5 | 10 | +-------------+-------------+ 4 rows returned +-------------+-------------+ | c | c | +-------------+-------------+ | 2 | 10 | | 3 | 10 | | 4 | 10 | | 5 | 10 | +-------------+-------------+ 4 rows returned +-------------+-------------+ | c | c | +-------------+-------------+ | 2 | 10 | | 3 | 10 | | 4 | 10 | | 5 | 10 | +-------------+-------------+ 4 rows returned ##################################### 145 of (1/1): test_view_2where ##################################### +-------+--------+--------+-----------+----------+---------+------+---------+--------+---------+---------+-------+--------+--------+------------+----------+ | RELID | REPORT | HANDLE | LOG_GROUP | USERNAME | VARIANT | TYPE | VERSION | ERFDAT | ERFTIME | ERFNAME | AEDAT | AETIME | AENAME | DEPENDVARS | INACTIVE | +-------+--------+--------+-----------+----------+---------+------+---------+--------+---------+---------+-------+--------+--------+------------+----------+ 0 rows returned ##################################### 146 of (1/1): test_view_star ##################################### +-------------+ | a | +-------------+ 0 rows returned +-------------+ | a | +-------------+ 0 rows returned +-------------+ | a | +-------------+ 0 rows returned ##################################### 147 of (1/1): test_view_insert ##################################### +-------------+ | a | +-------------+ | 0 | +-------------+ 1 row returned +-------------+ | a | +-------------+ | 0 | | 1 | +-------------+ 2 rows returned +-------------+ | a | +-------------+ | 0 | | 1 | | 2 | +-------------+ 3 rows returned ##################################### 148 of (1/1): test_left_join_view ##################################### +-------------+-------------+ | a | x | +-------------+-------------+ | 1 | NULL | | 2 | 2 | | 3 | 3 | +-------------+-------------+ 3 rows returned +-------------+-------------+ | a | x | +-------------+-------------+ | 1 | NULL | | 2 | 2 | | 3 | 3 | +-------------+-------------+ 3 rows returned +-------------+-------------+ | a | x | +-------------+-------------+ | 1 | NULL | | 2 | 2 | | 3 | 3 | +-------------+-------------+ 3 rows returned ##################################### 149 of (1/1): test_view_insert_fields ##################################### +------+------+------+------+------+-------------+-------+-------------+----------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+ | K1C4 | K2C4 | K3C4 | K4N4 | F1C4 | F2I4 | F3N5 | F4I4 | F5C8 | F6N4 | F7F8 | F8F8 | F9D8 | +------+------+------+------+------+-------------+-------+-------------+----------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+ | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 0 | 1.00 | +------+------+------+------+------+-------------+-------+-------------+----------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------+ 1 row returned ##################################### 150 of (1/1): test_basic_cursors ##################################### Stmt 0 fetched row 1: column 1: 2 column 2: Ja Stmt 1 fetched row 1: column 1: 4 column 2: Guam Stmt 0 fetched row 2: column 1: 3 column 2: Ede Stmt 1 fetched row 2: column 1: 5 column 2: Aruba Stmt 0 fetched row 3: column 1: 4 column 2: Haag Stmt 1 fetched row 3: column 1: 6 column 2: Angola Stmt 0 fetched row 4: column 1: 5 column 2: Kabul Stmt 1 fetched row 4: column 1: 7 column 2: Albania Stmt 0 fetched row 5: column 1: 6 column 2: Almere Stmt 1 fetched row 5: column 1: 8 column 2: Anguilla Stmt 0 fetched row 6: column 1: 7 column 2: Utrecht Stmt 1 fetched row 6: column 1: 9 column 2: Argentina Stmt 0 fetched row 7: column 1: 8 column 2: Qandahar Stmt 1 fetched row 7: column 1: 10 column 2: Azerbaijan Stmt 0 fetched row 8: column 1: 9 column 2: Amsterdam Stmt 1 fetched row 8: column 1: 11 column 2: Afghanistan Stmt 0 fetched row 9: column 1: 10 column 2: Amersfoort Stmt 1 fetched row 9: column 1: 12 column 2: Burkina Faso Stmt 0 fetched row 10: column 1: 11 column 2: Constantine Stmt 1 fetched row 10: column 1: 13 column 2: Faroe Islands Success, total rows fetched: 20 Stmt 0 fetched row 1: column 1: 2 column 2: Ja Stmt 1 fetched row 1: column 1: 4 column 2: Guam Stmt 0 fetched row 2: column 1: 3 column 2: Ede Stmt 1 fetched row 2: column 1: 5 column 2: Aruba Stmt 0 fetched row 3: column 1: 4 column 2: Haag Stmt 1 fetched row 3: column 1: 6 column 2: Angola Stmt 0 fetched row 4: column 1: 5 column 2: Kabul Stmt 1 fetched row 4: column 1: 7 column 2: Albania Stmt 0 fetched row 5: column 1: 6 column 2: Almere Stmt 1 fetched row 5: column 1: 8 column 2: Anguilla Stmt 0 fetched row 6: column 1: 7 column 2: Utrecht Stmt 1 fetched row 6: column 1: 9 column 2: Argentina Stmt 0 fetched row 7: column 1: 8 column 2: Qandahar Stmt 1 fetched row 7: column 1: 10 column 2: Azerbaijan Stmt 0 fetched row 8: column 1: 9 column 2: Amsterdam Stmt 1 fetched row 8: column 1: 11 column 2: Afghanistan Stmt 0 fetched row 9: column 1: 10 column 2: Amersfoort Stmt 1 fetched row 9: column 1: 12 column 2: Burkina Faso Stmt 0 fetched row 10: column 1: 11 column 2: Constantine Stmt 1 fetched row 10: column 1: 13 column 2: Faroe Islands Success, total rows fetched: 20 ##################################### 151 of (1/1): test_cursors_with_union ##################################### Stmt 0 fetched row 1: column 1: Ja Stmt 1 fetched row 1: column 1: 2 Stmt 0 fetched row 2: column 1: Ede Stmt 1 fetched row 2: column 1: 3 Stmt 0 fetched row 3: column 1: Haag Stmt 1 fetched row 3: column 1: 4 Stmt 0 fetched row 4: column 1: Kabul Stmt 0 fetched row 5: column 1: Almere Stmt 0 fetched row 6: column 1: Utrecht Stmt 0 fetched row 7: column 1: Qandahar Stmt 0 fetched row 8: column 1: Amsterdam Stmt 0 fetched row 9: column 1: Amersfoort Stmt 0 fetched row 10: column 1: Constantine Stmt 0 fetched row 11: column 1: Guam Stmt 0 fetched row 12: column 1: Aruba Stmt 0 fetched row 13: column 1: Angola Stmt 0 fetched row 14: column 1: Albania Stmt 0 fetched row 15: column 1: Anguilla Stmt 0 fetched row 16: column 1: Argentina Stmt 0 fetched row 17: column 1: Azerbaijan Stmt 0 fetched row 18: column 1: Afghanistan Stmt 0 fetched row 19: column 1: Burkina Faso Stmt 0 fetched row 20: column 1: Faroe Islands Success, total rows fetched: 23 Stmt 0 fetched row 1: column 1: Ja Stmt 1 fetched row 1: column 1: 2 Stmt 0 fetched row 2: column 1: Ede Stmt 1 fetched row 2: column 1: 3 Stmt 0 fetched row 3: column 1: Haag Stmt 1 fetched row 3: column 1: 4 Stmt 0 fetched row 4: column 1: Kabul Stmt 0 fetched row 5: column 1: Almere Stmt 0 fetched row 6: column 1: Utrecht Stmt 0 fetched row 7: column 1: Qandahar Stmt 0 fetched row 8: column 1: Amsterdam Stmt 0 fetched row 9: column 1: Amersfoort Stmt 0 fetched row 10: column 1: Constantine Stmt 0 fetched row 11: column 1: Guam Stmt 0 fetched row 12: column 1: Aruba Stmt 0 fetched row 13: column 1: Angola Stmt 0 fetched row 14: column 1: Albania Stmt 0 fetched row 15: column 1: Anguilla Stmt 0 fetched row 16: column 1: Argentina Stmt 0 fetched row 17: column 1: Azerbaijan Stmt 0 fetched row 18: column 1: Afghanistan Stmt 0 fetched row 19: column 1: Burkina Faso Stmt 0 fetched row 20: column 1: Faroe Islands Success, total rows fetched: 23 ##################################### 152 of (1/1): test_cursors_with_procedure ##################################### Stmt 0 fetched row 1: column 1: client_test_db.t1.id column 2: 2 column 3: 11 column 4: 1 column 5: 2 column 6: 0 column 7: 0 column 8: 6.5000 column 9: 2.8723 column 10: ENUM('2','3','4','5','6','7','8','9','10','11') NOT NULL Stmt 0 fetched row 2: column 1: client_test_db.t1.name column 2: Almere column 3: Utrecht column 4: 2 column 5: 11 column 6: 0 column 7: 0 column 8: 6.5000 column 9: 2.8723 column 10: ENUM('Almere','Amersfoort','Amsterdam','Constantine','Ede','Haag Success, total rows fetched: 2 Stmt 0 fetched row 1: column 1: client_test_db.t1.id column 2: 2 column 3: 11 column 4: 1 column 5: 2 column 6: 0 column 7: 0 column 8: 6.5000 column 9: 2.8723 column 10: ENUM('2','3','4','5','6','7','8','9','10','11') NOT NULL Stmt 0 fetched row 2: column 1: client_test_db.t1.name column 2: Almere column 3: Utrecht column 4: 2 column 5: 11 column 6: 0 column 7: 0 column 8: 6.5000 column 9: 2.8723 column 10: ENUM('Almere','Amersfoort','Amsterdam','Constantine','Ede','Haag Success, total rows fetched: 2 ##################################### 153 of (1/1): test_truncation ##################################### ##################################### 154 of (1/1): test_truncation_option ##################################### ##################################### 155 of (1/1): test_client_character_set ##################################### ##################################### 156 of (1/1): test_bug8330 ##################################### ##################################### 157 of (1/1): test_bug7990 ##################################### ##################################### 158 of (1/1): test_bug8378 ##################################### Establishing a test connection ... OK ##################################### 159 of (1/1): test_bug8722 ##################################### ##################################### 160 of (1/1): test_bug8880 ##################################### ##################################### 161 of (1/1): test_bug9159 ##################################### ##################################### 162 of (1/1): test_bug9520 ##################################### Fetched 3 rows ##################################### 163 of (1/1): test_bug9478 ##################################### Fetched row: bbb Fetched row: bbb Got error (as expected): The statement (2368) has no open cursor. Fetched row: bbb Got error (as expected): Attempt to read a row while there is no result set associated with the statement Fetched row: aaa Fetched row: aaa Fetched row: bbb Fetched row: ccc Fetched row: aaa Got error (as expected): Attempt to read a row while there is no result set associated with the statement ##################################### 164 of (1/1): test_bug9643 ##################################### Got error (as expected): This feature is not implemented yet ##################################### 165 of (1/1): test_bug10729 ##################################### 0: aaa 1: bbb 2: ccc 0: aaa 1: bbb 2: ccc 0: aaa 1: bbb 2: ccc ##################################### 166 of (1/1): test_bug11111 ##################################### return: 1 ##################################### 167 of (1/1): test_bug9992 ##################################### Establishing a connection with option CLIENT_MULTI_STATEMENTS.. Testing mysql_store_result/mysql_next_result.. Got error, as expected: [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATABASE; SELECT 1' at line 1 ##################################### 168 of (1/1): test_bug10736 ##################################### 0: bbb 0: bbb 0: bbb ##################################### 169 of (1/1): test_bug10794 ##################################### Fetched row from stmt: a0 Fetched row from stmt1: a0 End of data in stmt1 ##################################### 170 of (1/1): test_bug11172 ##################################### fetched data 2:1965-1-1 fetched data 2:1965-1-1 fetched data 2:1965-1-1 ##################################### 171 of (1/1): test_bug11656 ##################################### ##################################### 172 of (1/1): test_bug10214 ##################################### ##################################### 173 of (1/1): test_bug9735 ##################################### field[0]: name :`a` (expected: `a`) org_name :`a` (expected: `a`) type :`252` (expected: `252`) table :`t1` (expected: `t1`) org_table:`t1` (expected: `t1`) database :`client_test_db` (expected: `client_test_db`) length :`16777215` (expected: `16777215`) maxlength:`0` charsetnr:`8` default :`(null)` (expected: `(null)`) field[1]: name :`b` (expected: `b`) org_name :`b` (expected: `b`) type :`252` (expected: `252`) table :`t1` (expected: `t1`) org_table:`t1` (expected: `t1`) database :`client_test_db` (expected: `client_test_db`) length :`4294967295` (expected: `4294967295`) maxlength:`0` charsetnr:`8` default :`(null)` (expected: `(null)`) ##################################### 174 of (1/1): test_bug11183 ##################################### ##################################### 175 of (1/1): test_bug11037 ##################################### Got error, as expected: [2053] Attempt to read a row while there is no result set associated with the statement ##################################### 176 of (1/1): test_bug10760 ##################################### Fetched row 101 ##################################### 177 of (1/1): test_bug12001 ##################################### ##################################### 178 of (1/1): test_bug11718 ##################################### return type: DATE ##################################### 179 of (1/1): test_bug12925 ##################################### ##################################### 180 of (1/1): test_bug11909 ##################################### ##################################### 181 of (1/1): test_bug11901 ##################################### ##################################### 182 of (1/1): test_bug11904 ##################################### ##################################### 183 of (1/1): test_bug12243 ##################################### ##################################### 184 of (1/1): test_bug14210 ##################################### ##################################### 185 of (1/1): test_bug13488 ##################################### data is: OK ##################################### 186 of (1/1): test_bug13524 ##################################### ##################################### 187 of (1/1): test_bug14845 ##################################### ##################################### 188 of (1/1): test_bug15510 ##################################### ##################################### 189 of (1/1): test_opt_reconnect ##################################### reconnect before mysql_options: 0 reconnect after mysql_options: 1 reconnect after mysql_real_connect: 1 reconnect before mysql_real_connect: 0 reconnect after mysql_real_connect: 0 ##################################### 190 of (1/1): test_bug12744 ##################################### ##################################### 191 of (1/1): test_bug16143 ##################################### ##################################### 192 of (1/1): test_bug15613 ##################################### Field lengths (client character set is latin1): text character set utf8: 65535 tinytext character set utf8: 255 mediumtext character set utf8: 16777215 longtext character set utf8: 4294967295 varchar(255) character set latin1: 255 varchar(255) character set binary: 255 varchar(255) character set utf8: 255 ##################################### 193 of (1/1): test_bug20152 ##################################### OK! ##################################### 194 of (1/1): test_bug14169 ##################################### GROUP_CONCAT() result type 252 ##################################### 195 of (1/1): test_bug17667 ##################################### Opening '/home/spunkmeyer/src/mysql-5.0.82/mysql-test/var/log/master.log' Found statement starting with "drop table if exists bug17667" Found statement starting with "create table bug17667 (c varchar(20))" Found statement starting with "insert into bug17667 (c) values ('regular') /* NUL=" Found statement starting with "insert into bug17667 (c) values ('prepared') /* NUL=" Found statement starting with "insert into bug17667 (c) values ('NUL=" Found statement starting with "insert into bug17667 (c) values ('5 NULs=" Found statement starting with "insert into bug17667 (c) values ('6 NULs=" Found statement starting with "/* NUL=" Found statement starting with "drop table bug17667" success. All queries found intact in the log. ##################################### 196 of (1/1): test_bug19671 ##################################### +------+ | f1 | +------+ 0 rows returned field[0]: name :`f1` (expected: `f1`) org_name :`f1` (expected: `f1`) type :`3` (expected: `3`) table :`v1` (expected: `v1`) org_table:`v1` (expected: `v1`) database :`client_test_db` (expected: `client_test_db`) length :`11` (expected: `11`) maxlength:`4` charsetnr:`63` default :`0` (expected: `0`) ##################################### 197 of (1/1): test_bug15752 ##################################### Got error (as expected): Commands out of sync; you can't run this command now ##################################### 198 of (1/1): test_mysql_insert_id ##################################### [MySQL-5.0.82-log][1062] Duplicate entry '12' for key 1 [MySQL-5.0.82-log][1062] Duplicate entry '12' for key 1 [MySQL-5.0.82-log][1062] Duplicate entry '12' for key 1 [MySQL-5.0.82-log][1062] Duplicate entry '12' for key 1 ##################################### 199 of (1/1): test_bug21206 ##################################### ##################################### 200 of (1/1): test_bug21726 ##################################### ##################################### 201 of (1/1): test_bug15518 ##################################### rc: 1, mysql_stmt_errno: 1064, mysql_errno: 1064 rc: 0, mysql_stmt_errno: 0, mysql_errno: 0 rc: 1, mysql_stmt_errno: 1064, mysql_errno: 1064 rc: 1, mysql_stmt_errno: 2013 ##################################### 202 of (1/1): test_bug23383 ##################################### ##################################### 203 of (1/1): test_bug21635 ##################################### MIN(i) -> MIN(i) ... OK MIN(i) AS A1 -> A1 ... OK MAX(i) -> MAX(i) ... OK MAX(i) AS A2 -> A2 ... OK COUNT(i) -> COUNT(i) ... OK COUNT(i) AS A3 -> A3 ... OK MIN(i) -> MIN(i) ... OK MIN(i) AS A1 -> A1 ... OK MAX(i) -> MAX(i) ... OK MAX(i) AS A2 -> A2 ... OK COUNT(i) -> COUNT(i) ... OK COUNT(i) AS A3 -> A3 ... OK ##################################### 204 of (1/1): test_bug24179 ##################################### Got error (as expected): 1323 Cursor SELECT must not have INTO ##################################### 205 of (1/1): test_bug27876 ##################################### [MySQL-5.0.82-log][1210] Incorrect arguments to mysql_stmt_execute ##################################### 206 of (1/1): test_bug27592 ##################################### ##################################### 207 of (1/1): test_bug29306 ##################################### field name dd field table view17557 field decimals 1 ##################################### 208 of (1/1): test_bug31669 ##################################### ##################################### 209 of (1/1): test_bug32265 ##################################### ##################################### 210 of (1/1): test_bug38486 ##################################### total parameters in stmt: `2` (expected: `2`) time[0]: 00-00-00 time[1]: 00-00-00 ##################################### 211 of (1/1): test_bug36326 ##################################### +------+ | a | +------+ | 1 | +------+ 1 row returned +------+ | a | +------+ | 1 | +------+ 1 row returned total parameters in stmt: `1` (expected: `1`)mysql_client_test.c:16387: check failed: 'sql_big_selects_5 == sql_big_selects_orig'