~tsarev/dbqp/dbqp_out_of_source

« back to all changes in this revision

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

  • Committer: patrick crews
  • Date: 2011-10-05 20:26:34 UTC
  • Revision ID: gleebix@gmail.com-20111005202634-2q6baxxvbfuhmdzy
Initial branch

Show diffs side-by-side

added added

removed removed

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