diff options
Diffstat (limited to 'sql-bench/limits/mysql.cfg')
| -rw-r--r-- | sql-bench/limits/mysql.cfg | 329 |
1 files changed, 163 insertions, 166 deletions
diff --git a/sql-bench/limits/mysql.cfg b/sql-bench/limits/mysql.cfg index 1eb44d72a57..64f91f07363 100644 --- a/sql-bench/limits/mysql.cfg +++ b/sql-bench/limits/mysql.cfg @@ -345,7 +345,7 @@ date_format_inresult=iso # Date format in result ###> OK ### ###< select a from crash_me_d - ###> 2003-12-24 + ###> 2004-04-06 ###< delete from crash_me_d ###> OK date_infinity=error # Supports 'infinity dates @@ -695,7 +695,7 @@ func_extra_elt=yes # Function ELT func_extra_encrypt=yes # Function ENCRYPT ### ###<select encrypt('hello') - ###>1Wi1s0yzcGqMY + ###>VNeu3dE4DbVJY func_extra_expand2arg=no # Function EXPAND ### ###<select expand('abcd',6) @@ -841,11 +841,10 @@ func_extra_mdy=no # Function MDY ### ###<select mdy(7,1,1998) from crash_me_d ###> execute failed: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 '(7,1,1998) from crash_me_d' at line 1 -func_extra_microsecond=error # Function MICROSECOND +func_extra_microsecond=yes # Function MICROSECOND ### ###<select MICROSECOND('19630816200212111111') - ###>11 - ###We expected '111111' but got '11' + ###>110000 func_extra_mid=yes # Function SUBSTRING as MID ### ###<select mid('hello',3,2) @@ -876,7 +875,7 @@ func_extra_num=no # Function NUM func_extra_odbc_convert=no # Function ODBC CONVERT ### ###<select convert(5,SQL_CHAR) - ###> execute failed: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 + ###> execute failed: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 'SQL_CHAR)' at line 1 func_extra_password=yes # Function PASSWORD ### ###<select password('hello') @@ -992,7 +991,7 @@ func_extra_subtime=yes # Function SUBTIME func_extra_sysdate=yes # Function SYSDATE ### ###<select sysdate() - ###>2003-12-24 09:46:11 + ###>2004-04-06 13:49:05 func_extra_tail=no # Function TAIL ### ###<select tail('ABCDEFG',3) @@ -1058,7 +1057,7 @@ func_extra_uid=no # Function UID func_extra_unix_timestamp=yes # Function UNIX_TIMESTAMP ### ###<select unix_timestamp() - ###>1072251971 + ###>1081248545 func_extra_userenv=no # Function USERENV ### ###<select userenv @@ -1070,7 +1069,7 @@ func_extra_value=no # Function VALUE func_extra_version=yes # Function VERSION ### ###<select version() - ###>5.0.0-alpha-debug-log + ###>4.1.2-alpha func_extra_weekday=yes # Function WEEKDAY ### ###<select weekday('1997-11-29') from crash_me_d @@ -1138,11 +1137,11 @@ func_odbc_cot=yes # Function COT func_odbc_curdate=yes # Function CURDATE ### ###<select curdate() - ###>2003-12-24 + ###>2004-04-06 func_odbc_curtime=yes # Function CURTIME ### ###<select curtime() - ###>09:46:11 + ###>13:49:04 func_odbc_database=yes # Function DATABASE ### ###<select database() @@ -1271,7 +1270,7 @@ func_odbc_monthname=yes # Function MONTHNAME func_odbc_now=yes # Function NOW ### ###<select now() - ###>2003-12-24 09:46:11 + ###>2004-04-06 13:49:04 func_odbc_pi=yes # Function PI ### ###<select pi() @@ -1346,19 +1345,20 @@ func_odbc_tan=yes # Function TAN ### ###<select tan(1) ###>1.557408 -func_odbc_timestampadd=yes # Function TIMESTAMPADD +func_odbc_timestampadd=no # Function TIMESTAMPADD ### ###<select timestampadd(SQL_TSI_SECOND,1,'1997-01-01 00:00:00') - ###>1997-01-01 00:00:01 -func_odbc_timestampdiff=error # Function TIMESTAMPDIFF + ###> execute failed: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 '(SQL_TSI_SECOND,1,'1997-01-01 00:00:00')' at line 1 + ### + ###<select {fn timestampadd(SQL_TSI_SECOND,1,{ts '1997-01-01 00:00:00'}) } + ###> execute failed: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 '(SQL_TSI_SECOND,1,{ts '1997-01-01 00:00:00'}) }' at line 1 +func_odbc_timestampdiff=no # Function TIMESTAMPDIFF ### ###<select timestampdiff(SQL_TSI_SECOND,'1997-01-01 00:00:02', '1997-01-01 00:00:01') - ###>-1 - ###We expected '1' but got '-1' + ###> execute failed: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 '(SQL_TSI_SECOND,'1997-01-01 00:00:02', '1997-01-01 00:00:01')' ### ###<select {fn timestampdiff(SQL_TSI_SECOND,{ts '1997-01-01 00:00:02'}, {ts '1997-01-01 00:00:01'}) } - ###>-1 - ###We expected '1' but got '-1' + ###> execute failed: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 '(SQL_TSI_SECOND,{ts '1997-01-01 00:00:02'}, {ts '1997-01-01 00: func_odbc_truncate=yes # Function TRUNCATE ### ###<select truncate(18.18,-1) @@ -1417,20 +1417,17 @@ func_sql_concat_as_||=error # Function concatenation with || func_sql_current_date=yes # Function CURRENT_DATE ### ###<select current_date - ###>2003-12-24 + ###>2004-04-06 func_sql_current_time=yes # Function CURRENT_TIME ### ###<select current_time - ###>09:46:11 + ###>13:49:04 func_sql_current_timestamp=yes # Function CURRENT_TIMESTAMP ### ###<select current_timestamp - ###>2003-12-24 09:46:11 -func_sql_current_user=with_parenthesis # CURRENT_USER + ###>2004-04-06 13:49:04 +func_sql_current_user=yes # CURRENT_USER ###< select CURRENT_USER - ###> execute error:Unknown column 'CURRENT_USER' in 'field list' - ### - ###< select CURRENT_USER() ###> OK func_sql_extract_sql=yes # Function EXTRACT ### @@ -1439,11 +1436,11 @@ func_sql_extract_sql=yes # Function EXTRACT func_sql_localtime=yes # Function LOCALTIME ### ###<select localtime - ###>2003-12-24 09:46:11 + ###>2004-04-06 13:49:04 func_sql_localtimestamp=yes # Function LOCALTIMESTAMP ### ###<select localtimestamp - ###>2003-12-24 09:46:11 + ###>2004-04-06 13:49:04 func_sql_lower=yes # Function LOWER ### ###<select LOWER('ABC') @@ -1891,7 +1888,7 @@ logical_value=1 # Value of logical operation (1=1) ###>1 max_big_expressions=10 # big expressions ###We are trying (example with N=5): - ###select 0+(1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+...(14328) + ###select 0+(1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+...(8168) ### 50:FAIL 10:OK 30:FAIL 14:FAIL 11:FAIL max_char_size=1048543 # max char() size ###We are trying (example with N=5): @@ -1913,17 +1910,17 @@ max_conditions=85660 # OR and AND in WHERE ###We are trying (example with N=5): ###select a from crash_me where a=1 and b='a' or a=0 and b='0' or a=1 and b='1' or a=2 and b='2' or a=3 and b='3' or a=4 and b='4' ### 27592:OK 41389:OK 48287:FAIL 42769:OK 45528:FAIL 43321:FAIL 42880:FAIL 42791:OK 42835:FAIL 42800:OK 42817:OK 42826:OK 42830:OK 42832:FAIL 42831:FAIL -max_expressions=1452 # simple expressions +max_expressions=836 # simple expressions ###We are trying (example with N=5): ###select 1+1+1+1+1+1 - ### 5000:FAIL 1000:OK 3000:FAIL 1400:OK 2200:FAIL 1560:FAIL 1432:OK 1496:FAIL 1445:OK 1470:FAIL 1450:OK 1460:FAIL 1452:OK 1456:FAIL 1453:FAIL + ### 5000:FAIL 1000:FAIL 200:OK 600:OK 800:OK 900:FAIL 820:OK 860:FAIL 828:OK 844:FAIL 831:OK 837:FAIL 832:OK 834:OK 835:OK 836:OK max_index=32 # max index ### max_unique_index=32 ,so max_index must be same -max_index_length=500 # index length +max_index_length=1000 # index length ###We are trying (example with N=5): ###create table crash_q (q0 char(5) not null,unique (q0)) ###insert into crash_q values('aaaaa') - ### 4096:FAIL 819:FAIL 164:OK 491:OK 655:FAIL 524:FAIL 498:OK 511:FAIL 501:FAIL 499:OK 500:OK + ### 4096:FAIL 819:OK 2457:FAIL 1147:FAIL 885:OK 1016:FAIL 911:OK 963:OK 989:OK 1002:FAIL 992:OK 997:OK 999:OK 1000:OK 1001:FAIL max_index_name=64 # index name length ###We are trying (example with N=5): ###create index crash_qaaaaa on crash_me (a) @@ -1959,10 +1956,10 @@ max_row_length_with_null=65502 # table row length with nulls (without blobs) max_select_alias_name=+512 # select alias name length ###We are trying (example with N=5): ###select b as aaaaa from crash_me -max_stack_expression=1452 # stacked expressions +max_stack_expression=836 # stacked expressions ###We are trying (example with N=5): ###select 1+(1+(1+(1+(1+(1))))) - ### 1000:OK 1500:FAIL 1100:OK 1300:OK 1400:OK 1450:OK 1475:FAIL 1455:FAIL 1451:OK 1453:FAIL 1452:OK + ### 1000:FAIL 200:OK 600:OK 800:OK 900:FAIL 820:OK 860:FAIL 828:OK 844:FAIL 831:OK 837:FAIL 832:OK 834:OK 835:OK 836:OK max_table_alias_name=+512 # table alias name length ###We are trying (example with N=5): ###select aaaaa.b from crash_me aaaaa @@ -2132,7 +2129,7 @@ odbc_left_outer_join=yes # left outer join odbc style ###> OK ### ###As far as all queries returned OK, result is YES -operating_system=Linux 2.4.20-64GB-SMP i686 # crash-me tested on +operating_system=Linux 2.4.21-199-smp4G i686 # crash-me tested on order_by=yes # Order by ###< select a from crash_me order by a ###> OK @@ -2194,13 +2191,13 @@ psm_functions=no # PSM functions (ANSI SQL) ###< create table crash_q (a int) ###> OK ###< create function crash_func(in a1 int, in b1 int) returns int language sql deterministic contains sql begin return a1 * b1; end - ###> execute error: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 'in a1 int, in b1 int) returns int language sql deterministic co + ###> execute error: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 '(in a1 int, in b1 int) returns int language sql deterministic c ###< insert into crash_q values(crash_func(2,4)) ###> execute error: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 '(2,4))' at line 1 ###< select a,crash_func(a,2) from crash_q ###> execute error: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 '(a,2) from crash_q' at line 1 ###< drop function crash_func cascade - ###> execute error:Failed to DROP FUNCTION crash_func + ###> execute error: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 'cascade' at line 1 ###< drop table crash_q ###> OK ### @@ -2211,7 +2208,7 @@ psm_modules=no # PSM modules (ANSI SQL) ###< create module crash_m declare procedure crash_proc(in a1 int, in b1 int) language sql modifies sql data begin declare c1 int; set c1 = a1 + b1; insert into crash_q(a,b) values (a1,c1); end; declare procedure crash_proc2(INOUT a int, in b int) contains sql set a = b + 10; end module ###> execute error: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 'module crash_m declare procedure crash_proc(in a1 int, in b1 in ###< call crash_proc(1,10) - ###> execute error:PROCEDURE crash_proc does not exist + ###> execute error: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 'call crash_proc(1,10)' at line 1 ###< drop module crash_m cascade ###> execute error: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 'module crash_m cascade' at line 1 ###< drop table crash_q cascade @@ -2222,11 +2219,11 @@ psm_procedures=no # PSM procedures (ANSI SQL) ###< create table crash_q (a int,b int) ###> OK ###< create procedure crash_proc(in a1 int, in b1 int) language sql modifies sql data begin declare c1 int; set c1 = a1 + b1; insert into crash_q(a,b) values (a1,c1); end - ###> execute error: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 'sql data begin declare c1 int; set c1 = a1 + b1; insert into cr + ###> execute error: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 'procedure crash_proc(in a1 int, in b1 int) language sql modifie ###< call crash_proc(1,10) - ###> execute error:PROCEDURE crash_proc does not exist + ###> execute error: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 'call crash_proc(1,10)' at line 1 ###< drop procedure crash_proc - ###> execute error:Failed to DROP PROCEDURE crash_proc + ###> execute error: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 'procedure crash_proc' at line 1 ###< drop table crash_q ###> OK ### @@ -2306,10 +2303,10 @@ rename_table=yes # rename table ###> OK ### ###As far as all queries returned OK, result is YES -repeat_string_size=1047552 # return string size from function +repeat_string_size=1048576 # return string size from function ###We are trying (example with N=5): ###select repeat('a',5) - ### 4000000:FAIL 800000:OK 2400000:FAIL 1120000:FAIL 864000:OK 992000:OK 1056000:FAIL 1004800:OK 1030400:OK 1043200:OK 1049600:FAIL 1044480:OK 1047040:OK 1048320:FAIL 1047296:OK 1047808:FAIL 1047399:OK 1047603:FAIL 1047440:OK 1047521:OK 1047562:FAIL 1047529:OK 1047545:OK 1047553:FAIL 1047547:OK 1047550:OK 1047551:OK 1047552:OK + ### 4000000:FAIL 800000:OK 2400000:FAIL 1120000:FAIL 864000:OK 992000:OK 1056000:FAIL 1004800:OK 1030400:OK 1043200:OK 1049600:FAIL 1044480:OK 1047040:OK 1048320:OK 1048960:FAIL 1048448:OK 1048704:FAIL 1048499:OK 1048601:FAIL 1048520:OK 1048560:OK 1048580:FAIL 1048564:OK 1048572:OK 1048576:OK 1048578:FAIL 1048577:FAIL reserved_word_ansi-92/99_absolute=no # Keyword ABSOLUTE ###< create table crash_me10 (ABSOLUTE int not null) ###> OK @@ -2471,13 +2468,13 @@ reserved_word_ansi-92/99_by=yes # Keyword BY ###> execute error:Unknown table 'crash_me10' ### ###As far as some queries didnt return OK, result is YES -reserved_word_ansi-92/99_call=yes # Keyword CALL +reserved_word_ansi-92/99_call=no # Keyword CALL ###< create table crash_me10 (CALL int not null) - ###> execute error: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 'CALL int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi-92/99_cascade=yes # Keyword CASCADE ###< create table crash_me10 (CASCADE int not null) ###> execute error: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 'CASCADE int not null)' at line 1 @@ -2583,13 +2580,13 @@ reserved_word_ansi-92/99_connect=no # Keyword CONNECT ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi-92/99_connection=yes # Keyword CONNECTION +reserved_word_ansi-92/99_connection=no # Keyword CONNECTION ###< create table crash_me10 (CONNECTION int not null) - ###> execute error: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 'CONNECTION int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi-92/99_constraint=yes # Keyword CONSTRAINT ###< create table crash_me10 (CONSTRAINT int not null) ###> execute error: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 'int not null)' at line 1 @@ -2604,13 +2601,13 @@ reserved_word_ansi-92/99_constraints=no # Keyword CONSTRAINTS ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi-92/99_continue=yes # Keyword CONTINUE +reserved_word_ansi-92/99_continue=no # Keyword CONTINUE ###< create table crash_me10 (CONTINUE int not null) - ###> execute error: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 'CONTINUE int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi-92/99_corresponding=no # Keyword CORRESPONDING ###< create table crash_me10 (CORRESPONDING int not null) ###> OK @@ -2667,13 +2664,13 @@ reserved_word_ansi-92/99_current_user=no # Keyword CURRENT_USER ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi-92/99_cursor=yes # Keyword CURSOR +reserved_word_ansi-92/99_cursor=no # Keyword CURSOR ###< create table crash_me10 (CURSOR int not null) - ###> execute error: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 'CURSOR int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi-92/99_cycle=no # Keyword CYCLE ###< create table crash_me10 (CYCLE int not null) ###> OK @@ -2723,13 +2720,13 @@ reserved_word_ansi-92/99_decimal=yes # Keyword DECIMAL ###> execute error:Unknown table 'crash_me10' ### ###As far as some queries didnt return OK, result is YES -reserved_word_ansi-92/99_declare=yes # Keyword DECLARE +reserved_word_ansi-92/99_declare=no # Keyword DECLARE ###< create table crash_me10 (DECLARE int not null) - ###> execute error: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 'DECLARE int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi-92/99_default=yes # Keyword DEFAULT ###< create table crash_me10 (DEFAULT int not null) ###> execute error: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 'DEFAULT int not null)' at line 1 @@ -2849,13 +2846,13 @@ reserved_word_ansi-92/99_else=yes # Keyword ELSE ###> execute error:Unknown table 'crash_me10' ### ###As far as some queries didnt return OK, result is YES -reserved_word_ansi-92/99_elseif=yes # Keyword ELSEIF +reserved_word_ansi-92/99_elseif=no # Keyword ELSEIF ###< create table crash_me10 (ELSEIF int not null) - ###> execute error: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 'ELSEIF int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi-92/99_end=no # Keyword END ###< create table crash_me10 (END int not null) ###> OK @@ -2926,13 +2923,13 @@ reserved_word_ansi-92/99_false=yes # Keyword FALSE ###> execute error:Unknown table 'crash_me10' ### ###As far as some queries didnt return OK, result is YES -reserved_word_ansi-92/99_fetch=yes # Keyword FETCH +reserved_word_ansi-92/99_fetch=no # Keyword FETCH ###< create table crash_me10 (FETCH int not null) - ###> execute error: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 'FETCH int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi-92/99_first=no # Keyword FIRST ###< create table crash_me10 (FIRST int not null) ###> OK @@ -2961,13 +2958,13 @@ reserved_word_ansi-92/99_foreign=yes # Keyword FOREIGN ###> execute error:Unknown table 'crash_me10' ### ###As far as some queries didnt return OK, result is YES -reserved_word_ansi-92/99_found=yes # Keyword FOUND +reserved_word_ansi-92/99_found=no # Keyword FOUND ###< create table crash_me10 (FOUND int not null) - ###> execute error: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 'FOUND int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi-92/99_from=yes # Keyword FROM ###< create table crash_me10 (FROM int not null) ###> execute error: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 'FROM int not null)' at line 1 @@ -3199,13 +3196,13 @@ reserved_word_ansi-92/99_leading=yes # Keyword LEADING ###> execute error:Unknown table 'crash_me10' ### ###As far as some queries didnt return OK, result is YES -reserved_word_ansi-92/99_leave=yes # Keyword LEAVE +reserved_word_ansi-92/99_leave=no # Keyword LEAVE ###< create table crash_me10 (LEAVE int not null) - ###> execute error: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 'LEAVE int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi-92/99_left=yes # Keyword LEFT ###< create table crash_me10 (LEFT int not null) ###> execute error: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 'LEFT int not null)' at line 1 @@ -3248,13 +3245,13 @@ reserved_word_ansi-92/99_local=no # Keyword LOCAL ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi-92/99_loop=yes # Keyword LOOP +reserved_word_ansi-92/99_loop=no # Keyword LOOP ###< create table crash_me10 (LOOP int not null) - ###> execute error: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 'LOOP int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi-92/99_match=yes # Keyword MATCH ###< create table crash_me10 (MATCH int not null) ###> execute error: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 'MATCH int not null)' at line 1 @@ -3605,20 +3602,20 @@ reserved_word_ansi-92/99_restrict=yes # Keyword RESTRICT ###> execute error:Unknown table 'crash_me10' ### ###As far as some queries didnt return OK, result is YES -reserved_word_ansi-92/99_return=yes # Keyword RETURN +reserved_word_ansi-92/99_return=no # Keyword RETURN ###< create table crash_me10 (RETURN int not null) - ###> execute error: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 'RETURN int not null)' at line 1 - ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' - ### - ###As far as some queries didnt return OK, result is YES -reserved_word_ansi-92/99_returns=no # Keyword RETURNS - ###< create table crash_me10 (RETURNS int not null) ###> OK ###< drop table crash_me10 ###> OK ### ###As far as all queries returned OK, result is NO +reserved_word_ansi-92/99_returns=yes # Keyword RETURNS + ###< create table crash_me10 (RETURNS int not null) + ###> execute error: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 'RETURNS int not null)' at line 1 + ###< drop table crash_me10 + ###> execute error:Unknown table 'crash_me10' + ### + ###As far as some queries didnt return OK, result is YES reserved_word_ansi-92/99_revoke=yes # Keyword REVOKE ###< create table crash_me10 (REVOKE int not null) ###> execute error: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 'REVOKE int not null)' at line 1 @@ -3780,34 +3777,34 @@ reserved_word_ansi-92/99_space=no # Keyword SPACE ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi-92/99_sql=yes # Keyword SQL +reserved_word_ansi-92/99_sql=no # Keyword SQL ###< create table crash_me10 (SQL int not null) - ###> execute error: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 'SQL int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES -reserved_word_ansi-92/99_sqlexception=yes # Keyword SQLEXCEPTION + ###As far as all queries returned OK, result is NO +reserved_word_ansi-92/99_sqlexception=no # Keyword SQLEXCEPTION ###< create table crash_me10 (SQLEXCEPTION int not null) - ###> execute error: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 'SQLEXCEPTION int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES -reserved_word_ansi-92/99_sqlstate=yes # Keyword SQLSTATE + ###As far as all queries returned OK, result is NO +reserved_word_ansi-92/99_sqlstate=no # Keyword SQLSTATE ###< create table crash_me10 (SQLSTATE int not null) - ###> execute error: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 'SQLSTATE int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES -reserved_word_ansi-92/99_sqlwarning=yes # Keyword SQLWARNING + ###As far as all queries returned OK, result is NO +reserved_word_ansi-92/99_sqlwarning=no # Keyword SQLWARNING ###< create table crash_me10 (SQLWARNING int not null) - ###> execute error: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 'SQLWARNING int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi-92/99_structure=no # Keyword STRUCTURE ###< create table crash_me10 (STRUCTURE int not null) ###> OK @@ -4032,13 +4029,13 @@ reserved_word_ansi-92/99_where=yes # Keyword WHERE ###> execute error:Unknown table 'crash_me10' ### ###As far as some queries didnt return OK, result is YES -reserved_word_ansi-92/99_while=yes # Keyword WHILE +reserved_word_ansi-92/99_while=no # Keyword WHILE ###< create table crash_me10 (WHILE int not null) - ###> execute error: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 'WHILE int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi-92/99_with=yes # Keyword WITH ###< create table crash_me10 (WITH int not null) ###> execute error: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 'WITH int not null)' at line 1 @@ -4130,13 +4127,13 @@ reserved_word_ansi92_coalesce=no # Keyword COALESCE ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi92_convert=no # Keyword CONVERT +reserved_word_ansi92_convert=yes # Keyword CONVERT ###< create table crash_me10 (CONVERT int not null) - ###> OK + ###> execute error: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 'CONVERT int not null)' at line 1 ###< drop table crash_me10 - ###> OK + ###> execute error:Unknown table 'crash_me10' ### - ###As far as all queries returned OK, result is NO + ###As far as some queries didnt return OK, result is YES reserved_word_ansi92_count=no # Keyword COUNT ###< create table crash_me10 (COUNT int not null) ###> OK @@ -4158,13 +4155,13 @@ reserved_word_ansi92_extract=no # Keyword EXTRACT ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi92_insensitive=yes # Keyword INSENSITIVE +reserved_word_ansi92_insensitive=no # Keyword INSENSITIVE ###< create table crash_me10 (INSENSITIVE int not null) - ###> execute error: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 'INSENSITIVE int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi92_lower=no # Keyword LOWER ###< create table crash_me10 (LOWER int not null) ###> OK @@ -4263,13 +4260,13 @@ reserved_word_ansi92_replace=yes # Keyword REPLACE ###> execute error:Unknown table 'crash_me10' ### ###As far as some queries didnt return OK, result is YES -reserved_word_ansi92_sensitive=yes # Keyword SENSITIVE +reserved_word_ansi92_sensitive=no # Keyword SENSITIVE ###< create table crash_me10 (SENSITIVE int not null) - ###> execute error: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 'SENSITIVE int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi92_similar=no # Keyword SIMILAR ###< create table crash_me10 (SIMILAR int not null) ###> OK @@ -4417,13 +4414,13 @@ reserved_word_ansi99_clob=no # Keyword CLOB ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi99_condition=yes # Keyword CONDITION +reserved_word_ansi99_condition=no # Keyword CONDITION ###< create table crash_me10 (CONDITION int not null) - ###> execute error: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 'CONDITION int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi99_constructor=no # Keyword CONSTRUCTOR ###< create table crash_me10 (CONSTRUCTOR int not null) ###> OK @@ -4487,13 +4484,13 @@ reserved_word_ansi99_destructor=no # Keyword DESTRUCTOR ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi99_deterministic=yes # Keyword DETERMINISTIC +reserved_word_ansi99_deterministic=no # Keyword DETERMINISTIC ###< create table crash_me10 (DETERMINISTIC int not null) - ###> execute error: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 'DETERMINISTIC int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi99_do=no # Keyword DO ###< create table crash_me10 (DO int not null) ###> OK @@ -4515,13 +4512,13 @@ reserved_word_ansi99_every=no # Keyword EVERY ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi99_exit=yes # Keyword EXIT +reserved_word_ansi99_exit=no # Keyword EXIT ###< create table crash_me10 (EXIT int not null) - ###> execute error: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 'EXIT int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi99_expand=no # Keyword EXPAND ###< create table crash_me10 (EXPAND int not null) ###> OK @@ -4585,20 +4582,20 @@ reserved_word_ansi99_initialize=no # Keyword INITIALIZE ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi99_inout=yes # Keyword INOUT +reserved_word_ansi99_inout=no # Keyword INOUT ###< create table crash_me10 (INOUT int not null) - ###> execute error: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 'INOUT int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES -reserved_word_ansi99_iterate=yes # Keyword ITERATE + ###As far as all queries returned OK, result is NO +reserved_word_ansi99_iterate=no # Keyword ITERATE ###< create table crash_me10 (ITERATE int not null) - ###> execute error: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 'ITERATE int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi99_large=no # Keyword LARGE ###< create table crash_me10 (LARGE int not null) ###> OK @@ -4669,13 +4666,13 @@ reserved_word_ansi99_ordinality=no # Keyword ORDINALITY ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi99_out=yes # Keyword OUT +reserved_word_ansi99_out=no # Keyword OUT ###< create table crash_me10 (OUT int not null) - ###> execute error: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 'OUT int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi99_parameter=no # Keyword PARAMETER ###< create table crash_me10 (PARAMETER int not null) ###> OK @@ -4732,13 +4729,13 @@ reserved_word_ansi99_redo=no # Keyword REDO ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi99_repeat=yes # Keyword REPEAT +reserved_word_ansi99_repeat=no # Keyword REPEAT ###< create table crash_me10 (REPEAT int not null) - ###> execute error: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 'REPEAT int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi99_result=no # Keyword RESULT ###< create table crash_me10 (RESULT int not null) ###> OK @@ -4760,13 +4757,13 @@ reserved_word_ansi99_sets=no # Keyword SETS ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi99_specific=yes # Keyword SPECIFIC +reserved_word_ansi99_specific=no # Keyword SPECIFIC ###< create table crash_me10 (SPECIFIC int not null) - ###> execute error: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 'SPECIFIC int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi99_specifictype=no # Keyword SPECIFICTYPE ###< create table crash_me10 (SPECIFICTYPE int not null) ###> OK @@ -4823,13 +4820,13 @@ reserved_word_ansi99_treat=no # Keyword TREAT ###> OK ### ###As far as all queries returned OK, result is NO -reserved_word_ansi99_undo=yes # Keyword UNDO +reserved_word_ansi99_undo=no # Keyword UNDO ###< create table crash_me10 (UNDO int not null) - ###> execute error: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 'UNDO int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_ansi99_until=no # Keyword UNTIL ###< create table crash_me10 (UNTIL int not null) ###> OK @@ -5327,13 +5324,13 @@ reserved_word_extra_low_priority=yes # Keyword LOW_PRIORITY ###> execute error:Unknown table 'crash_me10' ### ###As far as some queries didnt return OK, result is YES -reserved_word_extra_master_server_id=yes # Keyword MASTER_SERVER_ID +reserved_word_extra_master_server_id=no # Keyword MASTER_SERVER_ID ###< create table crash_me10 (MASTER_SERVER_ID int not null) - ###> execute error: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 'MASTER_SERVER_ID int not null)' at line 1 + ###> OK ###< drop table crash_me10 - ###> execute error:Unknown table 'crash_me10' + ###> OK ### - ###As far as some queries didnt return OK, result is YES + ###As far as all queries returned OK, result is NO reserved_word_extra_maxextents=no # Keyword MAXEXTENTS ###< create table crash_me10 (MAXEXTENTS int not null) ###> OK @@ -6062,7 +6059,7 @@ select_without_from=yes # SELECT without FROM ###> OK ### ###As far as all queries returned OK, result is YES -server_version=MySQL 5.0.0 alpha debug log/ # server version +server_version=MySQL 4.1.2 alpha # server version simple_joins=yes # ANSI SQL simple joins ###< select crash_me.a from crash_me, crash_me t0 ###> OK @@ -6229,7 +6226,7 @@ time_format_inresult=iso # Time format in result ###> OK ### ###< select a from crash_me_t - ###> 09:46:11 + ###> 13:49:05 ###< delete from crash_me_t ###> OK transactions=yes # transactions |