~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to sql-bench/limits/mysql-3.23.cfg

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-03-17 14:56:02 UTC
  • Revision ID: james.westby@ubuntu.com-20100317145602-x7e30l1b2sb5s6w6
Tags: upstream-5.1.45
ImportĀ upstreamĀ versionĀ 5.1.45

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
#This file is automaticly generated by crash-me 1.57
 
2
 
 
3
NEG=yes                                 # update of column= -column
 
4
Need_cast_for_null=no                   # Need to cast NULL for arithmetic
 
5
alter_add_col=yes                       # Alter table add column
 
6
alter_add_constraint=yes                # Alter table add constraint
 
7
alter_add_foreign_key=yes               # Alter table add foreign key
 
8
alter_add_multi_col=yes                 # 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=yes                     # Alter table alter column default
 
12
alter_change_col=yes                    # Alter table change column
 
13
alter_drop_col=yes                      # Alter table drop column
 
14
alter_drop_constraint=no                # Alter table drop constraint
 
15
alter_drop_foreign_key=with drop foreign key    # Alter table drop foreign key
 
16
alter_drop_primary_key=drop primary key # Alter table drop primary key
 
17
alter_drop_unique=with drop key         # Alter table drop unique
 
18
alter_modify_col=yes                    # Alter table modify column
 
19
alter_rename_table=yes                  # Alter table rename table
 
20
atomic_updates=no                       # atomic updates
 
21
automatic_rowid=_rowid                  # Automatic row id
 
22
binary_numbers=no                       # binary numbers (0b1001)
 
23
binary_strings=no                       # binary strings (b'0110')
 
24
case_insensitive_strings=yes            # Case insensitive compare
 
25
char_is_space_filled=no                 # 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_#=yes                           # # as comment
 
30
comment_--=yes                          # -- as comment (ANSI)
 
31
comment_/**/=yes                        # /* */ as comment
 
32
comment_//=no                           # // as comment (ANSI)
 
33
compute=no                              # Compute
 
34
connections=101                         # Simultaneous connections (installation default)
 
35
constraint_check=no                     # Column constraints
 
36
constraint_check_table=no               # 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=no                  # default value function for column
 
42
create_if_not_exists=yes                # create table if not exists
 
43
create_index=yes                        # create index
 
44
create_schema=no                        # Create SCHEMA
 
45
create_table_select=yes                 # 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=error                     # 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=yes                           # Supports 0000-00-00 dates
 
53
domains=no                              # Domains (ANSI SQL)
 
54
dont_require_cast_to_float=yes          # No need to cast from integer to float
 
55
double_quotes=yes                       # Double '' as ' in strings
 
56
drop_if_exists=yes                      # drop table if exists
 
57
drop_index=with 'ON'                    # drop index
 
58
drop_requires_cascade=no                # drop table require cascade/restrict
 
59
drop_restrict=yes                       # drop table with cascade/restrict
 
60
end_colon=yes                           # allows end ';'
 
61
except=no                               # except
 
62
except_all=no                           # 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=no                          # foreign keys
 
67
foreign_key_syntax=yes                  # foreign key syntax
 
68
full_outer_join=no                      # full outer join
 
69
func_extra_!=yes                        # Function NOT as '!' in SELECT
 
70
func_extra_%=yes                        # Function MOD as %
 
71
func_extra_&=yes                        # Function & (bitwise and)
 
72
func_extra_&&=yes                       # 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=yes          # 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=yes                # Function BIT_COUNT
 
85
func_extra_ceil=no                      # Function CEIL
 
86
func_extra_charindex=no                 # Function CHARINDEX
 
87
func_extra_chr=no                       # Function CHR
 
88
func_extra_concat_as_+=error            # Function concatenation with +
 
89
func_extra_concat_list=yes              # Function CONCAT(list)
 
90
func_extra_convert=no                   # Function CONVERT
 
