📄 mysql-4.1.cfg
字号:
#This file is automaticly generated by crash-me 1.61NEG=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 YESNeed_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 YESalter_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 YESalter_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 NOalter_add_multi_col=yes # Alter table add many columns ###< alter table crash_q add (f integer,g integer) ###> OKalter_add_primary_key=with constraint # Alter table add primary key ###< alter table crash_q1 add constraint p1 primary key(c1) ###> OKalter_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 YESalter_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 YESalter_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 YESalter_drop_col=yes # Alter table drop column ###< alter table crash_q drop column b ###> OKalter_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 1alter_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 ###> OKalter_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 ###> OKalter_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 ###> OKalter_modify_col=yes # Alter table modify column ###< alter table crash_q modify c1 CHAR(20) ###> OKalter_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 YESatomic_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 NOautomatic_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 ###> OKbinary_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 NObinary_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 NOcase_insensitive_strings=yes # Case insensitive compare ### ###<select b from crash_me where b = 'A' ###>achar_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 YEScolumns_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,q5columns_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,q5comment_#=yes # # as comment ###< select * from crash_me # Testing of comments ###> OK ### ###As far as all queries returned OK, result is YEScomment_--=yes # -- as comment (ANSI) ###< select * from crash_me -- Testing of comments ###> OK ### ###As far as all queries returned OK, result is YEScomment_/**/=yes # /* */ as comment ###< select * from crash_me /* Testing of comments */ ###> OK ### ###As far as all queries returned OK, result is YEScomment_//=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 NOcompute=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 NOconnections=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 ###> OKconstraint_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 ###> OKconstraint_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 ###> OKconstraint_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 YEScrash_me_safe=yes # crash me safecrash_me_version=1.61 # crash me versioncreate_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 YEScreate_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 NOcreate_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 YEScreate_index=yes # create index ###< create index crash_q on crash_me (a) ###> OKcreate_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 NOcreate_table_select=yes # create table from select ###< create table crash_q SELECT * from crash_me ###> OKcross_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 YESdate_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 ###> OKdate_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 ###> OKdate_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⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -