~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to tests/sql-bench/limits/interbase-dialect3.cfg

  • Committer: Package Import Robot
  • Author(s): Dmitrijs Ledkovs
  • Date: 2013-10-29 15:43:40 UTC
  • mfrom: (1.2.12) (2.1.19 trusty-proposed)
  • Revision ID: package-import@ubuntu.com-20131029154340-2gp39el6cv8bwf2o
Tags: 1:7.2.3-2ubuntu1
* Merge from debian, remaining changes:
  - Link against boost_system because of boost_thread.
  - Add required libs to message/include.am
  - Add upstart job and adjust init script to be upstart compatible.
  - Disable -floop-parallelize-all due to gcc-4.8/4.9 compiler ICE
    http://gcc.gnu.org/bugzilla/show_bug.cgi?id=57732

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