91
func_extra_cosh=no                      # Function COSH
 
92
func_extra_date_format=yes              # 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=yes                      # Function ELT
 
98
func_extra_encrypt=yes                  # Function ENCRYPT
 
99
func_extra_field=yes                    # Function FIELD
 
100
func_extra_format=yes                   # Function FORMAT
 
101
func_extra_from_days=yes                # Function FROM_DAYS
 
102
func_extra_from_unixtime=yes            # Function FROM_UNIXTIME
 
103
func_extra_getdate=no                   # Function GETDATE
 
104
func_extra_greatest=yes                 # Function GREATEST
 
105
func_extra_if=yes                       # 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=no                   # Function INITCAP
 
109
func_extra_instr=yes                    # 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=yes                 # Function INTERVAL
 
113
func_extra_last_day=no                  # Function LAST_DAY
 
114
func_extra_last_insert_id=yes           # Function LAST_INSERT_ID
 
115
func_extra_least=yes                    # 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)=no                  # 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=yes                      # 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=yes                 # Function PASSWORD
 
131
func_extra_paste=no                     # Function PASTE
 
132
func_extra_patindex=no                  # Function PATINDEX
 
133
func_extra_period_add=yes               # Function PERIOD_ADD
 
134
func_extra_period_diff=yes              # Function PERIOD_DIFF
 
135
func_extra_pow=yes                      # Function POW
 
136
func_extra_range=no                     # Function RANGE
 
137
func_extra_regexp=yes                   # Function REGEXP in SELECT
 
138
func_extra_replicate=no                 # Function REPLICATE
 
139
func_extra_reverse=yes                  # 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=yes              # Function SEC_TO_TIME
 
144
func_extra_sinh=no                      # Function SINH
 
145
func_extra_str=no                       # Function STR
 
146
func_extra_strcmp=yes                   # Function STRCMP
 
147
func_extra_stuff=no                     # Function STUFF
 
148
func_extra_substrb=no                   # Function SUBSTRB
 
149
func_extra_substring_index=yes          # Function SUBSTRING_INDEX
 
150
func_extra_sysdate=yes                  # Function SYSDATE
 
151
func_extra_tail=no                      # Function TAIL
 
152
func_extra_tanh=no                      # Function TANH
 
153
func_extra_time_to_sec=yes              # Function TIME_TO_SEC
 
154
func_extra_to_days=yes                  # Function TO_DAYS
 
155
func_extra_translate=no                 # Function TRANSLATE
 
156
func_extra_trim_many_char=error         # Function TRIM; Many char extension
 
157
func_extra_trim_substring=yes           # Function TRIM; Substring extension
 
158
func_extra_trunc=no                     # Function TRUNC
 
159
func_extra_uid=no                       # Function UID
 
160
func_extra_unix_timestamp=yes           # Function UNIX_TIMESTAMP
 
161
func_extra_userenv=no                   # Function USERENV
 
162
func_extra_version=yes                  # Function VERSION
 
163
func_extra_weekday=yes                  # Function WEEKDAY
 
164
func_extra_|=yes                        # Function | (bitwise or)
 
165
func_extra_||=yes                       # Function OR as '||'
 
166
func_extra_~*=no                        # 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=yes                   # Function CEILING
 
174
func_odbc_char=yes                      # Function CHAR
 
175
func_odbc_concat=yes                    # Function CONCAT(2 arg)
 
176
func_odbc_cos=yes                       # Function COS
 
177
func_odbc_cot=yes                       # Function COT
 
178
func_odbc_curdate=yes                   # Function CURDATE
 
179
func_odbc_curtime=yes                   # Function CURTIME
 
180
func_odbc_database=yes                  # Function DATABASE
 
181
func_odbc_dayname=yes                   # Function DAYNAME
 
182
func_odbc_dayofmonth=yes                # Function DAYOFMONTH
 
183
func_odbc_dayofweek=yes                 # Function DAYOFWEEK
 
