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'