1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
|
#This file is automaticly generated by crash-me 1.61
NEG=yes # update of column= -column
Need_cast_for_null=no # Need to cast NULL for arithmetic
alter_add_col=yes # Alter table add column
alter_add_constraint=yes # Alter table add constraint
alter_add_foreign_key=yes # Alter table add foreign key
alter_add_multi_col=yes # Alter table add many columns
alter_add_primary_key=with constraint # Alter table add primary key
alter_add_unique=yes # Alter table add unique
alter_alter_col=yes # Alter table alter column default
alter_change_col=yes # Alter table change column
alter_drop_col=yes # Alter table drop column
alter_drop_constraint=no # Alter table drop constraint
alter_drop_foreign_key=with drop foreign key # Alter table drop foreign key
alter_drop_primary_key=drop primary key # Alter table drop primary key
alter_drop_unique=with drop key # Alter table drop unique
alter_modify_col=yes # Alter table modify column
alter_rename_table=yes # Alter table rename table
atomic_updates=no # atomic updates
automatic_rowid=_rowid # Automatic row id
binary_numbers=yes # binary numbers (0b1001)
binary_strings=yes # binary strings (b'0110')
case_insensitive_strings=yes # Case insensitive compare
char_is_space_filled=no # char are space filled
column_alias=yes # Column alias
columns_in_group_by=+64 # number of columns in group by
columns_in_order_by=+64 # number of columns in order by
comment_#=yes # # as comment
comment_--=yes # -- as comment (ANSI)
comment_/**/=yes # /* */ as comment
comment_//=no # // as comment
compute=no # Compute
connections=101 # Simultaneous connections (installation default)
constraint_check=syntax only # Column constraints
constraint_check_named=syntax only # Named constraints
constraint_check_table=syntax only # Table constraints
constraint_null=yes # NULL constraint (SyBase style)
crash_me_safe=yes # crash me safe
crash_me_version=1.61 # crash me version
create_default=yes # default value for column
create_default_func=no # default value function for column
create_if_not_exists=yes # create table if not exists
create_index=yes # create index
create_schema=no # Create SCHEMA
create_table_select=yes # create table from select
cross_join=yes # cross join (same as from a,b)
date_as_string=yes # String functions on date columns
date_format_EUR=error # Supports DD.MM.YYYY (EUR) format
date_format_EUR_with_date=error # Supports DATE 'DD.MM.YYYY' (EUR) format
date_format_ISO=yes # Supports YYYY-MM-DD (ISO) format
date_format_ISO_with_date=yes # Supports DATE 'YYYY-MM-DD' (ISO) format
date_format_USA=error # Supports MM/DD/YYYY format
date_format_USA_with_date=error # Supports DATE 'MM/DD/YYYY' format
date_format_YYYYMMDD=yes # Supports YYYYMMDD format
date_format_YYYYMMDD_with_date=yes # Supports DATE 'YYYYMMDD' format
date_format_inresult=iso # Date format in result
date_infinity=error # Supports 'infinity dates
date_last=yes # Supports 9999-12-31 dates
date_one=yes # Supports 0001-01-01 dates
date_with_YY=yes # Supports YY-MM-DD 2000 compilant dates
date_zero=yes # Supports 0000-00-00 dates
domains=no # Domains (ANSI SQL)
dont_require_cast_to_float=yes # No need to cast from integer to float
double_quotes=yes # Double '' as ' in strings
drop_if_exists=yes # drop table if exists
drop_index=with 'ON' # drop index
drop_requires_cascade=no # drop table require cascade/restrict
drop_restrict=yes # drop table with cascade/restrict
end_colon=yes # allows end ';'
except=no # except
except_all=no # except all
except_all_incompat=no # except all (incompatible lists)
except_incompat=no # except (incompatible lists)
field_name_case=yes # case independent field names
float_int_expr=yes # mixing of integer and float in expression
foreign_key=syntax only # foreign keys
full_outer_join=no # full outer join
func_extra_!=yes # Function NOT as '!' in SELECT
func_extra_%=yes # Function MOD as %
func_extra_&=yes # Function & (bitwise and)
func_extra_&&=yes # Function AND as '&&'
func_extra_<>=yes # Function <> in SELECT
func_extra_==yes # Function =
func_extra_add_months=no # Function ADD_MONTHS
func_extra_adddate=yes # Function ADDDATE
func_extra_addtime=yes # Function ADDTIME
func_extra_alpha=no # Function ALPHA
func_extra_and_or=yes # Function AND and OR in SELECT
func_extra_ascii_char=no # Function ASCII_CHAR
func_extra_ascii_code=no # Function ASCII_CODE
func_extra_ascii_string=error # Function ASCII in string cast
func_extra_atn2=no # Function ATN2
func_extra_auto_num2string=yes # Function automatic num->string convert
func_extra_auto_string2num=yes # Function automatic string->num convert
func_extra_between=yes # Function BETWEEN in SELECT
func_extra_binary_shifts=yes # Function << and >> (bitwise shifts)
func_extra_bit_count=yes # Function BIT_COUNT
func_extra_ceil=yes # Function CEIL
func_extra_char_date=no # Function CHAR (conversation date)
func_extra_charindex=no # Function CHARINDEX
func_extra_chr=no # Function CHR
func_extra_chr_str=no # Function CHR (any type to string)
func_extra_concat_as_+=error # Function concatenation with +
func_extra_concat_list=yes # Function CONCAT(list)
func_extra_convert=no # Function CONVERT
func_extra_cosh=no # Function COSH
func_extra_date=yes # Function DATE
func_extra_date_format=yes # Function DATE_FORMAT
func_extra_dateadd=no # Function DATEADD
func_extra_datediff=no # Function DATEDIFF
func_extra_datediff2arg=yes # Function DATEDIFF (2 arg)
func_extra_datename=no # Function DATENAME
func_extra_datepart=no # Function DATEPART
func_extra_day=yes # Function DAY
func_extra_decode=no # Function DECODE
func_extra_ebcdic_string=no # Function EBCDIC in string cast
func_extra_elt=yes # Function ELT
func_extra_encrypt=yes # Function ENCRYPT
func_extra_expand2arg=no # Function EXPAND
func_extra_field=yes # Function FIELD
func_extra_fixed=no # Function FIXED
func_extra_float=no # Function FLOAT
func_extra_format=yes # Function FORMAT
func_extra_from_days=yes # Function FROM_DAYS
func_extra_from_unixtime=yes # Function FROM_UNIXTIME
func_extra_getdate=no # Function GETDATE
func_extra_greatest=yes # Function GREATEST
func_extra_hex=yes # Function HEX
func_extra_if=yes # Function IF
func_extra_in_num=yes # Function IN on numbers in SELECT
func_extra_in_str=yes # Function IN on strings in SELECT
func_extra_index=no # Function INDEX
func_extra_initcap=no # Function INITCAP
func_extra_instr=yes # Function LOCATE as INSTR
func_extra_instr_oracle=no # Function INSTR (Oracle syntax)
func_extra_instrb=no # Function INSTRB
func_extra_interval=yes # Function INTERVAL
func_extra_last_day=yes # Function LAST_DAY
func_extra_last_insert_id=yes # Function LAST_INSERT_ID
func_extra_least=yes # Function LEAST
func_extra_length=error # Function LENGTH
func_extra_lengthb=no # Function LENGTHB
func_extra_lfill3arg=no # Function LFILL (3 arg)
func_extra_like=yes # Function LIKE in SELECT
func_extra_like_escape=yes # Function LIKE ESCAPE in SELECT
func_extra_ln=yes # Function LN
func_extra_log(m_n)=yes # Function LOG(m,n)
func_extra_logn=no # Function LOGN
func_extra_lpad=yes # Function LPAD
func_extra_ltrim2arg=no # Function LTRIM (2 arg)
func_extra_makedate=yes # Function MAKEDATE
func_extra_maketime=yes # Function MAKETIME
func_extra_mapchar=no # Function MAPCHAR
func_extra_mdy=no # Function MDY
func_extra_microsecond=yes # Function MICROSECOND
func_extra_mid=yes # Function SUBSTRING as MID
func_extra_months_between=no # Function MONTHS_BETWEEN
func_extra_noround=no # Function NOROUND
func_extra_not=yes # Function NOT in SELECT
func_extra_not_between=yes # Function NOT BETWEEN in SELECT
func_extra_not_like=yes # Function NOT LIKE in SELECT
func_extra_num=no # Function NUM
func_extra_odbc_convert=no # Function ODBC CONVERT
func_extra_password=yes # Function PASSWORD
func_extra_paste=no # Function PASTE
func_extra_patindex=no # Function PATINDEX
func_extra_period_add=yes # Function PERIOD_ADD
func_extra_period_diff=yes # Function PERIOD_DIFF
func_extra_pow=yes # Function POW
func_extra_range=no # Function RANGE
func_extra_regexp=yes # Function REGEXP in SELECT
func_extra_replace2arg=no # Function REPLACE (2 arg)
func_extra_replicate=no # Function REPLICATE
func_extra_reverse=yes # Function REVERSE
func_extra_rfill3arg=no # Function RFILL (3 arg)
func_extra_root=no # Function ROOT
func_extra_round1=yes # Function ROUND(1 arg)
func_extra_rpad=yes # Function RPAD
func_extra_rpad4arg=no # Function RPAD (4 arg)
func_extra_rtrim2arg=no # Function RTRIM (2 arg)
func_extra_sec_to_time=yes # Function SEC_TO_TIME
func_extra_sinh=no # Function SINH
func_extra_str=no # Function STR
func_extra_strcmp=yes # Function STRCMP
func_extra_stuff=no # Function STUFF
func_extra_subdate=yes # Function SUBDATE
func_extra_substr2arg=yes # Function SUBSTR (2 arg)
func_extra_substr3arg=yes # Function SUBSTR (3 arg)
func_extra_substrb=no # Function SUBSTRB
func_extra_substring_index=yes # Function SUBSTRING_INDEX
func_extra_subtime=yes # Function SUBTIME
func_extra_sysdate=yes # Function SYSDATE
func_extra_tail=no # Function TAIL
func_extra_tanh=no # Function TANH
func_extra_time=yes # Function TIME
func_extra_time_to_sec=yes # Function TIME_TO_SEC
func_extra_timediff=yes # Function TIMEDIFF
func_extra_timestamp=error # Function TIMESTAMP
func_extra_to_days=yes # Function TO_DAYS
func_extra_translate=no # Function TRANSLATE
func_extra_trim1arg=yes # Function TRIM (1 arg)
func_extra_trim2arg=no # Function TRIM (2 arg)
func_extra_trim_many_char=error # Function TRIM; Many char extension
func_extra_trim_substring=yes # Function TRIM; Substring extension
func_extra_trunc=no # Function TRUNC
func_extra_trunc1arg=no # Function TRUNC (1 arg)
func_extra_uid=no # Function UID
func_extra_unix_timestamp=yes # Function UNIX_TIMESTAMP
func_extra_userenv=no # Function USERENV
func_extra_value=no # Function VALUE
func_extra_version=yes # Function VERSION
func_extra_weekday=yes # Function WEEKDAY
func_extra_weekofyear=yes # Function WEEKOFYEAR
func_extra_|=yes # Function | (bitwise or)
func_extra_||=yes # Function OR as '||'
func_extra_~*=no # Function ~* (case insensitive compare)
func_odbc_abs=yes # Function ABS
func_odbc_acos=yes # Function ACOS
func_odbc_ascii=yes # Function ASCII
func_odbc_asin=yes # Function ASIN
func_odbc_atan=yes # Function ATAN
func_odbc_atan2=yes # Function ATAN2
func_odbc_ceiling=yes # Function CEILING
func_odbc_char=yes # Function CHAR
func_odbc_concat=yes # Function CONCAT(2 arg)
func_odbc_cos=yes # Function COS
func_odbc_cot=yes # Function COT
func_odbc_curdate=yes # Function CURDATE
func_odbc_curtime=yes # Function CURTIME
func_odbc_database=yes # Function DATABASE
func_odbc_dayname=yes # Function DAYNAME
func_odbc_dayofmonth=yes # Function DAYOFMONTH
func_odbc_dayofweek=yes # Function DAYOFWEEK
func_odbc_dayofyear=yes # Function DAYOFYEAR
func_odbc_degrees=yes # Function DEGREES
func_odbc_difference=no # Function DIFFERENCE()
func_odbc_exp=yes # Function EXP
func_odbc_floor=yes # Function FLOOR
func_odbc_fn_left=yes # Function ODBC syntax LEFT & RIGHT
func_odbc_hour=yes # Function HOUR
func_odbc_hour_time=yes # Function ANSI HOUR
func_odbc_ifnull=yes # Function IFNULL
func_odbc_insert=yes # Function INSERT
func_odbc_lcase=yes # Function LCASE
func_odbc_left=yes # Function LEFT
func_odbc_length=yes # Function REAL LENGTH
func_odbc_length_without_space=error # Function ODBC LENGTH
func_odbc_locate_2=yes # Function LOCATE(2 arg)
func_odbc_locate_3=yes # Function LOCATE(3 arg)
func_odbc_log=yes # Function LOG
func_odbc_log10=yes # Function LOG10
func_odbc_ltrim=yes # Function LTRIM
func_odbc_minute=yes # Function MINUTE
func_odbc_mod=yes # Function MOD
func_odbc_month=yes # Function MONTH
func_odbc_monthname=yes # Function MONTHNAME
func_odbc_now=yes # Function NOW
func_odbc_pi=yes # Function PI
func_odbc_power=yes # Function POWER
func_odbc_quarter=yes # Function QUARTER
func_odbc_radians=yes # Function RADIANS
func_odbc_rand=yes # Function RAND
func_odbc_repeat=yes # Function REPEAT
func_odbc_replace=yes # Function REPLACE
func_odbc_right=yes # Function RIGHT
func_odbc_round=yes # Function ROUND(2 arg)
func_odbc_rtrim=yes # Function RTRIM
func_odbc_second=yes # Function SECOND
func_odbc_sign=yes # Function SIGN
func_odbc_sin=yes # Function SIN
func_odbc_soundex=yes # Function SOUNDEX
func_odbc_space=yes # Function SPACE
func_odbc_sqrt=yes # Function SQRT
func_odbc_substring=yes # Function ODBC SUBSTRING
func_odbc_tan=yes # Function TAN
func_odbc_timestampadd=yes # Function TIMESTAMPADD
func_odbc_timestampdiff=error # Function TIMESTAMPDIFF
func_odbc_truncate=yes # Function TRUNCATE
func_odbc_ucase=yes # Function UCASE
func_odbc_user()=yes # Function USER()
func_odbc_week=USA # WEEK
func_odbc_year=yes # Function YEAR
func_sql_+=yes # Function +, -, * and /
func_sql_bit_length=yes # Function BIT_LENGTH
func_sql_cast=yes # Function CAST
func_sql_char_length=error # Function CHAR_LENGTH
func_sql_char_length(constant)=yes # Function CHAR_LENGTH(constant)
func_sql_character_length=yes # Function CHARACTER_LENGTH
func_sql_coalesce=yes # Function COALESCE
func_sql_concat_as_||=error # Function concatenation with ||
func_sql_current_date=yes # Function CURRENT_DATE
func_sql_current_time=yes # Function CURRENT_TIME
func_sql_current_timestamp=yes # Function CURRENT_TIMESTAMP
func_sql_current_user=yes # CURRENT_USER
func_sql_extract_sql=yes # Function EXTRACT
func_sql_localtime=yes # Function LOCALTIME
func_sql_localtimestamp=yes # Function LOCALTIMESTAMP
func_sql_lower=yes # Function LOWER
func_sql_nullif_num=yes # Function NULLIF with numbers
func_sql_nullif_string=yes # Function NULLIF with strings
func_sql_octet_length=yes # Function OCTET_LENGTH
func_sql_position=yes # Function POSITION
func_sql_searched_case=yes # Function searched CASE
func_sql_session_user=with_parenthesis # SESSION_USER
func_sql_simple_case=yes # Function simple CASE
func_sql_substring=yes # Function ANSI SQL SUBSTRING
func_sql_system_user=with_parenthesis # SYSTEM_USER
func_sql_trim=yes # Function TRIM
func_sql_upper=yes # Function UPPER
func_sql_user=with_parenthesis # USER
func_where_between=yes # Function BETWEEN
func_where_eq_all=yes # Function = ALL
func_where_eq_any=yes # Function = ANY
func_where_eq_some=yes # Function = SOME
func_where_exists=yes # Function EXISTS
func_where_in_num=yes # Function IN on numbers
func_where_like=yes # Function LIKE
func_where_like_escape=yes # Function LIKE ESCAPE
func_where_match=no # Function MATCH
func_where_match_unique=no # Function MATCH UNIQUE
func_where_matches=no # Function MATCHES
func_where_not_between=yes # Function NOT BETWEEN
func_where_not_exists=yes # Function NOT EXISTS
func_where_not_like=yes # Function NOT LIKE
func_where_not_unique=no # Function NOT UNIQUE
func_where_unique=no # Function UNIQUE
functions=yes # Functions
group_by=yes # Group by
group_by_alias=yes # Group by alias
group_by_null=yes # Group on column with null values
group_by_position=yes # Group by position
group_distinct_functions=yes # Group functions with distinct
group_func_extra_bit_and=yes # Group function BIT_AND
group_func_extra_bit_or=yes # Group function BIT_OR
group_func_extra_count_distinct_list=yes # Group function COUNT(DISTINCT expr,expr,...)
group_func_extra_std=yes # Group function STD
group_func_extra_stddev=yes # Group function STDDEV
group_func_extra_variance=yes # Group function VARIANCE
group_func_sql_any=no # Group function ANY
group_func_sql_avg=yes # Group function AVG
group_func_sql_count_*=yes # Group function COUNT (*)
group_func_sql_count_column=yes # Group function COUNT column name
group_func_sql_count_distinct=yes # Group function COUNT(DISTINCT expr)
group_func_sql_every=no # Group function EVERY
group_func_sql_max=yes # Group function MAX on numbers
group_func_sql_max_str=yes # Group function MAX on strings
group_func_sql_min=yes # Group function MIN on numbers
group_func_sql_min_str=yes # Group function MIN on strings
group_func_sql_some=no # Group function SOME
group_func_sql_sum=yes # Group function SUM
group_functions=yes # Group functions
group_many_distinct_functions=yes # Group functions with several distinct
group_on_unused=yes # Group on unused column
has_true_false=yes # TRUE and FALSE
having=yes # Having
having_with_alias=yes # Having on alias
having_with_group=yes # Having with group function
hex_numbers=yes # hex numbers (0x41)
hex_strings=yes # hex strings (x'1ace')
ignore_end_space=yes # Ignore end space in compare
index_in_create=yes # index in create table
index_namespace=yes # different namespace for index
index_parts=yes # index on column part (extension)
inner_join=yes # inner join
insert_default_values=no # INSERT DEFAULT VALUES
insert_empty_string=yes # insert empty string
insert_multi_value=yes # INSERT with Value lists
insert_select=yes # insert INTO ... SELECT ...
insert_with_default=yes # INSERT with DEFAULT
insert_with_empty_value_list=no # INSERT with empty value list
insert_with_set=yes # INSERT with set syntax
intersect=no # intersect
intersect_all=no # intersect all
intersect_all_incompat=no # intersect all (incompatible lists)
intersect_incompat=no # intersect (incompatible lists)
join_tables=61 # tables in join
left_outer_join=yes # left outer join
left_outer_join_using=yes # left outer join using
length_of_varchar_field=actual length # CHARACTER_LENGTH(varchar_field)
like_with_column=yes # column LIKE column
like_with_number=yes # LIKE on numbers
lock_tables=yes # lock table
logical_value=1 # Value of logical operation (1=1)
max_big_expressions=10 # big expressions
max_char_size=255 # max char() size
max_column_name=64 # column name length
max_columns=2599 # Columns in table
max_conditions=85660 # OR and AND in WHERE
max_expressions=580 # simple expressions
max_index=+64 # max index
max_index_length=1000 # index length
max_index_name=64 # index name length
max_index_part_length=255 # max index part length
max_index_parts=16 # index parts
max_index_varchar_part_length=1000 # index varchar part length
max_row_length=65534 # max table row length (without blobs)
max_row_length_with_null=65502 # table row length with nulls (without blobs)
max_select_alias_name=+512 # select alias name length
max_stack_expression=580 # stacked expressions
max_table_alias_name=+512 # table alias name length
max_table_name=64 # table name length
max_text_size=1048543 # max text or blob size
max_unique_index=+64 # unique indexes
max_varchar_size=1048543 # max varchar() size
minus=no # minus
minus_incompat=no # minus (incompatible lists)
minus_neg=yes # Calculate 1--1
multi_drop=yes # many tables to drop table
multi_null_in_unique=yes # null in unique index
multi_strings=yes # Multiple line strings
multi_table_delete=yes # DELETE FROM table1,table2...
multi_table_update=yes # Update with many tables
natural_join=yes # natural join
natural_join_incompat=yes # natural join (incompatible lists)
natural_left_outer_join=yes # natural left outer join
no_primary_key=yes # Tables without primary key
not_id_between=yes # NOT ID BETWEEN interprets as ID NOT BETWEEN
null_concat_expr=yes # Is concat('a',NULL) = NULL
null_in_index=yes # null in index
null_in_unique=yes # null in unique index
null_num_expr=yes # Is 1+NULL = NULL
nulls_in_unique=yes # null combination in unique index
odbc_left_outer_join=yes # left outer join odbc style
operating_system=Linux 2.6.8-my i686 # crash-me tested on
order_by=yes # Order by
order_by_alias=yes # Order by alias
order_by_function=yes # Order by function
order_by_position=yes # Order by position
order_on_unused=yes # Order by on unused column
position_of_null=first # Where is null values in sorted recordset
position_of_null_desc=last # Where is null values in sorted recordset (DESC)
primary_key_in_create=yes # primary key in create table
psm_functions=no # PSM functions (ANSI SQL)
psm_modules=no # PSM modules (ANSI SQL)
psm_procedures=no # PSM procedures (ANSI SQL)
psm_trigger=no # Triggers (ANSI SQL)
query_size=1048574 # query size
quote_ident_with_"=error # " as identifier quote (ANSI SQL)
quote_ident_with_[=no # [] as identifier quote
quote_ident_with_`=yes # ` as identifier quote
quote_ident_with_dbl_"=no # Double "" in identifiers as "
quote_with_"=yes # Allows ' and " as string markers
recursive_subqueries=+64 # recursive subqueries
remember_end_space=no # Remembers end space in char()
remember_end_space_varchar=yes # Remembers end space in varchar()
rename_table=yes # rename table
repeat_string_size=1048576 # return string size from function
reserved_word_ansi-92/99_absolute=no # Keyword ABSOLUTE
reserved_word_ansi-92/99_action=no # Keyword ACTION
reserved_word_ansi-92/99_add=yes # Keyword ADD
reserved_word_ansi-92/99_after=no # Keyword AFTER
reserved_word_ansi-92/99_alias=no # Keyword ALIAS
reserved_word_ansi-92/99_all=yes # Keyword ALL
reserved_word_ansi-92/99_allocate=no # Keyword ALLOCATE
reserved_word_ansi-92/99_alter=yes # Keyword ALTER
reserved_word_ansi-92/99_and=yes # Keyword AND
reserved_word_ansi-92/99_any=no # Keyword ANY
reserved_word_ansi-92/99_are=no # Keyword ARE
reserved_word_ansi-92/99_as=yes # Keyword AS
reserved_word_ansi-92/99_asc=yes # Keyword ASC
reserved_word_ansi-92/99_assertion=no # Keyword ASSERTION
reserved_word_ansi-92/99_at=no # Keyword AT
reserved_word_ansi-92/99_authorization=no # Keyword AUTHORIZATION
reserved_word_ansi-92/99_before=yes # Keyword BEFORE
reserved_word_ansi-92/99_begin=no # Keyword BEGIN
reserved_word_ansi-92/99_bit=no # Keyword BIT
reserved_word_ansi-92/99_boolean=no # Keyword BOOLEAN
reserved_word_ansi-92/99_both=yes # Keyword BOTH
reserved_word_ansi-92/99_breadth=no # Keyword BREADTH
reserved_word_ansi-92/99_by=yes # Keyword BY
reserved_word_ansi-92/99_call=yes # Keyword CALL
reserved_word_ansi-92/99_cascade=yes # Keyword CASCADE
reserved_word_ansi-92/99_cascaded=no # Keyword CASCADED
reserved_word_ansi-92/99_case=yes # Keyword CASE
reserved_word_ansi-92/99_cast=no # Keyword CAST
reserved_word_ansi-92/99_catalog=no # Keyword CATALOG
reserved_word_ansi-92/99_char=yes # Keyword CHAR
reserved_word_ansi-92/99_character=yes # Keyword CHARACTER
reserved_word_ansi-92/99_check=yes # Keyword CHECK
reserved_word_ansi-92/99_close=no # Keyword CLOSE
reserved_word_ansi-92/99_collate=yes # Keyword COLLATE
reserved_word_ansi-92/99_collation=no # Keyword COLLATION
reserved_word_ansi-92/99_column=yes # Keyword COLUMN
reserved_word_ansi-92/99_commit=no # Keyword COMMIT
reserved_word_ansi-92/99_completion=no # Keyword COMPLETION
reserved_word_ansi-92/99_connect=no # Keyword CONNECT
reserved_word_ansi-92/99_connection=yes # Keyword CONNECTION
reserved_word_ansi-92/99_constraint=yes # Keyword CONSTRAINT
reserved_word_ansi-92/99_constraints=no # Keyword CONSTRAINTS
reserved_word_ansi-92/99_continue=yes # Keyword CONTINUE
reserved_word_ansi-92/99_corresponding=no # Keyword CORRESPONDING
reserved_word_ansi-92/99_create=yes # Keyword CREATE
reserved_word_ansi-92/99_cross=yes # Keyword CROSS
reserved_word_ansi-92/99_current=no # Keyword CURRENT
reserved_word_ansi-92/99_current_date=yes # Keyword CURRENT_DATE
reserved_word_ansi-92/99_current_time=yes # Keyword CURRENT_TIME
reserved_word_ansi-92/99_current_timestamp=yes # Keyword CURRENT_TIMESTAMP
reserved_word_ansi-92/99_current_user=yes # Keyword CURRENT_USER
reserved_word_ansi-92/99_cursor=yes # Keyword CURSOR
reserved_word_ansi-92/99_cycle=no # Keyword CYCLE
reserved_word_ansi-92/99_data=no # Keyword DATA
reserved_word_ansi-92/99_date=no # Keyword DATE
reserved_word_ansi-92/99_day=no # Keyword DAY
reserved_word_ansi-92/99_deallocate=no # Keyword DEALLOCATE
reserved_word_ansi-92/99_dec=yes # Keyword DEC
reserved_word_ansi-92/99_decimal=yes # Keyword DECIMAL
reserved_word_ansi-92/99_declare=yes # Keyword DECLARE
reserved_word_ansi-92/99_default=yes # Keyword DEFAULT
reserved_word_ansi-92/99_deferrable=no # Keyword DEFERRABLE
reserved_word_ansi-92/99_deferred=no # Keyword DEFERRED
reserved_word_ansi-92/99_delete=yes # Keyword DELETE
reserved_word_ansi-92/99_depth=no # Keyword DEPTH
reserved_word_ansi-92/99_desc=yes # Keyword DESC
reserved_word_ansi-92/99_describe=yes # Keyword DESCRIBE
reserved_word_ansi-92/99_descriptor=no # Keyword DESCRIPTOR
reserved_word_ansi-92/99_diagnostics=no # Keyword DIAGNOSTICS
reserved_word_ansi-92/99_dictionary=no # Keyword DICTIONARY
reserved_word_ansi-92/99_disconnect=no # Keyword DISCONNECT
reserved_word_ansi-92/99_distinct=yes # Keyword DISTINCT
reserved_word_ansi-92/99_domain=no # Keyword DOMAIN
reserved_word_ansi-92/99_double=yes # Keyword DOUBLE
reserved_word_ansi-92/99_drop=yes # Keyword DROP
reserved_word_ansi-92/99_each=yes # Keyword EACH
reserved_word_ansi-92/99_else=yes # Keyword ELSE
reserved_word_ansi-92/99_elseif=yes # Keyword ELSEIF
reserved_word_ansi-92/99_end=no # Keyword END
reserved_word_ansi-92/99_end-exec=yes # Keyword END-EXEC
reserved_word_ansi-92/99_equals=no # Keyword EQUALS
reserved_word_ansi-92/99_escape=no # Keyword ESCAPE
reserved_word_ansi-92/99_except=no # Keyword EXCEPT
reserved_word_ansi-92/99_exception=no # Keyword EXCEPTION
reserved_word_ansi-92/99_exec=no # Keyword EXEC
reserved_word_ansi-92/99_execute=no # Keyword EXECUTE
reserved_word_ansi-92/99_external=no # Keyword EXTERNAL
reserved_word_ansi-92/99_false=yes # Keyword FALSE
reserved_word_ansi-92/99_fetch=yes # Keyword FETCH
reserved_word_ansi-92/99_first=no # Keyword FIRST
reserved_word_ansi-92/99_float=yes # Keyword FLOAT
reserved_word_ansi-92/99_for=yes # Keyword FOR
reserved_word_ansi-92/99_foreign=yes # Keyword FOREIGN
reserved_word_ansi-92/99_found=no # Keyword FOUND
reserved_word_ansi-92/99_from=yes # Keyword FROM
reserved_word_ansi-92/99_full=no # Keyword FULL
reserved_word_ansi-92/99_general=no # Keyword GENERAL
reserved_word_ansi-92/99_get=no # Keyword GET
reserved_word_ansi-92/99_global=no # Keyword GLOBAL
reserved_word_ansi-92/99_go=no # Keyword GO
reserved_word_ansi-92/99_goto=yes # Keyword GOTO
reserved_word_ansi-92/99_grant=yes # Keyword GRANT
reserved_word_ansi-92/99_group=yes # Keyword GROUP
reserved_word_ansi-92/99_having=yes # Keyword HAVING
reserved_word_ansi-92/99_hour=no # Keyword HOUR
reserved_word_ansi-92/99_identity=no # Keyword IDENTITY
reserved_word_ansi-92/99_if=yes # Keyword IF
reserved_word_ansi-92/99_ignore=yes # Keyword IGNORE
reserved_word_ansi-92/99_immediate=no # Keyword IMMEDIATE
reserved_word_ansi-92/99_in=yes # Keyword IN
reserved_word_ansi-92/99_indicator=no # Keyword INDICATOR
reserved_word_ansi-92/99_initially=no # Keyword INITIALLY
reserved_word_ansi-92/99_inner=yes # Keyword INNER
reserved_word_ansi-92/99_input=no # Keyword INPUT
reserved_word_ansi-92/99_insert=yes # Keyword INSERT
reserved_word_ansi-92/99_int=yes # Keyword INT
reserved_word_ansi-92/99_integer=yes # Keyword INTEGER
reserved_word_ansi-92/99_intersect=no # Keyword INTERSECT
reserved_word_ansi-92/99_interval=yes # Keyword INTERVAL
reserved_word_ansi-92/99_into=yes # Keyword INTO
reserved_word_ansi-92/99_is=yes # Keyword IS
reserved_word_ansi-92/99_isolation=no # Keyword ISOLATION
reserved_word_ansi-92/99_join=yes # Keyword JOIN
reserved_word_ansi-92/99_key=yes # Keyword KEY
reserved_word_ansi-92/99_language=no # Keyword LANGUAGE
reserved_word_ansi-92/99_last=no # Keyword LAST
reserved_word_ansi-92/99_leading=yes # Keyword LEADING
reserved_word_ansi-92/99_leave=yes # Keyword LEAVE
reserved_word_ansi-92/99_left=yes # Keyword LEFT
reserved_word_ansi-92/99_less=no # Keyword LESS
reserved_word_ansi-92/99_level=no # Keyword LEVEL
reserved_word_ansi-92/99_like=yes # Keyword LIKE
reserved_word_ansi-92/99_limit=yes # Keyword LIMIT
reserved_word_ansi-92/99_local=no # Keyword LOCAL
reserved_word_ansi-92/99_loop=yes # Keyword LOOP
reserved_word_ansi-92/99_match=yes # Keyword MATCH
reserved_word_ansi-92/99_minute=no # Keyword MINUTE
reserved_word_ansi-92/99_modify=no # Keyword MODIFY
reserved_word_ansi-92/99_module=no # Keyword MODULE
reserved_word_ansi-92/99_month=no # Keyword MONTH
reserved_word_ansi-92/99_names=no # Keyword NAMES
reserved_word_ansi-92/99_national=no # Keyword NATIONAL
reserved_word_ansi-92/99_natural=yes # Keyword NATURAL
reserved_word_ansi-92/99_nchar=no # Keyword NCHAR
reserved_word_ansi-92/99_new=no # Keyword NEW
reserved_word_ansi-92/99_next=no # Keyword NEXT
reserved_word_ansi-92/99_no=no # Keyword NO
reserved_word_ansi-92/99_none=no # Keyword NONE
reserved_word_ansi-92/99_not=yes # Keyword NOT
reserved_word_ansi-92/99_null=yes # Keyword NULL
reserved_word_ansi-92/99_numeric=yes # Keyword NUMERIC
reserved_word_ansi-92/99_object=no # Keyword OBJECT
reserved_word_ansi-92/99_of=no # Keyword OF
reserved_word_ansi-92/99_off=no # Keyword OFF
reserved_word_ansi-92/99_old=no # Keyword OLD
reserved_word_ansi-92/99_on=yes # Keyword ON
reserved_word_ansi-92/99_only=no # Keyword ONLY
reserved_word_ansi-92/99_open=no # Keyword OPEN
reserved_word_ansi-92/99_operation=no # Keyword OPERATION
reserved_word_ansi-92/99_option=yes # Keyword OPTION
reserved_word_ansi-92/99_or=yes # Keyword OR
reserved_word_ansi-92/99_order=yes # Keyword ORDER
reserved_word_ansi-92/99_outer=yes # Keyword OUTER
reserved_word_ansi-92/99_output=no # Keyword OUTPUT
reserved_word_ansi-92/99_pad=no # Keyword PAD
reserved_word_ansi-92/99_parameters=no # Keyword PARAMETERS
reserved_word_ansi-92/99_partial=no # Keyword PARTIAL
reserved_word_ansi-92/99_precision=yes # Keyword PRECISION
reserved_word_ansi-92/99_preorder=no # Keyword PREORDER
reserved_word_ansi-92/99_prepare=no # Keyword PREPARE
reserved_word_ansi-92/99_preserve=no # Keyword PRESERVE
reserved_word_ansi-92/99_primary=yes # Keyword PRIMARY
reserved_word_ansi-92/99_prior=no # Keyword PRIOR
reserved_word_ansi-92/99_privileges=no # Keyword PRIVILEGES
reserved_word_ansi-92/99_procedure=yes # Keyword PROCEDURE
reserved_word_ansi-92/99_public=no # Keyword PUBLIC
reserved_word_ansi-92/99_read=yes # Keyword READ
reserved_word_ansi-92/99_real=yes # Keyword REAL
reserved_word_ansi-92/99_recursive=no # Keyword RECURSIVE
reserved_word_ansi-92/99_ref=no # Keyword REF
reserved_word_ansi-92/99_references=yes # Keyword REFERENCES
reserved_word_ansi-92/99_referencing=no # Keyword REFERENCING
reserved_word_ansi-92/99_relative=no # Keyword RELATIVE
reserved_word_ansi-92/99_resignal=no # Keyword RESIGNAL
reserved_word_ansi-92/99_restrict=yes # Keyword RESTRICT
reserved_word_ansi-92/99_return=yes # Keyword RETURN
reserved_word_ansi-92/99_returns=no # Keyword RETURNS
reserved_word_ansi-92/99_revoke=yes # Keyword REVOKE
reserved_word_ansi-92/99_right=yes # Keyword RIGHT
reserved_word_ansi-92/99_role=no # Keyword ROLE
reserved_word_ansi-92/99_rollback=no # Keyword ROLLBACK
reserved_word_ansi-92/99_routine=no # Keyword ROUTINE
reserved_word_ansi-92/99_row=no # Keyword ROW
reserved_word_ansi-92/99_rows=no # Keyword ROWS
reserved_word_ansi-92/99_savepoint=no # Keyword SAVEPOINT
reserved_word_ansi-92/99_schema=yes # Keyword SCHEMA
reserved_word_ansi-92/99_scroll=no # Keyword SCROLL
reserved_word_ansi-92/99_search=no # Keyword SEARCH
reserved_word_ansi-92/99_second=no # Keyword SECOND
reserved_word_ansi-92/99_section=no # Keyword SECTION
reserved_word_ansi-92/99_select=yes # Keyword SELECT
reserved_word_ansi-92/99_sequence=no # Keyword SEQUENCE
reserved_word_ansi-92/99_session=no # Keyword SESSION
reserved_word_ansi-92/99_session_user=no # Keyword SESSION_USER
reserved_word_ansi-92/99_set=yes # Keyword SET
reserved_word_ansi-92/99_signal=no # Keyword SIGNAL
reserved_word_ansi-92/99_size=no # Keyword SIZE
reserved_word_ansi-92/99_smallint=yes # Keyword SMALLINT
reserved_word_ansi-92/99_some=no # Keyword SOME
reserved_word_ansi-92/99_space=no # Keyword SPACE
reserved_word_ansi-92/99_sql=yes # Keyword SQL
reserved_word_ansi-92/99_sqlexception=yes # Keyword SQLEXCEPTION
reserved_word_ansi-92/99_sqlstate=yes # Keyword SQLSTATE
reserved_word_ansi-92/99_sqlwarning=yes # Keyword SQLWARNING
reserved_word_ansi-92/99_structure=no # Keyword STRUCTURE
reserved_word_ansi-92/99_system_user=no # Keyword SYSTEM_USER
reserved_word_ansi-92/99_table=yes # Keyword TABLE
reserved_word_ansi-92/99_temporary=no # Keyword TEMPORARY
reserved_word_ansi-92/99_then=yes # Keyword THEN
reserved_word_ansi-92/99_time=no # Keyword TIME
reserved_word_ansi-92/99_timestamp=no # Keyword TIMESTAMP
reserved_word_ansi-92/99_timezone_hour=no # Keyword TIMEZONE_HOUR
reserved_word_ansi-92/99_timezone_minute=no # Keyword TIMEZONE_MINUTE
reserved_word_ansi-92/99_to=yes # Keyword TO
reserved_word_ansi-92/99_trailing=yes # Keyword TRAILING
reserved_word_ansi-92/99_transaction=no # Keyword TRANSACTION
reserved_word_ansi-92/99_translation=no # Keyword TRANSLATION
reserved_word_ansi-92/99_trigger=yes # Keyword TRIGGER
reserved_word_ansi-92/99_true=yes # Keyword TRUE
reserved_word_ansi-92/99_under=no # Keyword UNDER
reserved_word_ansi-92/99_union=yes # Keyword UNION
reserved_word_ansi-92/99_unique=yes # Keyword UNIQUE
reserved_word_ansi-92/99_unknown=no # Keyword UNKNOWN
reserved_word_ansi-92/99_update=yes # Keyword UPDATE
reserved_word_ansi-92/99_usage=yes # Keyword USAGE
reserved_word_ansi-92/99_user=no # Keyword USER
reserved_word_ansi-92/99_using=yes # Keyword USING
reserved_word_ansi-92/99_value=no # Keyword VALUE
reserved_word_ansi-92/99_values=yes # Keyword VALUES
reserved_word_ansi-92/99_varchar=yes # Keyword VARCHAR
reserved_word_ansi-92/99_variable=no # Keyword VARIABLE
reserved_word_ansi-92/99_varying=yes # Keyword VARYING
reserved_word_ansi-92/99_view=no # Keyword VIEW
reserved_word_ansi-92/99_when=yes # Keyword WHEN
reserved_word_ansi-92/99_whenever=no # Keyword WHENEVER
reserved_word_ansi-92/99_where=yes # Keyword WHERE
reserved_word_ansi-92/99_while=yes # Keyword WHILE
reserved_word_ansi-92/99_with=yes # Keyword WITH
reserved_word_ansi-92/99_without=no # Keyword WITHOUT
reserved_word_ansi-92/99_work=no # Keyword WORK
reserved_word_ansi-92/99_write=yes # Keyword WRITE
reserved_word_ansi-92/99_year=no # Keyword YEAR
reserved_word_ansi-92/99_zone=no # Keyword ZONE
reserved_word_ansi92_async=no # Keyword ASYNC
reserved_word_ansi92_avg=no # Keyword AVG
reserved_word_ansi92_between=yes # Keyword BETWEEN
reserved_word_ansi92_bit_length=no # Keyword BIT_LENGTH
reserved_word_ansi92_char_length=no # Keyword CHAR_LENGTH
reserved_word_ansi92_character_length=no # Keyword CHARACTER_LENGTH
reserved_word_ansi92_coalesce=no # Keyword COALESCE
reserved_word_ansi92_convert=yes # Keyword CONVERT
reserved_word_ansi92_count=no # Keyword COUNT
reserved_word_ansi92_exists=yes # Keyword EXISTS
reserved_word_ansi92_extract=no # Keyword EXTRACT
reserved_word_ansi92_insensitive=yes # Keyword INSENSITIVE
reserved_word_ansi92_lower=no # Keyword LOWER
reserved_word_ansi92_max=no # Keyword MAX
reserved_word_ansi92_min=no # Keyword MIN
reserved_word_ansi92_nullif=no # Keyword NULLIF
reserved_word_ansi92_octet_length=no # Keyword OCTET_LENGTH
reserved_word_ansi92_oid=no # Keyword OID
reserved_word_ansi92_operators=no # Keyword OPERATORS
reserved_word_ansi92_others=no # Keyword OTHERS
reserved_word_ansi92_overlaps=no # Keyword OVERLAPS
reserved_word_ansi92_pendant=no # Keyword PENDANT
reserved_word_ansi92_position=no # Keyword POSITION
reserved_word_ansi92_private=no # Keyword PRIVATE
reserved_word_ansi92_protected=no # Keyword PROTECTED
reserved_word_ansi92_replace=yes # Keyword REPLACE
reserved_word_ansi92_sensitive=yes # Keyword SENSITIVE
reserved_word_ansi92_similar=no # Keyword SIMILAR
reserved_word_ansi92_sqlcode=no # Keyword SQLCODE
reserved_word_ansi92_sqlerror=no # Keyword SQLERROR
reserved_word_ansi92_substring=no # Keyword SUBSTRING
reserved_word_ansi92_sum=no # Keyword SUM
reserved_word_ansi92_test=no # Keyword TEST
reserved_word_ansi92_there=no # Keyword THERE
reserved_word_ansi92_translate=no # Keyword TRANSLATE
reserved_word_ansi92_trim=no # Keyword TRIM
reserved_word_ansi92_type=no # Keyword TYPE
reserved_word_ansi92_upper=no # Keyword UPPER
reserved_word_ansi92_virtual=no # Keyword VIRTUAL
reserved_word_ansi92_visible=no # Keyword VISIBLE
reserved_word_ansi92_wait=no # Keyword WAIT
reserved_word_ansi99_admin=no # Keyword ADMIN
reserved_word_ansi99_aggregate=no # Keyword AGGREGATE
reserved_word_ansi99_array=no # Keyword ARRAY
reserved_word_ansi99_binary=yes # Keyword BINARY
reserved_word_ansi99_blob=yes # Keyword BLOB
reserved_word_ansi99_class=no # Keyword CLASS
reserved_word_ansi99_clob=no # Keyword CLOB
reserved_word_ansi99_condition=yes # Keyword CONDITION
reserved_word_ansi99_constructor=no # Keyword CONSTRUCTOR
reserved_word_ansi99_contains=no # Keyword CONTAINS
reserved_word_ansi99_cube=no # Keyword CUBE
reserved_word_ansi99_current_path=no # Keyword CURRENT_PATH
reserved_word_ansi99_current_role=no # Keyword CURRENT_ROLE
reserved_word_ansi99_datalink=no # Keyword DATALINK
reserved_word_ansi99_deref=no # Keyword DEREF
reserved_word_ansi99_destroy=no # Keyword DESTROY
reserved_word_ansi99_destructor=no # Keyword DESTRUCTOR
reserved_word_ansi99_deterministic=yes # Keyword DETERMINISTIC
reserved_word_ansi99_do=no # Keyword DO
reserved_word_ansi99_dynamic=no # Keyword DYNAMIC
reserved_word_ansi99_every=no # Keyword EVERY
reserved_word_ansi99_exit=yes # Keyword EXIT
reserved_word_ansi99_expand=no # Keyword EXPAND
reserved_word_ansi99_expanding=no # Keyword EXPANDING
reserved_word_ansi99_free=no # Keyword FREE
reserved_word_ansi99_function=no # Keyword FUNCTION
reserved_word_ansi99_grouping=no # Keyword GROUPING
reserved_word_ansi99_handler=no # Keyword HANDLER
reserved_word_ansi99_hast=no # Keyword HAST
reserved_word_ansi99_host=no # Keyword HOST
reserved_word_ansi99_initialize=no # Keyword INITIALIZE
reserved_word_ansi99_inout=yes # Keyword INOUT
reserved_word_ansi99_iterate=yes # Keyword ITERATE
reserved_word_ansi99_large=no # Keyword LARGE
reserved_word_ansi99_lateral=no # Keyword LATERAL
reserved_word_ansi99_localtime=yes # Keyword LOCALTIME
reserved_word_ansi99_localtimestamp=yes # Keyword LOCALTIMESTAMP
reserved_word_ansi99_locator=no # Keyword LOCATOR
reserved_word_ansi99_meets=no # Keyword MEETS
reserved_word_ansi99_modifies=yes # Keyword MODIFIES
reserved_word_ansi99_nclob=no # Keyword NCLOB
reserved_word_ansi99_normalize=no # Keyword NORMALIZE
reserved_word_ansi99_ordinality=no # Keyword ORDINALITY
reserved_word_ansi99_out=yes # Keyword OUT
reserved_word_ansi99_parameter=no # Keyword PARAMETER
reserved_word_ansi99_path=no # Keyword PATH
reserved_word_ansi99_period=no # Keyword PERIOD
reserved_word_ansi99_postfix=no # Keyword POSTFIX
reserved_word_ansi99_precedes=no # Keyword PRECEDES
reserved_word_ansi99_prefix=no # Keyword PREFIX
reserved_word_ansi99_reads=yes # Keyword READS
reserved_word_ansi99_redo=no # Keyword REDO
reserved_word_ansi99_repeat=yes # Keyword REPEAT
reserved_word_ansi99_result=no # Keyword RESULT
reserved_word_ansi99_rollup=no # Keyword ROLLUP
reserved_word_ansi99_sets=no # Keyword SETS
reserved_word_ansi99_specific=yes # Keyword SPECIFIC
reserved_word_ansi99_specifictype=no # Keyword SPECIFICTYPE
reserved_word_ansi99_start=no # Keyword START
reserved_word_ansi99_state=no # Keyword STATE
reserved_word_ansi99_static=no # Keyword STATIC
reserved_word_ansi99_succeeds=no # Keyword SUCCEEDS
reserved_word_ansi99_terminate=no # Keyword TERMINATE
reserved_word_ansi99_than=no # Keyword THAN
reserved_word_ansi99_treat=no # Keyword TREAT
reserved_word_ansi99_undo=yes # Keyword UNDO
reserved_word_ansi99_until=no # Keyword UNTIL
reserved_word_extra_access=no # Keyword ACCESS
reserved_word_extra_analyze=yes # Keyword ANALYZE
reserved_word_extra_audit=no # Keyword AUDIT
reserved_word_extra_auto_increment=no # Keyword AUTO_INCREMENT
reserved_word_extra_backup=no # Keyword BACKUP
reserved_word_extra_bdb=no # Keyword BDB
reserved_word_extra_berkeleydb=no # Keyword BERKELEYDB
reserved_word_extra_bigint=yes # Keyword BIGINT
reserved_word_extra_break=no # Keyword BREAK
reserved_word_extra_browse=no # Keyword BROWSE
reserved_word_extra_btree=no # Keyword BTREE
reserved_word_extra_bulk=no # Keyword BULK
reserved_word_extra_change=yes # Keyword CHANGE
reserved_word_extra_checkpoint=no # Keyword CHECKPOINT
reserved_word_extra_cluster=no # Keyword CLUSTER
reserved_word_extra_clustered=no # Keyword CLUSTERED
reserved_word_extra_columns=no # Keyword COLUMNS
reserved_word_extra_comment=no # Keyword COMMENT
reserved_word_extra_compress=no # Keyword COMPRESS
reserved_word_extra_compute=no # Keyword COMPUTE
reserved_word_extra_containstable=no # Keyword CONTAINSTABLE
reserved_word_extra_database=yes # Keyword DATABASE
reserved_word_extra_databases=yes # Keyword DATABASES
reserved_word_extra_day_hour=yes # Keyword DAY_HOUR
reserved_word_extra_day_minute=yes # Keyword DAY_MINUTE
reserved_word_extra_day_second=yes # Keyword DAY_SECOND
reserved_word_extra_dbcc=no # Keyword DBCC
reserved_word_extra_delayed=yes # Keyword DELAYED
reserved_word_extra_deny=no # Keyword DENY
reserved_word_extra_disk=no # Keyword DISK
reserved_word_extra_distinctrow=yes # Keyword DISTINCTROW
reserved_word_extra_distributed=no # Keyword DISTRIBUTED
reserved_word_extra_dummy=no # Keyword DUMMY
reserved_word_extra_dump=no # Keyword DUMP
reserved_word_extra_enclosed=yes # Keyword ENCLOSED
reserved_word_extra_errlvl=no # Keyword ERRLVL
reserved_word_extra_errors=no # Keyword ERRORS
reserved_word_extra_escaped=yes # Keyword ESCAPED
reserved_word_extra_exclusive=no # Keyword EXCLUSIVE
reserved_word_extra_explain=yes # Keyword EXPLAIN
reserved_word_extra_fields=no # Keyword FIELDS
reserved_word_extra_file=no # Keyword FILE
reserved_word_extra_fillfactor=no # Keyword FILLFACTOR
reserved_word_extra_freetext=no # Keyword FREETEXT
reserved_word_extra_freetexttable=no # Keyword FREETEXTTABLE
reserved_word_extra_fulltext=yes # Keyword FULLTEXT
reserved_word_extra_geometry=no # Keyword GEOMETRY
reserved_word_extra_hash=no # Keyword HASH
reserved_word_extra_high_priority=yes # Keyword HIGH_PRIORITY
reserved_word_extra_holdlock=no # Keyword HOLDLOCK
reserved_word_extra_hour_minute=yes # Keyword HOUR_MINUTE
reserved_word_extra_hour_second=yes # Keyword HOUR_SECOND
reserved_word_extra_identified=no # Keyword IDENTIFIED
reserved_word_extra_identity_insert=no # Keyword IDENTITY_INSERT
reserved_word_extra_identitycol=no # Keyword IDENTITYCOL
reserved_word_extra_increment=no # Keyword INCREMENT
reserved_word_extra_index=yes # Keyword INDEX
reserved_word_extra_infile=yes # Keyword INFILE
reserved_word_extra_initial=no # Keyword INITIAL
reserved_word_extra_innodb=no # Keyword INNODB
reserved_word_extra_keys=yes # Keyword KEYS
reserved_word_extra_kill=yes # Keyword KILL
reserved_word_extra_lineno=no # Keyword LINENO
reserved_word_extra_lines=yes # Keyword LINES
reserved_word_extra_load=yes # Keyword LOAD
reserved_word_extra_lock=yes # Keyword LOCK
reserved_word_extra_long=yes # Keyword LONG
reserved_word_extra_longblob=yes # Keyword LONGBLOB
reserved_word_extra_longtext=yes # Keyword LONGTEXT
reserved_word_extra_low_priority=yes # Keyword LOW_PRIORITY
reserved_word_extra_master_server_id=no # Keyword MASTER_SERVER_ID
reserved_word_extra_maxextents=no # Keyword MAXEXTENTS
reserved_word_extra_mediumblob=yes # Keyword MEDIUMBLOB
reserved_word_extra_mediumint=yes # Keyword MEDIUMINT
reserved_word_extra_mediumtext=yes # Keyword MEDIUMTEXT
reserved_word_extra_middleint=yes # Keyword MIDDLEINT
reserved_word_extra_minus=no # Keyword MINUS
reserved_word_extra_minute_second=yes # Keyword MINUTE_SECOND
reserved_word_extra_mlslabel=no # Keyword MLSLABEL
reserved_word_extra_mode=no # Keyword MODE
reserved_word_extra_mrg_myisam=no # Keyword MRG_MYISAM
reserved_word_extra_noaudit=no # Keyword NOAUDIT
reserved_word_extra_nocheck=no # Keyword NOCHECK
reserved_word_extra_nocompress=no # Keyword NOCOMPRESS
reserved_word_extra_nonclustered=no # Keyword NONCLUSTERED
reserved_word_extra_nowait=no # Keyword NOWAIT
reserved_word_extra_number=no # Keyword NUMBER
reserved_word_extra_offline=no # Keyword OFFLINE
reserved_word_extra_offsets=no # Keyword OFFSETS
reserved_word_extra_online=no # Keyword ONLINE
reserved_word_extra_opendatasource=no # Keyword OPENDATASOURCE
reserved_word_extra_openquery=no # Keyword OPENQUERY
reserved_word_extra_openrowset=no # Keyword OPENROWSET
reserved_word_extra_openxml=no # Keyword OPENXML
reserved_word_extra_optimize=yes # Keyword OPTIMIZE
reserved_word_extra_optionally=yes # Keyword OPTIONALLY
reserved_word_extra_outfile=yes # Keyword OUTFILE
reserved_word_extra_over=no # Keyword OVER
reserved_word_extra_pctfree=no # Keyword PCTFREE
reserved_word_extra_percent=no # Keyword PERCENT
reserved_word_extra_plan=no # Keyword PLAN
reserved_word_extra_print=no # Keyword PRINT
reserved_word_extra_proc=no # Keyword PROC
reserved_word_extra_purge=yes # Keyword PURGE
reserved_word_extra_raiserror=no # Keyword RAISERROR
reserved_word_extra_raw=no # Keyword RAW
reserved_word_extra_readtext=no # Keyword READTEXT
reserved_word_extra_reconfigure=no # Keyword RECONFIGURE
reserved_word_extra_regexp=yes # Keyword REGEXP
reserved_word_extra_rename=yes # Keyword RENAME
reserved_word_extra_replication=no # Keyword REPLICATION
reserved_word_extra_require=yes # Keyword REQUIRE
reserved_word_extra_resource=no # Keyword RESOURCE
reserved_word_extra_restore=no # Keyword RESTORE
reserved_word_extra_rlike=yes # Keyword RLIKE
reserved_word_extra_rowcount=no # Keyword ROWCOUNT
reserved_word_extra_rowguidcol=no # Keyword ROWGUIDCOL
reserved_word_extra_rowid=no # Keyword ROWID
reserved_word_extra_rownum=no # Keyword ROWNUM
reserved_word_extra_rtree=no # Keyword RTREE
reserved_word_extra_rule=no # Keyword RULE
reserved_word_extra_save=no # Keyword SAVE
reserved_word_extra_setuser=no # Keyword SETUSER
reserved_word_extra_share=no # Keyword SHARE
reserved_word_extra_show=yes # Keyword SHOW
reserved_word_extra_shutdown=no # Keyword SHUTDOWN
reserved_word_extra_soname=yes # Keyword SONAME
reserved_word_extra_spatial=yes # Keyword SPATIAL
reserved_word_extra_sql_big_result=yes # Keyword SQL_BIG_RESULT
reserved_word_extra_sql_calc_found_rows=yes # Keyword SQL_CALC_FOUND_ROWS
reserved_word_extra_sql_small_result=yes # Keyword SQL_SMALL_RESULT
reserved_word_extra_ssl=yes # Keyword SSL
reserved_word_extra_starting=yes # Keyword STARTING
reserved_word_extra_statistics=no # Keyword STATISTICS
reserved_word_extra_straight_join=yes # Keyword STRAIGHT_JOIN
reserved_word_extra_striped=no # Keyword STRIPED
reserved_word_extra_successful=no # Keyword SUCCESSFUL
reserved_word_extra_synonym=no # Keyword SYNONYM
reserved_word_extra_sysdate=no # Keyword SYSDATE
reserved_word_extra_tables=no # Keyword TABLES
reserved_word_extra_terminated=yes # Keyword TERMINATED
reserved_word_extra_textsize=no # Keyword TEXTSIZE
reserved_word_extra_tinyblob=yes # Keyword TINYBLOB
reserved_word_extra_tinyint=yes # Keyword TINYINT
reserved_word_extra_tinytext=yes # Keyword TINYTEXT
reserved_word_extra_top=no # Keyword TOP
reserved_word_extra_tran=no # Keyword TRAN
reserved_word_extra_truncate=no # Keyword TRUNCATE
reserved_word_extra_tsequal=no # Keyword TSEQUAL
reserved_word_extra_types=no # Keyword TYPES
reserved_word_extra_uid=no # Keyword UID
reserved_word_extra_unlock=yes # Keyword UNLOCK
reserved_word_extra_unsigned=yes # Keyword UNSIGNED
reserved_word_extra_updatetext=no # Keyword UPDATETEXT
reserved_word_extra_use=yes # Keyword USE
reserved_word_extra_user_resources=no # Keyword USER_RESOURCES
reserved_word_extra_validate=no # Keyword VALIDATE
reserved_word_extra_varbinary=yes # Keyword VARBINARY
reserved_word_extra_varchar2=no # Keyword VARCHAR2
reserved_word_extra_waitfor=no # Keyword WAITFOR
reserved_word_extra_warnings=no # Keyword WARNINGS
reserved_word_extra_writetext=no # Keyword WRITETEXT
reserved_word_extra_xor=yes # Keyword XOR
reserved_word_extra_year_month=yes # Keyword YEAR_MONTH
reserved_word_extra_zerofill=yes # Keyword ZEROFILL
right_outer_join=yes # right outer join
rollback_metadata=no # rollback_metadata
rowid=auto_increment # Type for row id
safe_decimal_arithmetic=yes # safe decimal arithmetic
select_constants=yes # Select constants
select_limit=with LIMIT # LIMIT number of rows
select_limit2=yes # SELECT with LIMIT #,#
select_limit3=yes # SELECT with LIMIT # OFFSET #
select_string_size=1048565 # constant string size in SELECT
select_table_update=yes # Update with sub select
select_without_from=yes # SELECT without FROM
server_version=MySQL 5.0.7 beta valgrind max debug/ # server version
simple_joins=yes # ANSI SQL simple joins
sorted_group_by=yes # Group by always sorted
storage_of_float=round # Storage of float values
subqueries=yes # subqueries
table_alias=yes # Table alias
table_name_case=no # case independent table names
table_wildcard=yes # Select table_name.*
temporary_table=yes # temporary tables
time_format_EUR=error # Supports HH.MM.SS (EUR) time format
time_format_HHHHMMSS=yes # Supports HHHHmmSS time format
time_format_ISO=yes # Supports HH:MM:SS (ISO) time format
time_format_USA=error # Supports HH:MM:SS (AM|PM) time format
time_format_inresult=iso # Time format in result
transactions=yes # transactions
truncate_table=yes # truncate
type_extra_abstime=no # Type abstime
type_extra_bfile=no # Type bfile
type_extra_blob=yes # Type blob
type_extra_bool=yes # Type bool
type_extra_box=no # Type box
type_extra_byte=no # Type byte
type_extra_char(1_arg)_binary=yes # Type char(1 arg) binary
type_extra_cidr=no # Type cidr
type_extra_circle=no # Type circle
type_extra_clob=no # Type clob
type_extra_datetime=yes # Type datetime
type_extra_double=yes # Type double
type_extra_enum(1_arg)=yes # Type enum(1 arg)
type_extra_float(2_arg)=yes # Type float(2 arg)
type_extra_float4=yes # Type float4
type_extra_float8=yes # Type float8
type_extra_image=no # Type image
type_extra_inet=no # Type inet
type_extra_int(1_arg)_zerofill=yes # Type int(1 arg) zerofill
type_extra_int1=yes # Type int1
type_extra_int2=yes # Type int2
type_extra_int3=yes # Type int3
type_extra_int4=yes # Type int4
type_extra_int8=yes # Type int8
type_extra_int_auto_increment=yes # Type int not null auto_increment
type_extra_int_identity=no # Type int not null identity
type_extra_int_unsigned=yes # Type int unsigned
type_extra_interval=no # Type interval
type_extra_line=no # Type line
type_extra_long=yes # Type long
type_extra_long_raw=no # Type long raw
type_extra_long_varbinary=yes # Type long varbinary
type_extra_long_varchar(1_arg)=no # Type long varchar(1 arg)
type_extra_lseg=no # Type lseg
type_extra_macaddr=no # Type macaddr
type_extra_mediumint=yes # Type mediumint
type_extra_mediumtext=yes # Type mediumtext
type_extra_middleint=yes # Type middleint
type_extra_mlslabel=no # Type mlslabel
type_extra_money=no # Type money
type_extra_nclob=no # Type nclob
type_extra_number=no # Type number
type_extra_number(1_arg)=no # Type number(1 arg)
type_extra_number(2_arg)=no # Type number(2 arg)
type_extra_nvarchar2(1_arg)=no # Type nvarchar2(1 arg)
type_extra_path=no # Type path
type_extra_point=yes # Type point
type_extra_polygon=yes # Type polygon
type_extra_raw(1_arg)=no # Type raw(1 arg)
type_extra_reltime=no # Type reltime
type_extra_rowid=no # Type rowid
type_extra_serial=yes # Type serial
type_extra_set(1_arg)=yes # Type set(1 arg)
type_extra_smalldatetime=no # Type smalldatetime
type_extra_smallfloat=no # Type smallfloat
type_extra_smallmoney=no # Type smallmoney
type_extra_text=yes # Type text
type_extra_text(1_arg)=yes # Type text(1 arg)
type_extra_timespan=no # Type timespan
type_extra_uint=no # Type uint
type_extra_varchar2(1_arg)=no # Type varchar2(1 arg)
type_extra_year=yes # Type year
type_odbc_bigint=yes # Type bigint
type_odbc_binary(1_arg)=yes # Type binary(1 arg)
type_odbc_datetime=yes # Type datetime
type_odbc_tinyint=yes # Type tinyint
type_odbc_varbinary(1_arg)=yes # Type varbinary(1 arg)
type_sql_bit=yes # Type bit
type_sql_bit(1_arg)=yes # Type bit(1 arg)
type_sql_bit_varying(1_arg)=no # Type bit varying(1 arg)
type_sql_boolean=yes # Type boolean
type_sql_char(1_arg)=yes # Type char(1 arg)
type_sql_char_varying(1_arg)=yes # Type char varying(1 arg)
type_sql_character(1_arg)=yes # Type character(1 arg)
type_sql_character_varying(1_arg)=yes # Type character varying(1 arg)
type_sql_date=yes # Type date
type_sql_dec(2_arg)=yes # Type dec(2 arg)
type_sql_decimal(2_arg)=yes # Type decimal(2 arg)
type_sql_double_precision=yes # Type double precision
type_sql_float=yes # Type float
type_sql_float(1_arg)=yes # Type float(1 arg)
type_sql_int=yes # Type int
type_sql_integer=yes # Type integer
type_sql_interval_day=no # Type interval day
type_sql_interval_day_to_hour=no # Type interval day to hour
type_sql_interval_day_to_minute=no # Type interval day to minute
type_sql_interval_day_to_second=no # Type interval day to second
type_sql_interval_hour=no # Type interval hour
type_sql_interval_hour_to_minute=no # Type interval hour to minute
type_sql_interval_hour_to_second=no # Type interval hour to second
type_sql_interval_minute=no # Type interval minute
type_sql_interval_minute_to_second=no # Type interval minute to second
type_sql_interval_month=no # Type interval month
type_sql_interval_second=no # Type interval second
type_sql_interval_year=no # Type interval year
type_sql_interval_year_to_month=no # Type interval year to month
type_sql_national_char_varying(1_arg)=yes # Type national char varying(1 arg)
type_sql_national_character(1_arg)=yes # Type national character(1 arg)
type_sql_national_character_varying(1_arg)=yes # Type national character varying(1 arg)
type_sql_nchar(1_arg)=yes # Type nchar(1 arg)
type_sql_nchar_varying(1_arg)=yes # Type nchar varying(1 arg)
type_sql_numeric(2_arg)=yes # Type numeric(2 arg)
type_sql_real=yes # Type real
type_sql_smallint=yes # Type smallint
type_sql_time=yes # Type time
type_sql_timestamp=yes # Type timestamp
type_sql_timestamp_with_time_zone=no # Type timestamp with time zone
type_sql_varchar(1_arg)=yes # Type varchar(1 arg)
union=yes # union
union_all=yes # union all
union_all_incompat=yes # union all (incompatible lists)
union_incompat=yes # union (incompatible lists)
unique_in_create=yes # unique in create table
unique_null_in_create=yes # unique null in create
value_of_false=0 # Value of FALSE
value_of_true=1 # Value of TRUE
views=yes # views
where_string_size=1048539 # constant string size in where
|