184
func_odbc_dayofyear=yes                 # 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=yes                   # Function ODBC syntax LEFT & RIGHT
 
190
func_odbc_hour=yes                      # Function HOUR
 
191
func_odbc_hour_time=yes                 # Function ANSI HOUR
 
192
func_odbc_ifnull=yes                    # Function IFNULL
 
193
func_odbc_insert=yes                    # Function INSERT
 
194
func_odbc_lcase=yes                     # Function LCASE
 
195
func_odbc_left=yes                      # Function LEFT
 
196
func_odbc_length=yes                    # Function REAL LENGTH
 
197
func_odbc_length_without_space=error    # Function ODBC LENGTH
 
198
func_odbc_locate_2=yes                  # Function LOCATE(2 arg)
 
199
func_odbc_locate_3=yes                  # Function LOCATE(3 arg)
 
200
func_odbc_log=yes                       # Function LOG
 
201
func_odbc_log10=yes                     # Function LOG10
 
202
func_odbc_ltrim=yes                     # Function LTRIM
 
203
func_odbc_minute=yes                    # Function MINUTE
 
204
func_odbc_mod=yes                       # Function MOD
 
205
func_odbc_month=yes                     # Function MONTH
 
206
func_odbc_monthname=yes                 # Function MONTHNAME
 
207
func_odbc_now=yes                       # Function NOW
 
208
func_odbc_pi=yes                        # Function PI
 
209
func_odbc_power=yes                     # Function POWER
 
210
func_odbc_quarter=yes                   # Function QUARTER
 
211
func_odbc_radians=yes                   # Function RADIANS
 
212
func_odbc_rand=yes                      # Function RAND
 
213
func_odbc_repeat=yes                    # Function REPEAT
 
214
func_odbc_replace=yes                   # Function REPLACE
 
215
func_odbc_right=yes                     # Function RIGHT
 
216
func_odbc_round=yes                     # Function ROUND(2 arg)
 
217
func_odbc_rtrim=yes                     # Function RTRIM
 
218
func_odbc_second=yes                    # Function SECOND
 
219
func_odbc_sign=yes                      # Function SIGN
 
220
func_odbc_sin=yes                       # Function SIN
 
221
func_odbc_soundex=yes                   # Function SOUNDEX
 
222
func_odbc_space=yes                     # Function SPACE
 
223
func_odbc_sqrt=yes                      # 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=yes                  # Function TRUNCATE
 
229
func_odbc_ucase=yes                     # Function UCASE
 
230
func_odbc_user()=yes                    # Function USER()
 
231
func_odbc_week=yes                      # Function WEEK
 
232
func_odbc_year=yes                      # Function YEAR
 
233
func_sql_+=yes                          # Function +, -, * and /
 
234
func_sql_bit_length=no                  # Function BIT_LENGTH
 
235
func_sql_cast=no                        # Function CAST
 
236
func_sql_char_length=error              # 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_||=error             # 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=no                # 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=no                # 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=no                        # Function USER
 
261
func_where_between=yes                  # Function BETWEEN
 
262
func_where_eq_all=no                    # Function = ALL
 
263
func_where_eq_any=no                    # Function = ANY
 
264
func_where_eq_some=no                   # Function = SOME
 
265
func_where_exists=no                    # 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=no                # 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=yes            # Group function BIT_AND
 
284
group_func_extra_bit_or=yes             # Group function BIT_OR
 
285
group_func_extra_count_distinct_list=yes        # Group function COUNT(DISTINCT expr,expr,...)
 
286
group_func_extra_std=yes                # Group function STD
 
287
group_func_extra_stddev=yes             # Group function STDDEV
 
288
group_func_extra_variance=no            # 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=no                       # TRUE and FALSE
 
304
having=yes                              # Having
 
305
having_with_alias=yes                   # Having on alias
 
306
having_with_group=yes                   # Having with group function
 
