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