| Bug #2549 | Server Dump when bind the sql with 'AND' operator | ||
|---|---|---|---|
| Submitted: | 29 Jan 2004 0:06 | Modified: | 29 Jan 2004 11:54 |
| Reporter: | Gergo Bacskai | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 4.1.1 | OS: | Linux (Linux) |
| Assigned to: | CPU Architecture: | Any | |
[29 Jan 2004 0:09]
Gergo Bacskai
I have tryed with 4.1.1 Official binaries , 5.0 binaries I have compiled some also , but I have this error all the time. Gergõ
[29 Jan 2004 11:54]
MySQL Verification Team
I have tried your code and it worked fine for me with latest 4.1.2. I have skipped few tests from client_test.c, but your test is there:and it passed with flying colors. Search for BUGS DB: ##################################### client_connect ##################################### Establishing a connection to '(null)' ... OK Creating a test database 'client_test_db' ... OK ##################################### 1 of (1/1): client_query ##################################### [MySQL-4.1.2-alpha-debug][1050] Table 'myclient_test' already exists [MySQL-4.1.2-alpha-debug][1062] Duplicate entry '3' for key 1 ##################################### 2 of (1/1): test_fetch_seek ##################################### row 0: 1,venu,2004-01-29 21:55:06 row 2: 2,mysql,2004-01-29 21:55:06 row 2: 2,mysql,2004-01-29 21:55:06 row 0: 1,venu,2004-01-29 21:55:06 ##################################### 3 of (1/1): test_fetch_nobuffs ##################################### total rows : 1 CURRENT_DATABASE(): client_test_db CURRENT_USER() : root@localhost CURRENT_DATE() : 2004-01-29 CURRENT_TIME() : 21:55:06 total rows : 1 ##################################### 4 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-4.1.2-alpha-debug][2014] Commands out of sync; You can't run this command now ##################################### 5 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 ##################################### 6 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 | | 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) : (0) ts(6) : 1999-12-29 00:00:00(19) ##################################### 7 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) ##################################### 8 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) ##################################### 9 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) ##################################### 10 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) ##################################### 11 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) ##################################### 12 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) ##################################### 13 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 | 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_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) ##################################### 15 of (1/1): test_bind_result_ext1 ##################################### 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) ##################################### 16 of (1/1): test_select_direct ##################################### +------+------+------+------+------+ | id | id1 | id2 | id3 | name | +------+------+------+------+------+ | 10 | 5 | 2.3 | 4.5 | venu | +------+------+------+------+------+ 1 row returned ##################################### 17 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 ##################################### 18 of (1/1): test_select ##################################### total parameters in stmt: `2` (expected: `2`) +------+------+ | id | name | +------+------+ | 10 | venu | +------+------+ 1 row returned ##################################### 19 of (1/1): test_select_version ##################################### total parameters in stmt: `0` (expected: `0`) +-----------+ | @@VERSION | +-----------+ | 4.1.2-alpha-debug | +-----------+ 1 row returned ##################################### 20 of (1/1): test_select_simple ##################################### total parameters in stmt: `0` (expected: `0`) +-----------------+ | Tables_in_mysql | +-----------------+ | columns_priv | | db | | func | | host | | proc | | tables_priv | | user | +-----------------+ 7 rows returned ##################################### 21 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: ``) ##################################### 22 of (1/1): test_long_data ##################################### [MySQL-4.1.2-alpha-debug][1136] Column count doesn't match value count at row 1 total parameters in stmt: `3` (expected: `3`) mysql_execute() returned 0 +------+--------------------------+------+ | col1 | col2 | col3 | +------+--------------------------+------+ | 999 | Michael 'Monty' Widenius | Venu | +------+--------------------------+------+ 1 row returned SELECT col1 FROM test_long_data LIMIT 1 obtained: `999` (expected: `999`) SELECT col2 FROM test_long_data LIMIT 1 obtained: `Michael 'Monty' Widenius` (expected: `Michael 'Monty' Widenius`) SELECT col3 FROM test_long_data LIMIT 1 obtained: `Venu` (expected: `Venu`) ##################################### 23 of (1/1): test_insert ##################################### total parameters in stmt: `2` (expected: `2`) +------+--------+ | col1 | col2 | +------+--------+ | 0 | MySQL0 | | 1 | MySQL1 | | 2 | MySQL2 | +------+--------+ 3 rows returned ##################################### 24 of (1/1): test_set_variable ##################################### max_error_count(default): 64 max_error_count : 31 max_error_count(default): 64 ##################################### 25 of (1/1): test_select_show ##################################### total parameters in stmt: `0` (expected: `0`) +-------+------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------+------+-----+---------+-------+ | id | int(4) | | PRI | 0 | | | name | char(2) | YES | | NULL | | +-------+------+------+-----+---------+-------+ 2 rows returned [MySQL-4.1.2-alpha-debug][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 +--------------------------------------+ | Tables_in_client_test_db (test_show) | +--------------------------------------+ | test_show | +--------------------------------------+ 1 row returned +-------+------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------+------+-----+---------+-------+ | id | int(4) | | PRI | 0 | | | 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 ##################################### 26 of (1/1): test_prepare_noparam ##################################### total parameters in stmt: `0` (expected: `0`) +------+------+ | col1 | col2 | +------+------+ | 10 | venu | +------+------+ 1 row returned ##################################### 27 of (1/1): test_bind_result_ext From the BUGS DB ##################################### Short : 2998 int : 3998 Short : 2998 int : 3999 Short : 2998 int : 4000 Short : 2998 int : 4001 Short : 2999 int : 3998 Short : 2999 int : 3999 Short : 2999 int : 4000 Short : 2999 int : 4001 Short : 3000 int : 3998 Short : 3000 int : 3999 Short : 3000 int : 4000 Short : 3000 int : 4001 Short : 3001 int : 3998 Short : 3001 int : 3999 Short : 3001 int : 4000 Short : 3001 int : 4001 ##################################### 28 of (1/1): test_prepare_simple ##################################### total parameters in stmt: `0` (expected: `0`) 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`) [MySQL-4.1.2-alpha-debug][2030] Not all parameters data supplied total parameters in stmt: `2` (expected: `2`) ##################################### 29 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 | | 1 | MySQL345 | 345 | 1877 | 1100 | 3 | 6588.09 | | 2 | MySQL370 | 370 | 1887 | 1200 | 4 | 6598.18 | | 3 | MySQL395 | 395 | 1897 | 1300 | 5 | 6608.27 | | 4 | MySQL420 | 420 | 1907 | 1400 | 6 | 6618.36 | | 5 | MySQL445 | 445 | 1917 | 1500 | 7 | 6628.45 | | 6 | MySQL470 | 470 | 1927 | 1600 | 8 | 6638.54 | | 7 | MySQL495 | 495 | 1937 | 1700 | 9 | 6648.63 | | 8 | MySQL520 | 520 | 1947 | 1800 | 10 | 6658.72 | | 9 | MySQL545 | 545 | 1957 | 1900 | 11 | 6668.81 | | 10 | MySQL570 | 570 | 1967 | 2000 | 12 | 6678.9 | | 11 | MySQL595 | 595 | 1977 | 2100 | 13 | 6688.99 | | 12 | MySQL620 | 620 | 1987 | 2200 | 14 | 6699.08 | | 13 | MySQL645 | 645 | 1997 | 2300 | 15 | 6709.17 | | 14 | MySQL670 | 670 | 2007 | 2400 | 16 | 6719.26 | | 15 | MySQL695 | 695 | 2017 | 2500 | 17 | 6729.35 | | 16 | MySQL720 | 720 | 2027 | 2600 | 18 | 6739.44 | | 17 | MySQL745 | 745 | 2037 | 2700 | 19 | 6749.53 | | 18 | MySQL770 | 770 | 2047 | 2800 | 20 | 6759.62 | | 19 | MySQL795 | 795 | 2057 | 2900 | 21 | 6769.71 | | 20 | MySQL820 | 820 | 2067 | 3000 | 22 | 6779.8 | | 21 | MySQL845 | 845 | 2077 | 3100 | 23 | 6789.89 | | 22 | MySQL870 | 870 | 2087 | 3200 | 24 | 6799.98 | | 23 | MySQL895 | 895 | 2097 | 3300 | 25 | 6810.07 | | 24 | MySQL920 | 920 | 2107 | 3400 | 26 | 6820.16 | | 25 | MySQL945 | 945 | 2117 | 3500 | 27 | 6830.25 | | 26 | MySQL970 | 970 | 2127 | 3600 | 28 | 6840.34 | | 27 | MySQL995 | 995 | 2137 | 3700 | 29 | 6850.43 | | 28 | MySQL1020 | 1020 | 2147 | 3800 | 30 | 6860.52 | | 29 | MySQL1045 | 1045 | 2157 | 3900 | 31 | 6870.61 | | 30 | MySQL1070 | 1070 | 2167 | 4000 | 32 | 6880.7 | | 31 | MySQL1095 | 1095 | 2177 | 4100 | 33 | 6890.79 | | 32 | MySQL1120 | 1120 | 2187 | 4200 | 34 | 6900.88 | | 33 | MySQL1145 | 1145 | 2197 | 4300 | 35 | 6910.97 | | 34 | MySQL1170 | 1170 | 2207 | 4400 | 36 | 6921.06 | | 35 | MySQL1195 | 1195 | 2217 | 4500 | 37 | 6931.15 | | 36 | MySQL1220 | 1220 | 2227 | 4600 | 38 | 6941.24 | | 37 | MySQL1245 | 1245 | 2237 | 4700 | 39 | 6951.33 | | 38 | MySQL1270 | 1270 | 2247 | 4800 | 40 | 6961.42 | | 39 | MySQL1295 | 1295 | 2257 | 4900 | 41 | 6971.51 | | 40 | MySQL1320 | 1320 | 2267 | 5000 | 42 | 6981.6 | | 41 | MySQL1345 | 1345 | 2277 | 5100 | 43 | 6991.69 | | 42 | MySQL1370 | 1370 | 2287 | 5200 | 44 | 7001.78 | | 43 | MySQL1395 | 1395 | 2297 | 5300 | 45 | 7011.87 | | 44 | MySQL1420 | 1420 | 2307 | 5400 | 46 | 7021.96 | | 45 | MySQL1445 | 1445 | 2317 | 5500 | 47 | 7032.05 | | 46 | MySQL1470 | 1470 | 2327 | 5600 | 48 | 7042.14 | | 47 | MySQL1495 | 1495 | 2337 | 5700 | 49 | 7052.23 | | 48 | MySQL1520 | 1520 | 2347 | 5800 | 50 | 7062.32 | | 49 | MySQL1545 | 1545 | 2357 | 5900 | 51 | 7072.41 | | 50 | MySQL1570 | 1570 | 2367 | 6000 | 52 | 7082.5 | | 51 | MySQL1595 | 1595 | 2377 | 6100 | 53 | 7092.59 | | 52 | MySQL1620 | 1620 | 2387 | 6200 | 54 | 7102.68 | | 53 | MySQL1645 | 1645 | 2397 | 6300 | 55 | 7112.77 | | 54 | MySQL1670 | 1670 | 2407 | 6400 | 56 | 7122.86 | | 55 | MySQL1695 | 1695 | 2417 | 6500 | 57 | 7132.95 | | 56 | MySQL1720 | 1720 | 2427 | 6600 | 58 | 7143.04 | | 57 | MySQL1745 | 1745 | 2437 | 6700 | 59 | 7153.13 | | 58 | MySQL1770 | 1770 | 2447 | 6800 | 60 | 7163.22 | | 59 | MySQL1795 | 1795 | 2457 | 6900 | 61 | 7173.31 | | 60 | MySQL1820 | 1820 | 2467 | 7000 | 62 | 7183.4 | | 61 | MySQL1845 | 1845 | 2477 | 7100 | 63 | 7193.49 | | 62 | MySQL1870 | 1870 | 2487 | 7200 | 64 | 7203.58 | | 63 | MySQL1895 | 1895 | 2497 | 7300 | 65 | 7213.67 | | 64 | MySQL1920 | 1920 | 2507 | 7400 | 66 | 7223.76 | | 65 | MySQL1945 | 1945 | 2517 | 7500 | 67 | 7233.85 | | 66 | MySQL1970 | 1970 | 2527 | 7600 | 68 | 7243.94 | | 67 | MySQL1995 | 1995 | 2537 | 7700 | 69 | 7254.03 | | 68 | MySQL2020 | 2020 | 2547 | 7800 | 70 | 7264.12 | | 69 | MySQL2045 | 2045 | 2557 | 7900 | 71 | 7274.21 | | 70 | MySQL2070 | 2070 | 2567 | 8000 | 72 | 7284.3 | | 71 | MySQL2095 | 2095 | 2577 | 8100 | 73 | 7294.39 | | 72 | MySQL2120 | 2120 | 2587 | 8200 | 74 | 7304.48 | | 73 | MySQL2145 | 2145 | 2597 | 8300 | 75 | 7314.57 | | 74 | MySQL2170 | 2170 | 2607 | 8400 | 76 | 7324.66 | | 75 | MySQL2195 | 2195 | 2617 | 8500 | 77 | 7334.75 | | 76 | MySQL2220 | 2220 | 2627 | 8600 | 78 | 7344.84 | | 77 | MySQL2245 | 2245 | 2637 | 8700 | 79 | 7354.93 | | 78 | MySQL2270 | 2270 | 2647 | 8800 | 80 | 7365.02 | | 79 | MySQL2295 | 2295 | 2657 | 8900 | 81 | 7375.11 | | 80 | MySQL2320 | 2320 | 2667 | 9000 | 82 | 7385.2 | | 81 | MySQL2345 | 2345 | 2677 | 9100 | 83 | 7395.29 | | 82 | MySQL2370 | 2370 | 2687 | 9200 | 84 | 7405.38 | | 83 | MySQL2395 | 2395 | 2697 | 9300 | 85 | 7415.47 | | 84 | MySQL2420 | 2420 | 2707 | 9400 | 86 | 7425.56 | | 85 | MySQL2445 | 2445 | 2717 | 9500 | 87 | 7435.65 | | 86 | MySQL2470 | 2470 | 2727 | 9600 | 88 | 7445.74 | | 87 | MySQL2495 | 2495 | 2737 | 9700 | 89 | 7455.83 | | 88 | MySQL2520 | 2520 | 2747 | 9800 | 90 | 7465.92 | | 89 | MySQL2545 | 2545 | 2757 | 9900 | 91 | 7476.01 | | 90 | MySQL2570 | 2570 | 2767 | 10000 | 92 | 7486.1 | | 91 | MySQL2595 | 2595 | 2777 | 10100 | 93 | 7496.19 | | 92 | MySQL2620 | 2620 | 2787 | 10200 | 94 | 7506.28 | | 93 | MySQL2645 | 2645 | 2797 | 10300 | 95 | 7516.37 | | 94 | MySQL2670 | 2670 | 2807 | 10400 | 96 | 7526.46 | | 95 | MySQL2695 | 2695 | 2817 | 10500 | 97 | 7536.55 | | 96 | MySQL2720 | 2720 | 2827 | 10600 | 98 | 7546.64 | | 97 | MySQL2745 | 2745 | 2837 | 10700 | 99 | 7556.73 | | 98 | MySQL2770 | 2770 | 2847 | 10800 | 100 | 7566.82 | | 99 | MySQL2795 | 2795 | 2857 | 10900 | 101 | 7576.91 | +------+------+------+------+------+------+------+ 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) ##################################### client_disconnect ##################################### droping the test database 'client_test_db' ... OK closing the connection ... OK All '29' tests were successful (in '1' iterations) Total execution time: 1 SECS !!! SUCCESS !!!
Description: The server dump when bind the result and the parameters to an sql statement what contain 'AND' operator with C API. please see the following source code (you can include this to the client_test.c an where all the required function exist): But is you use in sql 'where (c1=?) * (c2=?) '... etc than the server will not dump. Best regards Gergõ /******************************************************** * to test ext bind result UPC * *********************************************************/ static void test_bind_result_ext_UPC() { MYSQL_STMT *stmt; int rc, i; uchar t_data; short s_data,s_data2; int i_data,i_data2; longlong b_data; float f_data; double d_data; char szData[20], bData[20]; ulong szLength, bLength; MYSQL_BIND bind[8]; long length[8]; my_bool is_null[8]; MYSQL_BIND bind2[2]; long length2[2]; my_bool is_null2[2]; myheader("test_bind_result_ext"); rc = mysql_query(mysql,"DROP TABLE IF EXISTS test_bind_result"); myquery(rc); rc = mysql_commit(mysql); myquery(rc); rc = mysql_query(mysql,"CREATE TABLE test_bind_result(c1 tinyint, c2 smallint, \ c3 int, c4 bigint, \ c5 float, c6 double, \ c7 varbinary(10), \ c8 varchar(50))"); myquery(rc); rc = mysql_commit(mysql); myquery(rc); rc = mysql_query(mysql,"INSERT INTO test_bind_result VALUES(19,2999,3999,4999999,\ 2345.6,5678.89563,\ 'venu','mysql')"); myquery(rc); rc = mysql_commit(mysql); myquery(rc); for (i= 0; i < (int) array_elements(bind); i++) { bind[i].length= &length[i]; bind[i].is_null= &is_null[i]; } for (i= 0; i < (int) array_elements(bind2); i++) { bind2[i].length= &length2[i]; bind2[i].is_null= &is_null2[i]; } bind[0].buffer_type=MYSQL_TYPE_TINY; bind[0].buffer=(char *)&t_data; bind[1].buffer_type=MYSQL_TYPE_SHORT; bind[1].buffer=(char *)&s_data; bind[2].buffer_type=MYSQL_TYPE_LONG; bind[2].buffer=(char *)&i_data; bind[3].buffer_type=MYSQL_TYPE_LONGLONG; bind[3].buffer=(char *)&b_data; bind[4].buffer_type=MYSQL_TYPE_FLOAT; bind[4].buffer=(char *)&f_data; bind[5].buffer_type=MYSQL_TYPE_DOUBLE; bind[5].buffer=(char *)&d_data; bind[6].buffer_type=MYSQL_TYPE_STRING; bind[6].buffer= (char *)szData; bind[6].buffer_length= sizeof(szData); bind[6].length= &szLength; bind[7].buffer_type=MYSQL_TYPE_TINY_BLOB; bind[7].buffer=(char *)&bData; bind[7].length= &bLength; bind[7].buffer_length= sizeof(bData); stmt = mysql_prepare(mysql, "select * from test_bind_result where c2=? and c3=?", 90); mystmt_init(stmt); bind2[0].buffer_type=MYSQL_TYPE_SHORT; bind2[0].buffer=(char *)&s_data2; bind2[1].buffer_type=MYSQL_TYPE_LONG; bind2[1].buffer=(char *)&i_data2; rc = mysql_bind_param(stmt,bind2); mystmt(stmt, rc); rc = mysql_bind_result(stmt,bind); mystmt(stmt, rc); for(s_data2=2998;s_data2<=3001;s_data2++) { for(i_data2=3998;i_data2<=4001;i_data2++) { fprintf(stdout,"\n Short : %d int : %d ",s_data2,i_data2); if (mysql_execute(stmt)) { printf("\n execute In failed %s ",mysql_stmt_error(stmt)); fprintf(stdout,"[%d] %s\n",mysql_errno(mysql),mysql_error(mysql)); } if((rc = mysql_fetch(stmt)) != MYSQL_NO_DATA) { mystmt(stmt,rc); fprintf(stdout, "\n data (tiny) : %d", t_data); fprintf(stdout, "\n data (short) : %d", s_data); fprintf(stdout, "\n data (int) : %d", i_data); fprintf(stdout, "\n data (big) : %lld", b_data); fprintf(stdout, "\n data (float) : %f", f_data); fprintf(stdout, "\n data (double) : %f", d_data); fprintf(stdout, "\n data (str) : %s(%lu)", szData, szLength); fprintf(stdout, "\n data (bin) : %s(%lu)", bData, bLength); } } } mysql_stmt_close(stmt); } ------------------------------------------------------------------------------------------------ stdout ----------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------ ##################################### client_connect ##################################### Establishing a connection to '(null)' ... OK Creating a test database 'client_test_db' ... OK ##################################### 0 of (0/1): test_bind_result_ext ##################################### Short : 2998 int : 3998 Short : 2998 int : 3999 execute In failed Lost connection to MySQL server during query [2013] Lost connection to MySQL server during query [MySQL-4.1.1-alpha-standard-log][2013] Lost connection to MySQL server during query xconv2: /root/xconv2/src/client_test.c:2974: test_bind_result_ext_UPC: Assertion `rc == 0' failed. Press Enter to continue! ------------------------------------------------------------------------------------------------ error log -------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------ bu1wks2682:/usr/local/mysql/var# tail -f ./bu1wks2682.err InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 040128 9:25:04 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 198795. InnoDB: Doing recovery: scanned up to log sequence number 0 198795 InnoDB: Last MySQL binlog file position 0 33320, file name ./bu1wks2682-bin.000023 040128 9:25:04 InnoDB: Flushing modified pages from the buffer pool... 040128 9:25:04 InnoDB: Started; log sequence number 0 198795 /usr/local/mysql/bin/mysqld: ready for connections. Version: '4.1.1-alpha-standard-log' socket: '/tmp/mysql.sock' port: 3306 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=268435456 read_buffer_size=1044480 max_used_connections=0 max_connections=100 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 466543 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x8629528 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfe7e638, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x8086bd3 0x82d03c8 0x80b5e9a 0x80b6304 0x80b6070 0x80b69eb 0x80b51ae 0x80b2481 0x80b49f6 0x80b1abe 0x809401a 0x80c963e 0x8092be3 0x8092671 0x8091df9 0x82cdb7c 0x830355a New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x86393c8 = select * from test_bind_result where c2=2998 and c3=3999 thd->thread_id=1 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash. Number of processes running now: 0 040128 09:25:20 mysqld restarted 040128 9:25:20 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 040128 9:25:20 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 198795. InnoDB: Doing recovery: scanned up to log sequence number 0 198795 InnoDB: Last MySQL binlog file position 0 33320, file name ./bu1wks2682-bin.000023 040128 9:25:20 InnoDB: Flushing modified pages from the buffer pool... 040128 9:25:20 InnoDB: Started; log sequence number 0 198795 /usr/local/mysql/bin/mysqld: ready for connections. Version: '4.1.1-alpha-standard-log' socket: '/tmp/mysql.sock' port: 3306 How to repeat: run the source again Suggested fix: this is not the best solution but this works : you use in sql 'where (c1=?) * (c2=?) '... etc than the server will not dump.