/usr/src/redhat/BUILD/mysqlcom-5.0.38/tests/mysql_client_test --no-defaults --testcase --user=root --port=9306 --socket=/usr/src/redhat/BUILD/mysqlcom-5.0.38/mysql-test/var/tmp/master.sock --vardir=/usr/src/redhat/BUILD/mysqlcom-5.0.38/mysql-test/var ##################################### client_connect ##################################### Establishing a connection to '' ... OK Connected to MySQL server version: 5.0.38-enterprise-log (50038) 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.38-enterprise-log][1050] Table 't1' already exists [MySQL-5.0.38-enterprise-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, 2007-04-03 20:06:03 row 2: 2, mysql, 2007-04-03 20:06:03 row 2: 2, mysql, 2007-04-03 20:06:03 row 0: 1, venu, 2007-04-03 20:06:03 ##################################### 5 of (1/1): test_fetch_nobuffs ##################################### total rows : 1 CURRENT_DATABASE(): client_test_db CURRENT_USER() : root@localhost CURRENT_DATE() : 2007-04-03 CURRENT_TIME() : 20:06:03 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.38-enterprise-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 mysql_client_test.c:3893: check failed: 'rc == 0'