~drizzle-trunk/drizzle/development

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