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
alter_add_col=yes # Alter table add column
17
###< alter table crash_q add d integer
20
###As far as all queries returned OK, result is YES
21
alter_add_constraint=yes # Alter table add constraint
22
###< alter table crash_q add constraint c2 check(a > b)
25
###As far as all queries returned OK, result is YES
26
alter_add_foreign_key=no # Alter table add foreign key
27
###< alter table crash_q add constraint f1 foreign key(c1)
28
###> execute error:You 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
29
###< references crash_q1(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 'references crash_q1(c1)' at line 1
32
###As far as some queries didnt return OK, result is NO
33
alter_add_multi_col=yes # Alter table add many columns
34
###< alter table crash_q add (f integer,g integer)
36
alter_add_primary_key=with constraint # Alter table add primary key
37
###< alter table crash_q1 add constraint p1 primary key(c1)
39
alter_add_unique=yes # Alter table add unique
40
###< alter table crash_q add constraint u1 unique(c1)
43
###As far as all queries returned OK, result is YES
44
alter_alter_col=yes # Alter table alter column default
45
###< alter table crash_q alter b set default 10
48
###As far as all queries returned OK, result is YES
49
alter_change_col=yes # Alter table change column
50
###< alter table crash_q change a e char(50)
53
###As far as all queries returned OK, result is YES
54
alter_drop_col=yes # Alter table drop column
55
###< alter table crash_q drop column b
57
alter_drop_constraint=no # Alter table drop constraint
58
###< alter table crash_q drop constraint c2
59
###> execute error:You 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
61
###< alter table crash_q drop constraint c2 restrict
62
###> execute error:You 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
63
alter_drop_foreign_key=with drop foreign key # Alter table drop foreign key
64
###< alter table crash_q drop constraint f1
65
###> execute error:You 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
67
###< alter table crash_q drop constraint f1 restrict
68
###> execute error:You 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
70
###< alter table crash_q drop foreign key f1
72
alter_drop_primary_key=drop primary key # Alter table drop primary key
73
###< alter table crash_q1 drop constraint p1 restrict
74
###> execute error:You 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
76
###< alter table crash_q1 drop primary key
78
alter_drop_unique=with drop key # Alter table drop unique
79
###< alter table crash_q drop constraint u1
80
###> execute error:You 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
82
###< alter table crash_q drop constraint u1 restrict
83
###> execute error:You 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
85
###< alter table crash_q drop key u1
87
alter_modify_col=yes # Alter table modify column
88
###< alter table crash_q modify c1 CHAR(20)
90
alter_rename_table=yes # Alter table rename table
91
###< alter table crash_q rename to crash_q1
94
###As far as all queries returned OK, result is YES
95
atomic_updates=no # atomic updates
96
###< create table crash_q (a integer not null,primary key (a))
98
###< insert into crash_q values (2)
100
###< insert into crash_q values (3)
102
###< insert into crash_q values (1)
104
###< update crash_q set a=a+1
105
###> execute error:Duplicate entry '3' for key 1
106
###< drop table crash_q
109
###As far as some queries didnt return OK, result is NO
110
automatic_rowid=_rowid # Automatic row id
111
###< create table crash_q (a int not null, primary key(a))
113
###< insert into crash_q values (1)
115
###< select _rowid from crash_q
117
###< drop table crash_q
119
binary_numbers=no # binary numbers (0b1001)
121
###> execute error:Unknown column '0b1001' in 'field list'
123
###As far as some queries didnt return OK, result is NO
124
binary_strings=no # binary strings (b'0110')
126
###> execute error:Unknown column 'b' in 'field list'
128
###As far as some queries didnt return OK, result is NO
129
case_insensitive_strings=yes # Case insensitive compare
131
###<select b from crash_me where b = 'A'
133
char_is_space_filled=no # char are space filled
135
###<select concat(b,b) from crash_me where b = 'a '
137
###We expected 'a a ' but got 'aa'
138
column_alias=yes # Column alias
139
###< select a as ab from crash_me
142
###As far as all queries returned OK, result is YES
143
columns_in_group_by=+64 # number of columns in group by
144
###We are trying (example with N=5):
145
###create table crash_q (q1 integer,q2 integer,q3 integer,q4 integer,q5 integer)
146
###insert into crash_q values(1,1,1,1,1)
147
###insert into crash_q values(1,1,1,1,1)
148
###select q1,q2,q3,q4,q5 from crash_q group by q1,q2,q3,q4,q5
149
columns_in_order_by=+64 # number of columns in order by
150
###We are trying (example with N=5):
151
###create table crash_q (q1 integer,q2 integer,q3 integer,q4 integer,q5 integer)
152
###insert into crash_q values(1,1,1,1,1)
153
###insert into crash_q values(1,1,1,1,1)
154
###select * from crash_q order by q1,q2,q3,q4,q5
155
comment_#=yes # # as comment
156
###< select * from crash_me # Testing of comments
159
###As far as all queries returned OK, result is YES
160
comment_--=yes # -- as comment (ANSI)
161
###< select * from crash_me -- Testing of comments
164
###As far as all queries returned OK, result is YES
165
comment_/**/=yes # /* */ as comment
166
###< select * from crash_me /* Testing of comments */
169
###As far as all queries returned OK, result is YES
170
comment_//=no # // as comment
171
###< select * from crash_me // Testing of comments
172
###> execute error:You 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
174
###As far as some queries didnt return OK, result is NO
176
###< select a from crash_me order by a compute sum(a) by a
177
###> execute error:You 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
179
###As far as some queries didnt return OK, result is NO
180
connections=101 # Simultaneous connections (installation default)
181
constraint_check=syntax only # Column constraints
182
###< create table crash_q (a int check (a>0))
185
###< insert into crash_q values(0)
188
###< drop table crash_q
190
constraint_check_named=syntax only # Named constraints
191
###< create table crash_q (a int ,b int, constraint abc check (a>b))
194
###< insert into crash_q values(0,0)
197
###< drop table crash_q
199
constraint_check_table=syntax only # Table constraints
200
###< create table crash_q (a int ,b int, check (a>b))
203
###< insert into crash_q values(0,0)
206
###< drop table crash_q
208
constraint_null=yes # NULL constraint (SyBase style)
209
###< create table crash_q (a int null)
211
###< drop table crash_q
214
###As far as all queries returned OK, result is YES
215
crash_me_safe=yes # crash me safe
216
crash_me_version=1.61 # crash me version
217
create_default=yes # default value for column
218
###< create table crash_q (q integer default 10 not null)
220
###< drop table crash_q
223
###As far as all queries returned OK, result is YES
224
create_default_func=no # default value function for column
225
###< create table crash_q (q integer not null,q1 integer default (1+1))
226
###> execute error:You 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
227
###< drop table crash_q
228
###> execute error:Unknown table 'crash_q'
230
###As far as some queries didnt return OK, result is NO
231
create_if_not_exists=yes # create table if not exists
232
###< create table crash_q (q integer)
234
###< create table if not exists crash_q (q integer)
237
###As far as all queries returned OK, result is YES
238
create_index=yes # create index
239
###< create index crash_q on crash_me (a)
241
create_schema=no # Create SCHEMA
242
###< create schema crash_schema create table crash_q (a int) create table crash_q2(b int)
243
###> execute error:You 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
244
###< drop schema crash_schema cascade
245
###> execute error:You 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
247
###As far as some queries didnt return OK, result is NO
248
create_table_select=yes # create table from select
249
###< create table crash_q SELECT * from crash_me
251
cross_join=yes # cross join (same as from a,b)
252
###< select crash_me.a from crash_me cross join crash_me3
255
###As far as all queries returned OK, result is YES
256
date_as_string=yes # String functions on date columns
257
###< create table crash_me2 (a date not null)
259
###< insert into crash_me2 values ('1998-03-03')
262
###<select left(a,4) from crash_me2
265
###< drop table crash_me2
267
date_format_EUR=error # Supports DD.MM.YYYY (EUR) format
268
###< insert into crash_me_d(a) values ('16.08.1963')
271
###<select a from crash_me_d
273
###We expected '1963-08-16' but got '0000-00-00'
275
###< delete from crash_me_d
277
date_format_EUR_with_date=error # Supports DATE 'DD.MM.YYYY' (EUR) format
278
###< insert into crash_me_d(a) values (DATE '16.08.1963')
281
###<select a from crash_me_d
283
###We expected '1963-08-16' but got '0000-00-00'
285
###< delete from crash_me_d
287
date_format_ISO=yes # Supports YYYY-MM-DD (ISO) format
288
###< insert into crash_me_d(a) values ('1963-08-16')
291
###<select a from crash_me_d
294
###< delete from crash_me_d
296
date_format_ISO_with_date=yes # Supports DATE 'YYYY-MM-DD' (ISO) format
297
###< insert into crash_me_d(a) values (DATE '1963-08-16')
300
###<select a from crash_me_d
303
###< delete from crash_me_d
305
date_format_USA=error # Supports MM/DD/YYYY format
306
###< insert into crash_me_d(a) values ('08/16/1963')
309
###<select a from crash_me_d
311
###We expected '1963-08-16' but got '0000-00-00'
313
###< delete from crash_me_d
315
date_format_USA_with_date=error # Supports DATE 'MM/DD/YYYY' format
316
###< insert into crash_me_d(a) values (DATE '08/16/1963')
319
###<select a from crash_me_d
321
###We expected '1963-08-16' but got '0000-00-00'
323
###< delete from crash_me_d
325
date_format_YYYYMMDD=yes # Supports YYYYMMDD format
326
###< insert into crash_me_d(a) values ('19630816')
329
###<select a from crash_me_d
332
###< delete from crash_me_d
334
date_format_YYYYMMDD_with_date=yes # Supports DATE 'YYYYMMDD' format
335
###< insert into crash_me_d(a) values (DATE '19630816')
338
###<select a from crash_me_d
341
###< delete from crash_me_d
343
date_format_inresult=iso # Date format in result
344
###< insert into crash_me_d values( sysdate() )
347
###< select a from crash_me_d
349
###< delete from crash_me_d
351
date_infinity=error # Supports 'infinity dates
352
###< create table crash_me2 (a date not null)
354
###< insert into crash_me2 values ('infinity')
357
###<select a from crash_me2
359
###We expected 'infinity' but got '0000-00-00'
361
###< drop table crash_me2
363
date_last=yes # Supports 9999-12-31 dates
364
###< create table crash_me2 (a date not null)
366
###< insert into crash_me2 values ('9999-12-31')
369
###<select a from crash_me2
372
###< drop table crash_me2
374
date_one=yes # Supports 0001-01-01 dates
375
###< create table crash_me2 (a date not null)
377
###< insert into crash_me2 values ('0001-01-01')
380
###<select a from crash_me2
383
###< drop table crash_me2
385
date_with_YY=yes # Supports YY-MM-DD 2000 compilant dates
386
###< create table crash_me2 (a date not null)
388
###< insert into crash_me2 values ('98-03-03')
391
###<select a from crash_me2
394
###< drop table crash_me2
397
###< create table crash_me2 (a date not null)
399
###< insert into crash_me2 values ('10-03-03')
402
###<select a from crash_me2
405
###< drop table crash_me2
407
date_zero=yes # Supports 0000-00-00 dates
408
###< create table crash_me2 (a date not null)
410
###< insert into crash_me2 values ('0000-00-00')
413
###<select a from crash_me2
416
###< drop table crash_me2
418
domains=no # Domains (ANSI SQL)
419
###< create domain crash_d as varchar(10) default 'Empty' check (value <> 'abcd')
420
###> execute error:You 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 <> '
421
###< create table crash_q(a crash_d, b int)
422
###> execute error:You 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
423
###< insert into crash_q(a,b) values('xyz',10)
424
###> execute error:Table 'test.crash_q' doesn't exist
425
###< insert into crash_q(b) values(10)
426
###> execute error:Table 'test.crash_q' doesn't exist
427
###< drop table crash_q
428
###> execute error:Unknown table 'crash_q'
429
###< drop domain crash_d
430
###> execute error:You 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
432
###As far as some queries didnt return OK, result is NO
433
dont_require_cast_to_float=yes # No need to cast from integer to float
437
###As far as all queries returned OK, result is YES
438
double_quotes=yes # Double '' as ' in strings
440
###<select 'Walker''s'
442
drop_if_exists=yes # drop table if exists
443
###< create table crash_q (q integer)
445
###< drop table if exists crash_q
448
###As far as all queries returned OK, result is YES
449
drop_index=with 'ON' # drop index
450
###< drop index crash_q
451
###> execute error:You 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
453
###< drop index crash_q from crash_me
454
###> execute error:You 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
456
###< drop index crash_q on crash_me
458
drop_requires_cascade=no # drop table require cascade/restrict
459
###< create table crash_me (a integer not null)
461
###< drop table crash_me
463
drop_restrict=yes # drop table with cascade/restrict
464
###< create table crash_q (a int)
466
###< drop table crash_q restrict
469
###As far as all queries returned OK, result is YES
470
end_colon=yes # allows end ';'
471
###< select * from crash_me;
474
###As far as all queries returned OK, result is YES
476
###< select * from crash_me except select * from crash_me3
477
###> execute error:You 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
479
###As far as some queries didnt return OK, result is NO
480
except_all=no # except all
481
###< select * from crash_me except all select * from crash_me3
482
###> execute error:You 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
484
###As far as some queries didnt return OK, result is NO
485
except_all_incompat=no # except all (incompatible lists)
486
###< select * from crash_me except all select * from crash_me2
487
###> execute error:You 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
489
###As far as some queries didnt return OK, result is NO
490
except_incompat=no # except (incompatible lists)
491
###< select * from crash_me except select * from crash_me2
492
###> execute error:You 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
494
###As far as some queries didnt return OK, result is NO
495
field_name_case=yes # case independent field names
496
###< create table crash_q (q integer)
498
###< insert into crash_q(Q) values (1)
500
###< drop table crash_q
503
###As far as all queries returned OK, result is YES
504
float_int_expr=yes # mixing of integer and float in expression
508
###As far as all queries returned OK, result is YES
509
foreign_key=syntax only # foreign keys
510
###< create table crash_me_qf (a integer not null,primary key (a))
513
###< create table crash_me_qf2 (a integer not null,foreign key (a) references crash_me_qf (a))
516
###< insert into crash_me_qf values (1)
519
###< insert into crash_me_qf2 values (2)
522
###< drop table crash_me_qf2
525
###< drop table crash_me_qf
527
full_outer_join=no # full outer join
528
###< select crash_me.a from crash_me full join crash_me2 ON
529
### crash_me.a=crash_me2.a
530
###> execute error:Unknown table 'crash_me' in field list
532
###As far as some queries didnt return OK, result is NO
533
func_extra_!=yes # Function NOT as '!' in SELECT
537
func_extra_%=yes # Function MOD as %
541
func_extra_&=yes # Function & (bitwise and)
545
func_extra_&&=yes # Function AND as '&&'
547
###<select 1=1 && 2=2
549
func_extra_<>=yes # Function <> in SELECT
553
func_extra_==yes # Function =
557
func_extra_add_months=no # Function ADD_MONTHS
559
###<select add_months('1997-01-01',1) from crash_me_d
560
###> 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
561
func_extra_adddate=yes # Function ADDDATE
563
###<select ADDDATE('2002-12-01',3) from crash_me_d
565
func_extra_addtime=yes # Function ADDTIME
567
###<select ADDTIME('20:02:12','00:00:03')
569
func_extra_alpha=no # Function ALPHA
571
###<select alpha('A�',2)
572
###> 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
573
func_extra_and_or=yes # Function AND and OR in SELECT
575
###<select 1=1 AND 2=2
577
func_extra_ascii_char=no # Function ASCII_CHAR
579
###<select ASCII_CHAR(65)
580
###> 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
581
func_extra_ascii_code=no # Function ASCII_CODE
583
###<select ASCII_CODE('A')
584
###> 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
585
func_extra_ascii_string=error # Function ASCII in string cast
587
###<select ascii('a')
589
###We expected 'a' but got '97'
590
func_extra_atn2=no # Function ATN2
593
###> 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
594
func_extra_auto_num2string=yes # Function automatic num->string convert
596
###<select concat('a',2)
598
func_extra_auto_string2num=yes # Function automatic string->num convert
602
func_extra_between=yes # Function BETWEEN in SELECT
604
###<select 5 between 4 and 6
606
func_extra_binary_shifts=yes # Function << and >> (bitwise shifts)
608
###<select (1 << 4) >> 2
610
func_extra_bit_count=yes # Function BIT_COUNT
612
###<select bit_count(5)
614
func_extra_ceil=yes # Function CEIL
616
###<select ceil(-4.5)
618
func_extra_char_date=no # Function CHAR (conversation date)
620
###<select CHAR(a,EUR) from crash_me_d
621
###> execute failed:Unknown column 'EUR' in 'field list'
622
func_extra_charindex=no # Function CHARINDEX
624
###<select charindex('a','crash')
625
###> 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
626
func_extra_chr=no # Function CHR
629
###> 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
630
func_extra_chr_str=no # Function CHR (any type to string)
633
###> 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
634
func_extra_concat_as_+=error # Function concatenation with +
636
###<select 'abc' + 'def'
638
###We expected 'abcdef' but got '0'
639
func_extra_concat_list=yes # Function CONCAT(list)
641
###<select concat('a','b','c','d')
643
func_extra_convert=no # Function CONVERT
645
###<select convert(CHAR,5)
646
###> 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
647
func_extra_cosh=no # Function COSH
650
###> 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
651
func_extra_date=yes # Function DATE
653
###<select date('1963-08-16') from crash_me_d
655
func_extra_date_format=yes # Function DATE_FORMAT
657
###<select date_format('1997-01-02 03:04:05','M W D Y y m d h i s w') from crash_me_d
658
###>M W D Y y m d h i s w
659
func_extra_dateadd=no # Function DATEADD
661
###<select dateadd(day,3,'1997-11-30') from crash_me_d
662
###> 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
663
func_extra_datediff=no # Function DATEDIFF
665
###<select datediff(month,'Oct 21 1997','Nov 30 1997') 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 ''Nov 30 1997') from crash_me_d' at line 1
667
func_extra_datediff2arg=yes # Function DATEDIFF (2 arg)
669
###<select DATEDIFF('2002-12-04','2002-12-01') from crash_me_d
671
func_extra_datename=no # Function DATENAME
673
###<select datename(month,'Nov 30 1997') from crash_me_d
674
###> 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
675
func_extra_datepart=no # Function DATEPART
677
###<select datepart(month,'July 20 1997') from crash_me_d
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 '(month,'July 20 1997') from crash_me_d' at line 1
679
func_extra_day=yes # Function DAY
681
###<select DAY('2002-12-01') from crash_me_d
683
func_extra_decode=no # Function DECODE
685
###<select DECODE('S-103','T72',1,'S-103',2,'Leopard',3)
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 '1,'S-103',2,'Leopard',3)' at line 1
687
func_extra_ebcdic_string=no # Function EBCDIC in string cast
689
###<select ebcdic('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_elt=yes # Function ELT
693
###<select elt(2,'ONE','TWO','THREE')
695
func_extra_encrypt=yes # Function ENCRYPT
697
###<select encrypt('hello')
699
func_extra_expand2arg=no # Function EXPAND
701
###<select expand('abcd',6)
702
###> 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
703
func_extra_field=yes # Function FIELD
705
###<select field('IBM','NCA','ICL','SUN','IBM','DIGITAL')
707
func_extra_fixed=no # Function FIXED
709
###<select fixed(222.6666,10,2)
710
###> 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
711
func_extra_float=no # Function FLOAT
713
###<select float(6666.66,4)
714
###> 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
715
func_extra_format=yes # Function FORMAT
717
###<select format(1234.5555,2)
719
func_extra_from_days=yes # Function FROM_DAYS
721
###<select from_days(729024) from crash_me_d
723
func_extra_from_unixtime=yes # Function FROM_UNIXTIME
725
###<select from_unixtime(0) from crash_me_d
726
###>1970-01-01 02:00:00
727
func_extra_getdate=no # Function GETDATE
730
###> 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
731
func_extra_greatest=yes # Function GREATEST
733
###<select greatest('HARRY','HARRIOT','HAROLD')
735
func_extra_hex=yes # Function HEX
739
func_extra_if=yes # Function IF
743
func_extra_in_num=yes # Function IN on numbers in SELECT
745
###<select 2 in (3,2,5,9,5,1)
747
func_extra_in_str=yes # Function IN on strings in SELECT
749
###<select 'monty' in ('david','monty','allan')
751
func_extra_index=no # Function INDEX
753
###<select index('abcdefg','cd',1,1)
754
###> 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
755
func_extra_initcap=no # Function INITCAP
757
###<select initcap('the soap')
758
###> 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
759
func_extra_instr=yes # Function LOCATE as INSTR
761
###<select instr('hello','ll')
763
func_extra_instr_oracle=no # Function INSTR (Oracle syntax)
765
###<select INSTR('CORPORATE FLOOR','OR',3,2)
766
###> 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
767
func_extra_instrb=no # Function INSTRB
769
###<select INSTRB('CORPORATE FLOOR','OR',5,2)
770
###> 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
771
func_extra_interval=yes # Function INTERVAL
773
###<select interval(55,10,20,30,40,50,60,70,80,90,100)
775
func_extra_last_day=yes # Function LAST_DAY
777
###<select last_day('1997-04-01') from crash_me_d
779
func_extra_last_insert_id=yes # Function LAST_INSERT_ID
781
###<select last_insert_id()
783
func_extra_least=yes # Function LEAST
785
###<select least('HARRY','HARRIOT','HAROLD')
787
func_extra_length=error # Function LENGTH
791
###We expected '2' but got '1'
792
func_extra_lengthb=no # Function LENGTHB
794
###<select lengthb('CANDIDE')
795
###> 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
796
func_extra_lfill3arg=no # Function LFILL (3 arg)
798
###<select lfill('abcd','.',6)
799
###> 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
800
func_extra_like=yes # Function LIKE in SELECT
802
###<select 'a' like 'a%'
804
func_extra_like_escape=yes # Function LIKE ESCAPE in SELECT
806
###<select '%' like 'a%' escape 'a'
808
func_extra_ln=yes # Function LN
812
func_extra_log(m_n)=yes # Function LOG(m,n)
814
###<select log(10,100)
816
func_extra_logn=no # Function LOGN
819
###> 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
820
func_extra_lpad=yes # Function LPAD
822
###<select lpad('hi',4,'??')
824
func_extra_ltrim2arg=no # Function LTRIM (2 arg)
826
###<select ltrim('..abcd..','.')
827
###> 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
828
func_extra_makedate=yes # Function MAKEDATE
830
###<select MAKEDATE(1963,228) from crash_me_d
832
func_extra_maketime=yes # Function MAKETIME
834
###<select MAKETIME(20,02,12)
836
func_extra_mapchar=no # Function MAPCHAR
838
###<select mapchar('A�')
839
###> 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
840
func_extra_mdy=no # Function MDY
842
###<select mdy(7,1,1998) from crash_me_d
843
###> 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
844
func_extra_microsecond=yes # Function MICROSECOND
846
###<select MICROSECOND('19630816200212111111')
848
func_extra_mid=yes # Function SUBSTRING as MID
850
###<select mid('hello',3,2)
852
func_extra_months_between=no # Function MONTHS_BETWEEN
854
###<select months_between('1997-02-02','1997-01-01') from crash_me_d
855
###> 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
856
func_extra_noround=no # Function NOROUND
857
###< select noround(22.6)
858
###> execute error:You 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
859
func_extra_not=yes # Function NOT in SELECT
863
func_extra_not_between=yes # Function NOT BETWEEN in SELECT
865
###<select 5 not between 4 and 6
867
func_extra_not_like=yes # Function NOT LIKE in SELECT
869
###<select 'a' not like 'a%'
871
func_extra_num=no # Function NUM
873
###<select NUM('2123')
874
###> 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
875
func_extra_odbc_convert=no # Function ODBC CONVERT
877
###<select convert(5,SQL_CHAR)
878
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQL_CHAR)' at line 1
879
func_extra_password=yes # Function PASSWORD
881
###<select password('hello')
882
###>*6B4F89A54E2D27ECD7E8DA05B4AB8FD9D1D8B119
883
func_extra_paste=no # Function PASTE
885
###<select paste('ABCDEFG',3,2,'1234')
886
###> 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
887
func_extra_patindex=no # Function PATINDEX
889
###<select patindex('%a%','crash')
890
###> 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
891
func_extra_period_add=yes # Function PERIOD_ADD
893
###<select period_add(9602,-12) from crash_me_d
895
func_extra_period_diff=yes # Function PERIOD_DIFF
897
###<select period_diff(199505,199404) from crash_me_d
899
func_extra_pow=yes # Function POW
903
func_extra_range=no # Function RANGE
906
###> 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
907
func_extra_regexp=yes # Function REGEXP in SELECT
909
###<select 'a' regexp '^(a|b)*$'
911
func_extra_replace2arg=no # Function REPLACE (2 arg)
913
###<select replace('AbCd','bC')
914
###> 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
915
func_extra_replicate=no # Function REPLICATE
917
###<select replicate('a',5)
918
###> 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
919
func_extra_reverse=yes # Function REVERSE
921
###<select reverse('abcd')
923
func_extra_rfill3arg=no # Function RFILL (3 arg)
925
###<select rfill('abcd','.',6)
926
###> 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
927
func_extra_root=no # Function ROOT
930
###> 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
931
func_extra_round1=yes # Function ROUND(1 arg)
933
###<select round(5.63)
935
func_extra_rpad=yes # Function RPAD
937
###<select rpad('hi',4,'??')
939
func_extra_rpad4arg=no # Function RPAD (4 arg)
941
###<select rpad('abcd',2,'+-',8)
942
###> 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
943
func_extra_rtrim2arg=no # Function RTRIM (2 arg)
945
###<select rtrim('..abcd..','.')
946
###> 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
947
func_extra_sec_to_time=yes # Function SEC_TO_TIME
949
###<select sec_to_time(5001)
951
func_extra_sinh=no # Function SINH
954
###> 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
955
func_extra_str=no # Function STR
957
###<select str(123.45,5,1)
958
###> 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
959
func_extra_strcmp=yes # Function STRCMP
961
###<select strcmp('abc','adc')
963
func_extra_stuff=no # Function STUFF
965
###<select stuff('abc',2,3,'xyz')
966
###> 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
967
func_extra_subdate=yes # Function SUBDATE
969
###<select SUBDATE('2002-12-04',3) from crash_me_d
971
func_extra_substr2arg=yes # Function SUBSTR (2 arg)
973
###<select substr('abcd',2)
975
func_extra_substr3arg=yes # Function SUBSTR (3 arg)
977
###<select substr('abcd',2,2)
979
func_extra_substrb=no # Function SUBSTRB
981
###<select SUBSTRB('ABCDEFG',5,4.2)
982
###> 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
983
func_extra_substring_index=yes # Function SUBSTRING_INDEX
985
###<select substring_index('www.tcx.se','.',-2)
987
func_extra_subtime=yes # Function SUBTIME
989
###<select SUBTIME('20:02:15','00:00:03')
991
func_extra_sysdate=yes # Function SYSDATE
994
###>2004-04-06 13:49:05
995
func_extra_tail=no # Function TAIL
997
###<select tail('ABCDEFG',3)
998
###> 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
999
func_extra_tanh=no # Function TANH
1002
###> 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
1003
func_extra_time=yes # Function TIME
1005
###<select time('20:02:12')
1007
func_extra_time_to_sec=yes # Function TIME_TO_SEC
1009
###<select time_to_sec('01:23:21')
1011
func_extra_timediff=yes # Function TIMEDIFF
1013
###<select TIMEDIFF('20:02:15','20:02:12')
1015
func_extra_timestamp=error # Function TIMESTAMP
1017
###<select timestamp('19630816','00200212')
1018
###>1963-08-16 20:02:12
1019
###We expected '19630816200212000000' but got '1963-08-16 20:02:12'
1020
func_extra_to_days=yes # Function TO_DAYS
1022
###<select to_days('1996-01-01') from crash_me_d
1024
func_extra_translate=no # Function TRANSLATE
1026
###<select translate('abc','bc','de')
1027
###> 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
1028
func_extra_trim1arg=yes # Function TRIM (1 arg)
1030
###<select trim(' abcd ')
1032
func_extra_trim2arg=no # Function TRIM (2 arg)
1034
###<select trim('..abcd..','.')
1035
###> 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
1036
func_extra_trim_many_char=error # Function TRIM; Many char extension
1038
###<select trim(':!' FROM ':abc!')
1040
###We expected 'abc' but got ':abc!'
1041
func_extra_trim_substring=yes # Function TRIM; Substring extension
1043
###<select trim('cb' FROM 'abccb')
1045
func_extra_trunc=no # Function TRUNC
1047
###<select trunc(18.18,-1)
1048
###> 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
1049
func_extra_trunc1arg=no # Function TRUNC (1 arg)
1051
###<select trunc(222.6)
1052
###> 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
1053
func_extra_uid=no # Function UID
1056
###> execute failed:Unknown column 'uid' in 'field list'
1057
func_extra_unix_timestamp=yes # Function UNIX_TIMESTAMP
1059
###<select unix_timestamp()
1061
func_extra_userenv=no # Function USERENV
1064
###> execute failed:Unknown column 'userenv' in 'field list'
1065
func_extra_value=no # Function VALUE
1067
###<select value(NULL,'WALRUS')
1068
###> 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
1069
func_extra_version=yes # Function VERSION
1071
###<select version()
1073
func_extra_weekday=yes # Function WEEKDAY
1075
###<select weekday('1997-11-29') from crash_me_d
1077
func_extra_weekofyear=yes # Function WEEKOFYEAR
1079
###<select WEEKOFYEAR('1963-08-16') from crash_me_d
1081
func_extra_|=yes # Function | (bitwise or)
1085
func_extra_||=yes # Function OR as '||'
1087
###<select 1=0 || 1=1
1089
func_extra_~*=no # Function ~* (case insensitive compare)
1091
###<select 'hi' ~* 'HI'
1092
###> 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
1093
func_odbc_abs=yes # Function ABS
1097
func_odbc_acos=yes # Function ACOS
1101
func_odbc_ascii=yes # Function ASCII
1103
###<select ASCII('A')
1105
func_odbc_asin=yes # Function ASIN
1109
func_odbc_atan=yes # Function ATAN
1113
func_odbc_atan2=yes # Function ATAN2
1115
###<select atan2(1,0)
1117
func_odbc_ceiling=yes # Function CEILING
1119
###<select ceiling(-4.5)
1121
func_odbc_char=yes # Function CHAR
1125
func_odbc_concat=yes # Function CONCAT(2 arg)
1127
###<select concat('a','b')
1129
func_odbc_cos=yes # Function COS
1133
func_odbc_cot=yes # Function COT
1137
func_odbc_curdate=yes # Function CURDATE
1139
###<select curdate()
1141
func_odbc_curtime=yes # Function CURTIME
1143
###<select curtime()
1145
func_odbc_database=yes # Function DATABASE
1147
###<select database()
1149
func_odbc_dayname=yes # Function DAYNAME
1150
###< insert into crash_me_d values('1997-02-01')
1152
###<select dayname(a) from crash_me_d
1154
func_odbc_dayofmonth=yes # Function DAYOFMONTH
1155
###< insert into crash_me_d values('1997-02-01')
1157
###<select dayofmonth(a) from crash_me_d
1159
func_odbc_dayofweek=yes # Function DAYOFWEEK
1160
###< insert into crash_me_d values('1997-02-01')
1162
###<select dayofweek(a) from crash_me_d
1164
func_odbc_dayofyear=yes # Function DAYOFYEAR
1165
###< insert into crash_me_d values('1997-02-01')
1167
###<select dayofyear(a) from crash_me_d
1169
func_odbc_degrees=yes # Function DEGREES
1171
###<select degrees(6.283185)
1173
func_odbc_difference=no # Function DIFFERENCE()
1175
###<select difference('abc','abe')
1176
###> 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
1178
###<select {fn difference('abc','abe') }
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 '('abc','abe') }' at line 1
1180
func_odbc_exp=yes # Function EXP
1184
func_odbc_floor=yes # Function FLOOR
1186
###<select floor(2.5)
1188
func_odbc_fn_left=yes # Function ODBC syntax LEFT & RIGHT
1190
###<select { fn LEFT( { fn RIGHT('abcd',2) },1) }
1192
func_odbc_hour=yes # Function HOUR
1193
###< insert into crash_me_t values(20:08:16)
1195
###<select hour('12:13:14')
1197
func_odbc_hour_time=yes # Function ANSI HOUR
1198
###< insert into crash_me_t values(20:08:16)
1200
###<select hour(TIME '12:13:14')
1202
func_odbc_ifnull=yes # Function IFNULL
1204
###<select ifnull(2,3)
1206
func_odbc_insert=yes # Function INSERT
1208
###<select insert('abcd',2,2,'ef')
1210
func_odbc_lcase=yes # Function LCASE
1212
###<select lcase('ABC')
1214
func_odbc_left=yes # Function LEFT
1216
###<select left('abcd',2)
1218
func_odbc_length=yes # Function REAL LENGTH
1220
###<select length('abcd ')
1222
func_odbc_length_without_space=error # Function ODBC LENGTH
1224
###<select length('abcd ')
1226
###We expected '4' but got '5'
1228
###<select {fn length('abcd ') }
1230
###We expected '4' but got '5'
1231
func_odbc_locate_2=yes # Function LOCATE(2 arg)
1233
###<select locate('bcd','abcd')
1235
func_odbc_locate_3=yes # Function LOCATE(3 arg)
1237
###<select locate('bcd','abcd',3)
1239
func_odbc_log=yes # Function LOG
1243
func_odbc_log10=yes # Function LOG10
1245
###<select log10(10)
1247
func_odbc_ltrim=yes # Function LTRIM
1249
###<select ltrim(' abcd')
1251
func_odbc_minute=yes # Function MINUTE
1252
###< insert into crash_me_t values(20:08:16)
1254
###<select minute('12:13:14')
1256
func_odbc_mod=yes # Function MOD
1258
###<select mod(11,7)
1260
func_odbc_month=yes # Function MONTH
1261
###< insert into crash_me_d values('1997-02-01')
1263
###<select month(a) from crash_me_d
1265
func_odbc_monthname=yes # Function MONTHNAME
1266
###< insert into crash_me_d values('1997-02-01')
1268
###<select monthname(a) from crash_me_d
1270
func_odbc_now=yes # Function NOW
1273
###>2004-04-06 13:49:04
1274
func_odbc_pi=yes # Function PI
1278
func_odbc_power=yes # Function POWER
1280
###<select power(2,4)
1282
func_odbc_quarter=yes # Function QUARTER
1283
###< insert into crash_me_d values('1997-02-01')
1285
###<select quarter(a) from crash_me_d
1287
func_odbc_radians=yes # Function RADIANS
1289
###<select radians(360)
1291
func_odbc_rand=yes # Function RAND
1294
###>0.40540353712198
1295
func_odbc_repeat=yes # Function REPEAT
1297
###<select repeat('ab',3)
1299
func_odbc_replace=yes # Function REPLACE
1301
###<select replace('abbaab','ab','ba')
1303
func_odbc_right=yes # Function RIGHT
1305
###<select right('abcd',2)
1307
func_odbc_round=yes # Function ROUND(2 arg)
1309
###<select round(5.63,2)
1311
func_odbc_rtrim=yes # Function RTRIM
1313
###<select rtrim(' abcd ')
1315
func_odbc_second=yes # Function SECOND
1316
###< insert into crash_me_t values(20:08:16)
1318
###<select second('12:13:14')
1320
func_odbc_sign=yes # Function SIGN
1324
func_odbc_sin=yes # Function SIN
1328
func_odbc_soundex=yes # Function SOUNDEX
1330
###<select soundex('hello')
1332
func_odbc_space=yes # Function SPACE
1336
func_odbc_sqrt=yes # Function SQRT
1340
func_odbc_substring=yes # Function ODBC SUBSTRING
1342
###<select substring('abcd',3,2)
1344
func_odbc_tan=yes # Function TAN
1348
func_odbc_timestampadd=no # Function TIMESTAMPADD
1350
###<select timestampadd(SQL_TSI_SECOND,1,'1997-01-01 00:00:00')
1351
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(SQL_TSI_SECOND,1,'1997-01-01 00:00:00')' at line 1
1353
###<select {fn timestampadd(SQL_TSI_SECOND,1,{ts '1997-01-01 00:00:00'}) }
1354
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(SQL_TSI_SECOND,1,{ts '1997-01-01 00:00:00'}) }' at line 1
1355
func_odbc_timestampdiff=no # Function TIMESTAMPDIFF
1357
###<select timestampdiff(SQL_TSI_SECOND,'1997-01-01 00:00:02', '1997-01-01 00:00:01')
1358
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(SQL_TSI_SECOND,'1997-01-01 00:00:02', '1997-01-01 00:00:01')'
1360
###<select {fn timestampdiff(SQL_TSI_SECOND,{ts '1997-01-01 00:00:02'}, {ts '1997-01-01 00:00:01'}) }
1361
###> execute failed:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(SQL_TSI_SECOND,{ts '1997-01-01 00:00:02'}, {ts '1997-01-01 00:
1362
func_odbc_truncate=yes # Function TRUNCATE
1364
###<select truncate(18.18,-1)
1366
func_odbc_ucase=yes # Function UCASE
1368
###<select ucase('abc')
1370
func_odbc_user()=yes # Function USER()
1374
func_odbc_week=USA # WEEK
1375
###<select week('1997-02-01')
1377
###We expected '5' but got '4'
1378
func_odbc_year=yes # Function YEAR
1379
###< insert into crash_me_d values('1997-02-01')
1381
###<select year(a) from crash_me_d
1383
func_sql_+=yes # Function +, -, * and /
1385
###<select 5*3-4/2+1
1387
func_sql_bit_length=yes # Function BIT_LENGTH
1389
###<select bit_length('abc')
1391
func_sql_cast=yes # Function CAST
1393
###<select CAST(1 as CHAR)
1395
func_sql_char_length=error # Function CHAR_LENGTH
1397
###<select char_length(b) from crash_me
1399
###We expected '10' but got '1'
1400
func_sql_char_length(constant)=yes # Function CHAR_LENGTH(constant)
1402
###<select char_length('abcd')
1404
func_sql_character_length=yes # Function CHARACTER_LENGTH
1406
###<select character_length('abcd')
1408
func_sql_coalesce=yes # Function COALESCE
1410
###<select coalesce(NULL,'bcd','qwe')
1412
func_sql_concat_as_||=error # Function concatenation with ||
1414
###<select 'abc' || 'def'
1416
###We expected 'abcdef' but got '0'
1417
func_sql_current_date=yes # Function CURRENT_DATE
1419
###<select current_date
1421
func_sql_current_time=yes # Function CURRENT_TIME
1423
###<select current_time
1425
func_sql_current_timestamp=yes # Function CURRENT_TIMESTAMP
1427
###<select current_timestamp
1428
###>2004-04-06 13:49:04
1429
func_sql_current_user=yes # CURRENT_USER
1430
###< select CURRENT_USER
1432
func_sql_extract_sql=yes # Function EXTRACT
1434
###<select extract(minute from timestamp '2000-02-23 18:43:12.987')
1436
func_sql_localtime=yes # Function LOCALTIME
1438
###<select localtime
1439
###>2004-04-06 13:49:04
1440
func_sql_localtimestamp=yes # Function LOCALTIMESTAMP
1442
###<select localtimestamp
1443
###>2004-04-06 13:49:04
1444
func_sql_lower=yes # Function LOWER
1446
###<select LOWER('ABC')
1448
func_sql_nullif_num=yes # Function NULLIF with numbers
1450
###<select NULLIF(NULLIF(1,2),1)
1452
func_sql_nullif_string=yes # Function NULLIF with strings
1454
###<select NULLIF(NULLIF('first','second'),'first')
1456
func_sql_octet_length=yes # Function OCTET_LENGTH
1458
###<select octet_length('abc')
1460
func_sql_position=yes # Function POSITION
1462
###<select position('ll' in 'hello')
1464
func_sql_searched_case=yes # Function searched CASE
1466
###<select case when 1 > 2 then 'false' when 2 > 1 then 'true' end
1468
func_sql_session_user=with_parenthesis # SESSION_USER
1469
###< select SESSION_USER
1470
###> execute error:Unknown column 'SESSION_USER' in 'field list'
1472
###< select SESSION_USER()
1474
func_sql_simple_case=yes # Function simple CASE
1476
###<select case 2 when 1 then 'false' when 2 then 'true' end
1478
func_sql_substring=yes # Function ANSI SQL SUBSTRING
1480
###<select substring('abcd' from 2 for 2)
1482
func_sql_system_user=with_parenthesis # SYSTEM_USER
1483
###< select SYSTEM_USER
1484
###> execute error:Unknown column 'SYSTEM_USER' in 'field list'
1486
###< select SYSTEM_USER()
1488
func_sql_trim=yes # Function TRIM
1490
###<select trim(trailing from trim(LEADING FROM ' abc '))
1492
func_sql_upper=yes # Function UPPER
1494
###<select UPPER('abc')
1496
func_sql_user=with_parenthesis # USER
1498
###> execute error:Unknown column 'USER' in 'field list'
1502
func_where_between=yes # Function BETWEEN
1504
###<select a from crash_me where 5 between 4 and 6
1506
func_where_eq_all=yes # Function = ALL
1508
###<select a from crash_me where b =all (select b from crash_me)
1510
func_where_eq_any=yes # Function = ANY
1512
###<select a from crash_me where b =any (select b from crash_me)
1514
func_where_eq_some=yes # Function = SOME
1516
###<select a from crash_me where b =some (select b from crash_me)
1518
func_where_exists=yes # Function EXISTS
1520
###<select a from crash_me where exists (select * from crash_me)
1522
func_where_in_num=yes # Function IN on numbers
1524
###<select a from crash_me where 2 in (3,2,5,9,5,1)
1526
func_where_like=yes # Function LIKE
1528
###<select a from crash_me where b like 'a%'
1530
func_where_like_escape=yes # Function LIKE ESCAPE
1532
###<select a from crash_me where b like '%' escape 'a'
1534
func_where_match=no # Function MATCH
1536
###<select a from crash_me where 1 match (select a from crash_me)
1537
###> 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
1538
func_where_match_unique=no # Function MATCH UNIQUE
1540
###<select a from crash_me where 1 match unique (select a from crash_me)
1541
###> 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
1542
func_where_matches=no # Function MATCHES
1544
###<select a from crash_me where b matcjhes 'a*'
1545
###> 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
1546
func_where_not_between=yes # Function NOT BETWEEN
1548
###<select a from crash_me where 7 not between 4 and 6
1550
func_where_not_exists=yes # Function NOT EXISTS
1552
###<select a from crash_me where not exists (select * from crash_me where a = 2)
1554
func_where_not_like=yes # Function NOT LIKE
1556
###<select a from crash_me where b not like 'b%'
1558
func_where_not_unique=no # Function NOT UNIQUE
1560
###<select a from crash_me where not unique (select * from crash_me where a = 2)
1561
###> 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
1562
func_where_unique=no # Function UNIQUE
1564
###<select a from crash_me where unique (select * from crash_me)
1565
###> 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
1566
functions=yes # Functions
1570
###As far as all queries returned OK, result is YES
1571
group_by=yes # Group by
1572
###< select a from crash_me group by a
1575
###As far as all queries returned OK, result is YES
1576
group_by_alias=yes # Group by alias
1577
###< select a as ab from crash_me group by ab
1580
###As far as all queries returned OK, result is YES
1581
group_by_null=yes # Group on column with null values
1582
###< create table crash_q (s char(10))
1584
###< insert into crash_q values(null)
1586
###< insert into crash_q values(null)
1589
###<select count(*),s from crash_q group by s
1592
###< drop table crash_q
1594
group_by_position=yes # Group by position
1595
###< select a from crash_me group by 1
1598
###As far as all queries returned OK, result is YES
1599
group_distinct_functions=yes # Group functions with distinct
1600
###< select count(distinct a) from crash_me
1603
###As far as all queries returned OK, result is YES
1604
group_func_extra_bit_and=yes # Group function BIT_AND
1606
###<select bit_and(a),a from crash_me group by a
1608
group_func_extra_bit_or=yes # Group function BIT_OR
1610
###<select bit_or(a),a from crash_me group by a
1612
group_func_extra_count_distinct_list=yes # Group function COUNT(DISTINCT expr,expr,...)
1614
###<select count(distinct a,b),a from crash_me group by a
1616
group_func_extra_std=yes # Group function STD
1618
###<select std(a),a from crash_me group by a
1620
group_func_extra_stddev=yes # Group function STDDEV
1622
###<select stddev(a),a from crash_me group by a
1624
group_func_extra_variance=yes # Group function VARIANCE
1626
###<select variance(a),a from crash_me group by a
1628
group_func_sql_any=no # Group function ANY
1630
###<select any(a),a from crash_me group by a
1631
###> 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
1632
group_func_sql_avg=yes # Group function AVG
1634
###<select avg(a),a from crash_me group by a
1636
group_func_sql_count_*=yes # Group function COUNT (*)
1638
###<select count(*),a from crash_me group by a
1640
group_func_sql_count_column=yes # Group function COUNT column name
1642
###<select count(a),a from crash_me group by a
1644
group_func_sql_count_distinct=yes # Group function COUNT(DISTINCT expr)
1646
###<select count(distinct a),a from crash_me group by a
1648
group_func_sql_every=no # Group function EVERY
1650
###<select every(a),a from crash_me group by a
1651
###> 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
1652
group_func_sql_max=yes # Group function MAX on numbers
1654
###<select max(a),a from crash_me group by a
1656
group_func_sql_max_str=yes # Group function MAX on strings
1658
###<select max(b),a from crash_me group by a
1660
group_func_sql_min=yes # Group function MIN on numbers
1662
###<select min(a),a from crash_me group by a
1664
group_func_sql_min_str=yes # Group function MIN on strings
1666
###<select min(b),a from crash_me group by a
1668
group_func_sql_some=no # Group function SOME
1670
###<select some(a),a from crash_me group by a
1671
###> 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
1672
group_func_sql_sum=yes # Group function SUM
1674
###<select sum(a),a from crash_me group by a
1676
group_functions=yes # Group functions
1677
###< select count(*) from crash_me
1680
###As far as all queries returned OK, result is YES
1681
group_many_distinct_functions=yes # Group functions with several distinct
1682
###< select count(distinct a), count(distinct b) from crash_me
1685
###As far as all queries returned OK, result is YES
1686
group_on_unused=yes # Group on unused column
1687
###< select count(*) from crash_me group by a
1690
###As far as all queries returned OK, result is YES
1691
has_true_false=yes # TRUE and FALSE
1692
###< select (1=1)=true
1695
###<select a from crash_me group by a having a > 0
1698
###<select a from crash_me group by a having a < 0
1699
###> didn't return any result:
1700
having_with_alias=yes # Having on alias
1701
###< select a as ab from crash_me group by a having ab > 0
1704
###As far as all queries returned OK, result is YES
1705
having_with_group=yes # Having with group function
1706
###< select a from crash_me group by a having count(*) = 1
1709
###As far as all queries returned OK, result is YES
1710
hex_numbers=yes # hex numbers (0x41)
1714
###As far as all queries returned OK, result is YES
1715
hex_strings=yes # hex strings (x'1ace')
1719
###As far as all queries returned OK, result is YES
1720
ignore_end_space=yes # Ignore end space in compare
1722
###<select b from crash_me where b = 'a '
1724
index_in_create=yes # index in create table
1725
###< create table crash_q (q integer not null,index (q))
1727
###< drop table crash_q
1730
###As far as all queries returned OK, result is YES
1731
index_namespace=yes # different namespace for index
1732
###< create index crash_me on crash_me (b)
1734
###< drop index crash_me on crash_me
1737
###As far as all queries returned OK, result is YES
1738
index_parts=yes # index on column part (extension)
1739
###< create index crash_q on crash_me (b(5))
1741
###< drop index crash_q on crash_me
1744
###As far as all queries returned OK, result is YES
1745
inner_join=yes # inner join
1746
###< select crash_me.a from crash_me inner join crash_me2 ON crash_me.a=crash_me2.a
1749
###As far as all queries returned OK, result is YES
1750
insert_default_values=no # INSERT DEFAULT VALUES
1751
###< create table crash_me_q (a int)
1753
###< insert into crash_me_q DEFAULT VALUES
1754
###> execute error:You 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
1755
###< drop table crash_me_q
1758
###As far as some queries didnt return OK, result is NO
1759
insert_empty_string=yes # insert empty string
1760
###< create table crash_q (a char(10) not null,b char(10))
1762
###< insert into crash_q values ('','')
1764
###< drop table crash_q
1767
###As far as all queries returned OK, result is YES
1768
insert_multi_value=yes # INSERT with Value lists
1769
###< create table crash_q (s char(10))
1771
###< insert into crash_q values ('a'),('b')
1773
###< drop table crash_q
1776
###As far as all queries returned OK, result is YES
1777
insert_select=yes # insert INTO ... SELECT ...
1778
###< create table crash_q (a int)
1780
###< insert into crash_q (a) SELECT crash_me.a from crash_me
1782
###< drop table crash_q
1785
###As far as all queries returned OK, result is YES
1786
insert_with_default=yes # INSERT with DEFAULT
1787
###< create table crash_me_q (a int)
1789
###< insert into crash_me_q (a) values (DEFAULT)
1791
###< drop table crash_me_q
1794
###As far as all queries returned OK, result is YES
1795
insert_with_empty_value_list=no # INSERT with empty value list
1796
###< create table crash_me_q (a int)
1798
###< insert into crash_me_q (a) values ()
1799
###> execute error:Column count doesn't match value count at row 1
1800
###< drop table crash_me_q
1803
###As far as some queries didnt return OK, result is NO
1804
insert_with_set=yes # INSERT with set syntax
1805
###< create table crash_q (a integer)
1807
###< insert into crash_q SET a=1
1809
###< drop table crash_q
1812
###As far as all queries returned OK, result is YES
1813
intersect=no # intersect
1814
###< select * from crash_me intersect select * from crash_me3
1815
###> execute error:You 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
1817
###As far as some queries didnt return OK, result is NO
1818
intersect_all=no # intersect all
1819
###< select * from crash_me intersect all select * from crash_me3
1820
###> execute error:You 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
1822
###As far as some queries didnt return OK, result is NO
1823
intersect_all_incompat=no # intersect all (incompatible lists)
1824
###< select * from crash_me intersect all select * from crash_me2
1825
###> execute error:You 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
1827
###As far as some queries didnt return OK, result is NO
1828
intersect_incompat=no # intersect (incompatible lists)
1829
###< select * from crash_me intersect select * from crash_me2
1830
###> execute error:You 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
1832
###As far as some queries didnt return OK, result is NO
1833
join_tables=61 # tables in join
1834
###We are trying (example with N=5):
1835
###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
1836
### 32:OK 48:OK 56:OK 60:OK 62:FAIL 61:FAIL
1837
left_outer_join=yes # left outer join
1838
###< select crash_me.a from crash_me left join crash_me2 ON crash_me.a=crash_me2.a
1841
###As far as all queries returned OK, result is YES
1842
left_outer_join_using=yes # left outer join using
1843
###< select c1 from crash_me left join crash_me2 using (a)
1846
###As far as all queries returned OK, result is YES
1847
length_of_varchar_field=actual length # CHARACTER_LENGTH(varchar_field)
1848
###< CREATE TABLE crash_me1 (S1 VARCHAR(100))
1850
###< INSERT INTO crash_me1 VALUES ('X')
1853
###< SELECT CHARACTER_LENGTH(S1) FROM crash_me1
1855
###< drop table crash_me1
1857
like_with_column=yes # column LIKE column
1858
###< create table crash_q (a char(10),b char(10))
1860
###< insert into crash_q values('abc','abc')
1862
###< select * from crash_q where a like b
1864
###< drop table crash_q
1867
###As far as all queries returned OK, result is YES
1868
like_with_number=yes # LIKE on numbers
1869
###< create table crash_q (a int,b int)
1871
###< insert into crash_q values(10,10)
1873
###< select * from crash_q where a like '10'
1875
###< drop table crash_q
1878
###As far as all queries returned OK, result is YES
1879
lock_tables=yes # lock table
1880
###< lock table crash_me READ
1885
###As far as all queries returned OK, result is YES
1886
logical_value=1 # Value of logical operation (1=1)
1889
max_big_expressions=10 # big expressions
1890
###We are trying (example with N=5):
1891
###select 0+(1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+...(8168)
1892
### 50:FAIL 10:OK 30:FAIL 14:FAIL 11:FAIL
1893
max_char_size=1048543 # max char() size
1894
###We are trying (example with N=5):
1895
###create table crash_q (q char(5))
1896
###insert into crash_q values ('aaaaa')
1897
###select * from crash_q
1898
### 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
1899
max_column_name=64 # column name length
1900
###We are trying (example with N=5):
1901
###create table crash_q (qaaaaa integer)
1902
###insert into crash_q (qaaaaa) values(1)
1903
###select qaaaaa from crash_q
1904
### 256:FAIL 51:OK 153:FAIL 72:FAIL 55:OK 63:OK 67:FAIL 64:FAIL
1905
max_columns=2599 # Columns in table
1906
###We are trying (example with N=5):
1907
###create table crash_q (a integer ,a0 integer,a1 integer,a2 integer,a3 integer,a4 integer)
1908
### 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
1909
max_conditions=85660 # OR and AND in WHERE
1910
###We are trying (example with N=5):
1911
###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'
1912
### 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
1913
max_expressions=836 # simple expressions
1914
###We are trying (example with N=5):
1915
###select 1+1+1+1+1+1
1916
### 5000:FAIL 1000:FAIL 200:OK 600:OK 800:OK 900:FAIL 820:OK 860:FAIL 828:OK 844:FAIL 831:OK 837:FAIL 832:OK 834:OK 835:OK 836:OK
1917
max_index=32 # max index
1918
### max_unique_index=32 ,so max_index must be same
1919
max_index_length=1000 # index length
1920
###We are trying (example with N=5):
1921
###create table crash_q (q0 char(5) not null,unique (q0))
1922
###insert into crash_q values('aaaaa')
1923
### 4096:FAIL 819:OK 2457:FAIL 1147:FAIL 885:OK 1016:FAIL 911:OK 963:OK 989:OK 1002:FAIL 992:OK 997:OK 999:OK 1000:OK 1001:FAIL
1924
max_index_name=64 # index name length
1925
###We are trying (example with N=5):
1926
###create index crash_qaaaaa on crash_me (a)
1927
### 256:FAIL 51:OK 153:FAIL 72:FAIL 55:OK 63:FAIL 57:OK 60:FAIL 58:FAIL
1928
max_index_part_length=255 # max index part length
1929
###We are trying (example with N=5):
1930
###create table crash_q (q char(5) not null,unique(q))
1931
###insert into crash_q (q) values ('aaaaa')
1932
###select q from crash_q
1933
### 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
1934
max_index_parts=16 # index parts
1935
###We are trying (example with N=5):
1936
###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)
1937
###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)
1938
###select q0 from crash_q
1939
### 32:FAIL 7:OK 19:FAIL 10:OK 14:OK 16:FAIL 15:OK
1940
max_index_varchar_part_length=255 # index varchar part length
1941
###We are trying (example with N=5):
1942
###create table crash_q (q varchar(5) not null,unique(q))
1943
###insert into crash_q (q) values ('aaaaa')
1944
###select q from crash_q
1945
### 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
1946
max_row_length=65534 # max table row length (without blobs)
1947
###We are trying (example with N=5):
1948
###create table crash_q (q0 char(5) not null)
1949
###insert into crash_q values ('aaaaa')
1950
### 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
1951
max_row_length_with_null=65502 # table row length with nulls (without blobs)
1952
###We are trying (example with N=5):
1953
###create table crash_q (q0 char(5) )
1954
###insert into crash_q values ('aaaaa')
1955
### 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
1956
max_select_alias_name=+512 # select alias name length
1957
###We are trying (example with N=5):
1958
###select b as aaaaa from crash_me
1959
max_stack_expression=836 # stacked expressions
1960
###We are trying (example with N=5):
1961
###select 1+(1+(1+(1+(1+(1)))))
1962
### 1000:FAIL 200:OK 600:OK 800:OK 900:FAIL 820:OK 860:FAIL 828:OK 844:FAIL 831:OK 837:FAIL 832:OK 834:OK 835:OK 836:OK
1963
max_table_alias_name=+512 # table alias name length
1964
###We are trying (example with N=5):
1965
###select aaaaa.b from crash_me aaaaa
1966
max_table_name=64 # table name length
1967
###We are trying (example with N=5):
1968
###create table crash_qaaaaa (q integer)
1969
###insert into crash_qaaaaa values(1)
1970
###select * from crash_qaaaaa
1971
### 256:FAIL 51:OK 153:FAIL 72:FAIL 55:OK 63:FAIL 57:OK 60:FAIL 58:FAIL
1972
max_text_size=1048543 # max text or blob size
1973
###We are trying (example with N=5):
1974
###create table crash_q (q mediumtext)
1975
###insert into crash_q values ('aaaaa')
1976
###select * from crash_q
1977
### 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
1978
max_unique_index=32 # unique indexes
1979
###We are trying (example with N=5):
1980
###create table crash_q (q integer,q1 integer not null,unique (q1),q2 integer not null,unique (q2),q3 integer not null,uniq...(72)
1981
###insert into crash_q (q,q1,q2,q3,q4,q5) values (1,1,1,1,1,1)
1982
###select q from crash_q
1983
### 32:OK 48:FAIL 35:FAIL 33:FAIL
1984
max_varchar_size=1048543 # max varchar() size
1985
###We are trying (example with N=5):
1986
###create table crash_q (q varchar(5))
1987
###insert into crash_q values ('aaaaa')
1988
###select * from crash_q
1989
### 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
1991
###< select * from crash_me minus select * from crash_me3
1992
###> execute error:You 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
1994
###As far as some queries didnt return OK, result is NO
1995
minus_incompat=no # minus (incompatible lists)
1996
###< select * from crash_me minus select * from crash_me2
1997
###> execute error:You 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
1999
###As far as some queries didnt return OK, result is NO
2000
minus_neg=yes # Calculate 1--1
2002
###<select a--1 from crash_me
2004
multi_drop=yes # many tables to drop table
2005
###< create table crash_q (a int)
2007
###< create table crash_q2 (a int)
2009
###< drop table crash_q,crash_q2
2012
###As far as all queries returned OK, result is YES
2013
multi_null_in_unique=yes # null in unique index
2014
###< create table crash_q (q integer, x integer,unique (q))
2016
###< insert into crash_q(x) values(1)
2018
###< insert into crash_q(x) values(2)
2020
###< drop table crash_q
2023
###As far as all queries returned OK, result is YES
2024
multi_strings=yes # Multiple line strings
2026
###<select a from crash_me where b < 'a'
2029
multi_table_delete=yes # DELETE FROM table1,table2...
2030
###< create table crash_q (a integer,b char(10))
2032
###< insert into crash_q values(1,'c')
2034
###< delete crash_q.* from crash_q,crash_me where crash_q.a=crash_me.a
2036
###< drop table crash_q
2039
###As far as all queries returned OK, result is YES
2040
multi_table_update=yes # Update with many tables
2041
###< create table crash_q (a integer,b char(10))
2043
###< insert into crash_q values(1,'c')
2045
###< update crash_q left join crash_me on crash_q.a=crash_me.a set crash_q.b=crash_me.b
2048
###<select b from crash_q
2051
###< drop table crash_q
2053
natural_join=yes # natural join
2054
###< select * from crash_me natural join crash_me3
2057
###As far as all queries returned OK, result is YES
2058
natural_join_incompat=yes # natural join (incompatible lists)
2059
###< select c1 from crash_me natural join crash_me2
2062
###As far as all queries returned OK, result is YES
2063
natural_left_outer_join=yes # natural left outer join
2064
###< select c1 from crash_me natural left join crash_me2
2067
###As far as all queries returned OK, result is YES
2068
no_primary_key=yes # Tables without primary key
2069
###< create table crash_me (a integer not null,b char(10) not null)
2071
###< insert into crash_me (a,b) values (1,'a')
2073
not_id_between=no # NOT ID BETWEEN interprets as ID NOT BETWEEN
2074
###< create table crash_me_b (i int)
2076
###< insert into crash_me_b values(2)
2078
###< insert into crash_me_b values(5)
2081
###<select i from crash_me_b where not i between 1 and 3
2082
###> didn't return any result:
2084
###< drop table crash_me_b
2086
null_concat_expr=yes # Is concat('a',NULL) = NULL
2088
###<select concat('a',NULL)
2090
null_in_index=yes # null in index
2091
###< create table crash_q (a char(10),index (a))
2093
###< insert into crash_q values (NULL)
2096
###<select * from crash_q
2099
###< drop table crash_q
2101
null_in_unique=yes # null in unique index
2102
###< create table crash_q (q integer,unique (q))
2104
###< insert into crash_q (q) values(NULL)
2106
###< insert into crash_q (q) values(NULL)
2108
###< drop table crash_q
2111
###As far as all queries returned OK, result is YES
2112
null_num_expr=yes # Is 1+NULL = NULL
2116
nulls_in_unique=yes # null combination in unique index
2117
###< create table crash_q (q integer,q1 integer,unique (q,q1))
2119
###< insert into crash_q (q,q1) values(1,NULL)
2121
###< insert into crash_q (q,q1) values(1,NULL)
2123
###< drop table crash_q
2126
###As far as all queries returned OK, result is YES
2127
odbc_left_outer_join=yes # left outer join odbc style
2128
###< select crash_me.a from { oj crash_me left outer join crash_me2 ON crash_me.a=crash_me2.a }
2131
###As far as all queries returned OK, result is YES
2132
operating_system=Linux 2.4.21-199-smp4G i686 # crash-me tested on
2133
order_by=yes # Order by
2134
###< select a from crash_me order by a
2137
###As far as all queries returned OK, result is YES
2138
order_by_alias=yes # Order by alias
2139
###< select a as ab from crash_me order by ab
2142
###As far as all queries returned OK, result is YES
2143
order_by_function=yes # Order by function
2144
###< select a from crash_me order by a+1
2147
###As far as all queries returned OK, result is YES
2148
order_by_position=yes # Order by position
2149
###< select a from crash_me order by 1
2152
###As far as all queries returned OK, result is YES
2153
order_on_unused=yes # Order by on unused column
2154
###< select b from crash_me order by a
2157
###As far as all queries returned OK, result is YES
2158
position_of_null=first # Where is null values in sorted recordset
2159
###< insert into crash_me_n (i) values(1)
2161
###< insert into crash_me_n values(2,2)
2163
###< insert into crash_me_n values(3,3)
2165
###< insert into crash_me_n values(4,4)
2167
###< insert into crash_me_n (i) values(5)
2170
###< select r from crash_me_n order by r
2176
position_of_null_desc=last # Where is null values in sorted recordset (DESC)
2177
###< select r from crash_me_n order by r desc
2183
primary_key_in_create=yes # primary key in create table
2184
###< create table crash_q (q integer not null,primary key (q))
2186
###< drop table crash_q
2189
###As far as all queries returned OK, result is YES
2190
psm_functions=no # PSM functions (ANSI SQL)
2191
###< create table crash_q (a int)
2193
###< create function crash_func(in a1 int, in b1 int) returns int language sql deterministic contains sql begin return a1 * b1; end
2194
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(in a1 int, in b1 int) returns int language sql deterministic c
2195
###< insert into crash_q values(crash_func(2,4))
2196
###> execute error:You 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
2197
###< select a,crash_func(a,2) from crash_q
2198
###> execute error:You 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
2199
###< drop function crash_func cascade
2200
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'cascade' at line 1
2201
###< drop table crash_q
2204
###As far as some queries didnt return OK, result is NO
2205
psm_modules=no # PSM modules (ANSI SQL)
2206
###< create table crash_q (a int,b int)
2208
###< 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
2209
###> execute error:You 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
2210
###< call crash_proc(1,10)
2211
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'call crash_proc(1,10)' at line 1
2212
###< drop module crash_m cascade
2213
###> execute error:You 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
2214
###< drop table crash_q cascade
2217
###As far as some queries didnt return OK, result is NO
2218
psm_procedures=no # PSM procedures (ANSI SQL)
2219
###< create table crash_q (a int,b int)
2221
###< 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
2222
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'procedure crash_proc(in a1 int, in b1 int) language sql modifie
2223
###< call crash_proc(1,10)
2224
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'call crash_proc(1,10)' at line 1
2225
###< drop procedure crash_proc
2226
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'procedure crash_proc' at line 1
2227
###< drop table crash_q
2230
###As far as some queries didnt return OK, result is NO
2231
psm_trigger=no # Triggers (ANSI SQL)
2232
###< create table crash_q (a int ,b int)
2234
###< create trigger crash_trigger after insert on crash_q referencing new table as new_a when (localtime > time '18:00:00') begin atomic end
2235
###> execute error:You 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
2236
###< insert into crash_q values(1,2)
2238
###< drop trigger crash_trigger
2239
###> execute error:You 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
2240
###< drop table crash_q
2243
###As far as some queries didnt return OK, result is NO
2244
query_size=1048574 # query size
2245
quote_ident_with_"=error # " as identifier quote (ANSI SQL)
2247
###<select "A" from crash_me
2249
###We expected '1' but got 'A'
2250
quote_ident_with_[=no # [] as identifier quote
2252
###<select [A] from crash_me
2253
###> 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
2254
quote_ident_with_`=yes # ` as identifier quote
2256
###<select `A` from crash_me
2258
quote_ident_with_dbl_"=no # Double "" in identifiers as "
2259
###< create table crash_me1 ("abc""d" integer)
2260
###> execute error:You 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
2261
###< drop table crash_me1
2262
###> execute error:Unknown table 'crash_me1'
2264
###As far as some queries didnt return OK, result is NO
2265
quote_with_"=yes # Allows ' and " as string markers
2266
###< select a from crash_me where b<"c"
2269
###As far as all queries returned OK, result is YES
2270
recursive_subqueries=+64 # recursive subqueries
2271
###We are trying (example with N=5):
2272
###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)
2273
remember_end_space=no # Remembers end space in char()
2274
###< create table crash_q (a char(10))
2276
###< insert into crash_q values('hello ')
2279
###<select a from crash_q where a = 'hello '
2281
###We expected 'hello ' but got 'hello'
2283
###< drop table crash_q
2285
remember_end_space_varchar=no # Remembers end space in varchar()
2286
###< create table crash_q (a varchar(10))
2288
###< insert into crash_q values('hello ')
2291
###<select a from crash_q where a = 'hello '
2293
###We expected 'hello ' but got 'hello'
2295
###< drop table crash_q
2297
rename_table=yes # rename table
2298
###< create table crash_q (a integer, b integer,c1 CHAR(10))
2300
###< rename table crash_q to crash_q1
2302
###< drop table crash_q1
2305
###As far as all queries returned OK, result is YES
2306
repeat_string_size=1048576 # return string size from function
2307
###We are trying (example with N=5):
2308
###select repeat('a',5)
2309
### 4000000:FAIL 800000:OK 2400000:FAIL 1120000:FAIL 864000:OK 992000:OK 1056000:FAIL 1004800:OK 1030400:OK 1043200:OK 1049600:FAIL 1044480:OK 1047040:OK 1048320:OK 1048960:FAIL 1048448:OK 1048704:FAIL 1048499:OK 1048601:FAIL 1048520:OK 1048560:OK 1048580:FAIL 1048564:OK 1048572:OK 1048576:OK 1048578:FAIL 1048577:FAIL
2310
reserved_word_ansi-92/99_absolute=no # Keyword ABSOLUTE
2311
###< create table crash_me10 (ABSOLUTE int not null)
2313
###< drop table crash_me10
2316
###As far as all queries returned OK, result is NO
2317
reserved_word_ansi-92/99_action=no # Keyword ACTION
2318
###< create table crash_me10 (ACTION int not null)
2320
###< drop table crash_me10
2323
###As far as all queries returned OK, result is NO
2324
reserved_word_ansi-92/99_add=yes # Keyword ADD
2325
###< create table crash_me10 (ADD int not null)
2326
###> execute error:You 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
2327
###< drop table crash_me10
2328
###> execute error:Unknown table 'crash_me10'
2330
###As far as some queries didnt return OK, result is YES
2331
reserved_word_ansi-92/99_after=no # Keyword AFTER
2332
###< create table crash_me10 (AFTER int not null)
2334
###< drop table crash_me10
2337
###As far as all queries returned OK, result is NO
2338
reserved_word_ansi-92/99_alias=no # Keyword ALIAS
2339
###< create table crash_me10 (ALIAS int not null)
2341
###< drop table crash_me10
2344
###As far as all queries returned OK, result is NO
2345
reserved_word_ansi-92/99_all=yes # Keyword ALL
2346
###< create table crash_me10 (ALL int not null)
2347
###> execute error:You 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
2348
###< drop table crash_me10
2349
###> execute error:Unknown table 'crash_me10'
2351
###As far as some queries didnt return OK, result is YES
2352
reserved_word_ansi-92/99_allocate=no # Keyword ALLOCATE
2353
###< create table crash_me10 (ALLOCATE int not null)
2355
###< drop table crash_me10
2358
###As far as all queries returned OK, result is NO
2359
reserved_word_ansi-92/99_alter=yes # Keyword ALTER
2360
###< create table crash_me10 (ALTER int not null)
2361
###> execute error:You 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
2362
###< drop table crash_me10
2363
###> execute error:Unknown table 'crash_me10'
2365
###As far as some queries didnt return OK, result is YES
2366
reserved_word_ansi-92/99_and=yes # Keyword AND
2367
###< create table crash_me10 (AND int not null)
2368
###> execute error:You 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
2369
###< drop table crash_me10
2370
###> execute error:Unknown table 'crash_me10'
2372
###As far as some queries didnt return OK, result is YES
2373
reserved_word_ansi-92/99_any=no # Keyword ANY
2374
###< create table crash_me10 (ANY int not null)
2376
###< drop table crash_me10
2379
###As far as all queries returned OK, result is NO
2380
reserved_word_ansi-92/99_are=no # Keyword ARE
2381
###< create table crash_me10 (ARE int not null)
2383
###< drop table crash_me10
2386
###As far as all queries returned OK, result is NO
2387
reserved_word_ansi-92/99_as=yes # Keyword AS
2388
###< create table crash_me10 (AS int not null)
2389
###> execute error:You 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
2390
###< drop table crash_me10
2391
###> execute error:Unknown table 'crash_me10'
2393
###As far as some queries didnt return OK, result is YES
2394
reserved_word_ansi-92/99_asc=yes # Keyword ASC
2395
###< create table crash_me10 (ASC int not null)
2396
###> execute error:You 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
2397
###< drop table crash_me10
2398
###> execute error:Unknown table 'crash_me10'
2400
###As far as some queries didnt return OK, result is YES
2401
reserved_word_ansi-92/99_assertion=no # Keyword ASSERTION
2402
###< create table crash_me10 (ASSERTION int not null)
2404
###< drop table crash_me10
2407
###As far as all queries returned OK, result is NO
2408
reserved_word_ansi-92/99_at=no # Keyword AT
2409
###< create table crash_me10 (AT int not null)
2411
###< drop table crash_me10
2414
###As far as all queries returned OK, result is NO
2415
reserved_word_ansi-92/99_authorization=no # Keyword AUTHORIZATION
2416
###< create table crash_me10 (AUTHORIZATION int not null)
2418
###< drop table crash_me10
2421
###As far as all queries returned OK, result is NO
2422
reserved_word_ansi-92/99_before=yes # Keyword BEFORE
2423
###< create table crash_me10 (BEFORE int not null)
2424
###> execute error:You 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
2425
###< drop table crash_me10
2426
###> execute error:Unknown table 'crash_me10'
2428
###As far as some queries didnt return OK, result is YES
2429
reserved_word_ansi-92/99_begin=no # Keyword BEGIN
2430
###< create table crash_me10 (BEGIN int not null)
2432
###< drop table crash_me10
2435
###As far as all queries returned OK, result is NO
2436
reserved_word_ansi-92/99_bit=no # Keyword BIT
2437
###< create table crash_me10 (BIT int not null)
2439
###< drop table crash_me10
2442
###As far as all queries returned OK, result is NO
2443
reserved_word_ansi-92/99_boolean=no # Keyword BOOLEAN
2444
###< create table crash_me10 (BOOLEAN int not null)
2446
###< drop table crash_me10
2449
###As far as all queries returned OK, result is NO
2450
reserved_word_ansi-92/99_both=yes # Keyword BOTH
2451
###< create table crash_me10 (BOTH int not null)
2452
###> execute error:You 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
2453
###< drop table crash_me10
2454
###> execute error:Unknown table 'crash_me10'
2456
###As far as some queries didnt return OK, result is YES
2457
reserved_word_ansi-92/99_breadth=no # Keyword BREADTH
2458
###< create table crash_me10 (BREADTH int not null)
2460
###< drop table crash_me10
2463
###As far as all queries returned OK, result is NO
2464
reserved_word_ansi-92/99_by=yes # Keyword BY
2465
###< create table crash_me10 (BY int not null)
2466
###> execute error:You 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
2467
###< drop table crash_me10
2468
###> execute error:Unknown table 'crash_me10'
2470
###As far as some queries didnt return OK, result is YES
2471
reserved_word_ansi-92/99_call=no # Keyword CALL
2472
###< create table crash_me10 (CALL int not null)
2474
###< drop table crash_me10
2477
###As far as all queries returned OK, result is NO
2478
reserved_word_ansi-92/99_cascade=yes # Keyword CASCADE
2479
###< create table crash_me10 (CASCADE int not null)
2480
###> execute error:You 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
2481
###< drop table crash_me10
2482
###> execute error:Unknown table 'crash_me10'
2484
###As far as some queries didnt return OK, result is YES
2485
reserved_word_ansi-92/99_cascaded=no # Keyword CASCADED
2486
###< create table crash_me10 (CASCADED int not null)
2488
###< drop table crash_me10
2491
###As far as all queries returned OK, result is NO
2492
reserved_word_ansi-92/99_case=yes # Keyword CASE
2493
###< create table crash_me10 (CASE int not null)
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 'CASE int not null)' at line 1
2495
###< drop table crash_me10
2496
###> execute error:Unknown table 'crash_me10'
2498
###As far as some queries didnt return OK, result is YES
2499
reserved_word_ansi-92/99_cast=no # Keyword CAST
2500
###< create table crash_me10 (CAST int not null)
2502
###< drop table crash_me10
2505
###As far as all queries returned OK, result is NO
2506
reserved_word_ansi-92/99_catalog=no # Keyword CATALOG
2507
###< create table crash_me10 (CATALOG int not null)
2509
###< drop table crash_me10
2512
###As far as all queries returned OK, result is NO
2513
reserved_word_ansi-92/99_char=yes # Keyword CHAR
2514
###< create table crash_me10 (CHAR int not null)
2515
###> execute error:You 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
2516
###< drop table crash_me10
2517
###> execute error:Unknown table 'crash_me10'
2519
###As far as some queries didnt return OK, result is YES
2520
reserved_word_ansi-92/99_character=yes # Keyword CHARACTER
2521
###< create table crash_me10 (CHARACTER int not null)
2522
###> execute error:You 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
2523
###< drop table crash_me10
2524
###> execute error:Unknown table 'crash_me10'
2526
###As far as some queries didnt return OK, result is YES
2527
reserved_word_ansi-92/99_check=yes # Keyword CHECK
2528
###< create table crash_me10 (CHECK int not null)
2529
###> execute error:You 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
2530
###< drop table crash_me10
2531
###> execute error:Unknown table 'crash_me10'
2533
###As far as some queries didnt return OK, result is YES
2534
reserved_word_ansi-92/99_close=no # Keyword CLOSE
2535
###< create table crash_me10 (CLOSE int not null)
2537
###< drop table crash_me10
2540
###As far as all queries returned OK, result is NO
2541
reserved_word_ansi-92/99_collate=yes # Keyword COLLATE
2542
###< create table crash_me10 (COLLATE int not null)
2543
###> execute error:You 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
2544
###< drop table crash_me10
2545
###> execute error:Unknown table 'crash_me10'
2547
###As far as some queries didnt return OK, result is YES
2548
reserved_word_ansi-92/99_collation=no # Keyword COLLATION
2549
###< create table crash_me10 (COLLATION int not null)
2551
###< drop table crash_me10
2554
###As far as all queries returned OK, result is NO
2555
reserved_word_ansi-92/99_column=yes # Keyword COLUMN
2556
###< create table crash_me10 (COLUMN int not null)
2557
###> execute error:You 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
2558
###< drop table crash_me10
2559
###> execute error:Unknown table 'crash_me10'
2561
###As far as some queries didnt return OK, result is YES
2562
reserved_word_ansi-92/99_commit=no # Keyword COMMIT
2563
###< create table crash_me10 (COMMIT int not null)
2565
###< drop table crash_me10
2568
###As far as all queries returned OK, result is NO
2569
reserved_word_ansi-92/99_completion=no # Keyword COMPLETION
2570
###< create table crash_me10 (COMPLETION int not null)
2572
###< drop table crash_me10
2575
###As far as all queries returned OK, result is NO
2576
reserved_word_ansi-92/99_connect=no # Keyword CONNECT
2577
###< create table crash_me10 (CONNECT int not null)
2579
###< drop table crash_me10
2582
###As far as all queries returned OK, result is NO
2583
reserved_word_ansi-92/99_connection=no # Keyword CONNECTION
2584
###< create table crash_me10 (CONNECTION int not null)
2586
###< drop table crash_me10
2589
###As far as all queries returned OK, result is NO
2590
reserved_word_ansi-92/99_constraint=yes # Keyword CONSTRAINT
2591
###< create table crash_me10 (CONSTRAINT int not null)
2592
###> execute error:You 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
2593
###< drop table crash_me10
2594
###> execute error:Unknown table 'crash_me10'
2596
###As far as some queries didnt return OK, result is YES
2597
reserved_word_ansi-92/99_constraints=no # Keyword CONSTRAINTS
2598
###< create table crash_me10 (CONSTRAINTS int not null)
2600
###< drop table crash_me10
2603
###As far as all queries returned OK, result is NO
2604
reserved_word_ansi-92/99_continue=no # Keyword CONTINUE
2605
###< create table crash_me10 (CONTINUE int not null)
2607
###< drop table crash_me10
2610
###As far as all queries returned OK, result is NO
2611
reserved_word_ansi-92/99_corresponding=no # Keyword CORRESPONDING
2612
###< create table crash_me10 (CORRESPONDING int not null)
2614
###< drop table crash_me10
2617
###As far as all queries returned OK, result is NO
2618
reserved_word_ansi-92/99_create=yes # Keyword CREATE
2619
###< create table crash_me10 (CREATE int not null)
2620
###> execute error:You 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
2621
###< drop table crash_me10
2622
###> execute error:Unknown table 'crash_me10'
2624
###As far as some queries didnt return OK, result is YES
2625
reserved_word_ansi-92/99_cross=yes # Keyword CROSS
2626
###< create table crash_me10 (CROSS int not null)
2627
###> execute error:You 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
2628
###< drop table crash_me10
2629
###> execute error:Unknown table 'crash_me10'
2631
###As far as some queries didnt return OK, result is YES
2632
reserved_word_ansi-92/99_current=no # Keyword CURRENT
2633
###< create table crash_me10 (CURRENT int not null)
2635
###< drop table crash_me10
2638
###As far as all queries returned OK, result is NO
2639
reserved_word_ansi-92/99_current_date=yes # Keyword CURRENT_DATE
2640
###< create table crash_me10 (CURRENT_DATE int not null)
2641
###> execute error:You 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
2642
###< drop table crash_me10
2643
###> execute error:Unknown table 'crash_me10'
2645
###As far as some queries didnt return OK, result is YES
2646
reserved_word_ansi-92/99_current_time=yes # Keyword CURRENT_TIME
2647
###< create table crash_me10 (CURRENT_TIME int not null)
2648
###> execute error:You 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
2649
###< drop table crash_me10
2650
###> execute error:Unknown table 'crash_me10'
2652
###As far as some queries didnt return OK, result is YES
2653
reserved_word_ansi-92/99_current_timestamp=yes # Keyword CURRENT_TIMESTAMP
2654
###< create table crash_me10 (CURRENT_TIMESTAMP int not null)
2655
###> execute error:You 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
2656
###< drop table crash_me10
2657
###> execute error:Unknown table 'crash_me10'
2659
###As far as some queries didnt return OK, result is YES
2660
reserved_word_ansi-92/99_current_user=no # Keyword CURRENT_USER
2661
###< create table crash_me10 (CURRENT_USER int not null)
2663
###< drop table crash_me10
2666
###As far as all queries returned OK, result is NO
2667
reserved_word_ansi-92/99_cursor=no # Keyword CURSOR
2668
###< create table crash_me10 (CURSOR int not null)
2670
###< drop table crash_me10
2673
###As far as all queries returned OK, result is NO
2674
reserved_word_ansi-92/99_cycle=no # Keyword CYCLE
2675
###< create table crash_me10 (CYCLE int not null)
2677
###< drop table crash_me10
2680
###As far as all queries returned OK, result is NO
2681
reserved_word_ansi-92/99_data=no # Keyword DATA
2682
###< create table crash_me10 (DATA int not null)
2684
###< drop table crash_me10
2687
###As far as all queries returned OK, result is NO
2688
reserved_word_ansi-92/99_date=no # Keyword DATE
2689
###< create table crash_me10 (DATE int not null)
2691
###< drop table crash_me10
2694
###As far as all queries returned OK, result is NO
2695
reserved_word_ansi-92/99_day=no # Keyword DAY
2696
###< create table crash_me10 (DAY int not null)
2698
###< drop table crash_me10
2701
###As far as all queries returned OK, result is NO
2702
reserved_word_ansi-92/99_deallocate=no # Keyword DEALLOCATE
2703
###< create table crash_me10 (DEALLOCATE int not null)
2705
###< drop table crash_me10
2708
###As far as all queries returned OK, result is NO
2709
reserved_word_ansi-92/99_dec=yes # Keyword DEC
2710
###< create table crash_me10 (DEC int not null)
2711
###> execute error:You 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
2712
###< drop table crash_me10
2713
###> execute error:Unknown table 'crash_me10'
2715
###As far as some queries didnt return OK, result is YES
2716
reserved_word_ansi-92/99_decimal=yes # Keyword DECIMAL
2717
###< create table crash_me10 (DECIMAL int not null)
2718
###> execute error:You 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
2719
###< drop table crash_me10
2720
###> execute error:Unknown table 'crash_me10'
2722
###As far as some queries didnt return OK, result is YES
2723
reserved_word_ansi-92/99_declare=no # Keyword DECLARE
2724
###< create table crash_me10 (DECLARE int not null)
2726
###< drop table crash_me10
2729
###As far as all queries returned OK, result is NO
2730
reserved_word_ansi-92/99_default=yes # Keyword DEFAULT
2731
###< create table crash_me10 (DEFAULT int not null)
2732
###> execute error:You 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
2733
###< drop table crash_me10
2734
###> execute error:Unknown table 'crash_me10'
2736
###As far as some queries didnt return OK, result is YES
2737
reserved_word_ansi-92/99_deferrable=no # Keyword DEFERRABLE
2738
###< create table crash_me10 (DEFERRABLE int not null)
2740
###< drop table crash_me10
2743
###As far as all queries returned OK, result is NO
2744
reserved_word_ansi-92/99_deferred=no # Keyword DEFERRED
2745
###< create table crash_me10 (DEFERRED int not null)
2747
###< drop table crash_me10
2750
###As far as all queries returned OK, result is NO
2751
reserved_word_ansi-92/99_delete=yes # Keyword DELETE
2752
###< create table crash_me10 (DELETE int not null)
2753
###> execute error:You 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
2754
###< drop table crash_me10
2755
###> execute error:Unknown table 'crash_me10'
2757
###As far as some queries didnt return OK, result is YES
2758
reserved_word_ansi-92/99_depth=no # Keyword DEPTH
2759
###< create table crash_me10 (DEPTH int not null)
2761
###< drop table crash_me10
2764
###As far as all queries returned OK, result is NO
2765
reserved_word_ansi-92/99_desc=yes # Keyword DESC
2766
###< create table crash_me10 (DESC int not null)
2767
###> execute error:You 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
2768
###< drop table crash_me10
2769
###> execute error:Unknown table 'crash_me10'
2771
###As far as some queries didnt return OK, result is YES
2772
reserved_word_ansi-92/99_describe=yes # Keyword DESCRIBE
2773
###< create table crash_me10 (DESCRIBE int not null)
2774
###> execute error:You 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
2775
###< drop table crash_me10
2776
###> execute error:Unknown table 'crash_me10'
2778
###As far as some queries didnt return OK, result is YES
2779
reserved_word_ansi-92/99_descriptor=no # Keyword DESCRIPTOR
2780
###< create table crash_me10 (DESCRIPTOR int not null)
2782
###< drop table crash_me10
2785
###As far as all queries returned OK, result is NO
2786
reserved_word_ansi-92/99_diagnostics=no # Keyword DIAGNOSTICS
2787
###< create table crash_me10 (DIAGNOSTICS int not null)
2789
###< drop table crash_me10
2792
###As far as all queries returned OK, result is NO
2793
reserved_word_ansi-92/99_dictionary=no # Keyword DICTIONARY
2794
###< create table crash_me10 (DICTIONARY int not null)
2796
###< drop table crash_me10
2799
###As far as all queries returned OK, result is NO
2800
reserved_word_ansi-92/99_disconnect=no # Keyword DISCONNECT
2801
###< create table crash_me10 (DISCONNECT int not null)
2803
###< drop table crash_me10
2806
###As far as all queries returned OK, result is NO
2807
reserved_word_ansi-92/99_distinct=yes # Keyword DISTINCT
2808
###< create table crash_me10 (DISTINCT int not null)
2809
###> execute error:You 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
2810
###< drop table crash_me10
2811
###> execute error:Unknown table 'crash_me10'
2813
###As far as some queries didnt return OK, result is YES
2814
reserved_word_ansi-92/99_domain=no # Keyword DOMAIN
2815
###< create table crash_me10 (DOMAIN int not null)
2817
###< drop table crash_me10
2820
###As far as all queries returned OK, result is NO
2821
reserved_word_ansi-92/99_double=yes # Keyword DOUBLE
2822
###< create table crash_me10 (DOUBLE int not null)
2823
###> execute error:You 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
2824
###< drop table crash_me10
2825
###> execute error:Unknown table 'crash_me10'
2827
###As far as some queries didnt return OK, result is YES
2828
reserved_word_ansi-92/99_drop=yes # Keyword DROP
2829
###< create table crash_me10 (DROP int not null)
2830
###> execute error:You 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
2831
###< drop table crash_me10
2832
###> execute error:Unknown table 'crash_me10'
2834
###As far as some queries didnt return OK, result is YES
2835
reserved_word_ansi-92/99_each=no # Keyword EACH
2836
###< create table crash_me10 (EACH int not null)
2838
###< drop table crash_me10
2841
###As far as all queries returned OK, result is NO
2842
reserved_word_ansi-92/99_else=yes # Keyword ELSE
2843
###< create table crash_me10 (ELSE int not null)
2844
###> execute error:You 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
2845
###< drop table crash_me10
2846
###> execute error:Unknown table 'crash_me10'
2848
###As far as some queries didnt return OK, result is YES
2849
reserved_word_ansi-92/99_elseif=no # Keyword ELSEIF
2850
###< create table crash_me10 (ELSEIF int not null)
2852
###< drop table crash_me10
2855
###As far as all queries returned OK, result is NO
2856
reserved_word_ansi-92/99_end=no # Keyword END
2857
###< create table crash_me10 (END int not null)
2859
###< drop table crash_me10
2862
###As far as all queries returned OK, result is NO
2863
reserved_word_ansi-92/99_end-exec=yes # Keyword END-EXEC
2864
###< create table crash_me10 (END-EXEC int not null)
2865
###> execute error:You 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
2866
###< drop table crash_me10
2867
###> execute error:Unknown table 'crash_me10'
2869
###As far as some queries didnt return OK, result is YES
2870
reserved_word_ansi-92/99_equals=no # Keyword EQUALS
2871
###< create table crash_me10 (EQUALS int not null)
2873
###< drop table crash_me10
2876
###As far as all queries returned OK, result is NO
2877
reserved_word_ansi-92/99_escape=no # Keyword ESCAPE
2878
###< create table crash_me10 (ESCAPE int not null)
2880
###< drop table crash_me10
2883
###As far as all queries returned OK, result is NO
2884
reserved_word_ansi-92/99_except=no # Keyword EXCEPT
2885
###< create table crash_me10 (EXCEPT int not null)
2887
###< drop table crash_me10
2890
###As far as all queries returned OK, result is NO
2891
reserved_word_ansi-92/99_exception=no # Keyword EXCEPTION
2892
###< create table crash_me10 (EXCEPTION int not null)
2894
###< drop table crash_me10
2897
###As far as all queries returned OK, result is NO
2898
reserved_word_ansi-92/99_exec=no # Keyword EXEC
2899
###< create table crash_me10 (EXEC int not null)
2901
###< drop table crash_me10
2904
###As far as all queries returned OK, result is NO
2905
reserved_word_ansi-92/99_execute=no # Keyword EXECUTE
2906
###< create table crash_me10 (EXECUTE int not null)
2908
###< drop table crash_me10
2911
###As far as all queries returned OK, result is NO
2912
reserved_word_ansi-92/99_external=no # Keyword EXTERNAL
2913
###< create table crash_me10 (EXTERNAL int not null)
2915
###< drop table crash_me10
2918
###As far as all queries returned OK, result is NO
2919
reserved_word_ansi-92/99_false=yes # Keyword FALSE
2920
###< create table crash_me10 (FALSE int not null)
2921
###> execute error:You 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
2922
###< drop table crash_me10
2923
###> execute error:Unknown table 'crash_me10'
2925
###As far as some queries didnt return OK, result is YES
2926
reserved_word_ansi-92/99_fetch=no # Keyword FETCH
2927
###< create table crash_me10 (FETCH int not null)
2929
###< drop table crash_me10
2932
###As far as all queries returned OK, result is NO
2933
reserved_word_ansi-92/99_first=no # Keyword FIRST
2934
###< create table crash_me10 (FIRST int not null)
2936
###< drop table crash_me10
2939
###As far as all queries returned OK, result is NO
2940
reserved_word_ansi-92/99_float=yes # Keyword FLOAT
2941
###< create table crash_me10 (FLOAT int not null)
2942
###> execute error:You 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
2943
###< drop table crash_me10
2944
###> execute error:Unknown table 'crash_me10'
2946
###As far as some queries didnt return OK, result is YES
2947
reserved_word_ansi-92/99_for=yes # Keyword FOR
2948
###< create table crash_me10 (FOR int not null)
2949
###> execute error:You 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
2950
###< drop table crash_me10
2951
###> execute error:Unknown table 'crash_me10'
2953
###As far as some queries didnt return OK, result is YES
2954
reserved_word_ansi-92/99_foreign=yes # Keyword FOREIGN
2955
###< create table crash_me10 (FOREIGN int not null)
2956
###> execute error:You 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
2957
###< drop table crash_me10
2958
###> execute error:Unknown table 'crash_me10'
2960
###As far as some queries didnt return OK, result is YES
2961
reserved_word_ansi-92/99_found=no # Keyword FOUND
2962
###< create table crash_me10 (FOUND int not null)
2964
###< drop table crash_me10
2967
###As far as all queries returned OK, result is NO
2968
reserved_word_ansi-92/99_from=yes # Keyword FROM
2969
###< create table crash_me10 (FROM int not null)
2970
###> execute error:You 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
2971
###< drop table crash_me10
2972
###> execute error:Unknown table 'crash_me10'
2974
###As far as some queries didnt return OK, result is YES
2975
reserved_word_ansi-92/99_full=no # Keyword FULL
2976
###< create table crash_me10 (FULL int not null)
2978
###< drop table crash_me10
2981
###As far as all queries returned OK, result is NO
2982
reserved_word_ansi-92/99_general=no # Keyword GENERAL
2983
###< create table crash_me10 (GENERAL int not null)
2985
###< drop table crash_me10
2988
###As far as all queries returned OK, result is NO
2989
reserved_word_ansi-92/99_get=no # Keyword GET
2990
###< create table crash_me10 (GET int not null)
2992
###< drop table crash_me10
2995
###As far as all queries returned OK, result is NO
2996
reserved_word_ansi-92/99_global=no # Keyword GLOBAL
2997
###< create table crash_me10 (GLOBAL int not null)
2999
###< drop table crash_me10
3002
###As far as all queries returned OK, result is NO
3003
reserved_word_ansi-92/99_go=no # Keyword GO
3004
###< create table crash_me10 (GO int not null)
3006
###< drop table crash_me10
3009
###As far as all queries returned OK, result is NO
3010
reserved_word_ansi-92/99_goto=no # Keyword GOTO
3011
###< create table crash_me10 (GOTO int not null)
3013
###< drop table crash_me10
3016
###As far as all queries returned OK, result is NO
3017
reserved_word_ansi-92/99_grant=yes # Keyword GRANT
3018
###< create table crash_me10 (GRANT int not null)
3019
###> execute error:You 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
3020
###< drop table crash_me10
3021
###> execute error:Unknown table 'crash_me10'
3023
###As far as some queries didnt return OK, result is YES
3024
reserved_word_ansi-92/99_group=yes # Keyword GROUP
3025
###< create table crash_me10 (GROUP int not null)
3026
###> execute error:You 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
3027
###< drop table crash_me10
3028
###> execute error:Unknown table 'crash_me10'
3030
###As far as some queries didnt return OK, result is YES
3031
reserved_word_ansi-92/99_having=yes # Keyword HAVING
3032
###< create table crash_me10 (HAVING int not null)
3033
###> execute error:You 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
3034
###< drop table crash_me10
3035
###> execute error:Unknown table 'crash_me10'
3037
###As far as some queries didnt return OK, result is YES
3038
reserved_word_ansi-92/99_hour=no # Keyword HOUR
3039
###< create table crash_me10 (HOUR int not null)
3041
###< drop table crash_me10
3044
###As far as all queries returned OK, result is NO
3045
reserved_word_ansi-92/99_identity=no # Keyword IDENTITY
3046
###< create table crash_me10 (IDENTITY int not null)
3048
###< drop table crash_me10
3051
###As far as all queries returned OK, result is NO
3052
reserved_word_ansi-92/99_if=yes # Keyword IF
3053
###< create table crash_me10 (IF int not null)
3054
###> execute error:You 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
3055
###< drop table crash_me10
3056
###> execute error:Unknown table 'crash_me10'
3058
###As far as some queries didnt return OK, result is YES
3059
reserved_word_ansi-92/99_ignore=yes # Keyword IGNORE
3060
###< create table crash_me10 (IGNORE int not null)
3061
###> execute error:You 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
3062
###< drop table crash_me10
3063
###> execute error:Unknown table 'crash_me10'
3065
###As far as some queries didnt return OK, result is YES
3066
reserved_word_ansi-92/99_immediate=no # Keyword IMMEDIATE
3067
###< create table crash_me10 (IMMEDIATE int not null)
3069
###< drop table crash_me10
3072
###As far as all queries returned OK, result is NO
3073
reserved_word_ansi-92/99_in=yes # Keyword IN
3074
###< create table crash_me10 (IN int not null)
3075
###> execute error:You 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
3076
###< drop table crash_me10
3077
###> execute error:Unknown table 'crash_me10'
3079
###As far as some queries didnt return OK, result is YES
3080
reserved_word_ansi-92/99_indicator=no # Keyword INDICATOR
3081
###< create table crash_me10 (INDICATOR int not null)
3083
###< drop table crash_me10
3086
###As far as all queries returned OK, result is NO
3087
reserved_word_ansi-92/99_initially=no # Keyword INITIALLY
3088
###< create table crash_me10 (INITIALLY int not null)
3090
###< drop table crash_me10
3093
###As far as all queries returned OK, result is NO
3094
reserved_word_ansi-92/99_inner=yes # Keyword INNER
3095
###< create table crash_me10 (INNER int not null)
3096
###> execute error:You 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
3097
###< drop table crash_me10
3098
###> execute error:Unknown table 'crash_me10'
3100
###As far as some queries didnt return OK, result is YES
3101
reserved_word_ansi-92/99_input=no # Keyword INPUT
3102
###< create table crash_me10 (INPUT int not null)
3104
###< drop table crash_me10
3107
###As far as all queries returned OK, result is NO
3108
reserved_word_ansi-92/99_insert=yes # Keyword INSERT
3109
###< create table crash_me10 (INSERT int not null)
3110
###> execute error:You 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
3111
###< drop table crash_me10
3112
###> execute error:Unknown table 'crash_me10'
3114
###As far as some queries didnt return OK, result is YES
3115
reserved_word_ansi-92/99_int=yes # Keyword INT
3116
###< create table crash_me10 (INT int not null)
3117
###> execute error:You 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
3118
###< drop table crash_me10
3119
###> execute error:Unknown table 'crash_me10'
3121
###As far as some queries didnt return OK, result is YES
3122
reserved_word_ansi-92/99_integer=yes # Keyword INTEGER
3123
###< create table crash_me10 (INTEGER int not null)
3124
###> execute error:You 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
3125
###< drop table crash_me10
3126
###> execute error:Unknown table 'crash_me10'
3128
###As far as some queries didnt return OK, result is YES
3129
reserved_word_ansi-92/99_intersect=no # Keyword INTERSECT
3130
###< create table crash_me10 (INTERSECT int not null)
3132
###< drop table crash_me10
3135
###As far as all queries returned OK, result is NO
3136
reserved_word_ansi-92/99_interval=yes # Keyword INTERVAL
3137
###< create table crash_me10 (INTERVAL int not null)
3138
###> execute error:You 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
3139
###< drop table crash_me10
3140
###> execute error:Unknown table 'crash_me10'
3142
###As far as some queries didnt return OK, result is YES
3143
reserved_word_ansi-92/99_into=yes # Keyword INTO
3144
###< create table crash_me10 (INTO int not null)
3145
###> execute error:You 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
3146
###< drop table crash_me10
3147
###> execute error:Unknown table 'crash_me10'
3149
###As far as some queries didnt return OK, result is YES
3150
reserved_word_ansi-92/99_is=yes # Keyword IS
3151
###< create table crash_me10 (IS int not null)
3152
###> execute error:You 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
3153
###< drop table crash_me10
3154
###> execute error:Unknown table 'crash_me10'
3156
###As far as some queries didnt return OK, result is YES
3157
reserved_word_ansi-92/99_isolation=no # Keyword ISOLATION
3158
###< create table crash_me10 (ISOLATION int not null)
3160
###< drop table crash_me10
3163
###As far as all queries returned OK, result is NO
3164
reserved_word_ansi-92/99_join=yes # Keyword JOIN
3165
###< create table crash_me10 (JOIN int not null)
3166
###> execute error:You 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
3167
###< drop table crash_me10
3168
###> execute error:Unknown table 'crash_me10'
3170
###As far as some queries didnt return OK, result is YES
3171
reserved_word_ansi-92/99_key=yes # Keyword KEY
3172
###< create table crash_me10 (KEY int not null)
3173
###> execute error:You 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
3174
###< drop table crash_me10
3175
###> execute error:Unknown table 'crash_me10'
3177
###As far as some queries didnt return OK, result is YES
3178
reserved_word_ansi-92/99_language=no # Keyword LANGUAGE
3179
###< create table crash_me10 (LANGUAGE int not null)
3181
###< drop table crash_me10
3184
###As far as all queries returned OK, result is NO
3185
reserved_word_ansi-92/99_last=no # Keyword LAST
3186
###< create table crash_me10 (LAST int not null)
3188
###< drop table crash_me10
3191
###As far as all queries returned OK, result is NO
3192
reserved_word_ansi-92/99_leading=yes # Keyword LEADING
3193
###< create table crash_me10 (LEADING int not null)
3194
###> execute error:You 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
3195
###< drop table crash_me10
3196
###> execute error:Unknown table 'crash_me10'
3198
###As far as some queries didnt return OK, result is YES
3199
reserved_word_ansi-92/99_leave=no # Keyword LEAVE
3200
###< create table crash_me10 (LEAVE int not null)
3202
###< drop table crash_me10
3205
###As far as all queries returned OK, result is NO
3206
reserved_word_ansi-92/99_left=yes # Keyword LEFT
3207
###< create table crash_me10 (LEFT int not null)
3208
###> execute error:You 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
3209
###< drop table crash_me10
3210
###> execute error:Unknown table 'crash_me10'
3212
###As far as some queries didnt return OK, result is YES
3213
reserved_word_ansi-92/99_less=no # Keyword LESS
3214
###< create table crash_me10 (LESS int not null)
3216
###< drop table crash_me10
3219
###As far as all queries returned OK, result is NO
3220
reserved_word_ansi-92/99_level=no # Keyword LEVEL
3221
###< create table crash_me10 (LEVEL int not null)
3223
###< drop table crash_me10
3226
###As far as all queries returned OK, result is NO
3227
reserved_word_ansi-92/99_like=yes # Keyword LIKE
3228
###< create table crash_me10 (LIKE int not null)
3229
###> execute error:You 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
3230
###< drop table crash_me10
3231
###> execute error:Unknown table 'crash_me10'
3233
###As far as some queries didnt return OK, result is YES
3234
reserved_word_ansi-92/99_limit=yes # Keyword LIMIT
3235
###< create table crash_me10 (LIMIT int not null)
3236
###> execute error:You 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
3237
###< drop table crash_me10
3238
###> execute error:Unknown table 'crash_me10'
3240
###As far as some queries didnt return OK, result is YES
3241
reserved_word_ansi-92/99_local=no # Keyword LOCAL
3242
###< create table crash_me10 (LOCAL int not null)
3244
###< drop table crash_me10
3247
###As far as all queries returned OK, result is NO
3248
reserved_word_ansi-92/99_loop=no # Keyword LOOP
3249
###< create table crash_me10 (LOOP int not null)
3251
###< drop table crash_me10
3254
###As far as all queries returned OK, result is NO
3255
reserved_word_ansi-92/99_match=yes # Keyword MATCH
3256
###< create table crash_me10 (MATCH int not null)
3257
###> execute error:You 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
3258
###< drop table crash_me10
3259
###> execute error:Unknown table 'crash_me10'
3261
###As far as some queries didnt return OK, result is YES
3262
reserved_word_ansi-92/99_minute=no # Keyword MINUTE
3263
###< create table crash_me10 (MINUTE int not null)
3265
###< drop table crash_me10
3268
###As far as all queries returned OK, result is NO
3269
reserved_word_ansi-92/99_modify=no # Keyword MODIFY
3270
###< create table crash_me10 (MODIFY int not null)
3272
###< drop table crash_me10
3275
###As far as all queries returned OK, result is NO
3276
reserved_word_ansi-92/99_module=no # Keyword MODULE
3277
###< create table crash_me10 (MODULE int not null)
3279
###< drop table crash_me10
3282
###As far as all queries returned OK, result is NO
3283
reserved_word_ansi-92/99_month=no # Keyword MONTH
3284
###< create table crash_me10 (MONTH int not null)
3286
###< drop table crash_me10
3289
###As far as all queries returned OK, result is NO
3290
reserved_word_ansi-92/99_names=no # Keyword NAMES
3291
###< create table crash_me10 (NAMES int not null)
3293
###< drop table crash_me10
3296
###As far as all queries returned OK, result is NO
3297
reserved_word_ansi-92/99_national=no # Keyword NATIONAL
3298
###< create table crash_me10 (NATIONAL int not null)
3300
###< drop table crash_me10
3303
###As far as all queries returned OK, result is NO
3304
reserved_word_ansi-92/99_natural=yes # Keyword NATURAL
3305
###< create table crash_me10 (NATURAL int not null)
3306
###> execute error:You 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
3307
###< drop table crash_me10
3308
###> execute error:Unknown table 'crash_me10'
3310
###As far as some queries didnt return OK, result is YES
3311
reserved_word_ansi-92/99_nchar=no # Keyword NCHAR
3312
###< create table crash_me10 (NCHAR int not null)
3314
###< drop table crash_me10
3317
###As far as all queries returned OK, result is NO
3318
reserved_word_ansi-92/99_new=no # Keyword NEW
3319
###< create table crash_me10 (NEW int not null)
3321
###< drop table crash_me10
3324
###As far as all queries returned OK, result is NO
3325
reserved_word_ansi-92/99_next=no # Keyword NEXT
3326
###< create table crash_me10 (NEXT int not null)
3328
###< drop table crash_me10
3331
###As far as all queries returned OK, result is NO
3332
reserved_word_ansi-92/99_no=no # Keyword NO
3333
###< create table crash_me10 (NO int not null)
3335
###< drop table crash_me10
3338
###As far as all queries returned OK, result is NO
3339
reserved_word_ansi-92/99_none=no # Keyword NONE
3340
###< create table crash_me10 (NONE int not null)
3342
###< drop table crash_me10
3345
###As far as all queries returned OK, result is NO
3346
reserved_word_ansi-92/99_not=yes # Keyword NOT
3347
###< create table crash_me10 (NOT int not null)
3348
###> execute error:You 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
3349
###< drop table crash_me10
3350
###> execute error:Unknown table 'crash_me10'
3352
###As far as some queries didnt return OK, result is YES
3353
reserved_word_ansi-92/99_null=yes # Keyword NULL
3354
###< create table crash_me10 (NULL int not null)
3355
###> execute error:You 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
3356
###< drop table crash_me10
3357
###> execute error:Unknown table 'crash_me10'
3359
###As far as some queries didnt return OK, result is YES
3360
reserved_word_ansi-92/99_numeric=yes # Keyword NUMERIC
3361
###< create table crash_me10 (NUMERIC int not null)
3362
###> execute error:You 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
3363
###< drop table crash_me10
3364
###> execute error:Unknown table 'crash_me10'
3366
###As far as some queries didnt return OK, result is YES
3367
reserved_word_ansi-92/99_object=no # Keyword OBJECT
3368
###< create table crash_me10 (OBJECT int not null)
3370
###< drop table crash_me10
3373
###As far as all queries returned OK, result is NO
3374
reserved_word_ansi-92/99_of=no # Keyword OF
3375
###< create table crash_me10 (OF int not null)
3377
###< drop table crash_me10
3380
###As far as all queries returned OK, result is NO
3381
reserved_word_ansi-92/99_off=no # Keyword OFF
3382
###< create table crash_me10 (OFF int not null)
3384
###< drop table crash_me10
3387
###As far as all queries returned OK, result is NO
3388
reserved_word_ansi-92/99_old=no # Keyword OLD
3389
###< create table crash_me10 (OLD int not null)
3391
###< drop table crash_me10
3394
###As far as all queries returned OK, result is NO
3395
reserved_word_ansi-92/99_on=yes # Keyword ON
3396
###< create table crash_me10 (ON int not null)
3397
###> execute error:You 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
3398
###< drop table crash_me10
3399
###> execute error:Unknown table 'crash_me10'
3401
###As far as some queries didnt return OK, result is YES
3402
reserved_word_ansi-92/99_only=no # Keyword ONLY
3403
###< create table crash_me10 (ONLY int not null)
3405
###< drop table crash_me10
3408
###As far as all queries returned OK, result is NO
3409
reserved_word_ansi-92/99_open=no # Keyword OPEN
3410
###< create table crash_me10 (OPEN int not null)
3412
###< drop table crash_me10
3415
###As far as all queries returned OK, result is NO
3416
reserved_word_ansi-92/99_operation=no # Keyword OPERATION
3417
###< create table crash_me10 (OPERATION int not null)
3419
###< drop table crash_me10
3422
###As far as all queries returned OK, result is NO
3423
reserved_word_ansi-92/99_option=yes # Keyword OPTION
3424
###< create table crash_me10 (OPTION int not null)
3425
###> execute error:You 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
3426
###< drop table crash_me10
3427
###> execute error:Unknown table 'crash_me10'
3429
###As far as some queries didnt return OK, result is YES
3430
reserved_word_ansi-92/99_or=yes # Keyword OR
3431
###< create table crash_me10 (OR int not null)
3432
###> execute error:You 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
3433
###< drop table crash_me10
3434
###> execute error:Unknown table 'crash_me10'
3436
###As far as some queries didnt return OK, result is YES
3437
reserved_word_ansi-92/99_order=yes # Keyword ORDER
3438
###< create table crash_me10 (ORDER int not null)
3439
###> execute error:You 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
3440
###< drop table crash_me10
3441
###> execute error:Unknown table 'crash_me10'
3443
###As far as some queries didnt return OK, result is YES
3444
reserved_word_ansi-92/99_outer=yes # Keyword OUTER
3445
###< create table crash_me10 (OUTER int not null)
3446
###> execute error:You 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
3447
###< drop table crash_me10
3448
###> execute error:Unknown table 'crash_me10'
3450
###As far as some queries didnt return OK, result is YES
3451
reserved_word_ansi-92/99_output=no # Keyword OUTPUT
3452
###< create table crash_me10 (OUTPUT int not null)
3454
###< drop table crash_me10
3457
###As far as all queries returned OK, result is NO
3458
reserved_word_ansi-92/99_pad=no # Keyword PAD
3459
###< create table crash_me10 (PAD int not null)
3461
###< drop table crash_me10
3464
###As far as all queries returned OK, result is NO
3465
reserved_word_ansi-92/99_parameters=no # Keyword PARAMETERS
3466
###< create table crash_me10 (PARAMETERS int not null)
3468
###< drop table crash_me10
3471
###As far as all queries returned OK, result is NO
3472
reserved_word_ansi-92/99_partial=no # Keyword PARTIAL
3473
###< create table crash_me10 (PARTIAL int not null)
3475
###< drop table crash_me10
3478
###As far as all queries returned OK, result is NO
3479
reserved_word_ansi-92/99_precision=yes # Keyword PRECISION
3480
###< create table crash_me10 (PRECISION int not null)
3481
###> execute error:You 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
3482
###< drop table crash_me10
3483
###> execute error:Unknown table 'crash_me10'
3485
###As far as some queries didnt return OK, result is YES
3486
reserved_word_ansi-92/99_preorder=no # Keyword PREORDER
3487
###< create table crash_me10 (PREORDER int not null)
3489
###< drop table crash_me10
3492
###As far as all queries returned OK, result is NO
3493
reserved_word_ansi-92/99_prepare=no # Keyword PREPARE
3494
###< create table crash_me10 (PREPARE int not null)
3496
###< drop table crash_me10
3499
###As far as all queries returned OK, result is NO
3500
reserved_word_ansi-92/99_preserve=no # Keyword PRESERVE
3501
###< create table crash_me10 (PRESERVE int not null)
3503
###< drop table crash_me10
3506
###As far as all queries returned OK, result is NO
3507
reserved_word_ansi-92/99_primary=yes # Keyword PRIMARY
3508
###< create table crash_me10 (PRIMARY int not null)
3509
###> execute error:You 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
3510
###< drop table crash_me10
3511
###> execute error:Unknown table 'crash_me10'
3513
###As far as some queries didnt return OK, result is YES
3514
reserved_word_ansi-92/99_prior=no # Keyword PRIOR
3515
###< create table crash_me10 (PRIOR int not null)
3517
###< drop table crash_me10
3520
###As far as all queries returned OK, result is NO
3521
reserved_word_ansi-92/99_privileges=yes # Keyword PRIVILEGES
3522
###< create table crash_me10 (PRIVILEGES int not null)
3523
###> execute error:You 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
3524
###< drop table crash_me10
3525
###> execute error:Unknown table 'crash_me10'
3527
###As far as some queries didnt return OK, result is YES
3528
reserved_word_ansi-92/99_procedure=yes # Keyword PROCEDURE
3529
###< create table crash_me10 (PROCEDURE int not null)
3530
###> execute error:You 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
3531
###< drop table crash_me10
3532
###> execute error:Unknown table 'crash_me10'
3534
###As far as some queries didnt return OK, result is YES
3535
reserved_word_ansi-92/99_public=no # Keyword PUBLIC
3536
###< create table crash_me10 (PUBLIC int not null)
3538
###< drop table crash_me10
3541
###As far as all queries returned OK, result is NO
3542
reserved_word_ansi-92/99_read=yes # Keyword READ
3543
###< create table crash_me10 (READ int not null)
3544
###> execute error:You 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
3545
###< drop table crash_me10
3546
###> execute error:Unknown table 'crash_me10'
3548
###As far as some queries didnt return OK, result is YES
3549
reserved_word_ansi-92/99_real=yes # Keyword REAL
3550
###< create table crash_me10 (REAL int not null)
3551
###> execute error:You 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
3552
###< drop table crash_me10
3553
###> execute error:Unknown table 'crash_me10'
3555
###As far as some queries didnt return OK, result is YES
3556
reserved_word_ansi-92/99_recursive=no # Keyword RECURSIVE
3557
###< create table crash_me10 (RECURSIVE int not null)
3559
###< drop table crash_me10
3562
###As far as all queries returned OK, result is NO
3563
reserved_word_ansi-92/99_ref=no # Keyword REF
3564
###< create table crash_me10 (REF int not null)
3566
###< drop table crash_me10
3569
###As far as all queries returned OK, result is NO
3570
reserved_word_ansi-92/99_references=yes # Keyword REFERENCES
3571
###< create table crash_me10 (REFERENCES int not null)
3572
###> execute error:You 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
3573
###< drop table crash_me10
3574
###> execute error:Unknown table 'crash_me10'
3576
###As far as some queries didnt return OK, result is YES
3577
reserved_word_ansi-92/99_referencing=no # Keyword REFERENCING
3578
###< create table crash_me10 (REFERENCING int not null)
3580
###< drop table crash_me10
3583
###As far as all queries returned OK, result is NO
3584
reserved_word_ansi-92/99_relative=no # Keyword RELATIVE
3585
###< create table crash_me10 (RELATIVE int not null)
3587
###< drop table crash_me10
3590
###As far as all queries returned OK, result is NO
3591
reserved_word_ansi-92/99_resignal=no # Keyword RESIGNAL
3592
###< create table crash_me10 (RESIGNAL int not null)
3594
###< drop table crash_me10
3597
###As far as all queries returned OK, result is NO
3598
reserved_word_ansi-92/99_restrict=yes # Keyword RESTRICT
3599
###< create table crash_me10 (RESTRICT int not null)
3600
###> execute error:You 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
3601
###< drop table crash_me10
3602
###> execute error:Unknown table 'crash_me10'
3604
###As far as some queries didnt return OK, result is YES
3605
reserved_word_ansi-92/99_return=no # Keyword RETURN
3606
###< create table crash_me10 (RETURN int not null)
3608
###< drop table crash_me10
3611
###As far as all queries returned OK, result is NO
3612
reserved_word_ansi-92/99_returns=yes # Keyword RETURNS
3613
###< create table crash_me10 (RETURNS int not null)
3614
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'RETURNS int not null)' at line 1
3615
###< drop table crash_me10
3616
###> execute error:Unknown table 'crash_me10'
3618
###As far as some queries didnt return OK, result is YES
3619
reserved_word_ansi-92/99_revoke=yes # Keyword REVOKE
3620
###< create table crash_me10 (REVOKE int not null)
3621
###> execute error:You 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
3622
###< drop table crash_me10
3623
###> execute error:Unknown table 'crash_me10'
3625
###As far as some queries didnt return OK, result is YES
3626
reserved_word_ansi-92/99_right=yes # Keyword RIGHT
3627
###< create table crash_me10 (RIGHT int not null)
3628
###> execute error:You 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
3629
###< drop table crash_me10
3630
###> execute error:Unknown table 'crash_me10'
3632
###As far as some queries didnt return OK, result is YES
3633
reserved_word_ansi-92/99_role=no # Keyword ROLE
3634
###< create table crash_me10 (ROLE int not null)
3636
###< drop table crash_me10
3639
###As far as all queries returned OK, result is NO
3640
reserved_word_ansi-92/99_rollback=no # Keyword ROLLBACK
3641
###< create table crash_me10 (ROLLBACK int not null)
3643
###< drop table crash_me10
3646
###As far as all queries returned OK, result is NO
3647
reserved_word_ansi-92/99_routine=no # Keyword ROUTINE
3648
###< create table crash_me10 (ROUTINE int not null)
3650
###< drop table crash_me10
3653
###As far as all queries returned OK, result is NO
3654
reserved_word_ansi-92/99_row=no # Keyword ROW
3655
###< create table crash_me10 (ROW int not null)
3657
###< drop table crash_me10
3660
###As far as all queries returned OK, result is NO
3661
reserved_word_ansi-92/99_rows=no # Keyword ROWS
3662
###< create table crash_me10 (ROWS int not null)
3664
###< drop table crash_me10
3667
###As far as all queries returned OK, result is NO
3668
reserved_word_ansi-92/99_savepoint=no # Keyword SAVEPOINT
3669
###< create table crash_me10 (SAVEPOINT int not null)
3671
###< drop table crash_me10
3674
###As far as all queries returned OK, result is NO
3675
reserved_word_ansi-92/99_schema=no # Keyword SCHEMA
3676
###< create table crash_me10 (SCHEMA int not null)
3678
###< drop table crash_me10
3681
###As far as all queries returned OK, result is NO
3682
reserved_word_ansi-92/99_scroll=no # Keyword SCROLL
3683
###< create table crash_me10 (SCROLL int not null)
3685
###< drop table crash_me10
3688
###As far as all queries returned OK, result is NO
3689
reserved_word_ansi-92/99_search=no # Keyword SEARCH
3690
###< create table crash_me10 (SEARCH int not null)
3692
###< drop table crash_me10
3695
###As far as all queries returned OK, result is NO
3696
reserved_word_ansi-92/99_second=no # Keyword SECOND
3697
###< create table crash_me10 (SECOND int not null)
3699
###< drop table crash_me10
3702
###As far as all queries returned OK, result is NO
3703
reserved_word_ansi-92/99_section=no # Keyword SECTION
3704
###< create table crash_me10 (SECTION int not null)
3706
###< drop table crash_me10
3709
###As far as all queries returned OK, result is NO
3710
reserved_word_ansi-92/99_select=yes # Keyword SELECT
3711
###< create table crash_me10 (SELECT int not null)
3712
###> execute error:You 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
3713
###< drop table crash_me10
3714
###> execute error:Unknown table 'crash_me10'
3716
###As far as some queries didnt return OK, result is YES
3717
reserved_word_ansi-92/99_sequence=no # Keyword SEQUENCE
3718
###< create table crash_me10 (SEQUENCE int not null)
3720
###< drop table crash_me10
3723
###As far as all queries returned OK, result is NO
3724
reserved_word_ansi-92/99_session=no # Keyword SESSION
3725
###< create table crash_me10 (SESSION int not null)
3727
###< drop table crash_me10
3730
###As far as all queries returned OK, result is NO
3731
reserved_word_ansi-92/99_session_user=no # Keyword SESSION_USER
3732
###< create table crash_me10 (SESSION_USER int not null)
3734
###< drop table crash_me10
3737
###As far as all queries returned OK, result is NO
3738
reserved_word_ansi-92/99_set=yes # Keyword SET
3739
###< create table crash_me10 (SET int not null)
3740
###> execute error:You 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
3741
###< drop table crash_me10
3742
###> execute error:Unknown table 'crash_me10'
3744
###As far as some queries didnt return OK, result is YES
3745
reserved_word_ansi-92/99_signal=no # Keyword SIGNAL
3746
###< create table crash_me10 (SIGNAL int not null)
3748
###< drop table crash_me10
3751
###As far as all queries returned OK, result is NO
3752
reserved_word_ansi-92/99_size=no # Keyword SIZE
3753
###< create table crash_me10 (SIZE int not null)
3755
###< drop table crash_me10
3758
###As far as all queries returned OK, result is NO
3759
reserved_word_ansi-92/99_smallint=yes # Keyword SMALLINT
3760
###< create table crash_me10 (SMALLINT int not null)
3761
###> execute error:You 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
3762
###< drop table crash_me10
3763
###> execute error:Unknown table 'crash_me10'
3765
###As far as some queries didnt return OK, result is YES
3766
reserved_word_ansi-92/99_some=no # Keyword SOME
3767
###< create table crash_me10 (SOME int not null)
3769
###< drop table crash_me10
3772
###As far as all queries returned OK, result is NO
3773
reserved_word_ansi-92/99_space=no # Keyword SPACE
3774
###< create table crash_me10 (SPACE int not null)
3776
###< drop table crash_me10
3779
###As far as all queries returned OK, result is NO
3780
reserved_word_ansi-92/99_sql=no # Keyword SQL
3781
###< create table crash_me10 (SQL int not null)
3783
###< drop table crash_me10
3786
###As far as all queries returned OK, result is NO
3787
reserved_word_ansi-92/99_sqlexception=no # Keyword SQLEXCEPTION
3788
###< create table crash_me10 (SQLEXCEPTION int not null)
3790
###< drop table crash_me10
3793
###As far as all queries returned OK, result is NO
3794
reserved_word_ansi-92/99_sqlstate=no # Keyword SQLSTATE
3795
###< create table crash_me10 (SQLSTATE int not null)
3797
###< drop table crash_me10
3800
###As far as all queries returned OK, result is NO
3801
reserved_word_ansi-92/99_sqlwarning=no # Keyword SQLWARNING
3802
###< create table crash_me10 (SQLWARNING int not null)
3804
###< drop table crash_me10
3807
###As far as all queries returned OK, result is NO
3808
reserved_word_ansi-92/99_structure=no # Keyword STRUCTURE
3809
###< create table crash_me10 (STRUCTURE int not null)
3811
###< drop table crash_me10
3814
###As far as all queries returned OK, result is NO
3815
reserved_word_ansi-92/99_system_user=no # Keyword SYSTEM_USER
3816
###< create table crash_me10 (SYSTEM_USER int not null)
3818
###< drop table crash_me10
3821
###As far as all queries returned OK, result is NO
3822
reserved_word_ansi-92/99_table=yes # Keyword TABLE
3823
###< create table crash_me10 (TABLE int not null)
3824
###> execute error:You 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
3825
###< drop table crash_me10
3826
###> execute error:Unknown table 'crash_me10'
3828
###As far as some queries didnt return OK, result is YES
3829
reserved_word_ansi-92/99_temporary=no # Keyword TEMPORARY
3830
###< create table crash_me10 (TEMPORARY int not null)
3832
###< drop table crash_me10
3835
###As far as all queries returned OK, result is NO
3836
reserved_word_ansi-92/99_then=yes # Keyword THEN
3837
###< create table crash_me10 (THEN int not null)
3838
###> execute error:You 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
3839
###< drop table crash_me10
3840
###> execute error:Unknown table 'crash_me10'
3842
###As far as some queries didnt return OK, result is YES
3843
reserved_word_ansi-92/99_time=no # Keyword TIME
3844
###< create table crash_me10 (TIME int not null)
3846
###< drop table crash_me10
3849
###As far as all queries returned OK, result is NO
3850
reserved_word_ansi-92/99_timestamp=no # Keyword TIMESTAMP
3851
###< create table crash_me10 (TIMESTAMP int not null)
3853
###< drop table crash_me10
3856
###As far as all queries returned OK, result is NO
3857
reserved_word_ansi-92/99_timezone_hour=no # Keyword TIMEZONE_HOUR
3858
###< create table crash_me10 (TIMEZONE_HOUR int not null)
3860
###< drop table crash_me10
3863
###As far as all queries returned OK, result is NO
3864
reserved_word_ansi-92/99_timezone_minute=no # Keyword TIMEZONE_MINUTE
3865
###< create table crash_me10 (TIMEZONE_MINUTE int not null)
3867
###< drop table crash_me10
3870
###As far as all queries returned OK, result is NO
3871
reserved_word_ansi-92/99_to=yes # Keyword TO
3872
###< create table crash_me10 (TO int not null)
3873
###> execute error:You 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
3874
###< drop table crash_me10
3875
###> execute error:Unknown table 'crash_me10'
3877
###As far as some queries didnt return OK, result is YES
3878
reserved_word_ansi-92/99_trailing=yes # Keyword TRAILING
3879
###< create table crash_me10 (TRAILING int not null)
3880
###> execute error:You 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
3881
###< drop table crash_me10
3882
###> execute error:Unknown table 'crash_me10'
3884
###As far as some queries didnt return OK, result is YES
3885
reserved_word_ansi-92/99_transaction=no # Keyword TRANSACTION
3886
###< create table crash_me10 (TRANSACTION int not null)
3888
###< drop table crash_me10
3891
###As far as all queries returned OK, result is NO
3892
reserved_word_ansi-92/99_translation=no # Keyword TRANSLATION
3893
###< create table crash_me10 (TRANSLATION int not null)
3895
###< drop table crash_me10
3898
###As far as all queries returned OK, result is NO
3899
reserved_word_ansi-92/99_trigger=no # Keyword TRIGGER
3900
###< create table crash_me10 (TRIGGER int not null)
3902
###< drop table crash_me10
3905
###As far as all queries returned OK, result is NO
3906
reserved_word_ansi-92/99_true=yes # Keyword TRUE
3907
###< create table crash_me10 (TRUE int not null)
3908
###> execute error:You 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
3909
###< drop table crash_me10
3910
###> execute error:Unknown table 'crash_me10'
3912
###As far as some queries didnt return OK, result is YES
3913
reserved_word_ansi-92/99_under=no # Keyword UNDER
3914
###< create table crash_me10 (UNDER int not null)
3916
###< drop table crash_me10
3919
###As far as all queries returned OK, result is NO
3920
reserved_word_ansi-92/99_union=yes # Keyword UNION
3921
###< create table crash_me10 (UNION int not null)
3922
###> execute error:You 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
3923
###< drop table crash_me10
3924
###> execute error:Unknown table 'crash_me10'
3926
###As far as some queries didnt return OK, result is YES
3927
reserved_word_ansi-92/99_unique=yes # Keyword UNIQUE
3928
###< create table crash_me10 (UNIQUE int not null)
3929
###> execute error:You 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
3930
###< drop table crash_me10
3931
###> execute error:Unknown table 'crash_me10'
3933
###As far as some queries didnt return OK, result is YES
3934
reserved_word_ansi-92/99_unknown=no # Keyword UNKNOWN
3935
###< create table crash_me10 (UNKNOWN int not null)
3937
###< drop table crash_me10
3940
###As far as all queries returned OK, result is NO
3941
reserved_word_ansi-92/99_update=yes # Keyword UPDATE
3942
###< create table crash_me10 (UPDATE int not null)
3943
###> execute error:You 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
3944
###< drop table crash_me10
3945
###> execute error:Unknown table 'crash_me10'
3947
###As far as some queries didnt return OK, result is YES
3948
reserved_word_ansi-92/99_usage=yes # Keyword USAGE
3949
###< create table crash_me10 (USAGE int not null)
3950
###> execute error:You 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
3951
###< drop table crash_me10
3952
###> execute error:Unknown table 'crash_me10'
3954
###As far as some queries didnt return OK, result is YES
3955
reserved_word_ansi-92/99_user=no # Keyword USER
3956
###< create table crash_me10 (USER int not null)
3958
###< drop table crash_me10
3961
###As far as all queries returned OK, result is NO
3962
reserved_word_ansi-92/99_using=yes # Keyword USING
3963
###< create table crash_me10 (USING int not null)
3964
###> execute error:You 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
3965
###< drop table crash_me10
3966
###> execute error:Unknown table 'crash_me10'
3968
###As far as some queries didnt return OK, result is YES
3969
reserved_word_ansi-92/99_value=no # Keyword VALUE
3970
###< create table crash_me10 (VALUE int not null)
3972
###< drop table crash_me10
3975
###As far as all queries returned OK, result is NO
3976
reserved_word_ansi-92/99_values=yes # Keyword VALUES
3977
###< create table crash_me10 (VALUES int not null)
3978
###> execute error:You 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
3979
###< drop table crash_me10
3980
###> execute error:Unknown table 'crash_me10'
3982
###As far as some queries didnt return OK, result is YES
3983
reserved_word_ansi-92/99_varchar=yes # Keyword VARCHAR
3984
###< create table crash_me10 (VARCHAR int not null)
3985
###> execute error:You 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
3986
###< drop table crash_me10
3987
###> execute error:Unknown table 'crash_me10'
3989
###As far as some queries didnt return OK, result is YES
3990
reserved_word_ansi-92/99_variable=no # Keyword VARIABLE
3991
###< create table crash_me10 (VARIABLE int not null)
3993
###< drop table crash_me10
3996
###As far as all queries returned OK, result is NO
3997
reserved_word_ansi-92/99_varying=yes # Keyword VARYING
3998
###< create table crash_me10 (VARYING int not null)
3999
###> execute error:You 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
4000
###< drop table crash_me10
4001
###> execute error:Unknown table 'crash_me10'
4003
###As far as some queries didnt return OK, result is YES
4004
reserved_word_ansi-92/99_view=no # Keyword VIEW
4005
###< create table crash_me10 (VIEW int not null)
4007
###< drop table crash_me10
4010
###As far as all queries returned OK, result is NO
4011
reserved_word_ansi-92/99_when=yes # Keyword WHEN
4012
###< create table crash_me10 (WHEN int not null)
4013
###> execute error:You 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
4014
###< drop table crash_me10
4015
###> execute error:Unknown table 'crash_me10'
4017
###As far as some queries didnt return OK, result is YES
4018
reserved_word_ansi-92/99_whenever=no # Keyword WHENEVER
4019
###< create table crash_me10 (WHENEVER int not null)
4021
###< drop table crash_me10
4024
###As far as all queries returned OK, result is NO
4025
reserved_word_ansi-92/99_where=yes # Keyword WHERE
4026
###< create table crash_me10 (WHERE int not null)
4027
###> execute error:You 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
4028
###< drop table crash_me10
4029
###> execute error:Unknown table 'crash_me10'
4031
###As far as some queries didnt return OK, result is YES
4032
reserved_word_ansi-92/99_while=no # Keyword WHILE
4033
###< create table crash_me10 (WHILE int not null)
4035
###< drop table crash_me10
4038
###As far as all queries returned OK, result is NO
4039
reserved_word_ansi-92/99_with=yes # Keyword WITH
4040
###< create table crash_me10 (WITH int not null)
4041
###> execute error:You 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
4042
###< drop table crash_me10
4043
###> execute error:Unknown table 'crash_me10'
4045
###As far as some queries didnt return OK, result is YES
4046
reserved_word_ansi-92/99_without=no # Keyword WITHOUT
4047
###< create table crash_me10 (WITHOUT int not null)
4049
###< drop table crash_me10
4052
###As far as all queries returned OK, result is NO
4053
reserved_word_ansi-92/99_work=no # Keyword WORK
4054
###< create table crash_me10 (WORK int not null)
4056
###< drop table crash_me10
4059
###As far as all queries returned OK, result is NO
4060
reserved_word_ansi-92/99_write=yes # Keyword WRITE
4061
###< create table crash_me10 (WRITE int not null)
4062
###> execute error:You 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
4063
###< drop table crash_me10
4064
###> execute error:Unknown table 'crash_me10'
4066
###As far as some queries didnt return OK, result is YES
4067
reserved_word_ansi-92/99_year=no # Keyword YEAR
4068
###< create table crash_me10 (YEAR int not null)
4070
###< drop table crash_me10
4073
###As far as all queries returned OK, result is NO
4074
reserved_word_ansi-92/99_zone=no # Keyword ZONE
4075
###< create table crash_me10 (ZONE int not null)
4077
###< drop table crash_me10
4080
###As far as all queries returned OK, result is NO
4081
reserved_word_ansi92_async=no # Keyword ASYNC
4082
###< create table crash_me10 (ASYNC int not null)
4084
###< drop table crash_me10
4087
###As far as all queries returned OK, result is NO
4088
reserved_word_ansi92_avg=no # Keyword AVG
4089
###< create table crash_me10 (AVG int not null)
4091
###< drop table crash_me10
4094
###As far as all queries returned OK, result is NO
4095
reserved_word_ansi92_between=yes # Keyword BETWEEN
4096
###< create table crash_me10 (BETWEEN int not null)
4097
###> execute error:You 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
4098
###< drop table crash_me10
4099
###> execute error:Unknown table 'crash_me10'
4101
###As far as some queries didnt return OK, result is YES
4102
reserved_word_ansi92_bit_length=no # Keyword BIT_LENGTH
4103
###< create table crash_me10 (BIT_LENGTH int not null)
4105
###< drop table crash_me10
4108
###As far as all queries returned OK, result is NO
4109
reserved_word_ansi92_char_length=no # Keyword CHAR_LENGTH
4110
###< create table crash_me10 (CHAR_LENGTH int not null)
4112
###< drop table crash_me10
4115
###As far as all queries returned OK, result is NO
4116
reserved_word_ansi92_character_length=no # Keyword CHARACTER_LENGTH
4117
###< create table crash_me10 (CHARACTER_LENGTH int not null)
4119
###< drop table crash_me10
4122
###As far as all queries returned OK, result is NO
4123
reserved_word_ansi92_coalesce=no # Keyword COALESCE
4124
###< create table crash_me10 (COALESCE int not null)
4126
###< drop table crash_me10
4129
###As far as all queries returned OK, result is NO
4130
reserved_word_ansi92_convert=yes # Keyword CONVERT
4131
###< create table crash_me10 (CONVERT int not null)
4132
###> execute error:You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONVERT int not null)' at line 1
4133
###< drop table crash_me10
4134
###> execute error:Unknown table 'crash_me10'
4136
###As far as some queries didnt return OK, result is YES
4137
reserved_word_ansi92_count=no # Keyword COUNT
4138
###< create table crash_me10 (COUNT int not null)
4140
###< drop table crash_me10
4143
###As far as all queries returned OK, result is NO
4144
reserved_word_ansi92_exists=yes # Keyword EXISTS
4145
###< create table crash_me10 (EXISTS int not null)
4146
###> execute error:You 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
4147
###< drop table crash_me10
4148
###> execute error:Unknown table 'crash_me10'
4150
###As far as some queries didnt return OK, result is YES
4151
reserved_word_ansi92_extract=no # Keyword EXTRACT
4152
###< create table crash_me10 (EXTRACT int not null)
4154
###< drop table crash_me10
4157
###As far as all queries returned OK, result is NO
4158
reserved_word_ansi92_insensitive=no # Keyword INSENSITIVE
4159
###< create table crash_me10 (INSENSITIVE int not null)
4161
###< drop table crash_me10
4164
###As far as all queries returned OK, result is NO
4165
reserved_word_ansi92_lower=no # Keyword LOWER
4166
###< create table crash_me10 (LOWER int not null)
4168
###< drop table crash_me10
4171
###As far as all queries returned OK, result is NO
4172
reserved_word_ansi92_max=no # Keyword MAX
4173
###< create table crash_me10 (MAX int not null)
4175
###< drop table crash_me10
4178
###As far as all queries returned OK, result is NO
4179
reserved_word_ansi92_min=no # Keyword MIN
4180
###< create table crash_me10 (MIN int not null)
4182
###< drop table crash_me10
4185
###As far as all queries returned OK, result is NO
4186
reserved_word_ansi92_nullif=no # Keyword NULLIF
4187
###< create table crash_me10 (NULLIF int not null)
4189
###< drop table crash_me10
4192
###As far as all queries returned OK, result is NO
4193
reserved_word_ansi92_octet_length=no # Keyword OCTET_LENGTH
4194
###< create table crash_me10 (OCTET_LENGTH int not null)
4196
###< drop table crash_me10
4199
###As far as all queries returned OK, result is NO
4200
reserved_word_ansi92_oid=no # Keyword OID
4201
###< create table crash_me10 (OID int not null)
4203
###< drop table crash_me10
4206
###As far as all queries returned OK, result is NO
4207
reserved_word_ansi92_operators=no # Keyword OPERATORS
4208
###< create table crash_me10 (OPERATORS int not null)
4210
###< drop table crash_me10
4213
###As far as all queries returned OK, result is NO
4214
reserved_word_ansi92_others=no # Keyword OTHERS
4215
###< create table crash_me10 (OTHERS int not null)
4217
###< drop table crash_me10
4220
###As far as all queries returned OK, result is NO
4221
reserved_word_ansi92_overlaps=no # Keyword OVERLAPS
4222
###< create table crash_me10 (OVERLAPS int not null)
4224
###< drop table crash_me10
4227
###As far as all queries returned OK, result is NO
4228
reserved_word_ansi92_pendant=no # Keyword PENDANT
4229
###< create table crash_me10 (PENDANT int not null)
4231
###< drop table crash_me10
4234
###As far as all queries returned OK, result is NO
4235
reserved_word_ansi92_position=no # Keyword POSITION
4236
###< create table crash_me10 (POSITION int not null)
4238
###< drop table crash_me10
4241
###As far as all queries returned OK, result is NO
4242
reserved_word_ansi92_private=no # Keyword PRIVATE
4243
###< create table crash_me10 (PRIVATE int not null)
4245
###< drop table crash_me10
4248
###As far as all queries returned OK, result is NO
4249
reserved_word_ansi92_protected=no # Keyword PROTECTED
4250
###< create table crash_me10 (PROTECTED int not null)
4252
###< drop table crash_me10
4255
###As far as all queries returned OK, result is NO
4256
reserved_word_ansi92_replace=yes # Keyword REPLACE
4257
###< create table crash_me10 (REPLACE int not null)
4258
###> execute error:You 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
4259
###< drop table crash_me10
4260
###> execute error:Unknown table 'crash_me10'
4262
###As far as some queries didnt return OK, result is YES
4263
reserved_word_ansi92_sensitive=no # Keyword SENSITIVE
4264
###< create table crash_me10 (SENSITIVE int not null)
4266
###< drop table crash_me10
4269
###As far as all queries returned OK, result is NO
4270
reserved_word_ansi92_similar=no # Keyword SIMILAR
4271
###< create table crash_me10 (SIMILAR int not null)
4273
###< drop table crash_me10
4276
###As far as all queries returned OK, result is NO
4277
reserved_word_ansi92_sqlcode=no # Keyword SQLCODE
4278
###< create table crash_me10 (SQLCODE int not null)
4280
###< drop table crash_me10
4283
###As far as all queries returned OK, result is NO
4284
reserved_word_ansi92_sqlerror=no # Keyword SQLERROR
4285
###< create table crash_me10 (SQLERROR int not null)
4287
###< drop table crash_me10
4290
###As far as all queries returned OK, result is NO
4291
reserved_word_ansi92_substring=no # Keyword SUBSTRING
4292
###< create table crash_me10 (SUBSTRING int not null)
4294
###< drop table crash_me10
4297
###As far as all queries returned OK, result is NO
4298
reserved_word_ansi92_sum=no # Keyword SUM
4299
###< create table crash_me10 (SUM int not null)
4301
###< drop table crash_me10
4304
###As far as all queries returned OK, result is NO
4305
reserved_word_ansi92_test=no # Keyword TEST
4306
###< create table crash_me10 (TEST int not null)
4308
###< drop table crash_me10
4311
###As far as all queries returned OK, result is NO
4312
reserved_word_ansi92_there=no # Keyword THERE
4313
###< create table crash_me10 (THERE int not null)
4315
###< drop table crash_me10
4318
###As far as all queries returned OK, result is NO
4319
reserved_word_ansi92_translate=no # Keyword TRANSLATE
4320
###< create table crash_me10 (TRANSLATE int not null)
4322
###< drop table crash_me10
4325
###As far as all queries returned OK, result is NO
4326
reserved_word_ansi92_trim=no # Keyword TRIM
4327
###< create table crash_me10 (TRIM int not null)
4329
###< drop table crash_me10
4332
###As far as all queries returned OK, result is NO
4333
reserved_word_ansi92_type=no # Keyword TYPE
4334
###< create table crash_me10 (TYPE int not null)
4336
###< drop table crash_me10
4339
###As far as all queries returned OK, result is NO
4340
reserved_word_ansi92_upper=no # Keyword UPPER
4341
###< create table crash_me10 (UPPER int not null)
4343
###< drop table crash_me10
4346
###As far as all queries returned OK, result is NO
4347
reserved_word_ansi92_virtual=no # Keyword VIRTUAL
4348
###< create table crash_me10 (VIRTUAL int not null)
4350
###< drop table crash_me10
4353
###As far as all queries returned OK, result is NO
4354
reserved_word_ansi92_visible=no # Keyword VISIBLE
4355
###< create table crash_me10 (VISIBLE int not null)
4357
###< drop table crash_me10
4360
###As far as all queries returned OK, result is NO
4361
reserved_word_ansi92_wait=no # Keyword WAIT
4362
###< create table crash_me10 (WAIT int not null)
4364
###< drop table crash_me10
4367
###As far as all queries returned OK, result is NO
4368
reserved_word_ansi99_admin=no # Keyword ADMIN
4369
###< create table crash_me10 (ADMIN int not null)
4371
###< drop table crash_me10
4374
###As far as all queries returned OK, result is NO
4375
reserved_word_ansi99_aggregate=no # Keyword AGGREGATE
4376
###< create table crash_me10 (AGGREGATE int not null)
4378
###< drop table crash_me10
4381
###As far as all queries returned OK, result is NO
4382
reserved_word_ansi99_array=no # Keyword ARRAY
4383
###< create table crash_me10 (ARRAY int not null)
4385
###< drop table crash_me10
4388
###As far as all queries returned OK, result is NO
4389
reserved_word_ansi99_binary=yes # Keyword BINARY
4390
###< create table crash_me10 (BINARY int not null)
4391
###> execute error:You 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
4392
###< drop table crash_me10
4393
###> execute error:Unknown table 'crash_me10'
4395
###As far as some queries didnt return OK, result is YES
4396
reserved_word_ansi99_blob=yes # Keyword BLOB
4397
###< create table crash_me10 (BLOB int not null)
4398
###> execute error:You 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
4399
###< drop table crash_me10
4400
###> execute error:Unknown table 'crash_me10'
4402
###As far as some queries didnt return OK, result is YES
4403
reserved_word_ansi99_class=no # Keyword CLASS
4404
###< create table crash_me10 (CLASS int not null)
4406
###< drop table crash_me10
4409
###As far as all queries returned OK, result is NO
4410
reserved_word_ansi99_clob=no # Keyword CLOB
4411
###< create table crash_me10 (CLOB int not null)
4413
###< drop table crash_me10
4416
###As far as all queries returned OK, result is NO
4417
reserved_word_ansi99_condition=no # Keyword CONDITION
4418
###< create table crash_me10 (CONDITION int not null)
4420
###< drop table crash_me10
4423
###As far as all queries returned OK, result is NO
4424
reserved_word_ansi99_constructor=no # Keyword CONSTRUCTOR
4425
###< create table crash_me10 (CONSTRUCTOR int not null)
4427
###< drop table crash_me10
4430
###As far as all queries returned OK, result is NO
4431
reserved_word_ansi99_contains=no # Keyword CONTAINS
4432
###< create table crash_me10 (CONTAINS int not null)
4434
###< drop table crash_me10
4437
###As far as all queries returned OK, result is NO
4438
reserved_word_ansi99_cube=no # Keyword CUBE
4439
###< create table crash_me10 (CUBE int not null)
4441
###< drop table crash_me10
4444
###As far as all queries returned OK, result is NO
4445
reserved_word_ansi99_current_path=no # Keyword CURRENT_PATH
4446
###< create table crash_me10 (CURRENT_PATH int not null)
4448
###< drop table crash_me10
4451
###As far as all queries returned OK, result is NO
4452
reserved_word_ansi99_current_role=no # Keyword CURRENT_ROLE
4453
###< create table crash_me10 (CURRENT_ROLE int not null)
4455
###< drop table crash_me10
4458
###As far as all queries returned OK, result is NO
4459
reserved_word_ansi99_datalink=no # Keyword DATALINK
4460
###< create table crash_me10 (DATALINK int not null)
4462
###< drop table crash_me10
4465
###As far as all queries returned OK, result is NO
4466
reserved_word_ansi99_deref=no # Keyword DEREF
4467
###< create table crash_me10 (DEREF int not null)
4469
###< drop table crash_me10
4472
###As far as all queries returned OK, result is NO
4473
reserved_word_ansi99_destroy=no # Keyword DESTROY
4474
###< create table crash_me10 (DESTROY int not null)
4476
###< drop table crash_me10
4479
###As far as all queries returned OK, result is NO
4480
reserved_word_ansi99_destructor=no # Keyword DESTRUCTOR
4481
###< create table crash_me10 (DESTRUCTOR int not null)
4483
###< drop table crash_me10
4486
###As far as all queries returned OK, result is NO
4487
reserved_word_ansi99_deterministic=no # Keyword DETERMINISTIC
4488
###< create table crash_me10 (DETERMINISTIC int not null)
4490
###< drop table crash_me10
4493
###As far as all queries returned OK, result is NO
4494
reserved_word_ansi99_do=no # Keyword DO
4495
###< create table crash_me10 (DO int not null)
4497
###< drop table crash_me10
4500
###As far as all queries returned OK, result is NO
4501
reserved_word_ansi99_dynamic=no # Keyword DYNAMIC
4502
###< create table crash_me10 (DYNAMIC int not null)
4504
###< drop table crash_me10
4507
###As far as all queries returned OK, result is NO
4508
reserved_word_ansi99_every=no # Keyword EVERY
4509
###< create table crash_me10 (EVERY int not null)
4511
###< drop table crash_me10
4514
###As far as all queries returned OK, result is NO
4515
reserved_word_ansi99_exit=no # Keyword EXIT
4516
###< create table crash_me10 (EXIT int not null)
4518
###< drop table crash_me10
4521
###As far as all queries returned OK, result is NO
4522
reserved_word_ansi99_expand=no # Keyword EXPAND
4523
###< create table crash_me10 (EXPAND int not null)
4525
###< drop table crash_me10
4528
###As far as all queries returned OK, result is NO
4529
reserved_word_ansi99_expanding=no # Keyword EXPANDING
4530
###< create table crash_me10 (EXPANDING int not null)
4532
###< drop table crash_me10
4535
###As far as all queries returned OK, result is NO
4536
reserved_word_ansi99_free=no # Keyword FREE
4537
###< create table crash_me10 (FREE int not null)
4539
###< drop table crash_me10
4542
###As far as all queries returned OK, result is NO
4543
reserved_word_ansi99_function=no # Keyword FUNCTION
4544
###< create table crash_me10 (FUNCTION int not null)
4546
###< drop table crash_me10
4549
###As far as all queries returned OK, result is NO
4550
reserved_word_ansi99_grouping=no # Keyword GROUPING
4551
###< create table crash_me10 (GROUPING int not null)
4553
###< drop table crash_me10
4556
###As far as all queries returned OK, result is NO
4557
reserved_word_ansi99_handler=no # Keyword HANDLER
4558
###< create table crash_me10 (HANDLER int not null)
4560
###< drop table crash_me10
4563
###As far as all queries returned OK, result is NO
4564
reserved_word_ansi99_hast=no # Keyword HAST
4565
###< create table crash_me10 (HAST int not null)
4567
###< drop table crash_me10
4570
###As far as all queries returned OK, result is NO
4571
reserved_word_ansi99_host=no # Keyword HOST
4572
###< create table crash_me10 (HOST int not null)
4574
###< drop table crash_me10
4577
###As far as all queries returned OK, result is NO
4578
reserved_word_ansi99_initialize=no # Keyword INITIALIZE
4579
###< create table crash_me10 (INITIALIZE int not null)
4581
###< drop table crash_me10
4584
###As far as all queries returned OK, result is NO
4585
reserved_word_ansi99_inout=no # Keyword INOUT
4586
###< create table crash_me10 (INOUT int not null)
4588
###< drop table crash_me10
4591
###As far as all queries returned OK, result is NO
4592
reserved_word_ansi99_iterate=no # Keyword ITERATE
4593
###< create table crash_me10 (ITERATE int not null)
4595
###< drop table crash_me10
4598
###As far as all queries returned OK, result is NO
4599
reserved_word_ansi99_large=no # Keyword LARGE
4600
###< create table crash_me10 (LARGE int not null)
4602
###< drop table crash_me10
4605
###As far as all queries returned OK, result is NO
4606
reserved_word_ansi99_lateral=no # Keyword LATERAL
4607
###< create table crash_me10 (LATERAL int not null)
4609
###< drop table crash_me10
4612
###As far as all queries returned OK, result is NO
4613
reserved_word_ansi99_localtime=yes # Keyword LOCALTIME
4614
###< create table crash_me10 (LOCALTIME int not null)
4615
###> execute error:You 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
4616
###< drop table crash_me10
4617
###> execute error:Unknown table 'crash_me10'
4619
###As far as some queries didnt return OK, result is YES
4620
reserved_word_ansi99_localtimestamp=yes # Keyword LOCALTIMESTAMP
4621
###< create table crash_me10 (LOCALTIMESTAMP int not null)
4622
###> execute error:You 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
4623
###< drop table crash_me10
4624
###> execute error:Unknown table 'crash_me10'
4626
###As far as some queries didnt return OK, result is YES
4627
reserved_word_ansi99_locator=no # Keyword LOCATOR
4628
###< create table crash_me10 (LOCATOR int not null)
4630
###< drop table crash_me10
4633
###As far as all queries returned OK, result is NO
4634
reserved_word_ansi99_meets=no # Keyword MEETS
4635
###< create table crash_me10 (MEETS int not null)
4637
###< drop table crash_me10
4640
###As far as all queries returned OK, result is NO
4641
reserved_word_ansi99_modifies=no # Keyword MODIFIES
4642
###< create table crash_me10 (MODIFIES int not null)
4644
###< drop table crash_me10
4647
###As far as all queries returned OK, result is NO
4648
reserved_word_ansi99_nclob=no # Keyword NCLOB
4649
###< create table crash_me10 (NCLOB int not null)
4651
###< drop table crash_me10
4654
###As far as all queries returned OK, result is NO
4655
reserved_word_ansi99_normalize=no # Keyword NORMALIZE
4656
###< create table crash_me10 (NORMALIZE int not null)
4658
###< drop table crash_me10
4661
###As far as all queries returned OK, result is NO
4662
reserved_word_ansi99_ordinality=no # Keyword ORDINALITY
4663
###< create table crash_me10 (ORDINALITY int not null)
4665
###< drop table crash_me10
4668
###As far as all queries returned OK, result is NO
4669
reserved_word_ansi99_out=no # Keyword OUT
4670
###< create table crash_me10 (OUT int not null)
4672
###< drop table crash_me10
4675
###As far as all queries returned OK, result is NO
4676
reserved_word_ansi99_parameter=no # Keyword PARAMETER
4677
###< create table crash_me10 (PARAMETER int not null)
4679
###< drop table crash_me10
4682
###As far as all queries returned OK, result is NO
4683
reserved_word_ansi99_path=no # Keyword PATH
4684
###< create table crash_me10 (PATH int not null)
4686
###< drop table crash_me10
4689
###As far as all queries returned OK, result is NO
4690
reserved_word_ansi99_period=no # Keyword PERIOD
4691
###< create table crash_me10 (PERIOD int not null)
4693
###< drop table crash_me10
4696
###As far as all queries returned OK, result is NO
4697
reserved_word_ansi99_postfix=no # Keyword POSTFIX
4698
###< create table crash_me10 (POSTFIX int not null)
4700
###< drop table crash_me10
4703
###As far as all queries returned OK, result is NO
4704
reserved_word_ansi99_precedes=no # Keyword PRECEDES
4705
###< create table crash_me10 (PRECEDES int not null)
4707
###< drop table crash_me10
4710
###As far as all queries returned OK, result is NO
4711
reserved_word_ansi99_prefix=no # Keyword PREFIX
4712
###< create table crash_me10 (PREFIX int not null)
4714
###< drop table crash_me10
4717
###As far as all queries returned OK, result is NO
4718
reserved_word_ansi99_reads=no # Keyword READS
4719
###< create table crash_me10 (READS int not null)
4721
###< drop table crash_me10
4724
###As far as all queries returned OK, result is NO
4725
reserved_word_ansi99_redo=no # Keyword REDO
4726
###< create table crash_me10 (REDO int not null)
4728
###< drop table crash_me10
4731
###As far as all queries returned OK, result is NO
4732
reserved_word_ansi99_repeat=no # Keyword REPEAT
4733
###< create table crash_me10 (REPEAT int not null)
4735
###< drop table crash_me10
4738
###As far as all queries returned OK, result is NO
4739
reserved_word_ansi99_result=no # Keyword RESULT
4740
###< create table crash_me10 (RESULT int not null)
4742
###< drop table crash_me10
4745
###As far as all queries returned OK, result is NO
4746
reserved_word_ansi99_rollup=no # Keyword ROLLUP
4747
###< create table crash_me10 (ROLLUP int not null)
4749
###< drop table crash_me10
4752
###As far as all queries returned OK, result is NO
4753
reserved_word_ansi99_sets=no # Keyword SETS
4754
###< create table crash_me10 (SETS int not null)
4756
###< drop table crash_me10
4759
###As far as all queries returned OK, result is NO
4760
reserved_word_ansi99_specific=no # Keyword SPECIFIC
4761
###< create table crash_me10 (SPECIFIC int not null)
4763
###< drop table crash_me10
4766
###As far as all queries returned OK, result is NO
4767
reserved_word_ansi99_specifictype=no # Keyword SPECIFICTYPE
4768
###< create table crash_me10 (SPECIFICTYPE int not null)
4770
###< drop table crash_me10
4773
###As far as all queries returned OK, result is NO
4774
reserved_word_ansi99_start=no # Keyword START
4775
###< create table crash_me10 (START int not null)
4777
###< drop table crash_me10
4780
###As far as all queries returned OK, result is NO
4781
reserved_word_ansi99_state=no # Keyword STATE
4782
###< create table crash_me10 (STATE int not null)
4784
###< drop table crash_me10
4787
###As far as all queries returned OK, result is NO
4788
reserved_word_ansi99_static=no # Keyword STATIC
4789
###< create table crash_me10 (STATIC int not null)
4791
###< drop table crash_me10
4794
###As far as all queries returned OK, result is NO
4795
reserved_word_ansi99_succeeds=no # Keyword SUCCEEDS
4796
###< create table crash_me10 (SUCCEEDS int not null)
4798
###< drop table crash_me10
4801
###As far as all queries returned OK, result is NO
4802
reserved_word_ansi99_terminate=no # Keyword TERMINATE
4803
###< create table crash_me10 (TERMINATE int not null)
4805
###< drop table crash_me10
4808
###As far as all queries returned OK, result is NO
4809
reserved_word_ansi99_than=no # Keyword THAN
4810
###< create table crash_me10 (THAN int not null)
4812
###< drop table crash_me10
4815
###As far as all queries returned OK, result is NO
4816
reserved_word_ansi99_treat=no # Keyword TREAT
4817
###< create table crash_me10 (TREAT int not null)
4819
###< drop table crash_me10
4822
###As far as all queries returned OK, result is NO
4823
reserved_word_ansi99_undo=no # Keyword UNDO
4824
###< create table crash_me10 (UNDO int not null)
4826
###< drop table crash_me10
4829
###As far as all queries returned OK, result is NO
4830
reserved_word_ansi99_until=no # Keyword UNTIL
4831
###< create table crash_me10 (UNTIL int not null)
4833
###< drop table crash_me10
4836
###As far as all queries returned OK, result is NO
4837
reserved_word_extra_access=no # Keyword ACCESS
4838
###< create table crash_me10 (ACCESS int not null)
4840
###< drop table crash_me10
4843
###As far as all queries returned OK, result is NO
4844
reserved_word_extra_analyze=yes # Keyword ANALYZE
4845
###< create table crash_me10 (ANALYZE int not null)
4846
###> execute error:You 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
4847
###< drop table crash_me10
4848
###> execute error:Unknown table 'crash_me10'
4850
###As far as some queries didnt return OK, result is YES
4851
reserved_word_extra_audit=no # Keyword AUDIT
4852
###< create table crash_me10 (AUDIT int not null)
4854
###< drop table crash_me10
4857
###As far as all queries returned OK, result is NO
4858
reserved_word_extra_auto_increment=no # Keyword AUTO_INCREMENT
4859
###< create table crash_me10 (AUTO_INCREMENT int not null)
4861
###< drop table crash_me10
4864
###As far as all queries returned OK, result is NO
4865
reserved_word_extra_backup=no # Keyword BACKUP
4866
###< create table crash_me10 (BACKUP int not null)
4868
###< drop table crash_me10
4871
###As far as all queries returned OK, result is NO
4872
reserved_word_extra_bdb=no # Keyword BDB
4873
###< create table crash_me10 (BDB int not null)
4875
###< drop table crash_me10
4878
###As far as all queries returned OK, result is NO
4879
reserved_word_extra_berkeleydb=no # Keyword BERKELEYDB
4880
###< create table crash_me10 (BERKELEYDB int not null)
4882
###< drop table crash_me10
4885
###As far as all queries returned OK, result is NO
4886
reserved_word_extra_bigint=yes # Keyword BIGINT
4887
###< create table crash_me10 (BIGINT int not null)
4888
###> execute error:You 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
4889
###< drop table crash_me10
4890
###> execute error:Unknown table 'crash_me10'
4892
###As far as some queries didnt return OK, result is YES
4893
reserved_word_extra_break=no # Keyword BREAK
4894
###< create table crash_me10 (BREAK int not null)
4896
###< drop table crash_me10
4899
###As far as all queries returned OK, result is NO
4900
reserved_word_extra_browse=no # Keyword BROWSE
4901
###< create table crash_me10 (BROWSE int not null)
4903
###< drop table crash_me10
4906
###As far as all queries returned OK, result is NO
4907
reserved_word_extra_btree=no # Keyword BTREE
4908
###< create table crash_me10 (BTREE int not null)
4910
###< drop table crash_me10
4913
###As far as all queries returned OK, result is NO
4914
reserved_word_extra_bulk=no # Keyword BULK
4915
###< create table crash_me10 (BULK int not null)
4917
###< drop table crash_me10
4920
###As far as all queries returned OK, result is NO
4921
reserved_word_extra_change=yes # Keyword CHANGE
4922
###< create table crash_me10 (CHANGE int not null)
4923
###> execute error:You 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
4924
###< drop table crash_me10
4925
###> execute error:Unknown table 'crash_me10'
4927
###As far as some queries didnt return OK, result is YES
4928
reserved_word_extra_checkpoint=no # Keyword CHECKPOINT
4929
###< create table crash_me10 (CHECKPOINT int not null)
4931
###< drop table crash_me10
4934
###As far as all queries returned OK, result is NO
4935
reserved_word_extra_cluster=no # Keyword CLUSTER
4936
###< create table crash_me10 (CLUSTER int not null)
4938
###< drop table crash_me10
4941
###As far as all queries returned OK, result is NO
4942
reserved_word_extra_clustered=no # Keyword CLUSTERED
4943
###< create table crash_me10 (CLUSTERED int not null)
4945
###< drop table crash_me10
4948
###As far as all queries returned OK, result is NO
4949
reserved_word_extra_columns=yes # Keyword COLUMNS
4950
###< create table crash_me10 (COLUMNS int not null)
4951
###> execute error:You 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
4952
###< drop table crash_me10
4953
###> execute error:Unknown table 'crash_me10'
4955
###As far as some queries didnt return OK, result is YES
4956
reserved_word_extra_comment=no # Keyword COMMENT
4957
###< create table crash_me10 (COMMENT int not null)
4959
###< drop table crash_me10
4962
###As far as all queries returned OK, result is NO
4963
reserved_word_extra_compress=no # Keyword COMPRESS
4964
###< create table crash_me10 (COMPRESS int not null)
4966
###< drop table crash_me10
4969
###As far as all queries returned OK, result is NO
4970
reserved_word_extra_compute=no # Keyword COMPUTE
4971
###< create table crash_me10 (COMPUTE int not null)
4973
###< drop table crash_me10
4976
###As far as all queries returned OK, result is NO
4977
reserved_word_extra_containstable=no # Keyword CONTAINSTABLE
4978
###< create table crash_me10 (CONTAINSTABLE int not null)
4980
###< drop table crash_me10
4983
###As far as all queries returned OK, result is NO
4984
reserved_word_extra_database=yes # Keyword DATABASE
4985
###< create table crash_me10 (DATABASE int not null)
4986
###> execute error:You 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
4987
###< drop table crash_me10
4988
###> execute error:Unknown table 'crash_me10'
4990
###As far as some queries didnt return OK, result is YES
4991
reserved_word_extra_databases=yes # Keyword DATABASES
4992
###< create table crash_me10 (DATABASES int not null)
4993
###> execute error:You 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
4994
###< drop table crash_me10
4995
###> execute error:Unknown table 'crash_me10'
4997
###As far as some queries didnt return OK, result is YES
4998
reserved_word_extra_day_hour=yes # Keyword DAY_HOUR
4999
###< create table crash_me10 (DAY_HOUR int not null)
5000
###> execute error:You 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
5001
###< drop table crash_me10
5002
###> execute error:Unknown table 'crash_me10'
5004
###As far as some queries didnt return OK, result is YES
5005
reserved_word_extra_day_minute=yes # Keyword DAY_MINUTE
5006
###< create table crash_me10 (DAY_MINUTE int not null)
5007
###> execute error:You 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
5008
###< drop table crash_me10
5009
###> execute error:Unknown table 'crash_me10'
5011
###As far as some queries didnt return OK, result is YES
5012
reserved_word_extra_day_second=yes # Keyword DAY_SECOND
5013
###< create table crash_me10 (DAY_SECOND int not null)
5014
###> execute error:You 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
5015
###< drop table crash_me10
5016
###> execute error:Unknown table 'crash_me10'
5018
###As far as some queries didnt return OK, result is YES
5019
reserved_word_extra_dbcc=no # Keyword DBCC
5020
###< create table crash_me10 (DBCC int not null)
5022
###< drop table crash_me10
5025
###As far as all queries returned OK, result is NO
5026
reserved_word_extra_delayed=yes # Keyword DELAYED
5027
###< create table crash_me10 (DELAYED int not null)
5028
###> execute error:You 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
5029
###< drop table crash_me10
5030
###> execute error:Unknown table 'crash_me10'
5032
###As far as some queries didnt return OK, result is YES
5033
reserved_word_extra_deny=no # Keyword DENY
5034
###< create table crash_me10 (DENY int not null)
5036
###< drop table crash_me10
5039
###As far as all queries returned OK, result is NO
5040
reserved_word_extra_disk=no # Keyword DISK
5041
###< create table crash_me10 (DISK int not null)
5043
###< drop table crash_me10
5046
###As far as all queries returned OK, result is NO
5047
reserved_word_extra_distinctrow=yes # Keyword DISTINCTROW
5048
###< create table crash_me10 (DISTINCTROW int not null)
5049
###> execute error:You 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
5050
###< drop table crash_me10
5051
###> execute error:Unknown table 'crash_me10'
5053
###As far as some queries didnt return OK, result is YES
5054
reserved_word_extra_distributed=no # Keyword DISTRIBUTED
5055
###< create table crash_me10 (DISTRIBUTED int not null)
5057
###< drop table crash_me10
5060
###As far as all queries returned OK, result is NO
5061
reserved_word_extra_dummy=no # Keyword DUMMY
5062
###< create table crash_me10 (DUMMY int not null)
5064
###< drop table crash_me10
5067
###As far as all queries returned OK, result is NO
5068
reserved_word_extra_dump=no # Keyword DUMP
5069
###< create table crash_me10 (DUMP int not null)
5071
###< drop table crash_me10
5074
###As far as all queries returned OK, result is NO
5075
reserved_word_extra_enclosed=yes # Keyword ENCLOSED
5076
###< create table crash_me10 (ENCLOSED int not null)
5077
###> execute error:You 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
5078
###< drop table crash_me10
5079
###> execute error:Unknown table 'crash_me10'
5081
###As far as some queries didnt return OK, result is YES
5082
reserved_word_extra_errlvl=no # Keyword ERRLVL
5083
###< create table crash_me10 (ERRLVL int not null)
5085
###< drop table crash_me10
5088
###As far as all queries returned OK, result is NO
5089
reserved_word_extra_errors=no # Keyword ERRORS
5090
###< create table crash_me10 (ERRORS int not null)
5092
###< drop table crash_me10
5095
###As far as all queries returned OK, result is NO
5096
reserved_word_extra_escaped=yes # Keyword ESCAPED
5097
###< create table crash_me10 (ESCAPED int not null)
5098
###> execute error:You 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
5099
###< drop table crash_me10
5100
###> execute error:Unknown table 'crash_me10'
5102
###As far as some queries didnt return OK, result is YES
5103
reserved_word_extra_exclusive=no # Keyword EXCLUSIVE
5104
###< create table crash_me10 (EXCLUSIVE int not null)
5106
###< drop table crash_me10
5109
###As far as all queries returned OK, result is NO
5110
reserved_word_extra_explain=yes # Keyword EXPLAIN
5111
###< create table crash_me10 (EXPLAIN int not null)
5112
###> execute error:You 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
5113
###< drop table crash_me10
5114
###> execute error:Unknown table 'crash_me10'
5116
###As far as some queries didnt return OK, result is YES
5117
reserved_word_extra_fields=yes # Keyword FIELDS
5118
###< create table crash_me10 (FIELDS int not null)
5119
###> execute error:You 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
5120
###< drop table crash_me10
5121
###> execute error:Unknown table 'crash_me10'
5123
###As far as some queries didnt return OK, result is YES
5124
reserved_word_extra_file=no # Keyword FILE
5125
###< create table crash_me10 (FILE int not null)
5127
###< drop table crash_me10
5130
###As far as all queries returned OK, result is NO
5131
reserved_word_extra_fillfactor=no # Keyword FILLFACTOR
5132
###< create table crash_me10 (FILLFACTOR int not null)
5134
###< drop table crash_me10
5137
###As far as all queries returned OK, result is NO
5138
reserved_word_extra_freetext=no # Keyword FREETEXT
5139
###< create table crash_me10 (FREETEXT int not null)
5141
###< drop table crash_me10
5144
###As far as all queries returned OK, result is NO
5145
reserved_word_extra_freetexttable=no # Keyword FREETEXTTABLE
5146
###< create table crash_me10 (FREETEXTTABLE int not null)
5148
###< drop table crash_me10
5151
###As far as all queries returned OK, result is NO
5152
reserved_word_extra_fulltext=yes # Keyword FULLTEXT
5153
###< create table crash_me10 (FULLTEXT int not null)
5154
###> execute error:You 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
5155
###< drop table crash_me10
5156
###> execute error:Unknown table 'crash_me10'
5158
###As far as some queries didnt return OK, result is YES
5159
reserved_word_extra_geometry=no # Keyword GEOMETRY
5160
###< create table crash_me10 (GEOMETRY int not null)
5162
###< drop table crash_me10
5165
###As far as all queries returned OK, result is NO
5166
reserved_word_extra_hash=no # Keyword HASH
5167
###< create table crash_me10 (HASH int not null)
5169
###< drop table crash_me10
5172
###As far as all queries returned OK, result is NO
5173
reserved_word_extra_high_priority=yes # Keyword HIGH_PRIORITY
5174
###< create table crash_me10 (HIGH_PRIORITY int not null)
5175
###> execute error:You 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
5176
###< drop table crash_me10
5177
###> execute error:Unknown table 'crash_me10'
5179
###As far as some queries didnt return OK, result is YES
5180
reserved_word_extra_holdlock=no # Keyword HOLDLOCK
5181
###< create table crash_me10 (HOLDLOCK int not null)
5183
###< drop table crash_me10
5186
###As far as all queries returned OK, result is NO
5187
reserved_word_extra_hour_minute=yes # Keyword HOUR_MINUTE
5188
###< create table crash_me10 (HOUR_MINUTE int not null)
5189
###> execute error:You 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
5190
###< drop table crash_me10
5191
###> execute error:Unknown table 'crash_me10'
5193
###As far as some queries didnt return OK, result is YES
5194
reserved_word_extra_hour_second=yes # Keyword HOUR_SECOND
5195
###< create table crash_me10 (HOUR_SECOND int not null)
5196
###> execute error:You 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
5197
###< drop table crash_me10
5198
###> execute error:Unknown table 'crash_me10'
5200
###As far as some queries didnt return OK, result is YES
5201
reserved_word_extra_identified=no # Keyword IDENTIFIED
5202
###< create table crash_me10 (IDENTIFIED int not null)
5204
###< drop table crash_me10
5207
###As far as all queries returned OK, result is NO
5208
reserved_word_extra_identity_insert=no # Keyword IDENTITY_INSERT
5209
###< create table crash_me10 (IDENTITY_INSERT int not null)
5211
###< drop table crash_me10
5214
###As far as all queries returned OK, result is NO
5215
reserved_word_extra_identitycol=no # Keyword IDENTITYCOL
5216
###< create table crash_me10 (IDENTITYCOL int not null)
5218
###< drop table crash_me10
5221
###As far as all queries returned OK, result is NO
5222
reserved_word_extra_increment=no # Keyword INCREMENT
5223
###< create table crash_me10 (INCREMENT int not null)
5225
###< drop table crash_me10
5228
###As far as all queries returned OK, result is NO
5229
reserved_word_extra_index=yes # Keyword INDEX
5230
###< create table crash_me10 (INDEX int not null)
5231
###> execute error:You 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
5232
###< drop table crash_me10
5233
###> execute error:Unknown table 'crash_me10'
5235
###As far as some queries didnt return OK, result is YES
5236
reserved_word_extra_infile=yes # Keyword INFILE
5237
###< create table crash_me10 (INFILE int not null)
5238
###> execute error:You 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
5239
###< drop table crash_me10
5240
###> execute error:Unknown table 'crash_me10'
5242
###As far as some queries didnt return OK, result is YES
5243
reserved_word_extra_initial=no # Keyword INITIAL
5244
###< create table crash_me10 (INITIAL int not null)
5246
###< drop table crash_me10
5249
###As far as all queries returned OK, result is NO
5250
reserved_word_extra_innodb=no # Keyword INNODB
5251
###< create table crash_me10 (INNODB int not null)
5253
###< drop table crash_me10
5256
###As far as all queries returned OK, result is NO
5257
reserved_word_extra_keys=yes # Keyword KEYS
5258
###< create table crash_me10 (KEYS int not null)
5259
###> execute error:You 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
5260
###< drop table crash_me10
5261
###> execute error:Unknown table 'crash_me10'
5263
###As far as some queries didnt return OK, result is YES
5264
reserved_word_extra_kill=yes # Keyword KILL
5265
###< create table crash_me10 (KILL int not null)
5266
###> execute error:You 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
5267
###< drop table crash_me10
5268
###> execute error:Unknown table 'crash_me10'
5270
###As far as some queries didnt return OK, result is YES
5271
reserved_word_extra_lineno=no # Keyword LINENO
5272
###< create table crash_me10 (LINENO int not null)
5274
###< drop table crash_me10
5277
###As far as all queries returned OK, result is NO
5278
reserved_word_extra_lines=yes # Keyword LINES
5279
###< create table crash_me10 (LINES int not null)
5280
###> execute error:You 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
5281
###< drop table crash_me10
5282
###> execute error:Unknown table 'crash_me10'
5284
###As far as some queries didnt return OK, result is YES
5285
reserved_word_extra_load=yes # Keyword LOAD
5286
###< create table crash_me10 (LOAD int not null)
5287
###> execute error:You 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
5288
###< drop table crash_me10
5289
###> execute error:Unknown table 'crash_me10'
5291
###As far as some queries didnt return OK, result is YES
5292
reserved_word_extra_lock=yes # Keyword LOCK
5293
###< create table crash_me10 (LOCK int not null)
5294
###> execute error:You 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
5295
###< drop table crash_me10
5296
###> execute error:Unknown table 'crash_me10'
5298
###As far as some queries didnt return OK, result is YES
5299
reserved_word_extra_long=yes # Keyword LONG
5300
###< create table crash_me10 (LONG int not null)
5301
###> execute error:You 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
5302
###< drop table crash_me10
5303
###> execute error:Unknown table 'crash_me10'
5305
###As far as some queries didnt return OK, result is YES
5306
reserved_word_extra_longblob=yes # Keyword LONGBLOB
5307
###< create table crash_me10 (LONGBLOB int not null)
5308
###> execute error:You 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
5309
###< drop table crash_me10
5310
###> execute error:Unknown table 'crash_me10'
5312
###As far as some queries didnt return OK, result is YES
5313
reserved_word_extra_longtext=yes # Keyword LONGTEXT
5314
###< create table crash_me10 (LONGTEXT int not null)
5315
###> execute error:You 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
5316
###< drop table crash_me10
5317
###> execute error:Unknown table 'crash_me10'
5319
###As far as some queries didnt return OK, result is YES
5320
reserved_word_extra_low_priority=yes # Keyword LOW_PRIORITY
5321
###< create table crash_me10 (LOW_PRIORITY int not null)
5322
###> execute error:You 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
5323
###< drop table crash_me10
5324
###> execute error:Unknown table 'crash_me10'
5326
###As far as some queries didnt return OK, result is YES
5327
reserved_word_extra_master_server_id=no # Keyword MASTER_SERVER_ID
5328
###< create table crash_me10 (MASTER_SERVER_ID int not null)
5330
###< drop table crash_me10
5333
###As far as all queries returned OK, result is NO
5334
reserved_word_extra_maxextents=no # Keyword MAXEXTENTS
5335
###< create table crash_me10 (MAXEXTENTS int not null)
5337
###< drop table crash_me10
5340
###As far as all queries returned OK, result is NO
5341
reserved_word_extra_mediumblob=yes # Keyword MEDIUMBLOB
5342
###< create table crash_me10 (MEDIUMBLOB int not null)
5343
###> execute error:You 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
5344
###< drop table crash_me10
5345
###> execute error:Unknown table 'crash_me10'
5347
###As far as some queries didnt return OK, result is YES
5348
reserved_word_extra_mediumint=yes # Keyword MEDIUMINT
5349
###< create table crash_me10 (MEDIUMINT int not null)
5350
###> execute error:You 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
5351
###< drop table crash_me10
5352
###> execute error:Unknown table 'crash_me10'
5354
###As far as some queries didnt return OK, result is YES
5355
reserved_word_extra_mediumtext=yes # Keyword MEDIUMTEXT
5356
###< create table crash_me10 (MEDIUMTEXT int not null)
5357
###> execute error:You 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
5358
###< drop table crash_me10
5359
###> execute error:Unknown table 'crash_me10'
5361
###As far as some queries didnt return OK, result is YES
5362
reserved_word_extra_middleint=yes # Keyword MIDDLEINT
5363
###< create table crash_me10 (MIDDLEINT int not null)
5364
###> execute error:You 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
5365
###< drop table crash_me10
5366
###> execute error:Unknown table 'crash_me10'
5368
###As far as some queries didnt return OK, result is YES
5369
reserved_word_extra_minus=no # Keyword MINUS
5370
###< create table crash_me10 (MINUS int not null)
5372
###< drop table crash_me10
5375
###As far as all queries returned OK, result is NO
5376
reserved_word_extra_minute_second=yes # Keyword MINUTE_SECOND
5377
###< create table crash_me10 (MINUTE_SECOND int not null)
5378
###> execute error:You 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
5379
###< drop table crash_me10
5380
###> execute error:Unknown table 'crash_me10'
5382
###As far as some queries didnt return OK, result is YES
5383
reserved_word_extra_mlslabel=no # Keyword MLSLABEL
5384
###< create table crash_me10 (MLSLABEL int not null)
5386
###< drop table crash_me10
5389
###As far as all queries returned OK, result is NO
5390
reserved_word_extra_mode=no # Keyword MODE
5391
###< create table crash_me10 (MODE int not null)
5393
###< drop table crash_me10
5396
###As far as all queries returned OK, result is NO
5397
reserved_word_extra_mrg_myisam=no # Keyword MRG_MYISAM
5398
###< create table crash_me10 (MRG_MYISAM int not null)
5400
###< drop table crash_me10
5403
###As far as all queries returned OK, result is NO
5404
reserved_word_extra_noaudit=no # Keyword NOAUDIT
5405
###< create table crash_me10 (NOAUDIT int not null)
5407
###< drop table crash_me10
5410
###As far as all queries returned OK, result is NO
5411
reserved_word_extra_nocheck=no # Keyword NOCHECK
5412
###< create table crash_me10 (NOCHECK int not null)
5414
###< drop table crash_me10
5417
###As far as all queries returned OK, result is NO
5418
reserved_word_extra_nocompress=no # Keyword NOCOMPRESS
5419
###< create table crash_me10 (NOCOMPRESS int not null)
5421
###< drop table crash_me10
5424
###As far as all queries returned OK, result is NO
5425
reserved_word_extra_nonclustered=no # Keyword NONCLUSTERED
5426
###< create table crash_me10 (NONCLUSTERED int not null)
5428
###< drop table crash_me10
5431
###As far as all queries returned OK, result is NO
5432
reserved_word_extra_nowait=no # Keyword NOWAIT
5433
###< create table crash_me10 (NOWAIT int not null)
5435
###< drop table crash_me10
5438
###As far as all queries returned OK, result is NO
5439
reserved_word_extra_number=no # Keyword NUMBER
5440
###< create table crash_me10 (NUMBER int not null)
5442
###< drop table crash_me10
5445
###As far as all queries returned OK, result is NO
5446
reserved_word_extra_offline=no # Keyword OFFLINE
5447
###< create table crash_me10 (OFFLINE int not null)
5449
###< drop table crash_me10
5452
###As far as all queries returned OK, result is NO
5453
reserved_word_extra_offsets=no # Keyword OFFSETS
5454
###< create table crash_me10 (OFFSETS int not null)
5456
###< drop table crash_me10
5459
###As far as all queries returned OK, result is NO
5460
reserved_word_extra_online=no # Keyword ONLINE
5461
###< create table crash_me10 (ONLINE int not null)
5463
###< drop table crash_me10
5466
###As far as all queries returned OK, result is NO
5467
reserved_word_extra_opendatasource=no # Keyword OPENDATASOURCE
5468
###< create table crash_me10 (OPENDATASOURCE int not null)
5470
###< drop table crash_me10
5473
###As far as all queries returned OK, result is NO
5474
reserved_word_extra_openquery=no # Keyword OPENQUERY
5475
###< create table crash_me10 (OPENQUERY int not null)
5477
###< drop table crash_me10
5480
###As far as all queries returned OK, result is NO
5481
reserved_word_extra_openrowset=no # Keyword OPENROWSET
5482
###< create table crash_me10 (OPENROWSET int not null)
5484
###< drop table crash_me10
5487
###As far as all queries returned OK, result is NO
5488
reserved_word_extra_openxml=no # Keyword OPENXML
5489
###< create table crash_me10 (OPENXML int not null)
5491
###< drop table crash_me10
5494
###As far as all queries returned OK, result is NO
5495
reserved_word_extra_optimize=yes # Keyword OPTIMIZE
5496
###< create table crash_me10 (OPTIMIZE int not null)
5497
###> execute error:You 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
5498
###< drop table crash_me10
5499
###> execute error:Unknown table 'crash_me10'
5501
###As far as some queries didnt return OK, result is YES
5502
reserved_word_extra_optionally=yes # Keyword OPTIONALLY
5503
###< create table crash_me10 (OPTIONALLY int not null)
5504
###> execute error:You 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
5505
###< drop table crash_me10
5506
###> execute error:Unknown table 'crash_me10'
5508
###As far as some queries didnt return OK, result is YES
5509
reserved_word_extra_outfile=yes # Keyword OUTFILE
5510
###< create table crash_me10 (OUTFILE int not null)
5511
###> execute error:You 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
5512
###< drop table crash_me10
5513
###> execute error:Unknown table 'crash_me10'
5515
###As far as some queries didnt return OK, result is YES
5516
reserved_word_extra_over=no # Keyword OVER
5517
###< create table crash_me10 (OVER int not null)
5519
###< drop table crash_me10
5522
###As far as all queries returned OK, result is NO
5523
reserved_word_extra_pctfree=no # Keyword PCTFREE
5524
###< create table crash_me10 (PCTFREE int not null)
5526
###< drop table crash_me10
5529
###As far as all queries returned OK, result is NO
5530
reserved_word_extra_percent=no # Keyword PERCENT
5531
###< create table crash_me10 (PERCENT int not null)
5533
###< drop table crash_me10
5536
###As far as all queries returned OK, result is NO
5537
reserved_word_extra_plan=no # Keyword PLAN
5538
###< create table crash_me10 (PLAN int not null)
5540
###< drop table crash_me10
5543
###As far as all queries returned OK, result is NO
5544
reserved_word_extra_print=no # Keyword PRINT
5545
###< create table crash_me10 (PRINT int not null)
5547
###< drop table crash_me10
5550
###As far as all queries returned OK, result is NO
5551
reserved_word_extra_proc=no # Keyword PROC
5552
###< create table crash_me10 (PROC int not null)
5554
###< drop table crash_me10
5557
###As far as all queries returned OK, result is NO
5558
reserved_word_extra_purge=yes # Keyword PURGE
5559
###< create table crash_me10 (PURGE int not null)
5560
###> execute error:You 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
5561
###< drop table crash_me10
5562
###> execute error:Unknown table 'crash_me10'
5564
###As far as some queries didnt return OK, result is YES
5565
reserved_word_extra_raiserror=no # Keyword RAISERROR
5566
###< create table crash_me10 (RAISERROR int not null)
5568
###< drop table crash_me10
5571
###As far as all queries returned OK, result is NO
5572
reserved_word_extra_raw=no # Keyword RAW
5573
###< create table crash_me10 (RAW int not null)
5575
###< drop table crash_me10
5578
###As far as all queries returned OK, result is NO
5579
reserved_word_extra_readtext=no # Keyword READTEXT
5580
###< create table crash_me10 (READTEXT int not null)
5582
###< drop table crash_me10
5585
###As far as all queries returned OK, result is NO
5586
reserved_word_extra_reconfigure=no # Keyword RECONFIGURE
5587
###< create table crash_me10 (RECONFIGURE int not null)
5589
###< drop table crash_me10
5592
###As far as all queries returned OK, result is NO
5593
reserved_word_extra_regexp=yes # Keyword REGEXP
5594
###< create table crash_me10 (REGEXP int not null)
5595
###> execute error:You 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
5596
###< drop table crash_me10
5597
###> execute error:Unknown table 'crash_me10'
5599
###As far as some queries didnt return OK, result is YES
5600
reserved_word_extra_rename=yes # Keyword RENAME
5601
###< create table crash_me10 (RENAME int not null)
5602
###> execute error:You 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
5603
###< drop table crash_me10
5604
###> execute error:Unknown table 'crash_me10'
5606
###As far as some queries didnt return OK, result is YES
5607
reserved_word_extra_replication=no # Keyword REPLICATION
5608
###< create table crash_me10 (REPLICATION int not null)
5610
###< drop table crash_me10
5613
###As far as all queries returned OK, result is NO
5614
reserved_word_extra_require=yes # Keyword REQUIRE
5615
###< create table crash_me10 (REQUIRE int not null)
5616
###> execute error:You 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
5617
###< drop table crash_me10
5618
###> execute error:Unknown table 'crash_me10'
5620
###As far as some queries didnt return OK, result is YES
5621
reserved_word_extra_resource=no # Keyword RESOURCE
5622
###< create table crash_me10 (RESOURCE int not null)
5624
###< drop table crash_me10
5627
###As far as all queries returned OK, result is NO
5628
reserved_word_extra_restore=no # Keyword RESTORE
5629
###< create table crash_me10 (RESTORE int not null)
5631
###< drop table crash_me10
5634
###As far as all queries returned OK, result is NO
5635
reserved_word_extra_rlike=yes # Keyword RLIKE
5636
###< create table crash_me10 (RLIKE int not null)
5637
###> execute error:You 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
5638
###< drop table crash_me10
5639
###> execute error:Unknown table 'crash_me10'
5641
###As far as some queries didnt return OK, result is YES
5642
reserved_word_extra_rowcount=no # Keyword ROWCOUNT
5643
###< create table crash_me10 (ROWCOUNT int not null)
5645
###< drop table crash_me10
5648
###As far as all queries returned OK, result is NO
5649
reserved_word_extra_rowguidcol=no # Keyword ROWGUIDCOL
5650
###< create table crash_me10 (ROWGUIDCOL int not null)
5652
###< drop table crash_me10
5655
###As far as all queries returned OK, result is NO
5656
reserved_word_extra_rowid=no # Keyword ROWID
5657
###< create table crash_me10 (ROWID int not null)
5659
###< drop table crash_me10
5662
###As far as all queries returned OK, result is NO
5663
reserved_word_extra_rownum=no # Keyword ROWNUM
5664
###< create table crash_me10 (ROWNUM int not null)
5666
###< drop table crash_me10
5669
###As far as all queries returned OK, result is NO
5670
reserved_word_extra_rtree=no # Keyword RTREE
5671
###< create table crash_me10 (RTREE int not null)
5673
###< drop table crash_me10
5676
###As far as all queries returned OK, result is NO
5677
reserved_word_extra_rule=no # Keyword RULE
5678
###< create table crash_me10 (RULE int not null)
5680
###< drop table crash_me10
5683
###As far as all queries returned OK, result is NO
5684
reserved_word_extra_save=no # Keyword SAVE
5685
###< create table crash_me10 (SAVE int not null)
5687
###< drop table crash_me10
5690
###As far as all queries returned OK, result is NO
5691
reserved_word_extra_setuser=no # Keyword SETUSER
5692
###< create table crash_me10 (SETUSER int not null)
5694
###< drop table crash_me10
5697
###As far as all queries returned OK, result is NO
5698
reserved_word_extra_share=no # Keyword SHARE
5699
###< create table crash_me10 (SHARE int not null)
5701
###< drop table crash_me10
5704
###As far as all queries returned OK, result is NO
5705
reserved_word_extra_show=yes # Keyword SHOW
5706
###< create table crash_me10 (SHOW int not null)
5707
###> execute error:You 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
5708
###< drop table crash_me10
5709
###> execute error:Unknown table 'crash_me10'
5711
###As far as some queries didnt return OK, result is YES
5712
reserved_word_extra_shutdown=no # Keyword SHUTDOWN
5713
###< create table crash_me10 (SHUTDOWN int not null)
5715
###< drop table crash_me10
5718
###As far as all queries returned OK, result is NO
5719
reserved_word_extra_soname=yes # Keyword SONAME
5720
###< create table crash_me10 (SONAME int not null)
5721
###> execute error:You 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
5722
###< drop table crash_me10
5723
###> execute error:Unknown table 'crash_me10'
5725
###As far as some queries didnt return OK, result is YES
5726
reserved_word_extra_spatial=yes # Keyword SPATIAL
5727
###< create table crash_me10 (SPATIAL int not null)
5728
###> execute error:You 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
5729
###< drop table crash_me10
5730
###> execute error:Unknown table 'crash_me10'
5732
###As far as some queries didnt return OK, result is YES
5733
reserved_word_extra_sql_big_result=yes # Keyword SQL_BIG_RESULT
5734
###< create table crash_me10 (SQL_BIG_RESULT int not null)
5735
###> execute error:You 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
5736
###< drop table crash_me10
5737
###> execute error:Unknown table 'crash_me10'
5739
###As far as some queries didnt return OK, result is YES
5740
reserved_word_extra_sql_calc_found_rows=yes # Keyword SQL_CALC_FOUND_ROWS
5741
###< create table crash_me10 (SQL_CALC_FOUND_ROWS int not null)
5742
###> execute error:You 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
5743
###< drop table crash_me10
5744
###> execute error:Unknown table 'crash_me10'
5746
###As far as some queries didnt return OK, result is YES
5747
reserved_word_extra_sql_small_result=yes # Keyword SQL_SMALL_RESULT
5748
###< create table crash_me10 (SQL_SMALL_RESULT int not null)
5749
###> execute error:You 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
5750
###< drop table crash_me10
5751
###> execute error:Unknown table 'crash_me10'
5753
###As far as some queries didnt return OK, result is YES
5754
reserved_word_extra_ssl=yes # Keyword SSL
5755
###< create table crash_me10 (SSL int not null)
5756
###> execute error:You 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
5757
###< drop table crash_me10
5758
###> execute error:Unknown table 'crash_me10'
5760
###As far as some queries didnt return OK, result is YES
5761
reserved_word_extra_starting=yes # Keyword STARTING
5762
###< create table crash_me10 (STARTING int not null)
5763
###> execute error:You 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
5764
###< drop table crash_me10
5765
###> execute error:Unknown table 'crash_me10'
5767
###As far as some queries didnt return OK, result is YES
5768
reserved_word_extra_statistics=no # Keyword STATISTICS
5769
###< create table crash_me10 (STATISTICS int not null)
5771
###< drop table crash_me10
5774
###As far as all queries returned OK, result is NO
5775
reserved_word_extra_straight_join=yes # Keyword STRAIGHT_JOIN
5776
###< create table crash_me10 (STRAIGHT_JOIN int not null)
5777
###> execute error:You 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
5778
###< drop table crash_me10
5779
###> execute error:Unknown table 'crash_me10'
5781
###As far as some queries didnt return OK, result is YES
5782
reserved_word_extra_striped=no # Keyword STRIPED
5783
###< create table crash_me10 (STRIPED int not null)
5785
###< drop table crash_me10
5788
###As far as all queries returned OK, result is NO
5789
reserved_word_extra_successful=no # Keyword SUCCESSFUL
5790
###< create table crash_me10 (SUCCESSFUL int not null)
5792
###< drop table crash_me10
5795
###As far as all queries returned OK, result is NO
5796
reserved_word_extra_synonym=no # Keyword SYNONYM
5797
###< create table crash_me10 (SYNONYM int not null)
5799
###< drop table crash_me10
5802
###As far as all queries returned OK, result is NO
5803
reserved_word_extra_sysdate=no # Keyword SYSDATE
5804
###< create table crash_me10 (SYSDATE int not null)
5806
###< drop table crash_me10
5809
###As far as all queries returned OK, result is NO
5810
reserved_word_extra_tables=yes # Keyword TABLES
5811
###< create table crash_me10 (TABLES int not null)
5812
###> execute error:You 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
5813
###< drop table crash_me10
5814
###> execute error:Unknown table 'crash_me10'
5816
###As far as some queries didnt return OK, result is YES
5817
reserved_word_extra_terminated=yes # Keyword TERMINATED
5818
###< create table crash_me10 (TERMINATED int not null)
5819
###> execute error:You 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
5820
###< drop table crash_me10
5821
###> execute error:Unknown table 'crash_me10'
5823
###As far as some queries didnt return OK, result is YES
5824
reserved_word_extra_textsize=no # Keyword TEXTSIZE
5825
###< create table crash_me10 (TEXTSIZE int not null)
5827
###< drop table crash_me10
5830
###As far as all queries returned OK, result is NO
5831
reserved_word_extra_tinyblob=yes # Keyword TINYBLOB
5832
###< create table crash_me10 (TINYBLOB int not null)
5833
###> execute error:You 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
5834
###< drop table crash_me10
5835
###> execute error:Unknown table 'crash_me10'
5837
###As far as some queries didnt return OK, result is YES
5838
reserved_word_extra_tinyint=yes # Keyword TINYINT
5839
###< create table crash_me10 (TINYINT int not null)
5840
###> execute error:You 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
5841
###< drop table crash_me10
5842
###> execute error:Unknown table 'crash_me10'
5844
###As far as some queries didnt return OK, result is YES
5845
reserved_word_extra_tinytext=yes # Keyword TINYTEXT
5846
###< create table crash_me10 (TINYTEXT int not null)
5847
###> execute error:You 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
5848
###< drop table crash_me10
5849
###> execute error:Unknown table 'crash_me10'
5851
###As far as some queries didnt return OK, result is YES
5852
reserved_word_extra_top=no # Keyword TOP
5853
###< create table crash_me10 (TOP int not null)
5855
###< drop table crash_me10
5858
###As far as all queries returned OK, result is NO
5859
reserved_word_extra_tran=no # Keyword TRAN
5860
###< create table crash_me10 (TRAN int not null)
5862
###< drop table crash_me10
5865
###As far as all queries returned OK, result is NO
5866
reserved_word_extra_truncate=no # Keyword TRUNCATE
5867
###< create table crash_me10 (TRUNCATE int not null)
5869
###< drop table crash_me10
5872
###As far as all queries returned OK, result is NO
5873
reserved_word_extra_tsequal=no # Keyword TSEQUAL
5874
###< create table crash_me10 (TSEQUAL int not null)
5876
###< drop table crash_me10
5879
###As far as all queries returned OK, result is NO
5880
reserved_word_extra_types=no # Keyword TYPES
5881
###< create table crash_me10 (TYPES int not null)
5883
###< drop table crash_me10
5886
###As far as all queries returned OK, result is NO
5887
reserved_word_extra_uid=no # Keyword UID
5888
###< create table crash_me10 (UID int not null)
5890
###< drop table crash_me10
5893
###As far as all queries returned OK, result is NO
5894
reserved_word_extra_unlock=yes # Keyword UNLOCK
5895
###< create table crash_me10 (UNLOCK int not null)
5896
###> execute error:You 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
5897
###< drop table crash_me10
5898
###> execute error:Unknown table 'crash_me10'
5900
###As far as some queries didnt return OK, result is YES
5901
reserved_word_extra_unsigned=yes # Keyword UNSIGNED
5902
###< create table crash_me10 (UNSIGNED int not null)
5903
###> execute error:You 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
5904
###< drop table crash_me10
5905
###> execute error:Unknown table 'crash_me10'
5907
###As far as some queries didnt return OK, result is YES
5908
reserved_word_extra_updatetext=no # Keyword UPDATETEXT
5909
###< create table crash_me10 (UPDATETEXT int not null)
5911
###< drop table crash_me10
5914
###As far as all queries returned OK, result is NO
5915
reserved_word_extra_use=yes # Keyword USE
5916
###< create table crash_me10 (USE int not null)
5917
###> execute error:You 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
5918
###< drop table crash_me10
5919
###> execute error:Unknown table 'crash_me10'
5921
###As far as some queries didnt return OK, result is YES
5922
reserved_word_extra_user_resources=no # Keyword USER_RESOURCES
5923
###< create table crash_me10 (USER_RESOURCES int not null)
5925
###< drop table crash_me10
5928
###As far as all queries returned OK, result is NO
5929
reserved_word_extra_validate=no # Keyword VALIDATE
5930
###< create table crash_me10 (VALIDATE int not null)
5932
###< drop table crash_me10
5935
###As far as all queries returned OK, result is NO
5936
reserved_word_extra_varbinary=yes # Keyword VARBINARY
5937
###< create table crash_me10 (VARBINARY int not null)
5938
###> execute error:You 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
5939
###< drop table crash_me10
5940
###> execute error:Unknown table 'crash_me10'
5942
###As far as some queries didnt return OK, result is YES
5943
reserved_word_extra_varchar2=no # Keyword VARCHAR2
5944
###< create table crash_me10 (VARCHAR2 int not null)
5946
###< drop table crash_me10
5949
###As far as all queries returned OK, result is NO
5950
reserved_word_extra_waitfor=no # Keyword WAITFOR
5951
###< create table crash_me10 (WAITFOR int not null)
5953
###< drop table crash_me10
5956
###As far as all queries returned OK, result is NO
5957
reserved_word_extra_warnings=no # Keyword WARNINGS
5958
###< create table crash_me10 (WARNINGS int not null)
5960
###< drop table crash_me10
5963
###As far as all queries returned OK, result is NO
5964
reserved_word_extra_writetext=no # Keyword WRITETEXT
5965
###< create table crash_me10 (WRITETEXT int not null)
5967
###< drop table crash_me10
5970
###As far as all queries returned OK, result is NO
5971
reserved_word_extra_xor=yes # Keyword XOR
5972
###< create table crash_me10 (XOR int not null)
5973
###> execute error:You 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
5974
###< drop table crash_me10
5975
###> execute error:Unknown table 'crash_me10'
5977
###As far as some queries didnt return OK, result is YES
5978
reserved_word_extra_year_month=yes # Keyword YEAR_MONTH
5979
###< create table crash_me10 (YEAR_MONTH int not null)
5980
###> execute error:You 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
5981
###< drop table crash_me10
5982
###> execute error:Unknown table 'crash_me10'
5984
###As far as some queries didnt return OK, result is YES
5985
reserved_word_extra_zerofill=yes # Keyword ZEROFILL
5986
###< create table crash_me10 (ZEROFILL int not null)
5987
###> execute error:You 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
5988
###< drop table crash_me10
5989
###> execute error:Unknown table 'crash_me10'
5991
###As far as some queries didnt return OK, result is YES
5992
right_outer_join=yes # right outer join
5993
###< select crash_me.a from crash_me right join crash_me2 ON crash_me.a=crash_me2.a
5996
###As far as all queries returned OK, result is YES
5997
rollback_metadata=no # rollback_metadata
5998
###< create table crash_q (a integer not null)
6001
###< insert into crash_q values (1)
6003
rowid=auto_increment # Type for row id
6004
###< create table crash_q (a rowid)
6005
###> execute error:You 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
6006
###< drop table crash_q
6007
###> execute error:Unknown table 'crash_q'
6009
###< create table crash_q (a int not null auto_increment, primary key(a))
6011
###< drop table crash_q
6013
safe_decimal_arithmetic=no # safe decimal arithmetic
6014
###< create table crash_me_a (a decimal(10,2),b decimal(10,2))
6017
###< insert into crash_me_a (a,b) values (11.4,18.9)
6020
###<select count(*) from crash_me_a where a+b=30.3
6022
###We expected '1' but got '0'
6023
select_constants=yes # Select constants
6027
###As far as all queries returned OK, result is YES
6028
select_limit=with LIMIT # LIMIT number of rows
6029
###< select * from crash_me limit 1
6031
select_limit2=yes # SELECT with LIMIT #,#
6032
###< select * from crash_me limit 1,1
6035
###As far as all queries returned OK, result is YES
6036
select_limit3=yes # SELECT with LIMIT # OFFSET #
6037
###< select * from crash_me limit 1 offset 1
6040
###As far as all queries returned OK, result is YES
6041
select_string_size=1048565 # constant string size in SELECT
6042
###We are trying (example with N=5):
6044
select_table_update=yes # Update with sub select
6045
###< create table crash_q (a integer,b char(10))
6047
###< insert into crash_q values(1,'c')
6049
###< update crash_q set b= (select b from crash_me where crash_q.a = crash_me.a)
6052
###<select b from crash_q
6055
###< drop table crash_q
6057
select_without_from=yes # SELECT without FROM
6061
###As far as all queries returned OK, result is YES
6062
server_version=MySQL 4.1.2 alpha # server version
6063
simple_joins=yes # ANSI SQL simple joins
6064
###< select crash_me.a from crash_me, crash_me t0
6067
###As far as all queries returned OK, result is YES
6068
sorted_group_by=yes # Group by always sorted
6069
###< create table crash_me_t1 (a int not null, b int not null)
6071
###< insert into crash_me_t1 values (1,1)
6073
###< insert into crash_me_t1 values (1,2)
6075
###< insert into crash_me_t1 values (3,1)
6077
###< insert into crash_me_t1 values (3,2)
6079
###< insert into crash_me_t1 values (2,2)
6081
###< insert into crash_me_t1 values (2,1)
6083
###< create table crash_me_t2 (a int not null, b int not null)
6085
###< create index crash_me_t2_ind on crash_me_t2 (a)
6087
###< insert into crash_me_t2 values (1,3)
6089
###< insert into crash_me_t2 values (3,1)
6091
###< insert into crash_me_t2 values (2,2)
6093
###< insert into crash_me_t2 values (1,1)
6096
###< 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
6102
### Check recordset:
6103
### 1,1 expected: 1,1
6104
### 1,3 expected: 1,3
6105
### 2,2 expected: 2,2
6106
### 3,1 expected: 3,1
6107
### Recordset corresponds with template
6108
###< drop table crash_me_t1
6110
###< drop table crash_me_t2
6112
storage_of_float=round # Storage of float values
6113
###< create table crash_q (q1 float(4,1))
6115
###< insert into crash_q values(1.14)
6118
###<select q1 from crash_q
6121
###< drop table crash_q
6124
###< create table crash_q (q1 float(4,1))
6126
###< insert into crash_q values(1.16)
6129
###<select q1 from crash_q
6131
###We expected '1.1' but got '1.2'
6133
###< drop table crash_q
6136
###< create table crash_q (q1 float(4,1))
6138
###< insert into crash_q values(1.14)
6141
###<select q1 from crash_q
6144
###< drop table crash_q
6147
###< create table crash_q (q1 float(4,1))
6149
###< insert into crash_q values(1.16)
6152
###<select q1 from crash_q
6155
###< drop table crash_q
6157
subqueries=yes # subqueries
6158
###< select a from crash_me where crash_me.a in (select max(a) from crash_me)
6161
###As far as all queries returned OK, result is YES
6162
table_alias=yes # Table alias
6163
###< select b.a from crash_me as b
6166
###As far as all queries returned OK, result is YES
6167
table_name_case=no # case independent table names
6168
###< create table crash_q (q integer)
6170
###< drop table CRASH_Q
6171
###> execute error:Unknown table 'CRASH_Q'
6173
###As far as some queries didnt return OK, result is NO
6174
table_wildcard=yes # Select table_name.*
6175
###< select crash_me.* from crash_me
6178
###As far as all queries returned OK, result is YES
6179
temporary_table=yes # temporary tables
6180
###< create temporary table crash_q (q integer not null)
6182
###< drop table crash_q
6185
###As far as all queries returned OK, result is YES
6186
time_format_EUR=error # Supports HH.MM.SS (EUR) time format
6187
###< insert into crash_me_t(a) values ('20.08.16')
6190
###<select a from crash_me_t
6192
###We expected '20:08:16' but got '00:00:20'
6194
###< delete from crash_me_t
6196
time_format_HHHHMMSS=yes # Supports HHHHmmSS time format
6197
###< insert into crash_me_t(a) values ('00200816')
6200
###<select a from crash_me_t
6203
###< delete from crash_me_t
6205
time_format_ISO=yes # Supports HH:MM:SS (ISO) time format
6206
###< insert into crash_me_t(a) values ('20:08:16')
6209
###<select a from crash_me_t
6212
###< delete from crash_me_t
6214
time_format_USA=error # Supports HH:MM:SS (AM|PM) time format
6215
###< insert into crash_me_t(a) values ('08:08:16 PM')
6218
###<select a from crash_me_t
6220
###We expected '20:08:16' but got '08:08:16'
6222
###< delete from crash_me_t
6224
time_format_inresult=iso # Time format in result
6225
###< insert into crash_me_t values(CURRENT_TIME)
6228
###< select a from crash_me_t
6230
###< delete from crash_me_t
6232
transactions=yes # transactions
6233
###<select * from crash_q
6235
###We expected '' but got '1'
6236
truncate_table=yes # truncate
6237
###< create table crash_q (a integer, b integer,c1 CHAR(10))
6239
###< truncate table crash_q
6241
###< drop table crash_q
6244
###As far as all queries returned OK, result is YES
6245
type_extra_abstime=no # Type abstime
6246
###< create table crash_q (q abstime)
6247
###> execute error:You 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
6248
###< drop table crash_q
6249
###> execute error:Unknown table 'crash_q'
6251
###As far as some queries didnt return OK, result is NO
6252
type_extra_bfile=no # Type bfile
6253
###< create table crash_q (q bfile)
6254
###> execute error:You 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
6255
###< drop table crash_q
6256
###> execute error:Unknown table 'crash_q'
6258
###As far as some queries didnt return OK, result is NO
6259
type_extra_blob=yes # Type blob
6260
###< create table crash_q (q blob)
6262
###< drop table crash_q
6265
###As far as all queries returned OK, result is YES
6266
type_extra_bool=yes # Type bool
6267
###< create table crash_q (q bool)
6269
###< drop table crash_q
6272
###As far as all queries returned OK, result is YES
6273
type_extra_box=no # Type box
6274
###< create table crash_q (q box)
6275
###> execute error:You 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
6276
###< drop table crash_q
6277
###> execute error:Unknown table 'crash_q'
6279
###As far as some queries didnt return OK, result is NO
6280
type_extra_byte=no # Type byte
6281
###< create table crash_q (q byte)
6282
###> execute error:You 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
6283
###< drop table crash_q
6284
###> execute error:Unknown table 'crash_q'
6286
###As far as some queries didnt return OK, result is NO
6287
type_extra_char(1_arg)_binary=yes # Type char(1 arg) binary
6288
###< create table crash_q (q char(10) binary)
6290
###< drop table crash_q
6293
###As far as all queries returned OK, result is YES
6294
type_extra_cidr=no # Type cidr
6295
###< create table crash_q (q cidr)
6296
###> execute error:You 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
6297
###< drop table crash_q
6298
###> execute error:Unknown table 'crash_q'
6300
###As far as some queries didnt return OK, result is NO
6301
type_extra_circle=no # Type circle
6302
###< create table crash_q (q circle)
6303
###> execute error:You 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
6304
###< drop table crash_q
6305
###> execute error:Unknown table 'crash_q'
6307
###As far as some queries didnt return OK, result is NO
6308
type_extra_clob=no # Type clob
6309
###< create table crash_q (q clob)
6310
###> execute error:You 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
6311
###< drop table crash_q
6312
###> execute error:Unknown table 'crash_q'
6314
###As far as some queries didnt return OK, result is NO
6315
type_extra_datetime=yes # Type datetime
6316
###< create table crash_q (q datetime)
6318
###< drop table crash_q
6321
###As far as all queries returned OK, result is YES
6322
type_extra_double=yes # Type double
6323
###< create table crash_q (q double)
6325
###< drop table crash_q
6328
###As far as all queries returned OK, result is YES
6329
type_extra_enum(1_arg)=yes # Type enum(1 arg)
6330
###< create table crash_q (q enum('red'))
6332
###< drop table crash_q
6335
###As far as all queries returned OK, result is YES
6336
type_extra_float(2_arg)=yes # Type float(2 arg)
6337
###< create table crash_q (q float(6,2))
6339
###< drop table crash_q
6342
###As far as all queries returned OK, result is YES
6343
type_extra_float4=yes # Type float4
6344
###< create table crash_q (q float4)
6346
###< drop table crash_q
6349
###As far as all queries returned OK, result is YES
6350
type_extra_float8=yes # Type float8
6351
###< create table crash_q (q float8)
6353
###< drop table crash_q
6356
###As far as all queries returned OK, result is YES
6357
type_extra_image=no # Type image
6358
###< create table crash_q (q image)
6359
###> execute error:You 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
6360
###< drop table crash_q
6361
###> execute error:Unknown table 'crash_q'
6363
###As far as some queries didnt return OK, result is NO
6364
type_extra_inet=no # Type inet
6365
###< create table crash_q (q inet)
6366
###> execute error:You 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
6367
###< drop table crash_q
6368
###> execute error:Unknown table 'crash_q'
6370
###As far as some queries didnt return OK, result is NO
6371
type_extra_int(1_arg)_zerofill=yes # Type int(1 arg) zerofill
6372
###< create table crash_q (q int(5) zerofill)
6374
###< drop table crash_q
6377
###As far as all queries returned OK, result is YES
6378
type_extra_int1=yes # Type int1
6379
###< create table crash_q (q int1)
6381
###< drop table crash_q
6384
###As far as all queries returned OK, result is YES
6385
type_extra_int2=yes # Type int2
6386
###< create table crash_q (q int2)
6388
###< drop table crash_q
6391
###As far as all queries returned OK, result is YES
6392
type_extra_int3=yes # Type int3
6393
###< create table crash_q (q int3)
6395
###< drop table crash_q
6398
###As far as all queries returned OK, result is YES
6399
type_extra_int4=yes # Type int4
6400
###< create table crash_q (q int4)
6402
###< drop table crash_q
6405
###As far as all queries returned OK, result is YES
6406
type_extra_int8=yes # Type int8
6407
###< create table crash_q (q int8)
6409
###< drop table crash_q
6412
###As far as all queries returned OK, result is YES
6413
type_extra_int_auto_increment=yes # Type int not null auto_increment
6414
###< create table crash_q (q int not null auto_increment,unique(q))
6416
###< drop table crash_q
6419
###As far as all queries returned OK, result is YES
6420
type_extra_int_identity=no # Type int not null identity
6421
###< create table crash_q (q int not null identity,unique(q))
6422
###> execute error:You 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
6423
###< drop table crash_q
6424
###> execute error:Unknown table 'crash_q'
6426
###As far as some queries didnt return OK, result is NO
6427
type_extra_int_unsigned=yes # Type int unsigned
6428
###< create table crash_q (q int unsigned)
6430
###< drop table crash_q
6433
###As far as all queries returned OK, result is YES
6434
type_extra_interval=no # Type interval
6435
###< create table crash_q (q interval)
6436
###> execute error:You 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
6437
###< drop table crash_q
6438
###> execute error:Unknown table 'crash_q'
6440
###As far as some queries didnt return OK, result is NO
6441
type_extra_line=no # Type line
6442
###< create table crash_q (q line)
6443
###> execute error:You 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
6444
###< drop table crash_q
6445
###> execute error:Unknown table 'crash_q'
6447
###As far as some queries didnt return OK, result is NO
6448
type_extra_long=yes # Type long
6449
###< create table crash_q (q long)
6451
###< drop table crash_q
6454
###As far as all queries returned OK, result is YES
6455
type_extra_long_raw=no # Type long raw
6456
###< create table crash_q (q long raw)
6457
###> execute error:You 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
6458
###< drop table crash_q
6459
###> execute error:Unknown table 'crash_q'
6461
###As far as some queries didnt return OK, result is NO
6462
type_extra_long_varbinary=yes # Type long varbinary
6463
###< create table crash_q (q long varbinary)
6465
###< drop table crash_q
6468
###As far as all queries returned OK, result is YES
6469
type_extra_long_varchar(1_arg)=no # Type long varchar(1 arg)
6470
###< create table crash_q (q long varchar(1))
6471
###> execute error:You 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
6472
###< drop table crash_q
6473
###> execute error:Unknown table 'crash_q'
6475
###As far as some queries didnt return OK, result is NO
6476
type_extra_lseg=no # Type lseg
6477
###< create table crash_q (q lseg)
6478
###> execute error:You 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
6479
###< drop table crash_q
6480
###> execute error:Unknown table 'crash_q'
6482
###As far as some queries didnt return OK, result is NO
6483
type_extra_macaddr=no # Type macaddr
6484
###< create table crash_q (q macaddr)
6485
###> execute error:You 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
6486
###< drop table crash_q
6487
###> execute error:Unknown table 'crash_q'
6489
###As far as some queries didnt return OK, result is NO
6490
type_extra_mediumint=yes # Type mediumint
6491
###< create table crash_q (q mediumint)
6493
###< drop table crash_q
6496
###As far as all queries returned OK, result is YES
6497
type_extra_mediumtext=yes # Type mediumtext
6498
###< create table crash_q (q mediumtext)
6500
###< drop table crash_q
6503
###As far as all queries returned OK, result is YES
6504
type_extra_middleint=yes # Type middleint
6505
###< create table crash_q (q middleint)
6507
###< drop table crash_q
6510
###As far as all queries returned OK, result is YES
6511
type_extra_mlslabel=no # Type mlslabel
6512
###< create table crash_q (q mlslabel)
6513
###> execute error:You 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
6514
###< drop table crash_q
6515
###> execute error:Unknown table 'crash_q'
6517
###As far as some queries didnt return OK, result is NO
6518
type_extra_money=no # Type money
6519
###< create table crash_q (q money)
6520
###> execute error:You 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
6521
###< drop table crash_q
6522
###> execute error:Unknown table 'crash_q'
6524
###As far as some queries didnt return OK, result is NO
6525
type_extra_nclob=no # Type nclob
6526
###< create table crash_q (q nclob)
6527
###> execute error:You 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
6528
###< drop table crash_q
6529
###> execute error:Unknown table 'crash_q'
6531
###As far as some queries didnt return OK, result is NO
6532
type_extra_number=no # Type number
6533
###< create table crash_q (q number)
6534
###> execute error:You 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
6535
###< drop table crash_q
6536
###> execute error:Unknown table 'crash_q'
6538
###As far as some queries didnt return OK, result is NO
6539
type_extra_number(1_arg)=no # Type number(1 arg)
6540
###< create table crash_q (q number(9))
6541
###> execute error:You 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
6542
###< drop table crash_q
6543
###> execute error:Unknown table 'crash_q'
6545
###As far as some queries didnt return OK, result is NO
6546
type_extra_number(2_arg)=no # Type number(2 arg)
6547
###< create table crash_q (q number(9,2))
6548
###> execute error:You 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
6549
###< drop table crash_q
6550
###> execute error:Unknown table 'crash_q'
6552
###As far as some queries didnt return OK, result is NO
6553
type_extra_nvarchar2(1_arg)=no # Type nvarchar2(1 arg)
6554
###< create table crash_q (q nvarchar2(16))
6555
###> execute error:You 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
6556
###< drop table crash_q
6557
###> execute error:Unknown table 'crash_q'
6559
###As far as some queries didnt return OK, result is NO
6560
type_extra_path=no # Type path
6561
###< create table crash_q (q path)
6562
###> execute error:You 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
6563
###< drop table crash_q
6564
###> execute error:Unknown table 'crash_q'
6566
###As far as some queries didnt return OK, result is NO
6567
type_extra_point=yes # Type point
6568
###< create table crash_q (q point)
6570
###< drop table crash_q
6573
###As far as all queries returned OK, result is YES
6574
type_extra_polygon=yes # Type polygon
6575
###< create table crash_q (q polygon)
6577
###< drop table crash_q
6580
###As far as all queries returned OK, result is YES
6581
type_extra_raw(1_arg)=no # Type raw(1 arg)
6582
###< create table crash_q (q raw(16))
6583
###> execute error:You 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
6584
###< drop table crash_q
6585
###> execute error:Unknown table 'crash_q'
6587
###As far as some queries didnt return OK, result is NO
6588
type_extra_reltime=no # Type reltime
6589
###< create table crash_q (q reltime)
6590
###> execute error:You 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
6591
###< drop table crash_q
6592
###> execute error:Unknown table 'crash_q'
6594
###As far as some queries didnt return OK, result is NO
6595
type_extra_rowid=no # Type rowid
6596
###< create table crash_q (q rowid)
6597
###> execute error:You 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
6598
###< drop table crash_q
6599
###> execute error:Unknown table 'crash_q'
6601
###As far as some queries didnt return OK, result is NO
6602
type_extra_serial=yes # Type serial
6603
###< create table crash_q (q serial)
6605
###< drop table crash_q
6608
###As far as all queries returned OK, result is YES
6609
type_extra_set(1_arg)=yes # Type set(1 arg)
6610
###< create table crash_q (q set('red'))
6612
###< drop table crash_q
6615
###As far as all queries returned OK, result is YES
6616
type_extra_smalldatetime=no # Type smalldatetime
6617
###< create table crash_q (q smalldatetime)
6618
###> execute error:You 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
6619
###< drop table crash_q
6620
###> execute error:Unknown table 'crash_q'
6622
###As far as some queries didnt return OK, result is NO
6623
type_extra_smallfloat=no # Type smallfloat
6624
###< create table crash_q (q smallfloat)
6625
###> execute error:You 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
6626
###< drop table crash_q
6627
###> execute error:Unknown table 'crash_q'
6629
###As far as some queries didnt return OK, result is NO
6630
type_extra_smallmoney=no # Type smallmoney
6631
###< create table crash_q (q smallmoney)
6632
###> execute error:You 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
6633
###< drop table crash_q
6634
###> execute error:Unknown table 'crash_q'
6636
###As far as some queries didnt return OK, result is NO
6637
type_extra_text=yes # Type text
6638
###< create table crash_q (q text)
6640
###< drop table crash_q
6643
###As far as all queries returned OK, result is YES
6644
type_extra_text(1_arg)=yes # Type text(1 arg)
6645
###< create table crash_q (q text(10))
6647
###< drop table crash_q
6650
###As far as all queries returned OK, result is YES
6651
type_extra_timespan=no # Type timespan
6652
###< create table crash_q (q timespan)
6653
###> execute error:You 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
6654
###< drop table crash_q
6655
###> execute error:Unknown table 'crash_q'
6657
###As far as some queries didnt return OK, result is NO
6658
type_extra_uint=no # Type uint
6659
###< create table crash_q (q uint)
6660
###> execute error:You 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
6661
###< drop table crash_q
6662
###> execute error:Unknown table 'crash_q'
6664
###As far as some queries didnt return OK, result is NO
6665
type_extra_varchar2(1_arg)=no # Type varchar2(1 arg)
6666
###< create table crash_q (q varchar2(257))
6667
###> execute error:You 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
6668
###< drop table crash_q
6669
###> execute error:Unknown table 'crash_q'
6671
###As far as some queries didnt return OK, result is NO
6672
type_extra_year=yes # Type year
6673
###< create table crash_q (q year)
6675
###< drop table crash_q
6678
###As far as all queries returned OK, result is YES
6679
type_odbc_bigint=yes # Type bigint
6680
###< create table crash_q (q bigint)
6682
###< drop table crash_q
6685
###As far as all queries returned OK, result is YES
6686
type_odbc_binary(1_arg)=yes # Type binary(1 arg)
6687
###< create table crash_q (q binary(1))
6689
###< drop table crash_q
6692
###As far as all queries returned OK, result is YES
6693
type_odbc_datetime=yes # Type datetime
6694
###< create table crash_q (q datetime)
6696
###< drop table crash_q
6699
###As far as all queries returned OK, result is YES
6700
type_odbc_tinyint=yes # Type tinyint
6701
###< create table crash_q (q tinyint)
6703
###< drop table crash_q
6706
###As far as all queries returned OK, result is YES
6707
type_odbc_varbinary(1_arg)=yes # Type varbinary(1 arg)
6708
###< create table crash_q (q varbinary(1))
6710
###< drop table crash_q
6713
###As far as all queries returned OK, result is YES
6714
type_sql_bit=yes # Type bit
6715
###< create table crash_q (q bit)
6717
###< drop table crash_q
6720
###As far as all queries returned OK, result is YES
6721
type_sql_bit(1_arg)=yes # Type bit(1 arg)
6722
###< create table crash_q (q bit(2))
6724
###< drop table crash_q
6727
###As far as all queries returned OK, result is YES
6728
type_sql_bit_varying(1_arg)=no # Type bit varying(1 arg)
6729
###< create table crash_q (q bit varying(2))
6730
###> execute error:You 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
6731
###< drop table crash_q
6732
###> execute error:Unknown table 'crash_q'
6734
###As far as some queries didnt return OK, result is NO
6735
type_sql_boolean=yes # Type boolean
6736
###< create table crash_q (q boolean)
6738
###< drop table crash_q
6741
###As far as all queries returned OK, result is YES
6742
type_sql_char(1_arg)=yes # Type char(1 arg)
6743
###< create table crash_q (q char(1))
6745
###< drop table crash_q
6748
###As far as all queries returned OK, result is YES
6749
type_sql_char_varying(1_arg)=yes # Type char varying(1 arg)
6750
###< create table crash_q (q char varying(1))
6752
###< drop table crash_q
6755
###As far as all queries returned OK, result is YES
6756
type_sql_character(1_arg)=yes # Type character(1 arg)
6757
###< create table crash_q (q character(1))
6759
###< drop table crash_q
6762
###As far as all queries returned OK, result is YES
6763
type_sql_character_varying(1_arg)=yes # Type character varying(1 arg)
6764
###< create table crash_q (q character varying(1))
6766
###< drop table crash_q
6769
###As far as all queries returned OK, result is YES
6770
type_sql_date=yes # Type date
6771
###< create table crash_q (q date)
6773
###< drop table crash_q
6776
###As far as all queries returned OK, result is YES
6777
type_sql_dec(2_arg)=yes # Type dec(2 arg)
6778
###< create table crash_q (q dec(6,2))
6780
###< drop table crash_q
6783
###As far as all queries returned OK, result is YES
6784
type_sql_decimal(2_arg)=yes # Type decimal(2 arg)
6785
###< create table crash_q (q decimal(6,2))
6787
###< drop table crash_q
6790
###As far as all queries returned OK, result is YES
6791
type_sql_double_precision=yes # Type double precision
6792
###< create table crash_q (q double precision)
6794
###< drop table crash_q
6797
###As far as all queries returned OK, result is YES
6798
type_sql_float=yes # Type float
6799
###< create table crash_q (q float)
6801
###< drop table crash_q
6804
###As far as all queries returned OK, result is YES
6805
type_sql_float(1_arg)=yes # Type float(1 arg)
6806
###< create table crash_q (q float(8))
6808
###< drop table crash_q
6811
###As far as all queries returned OK, result is YES
6812
type_sql_int=yes # Type int
6813
###< create table crash_q (q int)
6815
###< drop table crash_q
6818
###As far as all queries returned OK, result is YES
6819
type_sql_integer=yes # Type integer
6820
###< create table crash_q (q integer)
6822
###< drop table crash_q
6825
###As far as all queries returned OK, result is YES
6826
type_sql_interval_day=no # Type interval day
6827
###< create table crash_q (q interval day)
6828
###> execute error:You 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
6829
###< drop table crash_q
6830
###> execute error:Unknown table 'crash_q'
6832
###As far as some queries didnt return OK, result is NO
6833
type_sql_interval_day_to_hour=no # Type interval day to hour
6834
###< create table crash_q (q interval day to hour)
6835
###> execute error:You 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
6836
###< drop table crash_q
6837
###> execute error:Unknown table 'crash_q'
6839
###As far as some queries didnt return OK, result is NO
6840
type_sql_interval_day_to_minute=no # Type interval day to minute
6841
###< create table crash_q (q interval day to minute)
6842
###> execute error:You 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
6843
###< drop table crash_q
6844
###> execute error:Unknown table 'crash_q'
6846
###As far as some queries didnt return OK, result is NO
6847
type_sql_interval_day_to_second=no # Type interval day to second
6848
###< create table crash_q (q interval day to second)
6849
###> execute error:You 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
6850
###< drop table crash_q
6851
###> execute error:Unknown table 'crash_q'
6853
###As far as some queries didnt return OK, result is NO
6854
type_sql_interval_hour=no # Type interval hour
6855
###< create table crash_q (q interval hour)
6856
###> execute error:You 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
6857
###< drop table crash_q
6858
###> execute error:Unknown table 'crash_q'
6860
###As far as some queries didnt return OK, result is NO
6861
type_sql_interval_hour_to_minute=no # Type interval hour to minute
6862
###< create table crash_q (q interval hour to minute)
6863
###> execute error:You 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
6864
###< drop table crash_q
6865
###> execute error:Unknown table 'crash_q'
6867
###As far as some queries didnt return OK, result is NO
6868
type_sql_interval_hour_to_second=no # Type interval hour to second
6869
###< create table crash_q (q interval hour to second)
6870
###> execute error:You 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
6871
###< drop table crash_q
6872
###> execute error:Unknown table 'crash_q'
6874
###As far as some queries didnt return OK, result is NO
6875
type_sql_interval_minute=no # Type interval minute
6876
###< create table crash_q (q interval minute)
6877
###> execute error:You 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
6878
###< drop table crash_q
6879
###> execute error:Unknown table 'crash_q'
6881
###As far as some queries didnt return OK, result is NO
6882
type_sql_interval_minute_to_second=no # Type interval minute to second
6883
###< create table crash_q (q interval minute to second)
6884
###> execute error:You 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
6885
###< drop table crash_q
6886
###> execute error:Unknown table 'crash_q'
6888
###As far as some queries didnt return OK, result is NO
6889
type_sql_interval_month=no # Type interval month
6890
###< create table crash_q (q interval month)
6891
###> execute error:You 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
6892
###< drop table crash_q
6893
###> execute error:Unknown table 'crash_q'
6895
###As far as some queries didnt return OK, result is NO
6896
type_sql_interval_second=no # Type interval second
6897
###< create table crash_q (q interval second)
6898
###> execute error:You 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
6899
###< drop table crash_q
6900
###> execute error:Unknown table 'crash_q'
6902
###As far as some queries didnt return OK, result is NO
6903
type_sql_interval_year=no # Type interval year
6904
###< create table crash_q (q interval year)
6905
###> execute error:You 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
6906
###< drop table crash_q
6907
###> execute error:Unknown table 'crash_q'
6909
###As far as some queries didnt return OK, result is NO
6910
type_sql_interval_year_to_month=no # Type interval year to month
6911
###< create table crash_q (q interval year to month)
6912
###> execute error:You 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
6913
###< drop table crash_q
6914
###> execute error:Unknown table 'crash_q'
6916
###As far as some queries didnt return OK, result is NO
6917
type_sql_national_char_varying(1_arg)=yes # Type national char varying(1 arg)
6918
###< create table crash_q (q national char varying(20))
6920
###< drop table crash_q
6923
###As far as all queries returned OK, result is YES
6924
type_sql_national_character(1_arg)=yes # Type national character(1 arg)
6925
###< create table crash_q (q national character(20))
6927
###< drop table crash_q
6930
###As far as all queries returned OK, result is YES
6931
type_sql_national_character_varying(1_arg)=yes # Type national character varying(1 arg)
6932
###< create table crash_q (q national character varying(20))
6934
###< drop table crash_q
6937
###As far as all queries returned OK, result is YES
6938
type_sql_nchar(1_arg)=yes # Type nchar(1 arg)
6939
###< create table crash_q (q nchar(1))
6941
###< drop table crash_q
6944
###As far as all queries returned OK, result is YES
6945
type_sql_nchar_varying(1_arg)=yes # Type nchar varying(1 arg)
6946
###< create table crash_q (q nchar varying(20))
6948
###< drop table crash_q
6951
###As far as all queries returned OK, result is YES
6952
type_sql_numeric(2_arg)=yes # Type numeric(2 arg)
6953
###< create table crash_q (q numeric(9,2))
6955
###< drop table crash_q
6958
###As far as all queries returned OK, result is YES
6959
type_sql_real=yes # Type real
6960
###< create table crash_q (q real)
6962
###< drop table crash_q
6965
###As far as all queries returned OK, result is YES
6966
type_sql_smallint=yes # Type smallint
6967
###< create table crash_q (q smallint)
6969
###< drop table crash_q
6972
###As far as all queries returned OK, result is YES
6973
type_sql_time=yes # Type time
6974
###< create table crash_q (q time)
6976
###< drop table crash_q
6979
###As far as all queries returned OK, result is YES
6980
type_sql_timestamp=yes # Type timestamp
6981
###< create table crash_q (q timestamp)
6983
###< drop table crash_q
6986
###As far as all queries returned OK, result is YES
6987
type_sql_timestamp_with_time_zone=no # Type timestamp with time zone
6988
###< create table crash_q (q timestamp with time zone)
6989
###> execute error:You 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
6990
###< drop table crash_q
6991
###> execute error:Unknown table 'crash_q'
6993
###As far as some queries didnt return OK, result is NO
6994
type_sql_varchar(1_arg)=yes # Type varchar(1 arg)
6995
###< create table crash_q (q varchar(1))
6997
###< drop table crash_q
7000
###As far as all queries returned OK, result is YES
7002
###< select * from crash_me union select a,b from crash_me3
7005
###As far as all queries returned OK, result is YES
7006
union_all=yes # union all
7007
###< select * from crash_me union all select a,b from crash_me3
7010
###As far as all queries returned OK, result is YES
7011
union_all_incompat=yes # union all (incompatible lists)
7012
###< select * from crash_me union all select a,b from crash_me2
7015
###As far as all queries returned OK, result is YES
7016
union_incompat=yes # union (incompatible lists)
7017
###< select * from crash_me union select a,b from crash_me2
7020
###As far as all queries returned OK, result is YES
7021
unique_in_create=yes # unique in create table
7022
###< create table crash_q (q integer not null,unique (q))
7024
###< drop table crash_q
7027
###As far as all queries returned OK, result is YES
7028
unique_null_in_create=yes # unique null in create
7029
###< create table crash_q (q integer,unique (q))
7031
###< insert into crash_q (q) values (NULL)
7033
###< insert into crash_q (q) values (NULL)
7035
###< insert into crash_q (q) values (1)
7037
###< drop table crash_q
7040
###As far as all queries returned OK, result is YES
7041
value_of_false=0 # Value of FALSE
7044
value_of_true=1 # Value of TRUE
7048
###< create view crash_q as select a from crash_me
7049
###> execute error:You 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
7050
###< drop view crash_q
7051
###> execute error:You 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
7053
###As far as some queries didnt return OK, result is NO
7054
where_string_size=1048539 # constant string size in where
7055
###We are trying (example with N=5):
7056
###select a from crash_me where b >='11111'
added
removed
sql-bench/limits/mysql-4.1.cfg
