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