307
hex_numbers=yes                         # hex numbers (0x41)
 
308
hex_strings=no                          # hex strings (x'1ace')
 
309
ignore_end_space=yes                    # Ignore end space in compare
 
310
index_in_create=yes                     # index in create table
 
311
index_namespace=yes                     # different namespace for index
 
312
index_parts=yes                         # index on column part (extension)
 
313
inner_join=yes                          # inner join
 
314
insert_empty_string=yes                 # insert empty string
 
315
insert_multi_value=yes                  # INSERT with Value lists
 
316
insert_select=yes                       # insert INTO ... SELECT ...
 
317
insert_with_set=yes                     # INSERT with set syntax
 
318
intersect=no                            # intersect
 
319
intersect_all=no                        # intersect all
 
320
intersect_all_incompat=no               # intersect all (incompatible lists)
 
321
intersect_incompat=no                   # intersect (incompatible lists)
 
322
join_tables=63                          # 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=255                       # max char() size
 
331
max_column_name=64                      # column name length
 
332
max_columns=3398                        # Columns in table
 
333
max_conditions=85660                    # OR and AND in WHERE
 
334
max_expressions=1837                    # simple expressions
 
335
max_index=32                            # max index
 
336
max_index_length=500                    # index length
 
337
max_index_name=64                       # index name length
 
338
max_index_part_length=255               # max index part length
 
339
max_index_parts=16                      # index parts
 
340
max_index_varchar_part_length=255       # index varchar part length
 
341
max_row_length=65534                    # max table row length (without blobs)
 
342
max_row_length_with_null=65502          # table row length with nulls (without blobs)
 
343
max_select_alias_name=+512              # select alias name length
 
344
max_stack_expression=1837               # stacked expressions
 
345
max_table_alias_name=+512               # table alias name length
 
346
max_table_name=64                       # table name length
 
347
max_text_size=1048543                   # max text or blob size
 
348
max_unique_index=32                     # unique indexes
 
349
max_varchar_size=255                    # max varchar() size
 
350
minus=no                                # minus
 
351
minus_incompat=no                       # minus (incompatible lists)
 
352
minus_neg=yes                           # 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 concat('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=yes                # left outer join odbc style
 
368
operating_system=Linux 2.2.13-SMP alpha # 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=1048574                      # query size
 
381
quote_ident_with_"=error                # " as identifier quote (ANSI SQL)
 
