~mysql/mysql-server/mysql-6.0

« back to all changes in this revision

Viewing changes to sql-bench/limits/ms-sql.cfg

  • Committer: bk at mysql
  • Date: 2000-07-31 19:29:14 UTC
  • Revision ID: sp1r-bk@work.mysql.com-20000731192914-08846
Import changeset

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
#This file is automaticly generated by crash-me 1.45
 
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=without add         # 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=no                      # Alter table alter column default
 
12
alter_change_col=no                     # Alter table change column
 
13
alter_drop_col=yes                      # Alter table drop column
 
14
alter_drop_constraint=yes               # Alter table drop constraint
 
15
alter_drop_foreign_key=with drop constraint     # Alter table drop foreign key
 
16
alter_drop_primary_key=no               # Alter table drop primary key
 
17
alter_drop_unique=with constraint       # Alter table drop unique
 
18
alter_modify_col=no                     # Alter table modify column
 
19
alter_rename_table=no                   # Alter table rename table
 
20
atomic_updates=yes                      # atomic updates
 
21
atomic_updates_with_rollback=yes        # atomic_updates_with_rollback
 
22
automatic_rowid=no                      # Automatic rowid
 
23
binary_numbers=yes                      # binary numbers (0b1001)
 
24
binary_strings=no                       # binary strings (b'0110')
 
25
case_insensitive_strings=yes            # case insensitive compare
 
26
char_is_space_filled=no                 # char are space filled
 
27
column_alias=yes                        # Column alias
 
28
columns_in_group_by=+64                 # number of columns in group by
 
29
columns_in_order_by=+64                 # number of columns in order by
 
30
comment_#=no                            # # as comment
 
31
comment_--=yes                          # -- as comment
 
32
comment_/**/=yes                        # /* */ as comment
 
33
comment_//=no                           # // as comment
 
34
compute=yes                             # Compute
 
35
connections=1000                        # Simultaneous connections (installation default)
 
36
constraint_check=no                     # Column constraints
 
37
constraint_check_table=yes              # Table constraints
 
38
constraint_null=yes                     # NULL constraint (SyBase style)
 
39
crash_me_safe=no                        # crash me safe
 
40
crash_me_version=1.45                   # 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=no                 # create table if not exists
 
44
create_index=yes                        # create index
 
45
create_schema=yes                       # Create SCHEMA
 
46
create_table_select=no                  # create table from select
 
47
cross_join=yes                          # cross join (same as from a,b)
 
48
date_as_string=no                       # String functions on date columns
 
49
date_last=no                            # Supports 9999-12-31 dates
 
50
date_one=no                             # Supports 0001-01-01 dates
 
51
date_with_YY=no                         # Supports YY-MM-DD dates
 
52
date_zero=no                            # Supports 0000-00-00 dates
 
53
domains=no                              # Domains (ANSI SQL)
 
54
double_quotes=yes                       # Double '' as ' in strings
 
55
drop_if_exists=no                       # drop table if exists
 
56
drop_index=with 'table.index'           # drop index
 
57
end_colon=yes                           # allows end ';'
 
58
except=no                               # except
 
59
except_all=no                           # except all
 
60
except_all_incompat=no                  # except all (incompatible lists)
 
61
except_incompat=no                      # except (incompatible lists)
 
62
float_int_expr=yes                      # mixing of integer and float in expression
 
63
foreign_key=yes                         # foreign keys
 
64
foreign_key_circular=no                 # Circular foreign keys
 
65
foreign_key_syntax=yes                  # foreign key syntax
 
66
full_outer_join=yes                     # full outer join
 
67
func_extra_!=no                         # Function NOT as '!' in SELECT
 
68
func_extra_%=yes                        # Function MOD as %
 
69
func_extra_&=yes                        # Function & (bitwise and)
 
70
func_extra_&&=no                        # Function AND as '&&'
 
71
func_extra_<>=no                        # Function <> in SELECT
 
72
func_extra_==no                         # Function =
 
73
func_extra_add_months=no                # Function ADD_MONTHS
 
