1
#This file is automaticly generated by crash-me 1.32
3
NEG=no # update of column= -column
4
alter_add_col=no # Alter table add column
5
alter_add_multi_col=no # Alter table add many columns
6
alter_alter_col=no # Alter table alter column
7
alter_change_col=no # Alter table change column
8
alter_drop_col=no # Alter table drop column
9
alter_modify_col=no # Alter table modify column
10
alter_rename_table=no # Alter table rename table
11
atomic_updates=no # atomic updates
12
binary_items=no # binary items (0x41)
13
case_insensitive_strings=no # case insensitive compare
14
column_alias=no # Column alias
15
columns_in_order_by=+64 # number of columns in order by
16
comment_#=yes # # as comment
17
comment_--=no # -- as comment
18
comment_/**/=no # /* */ as comment
20
connections=200 # Simultaneous connections
21
crash_me_safe=yes # crash me safe
22
crash_me_version=1.32 # crash me version
23
create_default=no # default value for column
24
create_default_func=no # default value function for column
25
create_if_not_exists=no # create table if not exists
26
create_index=yes # create index
27
create_table_select=no # create table from select
28
cross_join=no # cross join (same as from a,b)
29
date_with_YY=no # Supports YY-MM-DD dates
30
date_zero=no # Supports 0000-00-00 dates
31
double_quotes=no # Double '' as ' in strings
32
drop_if_exists=no # drop table if exists
33
drop_index=with 'FROM' # drop index
34
end_colon=no # allows end ';'
36
except_all=no # except all
37
foreign_key_syntax=no # foreign key syntax
38
full_outer_join=no # full outer join
39
func_where_between=no # Function BETWEEN
40
func_where_eq_all=no # Function = ALL
41
func_where_eq_any=no # Function = ANY
42
func_where_eq_some=no # Function = SOME
43
func_where_exists=no # Function EXISTS
44
func_where_in_num=no # Function IN on numbers
45
func_where_like=yes # Function LIKE
46
func_where_like_escape=no # Function LIKE ESCAPE
47
func_where_match=no # Function MATCH
48
func_where_match_unique=no # Function MATCH UNIQUE
49
func_where_matches=no # Function MATCHES
50
func_where_not_between=no # Function NOT BETWEEN
51
func_where_not_exists=no # Function NOT EXISTS
52
func_where_not_like=yes # Function NOT LIKE
53
func_where_not_unique=no # Function NOT UNIQUE
54
func_where_unique=no # Function UNIQUE
55
functions=no # Functions
56
group_by=no # Group by
57
group_by_alias=no # Group by alias
58
group_by_null=no # group on column with null values
59
group_by_position=no # Group by position
60
group_distinct_functions=no # Group functions with distinct
61
group_functions=no # Group functions
63
having_with_alias=no # Having with alias
64
having_with_group=no # Having with group function
65
ignore_end_space=no # ignore end space in compare
66
index_in_create=no # index in create table
67
index_namespace=yes # different namespace for index
68
index_parts=no # index on column part (extension)
69
insert_empty_string=yes # insert empty string
70
insert_select=no # insert INTO ... SELECT ...
71
insert_with_set=no # INSERT with set syntax
72
intersect=no # intersect
73
intersect_all=no # intersect all
74
join_tables=+64 # tables in join
75
left_outer_join=no # left outer join
76
left_outer_join_using=no # left outer join using
77
like_with_column=yes # column LIKE column
78
like_with_number=no # LIKE on numbers
79
lock_tables=no # lock table
80
logical_value=not supported # Value of logical operation (1=1)
81
max_char_size=131038 # max char() size
82
max_columns=75 # Columns in table
83
max_conditions=72 # OR and AND in WHERE
84
max_index=+64 # max index
85
max_index_length=+8192 # index length
86
max_index_name=35 # index name length
87
max_index_part_length=+8192 # index part length
88
max_index_parts=9 # index parts
89
max_row_length=19125 # max table row length (without blobs)
90
max_row_length_with_null=19125 # table row length with nulls (without blobs)
91
max_table_alias_name=34 # table alias name length
92
max_table_name=35 # table name length
93
max_unique_index=+64 # max unique index
95
minus_neg=no # Calculate 1--1
96
multi_drop=no # many tables to drop table
97
multi_strings=no # Multiple line strings
98
multi_table_delete=no # DELETE FROM table1,table2...
99
multi_table_update=no # Update with many tables
100
insert_multi_value=no # Value lists in INSERT
101
natural_join=no # natural join
102
natural_left_outer_join=no # natural left outer join
103
no_primary_key=yes # Tables without primary key
104
null_in_index=no # null in index
105
odbc_left_outer_join=no # left outer join odbc style
106
operating_system=Linux 2.2.10 i686 # crash-me tested on
107
order_by=yes # Order by
108
order_by_function=no # Order by function
109
order_by_position=no # Order by position
110
order_by_remember_desc=no # Order by DESC is remembered
111
primary_key_in_create=no # primary key in create table
112
query_size=131069 # query size
113
quote_with_"=no # Allows ' and " as string markers
114
remember_end_space=yes # Remembers end space in char()
115
remember_end_space_varchar=no # Remembers end space in varchar()
116
right_outer_join=no # right outer join
117
rowid=no # Type for row id
118
select_constants=no # Select constants
119
select_limit=yes # SELECT with LIMIT
120
select_limit2=no # SELECT with LIMIT #,#
121
select_table_update=no # Update with sub select
122
select_without_from=no # SELECT without FROM
123
server_version=mSQL server version 2.0.11 # server version
124
simple_joins=yes # ANSI SQL simple joins
125
subqueries=no # subqueries
126
table_alias=yes # Table alias
127
table_name_case=no # case independent table names
128
table_wildcard=no # Select table_name.*
129
tempoary_table=no # temporary tables
130
transactions=no # transactions
131
type_extra_abstime=no # Type abstime
132
type_extra_bfile=no # Type bfile
133
type_extra_blob=no # Type blob
134
type_extra_bool=no # Type bool
135
type_extra_box=no # Type box
136
type_extra_byte=no # Type byte
137
type_extra_char(1_arg)_binary=no # Type char(1 arg) binary
138
type_extra_circle=no # Type circle
139
type_extra_clob=no # Type clob
140
type_extra_datetime=no # Type datetime
141
type_extra_double=yes # Type double
142
type_extra_enum(1_arg)=no # Type enum(1 arg)
143
type_extra_float(2_arg)=no # Type float(2 arg)
144
type_extra_float4=no # Type float4
145
type_extra_float8=no # Type float8
146
type_extra_image=no # Type image
147
type_extra_int(1_arg)_zerofill=no # Type int(1 arg) zerofill
148
type_extra_int1=no # Type int1
149
type_extra_int2=no # Type int2
150
type_extra_int3=no # Type int3
151
type_extra_int4=no # Type int4
152
type_extra_int8=no # Type int8
153
type_extra_int_auto_increment=no # Type int not null auto_increment
154
type_extra_int_unsigned=no # Type int unsigned
155
type_extra_interval=no # Type interval
156
type_extra_line=no # Type line
157
type_extra_long=no # Type long
158
type_extra_long_raw=no # Type long raw
159
type_extra_long_varbinary=no # Type long varbinary
160
type_extra_long_varchar(1_arg)=no # Type long varchar(1 arg)
161
type_extra_lseg=no # Type lseg
162
type_extra_mediumint=no # Type mediumint
163
type_extra_mediumtext=no # Type mediumtext
164
type_extra_middleint=no # Type middleint
165
type_extra_mlslabel=no # Type mlslabel
166
type_extra_money=yes # Type money
167
type_extra_nclob=no # Type nclob
168
type_extra_number=no # Type number
169
type_extra_number(1_arg)=no # Type number(1 arg)
170
type_extra_number(2_arg)=no # Type number(2 arg)
171
type_extra_nvarchar2(1_arg)=no # Type nvarchar2(1 arg)
172
type_extra_path=no # Type path
173
type_extra_point=no # Type point
174
type_extra_polygon=no # Type polygon
175
type_extra_raw(1_arg)=no # Type raw(1 arg)
176
type_extra_reltime=no # Type reltime
177
type_extra_rowid=no # Type rowid
178
type_extra_serial=no # Type serial
179
type_extra_set(1_arg)=no # Type set(1 arg)
180
type_extra_smalldatetime=no # Type smalldatetime
181
type_extra_smallfloat=no # Type smallfloat
182
type_extra_smallmoney=no # Type smallmoney
183
type_extra_text=no # Type text
184
type_extra_text(1_arg)=yes # Type text(1 arg)
185
type_extra_timespan=no # Type timespan
186
type_extra_uint=yes # Type uint
187
type_extra_varchar2(1_arg)=no # Type varchar2(1 arg)
188
type_extra_year=no # Type year
189
type_odbc_bigint=yes # Type bigint
190
type_odbc_binary(1_arg)=no # Type binary(1 arg)
191
type_odbc_datetime=no # Type datetime
192
type_odbc_tinyint=yes # Type tinyint
193
type_odbc_varbinary(1_arg)=no # Type varbinary(1 arg)
194
type_sql_bit=no # Type bit
195
type_sql_bit(1_arg)=no # Type bit(1 arg)
196
type_sql_bit_varying(1_arg)=no # Type bit varying(1 arg)
197
type_sql_char(1_arg)=yes # Type char(1 arg)
198
type_sql_char_varying(1_arg)=no # Type char varying(1 arg)
199
type_sql_character(1_arg)=yes # Type character(1 arg)
200
type_sql_character_varying(1_arg)=no # Type character varying(1 arg)
201
type_sql_date=yes # Type date
202
type_sql_dec(2_arg)=no # Type dec(2 arg)
203
type_sql_decimal(2_arg)=no # Type decimal(2 arg)
204
type_sql_double_precision=no # Type double precision
205
type_sql_float=yes # Type float
206
type_sql_float(1_arg)=no # Type float(1 arg)
207
type_sql_int=yes # Type int
208
type_sql_integer=yes # Type integer
209
type_sql_interval_day_to_second=no # Type interval day to second
210
type_sql_interval_year=no # Type interval year
211
type_sql_interval_year_to_month=no # Type interval year to month
212
type_sql_national_char_varying(1_arg)=no # Type national char varying(1 arg)
213
type_sql_national_character(1_arg)=no # Type national character(1 arg)
214
type_sql_national_character_varying(1_arg)=no # Type national character varying(1 arg)
215
type_sql_nchar(1_arg)=no # Type nchar(1 arg)
216
type_sql_numeric(2_arg)=no # Type numeric(2 arg)
217
type_sql_real=yes # Type real
218
type_sql_smallint=yes # Type smallint
219
type_sql_time=yes # Type time
220
type_sql_timestamp=no # Type timestamp
221
type_sql_timestamp_with_time_zone=no # Type timestamp with time zone
222
type_sql_varchar(1_arg)=no # Type varchar(1 arg)
224
union_all=no # union all
225
unique_in_create=no # unique in create table
227
where_string_size=131035 # constant string size in where
added
removed
tests/kewpie/sql-bench/limits/msql.cfg
