1
#This file is automaticly generated by crash-me 1.61
3
NEG=yes # update of column= -column
4
###< create table crash_q (a integer)
6
###< insert into crash_q values(10)
8
###< update crash_q set a=-a
10
###< drop table crash_q
13
###As far as all queries returned OK, result is YES
14
Need_cast_for_null=no # Need to cast NULL for arithmetic
15
### Check if numeric_null (NULL) is 'NULL'
16
### Check if numeric_null (NULL) is 'NULL'
17
### Check if numeric_null (NULL) is 'NULL'
18
alter_add_col=yes # Alter table add column
19
###< alter table crash_q add d integer
22
###As far as all queries returned OK, result is YES
23
alter_add_constraint=yes # Alter table add constraint
24
###< alter table crash_q add constraint c2 check(a > b)
27
###As far as all queries returned OK, result is YES
28
alter_add_foreign_key=no # Alter table add foreign key
29
###< alter table crash_q add constraint f1 foreign key(c1)
30
###> 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
31
###< references crash_q1(c1)
32
###> 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
34
###As far as some queries didnt return OK, result is NO
35
alter_add_multi_col=yes # Alter table add many columns
36
###< alter table crash_q add (f integer,g integer)
38
alter_add_primary_key=with constraint # Alter table add primary key
39
###< alter table crash_q1 add constraint p1 primary key(c1)
41
alter_add_unique=yes # Alter table add unique
42
###< alter table crash_q add constraint u1 unique(c1)
45
###As far as all queries returned OK, result is YES
46
alter_alter_col=yes # Alter table alter column default
47
###< alter table crash_q alter b set default 10
50
###As far as all queries returned OK, result is YES
51
alter_change_col=yes # Alter table change column
52
###< alter table crash_q change a e char(50)
55
###As far as all queries returned OK, result is YES
56
alter_drop_col=yes # Alter table drop column
57
###< alter table crash_q drop column b
59
alter_drop_constraint=no # Alter table drop constraint
60
###< alter table crash_q drop constraint c2
61
###> 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
63
###< alter table crash_q drop constraint c2 restrict
64
###> 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
65
alter_drop_foreign_key=with drop foreign key # Alter table drop foreign key
66
###< alter table crash_q drop constraint f1
67
###> 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
69
###< alter table crash_q drop constraint f1 restrict
70
###> 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
72
###< alter table crash_q drop foreign key f1
74
alter_drop_primary_key=drop primary key # Alter table drop primary key
75
###< alter table crash_q1 drop constraint p1 restrict
76
###> 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
78
###< alter table crash_q1 drop primary key
80
alter_drop_unique=with drop key # Alter table drop unique
81
###< alter table crash_q drop constraint u1
82
###> 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
84
###< alter table crash_q drop constraint u1 restrict
85
###> 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
87
###< alter table crash_q drop key u1
89
alter_modify_col=yes # Alter table modify column
90
###< alter table crash_q modify c1 CHAR(20)
92
alter_rename_table=yes # Alter table rename table
93
###< alter table crash_q rename to crash_q1
96
###As far as all queries returned OK, result is YES
97
atomic_updates=no # atomic updates
98
###< create table crash_q (a integer not null,primary key (a))
100
###< insert into crash_q values (2)
102
###< insert into crash_q values (3)
104
###< insert into crash_q values (1)
106
###< update crash_q set a=a+1
107
###> execute error:Duplicate entry '3' for key 1
108
###< drop table crash_q
111
###As far as some queries didnt return OK, result is NO
112
automatic_rowid=_rowid # Automatic row id
113
###< create table crash_q (a int not null, primary key(a))
115
###< insert into crash_q values (1)
117
###< select _rowid from crash_q
119
###< drop table crash_q
121
binary_numbers=no # binary numbers (0b1001)
123
###> execute error:Unknown column '0b1001' in 'field list'
125
###As far as some queries didnt return OK, result is NO
126
binary_strings=no # binary strings (b'0110')
128
###> execute error:Unknown column 'b' in 'field list'
130
###As far as some queries didnt return OK, result is NO
131
case_insensitive_strings=yes # Case insensitive compare
133
###<select b from crash_me where b = 'A'
135
char_is_space_filled=no # char are space filled
137
###<select concat(b,b) from crash_me where b = 'a '
139
###We expected 'a a ' but got 'aa'
140
column_alias=yes # Column alias
141
###< select a as ab from crash_me
144
###As far as all queries returned OK, result is YES
145
columns_in_group_by=+64 # number of columns in group by
146
###We are trying (example with N=5):
147
###create table crash_q (q1 integer,q2 integer,q3 integer,q4 integer,q5 integer)
148
###insert into crash_q values(1,1,1,1,1)
149
###insert into crash_q values(1,1,1,1,1)
150
###select q1,q2,q3,q4,q5 from crash_q group by q1,q2,q3,q4,q5
151
columns_in_order_by=+64 # number of columns in order by
152
###We are trying (example with N=5):
153
###create table crash_q (q1 integer,q2 integer,q3 integer,q4 integer,q5 integer)
154
###insert into crash_q values(1,1,1,1,1)
155
###insert into crash_q values(1,1,1,1,1)
156
###select * from crash_q order by q1,q2,q3,q4,q5
157
comment_#=yes # # as comment
158
###< select * from crash_me # Testing of comments
161
###As far as all queries returned OK, result is YES
162
comment_--=yes # -- as comment (ANSI)
163
###< select * from crash_me -- Testing of comments
166
###As far as all queries returned OK, result is YES
167
comment_/**/=yes # /* */ as comment
168
###< select * from crash_me /* Testing of comments */
171
###As far as all queries returned OK, result is YES
172
comment_//=no # // as comment
173
###< select * from crash_me // Testing of comments
174
###> 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
176
###As far as some queries didnt return OK, result is NO
178
###< select a from crash_me order by a compute sum(a) by a
179
###> 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
181
###As far as some queries didnt return OK, result is NO
182
connections=101 # Simultaneous connections (installation default)
183
constraint_check=syntax only # Column constraints
184
###< create table crash_q (a int check (a>0))
187
###< insert into crash_q values(0)
190
###< drop table crash_q
192
###< create table crash_q (a int check (a>0))
195
###< insert into crash_q values(0)
198
###< drop table crash_q
200
###< create table crash_q (a int check (a>0))
203
###< insert into crash_q values(0)
206
###< drop table crash_q
208
constraint_check_named=syntax only # Named constraints
209
###< create table crash_q (a int ,b int, constraint abc check (a>b))
212
###< insert into crash_q values(0,0)
215
###< drop table crash_q
217
###< create table crash_q (a int ,b int, constraint abc check (a>b))
220
###< insert into crash_q values(0,0)
223
###< drop table crash_q
225
###< create table crash_q (a int ,b int, constraint abc check (a>b))
228
###< insert into crash_q values(0,0)
231
###< drop table crash_q
233
constraint_check_table=syntax only # Table constraints
234
###< create table crash_q (a int ,b int, check (a>b))
237
###< insert into crash_q values(0,0)
240
###< drop table crash_q
242
###< create table crash_q (a int ,b int, check (a>b))
245
###< insert into crash_q values(0,0)
248
###< drop table crash_q
250
###< create table crash_q (a int ,b int, check (a>b))
253
###< insert into crash_q values(0,0)
256
###< drop table crash_q
258
constraint_null=yes # NULL constraint (SyBase style)
259
###< create table crash_q (a int null)
261
###< drop table crash_q
264
###As far as all queries returned OK, result is YES
265
crash_me_safe=yes # crash me safe
266
crash_me_version=1.61 # crash me version
267
create_default=yes # default value for column
268
###< create table crash_q (q integer default 10 not null)
270
###< drop table crash_q
273
###As far as all queries returned OK, result is YES
274
create_default_func=no # default value function for column
275
###< create table crash_q (q integer not null,q1 integer default (1+1))
276
###> 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
277
###< drop table crash_q
278
###> execute error:Unknown table 'crash_q'
280
###As far as some queries didnt return OK, result is NO
281
create_if_not_exists=yes # create table if not exists
282
###< create table crash_q (q integer)
284
###< create table if not exists crash_q (q integer)
287
###As far as all queries returned OK, result is YES
288
create_index=yes # create index
289
###< create index crash_q on crash_me (a)
291
create_schema=no # Create SCHEMA
292
###< create schema crash_schema create table crash_q (a int) create table crash_q2(b int)
293
###> 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
294
###< drop schema crash_schema cascade
295
###> 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
297
###As far as some queries didnt return OK, result is NO
298
create_table_select=yes # create table from select
299
###< create table crash_q SELECT * from crash_me
301
cross_join=yes # cross join (same as from a,b)
302
###< select crash_me.a from crash_me cross join crash_me3
305
###As far as all queries returned OK, result is YES
306
date_as_string=yes # String functions on date columns
307
###< create table crash_me2 (a date not null)
309
###< insert into crash_me2 values ('1998-03-03')
312
###<select left(a,4) from crash_me2
315
###< drop table crash_me2
317
date_format_EUR=error # Supports DD.MM.YYYY (EUR) format
318
###< insert into crash_me_d(a) values ('16.08.1963')
321
###<select a from crash_me_d
323
###We expected '1963-08-16' but got '0000-00-00'
325
###< delete from crash_me_d
327
date_format_EUR_with_date=error # Supports DATE 'DD.MM.YYYY' (EUR) format
328
###< insert into crash_me_d(a) values (DATE '16.08.1963')
331
###<select a from crash_me_d
333
###We expected '1963-08-16' but got '0000-00-00'
335
###< delete from crash_me_d
337
date_format_ISO=yes # Supports YYYY-MM-DD (ISO) format
338
###< insert into crash_me_d(a) values ('1963-08-16')
341
###<select a from crash_me_d
344
###< delete from crash_me_d
346
date_format_ISO_with_date=yes # Supports DATE 'YYYY-MM-DD' (ISO) format
347
###< insert into crash_me_d(a) values (DATE '1963-08-16')
350
###<select a from crash_me_d
353
###< delete from crash_me_d
355
date_format_USA=error # Supports MM/DD/YYYY format
356
###< insert into crash_me_d(a) values ('08/16/1963')
359
###<select a from crash_me_d
361
###We expected '1963-08-16' but got '0000-00-00'
363
###< delete from crash_me_d
365
date_format_USA_with_date=error # Supports DATE 'MM/DD/YYYY' format
366
###< insert into crash_me_d(a) values (DATE '08/16/1963')
369
###<select a from crash_me_d
371
###We expected '1963-08-16' but got '0000-00-00'
373
###< delete from crash_me_d
375
date_format_YYYYMMDD=yes # Supports YYYYMMDD format
376
###< insert into crash_me_d(a) values ('19630816')
379
###<select a from crash_me_d
382
###< delete from crash_me_d
384
date_format_YYYYMMDD_with_date=yes # Supports DATE 'YYYYMMDD' format
385
###< insert into crash_me_d(a) values (DATE '19630816')
388
###<select a from crash_me_d
391
###< delete from crash_me_d
393
date_format_inresult=iso # Date format in result
394
###< insert into crash_me_d values( sysdate() )
397
###< select a from crash_me_d
399
###< delete from crash_me_d
401
###< insert into crash_me_d values( sysdate() )
404
###< select a from crash_me_d
406
###< delete from crash_me_d
408
###< insert into crash_me_d values( sysdate() )
411
###< select a from crash_me_d
413
###< delete from crash_me_d
415
date_infinity=error # Supports 'infinity dates
416
###< create table crash_me2 (a date not null)
418
###< insert into crash_me2 values ('infinity')
421
###<select a from crash_me2
423
###We expected 'infinity' but got '0000-00-00'
425
###< drop table crash_me2
427
date_last=yes # Supports 9999-12-31 dates
428
###< create table crash_me2 (a date not null)
430
###< insert into crash_me2 values ('9999-12-31')
433
###<select a from crash_me2
436
###< drop table crash_me2
438
date_one=yes # Supports 0001-01-01 dates
439
###< create table crash_me2 (a date not null)
441
###< insert into crash_me2 values ('0001-01-01')
444
###<select a from crash_me2
447
###< drop table crash_me2
449
date_with_YY=yes # Supports YY-MM-DD 2000 compilant dates
450
###< create table crash_me2 (a date not null)
452
###< insert into crash_me2 values ('98-03-03')
455
###<select a from crash_me2
458
###< drop table crash_me2
461
###< create table crash_me2 (a date not null)
463
###< insert into crash_me2 values ('10-03-03')
466
###<select a from crash_me2
469
###< drop table crash_me2
471
date_zero=yes # Supports 0000-00-00 dates
472
###< create table crash_me2 (a date not null)
474
###< insert into crash_me2 values ('0000-00-00')
477
###<select a from crash_me2
480
###< drop table crash_me2
482
domains=no # Domains (ANSI SQL)
483
###< create domain crash_d as varchar(10) default 'Empty' check (value <> 'abcd')
484
###> 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 <> '
485
###< create table crash_q(a crash_d, b int)
486
###> 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
487
###< insert into crash_q(a,b) values('xyz',10)
488
###> execute error:Table 'test.crash_q' doesn't exist
489
###< insert into crash_q(b) values(10)
490
###> execute error:Table 'test.crash_q' doesn't exist
491
###< drop table crash_q
492
###> execute error:Unknown table 'crash_q'
493
###< drop domain crash_d
494
###> 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
496
###As far as some queries didnt return OK, result is NO
497
dont_require_cast_to_float=yes # No need to cast from integer to float
501
###As far as all queries returned OK, result is YES
502
double_quotes=yes # Double '' as ' in strings
504
###<select 'Walker''s'
506
drop_if_exists=yes # drop table if exists
507
###< create table crash_q (q integer)
509
###< drop table if exists crash_q
512
###As far as all queries returned OK, result is YES
513
drop_index=with 'ON' # drop index
514
###< drop index crash_q
515
###> 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
517
###< drop index crash_q from crash_me
518
###> 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
520
###< drop index crash_q on crash_me
522
drop_requires_cascade=no # drop table require cascade/restrict
523
###< create table crash_me (a integer not null)
525
###< drop table crash_me
527
###< create table crash_me (a integer not null)
529
###< drop table crash_me
531
###< create table crash_me (a integer not null)
533
###< drop table crash_me
535
drop_restrict=yes # drop table with cascade/restrict
536
###< create table crash_q (a int)
538
###< drop table crash_q restrict
541
###As far as all queries returned OK, result is YES
542
end_colon=yes # allows end ';'
543
###< select * from crash_me;
546
###As far as all queries returned OK, result is YES
548
###< select * from crash_me except select * from crash_me3
549
###> 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
551
###As far as some queries didnt return OK, result is NO
552
except_all=no # except all
553
###< select * from crash_me except all select * from crash_me3
554
###> 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
556
###As far as some queries didnt return OK, result is NO
557
except_all_incompat=no # except all (incompatible lists)
558
###< select * from crash_me except all select * from crash_me2
559
###> 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
561
###As far as some queries didnt return OK, result is NO
562
except_incompat=no # except (incompatible lists)
563
###< select * from crash_me except select * from crash_me2
564
###> 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
566
###As far as some queries didnt return OK, result is NO
567
field_name_case=yes # case independent field names
568
###< create table crash_q (q integer)
570
###< insert into crash_q(Q) values (1)
572
###< drop table crash_q
575
###As far as all queries returned OK, result is YES
576
float_int_expr=yes # mixing of integer and float in expression
580
###As far as all queries returned OK, result is YES
581
foreign_key=syntax only # foreign keys
582
###< create table crash_me_qf (a integer not null,primary key (a))
585
###< create table crash_me_qf2 (a integer not null,foreign key (a) references crash_me_qf (a))
588
###< insert into crash_me_qf values (1)
591
###< insert into crash_me_qf2 values (2)
594
###< drop table crash_me_qf2
597
###< drop table crash_me_qf
599
###< create table crash_me_qf (a integer not null,primary key (a))
602
###< create table crash_me_qf2 (a integer not null,foreign key (a) references crash_me_qf (a))
605
###< insert into crash_me_qf values (1)
608
###< insert into crash_me_qf2 values (2)
611
###< drop table crash_me_qf2
614
###< drop table crash_me_qf
616
###< create table crash_me_qf (a integer not null,primary key (a))
619
###< create table crash_me_qf2 (a integer not null,foreign key (a) references crash_me_qf (a))
622
###< insert into crash_me_qf values (1)
625
###< insert into crash_me_qf2 values (2)
628
###< drop table crash_me_qf2
631
###< drop table crash_me_qf
633
full_outer_join=no # full outer join
634
###< select crash_me.a from crash_me full join crash_me2 ON
635
### crash_me.a=crash_me2.a
636
###> execute error:Unknown table 'crash_me' in field list
638
###As far as some queries didnt return OK, result is NO
639
func_extra_!=yes # Function NOT as '!' in SELECT
643
func_extra_%=yes # Function MOD as %
647
func_extra_&=yes # Function & (bitwise and)
651
func_extra_&&=yes # Function AND as '&&'
653
###<select 1=1 && 2=2
655
func_extra_<>=yes # Function <> in SELECT
659
func_extra_==yes # Function =
663
func_extra_add_months=no # Function ADD_MONTHS
665
###<select add_months('1997-01-01',1) from crash_me_d
666
###> 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
667
func_extra_adddate=yes # Function ADDDATE
669
###<select ADDDATE('2002-12-01',3) from crash_me_d
671
func_extra_addtime=yes # Function ADDTIME
673
###<select ADDTIME('20:02:12','00:00:03')
675
func_extra_alpha=no # Function ALPHA
677
###<select alpha('A�',2)
678
###> 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
679
func_extra_and_or=yes # Function AND and OR in SELECT
681
###<select 1=1 AND 2=2
683
func_extra_ascii_char=no # Function ASCII_CHAR
685
###<select ASCII_CHAR(65)
686
###> 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
687
func_extra_ascii_code=no # Function ASCII_CODE
689
###<select ASCII_CODE('A')
690
###> 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
691
func_extra_ascii_string=error # Function ASCII in string cast
693
###<select ascii('a')
695
###We expected 'a' but got '97'
696
func_extra_atn2=no # Function ATN2
699
###> 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,0)' at line 1
700
func_extra_auto_num2string=yes # Function automatic num->string convert
702
###<select concat('a',2)
704
func_extra_auto_string2num=yes # Function automatic string->num convert
708
func_extra_between=yes # Function BETWEEN in SELECT
710
###<select 5 between 4 and 6
712
func_extra_binary_shifts=yes # Function << and >> (bitwise shifts)
714
###<select (1 << 4) >> 2
716
func_extra_bit_count=yes # Function BIT_COUNT
718
###<select bit_count(5)
720
func_extra_ceil=yes # Function CEIL
722
###<select ceil(-4.5)
724
func_extra_char_date=no # Function CHAR (conversation date)
726
###<select CHAR(a,EUR) from crash_me_d
727
###> execute failed:Unknown column 'EUR' in 'field list'
728
func_extra_charindex=no # Function CHARINDEX
730
###<select charindex('a','crash')
731
###> 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
732
func_extra_chr=no # Function CHR
735
###> 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
736
func_extra_chr_str=no # Function CHR (any type to string)
739
###> 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 '(67)' at line 1
740
func_extra_concat_as_+=error # Function concatenation with +
742
###<select 'abc' + 'def'
744
###We expected 'abcdef' but got '0'
745
func_extra_concat_list=yes # Function CONCAT(list)
747
###<select concat('a','b','c','d')
749
func_extra_convert=no # Function CONVERT
751
###<select convert(CHAR,5)
752
###> 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
753
func_extra_cosh=no # Function COSH
756
###> 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 '(0)' at line 1
757
func_extra_date=yes # Function DATE
759
###<select date('1963-08-16') from crash_me_d
761
func_extra_date_format=yes # Function DATE_FORMAT
763
###<select date_format('1997-01-02 03:04:05','M W D Y y m d h i s w') from crash_me_d
764
###>M W D Y y m d h i s w
765
func_extra_dateadd=no # Function DATEADD
767
###<select dateadd(day,3,'1997-11-30') from crash_me_d
768
###> 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
769
func_extra_datediff=no # Function DATEDIFF
771
###<select datediff(month,'Oct 21 1997','Nov 30 1997') from crash_me_d
772
###> 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 ''Nov 30 1997') from crash_me_d' at line 1
773
func_extra_datediff2arg=yes # Function DATEDIFF (2 arg)
775
###<select DATEDIFF('2002-12-04','2002-12-01') from crash_me_d
777
func_extra_datename=no # Function DATENAME
779
###<select datename(month,'Nov 30 1997') from crash_me_d
780
###> 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,'Nov 30 1997') from crash_me_d' at line 1
781
func_extra_datepart=no # Function DATEPART
783
###<select datepart(month,'July 20 1997') from crash_me_d
784
###> 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
785
func_extra_day=yes # Function DAY
787
###<select DAY('2002-12-01') from crash_me_d
789
func_extra_decode=no # Function DECODE
791
###<select DECODE('S-103','T72',1,'S-103',2,'Leopard',3)
792
###> 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
793
func_extra_ebcdic_string=no # Function EBCDIC in string cast
795
###<select ebcdic('a')
796
###> 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
797
func_extra_elt=yes # Function ELT
799
###<select elt(2,'ONE','TWO','THREE')
801
func_extra_encrypt=yes # Function ENCRYPT
803
###<select encrypt('hello')
805
func_extra_expand2arg=no # Function EXPAND
807
###<select expand('abcd',6)
808
###> 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
809
func_extra_field=yes # Function FIELD
811
###<select field('IBM','NCA','ICL','SUN','IBM','DIGITAL')
813
func_extra_fixed=no # Function FIXED
815
###<select fixed(222.6666,10,2)
816
###> 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
817
func_extra_float=no # Function FLOAT
819
###<select float(6666.66,4)
820
###> 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 'float(6666.66,4)' at line 1
821
func_extra_format=yes # Function FORMAT
823
###<select format(1234.5555,2)
825
func_extra_from_days=yes # Function FROM_DAYS
827
###<select from_days(729024) from crash_me_d
829
func_extra_from_unixtime=yes # Function FROM_UNIXTIME
831
###<select from_unixtime(0) from crash_me_d
832
###>1970-01-01 02:00:00
833
func_extra_getdate=no # Function GETDATE
836
###> 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
837
func_extra_greatest=yes # Function GREATEST
839
###<select greatest('HARRY','HARRIOT','HAROLD')
841
func_extra_hex=yes # Function HEX
845
func_extra_if=yes # Function IF
849
func_extra_in_num=yes # Function IN on numbers in SELECT
851
###<select 2 in (3,2,5,9,5,1)
853
func_extra_in_str=yes # Function IN on strings in SELECT
855
###<select 'monty' in ('david','monty','allan')
857
func_extra_index=no # Function INDEX
859
###<select index('abcdefg','cd',1,1)
860
###> 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 'index('abcdefg','cd',1,1)' at line 1
861
func_extra_initcap=no # Function INITCAP
863
###<select initcap('the soap')
864
###> 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
865
func_extra_instr=yes # Function LOCATE as INSTR
867
###<select instr('hello','ll')
869
func_extra_instr_oracle=no # Function INSTR (Oracle syntax)
871
###<select INSTR('CORPORATE FLOOR','OR',3,2)
872
###> 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
873
func_extra_instrb=no # Function INSTRB
875
###<select INSTRB('CORPORATE FLOOR','OR',5,2)
876
###> 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 '('CORPORATE FLOOR','OR',5,2)' at line 1
877
func_extra_interval=yes # Function INTERVAL
879
###<select interval(55,10,20,30,40,50,60,70,80,90,100)
881
func_extra_last_day=yes # Function LAST_DAY
883
###<select last_day('1997-04-01') from crash_me_d
885
func_extra_last_insert_id=yes # Function LAST_INSERT_ID
887
###<select last_insert_id()
889
func_extra_least=yes # Function LEAST
891
###<select least('HARRY','HARRIOT','HAROLD')
893
func_extra_length=error # Function LENGTH
897
###We expected '2' but got '1'
898
func_extra_lengthb=no # Function LENGTHB
900
###<select lengthb('CANDIDE')
901
###> 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 '('CANDIDE')' at line 1
902
func_extra_lfill3arg=no # Function LFILL (3 arg)
904
###<select lfill('abcd','.',6)
905
###> 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
906
func_extra_like=yes # Function LIKE in SELECT
908
###<select 'a' like 'a%'
910
func_extra_like_escape=yes # Function LIKE ESCAPE in SELECT
912
###<select '%' like 'a%' escape 'a'
914
func_extra_ln=yes # Function LN
918
func_extra_log(m_n)=yes # Function LOG(m,n)
920
###<select log(10,100)
922
func_extra_logn=no # Function LOGN
925
###> 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 '(2)' at line 1
926
func_extra_lpad=yes # Function LPAD
928
###<select lpad('hi',4,'??')
930
func_extra_ltrim2arg=no # Function LTRIM (2 arg)
932
###<select ltrim('..abcd..','.')
933
###> 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
934
func_extra_makedate=yes # Function MAKEDATE
936
###<select MAKEDATE(1963,228) from crash_me_d
938
func_extra_maketime=yes # Function MAKETIME
940
###<select MAKETIME(20,02,12)
942
func_extra_mapchar=no # Function MAPCHAR
944
###<select mapchar('A�')
945
###> 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
946
func_extra_mdy=no # Function MDY
948
###<select mdy(7,1,1998) from crash_me_d
949
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(7,1,1998) from crash_me_d' at line 1
950
func_extra_microsecond=error # Function MICROSECOND
952
###<select MICROSECOND('19630816200212111111')
954
###We expected '111111' but got '11'
955
func_extra_mid=yes # Function SUBSTRING as MID
957
###<select mid('hello',3,2)
959
func_extra_months_between=no # Function MONTHS_BETWEEN
961
###<select months_between('1997-02-02','1997-01-01') from crash_me_d
962
###> 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
963
func_extra_noround=no # Function NOROUND
964
###< select noround(22.6)
965
###> 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
966
###< select noround(22.6)
967
###> 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
968
###< select noround(22.6)
969
###> 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
970
func_extra_not=yes # Function NOT in SELECT
974
func_extra_not_between=yes # Function NOT BETWEEN in SELECT
976
###<select 5 not between 4 and 6
978
func_extra_not_like=yes # Function NOT LIKE in SELECT
980
###<select 'a' not like 'a%'
982
func_extra_num=no # Function NUM
984
###<select NUM('2123')
985
###> 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
986
func_extra_odbc_convert=no # Function ODBC CONVERT
988
###<select convert(5,SQL_CHAR)
989
###> 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
990
func_extra_password=yes # Function PASSWORD
992
###<select password('hello')
993
###>*6B4F89A54E2D27ECD7E8DA05B4AB8FD9D1D8B119
994
func_extra_paste=no # Function PASTE
996
###<select paste('ABCDEFG',3,2,'1234')
997
###> 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 '('ABCDEFG',3,2,'1234')' at line 1
998
func_extra_patindex=no # Function PATINDEX
1000
###<select patindex('%a%','crash')
1001
###> 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
1002
func_extra_period_add=yes # Function PERIOD_ADD
1004
###<select period_add(9602,-12) from crash_me_d
1006
func_extra_period_diff=yes # Function PERIOD_DIFF
1008
###<select period_diff(199505,199404) from crash_me_d
1010
func_extra_pow=yes # Function POW
1014
func_extra_range=no # Function RANGE
1017
###> 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
1018
func_extra_regexp=yes # Function REGEXP in SELECT
1020
###<select 'a' regexp '^(a|b)*$'
1022
func_extra_replace2arg=no # Function REPLACE (2 arg)
1024
###<select replace('AbCd','bC')
1025
###> 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
1026
func_extra_replicate=no # Function REPLICATE
1028
###<select replicate('a',5)
1029
###> 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',5)' at line 1
1030
func_extra_reverse=yes # Function REVERSE
1032
###<select reverse('abcd')
1034
func_extra_rfill3arg=no # Function RFILL (3 arg)
1036
###<select rfill('abcd','.',6)
1037
###> 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
1038
func_extra_root=no # Function ROOT
1041
###> 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
1042
func_extra_round1=yes # Function ROUND(1 arg)
1044
###<select round(5.63)
1046
func_extra_rpad=yes # Function RPAD
1048
###<select rpad('hi',4,'??')
1050
func_extra_rpad4arg=no # Function RPAD (4 arg)
1052
###<select rpad('abcd',2,'+-',8)
1053
###> 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 '8)' at line 1
1054
func_extra_rtrim2arg=no # Function RTRIM (2 arg)
1056
###<select rtrim('..abcd..','.')
1057
###> 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
1058
func_extra_sec_to_time=yes # Function SEC_TO_TIME
1060
###<select sec_to_time(5001)
1062
func_extra_sinh=no # Function SINH
1065
###> 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
1066
func_extra_str=no # Function STR
1068
###<select str(123.45,5,1)
1069
###> 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 '(123.45,5,1)' at line 1
1070
func_extra_strcmp=yes # Function STRCMP
1072
###<select strcmp('abc','adc')
1074
func_extra_stuff=no # Function STUFF
1076
###<select stuff('abc',2,3,'xyz')
1077
###> 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',2,3,'xyz')' at line 1
1078
func_extra_subdate=yes # Function SUBDATE
1080
###<select SUBDATE('2002-12-04',3) from crash_me_d
1082
func_extra_substr2arg=yes # Function SUBSTR (2 arg)
1084
###<select substr('abcd',2)
1086
func_extra_substr3arg=yes # Function SUBSTR (3 arg)
1088
###<select substr('abcd',2,2)
1090
func_extra_substrb=no # Function SUBSTRB
1092
###<select SUBSTRB('ABCDEFG',5,4.2)
1093
###> 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 '('ABCDEFG',5,4.2)' at line 1
1094
func_extra_substring_index=yes # Function SUBSTRING_INDEX
1096
###<select substring_index('www.tcx.se','.',-2)
1098
func_extra_subtime=yes # Function SUBTIME
1100
###<select SUBTIME('20:02:15','00:00:03')
1102
func_extra_sysdate=yes # Function SYSDATE
1104
###<select sysdate()
1105
###>2003-12-24 09:46:11
1106
func_extra_tail=no # Function TAIL
1108
###<select tail('ABCDEFG',3)
1109
###> 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 '('ABCDEFG',3)' at line 1
1110
func_extra_tanh=no # Function TANH
1113
###> 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
1114
func_extra_time=yes # Function TIME
1116
###<select time('20:02:12')
1118
func_extra_time_to_sec=yes # Function TIME_TO_SEC
1120
###<select time_to_sec('01:23:21')
1122
func_extra_timediff=yes # Function TIMEDIFF
1124
###<select TIMEDIFF('20:02:15','20:02:12')
1126
func_extra_timestamp=error # Function TIMESTAMP
1128
###<select timestamp('19630816','00200212')
1129
###>1963-08-16 20:02:12
1130
###We expected '19630816200212000000' but got '1963-08-16 20:02:12'
1131
func_extra_to_days=yes # Function TO_DAYS
1133
###<select to_days('1996-01-01') from crash_me_d
1135
func_extra_translate=no # Function TRANSLATE
1137
###<select translate('abc','bc','de')
1138
###> 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
1139
func_extra_trim1arg=yes # Function TRIM (1 arg)
1141
###<select trim(' abcd ')
1143
func_extra_trim2arg=no # Function TRIM (2 arg)
1145
###<select trim('..abcd..','.')
1146
###> 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
1147
func_extra_trim_many_char=error # Function TRIM; Many char extension
1149
###<select trim(':!' FROM ':abc!')
1151
###We expected 'abc' but got ':abc!'
1152
func_extra_trim_substring=yes # Function TRIM; Substring extension
1154
###<select trim('cb' FROM 'abccb')
1156
func_extra_trunc=no # Function TRUNC
1158
###<select trunc(18.18,-1)
1159
###> 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 '(18.18,-1)' at line 1
1160
func_extra_trunc1arg=no # Function TRUNC (1 arg)
1162
###<select trunc(222.6)
1163
###> 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
1164
func_extra_uid=no # Function UID
1167
###> execute failed:Unknown column 'uid' in 'field list'
1168
func_extra_unix_timestamp=yes # Function UNIX_TIMESTAMP
1170
###<select unix_timestamp()
1172
func_extra_userenv=no # Function USERENV
1175
###> execute failed:Unknown column 'userenv' in 'field list'
1176
func_extra_value=no # Function VALUE
1178
###<select value(NULL,'WALRUS')
1179
###> 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
1180
func_extra_version=yes # Function VERSION
1182
###<select version()
1183
###>5.0.0-alpha-debug-log
1184
func_extra_weekday=yes # Function WEEKDAY
1186
###<select weekday('1997-11-29') from crash_me_d
1188
func_extra_weekofyear=yes # Function WEEKOFYEAR
1190
###<select WEEKOFYEAR('1963-08-16') from crash_me_d
1192
func_extra_|=yes # Function | (bitwise or)
1196
func_extra_||=yes # Function OR as '||'
1198
###<select 1=0 || 1=1
1200
func_extra_~*=no # Function ~* (case insensitive compare)
1202
###<select 'hi' ~* 'HI'
1203
###> 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
1204
func_odbc_abs=yes # Function ABS
1208
func_odbc_acos=yes # Function ACOS
1212
func_odbc_ascii=yes # Function ASCII
1214
###<select ASCII('A')
1216
func_odbc_asin=yes # Function ASIN
1220
func_odbc_atan=yes # Function ATAN
1224
func_odbc_atan2=yes # Function ATAN2
1226
###<select atan2(1,0)
1228
func_odbc_ceiling=yes # Function CEILING
1230
###<select ceiling(-4.5)
1232
func_odbc_char=yes # Function CHAR
1236
func_odbc_concat=yes # Function CONCAT(2 arg)
1238
###<select concat('a','b')
1240
func_odbc_cos=yes # Function COS
1244
func_odbc_cot=yes # Function COT
1248
func_odbc_curdate=yes # Function CURDATE
1250
###<select curdate()
1252
func_odbc_curtime=yes # Function CURTIME
1254
###<select curtime()
1256
func_odbc_database=yes # Function DATABASE
1258
###<select database()
1260
func_odbc_dayname=yes # Function DAYNAME
1261
###< insert into crash_me_d values('1997-02-01')
1263
###<select dayname(a) from crash_me_d
1265
###< insert into crash_me_d values('1997-02-01')
1266
###< insert into crash_me_d values('1997-02-01')
1267
func_odbc_dayofmonth=yes # Function DAYOFMONTH
1268
###< insert into crash_me_d values('1997-02-01')
1270
###<select dayofmonth(a) from crash_me_d
1272
###< insert into crash_me_d values('1997-02-01')
1273
###< insert into crash_me_d values('1997-02-01')
1274
func_odbc_dayofweek=yes # Function DAYOFWEEK
1275
###< insert into crash_me_d values('1997-02-01')
1277
###<select dayofweek(a) from crash_me_d
1279
###< insert into crash_me_d values('1997-02-01')
1280
###< insert into crash_me_d values('1997-02-01')
1281
func_odbc_dayofyear=yes # Function DAYOFYEAR
1282
###< insert into crash_me_d values('1997-02-01')
1284
###<select dayofyear(a) from crash_me_d
1286
###< insert into crash_me_d values('1997-02-01')
1287
###< insert into crash_me_d values('1997-02-01')
1288
func_odbc_degrees=yes # Function DEGREES
1290
###<select degrees(6.283185)
1292
func_odbc_difference=no # Function DIFFERENCE()
1294
###<select difference('abc','abe')
1295
###> 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
1297
###<select {fn difference('abc','abe') }
1298
###> 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
1299
func_odbc_exp=yes # Function EXP
1303
func_odbc_floor=yes # Function FLOOR
1305
###<select floor(2.5)
1307
func_odbc_fn_left=yes # Function ODBC syntax LEFT & RIGHT
1309
###<select { fn LEFT( { fn RIGHT('abcd',2) },1) }
1311
func_odbc_hour=yes # Function HOUR
1312
###< insert into crash_me_t values(20:08:16)
1314
###<select hour('12:13:14')
1316
###< insert into crash_me_t values(20:08:16)
1317
###< insert into crash_me_t values(20:08:16)
1318
func_odbc_hour_time=yes # Function ANSI HOUR
1319
###< insert into crash_me_t values(20:08:16)
1321
###<select hour(TIME '12:13:14')
1323
###< insert into crash_me_t values(20:08:16)
1324
###< insert into crash_me_t values(20:08:16)
1325
func_odbc_ifnull=yes # Function IFNULL
1327
###<select ifnull(2,3)
1329
func_odbc_insert=yes # Function INSERT
1331
###<select insert('abcd',2,2,'ef')
1333
func_odbc_lcase=yes # Function LCASE
1335
###<select lcase('ABC')
1337
func_odbc_left=yes # Function LEFT
1339
###<select left('abcd',2)
1341
func_odbc_length=yes # Function REAL LENGTH
1343
###<select length('abcd ')
1345
func_odbc_length_without_space=error # Function ODBC LENGTH
1347
###<select length('abcd ')
1349
###We expected '4' but got '5'
1351
###<select {fn length('abcd ') }
1353
###We expected '4' but got '5'
1354
func_odbc_locate_2=yes # Function LOCATE(2 arg)
1356
###<select locate('bcd','abcd')
1358
func_odbc_locate_3=yes # Function LOCATE(3 arg)
1360
###<select locate('bcd','abcd',3)
1362
func_odbc_log=yes # Function LOG
1366
func_odbc_log10=yes # Function LOG10
1368
###<select log10(10)
1370
func_odbc_ltrim=yes # Function LTRIM
1372
###<select ltrim(' abcd')
1374
func_odbc_minute=yes # Function MINUTE
1375
###< insert into crash_me_t values(20:08:16)
1377
###<select minute('12:13:14')
1379
###< insert into crash_me_t values(20:08:16)
1380
###< insert into crash_me_t values(20:08:16)
1381
func_odbc_mod=yes # Function MOD
1383
###<select mod(11,7)
1385
func_odbc_month=yes # Function MONTH
1386
###< insert into crash_me_d values('1997-02-01')
1388
###<select month(a) from crash_me_d
1390
###< insert into crash_me_d values('1997-02-01')
1391
###< insert into crash_me_d values('1997-02-01')
1392
func_odbc_monthname=yes # Function MONTHNAME
1393
###< insert into crash_me_d values('1997-02-01')
1395
###<select monthname(a) from crash_me_d
1397
###< insert into crash_me_d values('1997-02-01')
1398
###< insert into crash_me_d values('1997-02-01')
1399
func_odbc_now=yes # Function NOW
1402
###>2003-12-24 09:46:11
1403
func_odbc_pi=yes # Function PI
1407
func_odbc_power=yes # Function POWER
1409
###<select power(2,4)
1411
func_odbc_quarter=yes # Function QUARTER
1412
###< insert into crash_me_d values('1997-02-01')
1414
###<select quarter(a) from crash_me_d
1416
###< insert into crash_me_d values('1997-02-01')
1417
###< insert into crash_me_d values('1997-02-01')
1418
func_odbc_radians=yes # Function RADIANS
1420
###<select radians(360)
1422
func_odbc_rand=yes # Function RAND
1425
###>0.40540353712198
1426
func_odbc_repeat=yes # Function REPEAT
1428
###<select repeat('ab',3)
1430
func_odbc_replace=yes # Function REPLACE
1432
###<select replace('abbaab','ab','ba')
1434
func_odbc_right=yes # Function RIGHT
1436
###<select right('abcd',2)
1438
func_odbc_round=yes # Function ROUND(2 arg)
1440
###<select round(5.63,2)
1442
func_odbc_rtrim=yes # Function RTRIM
1444
###<select rtrim(' abcd ')
1446
func_odbc_second=yes # Function SECOND
1447
###< insert into crash_me_t values(20:08:16)
1449
###<select second('12:13:14')
1451
###< insert into crash_me_t values(20:08:16)
1452
###< insert into crash_me_t values(20:08:16)
1453
func_odbc_sign=yes # Function SIGN
1457
func_odbc_sin=yes # Function SIN
1461
func_odbc_soundex=yes # Function SOUNDEX
1463
###<select soundex('hello')
1465
func_odbc_space=yes # Function SPACE
1469
func_odbc_sqrt=yes # Function SQRT
1473
func_odbc_substring=yes # Function ODBC SUBSTRING
1475
###<select substring('abcd',3,2)
1477
func_odbc_tan=yes # Function TAN
1481
func_odbc_timestampadd=yes # Function TIMESTAMPADD
1483
###<select timestampadd(SQL_TSI_SECOND,1,'1997-01-01 00:00:00')
1484
###>1997-01-01 00:00:01
1485
func_odbc_timestampdiff=error # Function TIMESTAMPDIFF
1487
###<select timestampdiff(SQL_TSI_SECOND,'1997-01-01 00:00:02', '1997-01-01 00:00:01')
1489
###We expected '1' but got '-1'
1491
###<select {fn timestampdiff(SQL_TSI_SECOND,{ts '1997-01-01 00:00:02'}, {ts '1997-01-01 00:00:01'}) }
1493
###We expected '1' but got '-1'
1494
func_odbc_truncate=yes # Function TRUNCATE
1496
###<select truncate(18.18,-1)
1498
func_odbc_ucase=yes # Function UCASE
1500
###<select ucase('abc')
1502
func_odbc_user()=yes # Function USER()
1506
func_odbc_week=USA # WEEK
1507
###<select week('1997-02-01')
1509
###We expected '5' but got '4'
1510
###<select week('1997-02-01')
1512
###We expected '5' but got '4'
1513
###<select week('1997-02-01')
1515
###We expected '5' but got '4'
1516
func_odbc_year=yes # Function YEAR
1517
###< insert into crash_me_d values('1997-02-01')
1519
###<select year(a) from crash_me_d
1521
###< insert into crash_me_d values('1997-02-01')
1522
###< insert into crash_me_d values('1997-02-01')
1523
func_sql_+=yes # Function +, -, * and /
1525
###<select 5*3-4/2+1
1527
func_sql_bit_length=yes # Function BIT_LENGTH
1529
###<select bit_length('abc')
1531
func_sql_cast=yes # Function CAST
1533
###<select CAST(1 as CHAR)
1535
func_sql_char_length=error # Function CHAR_LENGTH
1537
###<select char_length(b) from crash_me
1539
###We expected '10' but got '1'
1540
func_sql_char_length(constant)=yes # Function CHAR_LENGTH(constant)
1542
###<select char_length('abcd')
1544
func_sql_character_length=yes # Function CHARACTER_LENGTH
1546
###<select character_length('abcd')
1548
func_sql_coalesce=yes # Function COALESCE
1550
###<select coalesce(NULL,'bcd','qwe')
1552
func_sql_concat_as_||=error # Function concatenation with ||
1554
###<select 'abc' || 'def'
1556
###We expected 'abcdef' but got '0'
1557
func_sql_current_date=yes # Function CURRENT_DATE
1559
###<select current_date
1561
func_sql_current_time=yes # Function CURRENT_TIME
1563
###<select current_time
1565
func_sql_current_timestamp=yes # Function CURRENT_TIMESTAMP
1567
###<select current_timestamp
1568
###>2003-12-24 09:46:11
1569
func_sql_current_user=with_parenthesis # CURRENT_USER
1570
###< select CURRENT_USER
1571
###> execute error:Unknown column 'CURRENT_USER' in 'field list'
1573
###< select CURRENT_USER()
1575
###< select CURRENT_USER
1577
###< select CURRENT_USER
1578
###> execute error:Unknown column 'CURRENT_USER' in 'field list'
1580
###< select CURRENT_USER()
1582
func_sql_extract_sql=yes # Function EXTRACT
1584
###<select extract(minute from timestamp '2000-02-23 18:43:12.987')
1586
func_sql_localtime=yes # Function LOCALTIME
1588
###<select localtime
1589
###>2003-12-24 09:46:11
1590
func_sql_localtimestamp=yes # Function LOCALTIMESTAMP
1592
###<select localtimestamp
1593
###>2003-12-24 09:46:11
1594
func_sql_lower=yes # Function LOWER
1596
###<select LOWER('ABC')
1598
func_sql_nullif_num=yes # Function NULLIF with numbers
1600
###<select NULLIF(NULLIF(1,2),1)
1602
func_sql_nullif_string=yes # Function NULLIF with strings
1604
###<select NULLIF(NULLIF('first','second'),'first')
1606
func_sql_octet_length=yes # Function OCTET_LENGTH
1608
###<select octet_length('abc')
1610
func_sql_position=yes # Function POSITION
1612
###<select position('ll' in 'hello')
1614
func_sql_searched_case=yes # Function searched CASE
1616
###<select case when 1 > 2 then 'false' when 2 > 1 then 'true' end
1618
func_sql_session_user=with_parenthesis # SESSION_USER
1619
###< select SESSION_USER
1620
###> execute error:Unknown column 'SESSION_USER' in 'field list'
1622
###< select SESSION_USER()
1624
###< select SESSION_USER
1625
###> execute error:Unknown column 'SESSION_USER' in 'field list'
1627
###< select SESSION_USER()
1629
###< select SESSION_USER
1630
###> execute error:Unknown column 'SESSION_USER' in 'field list'
1632
###< select SESSION_USER()
1634
func_sql_simple_case=yes # Function simple CASE
1636
###<select case 2 when 1 then 'false' when 2 then 'true' end
1638
func_sql_substring=yes # Function ANSI SQL SUBSTRING
1640
###<select substring('abcd' from 2 for 2)
1642
func_sql_system_user=with_parenthesis # SYSTEM_USER
1643
###< select SYSTEM_USER
1644
###> execute error:Unknown column 'SYSTEM_USER' in 'field list'
1646
###< select SYSTEM_USER()
1648
###< select SYSTEM_USER
1649
###> execute error:Unknown column 'SYSTEM_USER' in 'field list'
1651
###< select SYSTEM_USER()
1653
###< select SYSTEM_USER
1654
###> execute error:Unknown column 'SYSTEM_USER' in 'field list'
1656
###< select SYSTEM_USER()
1658
func_sql_trim=yes # Function TRIM
1660
###<select trim(trailing from trim(LEADING FROM ' abc '))
1662
func_sql_upper=yes # Function UPPER
1664
###<select UPPER('abc')
1666
func_sql_user=with_parenthesis # USER
1668
###> execute error:Unknown column 'USER' in 'field list'
1673
###> execute error:Unknown column 'USER' in 'field list'
1678
###> execute error:Unknown column 'USER' in 'field list'
1682
func_where_between=yes # Function BETWEEN
1684
###<select a from crash_me where 5 between 4 and 6
1686
func_where_eq_all=yes # Function = ALL
1688
###<select a from crash_me where b =all (select b from crash_me)
1690
func_where_eq_any=yes # Function = ANY
1692
###<select a from crash_me where b =any (select b from crash_me)
1694
func_where_eq_some=yes # Function = SOME
1696
###<select a from crash_me where b =some (select b from crash_me)
1698
func_where_exists=yes # Function EXISTS
1700
###<select a from crash_me where exists (select * from crash_me)
1702
func_where_in_num=yes # Function IN on numbers
1704
###<select a from crash_me where 2 in (3,2,5,9,5,1)
1706
func_where_like=yes # Function LIKE
1708
###<select a from crash_me where b like 'a%'
1710
func_where_like_escape=yes # Function LIKE ESCAPE
1712
###<select a from crash_me where b like '%' escape 'a'
1714
func_where_match=no # Function MATCH
1716
###<select a from crash_me where 1 match (select a from crash_me)
1717
###> 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 (select a from crash_me)' at line 1
1718
func_where_match_unique=no # Function MATCH UNIQUE
1720
###<select a from crash_me where 1 match unique (select a from crash_me)
1721
###> 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
1722
func_where_matches=no # Function MATCHES
1724
###<select a from crash_me where b matcjhes 'a*'
1725
###> 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 'matcjhes 'a*'' at line 1
1726
func_where_not_between=yes # Function NOT BETWEEN
1728
###<select a from crash_me where 7 not between 4 and 6
1730
func_where_not_exists=yes # Function NOT EXISTS
1732
###<select a from crash_me where not exists (select * from crash_me where a = 2)
1734
func_where_not_like=yes # Function NOT LIKE
1736
###<select a from crash_me where b not like 'b%'
1738
func_where_not_unique=no # Function NOT UNIQUE
1740
###<select a from crash_me where not unique (select * from crash_me where a = 2)
1741
###> 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 where a = 2)' at line 1
1742
func_where_unique=no # Function UNIQUE
1744
###<select a from crash_me where unique (select * from crash_me)
1745
###> 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
1746
functions=yes # Functions
1750
###As far as all queries returned OK, result is YES
1751
group_by=yes # Group by
1752
###< select a from crash_me group by a
1755
###As far as all queries returned OK, result is YES
1756
group_by_alias=yes # Group by alias
1757
###< select a as ab from crash_me group by ab
1760
###As far as all queries returned OK, result is YES
1761
group_by_null=yes # Group on column with null values
1762
###< create table crash_q (s char(10))
1764
###< insert into crash_q values(null)
1766
###< insert into crash_q values(null)
1769
###<select count(*),s from crash_q group by s
1772
###< drop table crash_q
1774
group_by_position=yes # Group by position
1775
###< select a from crash_me group by 1
1778
###As far as all queries returned OK, result is YES
1779
group_distinct_functions=yes # Group functions with distinct
1780
###< select count(distinct a) from crash_me
1783
###As far as all queries returned OK, result is YES
1784
group_func_extra_bit_and=yes # Group function BIT_AND
1786
###<select bit_and(a),a from crash_me group by a
1788
group_func_extra_bit_or=yes # Group function BIT_OR
1790
###<select bit_or(a),a from crash_me group by a
1792
group_func_extra_count_distinct_list=yes # Group function COUNT(DISTINCT expr,expr,...)
1794
###<select count(distinct a,b),a from crash_me group by a
1796
group_func_extra_std=yes # Group function STD
1798
###<select std(a),a from crash_me group by a
1800
group_func_extra_stddev=yes # Group function STDDEV
1802
###<select stddev(a),a from crash_me group by a
1804
group_func_extra_variance=yes # Group function VARIANCE
1806
###<select variance(a),a from crash_me group by a
1808
group_func_sql_any=no # Group function ANY
1810
###<select any(a),a from crash_me group by a
1811
###> 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
1812
group_func_sql_avg=yes # Group function AVG
1814
###<select avg(a),a from crash_me group by a
1816
group_func_sql_count_*=yes # Group function COUNT (*)
1818
###<select count(*),a from crash_me group by a
1820
group_func_sql_count_column=yes # Group function COUNT column name
1822
###<select count(a),a from crash_me group by a
1824
group_func_sql_count_distinct=yes # Group function COUNT(DISTINCT expr)
1826
###<select count(distinct a),a from crash_me group by a
1828
group_func_sql_every=no # Group function EVERY
1830
###<select every(a),a from crash_me group by a
1831
###> 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
1832
group_func_sql_max=yes # Group function MAX on numbers
1834
###<select max(a),a from crash_me group by a
1836
group_func_sql_max_str=yes # Group function MAX on strings
1838
###<select max(b),a from crash_me group by a
1840
group_func_sql_min=yes # Group function MIN on numbers
1842
###<select min(a),a from crash_me group by a
1844
group_func_sql_min_str=yes # Group function MIN on strings
1846
###<select min(b),a from crash_me group by a
1848
group_func_sql_some=no # Group function SOME
1850
###<select some(a),a from crash_me group by a
1851
###> 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
1852
group_func_sql_sum=yes # Group function SUM
1854
###<select sum(a),a from crash_me group by a
1856
group_functions=yes # Group functions
1857
###< select count(*) from crash_me
1860
###As far as all queries returned OK, result is YES
1861
group_many_distinct_functions=yes # Group functions with several distinct
1862
###< select count(distinct a), count(distinct b) from crash_me
1865
###As far as all queries returned OK, result is YES
1866
group_on_unused=yes # Group on unused column
1867
###< select count(*) from crash_me group by a
1870
###As far as all queries returned OK, result is YES
1871
has_true_false=yes # TRUE and FALSE
1872
###< select (1=1)=true
1875
###<select a from crash_me group by a having a > 0
1878
###<select a from crash_me group by a having a < 0
1879
###> didn't return any result:
1880
having_with_alias=yes # Having on alias
1881
###< select a as ab from crash_me group by a having ab > 0
1884
###As far as all queries returned OK, result is YES
1885
having_with_group=yes # Having with group function
1886
###< select a from crash_me group by a having count(*) = 1
1889
###As far as all queries returned OK, result is YES
1890
hex_numbers=yes # hex numbers (0x41)
1894
###As far as all queries returned OK, result is YES
1895
hex_strings=yes # hex strings (x'1ace')
1899
###As far as all queries returned OK, result is YES
1900
ignore_end_space=yes # Ignore end space in compare
1902
###<select b from crash_me where b = 'a '
1904
index_in_create=yes # index in create table
1905
###< create table crash_q (q integer not null,index (q))
1907
###< drop table crash_q
1910
###As far as all queries returned OK, result is YES
1911
index_namespace=yes # different namespace for index
1912
###< create index crash_me on crash_me (b)
1914
###< drop index crash_me on crash_me
1917
###As far as all queries returned OK, result is YES
1918
index_parts=yes # index on column part (extension)
1919
###< create index crash_q on crash_me (b(5))
1921
###< drop index crash_q on crash_me
1924
###As far as all queries returned OK, result is YES
1925
inner_join=yes # inner join
1926
###< select crash_me.a from crash_me inner join crash_me2 ON crash_me.a=crash_me2.a
1929
###As far as all queries returned OK, result is YES
1930
insert_default_values=no # INSERT DEFAULT VALUES
1931
###< create table crash_me_q (a int)
1933
###< insert into crash_me_q DEFAULT VALUES
1934
###> 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
1935
###< drop table crash_me_q
1938
###As far as some queries didnt return OK, result is NO
1939
insert_empty_string=yes # insert empty string
1940
###< create table crash_q (a char(10) not null,b char(10))
1942
###< insert into crash_q values ('','')
1944
###< drop table crash_q
1947
###As far as all queries returned OK, result is YES
1948
insert_multi_value=yes # INSERT with Value lists
1949
###< create table crash_q (s char(10))
1951
###< insert into crash_q values ('a'),('b')
1953
###< drop table crash_q
1956
###As far as all queries returned OK, result is YES
1957
insert_select=yes # insert INTO ... SELECT ...
1958
###< create table crash_q (a int)
1960
###< insert into crash_q (a) SELECT crash_me.a from crash_me
1962
###< drop table crash_q
1965
###As far as all queries returned OK, result is YES
1966
insert_with_default=yes # INSERT with DEFAULT
1967
###< create table crash_me_q (a int)
1969
###< insert into crash_me_q (a) values (DEFAULT)
1971
###< drop table crash_me_q
1974
###As far as all queries returned OK, result is YES
1975
insert_with_empty_value_list=no # INSERT with empty value list
1976
###< create table crash_me_q (a int)
1978
###< insert into crash_me_q (a) values ()
1979
###> execute error:Column count doesn't match value count at row 1
1980
###< drop table crash_me_q
1983
###As far as some queries didnt return OK, result is NO
1984
insert_with_set=yes # INSERT with set syntax
1985
###< create table crash_q (a integer)
1987
###< insert into crash_q SET a=1
1989
###< drop table crash_q
1992
###As far as all queries returned OK, result is YES
1993
intersect=no # intersect
1994
###< select * from crash_me intersect select * from crash_me3
1995
###> 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
1997
###As far as some queries didnt return OK, result is NO
1998
intersect_all=no # intersect all
1999
###< select * from crash_me intersect all select * from crash_me3
2000
###> 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
2002
###As far as some queries didnt return OK, result is NO
2003
intersect_all_incompat=no # intersect all (incompatible lists)
2004
###< select * from crash_me intersect all select * from crash_me2
2005
###> 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
2007
###As far as some queries didnt return OK, result is NO
2008
intersect_incompat=no # intersect (incompatible lists)
2009
###< select * from crash_me intersect select * from crash_me2
2010
###> 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
2012
###As far as some queries didnt return OK, result is NO
2013
join_tables=61 # tables in join
2014
###We are trying (example with N=5):
2015
###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
2016
### 32:OK 48:OK 56:OK 60:OK 62:FAIL 61:FAIL
2017
left_outer_join=yes # left outer join
2018
###< select crash_me.a from crash_me left join crash_me2 ON crash_me.a=crash_me2.a
2021
###As far as all queries returned OK, result is YES
2022
left_outer_join_using=yes # left outer join using
2023
###< select c1 from crash_me left join crash_me2 using (a)
2026
###As far as all queries returned OK, result is YES
2027
length_of_varchar_field=actual length # CHARACTER_LENGTH(varchar_field)
2028
###< CREATE TABLE crash_me1 (S1 VARCHAR(100))
2030
###< INSERT INTO crash_me1 VALUES ('X')
2033
###< SELECT CHARACTER_LENGTH(S1) FROM crash_me1
2035
###< drop table crash_me1
2037
like_with_column=yes # column LIKE column
2038
###< create table crash_q (a char(10),b char(10))
2040
###< insert into crash_q values('abc','abc')
2042
###< select * from crash_q where a like b
2044
###< drop table crash_q
2047
###As far as all queries returned OK, result is YES
2048
like_with_number=yes # LIKE on numbers
2049
###< create table crash_q (a int,b int)
2051
###< insert into crash_q values(10,10)
2053
###< select * from crash_q where a like '10'
2055
###< drop table crash_q
2058
###As far as all queries returned OK, result is YES
2059
lock_tables=yes # lock table
2060
###< lock table crash_me READ
2065
###As far as all queries returned OK, result is YES
2066
logical_value=1 # Value of logical operation (1=1)
2069
max_big_expressions=10 # big expressions
2070
###We are trying (example with N=5):
2071
###select 0+(1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+...(14328)
2072
### 50:FAIL 10:OK 30:FAIL 14:FAIL 11:FAIL
2073
max_char_size=1048543 # max char() size
2074
###We are trying (example with N=5):
2075
###create table crash_q (q char(5))
2076
###insert into crash_q values ('aaaaa')
2077
###select * from crash_q
2078
### 524287:OK 786431:OK 917503:OK 983039:OK 1015807:OK 1032191:OK 1040383:OK 1044479:OK 1046527:OK 1047551:OK 1048063:OK 1048319:OK 1048447:OK 1048511:OK 1048543:OK 1048559:FAIL 1048546:FAIL 1048544:FAIL
2079
max_column_name=64 # column name length
2080
###We are trying (example with N=5):
2081
###create table crash_q (qaaaaa integer)
2082
###insert into crash_q (qaaaaa) values(1)
2083
###select qaaaaa from crash_q
2084
### 256:FAIL 51:OK 153:FAIL 72:FAIL 55:OK 63:OK 67:FAIL 64:FAIL
2085
max_columns=2599 # Columns in table
2086
###We are trying (example with N=5):
2087
###create table crash_q (a integer ,a0 integer,a1 integer,a2 integer,a3 integer,a4 integer)
2088
### 4096:FAIL 819:OK 2457:OK 3276:FAIL 2621:FAIL 2490:OK 2555:OK 2588:OK 2604:FAIL 2591:OK 2597:OK 2600:FAIL 2598:OK 2599:FAIL
2089
max_conditions=85660 # OR and AND in WHERE
2090
###We are trying (example with N=5):
2091
###select a from crash_me where a=1 and b='a' or a=0 and b='0' or a=1 and b='1' or a=2 and b='2' or a=3 and b='3' or a=4 and b='4'
2092
### 27592:OK 41389:OK 48287:FAIL 42769:OK 45528:FAIL 43321:FAIL 42880:FAIL 42791:OK 42835:FAIL 42800:OK 42817:OK 42826:OK 42830:OK 42832:FAIL 42831:FAIL
2093
max_expressions=1452 # simple expressions
2094
###We are trying (example with N=5):
2095
###select 1+1+1+1+1+1
2096
### 5000:FAIL 1000:OK 3000:FAIL 1400:OK 2200:FAIL 1560:FAIL 1432:OK 1496:FAIL 1445:OK 1470:FAIL 1450:OK 1460:FAIL 1452:OK 1456:FAIL 1453:FAIL
2097
max_index=32 # max index
2098
### max_unique_index=32 ,so max_index must be same
2099
### max_unique_index=32 ,so max_index must be same
2100
### max_unique_index=32 ,so max_index must be same
2101
max_index_length=500 # index length
2102
###We are trying (example with N=5):
2103
###create table crash_q (q0 char(5) not null,unique (q0))
2104
###insert into crash_q values('aaaaa')
2105
### 4096:FAIL 819:FAIL 164:OK 491:OK 655:FAIL 524:FAIL 498:OK 511:FAIL 501:FAIL 499:OK 500:OK
2106
max_index_name=64 # index name length
2107
###We are trying (example with N=5):
2108
###create index crash_qaaaaa on crash_me (a)
2109
### 256:FAIL 51:OK 153:FAIL 72:FAIL 55:OK 63:FAIL 57:OK 60:FAIL 58:FAIL
2110
max_index_part_length=255 # max index part length
2111
###We are trying (example with N=5):
2112
###create table crash_q (q char(5) not null,unique(q))
2113
###insert into crash_q (q) values ('aaaaa')
2114
###select q from crash_q
2115
### 524271:FAIL 104854:FAIL 20971:FAIL 4194:FAIL 839:FAIL 168:OK 503:FAIL 235:OK 369:FAIL 262:FAIL 241:OK 251:OK 256:FAIL 252:OK 254:OK 255:OK
2116
max_index_parts=16 # index parts
2117
###We are trying (example with N=5):
2118
###create table crash_q (q0 integer not null,q1 integer not null,q2 integer not null,q3 integer not null,q4 integer not nul...(1263)
2119
###insert into crash_q (q0,q1,q2,q3,q4,q5,q6,q7,q8,q9,q10,q11,q12,q13,q14,q15,q16,q17,q18,q19,q20,q21,q22,q23,q24,q25,q26,q...(284)
2120
###select q0 from crash_q
2121
### 32:FAIL 7:OK 19:FAIL 10:OK 14:OK 16:FAIL 15:OK
2122
max_index_varchar_part_length=255 # index varchar part length
2123
###We are trying (example with N=5):
2124
###create table crash_q (q varchar(5) not null,unique(q))
2125
###insert into crash_q (q) values ('aaaaa')
2126
###select q from crash_q
2127
### 524271:FAIL 104854:FAIL 20971:FAIL 4194:FAIL 839:FAIL 168:OK 503:FAIL 235:OK 369:FAIL 262:FAIL 241:OK 251:OK 256:FAIL 252:OK 254:OK 255:OK
2128
max_row_length=65534 # max table row length (without blobs)
2129
###We are trying (example with N=5):
2130
###create table crash_q (q0 char(5) not null)
2131
###insert into crash_q values ('aaaaa')
2132
### 331372:FAIL 66275:FAIL 13255:OK 39765:OK 53020:OK 59647:OK 62961:OK 64618:OK 65446:OK 65860:FAIL 65529:OK 65694:FAIL 65562:FAIL 65536:FAIL 65531:OK 65533:OK 65534:OK 65535:FAIL
2133
max_row_length_with_null=65502 # table row length with nulls (without blobs)
2134
###We are trying (example with N=5):
2135
###create table crash_q (q0 char(5) )
2136
###insert into crash_q values ('aaaaa')
2137
### 65534:FAIL 13107:OK 39320:OK 52427:OK 58980:OK 62257:OK 63895:OK 64714:OK 65124:OK 65329:OK 65431:OK 65482:OK 65508:FAIL 65487:OK 65497:OK 65502:OK 65505:FAIL 65503:FAIL
2138
max_select_alias_name=+512 # select alias name length
2139
###We are trying (example with N=5):
2140
###select b as aaaaa from crash_me
2141
max_stack_expression=1452 # stacked expressions
2142
###We are trying (example with N=5):
2143
###select 1+(1+(1+(1+(1+(1)))))
2144
### 1000:OK 1500:FAIL 1100:OK 1300:OK 1400:OK 1450:OK 1475:FAIL 1455:FAIL 1451:OK 1453:FAIL 1452:OK
2145
max_table_alias_name=+512 # table alias name length
2146
###We are trying (example with N=5):
2147
###select aaaaa.b from crash_me aaaaa
2148
max_table_name=64 # table name length
2149
###We are trying (example with N=5):
2150
###create table crash_qaaaaa (q integer)
2151
###insert into crash_qaaaaa values(1)
2152
###select * from crash_qaaaaa
2153
### 256:FAIL 51:OK 153:FAIL 72:FAIL 55:OK 63:FAIL 57:OK 60:FAIL 58:FAIL
2154
max_text_size=1048543 # max text or blob size
2155
###We are trying (example with N=5):
2156
###create table crash_q (q mediumtext)
2157
###insert into crash_q values ('aaaaa')
2158
###select * from crash_q
2159
### 524272:OK 786408:OK 917476:OK 983010:OK 1015777:OK 1032161:OK 1040353:OK 1044449:OK 1046497:OK 1047521:OK 1048033:OK 1048289:OK 1048417:OK 1048481:OK 1048513:OK 1048529:OK 1048537:OK 1048541:OK 1048543:OK 1048544:FAIL
2160
max_unique_index=32 # unique indexes
2161
###We are trying (example with N=5):
2162
###create table crash_q (q integer,q1 integer not null,unique (q1),q2 integer not null,unique (q2),q3 integer not null,uniq...(72)
2163
###insert into crash_q (q,q1,q2,q3,q4,q5) values (1,1,1,1,1,1)
2164
###select q from crash_q
2165
### 32:OK 48:FAIL 35:FAIL 33:FAIL
2166
max_varchar_size=1048543 # max varchar() size
2167
###We are trying (example with N=5):
2168
###create table crash_q (q varchar(5))
2169
###insert into crash_q values ('aaaaa')
2170
###select * from crash_q
2171
### 524287:OK 786431:OK 917503:OK 983039:OK 1015807:OK 1032191:OK 1040383:OK 1044479:OK 1046527:OK 1047551:OK 1048063:OK 1048319:OK 1048447:OK 1048511:OK 1048543:OK 1048559:FAIL 1048546:FAIL 1048544:FAIL
2173
###< select * from crash_me minus select * from crash_me3
2174
###> 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
2176
###As far as some queries didnt return OK, result is NO
2177
minus_incompat=no # minus (incompatible lists)
2178
###< select * from crash_me minus select * from crash_me2
2179
###> 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
2181
###As far as some queries didnt return OK, result is NO
2182
minus_neg=yes # Calculate 1--1
2184
###<select a--1 from crash_me
2186
multi_drop=yes # many tables to drop table
2187
###< create table crash_q (a int)
2189
###< create table crash_q2 (a int)
2191
###< drop table crash_q,crash_q2
2194
###As far as all queries returned OK, result is YES
2195
multi_null_in_unique=yes # null in unique index
2196
###< create table crash_q (q integer, x integer,unique (q))
2198
###< insert into crash_q(x) values(1)
2200
###< insert into crash_q(x) values(2)
2202
###< drop table crash_q
2205
###As far as all queries returned OK, result is YES
2206
multi_strings=yes # Multiple line strings
2208
###<select a from crash_me where b < 'a'
2211
multi_table_delete=yes # DELETE FROM table1,table2...
2212
###< create table crash_q (a integer,b char(10))
2214
###< insert into crash_q values(1,'c')
2216
###< delete crash_q.* from crash_q,crash_me where crash_q.a=crash_me.a
2218
###< drop table crash_q
2221
###As far as all queries returned OK, result is YES
2222
multi_table_update=yes # Update with many tables
2223
###< create table crash_q (a integer,b char(10))
2225
###< insert into crash_q values(1,'c')
2227
###< update crash_q left join crash_me on crash_q.a=crash_me.a set crash_q.b=crash_me.b
2230
###<select b from crash_q
2233
###< drop table crash_q
2235
natural_join=yes # natural join
2236
###< select * from crash_me natural join crash_me3
2239
###As far as all queries returned OK, result is YES
2240
natural_join_incompat=yes # natural join (incompatible lists)
2241
###< select c1 from crash_me natural join crash_me2
2244
###As far as all queries returned OK, result is YES
2245
natural_left_outer_join=yes # natural left outer join
2246
###< select c1 from crash_me natural left join crash_me2
2249
###As far as all queries returned OK, result is YES
2250
no_primary_key=yes # Tables without primary key
2251
###< create table crash_me (a integer not null,b char(10) not null)
2253
###< insert into crash_me (a,b) values (1,'a')
2255
###< create table crash_me (a integer not null,b char(10) not null)
2257
###< insert into crash_me (a,b) values (1,'a')
2259
###< create table crash_me (a integer not null,b char(10) not null)
2261
###< insert into crash_me (a,b) values (1,'a')
2263
not_id_between=no # NOT ID BETWEEN interprets as ID NOT BETWEEN
2264
###< create table crash_me_b (i int)
2266
###< insert into crash_me_b values(2)
2268
###< insert into crash_me_b values(5)
2271
###<select i from crash_me_b where not i between 1 and 3
2272
###> didn't return any result:
2274
###< drop table crash_me_b
2276
###< create table crash_me_b (i int)
2278
###< insert into crash_me_b values(2)
2280
###< insert into crash_me_b values(5)
2283
###<select i from crash_me_b where not i between 1 and 3
2284
###> didn't return any result:
2286
###< drop table crash_me_b
2288
###< create table crash_me_b (i int)
2290
###< insert into crash_me_b values(2)
2292
###< insert into crash_me_b values(5)
2295
###<select i from crash_me_b where not i between 1 and 3
2296
###> didn't return any result:
2298
###< drop table crash_me_b
2300
null_concat_expr=yes # Is concat('a',NULL) = NULL
2302
###<select concat('a',NULL)
2304
null_in_index=yes # null in index
2305
###< create table crash_q (a char(10),index (a))
2307
###< insert into crash_q values (NULL)
2310
###<select * from crash_q
2313
###< drop table crash_q
2315
null_in_unique=yes # null in unique index
2316
###< create table crash_q (q integer,unique (q))
2318
###< insert into crash_q (q) values(NULL)
2320
###< insert into crash_q (q) values(NULL)
2322
###< drop table crash_q
2325
###As far as all queries returned OK, result is YES
2326
null_num_expr=yes # Is 1+NULL = NULL
2330
nulls_in_unique=yes # null combination in unique index
2331
###< create table crash_q (q integer,q1 integer,unique (q,q1))
2333
###< insert into crash_q (q,q1) values(1,NULL)
2335
###< insert into crash_q (q,q1) values(1,NULL)
2337
###< drop table crash_q
2340
###As far as all queries returned OK, result is YES
2341
odbc_left_outer_join=yes # left outer join odbc style
2342
###< select crash_me.a from { oj crash_me left outer join crash_me2 ON crash_me.a=crash_me2.a }
2345
###As far as all queries returned OK, result is YES
2346
operating_system=Linux 2.4.20-64GB-SMP i686 # crash-me tested on
2347
order_by=yes # Order by
2348
###< select a from crash_me order by a
2351
###As far as all queries returned OK, result is YES
2352
order_by_alias=yes # Order by alias
2353
###< select a as ab from crash_me order by ab
2356
###As far as all queries returned OK, result is YES
2357
order_by_function=yes # Order by function
2358
###< select a from crash_me order by a+1
2361
###As far as all queries returned OK, result is YES
2362
order_by_position=yes # Order by position
2363
###< select a from crash_me order by 1
2366
###As far as all queries returned OK, result is YES
2367
order_on_unused=yes # Order by on unused column
2368
###< select b from crash_me order by a
2371
###As far as all queries returned OK, result is YES
2372
position_of_null=first # Where is null values in sorted recordset
2373
###< insert into crash_me_n (i) values(1)
2375
###< insert into crash_me_n values(2,2)
2377
###< insert into crash_me_n values(3,3)
2379
###< insert into crash_me_n values(4,4)
2381
###< insert into crash_me_n (i) values(5)
2384
###< select r from crash_me_n order by r
2390
###< insert into crash_me_n (i) values(1)
2392
###< insert into crash_me_n values(2,2)
2394
###< insert into crash_me_n values(3,3)
2396
###< insert into crash_me_n values(4,4)
2398
###< insert into crash_me_n (i) values(5)
2400
###< insert into crash_me_n (i) values(1)
2402
###< insert into crash_me_n values(2,2)
2404
###< insert into crash_me_n values(3,3)
2406
###< insert into crash_me_n values(4,4)
2408
###< insert into crash_me_n (i) values(5)
2410
position_of_null_desc=last # Where is null values in sorted recordset (DESC)
2411
###< select r from crash_me_n order by r desc
2417
primary_key_in_create=yes # primary key in create table
2418
###< create table crash_q (q integer not null,primary key (q))
2420
###< drop table crash_q
2423
###As far as all queries returned OK, result is YES
2424
psm_functions=no # PSM functions (ANSI SQL)
2425
###< create table crash_q (a int)
2427
###< create function crash_func(in a1 int, in b1 int) returns int language sql deterministic contains sql begin return a1 * b1; end
2428
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'in a1 int, in b1 int) returns int language sql deterministic co
2429
###< insert into crash_q values(crash_func(2,4))
2430
###> 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
2431
###< select a,crash_func(a,2) from crash_q
2432
###> 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
2433
###< drop function crash_func cascade
2434
###> execute error:Failed to DROP FUNCTION crash_func
2435
###< drop table crash_q
2438
###As far as some queries didnt return OK, result is NO
2439
psm_modules=no # PSM modules (ANSI SQL)
2440
###< create table crash_q (a int,b int)
2442
###< 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
2443
###> 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
2444
###< call crash_proc(1,10)
2445
###> execute error:PROCEDURE crash_proc does not exist
2446
###< drop module crash_m cascade
2447
###> 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
2448
###< drop table crash_q cascade
2451
###As far as some queries didnt return OK, result is NO
2452
psm_procedures=no # PSM procedures (ANSI SQL)
2453
###< create table crash_q (a int,b int)
2455
###< 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
2456
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'sql data begin declare c1 int; set c1 = a1 + b1; insert into cr
2457
###< call crash_proc(1,10)
2458
###> execute error:PROCEDURE crash_proc does not exist
2459
###< drop procedure crash_proc
2460
###> execute error:Failed to DROP PROCEDURE crash_proc
2461
###< drop table crash_q
2464
###As far as some queries didnt return OK, result is NO
2465
psm_trigger=no # Triggers (ANSI SQL)
2466
###< create table crash_q (a int ,b int)
2468
###< create trigger crash_trigger after insert on crash_q referencing new table as new_a when (localtime > time '18:00:00') begin atomic end
2469
###> 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
2470
###< insert into crash_q values(1,2)
2472
###< drop trigger crash_trigger
2473
###> 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
2474
###< drop table crash_q
2477
###As far as some queries didnt return OK, result is NO
2478
query_size=1048574 # query size
2479
quote_ident_with_"=error # " as identifier quote (ANSI SQL)
2481
###<select "A" from crash_me
2483
###We expected '1' but got 'A'
2484
quote_ident_with_[=no # [] as identifier quote
2486
###<select [A] from crash_me
2487
###> 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
2488
quote_ident_with_`=yes # ` as identifier quote
2490
###<select `A` from crash_me
2492
quote_ident_with_dbl_"=no # Double "" in identifiers as "
2493
###< create table crash_me1 ("abc""d" integer)
2494
###> 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 '"abc""d" integer)' at line 1
2495
###< drop table crash_me1
2496
###> execute error:Unknown table 'crash_me1'
2498
###As far as some queries didnt return OK, result is NO
2499
quote_with_"=yes # Allows ' and " as string markers
2500
###< select a from crash_me where b<"c"
2503
###As far as all queries returned OK, result is YES
2504
recursive_subqueries=+64 # recursive subqueries
2505
###We are trying (example with N=5):
2506
###select a from crash_me where a in (select a from crash_me where a in (select a from crash_me where a in (select a from c...(82)
2507
remember_end_space=no # Remembers end space in char()
2508
###< create table crash_q (a char(10))
2510
###< insert into crash_q values('hello ')
2513
###<select a from crash_q where a = 'hello '
2515
###We expected 'hello ' but got 'hello'
2517
###< drop table crash_q
2519
remember_end_space_varchar=no # Remembers end space in varchar()
2520
###< create table crash_q (a varchar(10))
2522
###< insert into crash_q values('hello ')
2525
###<select a from crash_q where a = 'hello '
2527
###We expected 'hello ' but got 'hello'
2529
###< drop table crash_q
2531
rename_table=yes # rename table
2532
###< create table crash_q (a integer, b integer,c1 CHAR(10))
2534
###< rename table crash_q to crash_q1
2536
###< drop table crash_q1
2539
###As far as all queries returned OK, result is YES
2540
repeat_string_size=1047552 # return string size from function
2541
###We are trying (example with N=5):
2542
###select repeat('a',5)
2543
### 4000000:FAIL 800000:OK 2400000:FAIL 1120000:FAIL 864000:OK 992000:OK 1056000:FAIL 1004800:OK 1030400:OK 1043200:OK 1049600:FAIL 1044480:OK 1047040:OK 1048320:FAIL 1047296:OK 1047808:FAIL 1047399:OK 1047603:FAIL 1047440:OK 1047521:OK 1047562:FAIL 1047529:OK 1047545:OK 1047553:FAIL 1047547:OK 1047550:OK 1047551:OK 1047552:OK
2544
reserved_word_ansi-92/99_absolute=no # Keyword ABSOLUTE
2545
###< create table crash_me10 (ABSOLUTE int not null)
2547
###< drop table crash_me10
2550
###As far as all queries returned OK, result is NO
2551
reserved_word_ansi-92/99_action=no # Keyword ACTION
2552
###< create table crash_me10 (ACTION int not null)
2554
###< drop table crash_me10
2557
###As far as all queries returned OK, result is NO
2558
reserved_word_ansi-92/99_add=yes # Keyword ADD
2559
###< create table crash_me10 (ADD int not null)
2560
###> 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 'ADD int not null)' at line 1
2561
###< drop table crash_me10
2562
###> execute error:Unknown table 'crash_me10'
2564
###As far as some queries didnt return OK, result is YES
2565
reserved_word_ansi-92/99_after=no # Keyword AFTER
2566
###< create table crash_me10 (AFTER int not null)
2568
###< drop table crash_me10
2571
###As far as all queries returned OK, result is NO
2572
reserved_word_ansi-92/99_alias=no # Keyword ALIAS
2573
###< create table crash_me10 (ALIAS int not null)
2575
###< drop table crash_me10
2578
###As far as all queries returned OK, result is NO
2579
reserved_word_ansi-92/99_all=yes # Keyword ALL
2580
###< create table crash_me10 (ALL int not null)
2581
###> 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 int not null)' at line 1
2582
###< drop table crash_me10
2583
###> execute error:Unknown table 'crash_me10'
2585
###As far as some queries didnt return OK, result is YES
2586
reserved_word_ansi-92/99_allocate=no # Keyword ALLOCATE
2587
###< create table crash_me10 (ALLOCATE int not null)
2589
###< drop table crash_me10
2592
###As far as all queries returned OK, result is NO
2593
reserved_word_ansi-92/99_alter=yes # Keyword ALTER
2594
###< create table crash_me10 (ALTER int not null)
2595
###> 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 'ALTER int not null)' at line 1
2596
###< drop table crash_me10
2597
###> execute error:Unknown table 'crash_me10'
2599
###As far as some queries didnt return OK, result is YES
2600
reserved_word_ansi-92/99_and=yes # Keyword AND
2601
###< create table crash_me10 (AND int not null)
2602
###> 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 'AND int not null)' at line 1
2603
###< drop table crash_me10
2604
###> execute error:Unknown table 'crash_me10'
2606
###As far as some queries didnt return OK, result is YES
2607
reserved_word_ansi-92/99_any=no # Keyword ANY
2608
###< create table crash_me10 (ANY int not null)
2610
###< drop table crash_me10
2613
###As far as all queries returned OK, result is NO
2614
reserved_word_ansi-92/99_are=no # Keyword ARE
2615
###< create table crash_me10 (ARE int not null)
2617
###< drop table crash_me10
2620
###As far as all queries returned OK, result is NO
2621
reserved_word_ansi-92/99_as=yes # Keyword AS
2622
###< create table crash_me10 (AS int not null)
2623
###> 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 'AS int not null)' at line 1
2624
###< drop table crash_me10
2625
###> execute error:Unknown table 'crash_me10'
2627
###As far as some queries didnt return OK, result is YES
2628
reserved_word_ansi-92/99_asc=yes # Keyword ASC
2629
###< create table crash_me10 (ASC int not null)
2630
###> 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 'ASC int not null)' at line 1
2631
###< drop table crash_me10
2632
###> execute error:Unknown table 'crash_me10'
2634
###As far as some queries didnt return OK, result is YES
2635
reserved_word_ansi-92/99_assertion=no # Keyword ASSERTION
2636
###< create table crash_me10 (ASSERTION int not null)
2638
###< drop table crash_me10
2641
###As far as all queries returned OK, result is NO
2642
reserved_word_ansi-92/99_at=no # Keyword AT
2643
###< create table crash_me10 (AT int not null)
2645
###< drop table crash_me10
2648
###As far as all queries returned OK, result is NO
2649
reserved_word_ansi-92/99_authorization=no # Keyword AUTHORIZATION
2650
###< create table crash_me10 (AUTHORIZATION int not null)
2652
###< drop table crash_me10
2655
###As far as all queries returned OK, result is NO
2656
reserved_word_ansi-92/99_before=yes # Keyword BEFORE
2657
###< create table crash_me10 (BEFORE int not null)
2658
###> 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 'BEFORE int not null)' at line 1
2659
###< drop table crash_me10
2660
###> execute error:Unknown table 'crash_me10'
2662
###As far as some queries didnt return OK, result is YES
2663
reserved_word_ansi-92/99_begin=no # Keyword BEGIN
2664
###< create table crash_me10 (BEGIN int not null)
2666
###< drop table crash_me10
2669
###As far as all queries returned OK, result is NO
2670
reserved_word_ansi-92/99_bit=no # Keyword BIT
2671
###< create table crash_me10 (BIT int not null)
2673
###< drop table crash_me10
2676
###As far as all queries returned OK, result is NO
2677
reserved_word_ansi-92/99_boolean=no # Keyword BOOLEAN
2678
###< create table crash_me10 (BOOLEAN int not null)
2680
###< drop table crash_me10
2683
###As far as all queries returned OK, result is NO
2684
reserved_word_ansi-92/99_both=yes # Keyword BOTH
2685
###< create table crash_me10 (BOTH int not null)
2686
###> 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 'BOTH int not null)' at line 1
2687
###< drop table crash_me10
2688
###> execute error:Unknown table 'crash_me10'
2690
###As far as some queries didnt return OK, result is YES
2691
reserved_word_ansi-92/99_breadth=no # Keyword BREADTH
2692
###< create table crash_me10 (BREADTH int not null)
2694
###< drop table crash_me10
2697
###As far as all queries returned OK, result is NO
2698
reserved_word_ansi-92/99_by=yes # Keyword BY
2699
###< create table crash_me10 (BY int not null)
2700
###> 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 'BY int not null)' at line 1
2701
###< drop table crash_me10
2702
###> execute error:Unknown table 'crash_me10'
2704
###As far as some queries didnt return OK, result is YES
2705
reserved_word_ansi-92/99_call=yes # Keyword CALL
2706
###< create table crash_me10 (CALL int not null)
2707
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CALL int not null)' at line 1
2708
###< drop table crash_me10
2709
###> execute error:Unknown table 'crash_me10'
2711
###As far as some queries didnt return OK, result is YES
2712
reserved_word_ansi-92/99_cascade=yes # Keyword CASCADE
2713
###< create table crash_me10 (CASCADE int not null)
2714
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CASCADE int not null)' at line 1
2715
###< drop table crash_me10
2716
###> execute error:Unknown table 'crash_me10'
2718
###As far as some queries didnt return OK, result is YES
2719
reserved_word_ansi-92/99_cascaded=no # Keyword CASCADED
2720
###< create table crash_me10 (CASCADED int not null)
2722
###< drop table crash_me10
2725
###As far as all queries returned OK, result is NO
2726
reserved_word_ansi-92/99_case=yes # Keyword CASE
2727
###< create table crash_me10 (CASE int not null)
2728
###> 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 'CASE int not null)' at line 1
2729
###< drop table crash_me10
2730
###> execute error:Unknown table 'crash_me10'
2732
###As far as some queries didnt return OK, result is YES
2733
reserved_word_ansi-92/99_cast=no # Keyword CAST
2734
###< create table crash_me10 (CAST int not null)
2736
###< drop table crash_me10
2739
###As far as all queries returned OK, result is NO
2740
reserved_word_ansi-92/99_catalog=no # Keyword CATALOG
2741
###< create table crash_me10 (CATALOG int not null)
2743
###< drop table crash_me10
2746
###As far as all queries returned OK, result is NO
2747
reserved_word_ansi-92/99_char=yes # Keyword CHAR
2748
###< create table crash_me10 (CHAR int not null)
2749
###> 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 'CHAR int not null)' at line 1
2750
###< drop table crash_me10
2751
###> execute error:Unknown table 'crash_me10'
2753
###As far as some queries didnt return OK, result is YES
2754
reserved_word_ansi-92/99_character=yes # Keyword CHARACTER
2755
###< create table crash_me10 (CHARACTER int not null)
2756
###> 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 'CHARACTER int not null)' at line 1
2757
###< drop table crash_me10
2758
###> execute error:Unknown table 'crash_me10'
2760
###As far as some queries didnt return OK, result is YES
2761
reserved_word_ansi-92/99_check=yes # Keyword CHECK
2762
###< create table crash_me10 (CHECK int not null)
2763
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int not null)' at line 1
2764
###< drop table crash_me10
2765
###> execute error:Unknown table 'crash_me10'
2767
###As far as some queries didnt return OK, result is YES
2768
reserved_word_ansi-92/99_close=no # Keyword CLOSE
2769
###< create table crash_me10 (CLOSE int not null)
2771
###< drop table crash_me10
2774
###As far as all queries returned OK, result is NO
2775
reserved_word_ansi-92/99_collate=yes # Keyword COLLATE
2776
###< create table crash_me10 (COLLATE int not null)
2777
###> 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 'COLLATE int not null)' at line 1
2778
###< drop table crash_me10
2779
###> execute error:Unknown table 'crash_me10'
2781
###As far as some queries didnt return OK, result is YES
2782
reserved_word_ansi-92/99_collation=no # Keyword COLLATION
2783
###< create table crash_me10 (COLLATION int not null)
2785
###< drop table crash_me10
2788
###As far as all queries returned OK, result is NO
2789
reserved_word_ansi-92/99_column=yes # Keyword COLUMN
2790
###< create table crash_me10 (COLUMN int not null)
2791
###> 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 'COLUMN int not null)' at line 1
2792
###< drop table crash_me10
2793
###> execute error:Unknown table 'crash_me10'
2795
###As far as some queries didnt return OK, result is YES
2796
reserved_word_ansi-92/99_commit=no # Keyword COMMIT
2797
###< create table crash_me10 (COMMIT int not null)
2799
###< drop table crash_me10
2802
###As far as all queries returned OK, result is NO
2803
reserved_word_ansi-92/99_completion=no # Keyword COMPLETION
2804
###< create table crash_me10 (COMPLETION int not null)
2806
###< drop table crash_me10
2809
###As far as all queries returned OK, result is NO
2810
reserved_word_ansi-92/99_connect=no # Keyword CONNECT
2811
###< create table crash_me10 (CONNECT int not null)
2813
###< drop table crash_me10
2816
###As far as all queries returned OK, result is NO
2817
reserved_word_ansi-92/99_connection=yes # Keyword CONNECTION
2818
###< create table crash_me10 (CONNECTION int not null)
2819
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONNECTION int not null)' at line 1
2820
###< drop table crash_me10
2821
###> execute error:Unknown table 'crash_me10'
2823
###As far as some queries didnt return OK, result is YES
2824
reserved_word_ansi-92/99_constraint=yes # Keyword CONSTRAINT
2825
###< create table crash_me10 (CONSTRAINT int not null)
2826
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int not null)' at line 1
2827
###< drop table crash_me10
2828
###> execute error:Unknown table 'crash_me10'
2830
###As far as some queries didnt return OK, result is YES
2831
reserved_word_ansi-92/99_constraints=no # Keyword CONSTRAINTS
2832
###< create table crash_me10 (CONSTRAINTS int not null)
2834
###< drop table crash_me10
2837
###As far as all queries returned OK, result is NO
2838
reserved_word_ansi-92/99_continue=yes # Keyword CONTINUE
2839
###< create table crash_me10 (CONTINUE int not null)
2840
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONTINUE int not null)' at line 1
2841
###< drop table crash_me10
2842
###> execute error:Unknown table 'crash_me10'
2844
###As far as some queries didnt return OK, result is YES
2845
reserved_word_ansi-92/99_corresponding=no # Keyword CORRESPONDING
2846
###< create table crash_me10 (CORRESPONDING int not null)
2848
###< drop table crash_me10
2851
###As far as all queries returned OK, result is NO
2852
reserved_word_ansi-92/99_create=yes # Keyword CREATE
2853
###< create table crash_me10 (CREATE int not null)
2854
###> 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 'CREATE int not null)' at line 1
2855
###< drop table crash_me10
2856
###> execute error:Unknown table 'crash_me10'
2858
###As far as some queries didnt return OK, result is YES
2859
reserved_word_ansi-92/99_cross=yes # Keyword CROSS
2860
###< create table crash_me10 (CROSS int not null)
2861
###> 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 'CROSS int not null)' at line 1
2862
###< drop table crash_me10
2863
###> execute error:Unknown table 'crash_me10'
2865
###As far as some queries didnt return OK, result is YES
2866
reserved_word_ansi-92/99_current=no # Keyword CURRENT
2867
###< create table crash_me10 (CURRENT int not null)
2869
###< drop table crash_me10
2872
###As far as all queries returned OK, result is NO
2873
reserved_word_ansi-92/99_current_date=yes # Keyword CURRENT_DATE
2874
###< create table crash_me10 (CURRENT_DATE int not null)
2875
###> 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 'CURRENT_DATE int not null)' at line 1
2876
###< drop table crash_me10
2877
###> execute error:Unknown table 'crash_me10'
2879
###As far as some queries didnt return OK, result is YES
2880
reserved_word_ansi-92/99_current_time=yes # Keyword CURRENT_TIME
2881
###< create table crash_me10 (CURRENT_TIME int not null)
2882
###> 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 'CURRENT_TIME int not null)' at line 1
2883
###< drop table crash_me10
2884
###> execute error:Unknown table 'crash_me10'
2886
###As far as some queries didnt return OK, result is YES
2887
reserved_word_ansi-92/99_current_timestamp=yes # Keyword CURRENT_TIMESTAMP
2888
###< create table crash_me10 (CURRENT_TIMESTAMP int not null)
2889
###> 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 'CURRENT_TIMESTAMP int not null)' at line 1
2890
###< drop table crash_me10
2891
###> execute error:Unknown table 'crash_me10'
2893
###As far as some queries didnt return OK, result is YES
2894
reserved_word_ansi-92/99_current_user=no # Keyword CURRENT_USER
2895
###< create table crash_me10 (CURRENT_USER int not null)
2897
###< drop table crash_me10
2900
###As far as all queries returned OK, result is NO
2901
reserved_word_ansi-92/99_cursor=yes # Keyword CURSOR
2902
###< create table crash_me10 (CURSOR int not null)
2903
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CURSOR int not null)' at line 1
2904
###< drop table crash_me10
2905
###> execute error:Unknown table 'crash_me10'
2907
###As far as some queries didnt return OK, result is YES
2908
reserved_word_ansi-92/99_cycle=no # Keyword CYCLE
2909
###< create table crash_me10 (CYCLE int not null)
2911
###< drop table crash_me10
2914
###As far as all queries returned OK, result is NO
2915
reserved_word_ansi-92/99_data=no # Keyword DATA
2916
###< create table crash_me10 (DATA int not null)
2918
###< drop table crash_me10
2921
###As far as all queries returned OK, result is NO
2922
reserved_word_ansi-92/99_date=no # Keyword DATE
2923
###< create table crash_me10 (DATE int not null)
2925
###< drop table crash_me10
2928
###As far as all queries returned OK, result is NO
2929
reserved_word_ansi-92/99_day=no # Keyword DAY
2930
###< create table crash_me10 (DAY int not null)
2932
###< drop table crash_me10
2935
###As far as all queries returned OK, result is NO
2936
reserved_word_ansi-92/99_deallocate=no # Keyword DEALLOCATE
2937
###< create table crash_me10 (DEALLOCATE int not null)
2939
###< drop table crash_me10
2942
###As far as all queries returned OK, result is NO
2943
reserved_word_ansi-92/99_dec=yes # Keyword DEC
2944
###< create table crash_me10 (DEC int not null)
2945
###> 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 'DEC int not null)' at line 1
2946
###< drop table crash_me10
2947
###> execute error:Unknown table 'crash_me10'
2949
###As far as some queries didnt return OK, result is YES
2950
reserved_word_ansi-92/99_decimal=yes # Keyword DECIMAL
2951
###< create table crash_me10 (DECIMAL int not null)
2952
###> 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 'DECIMAL int not null)' at line 1
2953
###< drop table crash_me10
2954
###> execute error:Unknown table 'crash_me10'
2956
###As far as some queries didnt return OK, result is YES
2957
reserved_word_ansi-92/99_declare=yes # Keyword DECLARE
2958
###< create table crash_me10 (DECLARE int not null)
2959
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DECLARE int not null)' at line 1
2960
###< drop table crash_me10
2961
###> execute error:Unknown table 'crash_me10'
2963
###As far as some queries didnt return OK, result is YES
2964
reserved_word_ansi-92/99_default=yes # Keyword DEFAULT
2965
###< create table crash_me10 (DEFAULT int not null)
2966
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT int not null)' at line 1
2967
###< drop table crash_me10
2968
###> execute error:Unknown table 'crash_me10'
2970
###As far as some queries didnt return OK, result is YES
2971
reserved_word_ansi-92/99_deferrable=no # Keyword DEFERRABLE
2972
###< create table crash_me10 (DEFERRABLE int not null)
2974
###< drop table crash_me10
2977
###As far as all queries returned OK, result is NO
2978
reserved_word_ansi-92/99_deferred=no # Keyword DEFERRED
2979
###< create table crash_me10 (DEFERRED int not null)
2981
###< drop table crash_me10
2984
###As far as all queries returned OK, result is NO
2985
reserved_word_ansi-92/99_delete=yes # Keyword DELETE
2986
###< create table crash_me10 (DELETE int not null)
2987
###> 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 'DELETE int not null)' at line 1
2988
###< drop table crash_me10
2989
###> execute error:Unknown table 'crash_me10'
2991
###As far as some queries didnt return OK, result is YES
2992
reserved_word_ansi-92/99_depth=no # Keyword DEPTH
2993
###< create table crash_me10 (DEPTH int not null)
2995
###< drop table crash_me10
2998
###As far as all queries returned OK, result is NO
2999
reserved_word_ansi-92/99_desc=yes # Keyword DESC
3000
###< create table crash_me10 (DESC int not null)
3001
###> 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 'DESC int not null)' at line 1
3002
###< drop table crash_me10
3003
###> execute error:Unknown table 'crash_me10'
3005
###As far as some queries didnt return OK, result is YES
3006
reserved_word_ansi-92/99_describe=yes # Keyword DESCRIBE
3007
###< create table crash_me10 (DESCRIBE int not null)
3008
###> 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 'DESCRIBE int not null)' at line 1
3009
###< drop table crash_me10
3010
###> execute error:Unknown table 'crash_me10'
3012
###As far as some queries didnt return OK, result is YES
3013
reserved_word_ansi-92/99_descriptor=no # Keyword DESCRIPTOR
3014
###< create table crash_me10 (DESCRIPTOR int not null)
3016
###< drop table crash_me10
3019
###As far as all queries returned OK, result is NO
3020
reserved_word_ansi-92/99_diagnostics=no # Keyword DIAGNOSTICS
3021
###< create table crash_me10 (DIAGNOSTICS int not null)
3023
###< drop table crash_me10
3026
###As far as all queries returned OK, result is NO
3027
reserved_word_ansi-92/99_dictionary=no # Keyword DICTIONARY
3028
###< create table crash_me10 (DICTIONARY int not null)
3030
###< drop table crash_me10
3033
###As far as all queries returned OK, result is NO
3034
reserved_word_ansi-92/99_disconnect=no # Keyword DISCONNECT
3035
###< create table crash_me10 (DISCONNECT int not null)
3037
###< drop table crash_me10
3040
###As far as all queries returned OK, result is NO
3041
reserved_word_ansi-92/99_distinct=yes # Keyword DISTINCT
3042
###< create table crash_me10 (DISTINCT int not null)
3043
###> 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 'DISTINCT int not null)' at line 1
3044
###< drop table crash_me10
3045
###> execute error:Unknown table 'crash_me10'
3047
###As far as some queries didnt return OK, result is YES
3048
reserved_word_ansi-92/99_domain=no # Keyword DOMAIN
3049
###< create table crash_me10 (DOMAIN int not null)
3051
###< drop table crash_me10
3054
###As far as all queries returned OK, result is NO
3055
reserved_word_ansi-92/99_double=yes # Keyword DOUBLE
3056
###< create table crash_me10 (DOUBLE int not null)
3057
###> 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 'DOUBLE int not null)' at line 1
3058
###< drop table crash_me10
3059
###> execute error:Unknown table 'crash_me10'
3061
###As far as some queries didnt return OK, result is YES
3062
reserved_word_ansi-92/99_drop=yes # Keyword DROP
3063
###< create table crash_me10 (DROP int not null)
3064
###> 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 'DROP int not null)' at line 1
3065
###< drop table crash_me10
3066
###> execute error:Unknown table 'crash_me10'
3068
###As far as some queries didnt return OK, result is YES
3069
reserved_word_ansi-92/99_each=no # Keyword EACH
3070
###< create table crash_me10 (EACH int not null)
3072
###< drop table crash_me10
3075
###As far as all queries returned OK, result is NO
3076
reserved_word_ansi-92/99_else=yes # Keyword ELSE
3077
###< create table crash_me10 (ELSE int not null)
3078
###> 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 'ELSE int not null)' at line 1
3079
###< drop table crash_me10
3080
###> execute error:Unknown table 'crash_me10'
3082
###As far as some queries didnt return OK, result is YES
3083
reserved_word_ansi-92/99_elseif=yes # Keyword ELSEIF
3084
###< create table crash_me10 (ELSEIF int not null)
3085
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ELSEIF int not null)' at line 1
3086
###< drop table crash_me10
3087
###> execute error:Unknown table 'crash_me10'
3089
###As far as some queries didnt return OK, result is YES
3090
reserved_word_ansi-92/99_end=no # Keyword END
3091
###< create table crash_me10 (END int not null)
3093
###< drop table crash_me10
3096
###As far as all queries returned OK, result is NO
3097
reserved_word_ansi-92/99_end-exec=yes # Keyword END-EXEC
3098
###< create table crash_me10 (END-EXEC int not null)
3099
###> 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 '-EXEC int not null)' at line 1
3100
###< drop table crash_me10
3101
###> execute error:Unknown table 'crash_me10'
3103
###As far as some queries didnt return OK, result is YES
3104
reserved_word_ansi-92/99_equals=no # Keyword EQUALS
3105
###< create table crash_me10 (EQUALS int not null)
3107
###< drop table crash_me10
3110
###As far as all queries returned OK, result is NO
3111
reserved_word_ansi-92/99_escape=no # Keyword ESCAPE
3112
###< create table crash_me10 (ESCAPE int not null)
3114
###< drop table crash_me10
3117
###As far as all queries returned OK, result is NO
3118
reserved_word_ansi-92/99_except=no # Keyword EXCEPT
3119
###< create table crash_me10 (EXCEPT int not null)
3121
###< drop table crash_me10
3124
###As far as all queries returned OK, result is NO
3125
reserved_word_ansi-92/99_exception=no # Keyword EXCEPTION
3126
###< create table crash_me10 (EXCEPTION int not null)
3128
###< drop table crash_me10
3131
###As far as all queries returned OK, result is NO
3132
reserved_word_ansi-92/99_exec=no # Keyword EXEC
3133
###< create table crash_me10 (EXEC int not null)
3135
###< drop table crash_me10
3138
###As far as all queries returned OK, result is NO
3139
reserved_word_ansi-92/99_execute=no # Keyword EXECUTE
3140
###< create table crash_me10 (EXECUTE int not null)
3142
###< drop table crash_me10
3145
###As far as all queries returned OK, result is NO
3146
reserved_word_ansi-92/99_external=no # Keyword EXTERNAL
3147
###< create table crash_me10 (EXTERNAL int not null)
3149
###< drop table crash_me10
3152
###As far as all queries returned OK, result is NO
3153
reserved_word_ansi-92/99_false=yes # Keyword FALSE
3154
###< create table crash_me10 (FALSE int not null)
3155
###> 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 'FALSE int not null)' at line 1
3156
###< drop table crash_me10
3157
###> execute error:Unknown table 'crash_me10'
3159
###As far as some queries didnt return OK, result is YES
3160
reserved_word_ansi-92/99_fetch=yes # Keyword FETCH
3161
###< create table crash_me10 (FETCH int not null)
3162
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FETCH int not null)' at line 1
3163
###< drop table crash_me10
3164
###> execute error:Unknown table 'crash_me10'
3166
###As far as some queries didnt return OK, result is YES
3167
reserved_word_ansi-92/99_first=no # Keyword FIRST
3168
###< create table crash_me10 (FIRST int not null)
3170
###< drop table crash_me10
3173
###As far as all queries returned OK, result is NO
3174
reserved_word_ansi-92/99_float=yes # Keyword FLOAT
3175
###< create table crash_me10 (FLOAT int not null)
3176
###> 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 'FLOAT int not null)' at line 1
3177
###< drop table crash_me10
3178
###> execute error:Unknown table 'crash_me10'
3180
###As far as some queries didnt return OK, result is YES
3181
reserved_word_ansi-92/99_for=yes # Keyword FOR
3182
###< create table crash_me10 (FOR int not null)
3183
###> 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 'FOR int not null)' at line 1
3184
###< drop table crash_me10
3185
###> execute error:Unknown table 'crash_me10'
3187
###As far as some queries didnt return OK, result is YES
3188
reserved_word_ansi-92/99_foreign=yes # Keyword FOREIGN
3189
###< create table crash_me10 (FOREIGN int not null)
3190
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int not null)' at line 1
3191
###< drop table crash_me10
3192
###> execute error:Unknown table 'crash_me10'
3194
###As far as some queries didnt return OK, result is YES
3195
reserved_word_ansi-92/99_found=yes # Keyword FOUND
3196
###< create table crash_me10 (FOUND int not null)
3197
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOUND int not null)' at line 1
3198
###< drop table crash_me10
3199
###> execute error:Unknown table 'crash_me10'
3201
###As far as some queries didnt return OK, result is YES
3202
reserved_word_ansi-92/99_from=yes # Keyword FROM
3203
###< create table crash_me10 (FROM int not null)
3204
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM int not null)' at line 1
3205
###< drop table crash_me10
3206
###> execute error:Unknown table 'crash_me10'
3208
###As far as some queries didnt return OK, result is YES
3209
reserved_word_ansi-92/99_full=no # Keyword FULL
3210
###< create table crash_me10 (FULL int not null)
3212
###< drop table crash_me10
3215
###As far as all queries returned OK, result is NO
3216
reserved_word_ansi-92/99_general=no # Keyword GENERAL
3217
###< create table crash_me10 (GENERAL int not null)
3219
###< drop table crash_me10
3222
###As far as all queries returned OK, result is NO
3223
reserved_word_ansi-92/99_get=no # Keyword GET
3224
###< create table crash_me10 (GET int not null)
3226
###< drop table crash_me10
3229
###As far as all queries returned OK, result is NO
3230
reserved_word_ansi-92/99_global=no # Keyword GLOBAL
3231
###< create table crash_me10 (GLOBAL int not null)
3233
###< drop table crash_me10
3236
###As far as all queries returned OK, result is NO
3237
reserved_word_ansi-92/99_go=no # Keyword GO
3238
###< create table crash_me10 (GO int not null)
3240
###< drop table crash_me10
3243
###As far as all queries returned OK, result is NO
3244
reserved_word_ansi-92/99_goto=no # Keyword GOTO
3245
###< create table crash_me10 (GOTO int not null)
3247
###< drop table crash_me10
3250
###As far as all queries returned OK, result is NO
3251
reserved_word_ansi-92/99_grant=yes # Keyword GRANT
3252
###< create table crash_me10 (GRANT int not null)
3253
###> 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 'GRANT int not null)' at line 1
3254
###< drop table crash_me10
3255
###> execute error:Unknown table 'crash_me10'
3257
###As far as some queries didnt return OK, result is YES
3258
reserved_word_ansi-92/99_group=yes # Keyword GROUP
3259
###< create table crash_me10 (GROUP int not null)
3260
###> 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 'GROUP int not null)' at line 1
3261
###< drop table crash_me10
3262
###> execute error:Unknown table 'crash_me10'
3264
###As far as some queries didnt return OK, result is YES
3265
reserved_word_ansi-92/99_having=yes # Keyword HAVING
3266
###< create table crash_me10 (HAVING int not null)
3267
###> 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 'HAVING int not null)' at line 1
3268
###< drop table crash_me10
3269
###> execute error:Unknown table 'crash_me10'
3271
###As far as some queries didnt return OK, result is YES
3272
reserved_word_ansi-92/99_hour=no # Keyword HOUR
3273
###< create table crash_me10 (HOUR int not null)
3275
###< drop table crash_me10
3278
###As far as all queries returned OK, result is NO
3279
reserved_word_ansi-92/99_identity=no # Keyword IDENTITY
3280
###< create table crash_me10 (IDENTITY int not null)
3282
###< drop table crash_me10
3285
###As far as all queries returned OK, result is NO
3286
reserved_word_ansi-92/99_if=yes # Keyword IF
3287
###< create table crash_me10 (IF int not null)
3288
###> 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 'IF int not null)' at line 1
3289
###< drop table crash_me10
3290
###> execute error:Unknown table 'crash_me10'
3292
###As far as some queries didnt return OK, result is YES
3293
reserved_word_ansi-92/99_ignore=yes # Keyword IGNORE
3294
###< create table crash_me10 (IGNORE int not null)
3295
###> 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 'IGNORE int not null)' at line 1
3296
###< drop table crash_me10
3297
###> execute error:Unknown table 'crash_me10'
3299
###As far as some queries didnt return OK, result is YES
3300
reserved_word_ansi-92/99_immediate=no # Keyword IMMEDIATE
3301
###< create table crash_me10 (IMMEDIATE int not null)
3303
###< drop table crash_me10
3306
###As far as all queries returned OK, result is NO
3307
reserved_word_ansi-92/99_in=yes # Keyword IN
3308
###< create table crash_me10 (IN int not null)
3309
###> 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 int not null)' at line 1
3310
###< drop table crash_me10
3311
###> execute error:Unknown table 'crash_me10'
3313
###As far as some queries didnt return OK, result is YES
3314
reserved_word_ansi-92/99_indicator=no # Keyword INDICATOR
3315
###< create table crash_me10 (INDICATOR int not null)
3317
###< drop table crash_me10
3320
###As far as all queries returned OK, result is NO
3321
reserved_word_ansi-92/99_initially=no # Keyword INITIALLY
3322
###< create table crash_me10 (INITIALLY int not null)
3324
###< drop table crash_me10
3327
###As far as all queries returned OK, result is NO
3328
reserved_word_ansi-92/99_inner=yes # Keyword INNER
3329
###< create table crash_me10 (INNER int not null)
3330
###> 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 'INNER int not null)' at line 1
3331
###< drop table crash_me10
3332
###> execute error:Unknown table 'crash_me10'
3334
###As far as some queries didnt return OK, result is YES
3335
reserved_word_ansi-92/99_input=no # Keyword INPUT
3336
###< create table crash_me10 (INPUT int not null)
3338
###< drop table crash_me10
3341
###As far as all queries returned OK, result is NO
3342
reserved_word_ansi-92/99_insert=yes # Keyword INSERT
3343
###< create table crash_me10 (INSERT int not null)
3344
###> 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 'INSERT int not null)' at line 1
3345
###< drop table crash_me10
3346
###> execute error:Unknown table 'crash_me10'
3348
###As far as some queries didnt return OK, result is YES
3349
reserved_word_ansi-92/99_int=yes # Keyword INT
3350
###< create table crash_me10 (INT int not null)
3351
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INT int not null)' at line 1
3352
###< drop table crash_me10
3353
###> execute error:Unknown table 'crash_me10'
3355
###As far as some queries didnt return OK, result is YES
3356
reserved_word_ansi-92/99_integer=yes # Keyword INTEGER
3357
###< create table crash_me10 (INTEGER int not null)
3358
###> 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 'INTEGER int not null)' at line 1
3359
###< drop table crash_me10
3360
###> execute error:Unknown table 'crash_me10'
3362
###As far as some queries didnt return OK, result is YES
3363
reserved_word_ansi-92/99_intersect=no # Keyword INTERSECT
3364
###< create table crash_me10 (INTERSECT int not null)
3366
###< drop table crash_me10
3369
###As far as all queries returned OK, result is NO
3370
reserved_word_ansi-92/99_interval=yes # Keyword INTERVAL
3371
###< create table crash_me10 (INTERVAL int not null)
3372
###> 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 int not null)' at line 1
3373
###< drop table crash_me10
3374
###> execute error:Unknown table 'crash_me10'
3376
###As far as some queries didnt return OK, result is YES
3377
reserved_word_ansi-92/99_into=yes # Keyword INTO
3378
###< create table crash_me10 (INTO int not null)
3379
###> 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 'INTO int not null)' at line 1
3380
###< drop table crash_me10
3381
###> execute error:Unknown table 'crash_me10'
3383
###As far as some queries didnt return OK, result is YES
3384
reserved_word_ansi-92/99_is=yes # Keyword IS
3385
###< create table crash_me10 (IS int not null)
3386
###> 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 'IS int not null)' at line 1
3387
###< drop table crash_me10
3388
###> execute error:Unknown table 'crash_me10'
3390
###As far as some queries didnt return OK, result is YES
3391
reserved_word_ansi-92/99_isolation=no # Keyword ISOLATION
3392
###< create table crash_me10 (ISOLATION int not null)
3394
###< drop table crash_me10
3397
###As far as all queries returned OK, result is NO
3398
reserved_word_ansi-92/99_join=yes # Keyword JOIN
3399
###< create table crash_me10 (JOIN int not null)
3400
###> 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 'JOIN int not null)' at line 1
3401
###< drop table crash_me10
3402
###> execute error:Unknown table 'crash_me10'
3404
###As far as some queries didnt return OK, result is YES
3405
reserved_word_ansi-92/99_key=yes # Keyword KEY
3406
###< create table crash_me10 (KEY int not null)
3407
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int not null)' at line 1
3408
###< drop table crash_me10
3409
###> execute error:Unknown table 'crash_me10'
3411
###As far as some queries didnt return OK, result is YES
3412
reserved_word_ansi-92/99_language=no # Keyword LANGUAGE
3413
###< create table crash_me10 (LANGUAGE int not null)
3415
###< drop table crash_me10
3418
###As far as all queries returned OK, result is NO
3419
reserved_word_ansi-92/99_last=no # Keyword LAST
3420
###< create table crash_me10 (LAST int not null)
3422
###< drop table crash_me10
3425
###As far as all queries returned OK, result is NO
3426
reserved_word_ansi-92/99_leading=yes # Keyword LEADING
3427
###< create table crash_me10 (LEADING int not null)
3428
###> 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 'LEADING int not null)' at line 1
3429
###< drop table crash_me10
3430
###> execute error:Unknown table 'crash_me10'
3432
###As far as some queries didnt return OK, result is YES
3433
reserved_word_ansi-92/99_leave=yes # Keyword LEAVE
3434
###< create table crash_me10 (LEAVE int not null)
3435
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEAVE int not null)' at line 1
3436
###< drop table crash_me10
3437
###> execute error:Unknown table 'crash_me10'
3439
###As far as some queries didnt return OK, result is YES
3440
reserved_word_ansi-92/99_left=yes # Keyword LEFT
3441
###< create table crash_me10 (LEFT int not null)
3442
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT int not null)' at line 1
3443
###< drop table crash_me10
3444
###> execute error:Unknown table 'crash_me10'
3446
###As far as some queries didnt return OK, result is YES
3447
reserved_word_ansi-92/99_less=no # Keyword LESS
3448
###< create table crash_me10 (LESS int not null)
3450
###< drop table crash_me10
3453
###As far as all queries returned OK, result is NO
3454
reserved_word_ansi-92/99_level=no # Keyword LEVEL
3455
###< create table crash_me10 (LEVEL int not null)
3457
###< drop table crash_me10
3460
###As far as all queries returned OK, result is NO
3461
reserved_word_ansi-92/99_like=yes # Keyword LIKE
3462
###< create table crash_me10 (LIKE int not null)
3463
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int not null)' at line 1
3464
###< drop table crash_me10
3465
###> execute error:Unknown table 'crash_me10'
3467
###As far as some queries didnt return OK, result is YES
3468
reserved_word_ansi-92/99_limit=yes # Keyword LIMIT
3469
###< create table crash_me10 (LIMIT int not null)
3470
###> 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 'LIMIT int not null)' at line 1
3471
###< drop table crash_me10
3472
###> execute error:Unknown table 'crash_me10'
3474
###As far as some queries didnt return OK, result is YES
3475
reserved_word_ansi-92/99_local=no # Keyword LOCAL
3476
###< create table crash_me10 (LOCAL int not null)
3478
###< drop table crash_me10
3481
###As far as all queries returned OK, result is NO
3482
reserved_word_ansi-92/99_loop=yes # Keyword LOOP
3483
###< create table crash_me10 (LOOP int not null)
3484
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOOP int not null)' at line 1
3485
###< drop table crash_me10
3486
###> execute error:Unknown table 'crash_me10'
3488
###As far as some queries didnt return OK, result is YES
3489
reserved_word_ansi-92/99_match=yes # Keyword MATCH
3490
###< create table crash_me10 (MATCH int not null)
3491
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'MATCH int not null)' at line 1
3492
###< drop table crash_me10
3493
###> execute error:Unknown table 'crash_me10'
3495
###As far as some queries didnt return OK, result is YES
3496
reserved_word_ansi-92/99_minute=no # Keyword MINUTE
3497
###< create table crash_me10 (MINUTE int not null)
3499
###< drop table crash_me10
3502
###As far as all queries returned OK, result is NO
3503
reserved_word_ansi-92/99_modify=no # Keyword MODIFY
3504
###< create table crash_me10 (MODIFY int not null)
3506
###< drop table crash_me10
3509
###As far as all queries returned OK, result is NO
3510
reserved_word_ansi-92/99_module=no # Keyword MODULE
3511
###< create table crash_me10 (MODULE int not null)
3513
###< drop table crash_me10
3516
###As far as all queries returned OK, result is NO
3517
reserved_word_ansi-92/99_month=no # Keyword MONTH
3518
###< create table crash_me10 (MONTH int not null)
3520
###< drop table crash_me10
3523
###As far as all queries returned OK, result is NO
3524
reserved_word_ansi-92/99_names=no # Keyword NAMES
3525
###< create table crash_me10 (NAMES int not null)
3527
###< drop table crash_me10
3530
###As far as all queries returned OK, result is NO
3531
reserved_word_ansi-92/99_national=no # Keyword NATIONAL
3532
###< create table crash_me10 (NATIONAL int not null)
3534
###< drop table crash_me10
3537
###As far as all queries returned OK, result is NO
3538
reserved_word_ansi-92/99_natural=yes # Keyword NATURAL
3539
###< create table crash_me10 (NATURAL int not null)
3540
###> 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 'NATURAL int not null)' at line 1
3541
###< drop table crash_me10
3542
###> execute error:Unknown table 'crash_me10'
3544
###As far as some queries didnt return OK, result is YES
3545
reserved_word_ansi-92/99_nchar=no # Keyword NCHAR
3546
###< create table crash_me10 (NCHAR int not null)
3548
###< drop table crash_me10
3551
###As far as all queries returned OK, result is NO
3552
reserved_word_ansi-92/99_new=no # Keyword NEW
3553
###< create table crash_me10 (NEW int not null)
3555
###< drop table crash_me10
3558
###As far as all queries returned OK, result is NO
3559
reserved_word_ansi-92/99_next=no # Keyword NEXT
3560
###< create table crash_me10 (NEXT int not null)
3562
###< drop table crash_me10
3565
###As far as all queries returned OK, result is NO
3566
reserved_word_ansi-92/99_no=no # Keyword NO
3567
###< create table crash_me10 (NO int not null)
3569
###< drop table crash_me10
3572
###As far as all queries returned OK, result is NO
3573
reserved_word_ansi-92/99_none=no # Keyword NONE
3574
###< create table crash_me10 (NONE int not null)
3576
###< drop table crash_me10
3579
###As far as all queries returned OK, result is NO
3580
reserved_word_ansi-92/99_not=yes # Keyword NOT
3581
###< create table crash_me10 (NOT int not null)
3582
###> 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 'NOT int not null)' at line 1
3583
###< drop table crash_me10
3584
###> execute error:Unknown table 'crash_me10'
3586
###As far as some queries didnt return OK, result is YES
3587
reserved_word_ansi-92/99_null=yes # Keyword NULL
3588
###< create table crash_me10 (NULL int not null)
3589
###> 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 'NULL int not null)' at line 1
3590
###< drop table crash_me10
3591
###> execute error:Unknown table 'crash_me10'
3593
###As far as some queries didnt return OK, result is YES
3594
reserved_word_ansi-92/99_numeric=yes # Keyword NUMERIC
3595
###< create table crash_me10 (NUMERIC int not null)
3596
###> 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 'NUMERIC int not null)' at line 1
3597
###< drop table crash_me10
3598
###> execute error:Unknown table 'crash_me10'
3600
###As far as some queries didnt return OK, result is YES
3601
reserved_word_ansi-92/99_object=no # Keyword OBJECT
3602
###< create table crash_me10 (OBJECT int not null)
3604
###< drop table crash_me10
3607
###As far as all queries returned OK, result is NO
3608
reserved_word_ansi-92/99_of=no # Keyword OF
3609
###< create table crash_me10 (OF int not null)
3611
###< drop table crash_me10
3614
###As far as all queries returned OK, result is NO
3615
reserved_word_ansi-92/99_off=no # Keyword OFF
3616
###< create table crash_me10 (OFF int not null)
3618
###< drop table crash_me10
3621
###As far as all queries returned OK, result is NO
3622
reserved_word_ansi-92/99_old=no # Keyword OLD
3623
###< create table crash_me10 (OLD int not null)
3625
###< drop table crash_me10
3628
###As far as all queries returned OK, result is NO
3629
reserved_word_ansi-92/99_on=yes # Keyword ON
3630
###< create table crash_me10 (ON int not null)
3631
###> 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 'ON int not null)' at line 1
3632
###< drop table crash_me10
3633
###> execute error:Unknown table 'crash_me10'
3635
###As far as some queries didnt return OK, result is YES
3636
reserved_word_ansi-92/99_only=no # Keyword ONLY
3637
###< create table crash_me10 (ONLY int not null)
3639
###< drop table crash_me10
3642
###As far as all queries returned OK, result is NO
3643
reserved_word_ansi-92/99_open=no # Keyword OPEN
3644
###< create table crash_me10 (OPEN int not null)
3646
###< drop table crash_me10
3649
###As far as all queries returned OK, result is NO
3650
reserved_word_ansi-92/99_operation=no # Keyword OPERATION
3651
###< create table crash_me10 (OPERATION int not null)
3653
###< drop table crash_me10
3656
###As far as all queries returned OK, result is NO
3657
reserved_word_ansi-92/99_option=yes # Keyword OPTION
3658
###< create table crash_me10 (OPTION int not null)
3659
###> 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 'OPTION int not null)' at line 1
3660
###< drop table crash_me10
3661
###> execute error:Unknown table 'crash_me10'
3663
###As far as some queries didnt return OK, result is YES
3664
reserved_word_ansi-92/99_or=yes # Keyword OR
3665
###< create table crash_me10 (OR int not null)
3666
###> 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 'OR int not null)' at line 1
3667
###< drop table crash_me10
3668
###> execute error:Unknown table 'crash_me10'
3670
###As far as some queries didnt return OK, result is YES
3671
reserved_word_ansi-92/99_order=yes # Keyword ORDER
3672
###< create table crash_me10 (ORDER int not null)
3673
###> 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 'ORDER int not null)' at line 1
3674
###< drop table crash_me10
3675
###> execute error:Unknown table 'crash_me10'
3677
###As far as some queries didnt return OK, result is YES
3678
reserved_word_ansi-92/99_outer=yes # Keyword OUTER
3679
###< create table crash_me10 (OUTER int not null)
3680
###> 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 'OUTER int not null)' at line 1
3681
###< drop table crash_me10
3682
###> execute error:Unknown table 'crash_me10'
3684
###As far as some queries didnt return OK, result is YES
3685
reserved_word_ansi-92/99_output=no # Keyword OUTPUT
3686
###< create table crash_me10 (OUTPUT int not null)
3688
###< drop table crash_me10
3691
###As far as all queries returned OK, result is NO
3692
reserved_word_ansi-92/99_pad=no # Keyword PAD
3693
###< create table crash_me10 (PAD int not null)
3695
###< drop table crash_me10
3698
###As far as all queries returned OK, result is NO
3699
reserved_word_ansi-92/99_parameters=no # Keyword PARAMETERS
3700
###< create table crash_me10 (PARAMETERS int not null)
3702
###< drop table crash_me10
3705
###As far as all queries returned OK, result is NO
3706
reserved_word_ansi-92/99_partial=no # Keyword PARTIAL
3707
###< create table crash_me10 (PARTIAL int not null)
3709
###< drop table crash_me10
3712
###As far as all queries returned OK, result is NO
3713
reserved_word_ansi-92/99_precision=yes # Keyword PRECISION
3714
###< create table crash_me10 (PRECISION int not null)
3715
###> 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 'PRECISION int not null)' at line 1
3716
###< drop table crash_me10
3717
###> execute error:Unknown table 'crash_me10'
3719
###As far as some queries didnt return OK, result is YES
3720
reserved_word_ansi-92/99_preorder=no # Keyword PREORDER
3721
###< create table crash_me10 (PREORDER int not null)
3723
###< drop table crash_me10
3726
###As far as all queries returned OK, result is NO
3727
reserved_word_ansi-92/99_prepare=no # Keyword PREPARE
3728
###< create table crash_me10 (PREPARE int not null)
3730
###< drop table crash_me10
3733
###As far as all queries returned OK, result is NO
3734
reserved_word_ansi-92/99_preserve=no # Keyword PRESERVE
3735
###< create table crash_me10 (PRESERVE int not null)
3737
###< drop table crash_me10
3740
###As far as all queries returned OK, result is NO
3741
reserved_word_ansi-92/99_primary=yes # Keyword PRIMARY
3742
###< create table crash_me10 (PRIMARY int not null)
3743
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int not null)' at line 1
3744
###< drop table crash_me10
3745
###> execute error:Unknown table 'crash_me10'
3747
###As far as some queries didnt return OK, result is YES
3748
reserved_word_ansi-92/99_prior=no # Keyword PRIOR
3749
###< create table crash_me10 (PRIOR int not null)
3751
###< drop table crash_me10
3754
###As far as all queries returned OK, result is NO
3755
reserved_word_ansi-92/99_privileges=yes # Keyword PRIVILEGES
3756
###< create table crash_me10 (PRIVILEGES int not null)
3757
###> 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 'PRIVILEGES int not null)' at line 1
3758
###< drop table crash_me10
3759
###> execute error:Unknown table 'crash_me10'
3761
###As far as some queries didnt return OK, result is YES
3762
reserved_word_ansi-92/99_procedure=yes # Keyword PROCEDURE
3763
###< create table crash_me10 (PROCEDURE int not null)
3764
###> 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 int not null)' at line 1
3765
###< drop table crash_me10
3766
###> execute error:Unknown table 'crash_me10'
3768
###As far as some queries didnt return OK, result is YES
3769
reserved_word_ansi-92/99_public=no # Keyword PUBLIC
3770
###< create table crash_me10 (PUBLIC int not null)
3772
###< drop table crash_me10
3775
###As far as all queries returned OK, result is NO
3776
reserved_word_ansi-92/99_read=yes # Keyword READ
3777
###< create table crash_me10 (READ int not null)
3778
###> 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 'READ int not null)' at line 1
3779
###< drop table crash_me10
3780
###> execute error:Unknown table 'crash_me10'
3782
###As far as some queries didnt return OK, result is YES
3783
reserved_word_ansi-92/99_real=yes # Keyword REAL
3784
###< create table crash_me10 (REAL int not null)
3785
###> 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 'REAL int not null)' at line 1
3786
###< drop table crash_me10
3787
###> execute error:Unknown table 'crash_me10'
3789
###As far as some queries didnt return OK, result is YES
3790
reserved_word_ansi-92/99_recursive=no # Keyword RECURSIVE
3791
###< create table crash_me10 (RECURSIVE int not null)
3793
###< drop table crash_me10
3796
###As far as all queries returned OK, result is NO
3797
reserved_word_ansi-92/99_ref=no # Keyword REF
3798
###< create table crash_me10 (REF int not null)
3800
###< drop table crash_me10
3803
###As far as all queries returned OK, result is NO
3804
reserved_word_ansi-92/99_references=yes # Keyword REFERENCES
3805
###< create table crash_me10 (REFERENCES int not null)
3806
###> 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 int not null)' at line 1
3807
###< drop table crash_me10
3808
###> execute error:Unknown table 'crash_me10'
3810
###As far as some queries didnt return OK, result is YES
3811
reserved_word_ansi-92/99_referencing=no # Keyword REFERENCING
3812
###< create table crash_me10 (REFERENCING int not null)
3814
###< drop table crash_me10
3817
###As far as all queries returned OK, result is NO
3818
reserved_word_ansi-92/99_relative=no # Keyword RELATIVE
3819
###< create table crash_me10 (RELATIVE int not null)
3821
###< drop table crash_me10
3824
###As far as all queries returned OK, result is NO
3825
reserved_word_ansi-92/99_resignal=no # Keyword RESIGNAL
3826
###< create table crash_me10 (RESIGNAL int not null)
3828
###< drop table crash_me10
3831
###As far as all queries returned OK, result is NO
3832
reserved_word_ansi-92/99_restrict=yes # Keyword RESTRICT
3833
###< create table crash_me10 (RESTRICT int not null)
3834
###> 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 'RESTRICT int not null)' at line 1
3835
###< drop table crash_me10
3836
###> execute error:Unknown table 'crash_me10'
3838
###As far as some queries didnt return OK, result is YES
3839
reserved_word_ansi-92/99_return=yes # Keyword RETURN
3840
###< create table crash_me10 (RETURN int not null)
3841
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'RETURN int not null)' at line 1
3842
###< drop table crash_me10
3843
###> execute error:Unknown table 'crash_me10'
3845
###As far as some queries didnt return OK, result is YES
3846
reserved_word_ansi-92/99_returns=no # Keyword RETURNS
3847
###< create table crash_me10 (RETURNS int not null)
3849
###< drop table crash_me10
3852
###As far as all queries returned OK, result is NO
3853
reserved_word_ansi-92/99_revoke=yes # Keyword REVOKE
3854
###< create table crash_me10 (REVOKE int not null)
3855
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'REVOKE int not null)' at line 1
3856
###< drop table crash_me10
3857
###> execute error:Unknown table 'crash_me10'
3859
###As far as some queries didnt return OK, result is YES
3860
reserved_word_ansi-92/99_right=yes # Keyword RIGHT
3861
###< create table crash_me10 (RIGHT int not null)
3862
###> 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 'RIGHT int not null)' at line 1
3863
###< drop table crash_me10
3864
###> execute error:Unknown table 'crash_me10'
3866
###As far as some queries didnt return OK, result is YES
3867
reserved_word_ansi-92/99_role=no # Keyword ROLE
3868
###< create table crash_me10 (ROLE int not null)
3870
###< drop table crash_me10
3873
###As far as all queries returned OK, result is NO
3874
reserved_word_ansi-92/99_rollback=no # Keyword ROLLBACK
3875
###< create table crash_me10 (ROLLBACK int not null)
3877
###< drop table crash_me10
3880
###As far as all queries returned OK, result is NO
3881
reserved_word_ansi-92/99_routine=no # Keyword ROUTINE
3882
###< create table crash_me10 (ROUTINE int not null)
3884
###< drop table crash_me10
3887
###As far as all queries returned OK, result is NO
3888
reserved_word_ansi-92/99_row=no # Keyword ROW
3889
###< create table crash_me10 (ROW int not null)
3891
###< drop table crash_me10
3894
###As far as all queries returned OK, result is NO
3895
reserved_word_ansi-92/99_rows=no # Keyword ROWS
3896
###< create table crash_me10 (ROWS int not null)
3898
###< drop table crash_me10
3901
###As far as all queries returned OK, result is NO
3902
reserved_word_ansi-92/99_savepoint=no # Keyword SAVEPOINT
3903
###< create table crash_me10 (SAVEPOINT int not null)
3905
###< drop table crash_me10
3908
###As far as all queries returned OK, result is NO
3909
reserved_word_ansi-92/99_schema=no # Keyword SCHEMA
3910
###< create table crash_me10 (SCHEMA int not null)
3912
###< drop table crash_me10
3915
###As far as all queries returned OK, result is NO
3916
reserved_word_ansi-92/99_scroll=no # Keyword SCROLL
3917
###< create table crash_me10 (SCROLL int not null)
3919
###< drop table crash_me10
3922
###As far as all queries returned OK, result is NO
3923
reserved_word_ansi-92/99_search=no # Keyword SEARCH
3924
###< create table crash_me10 (SEARCH int not null)
3926
###< drop table crash_me10
3929
###As far as all queries returned OK, result is NO
3930
reserved_word_ansi-92/99_second=no # Keyword SECOND
3931
###< create table crash_me10 (SECOND int not null)
3933
###< drop table crash_me10
3936
###As far as all queries returned OK, result is NO
3937
reserved_word_ansi-92/99_section=no # Keyword SECTION
3938
###< create table crash_me10 (SECTION int not null)
3940
###< drop table crash_me10
3943
###As far as all queries returned OK, result is NO
3944
reserved_word_ansi-92/99_select=yes # Keyword SELECT
3945
###< create table crash_me10 (SELECT int not null)
3946
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int not null)' at line 1
3947
###< drop table crash_me10
3948
###> execute error:Unknown table 'crash_me10'
3950
###As far as some queries didnt return OK, result is YES
3951
reserved_word_ansi-92/99_sequence=no # Keyword SEQUENCE
3952
###< create table crash_me10 (SEQUENCE int not null)
3954
###< drop table crash_me10
3957
###As far as all queries returned OK, result is NO
3958
reserved_word_ansi-92/99_session=no # Keyword SESSION
3959
###< create table crash_me10 (SESSION int not null)
3961
###< drop table crash_me10
3964
###As far as all queries returned OK, result is NO
3965
reserved_word_ansi-92/99_session_user=no # Keyword SESSION_USER
3966
###< create table crash_me10 (SESSION_USER int not null)
3968
###< drop table crash_me10
3971
###As far as all queries returned OK, result is NO
3972
reserved_word_ansi-92/99_set=yes # Keyword SET
3973
###< create table crash_me10 (SET int not null)
3974
###> 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 'SET int not null)' at line 1
3975
###< drop table crash_me10
3976
###> execute error:Unknown table 'crash_me10'
3978
###As far as some queries didnt return OK, result is YES
3979
reserved_word_ansi-92/99_signal=no # Keyword SIGNAL
3980
###< create table crash_me10 (SIGNAL int not null)
3982
###< drop table crash_me10
3985
###As far as all queries returned OK, result is NO
3986
reserved_word_ansi-92/99_size=no # Keyword SIZE
3987
###< create table crash_me10 (SIZE int not null)
3989
###< drop table crash_me10
3992
###As far as all queries returned OK, result is NO
3993
reserved_word_ansi-92/99_smallint=yes # Keyword SMALLINT
3994
###< create table crash_me10 (SMALLINT int not null)
3995
###> 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 'SMALLINT int not null)' at line 1
3996
###< drop table crash_me10
3997
###> execute error:Unknown table 'crash_me10'
3999
###As far as some queries didnt return OK, result is YES
4000
reserved_word_ansi-92/99_some=no # Keyword SOME
4001
###< create table crash_me10 (SOME int not null)
4003
###< drop table crash_me10
4006
###As far as all queries returned OK, result is NO
4007
reserved_word_ansi-92/99_space=no # Keyword SPACE
4008
###< create table crash_me10 (SPACE int not null)
4010
###< drop table crash_me10
4013
###As far as all queries returned OK, result is NO
4014
reserved_word_ansi-92/99_sql=yes # Keyword SQL
4015
###< create table crash_me10 (SQL int not null)
4016
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL int not null)' at line 1
4017
###< drop table crash_me10
4018
###> execute error:Unknown table 'crash_me10'
4020
###As far as some queries didnt return OK, result is YES
4021
reserved_word_ansi-92/99_sqlexception=yes # Keyword SQLEXCEPTION
4022
###< create table crash_me10 (SQLEXCEPTION int not null)
4023
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLEXCEPTION int not null)' at line 1
4024
###< drop table crash_me10
4025
###> execute error:Unknown table 'crash_me10'
4027
###As far as some queries didnt return OK, result is YES
4028
reserved_word_ansi-92/99_sqlstate=yes # Keyword SQLSTATE
4029
###< create table crash_me10 (SQLSTATE int not null)
4030
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLSTATE int not null)' at line 1
4031
###< drop table crash_me10
4032
###> execute error:Unknown table 'crash_me10'
4034
###As far as some queries didnt return OK, result is YES
4035
reserved_word_ansi-92/99_sqlwarning=yes # Keyword SQLWARNING
4036
###< create table crash_me10 (SQLWARNING int not null)
4037
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLWARNING int not null)' at line 1
4038
###< drop table crash_me10
4039
###> execute error:Unknown table 'crash_me10'
4041
###As far as some queries didnt return OK, result is YES
4042
reserved_word_ansi-92/99_structure=no # Keyword STRUCTURE
4043
###< create table crash_me10 (STRUCTURE int not null)
4045
###< drop table crash_me10
4048
###As far as all queries returned OK, result is NO
4049
reserved_word_ansi-92/99_system_user=no # Keyword SYSTEM_USER
4050
###< create table crash_me10 (SYSTEM_USER int not null)
4052
###< drop table crash_me10
4055
###As far as all queries returned OK, result is NO
4056
reserved_word_ansi-92/99_table=yes # Keyword TABLE
4057
###< create table crash_me10 (TABLE int not null)
4058
###> 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 'TABLE int not null)' at line 1
4059
###< drop table crash_me10
4060
###> execute error:Unknown table 'crash_me10'
4062
###As far as some queries didnt return OK, result is YES
4063
reserved_word_ansi-92/99_temporary=no # Keyword TEMPORARY
4064
###< create table crash_me10 (TEMPORARY int not null)
4066
###< drop table crash_me10
4069
###As far as all queries returned OK, result is NO
4070
reserved_word_ansi-92/99_then=yes # Keyword THEN
4071
###< create table crash_me10 (THEN int not null)
4072
###> 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 'THEN int not null)' at line 1
4073
###< drop table crash_me10
4074
###> execute error:Unknown table 'crash_me10'
4076
###As far as some queries didnt return OK, result is YES
4077
reserved_word_ansi-92/99_time=no # Keyword TIME
4078
###< create table crash_me10 (TIME int not null)
4080
###< drop table crash_me10
4083
###As far as all queries returned OK, result is NO
4084
reserved_word_ansi-92/99_timestamp=no # Keyword TIMESTAMP
4085
###< create table crash_me10 (TIMESTAMP int not null)
4087
###< drop table crash_me10
4090
###As far as all queries returned OK, result is NO
4091
reserved_word_ansi-92/99_timezone_hour=no # Keyword TIMEZONE_HOUR
4092
###< create table crash_me10 (TIMEZONE_HOUR int not null)
4094
###< drop table crash_me10
4097
###As far as all queries returned OK, result is NO
4098
reserved_word_ansi-92/99_timezone_minute=no # Keyword TIMEZONE_MINUTE
4099
###< create table crash_me10 (TIMEZONE_MINUTE int not null)
4101
###< drop table crash_me10
4104
###As far as all queries returned OK, result is NO
4105
reserved_word_ansi-92/99_to=yes # Keyword TO
4106
###< create table crash_me10 (TO int not null)
4107
###> 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 'TO int not null)' at line 1
4108
###< drop table crash_me10
4109
###> execute error:Unknown table 'crash_me10'
4111
###As far as some queries didnt return OK, result is YES
4112
reserved_word_ansi-92/99_trailing=yes # Keyword TRAILING
4113
###< create table crash_me10 (TRAILING int not null)
4114
###> 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 'TRAILING int not null)' at line 1
4115
###< drop table crash_me10
4116
###> execute error:Unknown table 'crash_me10'
4118
###As far as some queries didnt return OK, result is YES
4119
reserved_word_ansi-92/99_transaction=no # Keyword TRANSACTION
4120
###< create table crash_me10 (TRANSACTION int not null)
4122
###< drop table crash_me10
4125
###As far as all queries returned OK, result is NO
4126
reserved_word_ansi-92/99_translation=no # Keyword TRANSLATION
4127
###< create table crash_me10 (TRANSLATION int not null)
4129
###< drop table crash_me10
4132
###As far as all queries returned OK, result is NO
4133
reserved_word_ansi-92/99_trigger=no # Keyword TRIGGER
4134
###< create table crash_me10 (TRIGGER int not null)
4136
###< drop table crash_me10
4139
###As far as all queries returned OK, result is NO
4140
reserved_word_ansi-92/99_true=yes # Keyword TRUE
4141
###< create table crash_me10 (TRUE int not null)
4142
###> 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 'TRUE int not null)' at line 1
4143
###< drop table crash_me10
4144
###> execute error:Unknown table 'crash_me10'
4146
###As far as some queries didnt return OK, result is YES
4147
reserved_word_ansi-92/99_under=no # Keyword UNDER
4148
###< create table crash_me10 (UNDER int not null)
4150
###< drop table crash_me10
4153
###As far as all queries returned OK, result is NO
4154
reserved_word_ansi-92/99_union=yes # Keyword UNION
4155
###< create table crash_me10 (UNION int not null)
4156
###> 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 'UNION int not null)' at line 1
4157
###< drop table crash_me10
4158
###> execute error:Unknown table 'crash_me10'
4160
###As far as some queries didnt return OK, result is YES
4161
reserved_word_ansi-92/99_unique=yes # Keyword UNIQUE
4162
###< create table crash_me10 (UNIQUE int not null)
4163
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int not null)' at line 1
4164
###< drop table crash_me10
4165
###> execute error:Unknown table 'crash_me10'
4167
###As far as some queries didnt return OK, result is YES
4168
reserved_word_ansi-92/99_unknown=no # Keyword UNKNOWN
4169
###< create table crash_me10 (UNKNOWN int not null)
4171
###< drop table crash_me10
4174
###As far as all queries returned OK, result is NO
4175
reserved_word_ansi-92/99_update=yes # Keyword UPDATE
4176
###< create table crash_me10 (UPDATE int not null)
4177
###> 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 'UPDATE int not null)' at line 1
4178
###< drop table crash_me10
4179
###> execute error:Unknown table 'crash_me10'
4181
###As far as some queries didnt return OK, result is YES
4182
reserved_word_ansi-92/99_usage=yes # Keyword USAGE
4183
###< create table crash_me10 (USAGE int not null)
4184
###> 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 'USAGE int not null)' at line 1
4185
###< drop table crash_me10
4186
###> execute error:Unknown table 'crash_me10'
4188
###As far as some queries didnt return OK, result is YES
4189
reserved_word_ansi-92/99_user=no # Keyword USER
4190
###< create table crash_me10 (USER int not null)
4192
###< drop table crash_me10
4195
###As far as all queries returned OK, result is NO
4196
reserved_word_ansi-92/99_using=yes # Keyword USING
4197
###< create table crash_me10 (USING int not null)
4198
###> 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 'USING int not null)' at line 1
4199
###< drop table crash_me10
4200
###> execute error:Unknown table 'crash_me10'
4202
###As far as some queries didnt return OK, result is YES
4203
reserved_word_ansi-92/99_value=no # Keyword VALUE
4204
###< create table crash_me10 (VALUE int not null)
4206
###< drop table crash_me10
4209
###As far as all queries returned OK, result is NO
4210
reserved_word_ansi-92/99_values=yes # Keyword VALUES
4211
###< create table crash_me10 (VALUES int not null)
4212
###> 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 'VALUES int not null)' at line 1
4213
###< drop table crash_me10
4214
###> execute error:Unknown table 'crash_me10'
4216
###As far as some queries didnt return OK, result is YES
4217
reserved_word_ansi-92/99_varchar=yes # Keyword VARCHAR
4218
###< create table crash_me10 (VARCHAR int not null)
4219
###> 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 'VARCHAR int not null)' at line 1
4220
###< drop table crash_me10
4221
###> execute error:Unknown table 'crash_me10'
4223
###As far as some queries didnt return OK, result is YES
4224
reserved_word_ansi-92/99_variable=no # Keyword VARIABLE
4225
###< create table crash_me10 (VARIABLE int not null)
4227
###< drop table crash_me10
4230
###As far as all queries returned OK, result is NO
4231
reserved_word_ansi-92/99_varying=yes # Keyword VARYING
4232
###< create table crash_me10 (VARYING int not null)
4233
###> 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 int not null)' at line 1
4234
###< drop table crash_me10
4235
###> execute error:Unknown table 'crash_me10'
4237
###As far as some queries didnt return OK, result is YES
4238
reserved_word_ansi-92/99_view=no # Keyword VIEW
4239
###< create table crash_me10 (VIEW int not null)
4241
###< drop table crash_me10
4244
###As far as all queries returned OK, result is NO
4245
reserved_word_ansi-92/99_when=yes # Keyword WHEN
4246
###< create table crash_me10 (WHEN int not null)
4247
###> 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 'WHEN int not null)' at line 1
4248
###< drop table crash_me10
4249
###> execute error:Unknown table 'crash_me10'
4251
###As far as some queries didnt return OK, result is YES
4252
reserved_word_ansi-92/99_whenever=no # Keyword WHENEVER
4253
###< create table crash_me10 (WHENEVER int not null)
4255
###< drop table crash_me10
4258
###As far as all queries returned OK, result is NO
4259
reserved_word_ansi-92/99_where=yes # Keyword WHERE
4260
###< create table crash_me10 (WHERE int not null)
4261
###> 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 'WHERE int not null)' at line 1
4262
###< drop table crash_me10
4263
###> execute error:Unknown table 'crash_me10'
4265
###As far as some queries didnt return OK, result is YES
4266
reserved_word_ansi-92/99_while=yes # Keyword WHILE
4267
###< create table crash_me10 (WHILE int not null)
4268
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHILE int not null)' at line 1
4269
###< drop table crash_me10
4270
###> execute error:Unknown table 'crash_me10'
4272
###As far as some queries didnt return OK, result is YES
4273
reserved_word_ansi-92/99_with=yes # Keyword WITH
4274
###< create table crash_me10 (WITH int not null)
4275
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WITH int not null)' at line 1
4276
###< drop table crash_me10
4277
###> execute error:Unknown table 'crash_me10'
4279
###As far as some queries didnt return OK, result is YES
4280
reserved_word_ansi-92/99_without=no # Keyword WITHOUT
4281
###< create table crash_me10 (WITHOUT int not null)
4283
###< drop table crash_me10
4286
###As far as all queries returned OK, result is NO
4287
reserved_word_ansi-92/99_work=no # Keyword WORK
4288
###< create table crash_me10 (WORK int not null)
4290
###< drop table crash_me10
4293
###As far as all queries returned OK, result is NO
4294
reserved_word_ansi-92/99_write=yes # Keyword WRITE
4295
###< create table crash_me10 (WRITE int not null)
4296
###> 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 'WRITE int not null)' at line 1
4297
###< drop table crash_me10
4298
###> execute error:Unknown table 'crash_me10'
4300
###As far as some queries didnt return OK, result is YES
4301
reserved_word_ansi-92/99_year=no # Keyword YEAR
4302
###< create table crash_me10 (YEAR int not null)
4304
###< drop table crash_me10
4307
###As far as all queries returned OK, result is NO
4308
reserved_word_ansi-92/99_zone=no # Keyword ZONE
4309
###< create table crash_me10 (ZONE int not null)
4311
###< drop table crash_me10
4314
###As far as all queries returned OK, result is NO
4315
reserved_word_ansi92_async=no # Keyword ASYNC
4316
###< create table crash_me10 (ASYNC int not null)
4318
###< drop table crash_me10
4321
###As far as all queries returned OK, result is NO
4322
reserved_word_ansi92_avg=no # Keyword AVG
4323
###< create table crash_me10 (AVG int not null)
4325
###< drop table crash_me10
4328
###As far as all queries returned OK, result is NO
4329
reserved_word_ansi92_between=yes # Keyword BETWEEN
4330
###< create table crash_me10 (BETWEEN int not null)
4331
###> 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 'BETWEEN int not null)' at line 1
4332
###< drop table crash_me10
4333
###> execute error:Unknown table 'crash_me10'
4335
###As far as some queries didnt return OK, result is YES
4336
reserved_word_ansi92_bit_length=no # Keyword BIT_LENGTH
4337
###< create table crash_me10 (BIT_LENGTH int not null)
4339
###< drop table crash_me10
4342
###As far as all queries returned OK, result is NO
4343
reserved_word_ansi92_char_length=no # Keyword CHAR_LENGTH
4344
###< create table crash_me10 (CHAR_LENGTH int not null)
4346
###< drop table crash_me10
4349
###As far as all queries returned OK, result is NO
4350
reserved_word_ansi92_character_length=no # Keyword CHARACTER_LENGTH
4351
###< create table crash_me10 (CHARACTER_LENGTH int not null)
4353
###< drop table crash_me10
4356
###As far as all queries returned OK, result is NO
4357
reserved_word_ansi92_coalesce=no # Keyword COALESCE
4358
###< create table crash_me10 (COALESCE int not null)
4360
###< drop table crash_me10
4363
###As far as all queries returned OK, result is NO
4364
reserved_word_ansi92_convert=no # Keyword CONVERT
4365
###< create table crash_me10 (CONVERT int not null)
4367
###< drop table crash_me10
4370
###As far as all queries returned OK, result is NO
4371
reserved_word_ansi92_count=no # Keyword COUNT
4372
###< create table crash_me10 (COUNT int not null)
4374
###< drop table crash_me10
4377
###As far as all queries returned OK, result is NO
4378
reserved_word_ansi92_exists=yes # Keyword EXISTS
4379
###< create table crash_me10 (EXISTS int not null)
4380
###> 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 'EXISTS int not null)' at line 1
4381
###< drop table crash_me10
4382
###> execute error:Unknown table 'crash_me10'
4384
###As far as some queries didnt return OK, result is YES
4385
reserved_word_ansi92_extract=no # Keyword EXTRACT
4386
###< create table crash_me10 (EXTRACT int not null)
4388
###< drop table crash_me10
4391
###As far as all queries returned OK, result is NO
4392
reserved_word_ansi92_insensitive=yes # Keyword INSENSITIVE
4393
###< create table crash_me10 (INSENSITIVE int not null)
4394
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSENSITIVE int not null)' at line 1
4395
###< drop table crash_me10
4396
###> execute error:Unknown table 'crash_me10'
4398
###As far as some queries didnt return OK, result is YES
4399
reserved_word_ansi92_lower=no # Keyword LOWER
4400
###< create table crash_me10 (LOWER int not null)
4402
###< drop table crash_me10
4405
###As far as all queries returned OK, result is NO
4406
reserved_word_ansi92_max=no # Keyword MAX
4407
###< create table crash_me10 (MAX int not null)
4409
###< drop table crash_me10
4412
###As far as all queries returned OK, result is NO
4413
reserved_word_ansi92_min=no # Keyword MIN
4414
###< create table crash_me10 (MIN int not null)
4416
###< drop table crash_me10
4419
###As far as all queries returned OK, result is NO
4420
reserved_word_ansi92_nullif=no # Keyword NULLIF
4421
###< create table crash_me10 (NULLIF int not null)
4423
###< drop table crash_me10
4426
###As far as all queries returned OK, result is NO
4427
reserved_word_ansi92_octet_length=no # Keyword OCTET_LENGTH
4428
###< create table crash_me10 (OCTET_LENGTH int not null)
4430
###< drop table crash_me10
4433
###As far as all queries returned OK, result is NO
4434
reserved_word_ansi92_oid=no # Keyword OID
4435
###< create table crash_me10 (OID int not null)
4437
###< drop table crash_me10
4440
###As far as all queries returned OK, result is NO
4441
reserved_word_ansi92_operators=no # Keyword OPERATORS
4442
###< create table crash_me10 (OPERATORS int not null)
4444
###< drop table crash_me10
4447
###As far as all queries returned OK, result is NO
4448
reserved_word_ansi92_others=no # Keyword OTHERS
4449
###< create table crash_me10 (OTHERS int not null)
4451
###< drop table crash_me10
4454
###As far as all queries returned OK, result is NO
4455
reserved_word_ansi92_overlaps=no # Keyword OVERLAPS
4456
###< create table crash_me10 (OVERLAPS int not null)
4458
###< drop table crash_me10
4461
###As far as all queries returned OK, result is NO
4462
reserved_word_ansi92_pendant=no # Keyword PENDANT
4463
###< create table crash_me10 (PENDANT int not null)
4465
###< drop table crash_me10
4468
###As far as all queries returned OK, result is NO
4469
reserved_word_ansi92_position=no # Keyword POSITION
4470
###< create table crash_me10 (POSITION int not null)
4472
###< drop table crash_me10
4475
###As far as all queries returned OK, result is NO
4476
reserved_word_ansi92_private=no # Keyword PRIVATE
4477
###< create table crash_me10 (PRIVATE int not null)
4479
###< drop table crash_me10
4482
###As far as all queries returned OK, result is NO
4483
reserved_word_ansi92_protected=no # Keyword PROTECTED
4484
###< create table crash_me10 (PROTECTED int not null)
4486
###< drop table crash_me10
4489
###As far as all queries returned OK, result is NO
4490
reserved_word_ansi92_replace=yes # Keyword REPLACE
4491
###< create table crash_me10 (REPLACE int not null)
4492
###> 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 'REPLACE int not null)' at line 1
4493
###< drop table crash_me10
4494
###> execute error:Unknown table 'crash_me10'
4496
###As far as some queries didnt return OK, result is YES
4497
reserved_word_ansi92_sensitive=yes # Keyword SENSITIVE
4498
###< create table crash_me10 (SENSITIVE int not null)
4499
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SENSITIVE int not null)' at line 1
4500
###< drop table crash_me10
4501
###> execute error:Unknown table 'crash_me10'
4503
###As far as some queries didnt return OK, result is YES
4504
reserved_word_ansi92_similar=no # Keyword SIMILAR
4505
###< create table crash_me10 (SIMILAR int not null)
4507
###< drop table crash_me10
4510
###As far as all queries returned OK, result is NO
4511
reserved_word_ansi92_sqlcode=no # Keyword SQLCODE
4512
###< create table crash_me10 (SQLCODE int not null)
4514
###< drop table crash_me10
4517
###As far as all queries returned OK, result is NO
4518
reserved_word_ansi92_sqlerror=no # Keyword SQLERROR
4519
###< create table crash_me10 (SQLERROR int not null)
4521
###< drop table crash_me10
4524
###As far as all queries returned OK, result is NO
4525
reserved_word_ansi92_substring=no # Keyword SUBSTRING
4526
###< create table crash_me10 (SUBSTRING int not null)
4528
###< drop table crash_me10
4531
###As far as all queries returned OK, result is NO
4532
reserved_word_ansi92_sum=no # Keyword SUM
4533
###< create table crash_me10 (SUM int not null)
4535
###< drop table crash_me10
4538
###As far as all queries returned OK, result is NO
4539
reserved_word_ansi92_test=no # Keyword TEST
4540
###< create table crash_me10 (TEST int not null)
4542
###< drop table crash_me10
4545
###As far as all queries returned OK, result is NO
4546
reserved_word_ansi92_there=no # Keyword THERE
4547
###< create table crash_me10 (THERE int not null)
4549
###< drop table crash_me10
4552
###As far as all queries returned OK, result is NO
4553
reserved_word_ansi92_translate=no # Keyword TRANSLATE
4554
###< create table crash_me10 (TRANSLATE int not null)
4556
###< drop table crash_me10
4559
###As far as all queries returned OK, result is NO
4560
reserved_word_ansi92_trim=no # Keyword TRIM
4561
###< create table crash_me10 (TRIM int not null)
4563
###< drop table crash_me10
4566
###As far as all queries returned OK, result is NO
4567
reserved_word_ansi92_type=no # Keyword TYPE
4568
###< create table crash_me10 (TYPE int not null)
4570
###< drop table crash_me10
4573
###As far as all queries returned OK, result is NO
4574
reserved_word_ansi92_upper=no # Keyword UPPER
4575
###< create table crash_me10 (UPPER int not null)
4577
###< drop table crash_me10
4580
###As far as all queries returned OK, result is NO
4581
reserved_word_ansi92_virtual=no # Keyword VIRTUAL
4582
###< create table crash_me10 (VIRTUAL int not null)
4584
###< drop table crash_me10
4587
###As far as all queries returned OK, result is NO
4588
reserved_word_ansi92_visible=no # Keyword VISIBLE
4589
###< create table crash_me10 (VISIBLE int not null)
4591
###< drop table crash_me10
4594
###As far as all queries returned OK, result is NO
4595
reserved_word_ansi92_wait=no # Keyword WAIT
4596
###< create table crash_me10 (WAIT int not null)
4598
###< drop table crash_me10
4601
###As far as all queries returned OK, result is NO
4602
reserved_word_ansi99_admin=no # Keyword ADMIN
4603
###< create table crash_me10 (ADMIN int not null)
4605
###< drop table crash_me10
4608
###As far as all queries returned OK, result is NO
4609
reserved_word_ansi99_aggregate=no # Keyword AGGREGATE
4610
###< create table crash_me10 (AGGREGATE int not null)
4612
###< drop table crash_me10
4615
###As far as all queries returned OK, result is NO
4616
reserved_word_ansi99_array=no # Keyword ARRAY
4617
###< create table crash_me10 (ARRAY int not null)
4619
###< drop table crash_me10
4622
###As far as all queries returned OK, result is NO
4623
reserved_word_ansi99_binary=yes # Keyword BINARY
4624
###< create table crash_me10 (BINARY int not null)
4625
###> 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 'BINARY int not null)' at line 1
4626
###< drop table crash_me10
4627
###> execute error:Unknown table 'crash_me10'
4629
###As far as some queries didnt return OK, result is YES
4630
reserved_word_ansi99_blob=yes # Keyword BLOB
4631
###< create table crash_me10 (BLOB int not null)
4632
###> 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 'BLOB int not null)' at line 1
4633
###< drop table crash_me10
4634
###> execute error:Unknown table 'crash_me10'
4636
###As far as some queries didnt return OK, result is YES
4637
reserved_word_ansi99_class=no # Keyword CLASS
4638
###< create table crash_me10 (CLASS int not null)
4640
###< drop table crash_me10
4643
###As far as all queries returned OK, result is NO
4644
reserved_word_ansi99_clob=no # Keyword CLOB
4645
###< create table crash_me10 (CLOB int not null)
4647
###< drop table crash_me10
4650
###As far as all queries returned OK, result is NO
4651
reserved_word_ansi99_condition=yes # Keyword CONDITION
4652
###< create table crash_me10 (CONDITION int not null)
4653
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONDITION int not null)' at line 1
4654
###< drop table crash_me10
4655
###> execute error:Unknown table 'crash_me10'
4657
###As far as some queries didnt return OK, result is YES
4658
reserved_word_ansi99_constructor=no # Keyword CONSTRUCTOR
4659
###< create table crash_me10 (CONSTRUCTOR int not null)
4661
###< drop table crash_me10
4664
###As far as all queries returned OK, result is NO
4665
reserved_word_ansi99_contains=no # Keyword CONTAINS
4666
###< create table crash_me10 (CONTAINS int not null)
4668
###< drop table crash_me10
4671
###As far as all queries returned OK, result is NO
4672
reserved_word_ansi99_cube=no # Keyword CUBE
4673
###< create table crash_me10 (CUBE int not null)
4675
###< drop table crash_me10
4678
###As far as all queries returned OK, result is NO
4679
reserved_word_ansi99_current_path=no # Keyword CURRENT_PATH
4680
###< create table crash_me10 (CURRENT_PATH int not null)
4682
###< drop table crash_me10
4685
###As far as all queries returned OK, result is NO
4686
reserved_word_ansi99_current_role=no # Keyword CURRENT_ROLE
4687
###< create table crash_me10 (CURRENT_ROLE int not null)
4689
###< drop table crash_me10
4692
###As far as all queries returned OK, result is NO
4693
reserved_word_ansi99_datalink=no # Keyword DATALINK
4694
###< create table crash_me10 (DATALINK int not null)
4696
###< drop table crash_me10
4699
###As far as all queries returned OK, result is NO
4700
reserved_word_ansi99_deref=no # Keyword DEREF
4701
###< create table crash_me10 (DEREF int not null)
4703
###< drop table crash_me10
4706
###As far as all queries returned OK, result is NO
4707
reserved_word_ansi99_destroy=no # Keyword DESTROY
4708
###< create table crash_me10 (DESTROY int not null)
4710
###< drop table crash_me10
4713
###As far as all queries returned OK, result is NO
4714
reserved_word_ansi99_destructor=no # Keyword DESTRUCTOR
4715
###< create table crash_me10 (DESTRUCTOR int not null)
4717
###< drop table crash_me10
4720
###As far as all queries returned OK, result is NO
4721
reserved_word_ansi99_deterministic=yes # Keyword DETERMINISTIC
4722
###< create table crash_me10 (DETERMINISTIC int not null)
4723
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DETERMINISTIC int not null)' at line 1
4724
###< drop table crash_me10
4725
###> execute error:Unknown table 'crash_me10'
4727
###As far as some queries didnt return OK, result is YES
4728
reserved_word_ansi99_do=no # Keyword DO
4729
###< create table crash_me10 (DO int not null)
4731
###< drop table crash_me10
4734
###As far as all queries returned OK, result is NO
4735
reserved_word_ansi99_dynamic=no # Keyword DYNAMIC
4736
###< create table crash_me10 (DYNAMIC int not null)
4738
###< drop table crash_me10
4741
###As far as all queries returned OK, result is NO
4742
reserved_word_ansi99_every=no # Keyword EVERY
4743
###< create table crash_me10 (EVERY int not null)
4745
###< drop table crash_me10
4748
###As far as all queries returned OK, result is NO
4749
reserved_word_ansi99_exit=yes # Keyword EXIT
4750
###< create table crash_me10 (EXIT int not null)
4751
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXIT int not null)' at line 1
4752
###< drop table crash_me10
4753
###> execute error:Unknown table 'crash_me10'
4755
###As far as some queries didnt return OK, result is YES
4756
reserved_word_ansi99_expand=no # Keyword EXPAND
4757
###< create table crash_me10 (EXPAND int not null)
4759
###< drop table crash_me10
4762
###As far as all queries returned OK, result is NO
4763
reserved_word_ansi99_expanding=no # Keyword EXPANDING
4764
###< create table crash_me10 (EXPANDING int not null)
4766
###< drop table crash_me10
4769
###As far as all queries returned OK, result is NO
4770
reserved_word_ansi99_free=no # Keyword FREE
4771
###< create table crash_me10 (FREE int not null)
4773
###< drop table crash_me10
4776
###As far as all queries returned OK, result is NO
4777
reserved_word_ansi99_function=no # Keyword FUNCTION
4778
###< create table crash_me10 (FUNCTION int not null)
4780
###< drop table crash_me10
4783
###As far as all queries returned OK, result is NO
4784
reserved_word_ansi99_grouping=no # Keyword GROUPING
4785
###< create table crash_me10 (GROUPING int not null)
4787
###< drop table crash_me10
4790
###As far as all queries returned OK, result is NO
4791
reserved_word_ansi99_handler=no # Keyword HANDLER
4792
###< create table crash_me10 (HANDLER int not null)
4794
###< drop table crash_me10
4797
###As far as all queries returned OK, result is NO
4798
reserved_word_ansi99_hast=no # Keyword HAST
4799
###< create table crash_me10 (HAST int not null)
4801
###< drop table crash_me10
4804
###As far as all queries returned OK, result is NO
4805
reserved_word_ansi99_host=no # Keyword HOST
4806
###< create table crash_me10 (HOST int not null)
4808
###< drop table crash_me10
4811
###As far as all queries returned OK, result is NO
4812
reserved_word_ansi99_initialize=no # Keyword INITIALIZE
4813
###< create table crash_me10 (INITIALIZE int not null)
4815
###< drop table crash_me10
4818
###As far as all queries returned OK, result is NO
4819
reserved_word_ansi99_inout=yes # Keyword INOUT
4820
###< create table crash_me10 (INOUT int not null)
4821
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INOUT int not null)' at line 1
4822
###< drop table crash_me10
4823
###> execute error:Unknown table 'crash_me10'
4825
###As far as some queries didnt return OK, result is YES
4826
reserved_word_ansi99_iterate=yes # Keyword ITERATE
4827
###< create table crash_me10 (ITERATE int not null)
4828
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ITERATE int not null)' at line 1
4829
###< drop table crash_me10
4830
###> execute error:Unknown table 'crash_me10'
4832
###As far as some queries didnt return OK, result is YES
4833
reserved_word_ansi99_large=no # Keyword LARGE
4834
###< create table crash_me10 (LARGE int not null)
4836
###< drop table crash_me10
4839
###As far as all queries returned OK, result is NO
4840
reserved_word_ansi99_lateral=no # Keyword LATERAL
4841
###< create table crash_me10 (LATERAL int not null)
4843
###< drop table crash_me10
4846
###As far as all queries returned OK, result is NO
4847
reserved_word_ansi99_localtime=yes # Keyword LOCALTIME
4848
###< create table crash_me10 (LOCALTIME int not null)
4849
###> 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 'LOCALTIME int not null)' at line 1
4850
###< drop table crash_me10
4851
###> execute error:Unknown table 'crash_me10'
4853
###As far as some queries didnt return OK, result is YES
4854
reserved_word_ansi99_localtimestamp=yes # Keyword LOCALTIMESTAMP
4855
###< create table crash_me10 (LOCALTIMESTAMP int not null)
4856
###> 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 'LOCALTIMESTAMP int not null)' at line 1
4857
###< drop table crash_me10
4858
###> execute error:Unknown table 'crash_me10'
4860
###As far as some queries didnt return OK, result is YES
4861
reserved_word_ansi99_locator=no # Keyword LOCATOR
4862
###< create table crash_me10 (LOCATOR int not null)
4864
###< drop table crash_me10
4867
###As far as all queries returned OK, result is NO
4868
reserved_word_ansi99_meets=no # Keyword MEETS
4869
###< create table crash_me10 (MEETS int not null)
4871
###< drop table crash_me10
4874
###As far as all queries returned OK, result is NO
4875
reserved_word_ansi99_modifies=no # Keyword MODIFIES
4876
###< create table crash_me10 (MODIFIES int not null)
4878
###< drop table crash_me10
4881
###As far as all queries returned OK, result is NO
4882
reserved_word_ansi99_nclob=no # Keyword NCLOB
4883
###< create table crash_me10 (NCLOB int not null)
4885
###< drop table crash_me10
4888
###As far as all queries returned OK, result is NO
4889
reserved_word_ansi99_normalize=no # Keyword NORMALIZE
4890
###< create table crash_me10 (NORMALIZE int not null)
4892
###< drop table crash_me10
4895
###As far as all queries returned OK, result is NO
4896
reserved_word_ansi99_ordinality=no # Keyword ORDINALITY
4897
###< create table crash_me10 (ORDINALITY int not null)
4899
###< drop table crash_me10
4902
###As far as all queries returned OK, result is NO
4903
reserved_word_ansi99_out=yes # Keyword OUT
4904
###< create table crash_me10 (OUT int not null)
4905
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'OUT int not null)' at line 1
4906
###< drop table crash_me10
4907
###> execute error:Unknown table 'crash_me10'
4909
###As far as some queries didnt return OK, result is YES
4910
reserved_word_ansi99_parameter=no # Keyword PARAMETER
4911
###< create table crash_me10 (PARAMETER int not null)
4913
###< drop table crash_me10
4916
###As far as all queries returned OK, result is NO
4917
reserved_word_ansi99_path=no # Keyword PATH
4918
###< create table crash_me10 (PATH int not null)
4920
###< drop table crash_me10
4923
###As far as all queries returned OK, result is NO
4924
reserved_word_ansi99_period=no # Keyword PERIOD
4925
###< create table crash_me10 (PERIOD int not null)
4927
###< drop table crash_me10
4930
###As far as all queries returned OK, result is NO
4931
reserved_word_ansi99_postfix=no # Keyword POSTFIX
4932
###< create table crash_me10 (POSTFIX int not null)
4934
###< drop table crash_me10
4937
###As far as all queries returned OK, result is NO
4938
reserved_word_ansi99_precedes=no # Keyword PRECEDES
4939
###< create table crash_me10 (PRECEDES int not null)
4941
###< drop table crash_me10
4944
###As far as all queries returned OK, result is NO
4945
reserved_word_ansi99_prefix=no # Keyword PREFIX
4946
###< create table crash_me10 (PREFIX int not null)
4948
###< drop table crash_me10
4951
###As far as all queries returned OK, result is NO
4952
reserved_word_ansi99_reads=no # Keyword READS
4953
###< create table crash_me10 (READS int not null)
4955
###< drop table crash_me10
4958
###As far as all queries returned OK, result is NO
4959
reserved_word_ansi99_redo=no # Keyword REDO
4960
###< create table crash_me10 (REDO int not null)
4962
###< drop table crash_me10
4965
###As far as all queries returned OK, result is NO
4966
reserved_word_ansi99_repeat=yes # Keyword REPEAT
4967
###< create table crash_me10 (REPEAT int not null)
4968
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'REPEAT int not null)' at line 1
4969
###< drop table crash_me10
4970
###> execute error:Unknown table 'crash_me10'
4972
###As far as some queries didnt return OK, result is YES
4973
reserved_word_ansi99_result=no # Keyword RESULT
4974
###< create table crash_me10 (RESULT int not null)
4976
###< drop table crash_me10
4979
###As far as all queries returned OK, result is NO
4980
reserved_word_ansi99_rollup=no # Keyword ROLLUP
4981
###< create table crash_me10 (ROLLUP int not null)
4983
###< drop table crash_me10
4986
###As far as all queries returned OK, result is NO
4987
reserved_word_ansi99_sets=no # Keyword SETS
4988
###< create table crash_me10 (SETS int not null)
4990
###< drop table crash_me10
4993
###As far as all queries returned OK, result is NO
4994
reserved_word_ansi99_specific=yes # Keyword SPECIFIC
4995
###< create table crash_me10 (SPECIFIC int not null)
4996
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SPECIFIC int not null)' at line 1
4997
###< drop table crash_me10
4998
###> execute error:Unknown table 'crash_me10'
5000
###As far as some queries didnt return OK, result is YES
5001
reserved_word_ansi99_specifictype=no # Keyword SPECIFICTYPE
5002
###< create table crash_me10 (SPECIFICTYPE int not null)
5004
###< drop table crash_me10
5007
###As far as all queries returned OK, result is NO
5008
reserved_word_ansi99_start=no # Keyword START
5009
###< create table crash_me10 (START int not null)
5011
###< drop table crash_me10
5014
###As far as all queries returned OK, result is NO
5015
reserved_word_ansi99_state=no # Keyword STATE
5016
###< create table crash_me10 (STATE int not null)
5018
###< drop table crash_me10
5021
###As far as all queries returned OK, result is NO
5022
reserved_word_ansi99_static=no # Keyword STATIC
5023
###< create table crash_me10 (STATIC int not null)
5025
###< drop table crash_me10
5028
###As far as all queries returned OK, result is NO
5029
reserved_word_ansi99_succeeds=no # Keyword SUCCEEDS
5030
###< create table crash_me10 (SUCCEEDS int not null)
5032
###< drop table crash_me10
5035
###As far as all queries returned OK, result is NO
5036
reserved_word_ansi99_terminate=no # Keyword TERMINATE
5037
###< create table crash_me10 (TERMINATE int not null)
5039
###< drop table crash_me10
5042
###As far as all queries returned OK, result is NO
5043
reserved_word_ansi99_than=no # Keyword THAN
5044
###< create table crash_me10 (THAN int not null)
5046
###< drop table crash_me10
5049
###As far as all queries returned OK, result is NO
5050
reserved_word_ansi99_treat=no # Keyword TREAT
5051
###< create table crash_me10 (TREAT int not null)
5053
###< drop table crash_me10
5056
###As far as all queries returned OK, result is NO
5057
reserved_word_ansi99_undo=yes # Keyword UNDO
5058
###< create table crash_me10 (UNDO int not null)
5059
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNDO int not null)' at line 1
5060
###< drop table crash_me10
5061
###> execute error:Unknown table 'crash_me10'
5063
###As far as some queries didnt return OK, result is YES
5064
reserved_word_ansi99_until=no # Keyword UNTIL
5065
###< create table crash_me10 (UNTIL int not null)
5067
###< drop table crash_me10
5070
###As far as all queries returned OK, result is NO
5071
reserved_word_extra_access=no # Keyword ACCESS
5072
###< create table crash_me10 (ACCESS int not null)
5074
###< drop table crash_me10
5077
###As far as all queries returned OK, result is NO
5078
reserved_word_extra_analyze=yes # Keyword ANALYZE
5079
###< create table crash_me10 (ANALYZE int not null)
5080
###> 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 'ANALYZE int not null)' at line 1
5081
###< drop table crash_me10
5082
###> execute error:Unknown table 'crash_me10'
5084
###As far as some queries didnt return OK, result is YES
5085
reserved_word_extra_audit=no # Keyword AUDIT
5086
###< create table crash_me10 (AUDIT int not null)
5088
###< drop table crash_me10
5091
###As far as all queries returned OK, result is NO
5092
reserved_word_extra_auto_increment=no # Keyword AUTO_INCREMENT
5093
###< create table crash_me10 (AUTO_INCREMENT int not null)
5095
###< drop table crash_me10
5098
###As far as all queries returned OK, result is NO
5099
reserved_word_extra_backup=no # Keyword BACKUP
5100
###< create table crash_me10 (BACKUP int not null)
5102
###< drop table crash_me10
5105
###As far as all queries returned OK, result is NO
5106
reserved_word_extra_bdb=no # Keyword BDB
5107
###< create table crash_me10 (BDB int not null)
5109
###< drop table crash_me10
5112
###As far as all queries returned OK, result is NO
5113
reserved_word_extra_berkeleydb=no # Keyword BERKELEYDB
5114
###< create table crash_me10 (BERKELEYDB int not null)
5116
###< drop table crash_me10
5119
###As far as all queries returned OK, result is NO
5120
reserved_word_extra_bigint=yes # Keyword BIGINT
5121
###< create table crash_me10 (BIGINT int not null)
5122
###> 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 'BIGINT int not null)' at line 1
5123
###< drop table crash_me10
5124
###> execute error:Unknown table 'crash_me10'
5126
###As far as some queries didnt return OK, result is YES
5127
reserved_word_extra_break=no # Keyword BREAK
5128
###< create table crash_me10 (BREAK int not null)
5130
###< drop table crash_me10
5133
###As far as all queries returned OK, result is NO
5134
reserved_word_extra_browse=no # Keyword BROWSE
5135
###< create table crash_me10 (BROWSE int not null)
5137
###< drop table crash_me10
5140
###As far as all queries returned OK, result is NO
5141
reserved_word_extra_btree=no # Keyword BTREE
5142
###< create table crash_me10 (BTREE int not null)
5144
###< drop table crash_me10
5147
###As far as all queries returned OK, result is NO
5148
reserved_word_extra_bulk=no # Keyword BULK
5149
###< create table crash_me10 (BULK int not null)
5151
###< drop table crash_me10
5154
###As far as all queries returned OK, result is NO
5155
reserved_word_extra_change=yes # Keyword CHANGE
5156
###< create table crash_me10 (CHANGE int not null)
5157
###> 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 'CHANGE int not null)' at line 1
5158
###< drop table crash_me10
5159
###> execute error:Unknown table 'crash_me10'
5161
###As far as some queries didnt return OK, result is YES
5162
reserved_word_extra_checkpoint=no # Keyword CHECKPOINT
5163
###< create table crash_me10 (CHECKPOINT int not null)
5165
###< drop table crash_me10
5168
###As far as all queries returned OK, result is NO
5169
reserved_word_extra_cluster=no # Keyword CLUSTER
5170
###< create table crash_me10 (CLUSTER int not null)
5172
###< drop table crash_me10
5175
###As far as all queries returned OK, result is NO
5176
reserved_word_extra_clustered=no # Keyword CLUSTERED
5177
###< create table crash_me10 (CLUSTERED int not null)
5179
###< drop table crash_me10
5182
###As far as all queries returned OK, result is NO
5183
reserved_word_extra_columns=yes # Keyword COLUMNS
5184
###< create table crash_me10 (COLUMNS int not null)
5185
###> 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 'COLUMNS int not null)' at line 1
5186
###< drop table crash_me10
5187
###> execute error:Unknown table 'crash_me10'
5189
###As far as some queries didnt return OK, result is YES
5190
reserved_word_extra_comment=no # Keyword COMMENT
5191
###< create table crash_me10 (COMMENT int not null)
5193
###< drop table crash_me10
5196
###As far as all queries returned OK, result is NO
5197
reserved_word_extra_compress=no # Keyword COMPRESS
5198
###< create table crash_me10 (COMPRESS int not null)
5200
###< drop table crash_me10
5203
###As far as all queries returned OK, result is NO
5204
reserved_word_extra_compute=no # Keyword COMPUTE
5205
###< create table crash_me10 (COMPUTE int not null)
5207
###< drop table crash_me10
5210
###As far as all queries returned OK, result is NO
5211
reserved_word_extra_containstable=no # Keyword CONTAINSTABLE
5212
###< create table crash_me10 (CONTAINSTABLE int not null)
5214
###< drop table crash_me10
5217
###As far as all queries returned OK, result is NO
5218
reserved_word_extra_database=yes # Keyword DATABASE
5219
###< create table crash_me10 (DATABASE int not null)
5220
###> 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 'DATABASE int not null)' at line 1
5221
###< drop table crash_me10
5222
###> execute error:Unknown table 'crash_me10'
5224
###As far as some queries didnt return OK, result is YES
5225
reserved_word_extra_databases=yes # Keyword DATABASES
5226
###< create table crash_me10 (DATABASES int not null)
5227
###> 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 'DATABASES int not null)' at line 1
5228
###< drop table crash_me10
5229
###> execute error:Unknown table 'crash_me10'
5231
###As far as some queries didnt return OK, result is YES
5232
reserved_word_extra_day_hour=yes # Keyword DAY_HOUR
5233
###< create table crash_me10 (DAY_HOUR int not null)
5234
###> 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 'DAY_HOUR int not null)' at line 1
5235
###< drop table crash_me10
5236
###> execute error:Unknown table 'crash_me10'
5238
###As far as some queries didnt return OK, result is YES
5239
reserved_word_extra_day_minute=yes # Keyword DAY_MINUTE
5240
###< create table crash_me10 (DAY_MINUTE int not null)
5241
###> 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 'DAY_MINUTE int not null)' at line 1
5242
###< drop table crash_me10
5243
###> execute error:Unknown table 'crash_me10'
5245
###As far as some queries didnt return OK, result is YES
5246
reserved_word_extra_day_second=yes # Keyword DAY_SECOND
5247
###< create table crash_me10 (DAY_SECOND int not null)
5248
###> 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 'DAY_SECOND int not null)' at line 1
5249
###< drop table crash_me10
5250
###> execute error:Unknown table 'crash_me10'
5252
###As far as some queries didnt return OK, result is YES
5253
reserved_word_extra_dbcc=no # Keyword DBCC
5254
###< create table crash_me10 (DBCC int not null)
5256
###< drop table crash_me10
5259
###As far as all queries returned OK, result is NO
5260
reserved_word_extra_delayed=yes # Keyword DELAYED
5261
###< create table crash_me10 (DELAYED int not null)
5262
###> 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 'DELAYED int not null)' at line 1
5263
###< drop table crash_me10
5264
###> execute error:Unknown table 'crash_me10'
5266
###As far as some queries didnt return OK, result is YES
5267
reserved_word_extra_deny=no # Keyword DENY
5268
###< create table crash_me10 (DENY int not null)
5270
###< drop table crash_me10
5273
###As far as all queries returned OK, result is NO
5274
reserved_word_extra_disk=no # Keyword DISK
5275
###< create table crash_me10 (DISK int not null)
5277
###< drop table crash_me10
5280
###As far as all queries returned OK, result is NO
5281
reserved_word_extra_distinctrow=yes # Keyword DISTINCTROW
5282
###< create table crash_me10 (DISTINCTROW int not null)
5283
###> 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 'DISTINCTROW int not null)' at line 1
5284
###< drop table crash_me10
5285
###> execute error:Unknown table 'crash_me10'
5287
###As far as some queries didnt return OK, result is YES
5288
reserved_word_extra_distributed=no # Keyword DISTRIBUTED
5289
###< create table crash_me10 (DISTRIBUTED int not null)
5291
###< drop table crash_me10
5294
###As far as all queries returned OK, result is NO
5295
reserved_word_extra_dummy=no # Keyword DUMMY
5296
###< create table crash_me10 (DUMMY int not null)
5298
###< drop table crash_me10
5301
###As far as all queries returned OK, result is NO
5302
reserved_word_extra_dump=no # Keyword DUMP
5303
###< create table crash_me10 (DUMP int not null)
5305
###< drop table crash_me10
5308
###As far as all queries returned OK, result is NO
5309
reserved_word_extra_enclosed=yes # Keyword ENCLOSED
5310
###< create table crash_me10 (ENCLOSED int not null)
5311
###> 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 'ENCLOSED int not null)' at line 1
5312
###< drop table crash_me10
5313
###> execute error:Unknown table 'crash_me10'
5315
###As far as some queries didnt return OK, result is YES
5316
reserved_word_extra_errlvl=no # Keyword ERRLVL
5317
###< create table crash_me10 (ERRLVL int not null)
5319
###< drop table crash_me10
5322
###As far as all queries returned OK, result is NO
5323
reserved_word_extra_errors=no # Keyword ERRORS
5324
###< create table crash_me10 (ERRORS int not null)
5326
###< drop table crash_me10
5329
###As far as all queries returned OK, result is NO
5330
reserved_word_extra_escaped=yes # Keyword ESCAPED
5331
###< create table crash_me10 (ESCAPED int not null)
5332
###> 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 'ESCAPED int not null)' at line 1
5333
###< drop table crash_me10
5334
###> execute error:Unknown table 'crash_me10'
5336
###As far as some queries didnt return OK, result is YES
5337
reserved_word_extra_exclusive=no # Keyword EXCLUSIVE
5338
###< create table crash_me10 (EXCLUSIVE int not null)
5340
###< drop table crash_me10
5343
###As far as all queries returned OK, result is NO
5344
reserved_word_extra_explain=yes # Keyword EXPLAIN
5345
###< create table crash_me10 (EXPLAIN int not null)
5346
###> 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 'EXPLAIN int not null)' at line 1
5347
###< drop table crash_me10
5348
###> execute error:Unknown table 'crash_me10'
5350
###As far as some queries didnt return OK, result is YES
5351
reserved_word_extra_fields=yes # Keyword FIELDS
5352
###< create table crash_me10 (FIELDS int not null)
5353
###> 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 'FIELDS int not null)' at line 1
5354
###< drop table crash_me10
5355
###> execute error:Unknown table 'crash_me10'
5357
###As far as some queries didnt return OK, result is YES
5358
reserved_word_extra_file=no # Keyword FILE
5359
###< create table crash_me10 (FILE int not null)
5361
###< drop table crash_me10
5364
###As far as all queries returned OK, result is NO
5365
reserved_word_extra_fillfactor=no # Keyword FILLFACTOR
5366
###< create table crash_me10 (FILLFACTOR int not null)
5368
###< drop table crash_me10
5371
###As far as all queries returned OK, result is NO
5372
reserved_word_extra_freetext=no # Keyword FREETEXT
5373
###< create table crash_me10 (FREETEXT int not null)
5375
###< drop table crash_me10
5378
###As far as all queries returned OK, result is NO
5379
reserved_word_extra_freetexttable=no # Keyword FREETEXTTABLE
5380
###< create table crash_me10 (FREETEXTTABLE int not null)
5382
###< drop table crash_me10
5385
###As far as all queries returned OK, result is NO
5386
reserved_word_extra_fulltext=yes # Keyword FULLTEXT
5387
###< create table crash_me10 (FULLTEXT int not null)
5388
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int not null)' at line 1
5389
###< drop table crash_me10
5390
###> execute error:Unknown table 'crash_me10'
5392
###As far as some queries didnt return OK, result is YES
5393
reserved_word_extra_geometry=no # Keyword GEOMETRY
5394
###< create table crash_me10 (GEOMETRY int not null)
5396
###< drop table crash_me10
5399
###As far as all queries returned OK, result is NO
5400
reserved_word_extra_hash=no # Keyword HASH
5401
###< create table crash_me10 (HASH int not null)
5403
###< drop table crash_me10
5406
###As far as all queries returned OK, result is NO
5407
reserved_word_extra_high_priority=yes # Keyword HIGH_PRIORITY
5408
###< create table crash_me10 (HIGH_PRIORITY int not null)
5409
###> 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 'HIGH_PRIORITY int not null)' at line 1
5410
###< drop table crash_me10
5411
###> execute error:Unknown table 'crash_me10'
5413
###As far as some queries didnt return OK, result is YES
5414
reserved_word_extra_holdlock=no # Keyword HOLDLOCK
5415
###< create table crash_me10 (HOLDLOCK int not null)
5417
###< drop table crash_me10
5420
###As far as all queries returned OK, result is NO
5421
reserved_word_extra_hour_minute=yes # Keyword HOUR_MINUTE
5422
###< create table crash_me10 (HOUR_MINUTE int not null)
5423
###> 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 'HOUR_MINUTE int not null)' at line 1
5424
###< drop table crash_me10
5425
###> execute error:Unknown table 'crash_me10'
5427
###As far as some queries didnt return OK, result is YES
5428
reserved_word_extra_hour_second=yes # Keyword HOUR_SECOND
5429
###< create table crash_me10 (HOUR_SECOND int not null)
5430
###> 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 'HOUR_SECOND int not null)' at line 1
5431
###< drop table crash_me10
5432
###> execute error:Unknown table 'crash_me10'
5434
###As far as some queries didnt return OK, result is YES
5435
reserved_word_extra_identified=no # Keyword IDENTIFIED
5436
###< create table crash_me10 (IDENTIFIED int not null)
5438
###< drop table crash_me10
5441
###As far as all queries returned OK, result is NO
5442
reserved_word_extra_identity_insert=no # Keyword IDENTITY_INSERT
5443
###< create table crash_me10 (IDENTITY_INSERT int not null)
5445
###< drop table crash_me10
5448
###As far as all queries returned OK, result is NO
5449
reserved_word_extra_identitycol=no # Keyword IDENTITYCOL
5450
###< create table crash_me10 (IDENTITYCOL int not null)
5452
###< drop table crash_me10
5455
###As far as all queries returned OK, result is NO
5456
reserved_word_extra_increment=no # Keyword INCREMENT
5457
###< create table crash_me10 (INCREMENT int not null)
5459
###< drop table crash_me10
5462
###As far as all queries returned OK, result is NO
5463
reserved_word_extra_index=yes # Keyword INDEX
5464
###< create table crash_me10 (INDEX int not null)
5465
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int not null)' at line 1
5466
###< drop table crash_me10
5467
###> execute error:Unknown table 'crash_me10'
5469
###As far as some queries didnt return OK, result is YES
5470
reserved_word_extra_infile=yes # Keyword INFILE
5471
###< create table crash_me10 (INFILE int not null)
5472
###> 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 'INFILE int not null)' at line 1
5473
###< drop table crash_me10
5474
###> execute error:Unknown table 'crash_me10'
5476
###As far as some queries didnt return OK, result is YES
5477
reserved_word_extra_initial=no # Keyword INITIAL
5478
###< create table crash_me10 (INITIAL int not null)
5480
###< drop table crash_me10
5483
###As far as all queries returned OK, result is NO
5484
reserved_word_extra_innodb=no # Keyword INNODB
5485
###< create table crash_me10 (INNODB int not null)
5487
###< drop table crash_me10
5490
###As far as all queries returned OK, result is NO
5491
reserved_word_extra_keys=yes # Keyword KEYS
5492
###< create table crash_me10 (KEYS int not null)
5493
###> 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 'KEYS int not null)' at line 1
5494
###< drop table crash_me10
5495
###> execute error:Unknown table 'crash_me10'
5497
###As far as some queries didnt return OK, result is YES
5498
reserved_word_extra_kill=yes # Keyword KILL
5499
###< create table crash_me10 (KILL int not null)
5500
###> 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 'KILL int not null)' at line 1
5501
###< drop table crash_me10
5502
###> execute error:Unknown table 'crash_me10'
5504
###As far as some queries didnt return OK, result is YES
5505
reserved_word_extra_lineno=no # Keyword LINENO
5506
###< create table crash_me10 (LINENO int not null)
5508
###< drop table crash_me10
5511
###As far as all queries returned OK, result is NO
5512
reserved_word_extra_lines=yes # Keyword LINES
5513
###< create table crash_me10 (LINES int not null)
5514
###> 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 'LINES int not null)' at line 1
5515
###< drop table crash_me10
5516
###> execute error:Unknown table 'crash_me10'
5518
###As far as some queries didnt return OK, result is YES
5519
reserved_word_extra_load=yes # Keyword LOAD
5520
###< create table crash_me10 (LOAD int not null)
5521
###> 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 'LOAD int not null)' at line 1
5522
###< drop table crash_me10
5523
###> execute error:Unknown table 'crash_me10'
5525
###As far as some queries didnt return OK, result is YES
5526
reserved_word_extra_lock=yes # Keyword LOCK
5527
###< create table crash_me10 (LOCK int not null)
5528
###> 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 'LOCK int not null)' at line 1
5529
###< drop table crash_me10
5530
###> execute error:Unknown table 'crash_me10'
5532
###As far as some queries didnt return OK, result is YES
5533
reserved_word_extra_long=yes # Keyword LONG
5534
###< create table crash_me10 (LONG int not null)
5535
###> 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 'LONG int not null)' at line 1
5536
###< drop table crash_me10
5537
###> execute error:Unknown table 'crash_me10'
5539
###As far as some queries didnt return OK, result is YES
5540
reserved_word_extra_longblob=yes # Keyword LONGBLOB
5541
###< create table crash_me10 (LONGBLOB int not null)
5542
###> 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 'LONGBLOB int not null)' at line 1
5543
###< drop table crash_me10
5544
###> execute error:Unknown table 'crash_me10'
5546
###As far as some queries didnt return OK, result is YES
5547
reserved_word_extra_longtext=yes # Keyword LONGTEXT
5548
###< create table crash_me10 (LONGTEXT int not null)
5549
###> 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 'LONGTEXT int not null)' at line 1
5550
###< drop table crash_me10
5551
###> execute error:Unknown table 'crash_me10'
5553
###As far as some queries didnt return OK, result is YES
5554
reserved_word_extra_low_priority=yes # Keyword LOW_PRIORITY
5555
###< create table crash_me10 (LOW_PRIORITY int not null)
5556
###> 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 'LOW_PRIORITY int not null)' at line 1
5557
###< drop table crash_me10
5558
###> execute error:Unknown table 'crash_me10'
5560
###As far as some queries didnt return OK, result is YES
5561
reserved_word_extra_master_server_id=yes # Keyword MASTER_SERVER_ID
5562
###< create table crash_me10 (MASTER_SERVER_ID int not null)
5563
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'MASTER_SERVER_ID int not null)' at line 1
5564
###< drop table crash_me10
5565
###> execute error:Unknown table 'crash_me10'
5567
###As far as some queries didnt return OK, result is YES
5568
reserved_word_extra_maxextents=no # Keyword MAXEXTENTS
5569
###< create table crash_me10 (MAXEXTENTS int not null)
5571
###< drop table crash_me10
5574
###As far as all queries returned OK, result is NO
5575
reserved_word_extra_mediumblob=yes # Keyword MEDIUMBLOB
5576
###< create table crash_me10 (MEDIUMBLOB int not null)
5577
###> 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 'MEDIUMBLOB int not null)' at line 1
5578
###< drop table crash_me10
5579
###> execute error:Unknown table 'crash_me10'
5581
###As far as some queries didnt return OK, result is YES
5582
reserved_word_extra_mediumint=yes # Keyword MEDIUMINT
5583
###< create table crash_me10 (MEDIUMINT int not null)
5584
###> 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 'MEDIUMINT int not null)' at line 1
5585
###< drop table crash_me10
5586
###> execute error:Unknown table 'crash_me10'
5588
###As far as some queries didnt return OK, result is YES
5589
reserved_word_extra_mediumtext=yes # Keyword MEDIUMTEXT
5590
###< create table crash_me10 (MEDIUMTEXT int not null)
5591
###> 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 'MEDIUMTEXT int not null)' at line 1
5592
###< drop table crash_me10
5593
###> execute error:Unknown table 'crash_me10'
5595
###As far as some queries didnt return OK, result is YES
5596
reserved_word_extra_middleint=yes # Keyword MIDDLEINT
5597
###< create table crash_me10 (MIDDLEINT int not null)
5598
###> 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 'MIDDLEINT int not null)' at line 1
5599
###< drop table crash_me10
5600
###> execute error:Unknown table 'crash_me10'
5602
###As far as some queries didnt return OK, result is YES
5603
reserved_word_extra_minus=no # Keyword MINUS
5604
###< create table crash_me10 (MINUS int not null)
5606
###< drop table crash_me10
5609
###As far as all queries returned OK, result is NO
5610
reserved_word_extra_minute_second=yes # Keyword MINUTE_SECOND
5611
###< create table crash_me10 (MINUTE_SECOND int not null)
5612
###> 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 'MINUTE_SECOND int not null)' at line 1
5613
###< drop table crash_me10
5614
###> execute error:Unknown table 'crash_me10'
5616
###As far as some queries didnt return OK, result is YES
5617
reserved_word_extra_mlslabel=no # Keyword MLSLABEL
5618
###< create table crash_me10 (MLSLABEL int not null)
5620
###< drop table crash_me10
5623
###As far as all queries returned OK, result is NO
5624
reserved_word_extra_mode=no # Keyword MODE
5625
###< create table crash_me10 (MODE int not null)
5627
###< drop table crash_me10
5630
###As far as all queries returned OK, result is NO
5631
reserved_word_extra_mrg_myisam=no # Keyword MRG_MYISAM
5632
###< create table crash_me10 (MRG_MYISAM int not null)
5634
###< drop table crash_me10
5637
###As far as all queries returned OK, result is NO
5638
reserved_word_extra_noaudit=no # Keyword NOAUDIT
5639
###< create table crash_me10 (NOAUDIT int not null)
5641
###< drop table crash_me10
5644
###As far as all queries returned OK, result is NO
5645
reserved_word_extra_nocheck=no # Keyword NOCHECK
5646
###< create table crash_me10 (NOCHECK int not null)
5648
###< drop table crash_me10
5651
###As far as all queries returned OK, result is NO
5652
reserved_word_extra_nocompress=no # Keyword NOCOMPRESS
5653
###< create table crash_me10 (NOCOMPRESS int not null)
5655
###< drop table crash_me10
5658
###As far as all queries returned OK, result is NO
5659
reserved_word_extra_nonclustered=no # Keyword NONCLUSTERED
5660
###< create table crash_me10 (NONCLUSTERED int not null)
5662
###< drop table crash_me10
5665
###As far as all queries returned OK, result is NO
5666
reserved_word_extra_nowait=no # Keyword NOWAIT
5667
###< create table crash_me10 (NOWAIT int not null)
5669
###< drop table crash_me10
5672
###As far as all queries returned OK, result is NO
5673
reserved_word_extra_number=no # Keyword NUMBER
5674
###< create table crash_me10 (NUMBER int not null)
5676
###< drop table crash_me10
5679
###As far as all queries returned OK, result is NO
5680
reserved_word_extra_offline=no # Keyword OFFLINE
5681
###< create table crash_me10 (OFFLINE int not null)
5683
###< drop table crash_me10
5686
###As far as all queries returned OK, result is NO
5687
reserved_word_extra_offsets=no # Keyword OFFSETS
5688
###< create table crash_me10 (OFFSETS int not null)
5690
###< drop table crash_me10
5693
###As far as all queries returned OK, result is NO
5694
reserved_word_extra_online=no # Keyword ONLINE
5695
###< create table crash_me10 (ONLINE int not null)
5697
###< drop table crash_me10
5700
###As far as all queries returned OK, result is NO
5701
reserved_word_extra_opendatasource=no # Keyword OPENDATASOURCE
5702
###< create table crash_me10 (OPENDATASOURCE int not null)
5704
###< drop table crash_me10
5707
###As far as all queries returned OK, result is NO
5708
reserved_word_extra_openquery=no # Keyword OPENQUERY
5709
###< create table crash_me10 (OPENQUERY int not null)
5711
###< drop table crash_me10
5714
###As far as all queries returned OK, result is NO
5715
reserved_word_extra_openrowset=no # Keyword OPENROWSET
5716
###< create table crash_me10 (OPENROWSET int not null)
5718
###< drop table crash_me10
5721
###As far as all queries returned OK, result is NO
5722
reserved_word_extra_openxml=no # Keyword OPENXML
5723
###< create table crash_me10 (OPENXML int not null)
5725
###< drop table crash_me10
5728
###As far as all queries returned OK, result is NO
5729
reserved_word_extra_optimize=yes # Keyword OPTIMIZE
5730
###< create table crash_me10 (OPTIMIZE int not null)
5731
###> 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 'OPTIMIZE int not null)' at line 1
5732
###< drop table crash_me10
5733
###> execute error:Unknown table 'crash_me10'
5735
###As far as some queries didnt return OK, result is YES
5736
reserved_word_extra_optionally=yes # Keyword OPTIONALLY
5737
###< create table crash_me10 (OPTIONALLY int not null)
5738
###> 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 'OPTIONALLY int not null)' at line 1
5739
###< drop table crash_me10
5740
###> execute error:Unknown table 'crash_me10'
5742
###As far as some queries didnt return OK, result is YES
5743
reserved_word_extra_outfile=yes # Keyword OUTFILE
5744
###< create table crash_me10 (OUTFILE int not null)
5745
###> 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 'OUTFILE int not null)' at line 1
5746
###< drop table crash_me10
5747
###> execute error:Unknown table 'crash_me10'
5749
###As far as some queries didnt return OK, result is YES
5750
reserved_word_extra_over=no # Keyword OVER
5751
###< create table crash_me10 (OVER int not null)
5753
###< drop table crash_me10
5756
###As far as all queries returned OK, result is NO
5757
reserved_word_extra_pctfree=no # Keyword PCTFREE
5758
###< create table crash_me10 (PCTFREE int not null)
5760
###< drop table crash_me10
5763
###As far as all queries returned OK, result is NO
5764
reserved_word_extra_percent=no # Keyword PERCENT
5765
###< create table crash_me10 (PERCENT int not null)
5767
###< drop table crash_me10
5770
###As far as all queries returned OK, result is NO
5771
reserved_word_extra_plan=no # Keyword PLAN
5772
###< create table crash_me10 (PLAN int not null)
5774
###< drop table crash_me10
5777
###As far as all queries returned OK, result is NO
5778
reserved_word_extra_print=no # Keyword PRINT
5779
###< create table crash_me10 (PRINT int not null)
5781
###< drop table crash_me10
5784
###As far as all queries returned OK, result is NO
5785
reserved_word_extra_proc=no # Keyword PROC
5786
###< create table crash_me10 (PROC int not null)
5788
###< drop table crash_me10
5791
###As far as all queries returned OK, result is NO
5792
reserved_word_extra_purge=yes # Keyword PURGE
5793
###< create table crash_me10 (PURGE int not null)
5794
###> 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 'PURGE int not null)' at line 1
5795
###< drop table crash_me10
5796
###> execute error:Unknown table 'crash_me10'
5798
###As far as some queries didnt return OK, result is YES
5799
reserved_word_extra_raiserror=no # Keyword RAISERROR
5800
###< create table crash_me10 (RAISERROR int not null)
5802
###< drop table crash_me10
5805
###As far as all queries returned OK, result is NO
5806
reserved_word_extra_raw=no # Keyword RAW
5807
###< create table crash_me10 (RAW int not null)
5809
###< drop table crash_me10
5812
###As far as all queries returned OK, result is NO
5813
reserved_word_extra_readtext=no # Keyword READTEXT
5814
###< create table crash_me10 (READTEXT int not null)
5816
###< drop table crash_me10
5819
###As far as all queries returned OK, result is NO
5820
reserved_word_extra_reconfigure=no # Keyword RECONFIGURE
5821
###< create table crash_me10 (RECONFIGURE int not null)
5823
###< drop table crash_me10
5826
###As far as all queries returned OK, result is NO
5827
reserved_word_extra_regexp=yes # Keyword REGEXP
5828
###< create table crash_me10 (REGEXP int not null)
5829
###> 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 'REGEXP int not null)' at line 1
5830
###< drop table crash_me10
5831
###> execute error:Unknown table 'crash_me10'
5833
###As far as some queries didnt return OK, result is YES
5834
reserved_word_extra_rename=yes # Keyword RENAME
5835
###< create table crash_me10 (RENAME int not null)
5836
###> 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 'RENAME int not null)' at line 1
5837
###< drop table crash_me10
5838
###> execute error:Unknown table 'crash_me10'
5840
###As far as some queries didnt return OK, result is YES
5841
reserved_word_extra_replication=no # Keyword REPLICATION
5842
###< create table crash_me10 (REPLICATION int not null)
5844
###< drop table crash_me10
5847
###As far as all queries returned OK, result is NO
5848
reserved_word_extra_require=yes # Keyword REQUIRE
5849
###< create table crash_me10 (REQUIRE int not null)
5850
###> 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 'REQUIRE int not null)' at line 1
5851
###< drop table crash_me10
5852
###> execute error:Unknown table 'crash_me10'
5854
###As far as some queries didnt return OK, result is YES
5855
reserved_word_extra_resource=no # Keyword RESOURCE
5856
###< create table crash_me10 (RESOURCE int not null)
5858
###< drop table crash_me10
5861
###As far as all queries returned OK, result is NO
5862
reserved_word_extra_restore=no # Keyword RESTORE
5863
###< create table crash_me10 (RESTORE int not null)
5865
###< drop table crash_me10
5868
###As far as all queries returned OK, result is NO
5869
reserved_word_extra_rlike=yes # Keyword RLIKE
5870
###< create table crash_me10 (RLIKE int not null)
5871
###> 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 'RLIKE int not null)' at line 1
5872
###< drop table crash_me10
5873
###> execute error:Unknown table 'crash_me10'
5875
###As far as some queries didnt return OK, result is YES
5876
reserved_word_extra_rowcount=no # Keyword ROWCOUNT
5877
###< create table crash_me10 (ROWCOUNT int not null)
5879
###< drop table crash_me10
5882
###As far as all queries returned OK, result is NO
5883
reserved_word_extra_rowguidcol=no # Keyword ROWGUIDCOL
5884
###< create table crash_me10 (ROWGUIDCOL int not null)
5886
###< drop table crash_me10
5889
###As far as all queries returned OK, result is NO
5890
reserved_word_extra_rowid=no # Keyword ROWID
5891
###< create table crash_me10 (ROWID int not null)
5893
###< drop table crash_me10
5896
###As far as all queries returned OK, result is NO
5897
reserved_word_extra_rownum=no # Keyword ROWNUM
5898
###< create table crash_me10 (ROWNUM int not null)
5900
###< drop table crash_me10
5903
###As far as all queries returned OK, result is NO
5904
reserved_word_extra_rtree=no # Keyword RTREE
5905
###< create table crash_me10 (RTREE int not null)
5907
###< drop table crash_me10
5910
###As far as all queries returned OK, result is NO
5911
reserved_word_extra_rule=no # Keyword RULE
5912
###< create table crash_me10 (RULE int not null)
5914
###< drop table crash_me10
5917
###As far as all queries returned OK, result is NO
5918
reserved_word_extra_save=no # Keyword SAVE
5919
###< create table crash_me10 (SAVE int not null)
5921
###< drop table crash_me10
5924
###As far as all queries returned OK, result is NO
5925
reserved_word_extra_setuser=no # Keyword SETUSER
5926
###< create table crash_me10 (SETUSER int not null)
5928
###< drop table crash_me10
5931
###As far as all queries returned OK, result is NO
5932
reserved_word_extra_share=no # Keyword SHARE
5933
###< create table crash_me10 (SHARE int not null)
5935
###< drop table crash_me10
5938
###As far as all queries returned OK, result is NO
5939
reserved_word_extra_show=yes # Keyword SHOW
5940
###< create table crash_me10 (SHOW int not null)
5941
###> 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 'SHOW int not null)' at line 1
5942
###< drop table crash_me10
5943
###> execute error:Unknown table 'crash_me10'
5945
###As far as some queries didnt return OK, result is YES
5946
reserved_word_extra_shutdown=no # Keyword SHUTDOWN
5947
###< create table crash_me10 (SHUTDOWN int not null)
5949
###< drop table crash_me10
5952
###As far as all queries returned OK, result is NO
5953
reserved_word_extra_soname=yes # Keyword SONAME
5954
###< create table crash_me10 (SONAME int not null)
5955
###> 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 'SONAME int not null)' at line 1
5956
###< drop table crash_me10
5957
###> execute error:Unknown table 'crash_me10'
5959
###As far as some queries didnt return OK, result is YES
5960
reserved_word_extra_spatial=yes # Keyword SPATIAL
5961
###< create table crash_me10 (SPATIAL int not null)
5962
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'int not null)' at line 1
5963
###< drop table crash_me10
5964
###> execute error:Unknown table 'crash_me10'
5966
###As far as some queries didnt return OK, result is YES
5967
reserved_word_extra_sql_big_result=yes # Keyword SQL_BIG_RESULT
5968
###< create table crash_me10 (SQL_BIG_RESULT int not null)
5969
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL_BIG_RESULT int not null)' at line 1
5970
###< drop table crash_me10
5971
###> execute error:Unknown table 'crash_me10'
5973
###As far as some queries didnt return OK, result is YES
5974
reserved_word_extra_sql_calc_found_rows=yes # Keyword SQL_CALC_FOUND_ROWS
5975
###< create table crash_me10 (SQL_CALC_FOUND_ROWS int not null)
5976
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL_CALC_FOUND_ROWS int not null)' at line 1
5977
###< drop table crash_me10
5978
###> execute error:Unknown table 'crash_me10'
5980
###As far as some queries didnt return OK, result is YES
5981
reserved_word_extra_sql_small_result=yes # Keyword SQL_SMALL_RESULT
5982
###< create table crash_me10 (SQL_SMALL_RESULT int not null)
5983
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL_SMALL_RESULT int not null)' at line 1
5984
###< drop table crash_me10
5985
###> execute error:Unknown table 'crash_me10'
5987
###As far as some queries didnt return OK, result is YES
5988
reserved_word_extra_ssl=yes # Keyword SSL
5989
###< create table crash_me10 (SSL int not null)
5990
###> 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 'SSL int not null)' at line 1
5991
###< drop table crash_me10
5992
###> execute error:Unknown table 'crash_me10'
5994
###As far as some queries didnt return OK, result is YES
5995
reserved_word_extra_starting=yes # Keyword STARTING
5996
###< create table crash_me10 (STARTING int not null)
5997
###> 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 'STARTING int not null)' at line 1
5998
###< drop table crash_me10
5999
###> execute error:Unknown table 'crash_me10'
6001
###As far as some queries didnt return OK, result is YES
6002
reserved_word_extra_statistics=no # Keyword STATISTICS
6003
###< create table crash_me10 (STATISTICS int not null)
6005
###< drop table crash_me10
6008
###As far as all queries returned OK, result is NO
6009
reserved_word_extra_straight_join=yes # Keyword STRAIGHT_JOIN
6010
###< create table crash_me10 (STRAIGHT_JOIN int not null)
6011
###> 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 'STRAIGHT_JOIN int not null)' at line 1
6012
###< drop table crash_me10
6013
###> execute error:Unknown table 'crash_me10'
6015
###As far as some queries didnt return OK, result is YES
6016
reserved_word_extra_striped=no # Keyword STRIPED
6017
###< create table crash_me10 (STRIPED int not null)
6019
###< drop table crash_me10
6022
###As far as all queries returned OK, result is NO
6023
reserved_word_extra_successful=no # Keyword SUCCESSFUL
6024
###< create table crash_me10 (SUCCESSFUL int not null)
6026
###< drop table crash_me10
6029
###As far as all queries returned OK, result is NO
6030
reserved_word_extra_synonym=no # Keyword SYNONYM
6031
###< create table crash_me10 (SYNONYM int not null)
6033
###< drop table crash_me10
6036
###As far as all queries returned OK, result is NO
6037
reserved_word_extra_sysdate=no # Keyword SYSDATE
6038
###< create table crash_me10 (SYSDATE int not null)
6040
###< drop table crash_me10
6043
###As far as all queries returned OK, result is NO
6044
reserved_word_extra_tables=yes # Keyword TABLES
6045
###< create table crash_me10 (TABLES int not null)
6046
###> 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 'TABLES int not null)' at line 1
6047
###< drop table crash_me10
6048
###> execute error:Unknown table 'crash_me10'
6050
###As far as some queries didnt return OK, result is YES
6051
reserved_word_extra_terminated=yes # Keyword TERMINATED
6052
###< create table crash_me10 (TERMINATED int not null)
6053
###> 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 'TERMINATED int not null)' at line 1
6054
###< drop table crash_me10
6055
###> execute error:Unknown table 'crash_me10'
6057
###As far as some queries didnt return OK, result is YES
6058
reserved_word_extra_textsize=no # Keyword TEXTSIZE
6059
###< create table crash_me10 (TEXTSIZE int not null)
6061
###< drop table crash_me10
6064
###As far as all queries returned OK, result is NO
6065
reserved_word_extra_tinyblob=yes # Keyword TINYBLOB
6066
###< create table crash_me10 (TINYBLOB int not null)
6067
###> 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 'TINYBLOB int not null)' at line 1
6068
###< drop table crash_me10
6069
###> execute error:Unknown table 'crash_me10'
6071
###As far as some queries didnt return OK, result is YES
6072
reserved_word_extra_tinyint=yes # Keyword TINYINT
6073
###< create table crash_me10 (TINYINT int not null)
6074
###> 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 'TINYINT int not null)' at line 1
6075
###< drop table crash_me10
6076
###> execute error:Unknown table 'crash_me10'
6078
###As far as some queries didnt return OK, result is YES
6079
reserved_word_extra_tinytext=yes # Keyword TINYTEXT
6080
###< create table crash_me10 (TINYTEXT int not null)
6081
###> 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 'TINYTEXT int not null)' at line 1
6082
###< drop table crash_me10
6083
###> execute error:Unknown table 'crash_me10'
6085
###As far as some queries didnt return OK, result is YES
6086
reserved_word_extra_top=no # Keyword TOP
6087
###< create table crash_me10 (TOP int not null)
6089
###< drop table crash_me10
6092
###As far as all queries returned OK, result is NO
6093
reserved_word_extra_tran=no # Keyword TRAN
6094
###< create table crash_me10 (TRAN int not null)
6096
###< drop table crash_me10
6099
###As far as all queries returned OK, result is NO
6100
reserved_word_extra_truncate=no # Keyword TRUNCATE
6101
###< create table crash_me10 (TRUNCATE int not null)
6103
###< drop table crash_me10
6106
###As far as all queries returned OK, result is NO
6107
reserved_word_extra_tsequal=no # Keyword TSEQUAL
6108
###< create table crash_me10 (TSEQUAL int not null)
6110
###< drop table crash_me10
6113
###As far as all queries returned OK, result is NO
6114
reserved_word_extra_types=no # Keyword TYPES
6115
###< create table crash_me10 (TYPES int not null)
6117
###< drop table crash_me10
6120
###As far as all queries returned OK, result is NO
6121
reserved_word_extra_uid=no # Keyword UID
6122
###< create table crash_me10 (UID int not null)
6124
###< drop table crash_me10
6127
###As far as all queries returned OK, result is NO
6128
reserved_word_extra_unlock=yes # Keyword UNLOCK
6129
###< create table crash_me10 (UNLOCK int not null)
6130
###> 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 'UNLOCK int not null)' at line 1
6131
###< drop table crash_me10
6132
###> execute error:Unknown table 'crash_me10'
6134
###As far as some queries didnt return OK, result is YES
6135
reserved_word_extra_unsigned=yes # Keyword UNSIGNED
6136
###< create table crash_me10 (UNSIGNED int not null)
6137
###> 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 'UNSIGNED int not null)' at line 1
6138
###< drop table crash_me10
6139
###> execute error:Unknown table 'crash_me10'
6141
###As far as some queries didnt return OK, result is YES
6142
reserved_word_extra_updatetext=no # Keyword UPDATETEXT
6143
###< create table crash_me10 (UPDATETEXT int not null)
6145
###< drop table crash_me10
6148
###As far as all queries returned OK, result is NO
6149
reserved_word_extra_use=yes # Keyword USE
6150
###< create table crash_me10 (USE int not null)
6151
###> 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 'USE int not null)' at line 1
6152
###< drop table crash_me10
6153
###> execute error:Unknown table 'crash_me10'
6155
###As far as some queries didnt return OK, result is YES
6156
reserved_word_extra_user_resources=no # Keyword USER_RESOURCES
6157
###< create table crash_me10 (USER_RESOURCES int not null)
6159
###< drop table crash_me10
6162
###As far as all queries returned OK, result is NO
6163
reserved_word_extra_validate=no # Keyword VALIDATE
6164
###< create table crash_me10 (VALIDATE int not null)
6166
###< drop table crash_me10
6169
###As far as all queries returned OK, result is NO
6170
reserved_word_extra_varbinary=yes # Keyword VARBINARY
6171
###< create table crash_me10 (VARBINARY int not null)
6172
###> 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 'VARBINARY int not null)' at line 1
6173
###< drop table crash_me10
6174
###> execute error:Unknown table 'crash_me10'
6176
###As far as some queries didnt return OK, result is YES
6177
reserved_word_extra_varchar2=no # Keyword VARCHAR2
6178
###< create table crash_me10 (VARCHAR2 int not null)
6180
###< drop table crash_me10
6183
###As far as all queries returned OK, result is NO
6184
reserved_word_extra_waitfor=no # Keyword WAITFOR
6185
###< create table crash_me10 (WAITFOR int not null)
6187
###< drop table crash_me10
6190
###As far as all queries returned OK, result is NO
6191
reserved_word_extra_warnings=no # Keyword WARNINGS
6192
###< create table crash_me10 (WARNINGS int not null)
6194
###< drop table crash_me10
6197
###As far as all queries returned OK, result is NO
6198
reserved_word_extra_writetext=no # Keyword WRITETEXT
6199
###< create table crash_me10 (WRITETEXT int not null)
6201
###< drop table crash_me10
6204
###As far as all queries returned OK, result is NO
6205
reserved_word_extra_xor=yes # Keyword XOR
6206
###< create table crash_me10 (XOR int not null)
6207
###> 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 'XOR int not null)' at line 1
6208
###< drop table crash_me10
6209
###> execute error:Unknown table 'crash_me10'
6211
###As far as some queries didnt return OK, result is YES
6212
reserved_word_extra_year_month=yes # Keyword YEAR_MONTH
6213
###< create table crash_me10 (YEAR_MONTH int not null)
6214
###> 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 'YEAR_MONTH int not null)' at line 1
6215
###< drop table crash_me10
6216
###> execute error:Unknown table 'crash_me10'
6218
###As far as some queries didnt return OK, result is YES
6219
reserved_word_extra_zerofill=yes # Keyword ZEROFILL
6220
###< create table crash_me10 (ZEROFILL int not null)
6221
###> 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 'ZEROFILL int not null)' at line 1
6222
###< drop table crash_me10
6223
###> execute error:Unknown table 'crash_me10'
6225
###As far as some queries didnt return OK, result is YES
6226
right_outer_join=yes # right outer join
6227
###< select crash_me.a from crash_me right join crash_me2 ON crash_me.a=crash_me2.a
6230
###As far as all queries returned OK, result is YES
6231
rollback_metadata=no # rollback_metadata
6232
###< create table crash_q (a integer not null)
6235
###< insert into crash_q values (1)
6237
rowid=auto_increment # Type for row id
6238
###< create table crash_q (a rowid)
6239
###> 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
6240
###< drop table crash_q
6241
###> execute error:Unknown table 'crash_q'
6243
###< create table crash_q (a int not null auto_increment, primary key(a))
6245
###< drop table crash_q
6247
safe_decimal_arithmetic=no # safe decimal arithmetic
6248
###< create table crash_me_a (a decimal(10,2),b decimal(10,2))
6251
###< insert into crash_me_a (a,b) values (11.4,18.9)
6254
###<select count(*) from crash_me_a where a+b=30.3
6256
###We expected '1' but got '0'
6257
select_constants=yes # Select constants
6261
###As far as all queries returned OK, result is YES
6262
select_limit=with LIMIT # LIMIT number of rows
6263
###< select * from crash_me limit 1
6265
select_limit2=yes # SELECT with LIMIT #,#
6266
###< select * from crash_me limit 1,1
6269
###As far as all queries returned OK, result is YES
6270
select_limit3=yes # SELECT with LIMIT # OFFSET #
6271
###< select * from crash_me limit 1 offset 1
6274
###As far as all queries returned OK, result is YES
6275
select_string_size=1048565 # constant string size in SELECT
6276
###We are trying (example with N=5):
6278
select_table_update=yes # Update with sub select
6279
###< create table crash_q (a integer,b char(10))
6281
###< insert into crash_q values(1,'c')
6283
###< update crash_q set b= (select b from crash_me where crash_q.a = crash_me.a)
6286
###<select b from crash_q
6289
###< drop table crash_q
6291
select_without_from=yes # SELECT without FROM
6295
###As far as all queries returned OK, result is YES
6296
server_version=MySQL 5.0.0 alpha debug log/ # server version
6297
simple_joins=yes # ANSI SQL simple joins
6298
###< select crash_me.a from crash_me, crash_me t0
6301
###As far as all queries returned OK, result is YES
6302
sorted_group_by=yes # Group by always sorted
6303
###< create table crash_me_t1 (a int not null, b int not null)
6305
###< insert into crash_me_t1 values (1,1)
6307
###< insert into crash_me_t1 values (1,2)
6309
###< insert into crash_me_t1 values (3,1)
6311
###< insert into crash_me_t1 values (3,2)
6313
###< insert into crash_me_t1 values (2,2)
6315
###< insert into crash_me_t1 values (2,1)
6317
###< create table crash_me_t2 (a int not null, b int not null)
6319
###< create index crash_me_t2_ind on crash_me_t2 (a)
6321
###< insert into crash_me_t2 values (1,3)
6323
###< insert into crash_me_t2 values (3,1)
6325
###< insert into crash_me_t2 values (2,2)
6327
###< insert into crash_me_t2 values (1,1)
6330
###< select crash_me_t1.a,crash_me_t2.b from crash_me_t1,crash_me_t2 where crash_me_t1.a=crash_me_t2.a group by crash_me_t1.a,crash_me_t2.b
6336
### Check recordset:
6337
### 1,1 expected: 1,1
6338
### 1,3 expected: 1,3
6339
### 2,2 expected: 2,2
6340
### 3,1 expected: 3,1
6341
### Recordset corresponds with template
6342
###< drop table crash_me_t1
6344
###< drop table crash_me_t2
6346
storage_of_float=round # Storage of float values
6347
###< create table crash_q (q1 float(4,1))
6349
###< insert into crash_q values(1.14)
6352
###<select q1 from crash_q
6355
###< drop table crash_q
6358
###< create table crash_q (q1 float(4,1))
6360
###< insert into crash_q values(1.16)
6363
###<select q1 from crash_q
6365
###We expected '1.1' but got '1.2'
6367
###< drop table crash_q
6370
###< create table crash_q (q1 float(4,1))
6372
###< insert into crash_q values(1.14)
6375
###<select q1 from crash_q
6378
###< drop table crash_q
6381
###< create table crash_q (q1 float(4,1))
6383
###< insert into crash_q values(1.16)
6386
###<select q1 from crash_q
6389
###< drop table crash_q
6391
subqueries=yes # subqueries
6392
###< select a from crash_me where crash_me.a in (select max(a) from crash_me)
6395
###As far as all queries returned OK, result is YES
6396
table_alias=yes # Table alias
6397
###< select b.a from crash_me as b
6400
###As far as all queries returned OK, result is YES
6401
table_name_case=no # case independent table names
6402
###< create table crash_q (q integer)
6404
###< drop table CRASH_Q
6405
###> execute error:Unknown table 'CRASH_Q'
6407
###As far as some queries didnt return OK, result is NO
6408
table_wildcard=yes # Select table_name.*
6409
###< select crash_me.* from crash_me
6412
###As far as all queries returned OK, result is YES
6413
temporary_table=yes # temporary tables
6414
###< create temporary table crash_q (q integer not null)
6416
###< drop table crash_q
6419
###As far as all queries returned OK, result is YES
6420
time_format_EUR=error # Supports HH.MM.SS (EUR) time format
6421
###< insert into crash_me_t(a) values ('20.08.16')
6424
###<select a from crash_me_t
6426
###We expected '20:08:16' but got '00:00:20'
6428
###< delete from crash_me_t
6430
time_format_HHHHMMSS=yes # Supports HHHHmmSS time format
6431
###< insert into crash_me_t(a) values ('00200816')
6434
###<select a from crash_me_t
6437
###< delete from crash_me_t
6439
time_format_ISO=yes # Supports HH:MM:SS (ISO) time format
6440
###< insert into crash_me_t(a) values ('20:08:16')
6443
###<select a from crash_me_t
6446
###< delete from crash_me_t
6448
time_format_USA=error # Supports HH:MM:SS (AM|PM) time format
6449
###< insert into crash_me_t(a) values ('08:08:16 PM')
6452
###<select a from crash_me_t
6454
###We expected '20:08:16' but got '08:08:16'
6456
###< delete from crash_me_t
6458
time_format_inresult=iso # Time format in result
6459
###< insert into crash_me_t values(CURRENT_TIME)
6462
###< select a from crash_me_t
6464
###< delete from crash_me_t
6466
transactions=yes # transactions
6467
###<select * from crash_q
6469
###We expected '' but got '1'
6470
truncate_table=yes # truncate
6471
###< create table crash_q (a integer, b integer,c1 CHAR(10))
6473
###< truncate table crash_q
6475
###< drop table crash_q
6478
###As far as all queries returned OK, result is YES
6479
type_extra_abstime=no # Type abstime
6480
###< create table crash_q (q abstime)
6481
###> 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
6482
###< drop table crash_q
6483
###> execute error:Unknown table 'crash_q'
6485
###As far as some queries didnt return OK, result is NO
6486
type_extra_bfile=no # Type bfile
6487
###< create table crash_q (q bfile)
6488
###> 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
6489
###< drop table crash_q
6490
###> execute error:Unknown table 'crash_q'
6492
###As far as some queries didnt return OK, result is NO
6493
type_extra_blob=yes # Type blob
6494
###< create table crash_q (q blob)
6496
###< drop table crash_q
6499
###As far as all queries returned OK, result is YES
6500
type_extra_bool=yes # Type bool
6501
###< create table crash_q (q bool)
6503
###< drop table crash_q
6506
###As far as all queries returned OK, result is YES
6507
type_extra_box=no # Type box
6508
###< create table crash_q (q box)
6509
###> 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
6510
###< drop table crash_q
6511
###> execute error:Unknown table 'crash_q'
6513
###As far as some queries didnt return OK, result is NO
6514
type_extra_byte=no # Type byte
6515
###< create table crash_q (q byte)
6516
###> 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
6517
###< drop table crash_q
6518
###> execute error:Unknown table 'crash_q'
6520
###As far as some queries didnt return OK, result is NO
6521
type_extra_char(1_arg)_binary=yes # Type char(1 arg) binary
6522
###< create table crash_q (q char(10) binary)
6524
###< drop table crash_q
6527
###As far as all queries returned OK, result is YES
6528
type_extra_cidr=no # Type cidr
6529
###< create table crash_q (q cidr)
6530
###> 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
6531
###< drop table crash_q
6532
###> execute error:Unknown table 'crash_q'
6534
###As far as some queries didnt return OK, result is NO
6535
type_extra_circle=no # Type circle
6536
###< create table crash_q (q circle)
6537
###> 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
6538
###< drop table crash_q
6539
###> execute error:Unknown table 'crash_q'
6541
###As far as some queries didnt return OK, result is NO
6542
type_extra_clob=no # Type clob
6543
###< create table crash_q (q clob)
6544
###> 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
6545
###< drop table crash_q
6546
###> execute error:Unknown table 'crash_q'
6548
###As far as some queries didnt return OK, result is NO
6549
type_extra_datetime=yes # Type datetime
6550
###< create table crash_q (q datetime)
6552
###< drop table crash_q
6555
###As far as all queries returned OK, result is YES
6556
type_extra_double=yes # Type double
6557
###< create table crash_q (q double)
6559
###< drop table crash_q
6562
###As far as all queries returned OK, result is YES
6563
type_extra_enum(1_arg)=yes # Type enum(1 arg)
6564
###< create table crash_q (q enum('red'))
6566
###< drop table crash_q
6569
###As far as all queries returned OK, result is YES
6570
type_extra_float(2_arg)=yes # Type float(2 arg)
6571
###< create table crash_q (q float(6,2))
6573
###< drop table crash_q
6576
###As far as all queries returned OK, result is YES
6577
type_extra_float4=yes # Type float4
6578
###< create table crash_q (q float4)
6580
###< drop table crash_q
6583
###As far as all queries returned OK, result is YES
6584
type_extra_float8=yes # Type float8
6585
###< create table crash_q (q float8)
6587
###< drop table crash_q
6590
###As far as all queries returned OK, result is YES
6591
type_extra_image=no # Type image
6592
###< create table crash_q (q image)
6593
###> 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
6594
###< drop table crash_q
6595
###> execute error:Unknown table 'crash_q'
6597
###As far as some queries didnt return OK, result is NO
6598
type_extra_inet=no # Type inet
6599
###< create table crash_q (q inet)
6600
###> 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
6601
###< drop table crash_q
6602
###> execute error:Unknown table 'crash_q'
6604
###As far as some queries didnt return OK, result is NO
6605
type_extra_int(1_arg)_zerofill=yes # Type int(1 arg) zerofill
6606
###< create table crash_q (q int(5) zerofill)
6608
###< drop table crash_q
6611
###As far as all queries returned OK, result is YES
6612
type_extra_int1=yes # Type int1
6613
###< create table crash_q (q int1)
6615
###< drop table crash_q
6618
###As far as all queries returned OK, result is YES
6619
type_extra_int2=yes # Type int2
6620
###< create table crash_q (q int2)
6622
###< drop table crash_q
6625
###As far as all queries returned OK, result is YES
6626
type_extra_int3=yes # Type int3
6627
###< create table crash_q (q int3)
6629
###< drop table crash_q
6632
###As far as all queries returned OK, result is YES
6633
type_extra_int4=yes # Type int4
6634
###< create table crash_q (q int4)
6636
###< drop table crash_q
6639
###As far as all queries returned OK, result is YES
6640
type_extra_int8=yes # Type int8
6641
###< create table crash_q (q int8)
6643
###< drop table crash_q
6646
###As far as all queries returned OK, result is YES
6647
type_extra_int_auto_increment=yes # Type int not null auto_increment
6648
###< create table crash_q (q int not null auto_increment,unique(q))
6650
###< drop table crash_q
6653
###As far as all queries returned OK, result is YES
6654
type_extra_int_identity=no # Type int not null identity
6655
###< create table crash_q (q int not null identity,unique(q))
6656
###> 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
6657
###< drop table crash_q
6658
###> execute error:Unknown table 'crash_q'
6660
###As far as some queries didnt return OK, result is NO
6661
type_extra_int_unsigned=yes # Type int unsigned
6662
###< create table crash_q (q int unsigned)
6664
###< drop table crash_q
6667
###As far as all queries returned OK, result is YES
6668
type_extra_interval=no # Type interval
6669
###< create table crash_q (q interval)
6670
###> 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
6671
###< drop table crash_q
6672
###> execute error:Unknown table 'crash_q'
6674
###As far as some queries didnt return OK, result is NO
6675
type_extra_line=no # Type line
6676
###< create table crash_q (q line)
6677
###> 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
6678
###< drop table crash_q
6679
###> execute error:Unknown table 'crash_q'
6681
###As far as some queries didnt return OK, result is NO
6682
type_extra_long=yes # Type long
6683
###< create table crash_q (q long)
6685
###< drop table crash_q
6688
###As far as all queries returned OK, result is YES
6689
type_extra_long_raw=no # Type long raw
6690
###< create table crash_q (q long raw)
6691
###> 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
6692
###< drop table crash_q
6693
###> execute error:Unknown table 'crash_q'
6695
###As far as some queries didnt return OK, result is NO
6696
type_extra_long_varbinary=yes # Type long varbinary
6697
###< create table crash_q (q long varbinary)
6699
###< drop table crash_q
6702
###As far as all queries returned OK, result is YES
6703
type_extra_long_varchar(1_arg)=no # Type long varchar(1 arg)
6704
###< create table crash_q (q long varchar(1))
6705
###> 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
6706
###< drop table crash_q
6707
###> execute error:Unknown table 'crash_q'
6709
###As far as some queries didnt return OK, result is NO
6710
type_extra_lseg=no # Type lseg
6711
###< create table crash_q (q lseg)
6712
###> 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
6713
###< drop table crash_q
6714
###> execute error:Unknown table 'crash_q'
6716
###As far as some queries didnt return OK, result is NO
6717
type_extra_macaddr=no # Type macaddr
6718
###< create table crash_q (q macaddr)
6719
###> 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
6720
###< drop table crash_q
6721
###> execute error:Unknown table 'crash_q'
6723
###As far as some queries didnt return OK, result is NO
6724
type_extra_mediumint=yes # Type mediumint
6725
###< create table crash_q (q mediumint)
6727
###< drop table crash_q
6730
###As far as all queries returned OK, result is YES
6731
type_extra_mediumtext=yes # Type mediumtext
6732
###< create table crash_q (q mediumtext)
6734
###< drop table crash_q
6737
###As far as all queries returned OK, result is YES
6738
type_extra_middleint=yes # Type middleint
6739
###< create table crash_q (q middleint)
6741
###< drop table crash_q
6744
###As far as all queries returned OK, result is YES
6745
type_extra_mlslabel=no # Type mlslabel
6746
###< create table crash_q (q mlslabel)
6747
###> 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
6748
###< drop table crash_q
6749
###> execute error:Unknown table 'crash_q'
6751
###As far as some queries didnt return OK, result is NO
6752
type_extra_money=no # Type money
6753
###< create table crash_q (q money)
6754
###> 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
6755
###< drop table crash_q
6756
###> execute error:Unknown table 'crash_q'
6758
###As far as some queries didnt return OK, result is NO
6759
type_extra_nclob=no # Type nclob
6760
###< create table crash_q (q nclob)
6761
###> 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
6762
###< drop table crash_q
6763
###> execute error:Unknown table 'crash_q'
6765
###As far as some queries didnt return OK, result is NO
6766
type_extra_number=no # Type number
6767
###< create table crash_q (q number)
6768
###> 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
6769
###< drop table crash_q
6770
###> execute error:Unknown table 'crash_q'
6772
###As far as some queries didnt return OK, result is NO
6773
type_extra_number(1_arg)=no # Type number(1 arg)
6774
###< create table crash_q (q number(9))
6775
###> 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
6776
###< drop table crash_q
6777
###> execute error:Unknown table 'crash_q'
6779
###As far as some queries didnt return OK, result is NO
6780
type_extra_number(2_arg)=no # Type number(2 arg)
6781
###< create table crash_q (q number(9,2))
6782
###> 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
6783
###< drop table crash_q
6784
###> execute error:Unknown table 'crash_q'
6786
###As far as some queries didnt return OK, result is NO
6787
type_extra_nvarchar2(1_arg)=no # Type nvarchar2(1 arg)
6788
###< create table crash_q (q nvarchar2(16))
6789
###> 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
6790
###< drop table crash_q
6791
###> execute error:Unknown table 'crash_q'
6793
###As far as some queries didnt return OK, result is NO
6794
type_extra_path=no # Type path
6795
###< create table crash_q (q path)
6796
###> 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
6797
###< drop table crash_q
6798
###> execute error:Unknown table 'crash_q'
6800
###As far as some queries didnt return OK, result is NO
6801
type_extra_point=yes # Type point
6802
###< create table crash_q (q point)
6804
###< drop table crash_q
6807
###As far as all queries returned OK, result is YES
6808
type_extra_polygon=yes # Type polygon
6809
###< create table crash_q (q polygon)
6811
###< drop table crash_q
6814
###As far as all queries returned OK, result is YES
6815
type_extra_raw(1_arg)=no # Type raw(1 arg)
6816
###< create table crash_q (q raw(16))
6817
###> 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
6818
###< drop table crash_q
6819
###> execute error:Unknown table 'crash_q'
6821
###As far as some queries didnt return OK, result is NO
6822
type_extra_reltime=no # Type reltime
6823
###< create table crash_q (q reltime)
6824
###> 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
6825
###< drop table crash_q
6826
###> execute error:Unknown table 'crash_q'
6828
###As far as some queries didnt return OK, result is NO
6829
type_extra_rowid=no # Type rowid
6830
###< create table crash_q (q rowid)
6831
###> 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
6832
###< drop table crash_q
6833
###> execute error:Unknown table 'crash_q'
6835
###As far as some queries didnt return OK, result is NO
6836
type_extra_serial=yes # Type serial
6837
###< create table crash_q (q serial)
6839
###< drop table crash_q
6842
###As far as all queries returned OK, result is YES
6843
type_extra_set(1_arg)=yes # Type set(1 arg)
6844
###< create table crash_q (q set('red'))
6846
###< drop table crash_q
6849
###As far as all queries returned OK, result is YES
6850
type_extra_smalldatetime=no # Type smalldatetime
6851
###< create table crash_q (q smalldatetime)
6852
###> 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
6853
###< drop table crash_q
6854
###> execute error:Unknown table 'crash_q'
6856
###As far as some queries didnt return OK, result is NO
6857
type_extra_smallfloat=no # Type smallfloat
6858
###< create table crash_q (q smallfloat)
6859
###> 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
6860
###< drop table crash_q
6861
###> execute error:Unknown table 'crash_q'
6863
###As far as some queries didnt return OK, result is NO
6864
type_extra_smallmoney=no # Type smallmoney
6865
###< create table crash_q (q smallmoney)
6866
###> 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
6867
###< drop table crash_q
6868
###> execute error:Unknown table 'crash_q'
6870
###As far as some queries didnt return OK, result is NO
6871
type_extra_text=yes # Type text
6872
###< create table crash_q (q text)
6874
###< drop table crash_q
6877
###As far as all queries returned OK, result is YES
6878
type_extra_text(1_arg)=yes # Type text(1 arg)
6879
###< create table crash_q (q text(10))
6881
###< drop table crash_q
6884
###As far as all queries returned OK, result is YES
6885
type_extra_timespan=no # Type timespan
6886
###< create table crash_q (q timespan)
6887
###> 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
6888
###< drop table crash_q
6889
###> execute error:Unknown table 'crash_q'
6891
###As far as some queries didnt return OK, result is NO
6892
type_extra_uint=no # Type uint
6893
###< create table crash_q (q uint)
6894
###> 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
6895
###< drop table crash_q
6896
###> execute error:Unknown table 'crash_q'
6898
###As far as some queries didnt return OK, result is NO
6899
type_extra_varchar2(1_arg)=no # Type varchar2(1 arg)
6900
###< create table crash_q (q varchar2(257))
6901
###> 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
6902
###< drop table crash_q
6903
###> execute error:Unknown table 'crash_q'
6905
###As far as some queries didnt return OK, result is NO
6906
type_extra_year=yes # Type year
6907
###< create table crash_q (q year)
6909
###< drop table crash_q
6912
###As far as all queries returned OK, result is YES
6913
type_odbc_bigint=yes # Type bigint
6914
###< create table crash_q (q bigint)
6916
###< drop table crash_q
6919
###As far as all queries returned OK, result is YES
6920
type_odbc_binary(1_arg)=yes # Type binary(1 arg)
6921
###< create table crash_q (q binary(1))
6923
###< drop table crash_q
6926
###As far as all queries returned OK, result is YES
6927
type_odbc_datetime=yes # Type datetime
6928
###< create table crash_q (q datetime)
6930
###< drop table crash_q
6933
###As far as all queries returned OK, result is YES
6934
type_odbc_tinyint=yes # Type tinyint
6935
###< create table crash_q (q tinyint)
6937
###< drop table crash_q
6940
###As far as all queries returned OK, result is YES
6941
type_odbc_varbinary(1_arg)=yes # Type varbinary(1 arg)
6942
###< create table crash_q (q varbinary(1))
6944
###< drop table crash_q
6947
###As far as all queries returned OK, result is YES
6948
type_sql_bit=yes # Type bit
6949
###< create table crash_q (q bit)
6951
###< drop table crash_q
6954
###As far as all queries returned OK, result is YES
6955
type_sql_bit(1_arg)=yes # Type bit(1 arg)
6956
###< create table crash_q (q bit(2))
6958
###< drop table crash_q
6961
###As far as all queries returned OK, result is YES
6962
type_sql_bit_varying(1_arg)=no # Type bit varying(1 arg)
6963
###< create table crash_q (q bit varying(2))
6964
###> 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
6965
###< drop table crash_q
6966
###> execute error:Unknown table 'crash_q'
6968
###As far as some queries didnt return OK, result is NO
6969
type_sql_boolean=yes # Type boolean
6970
###< create table crash_q (q boolean)
6972
###< drop table crash_q
6975
###As far as all queries returned OK, result is YES
6976
type_sql_char(1_arg)=yes # Type char(1 arg)
6977
###< create table crash_q (q char(1))
6979
###< drop table crash_q
6982
###As far as all queries returned OK, result is YES
6983
type_sql_char_varying(1_arg)=yes # Type char varying(1 arg)
6984
###< create table crash_q (q char varying(1))
6986
###< drop table crash_q
6989
###As far as all queries returned OK, result is YES
6990
type_sql_character(1_arg)=yes # Type character(1 arg)
6991
###< create table crash_q (q character(1))
6993
###< drop table crash_q
6996
###As far as all queries returned OK, result is YES
6997
type_sql_character_varying(1_arg)=yes # Type character varying(1 arg)
6998
###< create table crash_q (q character varying(1))
7000
###< drop table crash_q
7003
###As far as all queries returned OK, result is YES
7004
type_sql_date=yes # Type date
7005
###< create table crash_q (q date)
7007
###< drop table crash_q
7010
###As far as all queries returned OK, result is YES
7011
type_sql_dec(2_arg)=yes # Type dec(2 arg)
7012
###< create table crash_q (q dec(6,2))
7014
###< drop table crash_q
7017
###As far as all queries returned OK, result is YES
7018
type_sql_decimal(2_arg)=yes # Type decimal(2 arg)
7019
###< create table crash_q (q decimal(6,2))
7021
###< drop table crash_q
7024
###As far as all queries returned OK, result is YES
7025
type_sql_double_precision=yes # Type double precision
7026
###< create table crash_q (q double precision)
7028
###< drop table crash_q
7031
###As far as all queries returned OK, result is YES
7032
type_sql_float=yes # Type float
7033
###< create table crash_q (q float)
7035
###< drop table crash_q
7038
###As far as all queries returned OK, result is YES
7039
type_sql_float(1_arg)=yes # Type float(1 arg)
7040
###< create table crash_q (q float(8))
7042
###< drop table crash_q
7045
###As far as all queries returned OK, result is YES
7046
type_sql_int=yes # Type int
7047
###< create table crash_q (q int)
7049
###< drop table crash_q
7052
###As far as all queries returned OK, result is YES
7053
type_sql_integer=yes # Type integer
7054
###< create table crash_q (q integer)
7056
###< drop table crash_q
7059
###As far as all queries returned OK, result is YES
7060
type_sql_interval_day=no # Type interval day
7061
###< create table crash_q (q interval day)
7062
###> 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
7063
###< drop table crash_q
7064
###> execute error:Unknown table 'crash_q'
7066
###As far as some queries didnt return OK, result is NO
7067
type_sql_interval_day_to_hour=no # Type interval day to hour
7068
###< create table crash_q (q interval day to hour)
7069
###> 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
7070
###< drop table crash_q
7071
###> execute error:Unknown table 'crash_q'
7073
###As far as some queries didnt return OK, result is NO
7074
type_sql_interval_day_to_minute=no # Type interval day to minute
7075
###< create table crash_q (q interval day to minute)
7076
###> 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
7077
###< drop table crash_q
7078
###> execute error:Unknown table 'crash_q'
7080
###As far as some queries didnt return OK, result is NO
7081
type_sql_interval_day_to_second=no # Type interval day to second
7082
###< create table crash_q (q interval day to second)
7083
###> 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
7084
###< drop table crash_q
7085
###> execute error:Unknown table 'crash_q'
7087
###As far as some queries didnt return OK, result is NO
7088
type_sql_interval_hour=no # Type interval hour
7089
###< create table crash_q (q interval hour)
7090
###> 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
7091
###< drop table crash_q
7092
###> execute error:Unknown table 'crash_q'
7094
###As far as some queries didnt return OK, result is NO
7095
type_sql_interval_hour_to_minute=no # Type interval hour to minute
7096
###< create table crash_q (q interval hour to minute)
7097
###> 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
7098
###< drop table crash_q
7099
###> execute error:Unknown table 'crash_q'
7101
###As far as some queries didnt return OK, result is NO
7102
type_sql_interval_hour_to_second=no # Type interval hour to second
7103
###< create table crash_q (q interval hour to second)
7104
###> 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
7105
###< drop table crash_q
7106
###> execute error:Unknown table 'crash_q'
7108
###As far as some queries didnt return OK, result is NO
7109
type_sql_interval_minute=no # Type interval minute
7110
###< create table crash_q (q interval minute)
7111
###> 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
7112
###< drop table crash_q
7113
###> execute error:Unknown table 'crash_q'
7115
###As far as some queries didnt return OK, result is NO
7116
type_sql_interval_minute_to_second=no # Type interval minute to second
7117
###< create table crash_q (q interval minute to second)
7118
###> 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
7119
###< drop table crash_q
7120
###> execute error:Unknown table 'crash_q'
7122
###As far as some queries didnt return OK, result is NO
7123
type_sql_interval_month=no # Type interval month
7124
###< create table crash_q (q interval month)
7125
###> 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
7126
###< drop table crash_q
7127
###> execute error:Unknown table 'crash_q'
7129
###As far as some queries didnt return OK, result is NO
7130
type_sql_interval_second=no # Type interval second
7131
###< create table crash_q (q interval second)
7132
###> 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
7133
###< drop table crash_q
7134
###> execute error:Unknown table 'crash_q'
7136
###As far as some queries didnt return OK, result is NO
7137
type_sql_interval_year=no # Type interval year
7138
###< create table crash_q (q interval year)
7139
###> 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
7140
###< drop table crash_q
7141
###> execute error:Unknown table 'crash_q'
7143
###As far as some queries didnt return OK, result is NO
7144
type_sql_interval_year_to_month=no # Type interval year to month
7145
###< create table crash_q (q interval year to month)
7146
###> 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
7147
###< drop table crash_q
7148
###> execute error:Unknown table 'crash_q'
7150
###As far as some queries didnt return OK, result is NO
7151
type_sql_national_char_varying(1_arg)=yes # Type national char varying(1 arg)
7152
###< create table crash_q (q national char varying(20))
7154
###< drop table crash_q
7157
###As far as all queries returned OK, result is YES
7158
type_sql_national_character(1_arg)=yes # Type national character(1 arg)
7159
###< create table crash_q (q national character(20))
7161
###< drop table crash_q
7164
###As far as all queries returned OK, result is YES
7165
type_sql_national_character_varying(1_arg)=yes # Type national character varying(1 arg)
7166
###< create table crash_q (q national character varying(20))
7168
###< drop table crash_q
7171
###As far as all queries returned OK, result is YES
7172
type_sql_nchar(1_arg)=yes # Type nchar(1 arg)
7173
###< create table crash_q (q nchar(1))
7175
###< drop table crash_q
7178
###As far as all queries returned OK, result is YES
7179
type_sql_nchar_varying(1_arg)=yes # Type nchar varying(1 arg)
7180
###< create table crash_q (q nchar varying(20))
7182
###< drop table crash_q
7185
###As far as all queries returned OK, result is YES
7186
type_sql_numeric(2_arg)=yes # Type numeric(2 arg)
7187
###< create table crash_q (q numeric(9,2))
7189
###< drop table crash_q
7192
###As far as all queries returned OK, result is YES
7193
type_sql_real=yes # Type real
7194
###< create table crash_q (q real)
7196
###< drop table crash_q
7199
###As far as all queries returned OK, result is YES
7200
type_sql_smallint=yes # Type smallint
7201
###< create table crash_q (q smallint)
7203
###< drop table crash_q
7206
###As far as all queries returned OK, result is YES
7207
type_sql_time=yes # Type time
7208
###< create table crash_q (q time)
7210
###< drop table crash_q
7213
###As far as all queries returned OK, result is YES
7214
type_sql_timestamp=yes # Type timestamp
7215
###< create table crash_q (q timestamp)
7217
###< drop table crash_q
7220
###As far as all queries returned OK, result is YES
7221
type_sql_timestamp_with_time_zone=no # Type timestamp with time zone
7222
###< create table crash_q (q timestamp with time zone)
7223
###> 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
7224
###< drop table crash_q
7225
###> execute error:Unknown table 'crash_q'
7227
###As far as some queries didnt return OK, result is NO
7228
type_sql_varchar(1_arg)=yes # Type varchar(1 arg)
7229
###< create table crash_q (q varchar(1))
7231
###< drop table crash_q
7234
###As far as all queries returned OK, result is YES
7236
###< select * from crash_me union select a,b from crash_me3
7239
###As far as all queries returned OK, result is YES
7240
union_all=yes # union all
7241
###< select * from crash_me union all select a,b from crash_me3
7244
###As far as all queries returned OK, result is YES
7245
union_all_incompat=yes # union all (incompatible lists)
7246
###< select * from crash_me union all select a,b from crash_me2
7249
###As far as all queries returned OK, result is YES
7250
union_incompat=yes # union (incompatible lists)
7251
###< select * from crash_me union select a,b from crash_me2
7254
###As far as all queries returned OK, result is YES
7255
unique_in_create=yes # unique in create table
7256
###< create table crash_q (q integer not null,unique (q))
7258
###< drop table crash_q
7261
###As far as all queries returned OK, result is YES
7262
unique_null_in_create=yes # unique null in create
7263
###< create table crash_q (q integer,unique (q))
7265
###< insert into crash_q (q) values (NULL)
7267
###< insert into crash_q (q) values (NULL)
7269
###< insert into crash_q (q) values (1)
7271
###< drop table crash_q
7274
###As far as all queries returned OK, result is YES
7275
value_of_false=0 # Value of FALSE
7278
value_of_true=1 # Value of TRUE
7282
###< create view crash_q as select a from crash_me
7283
###> 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
7284
###< drop view crash_q
7285
###> 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
7287
###As far as some queries didnt return OK, result is NO
7288
where_string_size=1048539 # constant string size in where
7289
###We are trying (example with N=5):
7290
###select a from crash_me where b >='11111'
added
removed
tests/sql-bench/limits/mysql-4.0.cfg