74
func_extra_and_or=no                    # Function AND and OR in SELECT
 
75
func_extra_ascii_char=no                # Function ASCII_CHAR
 
76
func_extra_ascii_code=no                # Function ASCII_CODE
 
77
func_extra_atn2=yes                     # Function ATN2
 
78
func_extra_auto_num2string=no           # Function automatic num->string convert
 
79
func_extra_auto_string2num=yes          # Function automatic string->num convert
 
80
func_extra_between=no                   # Function BETWEEN in SELECT
 
81
func_extra_binary_shifts=no             # Function << and >> (bitwise shifts)
 
82
func_extra_bit_count=no                 # Function BIT_COUNT
 
83
func_extra_ceil=no                      # Function CEIL
 
84
func_extra_charindex=yes                # Function CHARINDEX
 
85
func_extra_chr=no                       # Function CHR
 
86
func_extra_concat_as_+=yes              # Function concatenation with +
 
87
func_extra_concat_list=no               # Function CONCAT(list)
 
88
func_extra_convert=yes                  # Function CONVERT
 
89
func_extra_cosh=no                      # Function COSH
 
90
func_extra_date_format=no               # Function DATE_FORMAT
 
91
func_extra_dateadd=yes                  # Function DATEADD
 
92
func_extra_datediff=yes                 # Function DATEDIFF
 
93
func_extra_datename=yes                 # Function DATENAME
 
94
func_extra_datepart=yes                 # Function DATEPART
 
95
func_extra_elt=no                       # Function ELT
 
96
func_extra_encrypt=yes                  # Function ENCRYPT
 
97
func_extra_field=no                     # Function FIELD
 
98
func_extra_format=no                    # Function FORMAT
 
99
func_extra_from_days=no                 # Function FROM_DAYS
 
100
func_extra_from_unixtime=no             # Function FROM_UNIXTIME
 
101
func_extra_getdate=yes                  # Function GETDATE
 
102
func_extra_greatest=no                  # Function GREATEST
 
103
func_extra_if=no                        # Function IF
 
104
func_extra_in_num=no                    # Function IN on numbers in SELECT
 
105
func_extra_in_str=no                    # Function IN on strings in SELECT
 
106
func_extra_initcap=no                   # Function INITCAP
 
107
func_extra_instr=no                     # Function LOCATE as INSTR
 
108
func_extra_instr_oracle=no              # Function INSTR (Oracle syntax)
 
109
func_extra_instrb=no                    # Function INSTRB
 
110
func_extra_interval=no                  # Function INTERVAL
 
111
func_extra_last_day=no                  # Function LAST_DAY
 
112
func_extra_last_insert_id=no            # Function LAST_INSERT_ID
 
113
func_extra_least=no                     # Function LEAST
 
114
func_extra_lengthb=no                   # Function LENGTHB
 
115
func_extra_like=no                      # Function LIKE in SELECT
 
116
func_extra_like_escape=no               # Function LIKE ESCAPE in SELECT
 
117
func_extra_ln=no                        # Function LN
 
118
func_extra_log(m_n)=no                  # Function LOG(m,n)
 
119
func_extra_logn=no                      # Function LOGN
 
120
func_extra_lpad=no                      # Function LPAD
 
121
func_extra_mdy=no                       # Function MDY
 
122
func_extra_mid=no                       # Function SUBSTRING as MID
 
123
func_extra_months_between=no            # Function MONTHS_BETWEEN
 
124
func_extra_not=no                       # Function NOT in SELECT
 
125
func_extra_not_between=no               # Function NOT BETWEEN in SELECT
 
126
func_extra_not_like=no                  # Function NOT LIKE in SELECT
 
127
func_extra_odbc_convert=no              # Function ODBC CONVERT
 
128
func_extra_password=no                  # Function PASSWORD
 
129
func_extra_paste=no                     # Function PASTE
 
130
func_extra_patindex=yes                 # Function PATINDEX
 
131
func_extra_period_add=no                # Function PERIOD_ADD
 
132
func_extra_period_diff=no               # Function PERIOD_DIFF
 
