← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/sql-bench/limits/mysql.cfg

  • Committer: Andrew Hutchings
  • Date: 2011-06-13 17:29:43 UTC
  • mfrom: (2331 drizzle)
  • mto: This revision was merged to the branch mainline in revision 2332.
  • Revision ID: andrew@linuxjedi.co.uk-20110613172943-y3gig2cyg4p2a0tq
Merge with trunk

Show diffs side-by-side

added added

removed removed

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