summaryrefslogtreecommitdiffstats
path: root/sql-bench/limits/mimer.cfg
blob: b3369f9a622da2bbe3153da5f75ea506687d85b3 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
#This file is automaticly generated by crash-me 1.38

NEG=yes					# update of column= -column
alter_add_col=yes			# Alter table add column
alter_add_constraint=yes		# Alter table add constraint
alter_add_foreign_key=yes		# Alter table add foreign key
alter_add_multi_col=yes			# Alter table add many columns
alter_add_primary_key=yes		# Alter table add primary key
alter_add_unique=yes			# Alter table add unique
alter_alter_col=yes			# Alter table alter column default
alter_change_col=no			# Alter table change column
alter_drop_col=yes			# Alter table drop column
alter_drop_constraint=yes		# Alter table drop constraint
alter_drop_foreign_key=yes		# Alter table drop foreign key
alter_drop_primary_key=yes		# Alter table drop primary key
alter_drop_unique=yes			# Alter table drop unique
alter_modify_col=no			# Alter table modify column
alter_rename_table=no			# Alter table rename table
atomic_updates=yes			# atomic updates
atomic_updates_with_rollback=yes	# atomic_updates_with_rollback
automatic_rowid=no			# Automatic rowid
binary_items=yes			# binary items (0x41)
case_insensitive_strings=no		# case insensitive compare
char_is_space_filled=yes		# char are space filled
column_alias=yes			# Column alias
columns_in_group_by=+64			# number of columns in group by
columns_in_order_by=+64			# number of columns in order by
comment_#=no				# # as comment
comment_--=yes				# -- as comment
comment_/**/=no				# /* */ as comment
comment_//=no				# // as comment
compute=no				# Compute
connections=50				# Simultaneous connections
constraint_check=yes			# Column constraints
constraint_check_table=yes		# Table constraints
constraint_null=no			# NULL constraint (SyBase style)
crash_me_safe=yes			# crash me safe
crash_me_version=1.38			# crash me version
create_default=yes			# default value for column
create_default_func=no			# default value function for column
create_if_not_exists=no			# create table if not exists
create_index=yes			# create index
create_schema=yes			# Create SCHEMA
create_table_select=no			# create table from select
cross_join=no				# cross join (same as from a,b)
date_as_string=no			# String functions on date columns
date_last=yes				# Supports 9999-12-31 dates
date_one=yes				# Supports 0001-01-01 dates
date_with_YY=no				# Supports YY-MM-DD dates
date_zero=no				# Supports 0000-00-00 dates
domains=yes				# Domains (ANSI SQL)
double_quotes=yes			# Double '' as ' in strings
drop_if_exists=no			# drop table if exists
drop_index=yes				# drop index
end_colon=yes				# allows end ';'
except=no				# except
except_all=no				# except all
float_int_expr=yes			# mixing of integer and float in expression
foreign_key=yes				# foreign keys
foreign_key_circular=yes		# Circular foreign keys
foreign_key_syntax=yes			# foreign key syntax
full_outer_join=no			# full outer join
func_extra_!=no				# Function NOT as '!' in SELECT
func_extra_%=no				# Function MOD as %
func_extra_&=no				# Function & (bitwise and)
func_extra_&&=no			# Function AND as '&&'
func_extra_<>=no			# Function <> in SELECT
func_extra_==no				# Function =
func_extra_add_months=no		# Function ADD_MONTHS
func_extra_and_or=no			# Function AND and OR in SELECT
func_extra_ascii_char=yes		# Function ASCII_CHAR
func_extra_ascii_code=yes		# Function ASCII_CODE
func_extra_atn2=no			# Function ATN2
func_extra_auto_num2string=no		# Function automatic num->string convert
func_extra_auto_string2num=no		# Function automatic string->num convert
func_extra_between=no			# Function BETWEEN in SELECT
func_extra_binary_shifts=no		# Function << and >> (bitwise shifts)
func_extra_bit_count=no			# Function BIT_COUNT
func_extra_ceil=no			# Function CEIL
func_extra_charindex=no			# Function CHARINDEX
func_extra_chr=no			# Function CHR
func_extra_concat_as_+=no		# Function concatenation with +
func_extra_concat_list=no		# Function CONCAT(list)
func_extra_convert=no			# Function CONVERT
func_extra_cosh=no			# Function COSH
func_extra_date_format=no		# Function DATE_FORMAT
func_extra_dateadd=no			# Function DATEADD
func_extra_datediff=no			# Function DATEDIFF
func_extra_datename=no			# Function DATENAME
func_extra_datepart=no			# Function DATEPART
func_extra_elt=no			# Function ELT
func_extra_encrypt=no			# Function ENCRYPT
func_extra_field=no			# Function FIELD
func_extra_format=no			# Function FORMAT
func_extra_from_days=no			# Function FROM_DAYS
func_extra_from_unixtime=no		# Function FROM_UNIXTIME
func_extra_getdate=no			# Function GETDATE
func_extra_greatest=no			# Function GREATEST
func_extra_if=no			# Function IF
func_extra_in_num=no			# Function IN on numbers in SELECT
func_extra_in_str=no			# Function IN on strings in SELECT
func_extra_initcap=no			# Function INITCAP
func_extra_instr=no			# Function LOCATE as INSTR
func_extra_instr_oracle=no		# Function INSTR (Oracle syntax)
func_extra_instrb=no			# Function INSTRB
func_extra_interval=no			# Function INTERVAL
func_extra_last_day=no			# Function LAST_DAY
func_extra_last_insert_id=no		# Function LAST_INSERT_ID
func_extra_least=no			# Function LEAST
func_extra_lengthb=no			# Function LENGTHB
func_extra_like=no			# Function LIKE in SELECT
func_extra_like_escape=no		# Function LIKE ESCAPE in SELECT
func_extra_ln=no			# Function LN
func_extra_log(m_n)=no			# Function LOG(m,n)
func_extra_logn=no			# Function LOGN
func_extra_lpad=no			# Function LPAD
func_extra_mdy=no			# Function MDY
func_extra_mid=no			# Function SUBSTRING as MID
func_extra_months_between=no		# Function MONTHS_BETWEEN
func_extra_not=no			# Function NOT in SELECT
func_extra_not_between=no		# Function NOT BETWEEN in SELECT
func_extra_not_like=no			# Function NOT LIKE in SELECT
func_extra_odbc_convert=no		# Function ODBC CONVERT
func_extra_password=no			# Function PASSWORD
func_extra_paste=yes			# Function PASTE
func_extra_patindex=no			# Function PATINDEX
func_extra_period_add=no		# Function PERIOD_ADD
func_extra_period_diff=no		# Function PERIOD_DIFF
func_extra_pow=no			# Function POW
func_extra_range=no			# Function RANGE
func_extra_regexp=no			# Function REGEXP in SELECT
func_extra_replicate=no			# Function REPLICATE
func_extra_reverse=no			# Function REVERSE
func_extra_root=no			# Function ROOT
func_extra_round1=no			# Function ROUND(1 arg)
func_extra_rpad=no			# Function RPAD
func_extra_sec_to_time=no		# Function SEC_TO_TIME
func_extra_sinh=no			# Function SINH
func_extra_str=no			# Function STR
func_extra_strcmp=no			# Function STRCMP
func_extra_stuff=no			# Function STUFF
func_extra_substrb=no			# Function SUBSTRB
func_extra_substring_index=no		# Function SUBSTRING_INDEX
func_extra_sysdate=no			# Function SYSDATE
func_extra_tail=yes			# Function TAIL
func_extra_tanh=no			# Function TANH
func_extra_time_to_sec=no		# Function TIME_TO_SEC
func_extra_to_days=no			# Function TO_DAYS
func_extra_translate=no			# Function TRANSLATE
func_extra_trim_many_char=no		# Function TRIM; Many char extension
func_extra_trim_substring=no		# Function TRIM; Substring extension
func_extra_trunc=no			# Function TRUNC
func_extra_uid=no			# Function UID
func_extra_unix_timestamp=no		# Function UNIX_TIMESTAMP
func_extra_userenv=no			# Function USERENV
func_extra_version=no			# Function VERSION
func_extra_weekday=no			# Function WEEKDAY
func_extra_|=no				# Function | (bitwise or)
func_extra_||=no			# Function OR as '||'
func_odbc_abs=yes			# Function ABS
func_odbc_acos=yes			# Function ACOS
func_odbc_ascii=yes			# Function ASCII
func_odbc_asin=yes			# Function ASIN
func_odbc_atan=yes			# Function ATAN
func_odbc_atan2=yes			# Function ATAN2
func_odbc_ceiling=yes			# Function CEILING
func_odbc_char=yes			# Function CHAR
func_odbc_concat=yes			# Function CONCAT(2 arg)
func_odbc_cos=yes			# Function COS
func_odbc_cot=yes			# Function COT
func_odbc_curdate=yes			# Function CURDATE
func_odbc_curtime=yes			# Function CURTIME
func_odbc_database=yes			# Function DATABASE
func_odbc_dayname=yes			# Function DAYNAME
func_odbc_dayofmonth=yes		# Function DAYOFMONTH
func_odbc_dayofweek=yes			# Function DAYOFWEEK
func_odbc_dayofyear=yes			# Function DAYOFYEAR
func_odbc_degrees=yes			# Function DEGREES
func_odbc_difference=yes		# Function DIFFERENCE()
func_odbc_exp=yes			# Function EXP
func_odbc_extract=yes			# Function EXTRACT
func_odbc_floor=yes			# Function FLOOR
func_odbc_fn_left=yes			# Function ODBC syntax LEFT & RIGHT
func_odbc_hour=yes			# Function HOUR
func_odbc_hour_time=yes			# Function ANSI HOUR
func_odbc_ifnull=yes			# Function IFNULL
func_odbc_insert=yes			# Function INSERT
func_odbc_lcase=yes			# Function LCASE
func_odbc_left=yes			# Function LEFT
func_odbc_length=error			# Function REAL LENGTH
func_odbc_length_without_space=yes	# Function ODBC LENGTH
func_odbc_locate_2=yes			# Function LOCATE(2 arg)
func_odbc_locate_3=yes			# Function LOCATE(3 arg)
func_odbc_log=yes			# Function LOG
func_odbc_log10=yes			# Function LOG10
func_odbc_ltrim=yes			# Function LTRIM
func_odbc_minute=yes			# Function MINUTE
func_odbc_mod=yes			# Function MOD
func_odbc_month=yes			# Function MONTH
func_odbc_monthname=yes			# Function MONTHNAME
func_odbc_now=yes			# Function NOW
func_odbc_pi=yes			# Function PI
func_odbc_power=yes			# Function POWER
func_odbc_quarter=yes			# Function QUARTER
func_odbc_radians=yes			# Function RADIANS
func_odbc_rand=yes			# Function RAND
func_odbc_repeat=yes			# Function REPEAT
func_odbc_replace=yes			# Function REPLACE
func_odbc_right=yes			# Function RIGHT
func_odbc_round=yes			# Function ROUND(2 arg)
func_odbc_rtrim=yes			# Function RTRIM
func_odbc_second=yes			# Function SECOND
func_odbc_sign=yes			# Function SIGN
func_odbc_sin=yes			# Function SIN
func_odbc_soundex=yes			# Function SOUNDEX
func_odbc_space=yes			# Function SPACE
func_odbc_sqrt=yes			# Function SQRT
func_odbc_substring=yes			# Function ODBC SUBSTRING
func_odbc_tan=yes			# Function TAN
func_odbc_timestampadd=yes		# Function TIMESTAMPADD
func_odbc_timestampdiff=yes		# Function TIMESTAMPDIFF
func_odbc_truncate=yes			# Function TRUNCATE
func_odbc_ucase=yes			# Function UCASE
func_odbc_user()=yes			# Function USER()
func_odbc_week=yes			# Function WEEK
func_odbc_year=yes			# Function YEAR
func_sql_+=yes				# Function +, -, * and /
func_sql_bit_length=yes			# Function BIT_LENGTH
func_sql_cast=yes			# Function CAST
func_sql_char_length=yes		# Function CHAR_LENGTH
func_sql_char_length(constant)=yes	# Function CHAR_LENGTH(constant)
func_sql_character_length=yes		# Function CHARACTER_LENGTH
func_sql_coalesce=yes			# Function COALESCE
func_sql_concat_as_||=yes		# Function concatenation with ||
func_sql_current_date=yes		# Function CURRENT_DATE
func_sql_current_time=yes		# Function CURRENT_TIME
func_sql_current_timestamp=yes		# Function CURRENT_TIMESTAMP
func_sql_current_user=yes		# Function CURRENT_USER
func_sql_extract_sql=yes		# Function EXTRACT
func_sql_localtime=yes			# Function LOCALTIME
func_sql_localtimestamp=yes		# Function LOCALTIMESTAMP
func_sql_lower=yes			# Function LOWER
func_sql_nullif=yes			# Function NULLIF
func_sql_octet_length=yes		# Function OCTET_LENGTH
func_sql_position=yes			# Function POSITION
func_sql_searched_case=yes		# Function searched CASE
func_sql_session_user=yes		# Function SESSION_USER
func_sql_simple_case=yes		# Function simple CASE
func_sql_substring=yes			# Function ANSI SQL SUBSTRING
func_sql_system_user=yes		# Function SYSTEM_USER
func_sql_trim=yes			# Function TRIM
func_sql_upper=yes			# Function UPPER
func_sql_user=yes			# Function USER
func_where_between=yes			# Function BETWEEN
func_where_eq_all=yes			# Function = ALL
func_where_eq_any=yes			# Function = ANY
func_where_eq_some=yes			# Function = SOME
func_where_exists=yes			# Function EXISTS
func_where_in_num=yes			# Function IN on numbers
func_where_like=yes			# Function LIKE
func_where_like_escape=yes		# Function LIKE ESCAPE
func_where_match=no			# Function MATCH
func_where_match_unique=no		# Function MATCH UNIQUE
func_where_matches=no			# Function MATCHES
func_where_not_between=yes		# Function NOT BETWEEN
func_where_not_exists=yes		# Function NOT EXISTS
func_where_not_like=yes			# Function NOT LIKE
func_where_not_unique=no		# Function NOT UNIQUE
func_where_unique=no			# Function UNIQUE
functions=yes				# Functions
group_by=yes				# Group by
group_by_alias=no			# Group by alias
group_by_null=yes			# group on column with null values
group_by_position=no			# Group by position
group_distinct_functions=yes		# Group functions with distinct
group_func_extra_bit_and=no		# Group function BIT_AND
group_func_extra_bit_or=no		# Group function BIT_OR
group_func_extra_count_distinct_list=no	# Group function COUNT(DISTINCT expr,expr,...)
group_func_extra_std=no			# Group function STD
group_func_extra_stddev=no		# Group function STDDEV
group_func_extra_variance=no		# Group function VARIANCE
group_func_sql_avg=yes			# Group function AVG
group_func_sql_count_*=yes		# Group function COUNT (*)
group_func_sql_count_column=yes		# Group function COUNT column name
group_func_sql_count_distinct=yes	# Group function COUNT(DISTINCT expr)
group_func_sql_max=yes			# Group function MAX on numbers
group_func_sql_max_str=yes		# Group function MAX on strings
group_func_sql_min=yes			# Group function MIN on numbers
group_func_sql_min_str=yes		# Group function MIN on strings
group_func_sql_sum=yes			# Group function SUM
group_functions=yes			# Group functions
having=yes				# Having
having_with_alias=no			# Having on alias
having_with_group=yes			# Having with group function
ignore_end_space=yes			# ignore end space in compare
index_in_create=no			# index in create table
index_namespace=no			# different namespace for index
index_parts=no				# index on column part (extension)
insert_empty_string=yes			# insert empty string
insert_select=yes			# insert INTO ... SELECT ...
insert_with_set=no			# INSERT with set syntax
intersect=no				# intersect
intersect_all=no			# intersect all
join_tables=+64				# tables in join
left_outer_join=yes			# left outer join
left_outer_join_using=yes		# left outer join using
like_with_column=yes			# column LIKE column
like_with_number=no			# LIKE on numbers
lock_tables=no				# lock table
logical_value=not supported		# Value of logical operation (1=1)
max_big_expressions=10			# big expressions
max_char_size=15000			# max char() size
max_column_name=128			# column name length
max_columns=252				# Columns in table
max_conditions=1020			# OR and AND in WHERE
max_expressions=1019			# simple expressions
max_index=+64				# max index
max_index_length=+8192			# index length
max_index_name=128			# index name length
max_index_part_length=15000		# max index part length
max_index_parts=32			# index parts
max_index_varchar_part_length=15000	# index varchar part length
max_row_length=15925			# max table row length (without blobs)
max_row_length_with_null=15925		# table row length with nulls (without blobs)
max_select_alias_name=128		# select alias name length
max_stack_expression=62			# stacked expressions
max_table_alias_name=128		# table alias name length
max_table_name=128			# table name length
max_unique_index=+64			# unique indexes
max_varchar_size=15000			# max varchar() size
minus=no				# minus
minus_neg=no				# Calculate 1--1
multi_drop=no				# many tables to drop table
multi_strings=yes			# Multiple line strings
multi_table_delete=no			# DELETE FROM table1,table2...
multi_table_update=no			# Update with many tables
insert_multi_value=no			# Value lists in INSERT
natural_join=yes			# natural join
natural_left_outer_join=yes		# natural left outer join
no_primary_key=yes			# Tables without primary key
null_concat_expr=yes			# Is 'a' || cast(NULL as char(1)) = NULL
null_in_index=yes			# null in index
null_in_unique=yes			# null in unique
null_num_expr=yes			# Is 1+NULL = NULL
odbc_left_outer_join=yes		# left outer join odbc style
operating_system=Windows NT 4.0		# crash-me tested on
order_by=yes				# Order by
order_by_alias=yes			# Order by alias
order_by_function=no			# Order by function
order_by_position=yes			# Order by position
order_by_remember_desc=no		# Order by DESC is remembered
primary_key_in_create=yes		# primary key in create table
psm_functions=yes			# PSM functions (ANSI SQL)
psm_modules=yes				# PSM modules (ANSI SQL)
psm_procedures=yes			# PSM procedures (ANSI SQL)
psm_trigger=yes				# Triggers (ANSI SQL)
query_size=16777216			# query size
quote_ident_with_"=yes			# " as identifier quote (ANSI SQL)
quote_ident_with_[=no			# [] as identifier quote
quote_ident_with_`=no			# ` as identifier quote
quote_with_"=no				# Allows ' and " as string markers
recursive_subqueries=15			# recursive subqueries
remember_end_space=no			# Remembers end space in char()
remember_end_space_varchar=yes		# Remembers end space in varchar()
repeat_string_size=15000		# return string size from function
right_outer_join=yes			# right outer join
round_on_store=error			# Correct rounding when storing float values
rowid=no				# Type for row id
select_constants=yes			# Select constants
select_limit=no				# SELECT with LIMIT
select_limit2=no			# SELECT with LIMIT #,#
select_string_size=15000		# constant string size in SELECT
select_table_update=no			# Update with sub select
select_without_from=no			# SELECT without FROM
server_version=MIMER 8.2.0C	  	# server version
simple_joins=yes			# ANSI SQL simple joins
subqueries=yes				# subqueries
table_alias=yes				# Table alias
table_name_case=yes			# case independent table names
table_wildcard=yes			# Select table_name.*
tempoary_table=no			# temporary tables
transactions=yes			# transactions
type_extra_abstime=no			# Type abstime
type_extra_bfile=no			# Type bfile
type_extra_blob=no			# Type blob
type_extra_bool=no			# Type bool
type_extra_box=no			# Type box
type_extra_byte=no			# Type byte
type_extra_char(1_arg)_binary=no	# Type char(1 arg) binary
type_extra_circle=no			# Type circle
type_extra_clob=no			# Type clob
type_extra_datetime=no			# Type datetime
type_extra_double=no			# Type double
type_extra_enum(1_arg)=no		# Type enum(1 arg)
type_extra_float(2_arg)=no		# Type float(2 arg)
type_extra_float4=no			# Type float4
type_extra_float8=no			# Type float8
type_extra_image=no			# Type image
type_extra_int(1_arg)_zerofill=no	# Type int(1 arg) zerofill
type_extra_int1=no			# Type int1
type_extra_int2=no			# Type int2
type_extra_int3=no			# Type int3
type_extra_int4=no			# Type int4
type_extra_int8=no			# Type int8
type_extra_int_auto_increment=no	# Type int not null auto_increment
type_extra_int_unsigned=no		# Type int unsigned
type_extra_interval=no			# Type interval
type_extra_line=no			# Type line
type_extra_long=no			# Type long
type_extra_long_raw=no			# Type long raw
type_extra_long_varbinary=no		# Type long varbinary
type_extra_long_varchar(1_arg)=no	# Type long varchar(1 arg)
type_extra_lseg=no			# Type lseg
type_extra_mediumint=no			# Type mediumint
type_extra_mediumtext=no		# Type mediumtext
type_extra_middleint=no			# Type middleint
type_extra_mlslabel=no			# Type mlslabel
type_extra_money=no			# Type money
type_extra_nclob=no			# Type nclob
type_extra_number=no			# Type number
type_extra_number(1_arg)=no		# Type number(1 arg)
type_extra_number(2_arg)=no		# Type number(2 arg)
type_extra_nvarchar2(1_arg)=no		# Type nvarchar2(1 arg)
type_extra_path=no			# Type path
type_extra_point=no			# Type point
type_extra_polygon=no			# Type polygon
type_extra_raw(1_arg)=no		# Type raw(1 arg)
type_extra_reltime=no			# Type reltime
type_extra_rowid=no			# Type rowid
type_extra_serial=no			# Type serial
type_extra_set(1_arg)=no		# Type set(1 arg)
type_extra_smalldatetime=no		# Type smalldatetime
type_extra_smallfloat=no		# Type smallfloat
type_extra_smallmoney=no		# Type smallmoney
type_extra_text=no			# Type text
type_extra_text(1_arg)=no		# Type text(1 arg)
type_extra_timespan=no			# Type timespan
type_extra_uint=no			# Type uint
type_extra_varchar2(1_arg)=no		# Type varchar2(1 arg)
type_extra_year=no			# Type year
type_odbc_bigint=yes			# Type bigint
type_odbc_binary(1_arg)=yes		# Type binary(1 arg)
type_odbc_datetime=no			# Type datetime
type_odbc_tinyint=no			# Type tinyint
type_odbc_varbinary(1_arg)=yes		# Type varbinary(1 arg)
type_sql_bit=no				# Type bit
type_sql_bit(1_arg)=no			# Type bit(1 arg)
type_sql_bit_varying(1_arg)=no		# Type bit varying(1 arg)
type_sql_char(1_arg)=yes		# Type char(1 arg)
type_sql_char_varying(1_arg)=yes	# Type char varying(1 arg)
type_sql_character(1_arg)=yes		# Type character(1 arg)
type_sql_character_varying(1_arg)=yes	# Type character varying(1 arg)
type_sql_date=yes			# Type date
type_sql_dec(2_arg)=yes			# Type dec(2 arg)
type_sql_decimal(2_arg)=yes		# Type decimal(2 arg)
type_sql_double_precision=yes		# Type double precision
type_sql_float=yes			# Type float
type_sql_float(1_arg)=yes		# Type float(1 arg)
type_sql_int=yes			# Type int
type_sql_integer=yes			# Type integer
type_sql_interval_day=yes		# Type interval day
type_sql_interval_day_to_hour=yes	# Type interval day to hour
type_sql_interval_day_to_minute=yes	# Type interval day to minute
type_sql_interval_day_to_second=yes	# Type interval day to second
type_sql_interval_hour=yes		# Type interval hour
type_sql_interval_hour_to_minute=yes	# Type interval hour to minute
type_sql_interval_hour_to_second=yes	# Type interval hour to second
type_sql_interval_minute=yes		# Type interval minute
type_sql_interval_minute_to_second=yes	# Type interval minute to second
type_sql_interval_month=yes		# Type interval month
type_sql_interval_second=yes		# Type interval second
type_sql_interval_year=yes		# Type interval year
type_sql_interval_year_to_month=yes	# Type interval year to month
type_sql_national_char_varying(1_arg)=no	# Type national char varying(1 arg)
type_sql_national_character(1_arg)=no	# Type national character(1 arg)
type_sql_national_character_varying(1_arg)=no	# Type national character varying(1 arg)
type_sql_nchar(1_arg)=no		# Type nchar(1 arg)
type_sql_nchar_varying(1_arg)=no	# Type nchar varying(1 arg)
type_sql_numeric(2_arg)=yes		# Type numeric(2 arg)
type_sql_real=yes			# Type real
type_sql_smallint=yes			# Type smallint
type_sql_time=yes			# Type time
type_sql_timestamp=yes			# Type timestamp
type_sql_timestamp_with_time_zone=no	# Type timestamp with time zone
type_sql_varchar(1_arg)=yes		# Type varchar(1 arg)
union=yes				# union
union_all=yes				# union all
unique_in_create=yes			# unique in create table
unique_null_in_create=yes		# unique null in create
views=yes				# views
where_string_size=15000			# constant string size in where