133
func_extra_pow=no                       # Function POW
 
134
func_extra_range=no                     # Function RANGE
 
135
func_extra_regexp=no                    # Function REGEXP in SELECT
 
136
func_extra_replicate=yes                # Function REPLICATE
 
137
func_extra_reverse=yes                  # Function REVERSE
 
138
func_extra_root=no                      # Function ROOT
 
139
func_extra_round1=no                    # Function ROUND(1 arg)
 
140
func_extra_rpad=no                      # Function RPAD
 
141
func_extra_sec_to_time=no               # Function SEC_TO_TIME
 
142
func_extra_sinh=no                      # Function SINH
 
143
func_extra_str=yes                      # Function STR
 
144
func_extra_strcmp=no                    # Function STRCMP
 
145
func_extra_stuff=yes                    # Function STUFF
 
146
func_extra_substrb=no                   # Function SUBSTRB
 
147
func_extra_substring_index=no           # Function SUBSTRING_INDEX
 
148
func_extra_sysdate=no                   # Function SYSDATE
 
149
func_extra_tail=no                      # Function TAIL
 
150
func_extra_tanh=no                      # Function TANH
 
151
func_extra_time_to_sec=no               # Function TIME_TO_SEC
 
152
func_extra_to_days=no                   # Function TO_DAYS
 
153
func_extra_translate=no                 # Function TRANSLATE
 
154
func_extra_trim_many_char=no            # Function TRIM; Many char extension
 
155
func_extra_trim_substring=no            # Function TRIM; Substring extension
 
156
func_extra_trunc=no                     # Function TRUNC
 
157
func_extra_uid=no                       # Function UID
 
158
func_extra_unix_timestamp=no            # Function UNIX_TIMESTAMP
 
159
func_extra_userenv=no                   # Function USERENV
 
160
func_extra_version=no                   # Function VERSION
 
161
func_extra_weekday=no                   # Function WEEKDAY
 
162
func_extra_|=yes                        # Function | (bitwise or)
 
163
func_extra_||=no                        # Function OR as '||'
 
164
func_odbc_abs=yes                       # Function ABS
 
165
func_odbc_acos=yes                      # Function ACOS
 
166
func_odbc_ascii=yes                     # Function ASCII
 
167
func_odbc_asin=yes                      # Function ASIN
 
168
func_odbc_atan=yes                      # Function ATAN
 
169
func_odbc_atan2=yes                     # Function ATAN2
 
170
func_odbc_ceiling=yes                   # Function CEILING
 
171
func_odbc_char=yes                      # Function CHAR
 
172
func_odbc_concat=yes                    # Function CONCAT(2 arg)
 
173
func_odbc_cos=yes                       # Function COS
 
174
func_odbc_cot=yes                       # Function COT
 
175
func_odbc_curdate=yes                   # Function CURDATE
 
176
func_odbc_curtime=yes                   # Function CURTIME
 
177
func_odbc_database=yes                  # Function DATABASE
 
178
func_odbc_dayname=yes                   # Function DAYNAME
 
179
func_odbc_dayofmonth=yes                # Function DAYOFMONTH
 
180
func_odbc_dayofweek=yes                 # Function DAYOFWEEK
 
181
func_odbc_dayofyear=yes                 # Function DAYOFYEAR
 
182
func_odbc_degrees=yes                   # Function DEGREES
 
183
func_odbc_difference=yes                # Function DIFFERENCE()
 
184
func_odbc_exp=yes                       # Function EXP
 
185
func_odbc_floor=yes                     # Function FLOOR
 
186
func_odbc_fn_left=yes                   # Function ODBC syntax LEFT & RIGHT
 
187
func_odbc_hour=yes                      # Function HOUR
 
188
func_odbc_hour_time=yes                 # Function ANSI HOUR
 
189
func_odbc_ifnull=yes                    # Function IFNULL
 
190
func_odbc_insert=yes                    # Function INSERT
 
191
func_odbc_lcase=yes                     # Function LCASE
 
192
func_odbc_left=yes                      # Function LEFT
 
