mysql.cfg
上传用户:romrleung
上传日期:2022-05-23
资源大小:18897k
文件大小:279k
- #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
- ###
- ###<select b from crash_me where b = 'A'
- ###>a
- char_is_space_filled=no # char are space filled
- ###
- ###<select concat(b,b) from crash_me where b = 'a '
- ###>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
- ###
- ###<select left(a,4) from crash_me2
- ###>1998
- ###
- ###< drop table crash_me2
- ###> OK
- date_format_EUR=error # Supports DD.MM.YYYY (EUR) format
- ###< insert into crash_me_d(a) values ('16.08.1963')
- ###> OK
- ###
- ###<select a from crash_me_d
- ###>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
- ###
- ###<select a from crash_me_d
- ###>0000-00-00
- ###We expected '1963-08-16' but got '0000-00-00'
- ###
- ###< delete from crash_me_d
- ###> OK
- date_format_ISO=yes # Supports YYYY-MM-DD (ISO) format
- ###< insert into crash_me_d(a) values ('1963-08-16')
- ###> OK
- ###
- ###<select a from crash_me_d
- ###>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
- ###
- ###<select a from crash_me_d
- ###>1963-08-16
- ###
- ###< delete from crash_me_d
- ###> OK
- date_format_USA=error # Supports MM/DD/YYYY format
- ###< insert into crash_me_d(a) values ('08/16/1963')
- ###> OK
- ###
- ###<select a from crash_me_d
- ###>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
- ###
- ###<select a from crash_me_d
- ###>0000-00-00
- ###We expected '1963-08-16' but got '0000-00-00'
- ###
- ###< delete from crash_me_d
- ###> OK
- date_format_YYYYMMDD=yes # Supports YYYYMMDD format
- ###< insert into crash_me_d(a) values ('19630816')
- ###> OK
- ###
- ###<select a from crash_me_d
- ###>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
- ###
- ###<select a from crash_me_d
- ###>1963-08-16
- ###
- ###< delete from crash_me_d
- ###> OK
- date_format_inresult=iso # Date format in result
- ###< insert into crash_me_d values( sysdate() )
- ###> OK
- ###
- ###< select a from crash_me_d
- ###> 2004-04-06
- ###< delete from crash_me_d
- ###> OK
- date_infinity=error # Supports 'infinity dates
- ###< create table crash_me2 (a date not null)
- ###> OK
- ###< insert into crash_me2 values ('infinity')
- ###> OK
- ###
- ###<select a from crash_me2
- ###>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
- ###
- ###<select a from crash_me2
- ###>9999-12-31
- ###
- ###< drop table crash_me2
- ###> OK
- date_one=yes # Supports 0001-01-01 dates
- ###< create table crash_me2 (a date not null)
- ###> OK
- ###< insert into crash_me2 values ('0001-01-01')
- ###> OK
- ###
- ###<select a from crash_me2
- ###>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
- ###
- ###<select a from crash_me2
- ###>1998-03-03
- ###
- ###< drop table crash_me2
- ###> OK
- ###
- ###< create table crash_me2 (a date not null)
- ###> OK
- ###< insert into crash_me2 values ('10-03-03')
- ###> OK
- ###
- ###<select a from crash_me2
- ###>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
- ###
- ###<select a from crash_me2
- ###>0000-00-00
- ###
- ###< drop table crash_me2
- ###> OK
- domains=no # Domains (ANSI SQL)
- ###< create domain crash_d as varchar(10) default 'Empty' check (value <> 'abcd')
- ###> 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 'domain crash_d as varchar(10) default 'Empty' check (value <> '
- ###< create table crash_q(a crash_d, 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 'crash_d, b int)' at line 1
- ###< insert into crash_q(a,b) values('xyz',10)
- ###> execute error:Table 'test.crash_q' doesn't exist
- ###< insert into crash_q(b) values(10)
- ###> execute error:Table 'test.crash_q' doesn't exist
- ###< drop table crash_q
- ###> execute error:Unknown table 'crash_q'
- ###< drop domain crash_d
- ###> 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 'domain crash_d' at line 1
- ###
- ###As far as some queries didnt return OK, result is NO
- dont_require_cast_to_float=yes # No need to cast from integer to float
- ###< select exp(1)
- ###> OK
- ###
- ###As far as all queries returned OK, result is YES
- double_quotes=yes # Double '' as ' in strings
- ###
- ###<select 'Walker''s'
- ###>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
- ###
- ###<select ! 1
- ###>0
- func_extra_%=yes # Function MOD as %
- ###
- ###<select 10%7
- ###>3
- func_extra_&=yes # Function & (bitwise and)
- ###
- ###<select 5 & 3
- ###>1
- func_extra_&&=yes # Function AND as '&&'
- ###
- ###<select 1=1 && 2=2
- ###>1
- func_extra_<>=yes # Function <> in SELECT
- ###
- ###<select 1<>1
- ###>0
- func_extra_==yes # Function =
- ###
- ###<select (1=1)
- ###>1
- func_extra_add_months=no # Function ADD_MONTHS
- ###
- ###<select add_months('1997-01-01',1) 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 '('1997-01-01',1) from crash_me_d' at line 1
- func_extra_adddate=yes # Function ADDDATE
- ###
- ###<select ADDDATE('2002-12-01',3) from crash_me_d
- ###>2002-12-04
- func_extra_addtime=yes # Function ADDTIME
- ###
- ###<select ADDTIME('20:02:12','00:00:03')
- ###>20:02:15
- func_extra_alpha=no # Function ALPHA
- ###
- ###<select alpha('A