~vadim-tk/percona-server/percona-galera-5.1.57-0.8.1

« back to all changes in this revision

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

  • Committer: root
  • Date: 2011-07-28 00:14:23 UTC
  • Revision ID: root@r815.office.percona.com-20110728001423-6pw0v4b7r0dkbsr4
Ported to Galera 0.8.1

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
#This file is automaticly generated by crash-me 1.57
 
2
 
 
3
NEG=yes                                 # update of column= -column
 
4
Need_cast_for_null=no                   # Need to cast NULL for arithmetic
 
5
alter_add_col=yes                       # Alter table add column
 
6
alter_add_constraint=yes                # Alter table add constraint
 
7
alter_add_foreign_key=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