193
func_odbc_length=error                  # Function REAL LENGTH
 
194
func_odbc_length_without_space=yes      # Function ODBC LENGTH
 
195
func_odbc_locate_2=yes                  # Function LOCATE(2 arg)
 
196
func_odbc_locate_3=yes                  # Function LOCATE(3 arg)
 
197
func_odbc_log=yes                       # Function LOG
 
198
func_odbc_log10=yes                     # Function LOG10
 
199
func_odbc_ltrim=yes                     # Function LTRIM
 
200
func_odbc_minute=yes                    # Function MINUTE
 
201
func_odbc_mod=yes                       # Function MOD
 
202
func_odbc_month=yes                     # Function MONTH
 
203
func_odbc_monthname=yes                 # Function MONTHNAME
 
204
func_odbc_now=yes                       # Function NOW
 
205
func_odbc_pi=yes                        # Function PI
 
206
func_odbc_power=yes                     # Function POWER
 
207
func_odbc_quarter=yes                   # Function QUARTER
 
208
func_odbc_radians=error                 # Function RADIANS
 
209
func_odbc_rand=yes                      # Function RAND
 
210
func_odbc_repeat=yes                    # Function REPEAT
 
211
func_odbc_replace=yes                   # Function REPLACE
 
212
func_odbc_right=yes                     # Function RIGHT
 
213
func_odbc_round=yes                     # Function ROUND(2 arg)
 
214
func_odbc_rtrim=yes                     # Function RTRIM
 
215
func_odbc_second=yes                    # Function SECOND
 
216
func_odbc_sign=yes                      # Function SIGN
 
217
func_odbc_sin=yes                       # Function SIN
 
218
func_odbc_soundex=yes                   # Function SOUNDEX
 
219
func_odbc_space=yes                     # Function SPACE
 
220
func_odbc_sqrt=yes                      # Function SQRT
 
221
func_odbc_substring=yes                 # Function ODBC SUBSTRING
 
222
func_odbc_tan=yes                       # Function TAN
 
223
func_odbc_timestampadd=error            # Function TIMESTAMPADD
 
224
func_odbc_timestampdiff=error           # Function TIMESTAMPDIFF
 
225
func_odbc_truncate=yes                  # Function TRUNCATE
 
226
func_odbc_ucase=yes                     # Function UCASE
 
227
func_odbc_user()=yes                    # Function USER()
 
228
func_odbc_week=yes                      # Function WEEK
 
229
func_odbc_year=yes                      # Function YEAR
 
230
func_sql_+=yes                          # Function +, -, * and /
 
231
func_sql_bit_length=no                  # Function BIT_LENGTH
 
232
func_sql_cast=yes                       # Function CAST
 
233
func_sql_char_length=no                 # Function CHAR_LENGTH
 
234
func_sql_char_length(constant)=no       # Function CHAR_LENGTH(constant)
 
235
func_sql_character_length=no            # Function CHARACTER_LENGTH
 
236
func_sql_coalesce=yes                   # Function COALESCE
 
237
func_sql_concat_as_||=no                # Function concatenation with ||
 
238
func_sql_current_date=no                # Function CURRENT_DATE
 
239
func_sql_current_time=no                # Function CURRENT_TIME
 
240
func_sql_current_timestamp=yes          # Function CURRENT_TIMESTAMP
 
241
func_sql_current_user=yes               # Function CURRENT_USER
 
242
func_sql_extract_sql=no                 # Function EXTRACT
 
243
func_sql_localtime=no                   # Function LOCALTIME
 
244
func_sql_localtimestamp=no              # Function LOCALTIMESTAMP
 
245
func_sql_lower=yes                      # Function LOWER
 
246
func_sql_nullif=yes                     # Function NULLIF
 
247
func_sql_octet_length=no                # Function OCTET_LENGTH
 
248
func_sql_position=no                    # Function POSITION
 
249
func_sql_searched_case=yes              # Function searched CASE
 
250
func_sql_session_user=yes               # Function SESSION_USER
 