382
quote_ident_with_[=no                   # [] as identifier quote
 
383
quote_ident_with_`=yes                  # ` as identifier quote
 
384
quote_with_"=yes                        # Allows ' and " as string markers
 
385
remember_end_space=no                   # Remembers end space in char()
 
386
remember_end_space_varchar=no           # Remembers end space in varchar()
 
387
rename_table=yes                        # rename table
 
388
repeat_string_size=1047552              # return string size from function
 
389
right_outer_join=yes                    # right outer join
 
390
rowid=auto_increment                    # Type for row id
 
391
select_constants=yes                    # Select constants
 
392
select_limit=with LIMIT                 # LIMIT number of rows
 
393
select_limit2=yes                       # SELECT with LIMIT #,#
 
394
select_string_size=1048565              # constant string size in SELECT
 
395
select_table_update=no                  # Update with sub select
 
396
select_without_from=yes                 # SELECT without FROM
 
397
server_version=MySQL 3.23.39 debug      # server version
 
398
simple_joins=yes                        # ANSI SQL simple joins
 
399
storage_of_float=round                  # Storage of float values
 
400
subqueries=no                           # subqueries
 
401
table_alias=yes                         # Table alias
 
402
table_name_case=no                      # case independent table names
 
403
table_wildcard=yes                      # Select table_name.*
 
404
temporary_table=yes                     # temporary tables
 
405
transactions=yes                        # constant string size in where
 
406
truncate_table=yes                      # truncate
 
407
type_extra_abstime=no                   # Type abstime
 
408
type_extra_bfile=no                     # Type bfile
 
409
type_extra_blob=yes                     # Type blob
 
410
type_extra_bool=yes                     # Type bool
 
411
type_extra_box=no                       # Type box
 
412
type_extra_byte=no                      # Type byte
 
413
type_extra_char(1_arg)_binary=yes       # Type char(1 arg) binary
 
414
type_extra_cidr=no                      # Type cidr
 
415
type_extra_circle=no                    # Type circle
 
416
type_extra_clob=no                      # Type clob
 
417
type_extra_datetime=yes                 # Type datetime
 
418
type_extra_double=yes                   # Type double
 
419
type_extra_enum(1_arg)=yes              # Type enum(1 arg)
 
420
type_extra_float(2_arg)=yes             # Type float(2 arg)
 
421
type_extra_float4=yes                   # Type float4
 
422
type_extra_float8=yes                   # Type float8
 
423
type_extra_image=no                     # Type image
 
424
type_extra_inet=no                      # Type inet
 
425
type_extra_int(1_arg)_zerofill=yes      # Type int(1 arg) zerofill
 
426
type_extra_int1=yes                     # Type int1
 
427
type_extra_int2=yes                     # Type int2
 
428
type_extra_int3=yes                     # Type int3
 
429
type_extra_int4=yes                     # Type int4
 
430
type_extra_int8=yes                     # Type int8
 
431
type_extra_int_auto_increment=yes       # Type int not null auto_increment
 
432
type_extra_int_identity=no              # Type int not null identity
 
433
type_extra_int_unsigned=yes             # Type int unsigned
 
434
type_extra_interval=no                  # Type interval
 
435
type_extra_line=no                      # Type line
 
436
type_extra_long=no                      # Type long
 
437
type_extra_long_raw=no                  # Type long raw
 
438
type_extra_long_varbinary=yes           # Type long varbinary
 
439
type_extra_long_varchar(1_arg)=no       # Type long varchar(1 arg)
 
440
type_extra_lseg=no                      # Type lseg
 
441
type_extra_macaddr=no                   # Type macaddr
 
442
type_extra_mediumint=yes                # Type mediumint
 
443
type_extra_mediumtext=yes               # Type mediumtext
 
444
type_extra_middleint=yes                # Type middleint
 
445
type_extra_mlslabel=no                  # Type mlslabel
 
446
type_extra_money=no                     # Type money
 
447
type_extra_nclob=no                     # Type nclob
 
448
type_extra_number=no                    # Type number
 
449
type_extra_number(1_arg)=no             # Type number(1 arg)
 
450
type_extra_number(2_arg)=no             # Type number(2 arg)
 
451
type_extra_nvarchar2(1_arg)=no          # Type nvarchar2(1 arg)
 
452
type_extra_path=no                      # Type path
 
453
type_extra_point=no                     # Type point
 
454
type_extra_polygon=no                   # Type polygon
 
455
type_extra_raw(1_arg)=no                # Type raw(1 arg)
 
456
type_extra_reltime=no                   # Type reltime
 
457
type_extra_rowid=no                     # Type rowid
 
458
type_extra_serial=no                    # Type serial
 
459
type_extra_set(1_arg)=yes               # Type set(1 arg)
 
460
type_extra_smalldatetime=no             # Type smalldatetime
 
461
type_extra_smallfloat=no                # Type smallfloat
 
462
type_extra_smallmoney=no                # Type smallmoney
 
463
type_extra_text=yes                     # Type text
 
464
type_extra_text(1_arg)=no               # Type text(1 arg)
 
465
type_extra_timespan=no                  # Type timespan
 
466
type_extra_uint=no                      # Type uint
 
467
type_extra_varchar2(1_arg)=no           # Type varchar2(1 arg)
 
468
type_extra_year=yes                     # Type year
 
469
type_odbc_bigint=yes                    # Type bigint
 
470
type_odbc_binary(1_arg)=yes             # Type binary(1 arg)
 
471
type_odbc_datetime=yes                  # Type datetime
 
472
type_odbc_tinyint=yes                   # Type tinyint
 
473
type_odbc_varbinary(1_arg)=yes          # Type varbinary(1 arg)
 
474
type_sql_bit=yes                        # Type bit
 
475
type_sql_bit(1_arg)=yes                 # Type bit(1 arg)
 
476
type_sql_bit_varying(1_arg)=no          # Type bit varying(1 arg)
 
477
type_sql_boolean=no                     # Type boolean
 
478
type_sql_char(1_arg)=yes                # Type char(1 arg)
 
479
type_sql_char_varying(1_arg)=yes        # Type char varying(1 arg)
 
480
type_sql_character(1_arg)=yes           # Type character(1 arg)
 
481
type_sql_character_varying(1_arg)=yes   # Type character varying(1 arg)
 
482
type_sql_date=yes                       # Type date
 
483
type_sql_dec(2_arg)=yes                 # Type dec(2 arg)
 
484
type_sql_decimal(2_arg)=yes             # Type decimal(2 arg)
 
485
type_sql_double_precision=yes           # Type double precision
 
486
type_sql_float=yes                      # Type float
 
487
type_sql_float(1_arg)=yes               # Type float(1 arg)
 
488
type_sql_int=yes                        # Type int
 
489
type_sql_integer=yes                    # Type integer
 
490
type_sql_interval_day=no                # Type interval day
 
491
type_sql_interval_day_to_hour=no        # Type interval day to hour
 
492
type_sql_interval_day_to_minute=no      # Type interval day to minute
 
493
type_sql_interval_day_to_second=no      # Type interval day to second
 
494
type_sql_interval_hour=no               # Type interval hour
 
495
type_sql_interval_hour_to_minute=no     # Type interval hour to minute
 
496
type_sql_interval_hour_to_second=no     # Type interval hour to second
 
497
type_sql_interval_minute=no             # Type interval minute
 
498
type_sql_interval_minute_to_second=no   # Type interval minute to second
 
499
type_sql_interval_month=no              # Type interval month
 
500
type_sql_interval_second=no             # Type interval second
 
501
type_sql_interval_year=no               # Type interval year
 
502
type_sql_interval_year_to_month=no      # Type interval year to month
 
503
type_sql_national_char_varying(1_arg)=yes       # Type national char varying(1 arg)
 
504
type_sql_national_character(1_arg)=yes  # Type national character(1 arg)
 
505
type_sql_national_character_varying(1_arg)=yes  # Type national character varying(1 arg)
 
506
type_sql_nchar(1_arg)=yes               # Type nchar(1 arg)
 
507
type_sql_nchar_varying(1_arg)=yes       # Type nchar varying(1 arg)
 
508
type_sql_numeric(2_arg)=yes             # Type numeric(2 arg)
 
509
type_sql_real=yes                       # Type real
 
510
type_sql_smallint=yes                   # Type smallint
 
511
type_sql_time=yes                       # Type time
 
512
type_sql_timestamp=yes                  # Type timestamp
 
513
type_sql_timestamp_with_time_zone=no    # Type timestamp with time zone
 
514
type_sql_varchar(1_arg)=yes             # Type varchar(1 arg)
 
515
union=no                                # union
 
516
union_all=no                            # union all
 
517
union_all_incompat=no                   # union all (incompatible lists)
 
518
union_incompat=no                       # union (incompatible lists)
 
519
unique_in_create=yes                    # unique in create table
 
520
unique_null_in_create=yes               # unique null in create
 
521
user_comment=Alpha DS20 2x500 MHz, 2G memory, key_buffer=16M; ccc + cxx # comment
 
522
views=no                                # views
 
523
where_string_size=1048539               # constant string size in where