#This file is automaticly generated by crash-me 1.61 NEG=yes # update of column= -column ###< create table crash_q (a integer) ###> OK ###< insert into crash_q values(10) ###> OK ###< update crash_q set a=-a ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES Need_cast_for_null=no # Need to cast NULL for arithmetic ### Check if numeric_null (NULL) is 'NULL' alter_add_col=yes # Alter table add column ###< alter table crash_q add d integer ###> OK ### ###As far as all queries returned OK, result is YES alter_add_constraint=yes # Alter table add constraint ###< alter table crash_q add constraint c2 check(a > b) ###> OK ### ###As far as all queries returned OK, result is YES alter_add_foreign_key=no # Alter table add foreign key ###< alter table crash_q add constraint f1 foreign key(c1) ###> 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 '' at line 1 ###< references crash_q1(c1) ###> 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 'references crash_q1(c1)' at line 1 ### ###As far as some queries didnt return OK, result is NO alter_add_multi_col=yes # Alter table add many columns ###< alter table crash_q add (f integer,g integer) ###> OK alter_add_primary_key=with constraint # Alter table add primary key ###< alter table crash_q1 add constraint p1 primary key(c1) ###> OK alter_add_unique=yes # Alter table add unique ###< alter table crash_q add constraint u1 unique(c1) ###> OK ### ###As far as all queries returned OK, result is YES alter_alter_col=yes # Alter table alter column default ###< alter table crash_q alter b set default 10 ###> OK ### ###As far as all queries returned OK, result is YES alter_change_col=yes # Alter table change column ###< alter table crash_q change a e char(50) ###> OK ### ###As far as all queries returned OK, result is YES alter_drop_col=yes # Alter table drop column ###< alter table crash_q drop column b ###> OK alter_drop_constraint=no # Alter table drop constraint ###< alter table crash_q drop constraint c2 ###> 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 'constraint c2' at line 1 ### ###< alter table crash_q drop constraint c2 restrict ###> 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 'constraint c2 restrict' at line 1 alter_drop_foreign_key=with drop foreign key # Alter table drop foreign key ###< alter table crash_q drop constraint f1 ###> 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 'constraint f1' at line 1 ### ###< alter table crash_q drop constraint f1 restrict ###> 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 'constraint f1 restrict' at line 1 ### ###< alter table crash_q drop foreign key f1 ###> OK alter_drop_primary_key=drop primary key # Alter table drop primary key ###< alter table crash_q1 drop constraint p1 restrict ###> 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 'constraint p1 restrict' at line 1 ### ###< alter table crash_q1 drop primary key ###> OK alter_drop_unique=with drop key # Alter table drop unique ###< alter table crash_q drop constraint u1 ###> 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 'constraint u1' at line 1 ### ###< alter table crash_q drop constraint u1 restrict ###> 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 'constraint u1 restrict' at line 1 ### ###< alter table crash_q drop key u1 ###> OK alter_modify_col=yes # Alter table modify column ###< alter table crash_q modify c1 CHAR(20) ###> OK alter_rename_table=yes # Alter table rename table ###< alter table crash_q rename to crash_q1 ###> OK ### ###As far as all queries returned OK, result is YES atomic_updates=no # atomic updates ###< create table crash_q (a integer not null,primary key (a)) ###> OK ###< insert into crash_q values (2) ###> OK ###< insert into crash_q values (3) ###> OK ###< insert into crash_q values (1) ###> OK ###< update crash_q set a=a+1 ###> execute error:Duplicate entry '3' for key 1 ###< drop table crash_q ###> OK ### ###As far as some queries didnt return OK, result is NO automatic_rowid=_rowid # Automatic row id ###< create table crash_q (a int not null, primary key(a)) ###> OK ###< insert into crash_q values (1) ###> OK ###< select _rowid from crash_q ###> OK ###< drop table crash_q ###> OK binary_numbers=no # binary numbers (0b1001) ###< select 0b1001 ###> execute error:Unknown column '0b1001' in 'field list' ### ###As far as some queries didnt return OK, result is NO binary_strings=no # binary strings (b'0110') ###< select b'0110' ###> execute error:Unknown column 'b' in 'field list' ### ###As far as some queries didnt return OK, result is NO case_insensitive_strings=yes # Case insensitive compare ### ###aa ###We expected 'a a ' but got 'aa' column_alias=yes # Column alias ###< select a as ab from crash_me ###> OK ### ###As far as all queries returned OK, result is YES columns_in_group_by=+64 # number of columns in group by ###We are trying (example with N=5): ###create table crash_q (q1 integer,q2 integer,q3 integer,q4 integer,q5 integer) ###insert into crash_q values(1,1,1,1,1) ###insert into crash_q values(1,1,1,1,1) ###select q1,q2,q3,q4,q5 from crash_q group by q1,q2,q3,q4,q5 columns_in_order_by=+64 # number of columns in order by ###We are trying (example with N=5): ###create table crash_q (q1 integer,q2 integer,q3 integer,q4 integer,q5 integer) ###insert into crash_q values(1,1,1,1,1) ###insert into crash_q values(1,1,1,1,1) ###select * from crash_q order by q1,q2,q3,q4,q5 comment_#=yes # # as comment ###< select * from crash_me # Testing of comments ###> OK ### ###As far as all queries returned OK, result is YES comment_--=yes # -- as comment (ANSI) ###< select * from crash_me -- Testing of comments ###> OK ### ###As far as all queries returned OK, result is YES comment_/**/=yes # /* */ as comment ###< select * from crash_me /* Testing of comments */ ###> OK ### ###As far as all queries returned OK, result is YES comment_//=no # // as comment ###< select * from crash_me // Testing of comments ###> 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 '// Testing of comments' at line 1 ### ###As far as some queries didnt return OK, result is NO compute=no # Compute ###< select a from crash_me order by a compute sum(a) by a ###> 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 'compute sum(a) by a' at line 1 ### ###As far as some queries didnt return OK, result is NO connections=101 # Simultaneous connections (installation default) constraint_check=syntax only # Column constraints ###< create table crash_q (a int check (a>0)) ###> OK ### ###< insert into crash_q values(0) ###> OK ### ###< drop table crash_q ###> OK constraint_check_named=syntax only # Named constraints ###< create table crash_q (a int ,b int, constraint abc check (a>b)) ###> OK ### ###< insert into crash_q values(0,0) ###> OK ### ###< drop table crash_q ###> OK constraint_check_table=syntax only # Table constraints ###< create table crash_q (a int ,b int, check (a>b)) ###> OK ### ###< insert into crash_q values(0,0) ###> OK ### ###< drop table crash_q ###> OK constraint_null=yes # NULL constraint (SyBase style) ###< create table crash_q (a int null) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES crash_me_safe=yes # crash me safe crash_me_version=1.61 # crash me version create_default=yes # default value for column ###< create table crash_q (q integer default 10 not null) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES create_default_func=no # default value function for column ###< create table crash_q (q integer not null,q1 integer default (1+1)) ###> 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 '(1+1))' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO create_if_not_exists=yes # create table if not exists ###< create table crash_q (q integer) ###> OK ###< create table if not exists crash_q (q integer) ###> OK ### ###As far as all queries returned OK, result is YES create_index=yes # create index ###< create index crash_q on crash_me (a) ###> OK create_schema=no # Create SCHEMA ###< create schema crash_schema create table crash_q (a int) create table crash_q2(b int) ###> 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 'schema crash_schema create table crash_q (a int) create table c ###< drop schema crash_schema 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 'schema crash_schema cascade' at line 1 ### ###As far as some queries didnt return OK, result is NO create_table_select=yes # create table from select ###< create table crash_q SELECT * from crash_me ###> OK cross_join=yes # cross join (same as from a,b) ###< select crash_me.a from crash_me cross join crash_me3 ###> OK ### ###As far as all queries returned OK, result is YES date_as_string=yes # String functions on date columns ###< create table crash_me2 (a date not null) ###> OK ###< insert into crash_me2 values ('1998-03-03') ###> OK ### ###0000-00-00 ###We expected '1963-08-16' but got '0000-00-00' ### ###< delete from crash_me_d ###> OK date_format_EUR_with_date=error # Supports DATE 'DD.MM.YYYY' (EUR) format ###< insert into crash_me_d(a) values (DATE '16.08.1963') ###> OK ### ###1963-08-16 ### ###< delete from crash_me_d ###> OK date_format_ISO_with_date=yes # Supports DATE 'YYYY-MM-DD' (ISO) format ###< insert into crash_me_d(a) values (DATE '1963-08-16') ###> OK ### ###0000-00-00 ###We expected '1963-08-16' but got '0000-00-00' ### ###< delete from crash_me_d ###> OK date_format_USA_with_date=error # Supports DATE 'MM/DD/YYYY' format ###< insert into crash_me_d(a) values (DATE '08/16/1963') ###> OK ### ###1963-08-16 ### ###< delete from crash_me_d ###> OK date_format_YYYYMMDD_with_date=yes # Supports DATE 'YYYYMMDD' format ###< insert into crash_me_d(a) values (DATE '19630816') ###> OK ### ###0000-00-00 ###We expected 'infinity' but got '0000-00-00' ### ###< drop table crash_me2 ###> OK date_last=yes # Supports 9999-12-31 dates ###< create table crash_me2 (a date not null) ###> OK ###< insert into crash_me2 values ('9999-12-31') ###> OK ### ###0001-01-01 ### ###< drop table crash_me2 ###> OK date_with_YY=yes # Supports YY-MM-DD 2000 compilant dates ###< create table crash_me2 (a date not null) ###> OK ###< insert into crash_me2 values ('98-03-03') ###> OK ### ###2010-03-03 ### ###< drop table crash_me2 ###> OK date_zero=yes # Supports 0000-00-00 dates ###< create table crash_me2 (a date not null) ###> OK ###< insert into crash_me2 values ('0000-00-00') ###> OK ### ###Walker's drop_if_exists=yes # drop table if exists ###< create table crash_q (q integer) ###> OK ###< drop table if exists crash_q ###> OK ### ###As far as all queries returned OK, result is YES drop_index=with 'ON' # drop index ###< drop index 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 '' at line 1 ### ###< drop index crash_q from crash_me ###> 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 crash_me' at line 1 ### ###< drop index crash_q on crash_me ###> OK drop_requires_cascade=no # drop table require cascade/restrict ###< create table crash_me (a integer not null) ###> OK ###< drop table crash_me ###> OK drop_restrict=yes # drop table with cascade/restrict ###< create table crash_q (a int) ###> OK ###< drop table crash_q restrict ###> OK ### ###As far as all queries returned OK, result is YES end_colon=yes # allows end ';' ###< select * from crash_me; ###> OK ### ###As far as all queries returned OK, result is YES except=no # except ###< select * from crash_me except select * from crash_me3 ###> 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 'select * from crash_me3' at line 1 ### ###As far as some queries didnt return OK, result is NO except_all=no # except all ###< select * from crash_me except all select * from crash_me3 ###> 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 'all select * from crash_me3' at line 1 ### ###As far as some queries didnt return OK, result is NO except_all_incompat=no # except all (incompatible lists) ###< select * from crash_me except all select * from crash_me2 ###> 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 'all select * from crash_me2' at line 1 ### ###As far as some queries didnt return OK, result is NO except_incompat=no # except (incompatible lists) ###< select * from crash_me except select * from crash_me2 ###> 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 'select * from crash_me2' at line 1 ### ###As far as some queries didnt return OK, result is NO field_name_case=yes # case independent field names ###< create table crash_q (q integer) ###> OK ###< insert into crash_q(Q) values (1) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES float_int_expr=yes # mixing of integer and float in expression ###< select 1+1.0 ###> OK ### ###As far as all queries returned OK, result is YES foreign_key=syntax only # foreign keys ###< create table crash_me_qf (a integer not null,primary key (a)) ###> OK ### ###< create table crash_me_qf2 (a integer not null,foreign key (a) references crash_me_qf (a)) ###> OK ### ###< insert into crash_me_qf values (1) ###> OK ### ###< insert into crash_me_qf2 values (2) ###> OK ### ###< drop table crash_me_qf2 ###> OK ### ###< drop table crash_me_qf ###> OK full_outer_join=no # full outer join ###< select crash_me.a from crash_me full join crash_me2 ON ### crash_me.a=crash_me2.a ###> execute error:Unknown table 'crash_me' in field list ### ###As far as some queries didnt return OK, result is NO func_extra_!=yes # Function NOT as '!' in SELECT ### ###3 func_extra_&=yes # Function & (bitwise and) ### ###1 func_extra_<>=yes # Function <> in SELECT ### ###1 func_extra_add_months=no # Function ADD_MONTHS ### ###2002-12-04 func_extra_addtime=yes # Function ADDTIME ### ### 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 '('Aâ',2)' at line 1 func_extra_and_or=yes # Function AND and OR in SELECT ### ### 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 '(65)' at line 1 func_extra_ascii_code=no # Function ASCII_CODE ### ###97 ###We expected 'a' but got '97' func_extra_atn2=no # Function ATN2 ### ###a2 func_extra_auto_string2num=yes # Function automatic string->num convert ### ###1 func_extra_binary_shifts=yes # Function << and >> (bitwise shifts) ### ###2 func_extra_ceil=yes # Function CEIL ### ### execute failed:Unknown column 'EUR' in 'field list' func_extra_charindex=no # Function CHARINDEX ### ### 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 '(65)' at line 1 func_extra_chr_str=no # Function CHR (any type to string) ### ###0 ###We expected 'abcdef' but got '0' func_extra_concat_list=yes # Function CONCAT(list) ### ### 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 '5)' at line 1 func_extra_cosh=no # Function COSH ### ###1963-08-16 func_extra_date_format=yes # Function DATE_FORMAT ### ### 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 '(day,3,'1997-11-30') from crash_me_d' at line 1 func_extra_datediff=no # Function DATEDIFF ### ###3 func_extra_datename=no # Function DATENAME ### ### 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 '(month,'July 20 1997') from crash_me_d' at line 1 func_extra_day=yes # Function DAY ### ### 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 '1,'S-103',2,'Leopard',3)' at line 1 func_extra_ebcdic_string=no # Function EBCDIC in string cast ### ###TWO func_extra_encrypt=yes # Function ENCRYPT ### ### 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 '('abcd',6)' at line 1 func_extra_field=yes # Function FIELD ### ### 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 '(222.6666,10,2)' at line 1 func_extra_float=no # Function FLOAT ### ###1,234.56 func_extra_from_days=yes # Function FROM_DAYS ### ###1970-01-01 02:00:00 func_extra_getdate=no # Function GETDATE ### ###HARRY func_extra_hex=yes # Function HEX ### ###6 func_extra_in_num=yes # Function IN on numbers in SELECT ### ###1 func_extra_index=no # Function INDEX ### ### 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 '('the soap')' at line 1 func_extra_instr=yes # Function LOCATE as INSTR ### ### 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 '3,2)' at line 1 func_extra_instrb=no # Function INSTRB ### ###5 func_extra_last_day=yes # Function LAST_DAY ### ###0 func_extra_least=yes # Function LEAST ### ###1 ###We expected '2' but got '1' func_extra_lengthb=no # Function LENGTHB ### ### 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 '('abcd','.',6)' at line 1 func_extra_like=yes # Function LIKE in SELECT ### ###1 func_extra_ln=yes # Function LN ### ###2.000000 func_extra_logn=no # Function LOGN ### ###??hi func_extra_ltrim2arg=no # Function LTRIM (2 arg) ### ###1963-08-16 func_extra_maketime=yes # Function MAKETIME ### ### 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 '('Aâ')' at line 1 func_extra_mdy=no # Function MDY ### ###110000 func_extra_mid=yes # Function SUBSTRING as MID ### ### 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 '('1997-02-02','1997-01-01') from crash_me_d' at line 1 func_extra_noround=no # Function NOROUND ###< select noround(22.6) ###> 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 '(22.6)' at line 1 func_extra_not=yes # Function NOT in SELECT ### ###0 func_extra_not_like=yes # Function NOT LIKE in SELECT ### ### 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 '('2123')' at line 1 func_extra_odbc_convert=no # Function ODBC CONVERT ### ###*6B4F89A54E2D27ECD7E8DA05B4AB8FD9D1D8B119 func_extra_paste=no # Function PASTE ### ### 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 '('%a%','crash')' at line 1 func_extra_period_add=yes # Function PERIOD_ADD ### ###13 func_extra_pow=yes # Function POW ### ### 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 '(a)' at line 1 func_extra_regexp=yes # Function REGEXP in SELECT ### ### 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 func_extra_replicate=no # Function REPLICATE ### ###dcba func_extra_rfill3arg=no # Function RFILL (3 arg) ### ### 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 '(4)' at line 1 func_extra_round1=yes # Function ROUND(1 arg) ### ###hi?? func_extra_rpad4arg=no # Function RPAD (4 arg) ### ### 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 func_extra_sec_to_time=yes # Function SEC_TO_TIME ### ### 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 '(1)' at line 1 func_extra_str=no # Function STR ### ###-1 func_extra_stuff=no # Function STUFF ### ###2002-12-01 func_extra_substr2arg=yes # Function SUBSTR (2 arg) ### ###bc func_extra_substrb=no # Function SUBSTRB ### ###tcx.se func_extra_subtime=yes # Function SUBTIME ### ###2004-04-06 13:49:05 func_extra_tail=no # Function TAIL ### ### 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 '(1)' at line 1 func_extra_time=yes # Function TIME ### ###5001 func_extra_timediff=yes # Function TIMEDIFF ### ###1963-08-16 20:02:12 ###We expected '19630816200212000000' but got '1963-08-16 20:02:12' func_extra_to_days=yes # Function TO_DAYS ### ### 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 '('abc','bc','de')' at line 1 func_extra_trim1arg=yes # Function TRIM (1 arg) ### ### 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 func_extra_trim_many_char=error # Function TRIM; Many char extension ### ###abc func_extra_trunc=no # Function TRUNC ### ### 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 '(222.6)' at line 1 func_extra_uid=no # Function UID ### ###1081248545 func_extra_userenv=no # Function USERENV ### ### 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 '(NULL,'WALRUS')' at line 1 func_extra_version=yes # Function VERSION ### ###5 func_extra_weekofyear=yes # Function WEEKOFYEAR ### ###3 func_extra_||=yes # Function OR as '||' ### ### 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 '~* 'HI'' at line 1 func_odbc_abs=yes # Function ABS ### ###1.570796 func_odbc_ascii=yes # Function ASCII ### ###1.570796 func_odbc_atan=yes # Function ATAN ### ###1.570796 func_odbc_ceiling=yes # Function CEILING ### ###A func_odbc_concat=yes # Function CONCAT(2 arg) ### ###1.000000 func_odbc_cot=yes # Function COT ### ###2004-04-06 func_odbc_curtime=yes # Function CURTIME ### ###test func_odbc_dayname=yes # Function DAYNAME ###< insert into crash_me_d values('1997-02-01') ### ###1 func_odbc_dayofweek=yes # Function DAYOFWEEK ###< insert into crash_me_d values('1997-02-01') ### ###32 func_odbc_degrees=yes # Function DEGREES ### ### 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 '('abc','abe')' at line 1 ### ###2.718282 func_odbc_floor=yes # Function FLOOR ### ###c func_odbc_hour=yes # Function HOUR ###< insert into crash_me_t values(20:08:16) ### ###12 func_odbc_ifnull=yes # Function IFNULL ### ###aefd func_odbc_lcase=yes # Function LCASE ### ###ab func_odbc_length=yes # Function REAL LENGTH ### ###5 ###We expected '4' but got '5' ### ###2 func_odbc_locate_3=yes # Function LOCATE(3 arg) ### ###0.693147 func_odbc_log10=yes # Function LOG10 ### ###abcd func_odbc_minute=yes # Function MINUTE ###< insert into crash_me_t values(20:08:16) ### ###4 func_odbc_month=yes # Function MONTH ###< insert into crash_me_d values('1997-02-01') ### ###February func_odbc_now=yes # Function NOW ### ###3.141593 func_odbc_power=yes # Function POWER ### ###1 func_odbc_radians=yes # Function RADIANS ### ###0.40540353712198 func_odbc_repeat=yes # Function REPEAT ### ###bababa func_odbc_right=yes # Function RIGHT ### ###5.63 func_odbc_rtrim=yes # Function RTRIM ### ###14 func_odbc_sign=yes # Function SIGN ### ###0.841471 func_odbc_soundex=yes # Function SOUNDEX ### ### func_odbc_sqrt=yes # Function SQRT ### ###cd func_odbc_tan=yes # Function TAN ### ### 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 ### ### 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')' ### ###10 func_odbc_ucase=yes # Function UCASE ### ###monty@localhost func_odbc_week=USA # WEEK ###1997 func_sql_+=yes # Function +, -, * and / ### ###24 func_sql_cast=yes # Function CAST ### ###1 ###We expected '10' but got '1' func_sql_char_length(constant)=yes # Function CHAR_LENGTH(constant) ### ###4 func_sql_coalesce=yes # Function COALESCE ### ###0 ###We expected 'abcdef' but got '0' func_sql_current_date=yes # Function CURRENT_DATE ### ###13:49:04 func_sql_current_timestamp=yes # Function CURRENT_TIMESTAMP ### ###43 func_sql_localtime=yes # Function LOCALTIME ### ###2004-04-06 13:49:04 func_sql_lower=yes # Function LOWER ### ### func_sql_nullif_string=yes # Function NULLIF with strings ### ###3 func_sql_position=yes # Function POSITION ### ### 2 then 'false' when 2 > 1 then 'true' end ###>true func_sql_session_user=with_parenthesis # SESSION_USER ###< select SESSION_USER ###> execute error:Unknown column 'SESSION_USER' in 'field list' ### ###< select SESSION_USER() ###> OK func_sql_simple_case=yes # Function simple CASE ### ###bc func_sql_system_user=with_parenthesis # SYSTEM_USER ###< select SYSTEM_USER ###> execute error:Unknown column 'SYSTEM_USER' in 'field list' ### ###< select SYSTEM_USER() ###> OK func_sql_trim=yes # Function TRIM ### ###ABC func_sql_user=with_parenthesis # USER ###< select USER ###> execute error:Unknown column 'USER' in 'field list' ### ###< select USER() ###> OK func_where_between=yes # Function BETWEEN ### ###1 func_where_eq_any=yes # Function = ANY ### ###1 func_where_exists=yes # Function EXISTS ### ###1 func_where_like=yes # Function LIKE ### ###1 func_where_match=no # Function MATCH ### ### 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 'match unique (select a from crash_me)' at line 1 func_where_matches=no # Function MATCHES ### ###1 func_where_not_exists=yes # Function NOT EXISTS ### ###1 func_where_not_unique=no # Function NOT UNIQUE ### ### 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 'unique (select * from crash_me)' at line 1 functions=yes # Functions ###< select 1+1 ###> OK ### ###As far as all queries returned OK, result is YES group_by=yes # Group by ###< select a from crash_me group by a ###> OK ### ###As far as all queries returned OK, result is YES group_by_alias=yes # Group by alias ###< select a as ab from crash_me group by ab ###> OK ### ###As far as all queries returned OK, result is YES group_by_null=yes # Group on column with null values ###< create table crash_q (s char(10)) ###> OK ###< insert into crash_q values(null) ###> OK ###< insert into crash_q values(null) ###> OK ### ###1 group_func_extra_bit_or=yes # Group function BIT_OR ### ###1 group_func_extra_std=yes # Group function STD ### ###0.0000 group_func_extra_variance=yes # Group function VARIANCE ### ### 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 '(a),a from crash_me group by a' at line 1 group_func_sql_avg=yes # Group function AVG ### ###1 group_func_sql_count_column=yes # Group function COUNT column name ### ###1 group_func_sql_every=no # Group function EVERY ### ###1 group_func_sql_max_str=yes # Group function MAX on strings ### ###1 group_func_sql_min_str=yes # Group function MIN on strings ### ### 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 '(a),a from crash_me group by a' at line 1 group_func_sql_sum=yes # Group function SUM ### ### 0 ###>1 ### ###a index_in_create=yes # index in create table ###< create table crash_q (q integer not null,index (q)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES index_namespace=yes # different namespace for index ###< create index crash_me on crash_me (b) ###> OK ###< drop index crash_me on crash_me ###> OK ### ###As far as all queries returned OK, result is YES index_parts=yes # index on column part (extension) ###< create index crash_q on crash_me (b(5)) ###> OK ###< drop index crash_q on crash_me ###> OK ### ###As far as all queries returned OK, result is YES inner_join=yes # inner join ###< select crash_me.a from crash_me inner join crash_me2 ON crash_me.a=crash_me2.a ###> OK ### ###As far as all queries returned OK, result is YES insert_default_values=no # INSERT DEFAULT VALUES ###< create table crash_me_q (a int) ###> OK ###< insert into crash_me_q DEFAULT VALUES ###> 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 VALUES' at line 1 ###< drop table crash_me_q ###> OK ### ###As far as some queries didnt return OK, result is NO insert_empty_string=yes # insert empty string ###< create table crash_q (a char(10) not null,b char(10)) ###> OK ###< insert into crash_q values ('','') ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES insert_multi_value=yes # INSERT with Value lists ###< create table crash_q (s char(10)) ###> OK ###< insert into crash_q values ('a'),('b') ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES insert_select=yes # insert INTO ... SELECT ... ###< create table crash_q (a int) ###> OK ###< insert into crash_q (a) SELECT crash_me.a from crash_me ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES insert_with_default=yes # INSERT with DEFAULT ###< create table crash_me_q (a int) ###> OK ###< insert into crash_me_q (a) values (DEFAULT) ###> OK ###< drop table crash_me_q ###> OK ### ###As far as all queries returned OK, result is YES insert_with_empty_value_list=no # INSERT with empty value list ###< create table crash_me_q (a int) ###> OK ###< insert into crash_me_q (a) values () ###> execute error:Column count doesn't match value count at row 1 ###< drop table crash_me_q ###> OK ### ###As far as some queries didnt return OK, result is NO insert_with_set=yes # INSERT with set syntax ###< create table crash_q (a integer) ###> OK ###< insert into crash_q SET a=1 ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES intersect=no # intersect ###< select * from crash_me intersect select * from crash_me3 ###> 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 'select * from crash_me3' at line 1 ### ###As far as some queries didnt return OK, result is NO intersect_all=no # intersect all ###< select * from crash_me intersect all select * from crash_me3 ###> 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 'all select * from crash_me3' at line 1 ### ###As far as some queries didnt return OK, result is NO intersect_all_incompat=no # intersect all (incompatible lists) ###< select * from crash_me intersect all select * from crash_me2 ###> 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 'all select * from crash_me2' at line 1 ### ###As far as some queries didnt return OK, result is NO intersect_incompat=no # intersect (incompatible lists) ###< select * from crash_me intersect select * from crash_me2 ###> 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 'select * from crash_me2' at line 1 ### ###As far as some queries didnt return OK, result is NO join_tables=61 # tables in join ###We are trying (example with N=5): ###select crash_me.a,t0.a,t1.a,t2.a,t3.a,t4.a from crash_me,crash_me t0,crash_me t1,crash_me t2,crash_me t3,crash_me t4 ### 32:OK 48:OK 56:OK 60:OK 62:FAIL 61:FAIL left_outer_join=yes # left outer join ###< select crash_me.a from crash_me left join crash_me2 ON crash_me.a=crash_me2.a ###> OK ### ###As far as all queries returned OK, result is YES left_outer_join_using=yes # left outer join using ###< select c1 from crash_me left join crash_me2 using (a) ###> OK ### ###As far as all queries returned OK, result is YES length_of_varchar_field=actual length # CHARACTER_LENGTH(varchar_field) ###< CREATE TABLE crash_me1 (S1 VARCHAR(100)) ###> OK ###< INSERT INTO crash_me1 VALUES ('X') ###> OK ### ###< SELECT CHARACTER_LENGTH(S1) FROM crash_me1 ### > 1 ###< drop table crash_me1 ###> OK like_with_column=yes # column LIKE column ###< create table crash_q (a char(10),b char(10)) ###> OK ###< insert into crash_q values('abc','abc') ###> OK ###< select * from crash_q where a like b ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES like_with_number=yes # LIKE on numbers ###< create table crash_q (a int,b int) ###> OK ###< insert into crash_q values(10,10) ###> OK ###< select * from crash_q where a like '10' ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES lock_tables=yes # lock table ###< lock table crash_me READ ###> OK ###< unlock tables ###> OK ### ###As far as all queries returned OK, result is YES logical_value=1 # Value of logical operation (1=1) ###2 multi_drop=yes # many tables to drop table ###< create table crash_q (a int) ###> OK ###< create table crash_q2 (a int) ###> OK ###< drop table crash_q,crash_q2 ###> OK ### ###As far as all queries returned OK, result is YES multi_null_in_unique=yes # null in unique index ###< create table crash_q (q integer, x integer,unique (q)) ###> OK ###< insert into crash_q(x) values(1) ###> OK ###< insert into crash_q(x) values(2) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES multi_strings=yes # Multiple line strings ### ###a ### ###< drop table crash_q ###> OK natural_join=yes # natural join ###< select * from crash_me natural join crash_me3 ###> OK ### ###As far as all queries returned OK, result is YES natural_join_incompat=yes # natural join (incompatible lists) ###< select c1 from crash_me natural join crash_me2 ###> OK ### ###As far as all queries returned OK, result is YES natural_left_outer_join=yes # natural left outer join ###< select c1 from crash_me natural left join crash_me2 ###> OK ### ###As far as all queries returned OK, result is YES no_primary_key=yes # Tables without primary key ###< create table crash_me (a integer not null,b char(10) not null) ###> OK ###< insert into crash_me (a,b) values (1,'a') ###> OK not_id_between=no # NOT ID BETWEEN interprets as ID NOT BETWEEN ###< create table crash_me_b (i int) ###> OK ###< insert into crash_me_b values(2) ###> OK ###< insert into crash_me_b values(5) ###> OK ### ### null_in_index=yes # null in index ###< create table crash_q (a char(10),index (a)) ###> OK ###< insert into crash_q values (NULL) ###> OK ### ### nulls_in_unique=yes # null combination in unique index ###< create table crash_q (q integer,q1 integer,unique (q,q1)) ###> OK ###< insert into crash_q (q,q1) values(1,NULL) ###> OK ###< insert into crash_q (q,q1) values(1,NULL) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES odbc_left_outer_join=yes # left outer join odbc style ###< select crash_me.a from { oj crash_me left outer join crash_me2 ON crash_me.a=crash_me2.a } ###> OK ### ###As far as all queries returned OK, result is YES 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 ### ###As far as all queries returned OK, result is YES order_by_alias=yes # Order by alias ###< select a as ab from crash_me order by ab ###> OK ### ###As far as all queries returned OK, result is YES order_by_function=yes # Order by function ###< select a from crash_me order by a+1 ###> OK ### ###As far as all queries returned OK, result is YES order_by_position=yes # Order by position ###< select a from crash_me order by 1 ###> OK ### ###As far as all queries returned OK, result is YES order_on_unused=yes # Order by on unused column ###< select b from crash_me order by a ###> OK ### ###As far as all queries returned OK, result is YES position_of_null=first # Where is null values in sorted recordset ###< insert into crash_me_n (i) values(1) ###> OK ###< insert into crash_me_n values(2,2) ###> OK ###< insert into crash_me_n values(3,3) ###> OK ###< insert into crash_me_n values(4,4) ###> OK ###< insert into crash_me_n (i) values(5) ###> OK ### ###< select r from crash_me_n order by r ###> ###> ###> 2 ###> 3 ###> 4 position_of_null_desc=last # Where is null values in sorted recordset (DESC) ###< select r from crash_me_n order by r desc ###> 4 ###> 3 ###> 2 ###> ###> primary_key_in_create=yes # primary key in create table ###< create table crash_q (q integer not null,primary key (q)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES 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 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: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 ### ###As far as some queries didnt return OK, result is NO psm_modules=no # PSM modules (ANSI SQL) ###< create table crash_q (a int,b int) ###> OK ###< 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: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 ###> OK ### ###As far as some queries didnt return OK, result is NO 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 'procedure crash_proc(in a1 int, in b1 int) language sql modifie ###< call crash_proc(1,10) ###> 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: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 ### ###As far as some queries didnt return OK, result is NO psm_trigger=no # Triggers (ANSI SQL) ###< create table crash_q (a int ,b int) ###> OK ###< create trigger crash_trigger after insert on crash_q referencing new table as new_a when (localtime > time '18:00:00') begin atomic 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 'trigger crash_trigger after insert on crash_q referencing new t ###< insert into crash_q values(1,2) ###> OK ###< drop trigger crash_trigger ###> 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 'trigger crash_trigger' at line 1 ###< drop table crash_q ###> OK ### ###As far as some queries didnt return OK, result is NO query_size=1048574 # query size quote_ident_with_"=error # " as identifier quote (ANSI SQL) ### ### 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 '[A] from crash_me' at line 1 quote_ident_with_`=yes # ` as identifier quote ### ###hello ###We expected 'hello ' but got 'hello' ### ###< drop table crash_q ###> OK remember_end_space_varchar=no # Remembers end space in varchar() ###< create table crash_q (a varchar(10)) ###> OK ###< insert into crash_q values('hello ') ###> OK ### ###0 ###We expected '1' but got '0' select_constants=yes # Select constants ###< select 1 ###> OK ### ###As far as all queries returned OK, result is YES select_limit=with LIMIT # LIMIT number of rows ###< select * from crash_me limit 1 ###> OK select_limit2=yes # SELECT with LIMIT #,# ###< select * from crash_me limit 1,1 ###> OK ### ###As far as all queries returned OK, result is YES select_limit3=yes # SELECT with LIMIT # OFFSET # ###< select * from crash_me limit 1 offset 1 ###> OK ### ###As far as all queries returned OK, result is YES select_string_size=1048565 # constant string size in SELECT ###We are trying (example with N=5): ###select 'aaaaa' select_table_update=yes # Update with sub select ###< create table crash_q (a integer,b char(10)) ###> OK ###< insert into crash_q values(1,'c') ###> OK ###< update crash_q set b= (select b from crash_me where crash_q.a = crash_me.a) ###> OK ### ###1.1 ### ###< drop table crash_q ###> OK ### ###< create table crash_q (q1 float(4,1)) ###> OK ###< insert into crash_q values(1.16) ###> OK ### ###1.1 ### ###< drop table crash_q ###> OK ### ###< create table crash_q (q1 float(4,1)) ###> OK ###< insert into crash_q values(1.16) ###> OK ### ###00:00:20 ###We expected '20:08:16' but got '00:00:20' ### ###< delete from crash_me_t ###> OK time_format_HHHHMMSS=yes # Supports HHHHmmSS time format ###< insert into crash_me_t(a) values ('00200816') ###> OK ### ###20:08:16 ### ###< delete from crash_me_t ###> OK time_format_USA=error # Supports HH:MM:SS (AM|PM) time format ###< insert into crash_me_t(a) values ('08:08:16 PM') ###> OK ### ###1 ###We expected '' but got '1' truncate_table=yes # truncate ###< create table crash_q (a integer, b integer,c1 CHAR(10)) ###> OK ###< truncate table crash_q ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_abstime=no # Type abstime ###< create table crash_q (q abstime) ###> 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 'abstime)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_bfile=no # Type bfile ###< create table crash_q (q bfile) ###> 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 'bfile)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_blob=yes # Type blob ###< create table crash_q (q blob) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_bool=yes # Type bool ###< create table crash_q (q bool) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_box=no # Type box ###< create table crash_q (q box) ###> 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 'box)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_byte=no # Type byte ###< create table crash_q (q byte) ###> 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 'byte)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_char(1_arg)_binary=yes # Type char(1 arg) binary ###< create table crash_q (q char(10) binary) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_cidr=no # Type cidr ###< create table crash_q (q cidr) ###> 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 'cidr)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_circle=no # Type circle ###< create table crash_q (q circle) ###> 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 'circle)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_clob=no # Type clob ###< create table crash_q (q clob) ###> 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 'clob)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_datetime=yes # Type datetime ###< create table crash_q (q datetime) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_double=yes # Type double ###< create table crash_q (q double) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_enum(1_arg)=yes # Type enum(1 arg) ###< create table crash_q (q enum('red')) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_float(2_arg)=yes # Type float(2 arg) ###< create table crash_q (q float(6,2)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_float4=yes # Type float4 ###< create table crash_q (q float4) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_float8=yes # Type float8 ###< create table crash_q (q float8) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_image=no # Type image ###< create table crash_q (q image) ###> 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 'image)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_inet=no # Type inet ###< create table crash_q (q inet) ###> 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 'inet)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_int(1_arg)_zerofill=yes # Type int(1 arg) zerofill ###< create table crash_q (q int(5) zerofill) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_int1=yes # Type int1 ###< create table crash_q (q int1) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_int2=yes # Type int2 ###< create table crash_q (q int2) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_int3=yes # Type int3 ###< create table crash_q (q int3) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_int4=yes # Type int4 ###< create table crash_q (q int4) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_int8=yes # Type int8 ###< create table crash_q (q int8) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_int_auto_increment=yes # Type int not null auto_increment ###< create table crash_q (q int not null auto_increment,unique(q)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_int_identity=no # Type int not null identity ###< create table crash_q (q int not null identity,unique(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 'identity,unique(q))' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_int_unsigned=yes # Type int unsigned ###< create table crash_q (q int unsigned) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_interval=no # Type interval ###< create table crash_q (q interval) ###> 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 'interval)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_line=no # Type line ###< create table crash_q (q line) ###> 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 'line)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_long=yes # Type long ###< create table crash_q (q long) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_long_raw=no # Type long raw ###< create table crash_q (q long raw) ###> 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 'raw)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_long_varbinary=yes # Type long varbinary ###< create table crash_q (q long varbinary) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_long_varchar(1_arg)=no # Type long varchar(1 arg) ###< create table crash_q (q long varchar(1)) ###> 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 '(1))' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_lseg=no # Type lseg ###< create table crash_q (q lseg) ###> 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 'lseg)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_macaddr=no # Type macaddr ###< create table crash_q (q macaddr) ###> 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 'macaddr)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_mediumint=yes # Type mediumint ###< create table crash_q (q mediumint) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_mediumtext=yes # Type mediumtext ###< create table crash_q (q mediumtext) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_middleint=yes # Type middleint ###< create table crash_q (q middleint) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_mlslabel=no # Type mlslabel ###< create table crash_q (q mlslabel) ###> 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 'mlslabel)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_money=no # Type money ###< create table crash_q (q money) ###> 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 'money)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_nclob=no # Type nclob ###< create table crash_q (q nclob) ###> 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 'nclob)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_number=no # Type number ###< create table crash_q (q number) ###> 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 'number)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_number(1_arg)=no # Type number(1 arg) ###< create table crash_q (q number(9)) ###> 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 'number(9))' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_number(2_arg)=no # Type number(2 arg) ###< create table crash_q (q number(9,2)) ###> 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 'number(9,2))' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_nvarchar2(1_arg)=no # Type nvarchar2(1 arg) ###< create table crash_q (q nvarchar2(16)) ###> 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 'nvarchar2(16))' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_path=no # Type path ###< create table crash_q (q path) ###> 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 'path)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_point=yes # Type point ###< create table crash_q (q point) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_polygon=yes # Type polygon ###< create table crash_q (q polygon) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_raw(1_arg)=no # Type raw(1 arg) ###< create table crash_q (q raw(16)) ###> 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 'raw(16))' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_reltime=no # Type reltime ###< create table crash_q (q reltime) ###> 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 'reltime)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_rowid=no # Type rowid ###< create table crash_q (q rowid) ###> 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 'rowid)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_serial=yes # Type serial ###< create table crash_q (q serial) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_set(1_arg)=yes # Type set(1 arg) ###< create table crash_q (q set('red')) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_smalldatetime=no # Type smalldatetime ###< create table crash_q (q smalldatetime) ###> 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 'smalldatetime)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_smallfloat=no # Type smallfloat ###< create table crash_q (q smallfloat) ###> 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 'smallfloat)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_smallmoney=no # Type smallmoney ###< create table crash_q (q smallmoney) ###> 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 'smallmoney)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_text=yes # Type text ###< create table crash_q (q text) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_text(1_arg)=yes # Type text(1 arg) ###< create table crash_q (q text(10)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_extra_timespan=no # Type timespan ###< create table crash_q (q timespan) ###> 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 'timespan)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_uint=no # Type uint ###< create table crash_q (q uint) ###> 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 'uint)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_varchar2(1_arg)=no # Type varchar2(1 arg) ###< create table crash_q (q varchar2(257)) ###> 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 'varchar2(257))' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_extra_year=yes # Type year ###< create table crash_q (q year) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_odbc_bigint=yes # Type bigint ###< create table crash_q (q bigint) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_odbc_binary(1_arg)=yes # Type binary(1 arg) ###< create table crash_q (q binary(1)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_odbc_datetime=yes # Type datetime ###< create table crash_q (q datetime) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_odbc_tinyint=yes # Type tinyint ###< create table crash_q (q tinyint) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_odbc_varbinary(1_arg)=yes # Type varbinary(1 arg) ###< create table crash_q (q varbinary(1)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_bit=yes # Type bit ###< create table crash_q (q bit) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_bit(1_arg)=yes # Type bit(1 arg) ###< create table crash_q (q bit(2)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_bit_varying(1_arg)=no # Type bit varying(1 arg) ###< create table crash_q (q bit varying(2)) ###> 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 'varying(2))' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_boolean=yes # Type boolean ###< create table crash_q (q boolean) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_char(1_arg)=yes # Type char(1 arg) ###< create table crash_q (q char(1)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_char_varying(1_arg)=yes # Type char varying(1 arg) ###< create table crash_q (q char varying(1)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_character(1_arg)=yes # Type character(1 arg) ###< create table crash_q (q character(1)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_character_varying(1_arg)=yes # Type character varying(1 arg) ###< create table crash_q (q character varying(1)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_date=yes # Type date ###< create table crash_q (q date) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_dec(2_arg)=yes # Type dec(2 arg) ###< create table crash_q (q dec(6,2)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_decimal(2_arg)=yes # Type decimal(2 arg) ###< create table crash_q (q decimal(6,2)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_double_precision=yes # Type double precision ###< create table crash_q (q double precision) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_float=yes # Type float ###< create table crash_q (q float) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_float(1_arg)=yes # Type float(1 arg) ###< create table crash_q (q float(8)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_int=yes # Type int ###< create table crash_q (q int) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_integer=yes # Type integer ###< create table crash_q (q integer) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_interval_day=no # Type interval day ###< create table crash_q (q interval day) ###> 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 'interval day)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_interval_day_to_hour=no # Type interval day to hour ###< create table crash_q (q interval day to hour) ###> 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 'interval day to hour)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_interval_day_to_minute=no # Type interval day to minute ###< create table crash_q (q interval day to minute) ###> 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 'interval day to minute)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_interval_day_to_second=no # Type interval day to second ###< create table crash_q (q interval day to second) ###> 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 'interval day to second)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_interval_hour=no # Type interval hour ###< create table crash_q (q interval hour) ###> 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 'interval hour)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_interval_hour_to_minute=no # Type interval hour to minute ###< create table crash_q (q interval hour to minute) ###> 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 'interval hour to minute)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_interval_hour_to_second=no # Type interval hour to second ###< create table crash_q (q interval hour to second) ###> 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 'interval hour to second)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_interval_minute=no # Type interval minute ###< create table crash_q (q interval minute) ###> 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 'interval minute)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_interval_minute_to_second=no # Type interval minute to second ###< create table crash_q (q interval minute to second) ###> 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 'interval minute to second)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_interval_month=no # Type interval month ###< create table crash_q (q interval month) ###> 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 'interval month)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_interval_second=no # Type interval second ###< create table crash_q (q interval second) ###> 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 'interval second)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_interval_year=no # Type interval year ###< create table crash_q (q interval year) ###> 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 'interval year)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_interval_year_to_month=no # Type interval year to month ###< create table crash_q (q interval year to month) ###> 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 'interval year to month)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_national_char_varying(1_arg)=yes # Type national char varying(1 arg) ###< create table crash_q (q national char varying(20)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_national_character(1_arg)=yes # Type national character(1 arg) ###< create table crash_q (q national character(20)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_national_character_varying(1_arg)=yes # Type national character varying(1 arg) ###< create table crash_q (q national character varying(20)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_nchar(1_arg)=yes # Type nchar(1 arg) ###< create table crash_q (q nchar(1)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_nchar_varying(1_arg)=yes # Type nchar varying(1 arg) ###< create table crash_q (q nchar varying(20)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_numeric(2_arg)=yes # Type numeric(2 arg) ###< create table crash_q (q numeric(9,2)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_real=yes # Type real ###< create table crash_q (q real) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_smallint=yes # Type smallint ###< create table crash_q (q smallint) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_time=yes # Type time ###< create table crash_q (q time) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_timestamp=yes # Type timestamp ###< create table crash_q (q timestamp) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES type_sql_timestamp_with_time_zone=no # Type timestamp with time zone ###< create table crash_q (q timestamp with time zone) ###> 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 time zone)' at line 1 ###< drop table crash_q ###> execute error:Unknown table 'crash_q' ### ###As far as some queries didnt return OK, result is NO type_sql_varchar(1_arg)=yes # Type varchar(1 arg) ###< create table crash_q (q varchar(1)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES union=yes # union ###< select * from crash_me union select a,b from crash_me3 ###> OK ### ###As far as all queries returned OK, result is YES union_all=yes # union all ###< select * from crash_me union all select a,b from crash_me3 ###> OK ### ###As far as all queries returned OK, result is YES union_all_incompat=yes # union all (incompatible lists) ###< select * from crash_me union all select a,b from crash_me2 ###> OK ### ###As far as all queries returned OK, result is YES union_incompat=yes # union (incompatible lists) ###< select * from crash_me union select a,b from crash_me2 ###> OK ### ###As far as all queries returned OK, result is YES unique_in_create=yes # unique in create table ###< create table crash_q (q integer not null,unique (q)) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES unique_null_in_create=yes # unique null in create ###< create table crash_q (q integer,unique (q)) ###> OK ###< insert into crash_q (q) values (NULL) ###> OK ###< insert into crash_q (q) values (NULL) ###> OK ###< insert into crash_q (q) values (1) ###> OK ###< drop table crash_q ###> OK ### ###As far as all queries returned OK, result is YES value_of_false=0 # Value of FALSE ###1 views=no # views ###< create view crash_q as select a from crash_me ###> 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 'view crash_q as select a from crash_me' at line 1 ###< drop view 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 'view crash_q' at line 1 ### ###As far as some queries didnt return OK, result is NO where_string_size=1048539 # constant string size in where ###We are trying (example with N=5): ###select a from crash_me where b >='11111'