251
func_sql_simple_case=yes                # Function simple CASE
 
252
func_sql_substring=no                   # Function ANSI SQL SUBSTRING
 
253
func_sql_system_user=yes                # Function SYSTEM_USER
 
254
func_sql_trim=no                        # Function TRIM
 
255
func_sql_upper=yes                      # Function UPPER
 
256
func_sql_user=yes                       # Function USER
 
257
func_where_between=yes                  # Function BETWEEN
 
258
func_where_eq_all=yes                   # Function = ALL
 
259
func_where_eq_any=yes                   # Function = ANY
 
260
func_where_eq_some=yes                  # Function = SOME
 
261
func_where_exists=yes                   # Function EXISTS
 
262
func_where_in_num=yes                   # Function IN on numbers
 
263
func_where_like=yes                     # Function LIKE
 
264
func_where_like_escape=yes              # Function LIKE ESCAPE
 
265
func_where_match=no                     # Function MATCH
 
266
func_where_match_unique=no              # Function MATCH UNIQUE
 
267
func_where_matches=no                   # Function MATCHES
 
268
func_where_not_between=yes              # Function NOT BETWEEN
 
269
func_where_not_exists=yes               # Function NOT EXISTS
 
270
func_where_not_like=yes                 # Function NOT LIKE
 
271
func_where_not_unique=no                # Function NOT UNIQUE
 
272
func_where_unique=no                    # Function UNIQUE
 
273
functions=yes                           # Functions
 
274
group_by=yes                            # Group by
 
275
group_by_alias=no                       # Group by alias
 
276
group_by_null=yes                       # group on column with null values
 
277
group_by_position=no                    # Group by position
 
278
group_distinct_functions=yes            # Group functions with distinct
 
279
group_func_extra_bit_and=no             # Group function BIT_AND
 
280
group_func_extra_bit_or=no              # Group function BIT_OR
 
281
group_func_extra_count_distinct_list=no # Group function COUNT(DISTINCT expr,expr,...)
 
282
group_func_extra_std=no                 # Group function STD
 
283
group_func_extra_stddev=no              # Group function STDDEV
 
284
group_func_extra_variance=no            # Group function VARIANCE
 
285
group_func_sql_avg=yes                  # Group function AVG
 
286
group_func_sql_count_*=yes              # Group function COUNT (*)
 
287
group_func_sql_count_column=yes         # Group function COUNT column name
 
288
group_func_sql_count_distinct=yes       # Group function COUNT(DISTINCT expr)
 
289
group_func_sql_max=yes                  # Group function MAX on numbers
 
290
group_func_sql_max_str=yes              # Group function MAX on strings
 
291
group_func_sql_min=yes                  # Group function MIN on numbers
 
292
group_func_sql_min_str=yes              # Group function MIN on strings
 
293
group_func_sql_sum=yes                  # Group function SUM
 
294
group_functions=yes                     # Group functions
 
295
has_true_false=no                       # TRUE and FALSE
 
296
having=yes                              # Having
 
297
having_with_alias=no                    # Having on alias
 
298
having_with_group=yes                   # Having with group function
 
299
hex_numbers=yes                         # hex numbers (0x41)
 
300
hex_strings=no                          # hex strings (x'1ace')
 
301
ignore_end_space=yes                    # ignore end space in compare
 
302
index_in_create=no                      # index in create table
 
303
index_namespace=yes                     # different namespace for index
 
304
index_parts=no                          # index on column part (extension)
 
305
inner_join=yes                          # inner join
 
306
insert_empty_string=yes                 # insert empty string
 
307
insert_select=yes                       # insert INTO ... SELECT ...
 
308
insert_with_set=no                      # INSERT with set syntax
 
309
intersect=no                            # intersect
 
310
intersect_all=no                        # intersect all
 
311
intersect_all_incompat=no               # intersect all (incompatible lists)
 
312
intersect_incompat=no                   # intersect (incompatible lists)
 
313
join_tables=+64                         # tables in join
 
314
left_outer_join=yes                     # left outer join
 
315
left_outer_join_using=no                # left outer join using
 
316
like_with_column=yes                    # column LIKE column
 
317
like_with_number=yes                    # LIKE on numbers
 
318
lock_tables=no                          # lock table
 
319
logical_value=not supported             # Value of logical operation (1=1)
 
320
max_big_expressions=7                   # big expressions
 
321
max_char_size=8000                      # max char() size
 
322
max_column_name=128                     # column name length
 
323
max_columns=1024                        # Columns in table
 
324
max_conditions=10922                    # OR and AND in WHERE
 
325
max_expressions=2783                    # simple expressions
 
326
max_index=+64                           # max index
 
327
max_index_length=900                    # index length
 
328
max_index_name=128                      # index name length
 
329
max_index_part_length=900               # max index part length
 
330
max_index_parts=16                      # index parts
 
331
max_index_varchar_part_length=900       # index varchar part length
 
332
max_row_length=8036                     # max table row length (without blobs)
 
333
max_row_length_with_null=8036           # table row length with nulls (without blobs)
 
334
max_select_alias_name=128               # select alias name length
 
335
max_stack_expression=164                # stacked expressions
 
336
max_table_alias_name=128                # table alias name length
 
337
max_table_name=128                      # table name length
 
338
max_text_size=+8000000                  # max text or blob size
 
339
max_unique_index=+64                    # unique indexes
 
340
max_varchar_size=8000                   # max varchar() size
 
341
minus=yes                               # minus
 
342
minus_incompat=yes                      # minus (incompatible lists)
 
343
minus_neg=no                            # Calculate 1--1
 
344
multi_drop=no                           # many tables to drop table
 
345
multi_strings=no                        # Multiple line strings
 
346
multi_table_delete=no                   # DELETE FROM table1,table2...
 
347
multi_table_update=no                   # Update with many tables
 
348
multi_value_insert=no                   # Value lists in INSERT
 
349
natural_join=no                         # natural join
 
350
natural_join_incompat=no                # natural join (incompatible lists)
 
351
natural_left_outer_join=no              # natural left outer join
 
352
no_primary_key=yes                      # Tables without primary key
 
353
null_concat_expr=no                     # Is concat('a',NULL) = NULL
 
354
null_in_index=yes                       # null in index
 
355
null_in_unique=no                       # null in unique index
 
356
null_num_expr=yes                       # Is 1+NULL = NULL
 
357
odbc_left_outer_join=yes                # left outer join odbc style
 
358
operating_system=Microsoft Windows 2000 [Version 5.00.2195]     # crash-me tested on
 
359
order_by=yes                            # Order by
 
360
order_by_alias=yes                      # Order by alias
 
361
order_by_function=yes                   # Order by function
 
362
order_by_position=yes                   # Order by position
 
363
order_by_remember_desc=no               # Order by DESC is remembered
 
364
primary_key_in_create=yes               # primary key in create table
 
365
psm_functions=no                        # PSM functions (ANSI SQL)
 
366
psm_modules=no                          # PSM modules (ANSI SQL)
 
367
psm_procedures=no                       # PSM procedures (ANSI SQL)
 
368
psm_trigger=no                          # Triggers (ANSI SQL)
 
369
query_size=16777216                     # query size
 
370
quote_ident_with_"=yes                  # " as identifier quote (ANSI SQL)
 
371
quote_ident_with_[=yes                  # [] as identifier quote
 
372
quote_ident_with_`=no                   # ` as identifier quote
 
373
quote_with_"=no                         # Allows ' and " as string markers
 
374
recursive_subqueries=40                 # recursive subqueries
 
375
remember_end_space=no                   # Remembers end space in char()
 
376
remember_end_space_varchar=yes          # Remembers end space in varchar()
 
377
repeat_string_size=8000                 # return string size from function
 
378
right_outer_join=yes                    # right outer join
 
379
rowid=no                                # Type for row id
 
380
select_constants=yes                    # Select constants
 
381
select_limit=with TOP                   # LIMIT number of rows
 
382
select_limit2=no                        # SELECT with LIMIT #,#
 
383
select_string_size=16777207             # constant string size in SELECT
 
384
select_table_update=yes                 # Update with sub select
 
385
select_without_from=yes                 # SELECT without FROM
 
386
server_version=Microsoft SQL Server  7.00 - 7.00.842 (Intel X86)        # server version
 
387
simple_joins=yes                        # ANSI SQL simple joins
 
388
storage_of_float=round                  # Storage of float values
 
389
subqueries=yes                          # subqueries
 
390
table_alias=yes                         # Table alias
 
391
table_name_case=yes                     # case independent table names
 
392
table_wildcard=yes                      # Select table_name.*
 
393
tempoary_table=no                       # temporary tables
 
394
transactions=yes                        # transactions
 
395
type_extra_abstime=no                   # Type abstime
 
396
type_extra_bfile=no                     # Type bfile
 
397
type_extra_blob=no                      # Type blob
 
398
type_extra_bool=no                      # Type bool
 
399
type_extra_box=no                       # Type box
 
400
type_extra_byte=no                      # Type byte
 
401
type_extra_char(1_arg)_binary=no        # Type char(1 arg) binary
 
402
type_extra_circle=no                    # Type circle
 
403
type_extra_clob=no                      # Type clob
 
404
type_extra_datetime=yes                 # Type datetime
 
405
type_extra_double=no                    # Type double
 
406
type_extra_enum(1_arg)=no               # Type enum(1 arg)
 
407
type_extra_float(2_arg)=no              # Type float(2 arg)
 
408
type_extra_float4=no                    # Type float4
 
409
type_extra_float8=no                    # Type float8
 
410
type_extra_image=yes                    # Type image
 
411
type_extra_int(1_arg)_zerofill=no       # Type int(1 arg) zerofill
 
412
type_extra_int1=no                      # Type int1
 
413
type_extra_int2=no                      # Type int2
 
414
type_extra_int3=no                      # Type int3
 
415
type_extra_int4=no                      # Type int4
 
416
type_extra_int8=no                      # Type int8
 
417
type_extra_int_auto_increment=no        # Type int not null auto_increment
 
418
type_extra_int_identity=yes             # Type int not null identity
 
419
type_extra_int_unsigned=no              # Type int unsigned
 
420
type_extra_interval=no                  # Type interval
 
421
type_extra_line=no                      # Type line
 
422
type_extra_long=no                      # Type long
 
423
type_extra_long_raw=no                  # Type long raw
 
424
type_extra_long_varbinary=no            # Type long varbinary
 
425
type_extra_long_varchar(1_arg)=no       # Type long varchar(1 arg)
 
426
type_extra_lseg=no                      # Type lseg
 
427
type_extra_mediumint=no                 # Type mediumint
 
428
type_extra_mediumtext=no                # Type mediumtext
 
429
type_extra_middleint=no                 # Type middleint
 
430
type_extra_mlslabel=no                  # Type mlslabel
 
431
type_extra_money=yes                    # Type money
 
432
type_extra_nclob=no                     # Type nclob
 
433
type_extra_number=no                    # Type number
 
434
type_extra_number(1_arg)=no             # Type number(1 arg)
 
435
type_extra_number(2_arg)=no             # Type number(2 arg)
 
436
type_extra_nvarchar2(1_arg)=no          # Type nvarchar2(1 arg)
 
437
type_extra_path=no                      # Type path
 
438
type_extra_point=no                     # Type point
 
439
type_extra_polygon=no                   # Type polygon
 
440
type_extra_raw(1_arg)=no                # Type raw(1 arg)
 
441
type_extra_reltime=no                   # Type reltime
 
442
type_extra_rowid=no                     # Type rowid
 
443
type_extra_serial=no                    # Type serial
 
444
type_extra_set(1_arg)=no                # Type set(1 arg)
 
445
type_extra_smalldatetime=yes            # Type smalldatetime
 
446
type_extra_smallfloat=no                # Type smallfloat
 
447
type_extra_smallmoney=yes               # Type smallmoney
 
448
type_extra_text=yes                     # Type text
 
449
type_extra_text(1_arg)=no               # Type text(1 arg)
 
450
type_extra_timespan=no                  # Type timespan
 
451
type_extra_uint=no                      # Type uint
 
452
type_extra_varchar2(1_arg)=no           # Type varchar2(1 arg)
 
453
type_extra_year=no                      # Type year
 
454
type_odbc_bigint=no                     # Type bigint
 
455
type_odbc_binary(1_arg)=yes             # Type binary(1 arg)
 
456
type_odbc_datetime=yes                  # Type datetime
 
457
type_odbc_tinyint=yes                   # Type tinyint
 
458
type_odbc_varbinary(1_arg)=yes          # Type varbinary(1 arg)
 
459
type_sql_bit=yes                        # Type bit
 
460
type_sql_bit(1_arg)=no                  # Type bit(1 arg)
 
461
type_sql_bit_varying(1_arg)=no          # Type bit varying(1 arg)
 
462
type_sql_char(1_arg)=yes                # Type char(1 arg)
 
463
type_sql_char_varying(1_arg)=yes        # Type char varying(1 arg)
 
464
type_sql_character(1_arg)=yes           # Type character(1 arg)
 
465
type_sql_character_varying(1_arg)=yes   # Type character varying(1 arg)
 
466
type_sql_date=no                        # Type date
 
467
type_sql_dec(2_arg)=yes                 # Type dec(2 arg)
 
468
type_sql_decimal(2_arg)=yes             # Type decimal(2 arg)
 
469
type_sql_double_precision=yes           # Type double precision
 
470
type_sql_float=yes                      # Type float
 
471
type_sql_float(1_arg)=yes               # Type float(1 arg)
 
472
type_sql_int=yes                        # Type int
 
473
type_sql_integer=yes                    # Type integer
 
474
type_sql_interval_day=no                # Type interval day
 
475
type_sql_interval_day_to_hour=no        # Type interval day to hour
 
476
type_sql_interval_day_to_minute=no      # Type interval day to minute
 
477
type_sql_interval_day_to_second=no      # Type interval day to second
 
478
type_sql_interval_hour=no               # Type interval hour
 
479
type_sql_interval_hour_to_minute=no     # Type interval hour to minute
 
480
type_sql_interval_hour_to_second=no     # Type interval hour to second
 
481
type_sql_interval_minute=no             # Type interval minute
 
482
type_sql_interval_minute_to_second=no   # Type interval minute to second
 
483
type_sql_interval_month=no              # Type interval month
 
484
type_sql_interval_second=no             # Type interval second
 
485
type_sql_interval_year=no               # Type interval year
 
486
type_sql_interval_year_to_month=no      # Type interval year to month
 
487
type_sql_national_char_varying(1_arg)=yes       # Type national char varying(1 arg)
 
488
type_sql_national_character(1_arg)=yes  # Type national character(1 arg)
 
489
type_sql_national_character_varying(1_arg)=yes  # Type national character varying(1 arg)
 
490
type_sql_nchar(1_arg)=yes               # Type nchar(1 arg)
 
491
type_sql_nchar_varying(1_arg)=yes       # Type nchar varying(1 arg)
 
492
type_sql_numeric(2_arg)=yes             # Type numeric(2 arg)
 
493
type_sql_real=yes                       # Type real
 
494
type_sql_smallint=yes                   # Type smallint
 
495
type_sql_time=no                        # Type time
 
496
type_sql_timestamp=yes                  # Type timestamp
 
497
type_sql_timestamp_with_time_zone=no    # Type timestamp with time zone
 
498
type_sql_varchar(1_arg)=yes             # Type varchar(1 arg)
 
499
union=yes                               # union
 
500
union_all=yes                           # union all
 
501
union_all_incompat=yes                  # union all (incompatible lists)
 
502
union_incompat=yes                      # union (incompatible lists)
 
503
unique_in_create=yes                    # unique in create table
 
504
unique_null_in_create=no                # unique null in create
 
505
views=yes                               # views
 
506
where_string_size=8000                  # constant string size in where