summaryrefslogtreecommitdiff
path: root/sql-bench/limits/msql.cfg
blob: 382f3e2ae81b43fb9d58f154381edaf1e08e18bc (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
#This file is automaticly generated by crash-me 1.32

NEG=no					# update of column= -column
alter_add_col=no			# Alter table add column
alter_add_multi_col=no			# Alter table add many columns
alter_alter_col=no			# Alter table alter column
alter_change_col=no			# Alter table change column
alter_drop_col=no			# Alter table drop column
alter_modify_col=no			# Alter table modify column
alter_rename_table=no			# Alter table rename table
atomic_updates=no			# atomic updates
binary_items=no				# binary items (0x41)
case_insensitive_strings=no		# case insensitive compare
column_alias=no				# Column alias
columns_in_order_by=+64			# number of columns in order by
comment_#=yes				# # as comment
comment_--=no				# -- as comment
comment_/**/=no				# /* */ as comment
compute=no				# Compute
connections=200				# Simultaneous connections
crash_me_safe=yes			# crash me safe
crash_me_version=1.32			# crash me version
create_default=no			# default value for column
create_default_func=no			# default value function for column
create_if_not_exists=no			# create table if not exists
create_index=yes			# create index
create_table_select=no			# create table from select
cross_join=no				# cross join (same as from a,b)
date_with_YY=no				# Supports YY-MM-DD dates
date_zero=no				# Supports 0000-00-00 dates
double_quotes=no			# Double '' as ' in strings
drop_if_exists=no			# drop table if exists
drop_index=with 'FROM'			# drop index
end_colon=no				# allows end ';'
except=no				# except
except_all=no				# except all
foreign_key_syntax=no			# foreign key syntax
full_outer_join=no			# full outer join
func_where_between=no			# Function BETWEEN
func_where_eq_all=no			# Function = ALL
func_where_eq_any=no			# Function = ANY
func_where_eq_some=no			# Function = SOME
func_where_exists=no			# Function EXISTS
func_where_in_num=no			# Function IN on numbers
func_where_like=yes			# Function LIKE
func_where_like_escape=no		# Function LIKE ESCAPE
func_where_match=no			# Function MATCH
func_where_match_unique=no		# Function MATCH UNIQUE
func_where_matches=no			# Function MATCHES
func_where_not_between=no		# Function NOT BETWEEN
func_where_not_exists=no		# Function NOT EXISTS
func_where_not_like=yes			# Function NOT LIKE
func_where_not_unique=no		# Function NOT UNIQUE
func_where_unique=no			# Function UNIQUE
functions=no				# Functions
group_by=no				# Group by
group_by_alias=no			# Group by alias
group_by_null=no			# group on column with null values
group_by_position=no			# Group by position
group_distinct_functions=no		# Group functions with distinct
group_functions=no			# Group functions
having=no				# Having
having_with_alias=no			# Having with alias
having_with_group=no			# Having with group function
ignore_end_space=no			# ignore end space in compare
index_in_create=no			# index in create table
index_namespace=yes			# different namespace for index
index_parts=no				# index on column part (extension)
insert_empty_string=yes			# insert empty string
insert_select=no			# insert INTO ... SELECT ...
insert_with_set=no			# INSERT with set syntax
intersect=no				# intersect
intersect_all=no			# intersect all
join_tables=+64				# tables in join
left_outer_join=no			# left outer join
left_outer_join_using=no		# left outer join using
like_with_column=yes			# column LIKE column
like_with_number=no			# LIKE on numbers
lock_tables=no				# lock table
logical_value=not supported		# Value of logical operation (1=1)
max_char_size=131038			# max char() size
max_columns=75				# Columns in table
max_conditions=72			# OR and AND in WHERE
max_index=+64				# max index
max_index_length=+8192			# index length
max_index_name=35			# index name length
max_index_part_length=+8192		# index part length
max_index_parts=9			# index parts
max_row_length=19125			# max table row length (without blobs)
max_row_length_with_null=19125		# table row length with nulls (without blobs)
max_table_alias_name=34			# table alias name length
max_table_name=35			# table name length
max_unique_index=+64			# max unique index
minus=no				# minus
minus_neg=no				# Calculate 1--1
multi_drop=no				# many tables to drop table
multi_strings=no			# Multiple line strings
multi_table_delete=no			# DELETE FROM table1,table2...
multi_table_update=no			# Update with many tables
insert_multi_value=no			# Value lists in INSERT
natural_join=no				# natural join
natural_left_outer_join=no		# natural left outer join
no_primary_key=yes			# Tables without primary key
null_in_index=no			# null in index
odbc_left_outer_join=no			# left outer join odbc style
operating_system=Linux 2.2.10 i686	# crash-me tested on
order_by=yes				# Order by
order_by_function=no			# Order by function
order_by_position=no			# Order by position
order_by_remember_desc=no		# Order by DESC is remembered
primary_key_in_create=no		# primary key in create table
query_size=131069			# query size
quote_with_"=no				# Allows ' and " as string markers
remember_end_space=yes			# Remembers end space in char()
remember_end_space_varchar=no		# Remembers end space in varchar()
right_outer_join=no			# right outer join
rowid=no				# Type for row id
select_constants=no			# Select constants
select_limit=yes			# SELECT with LIMIT
select_limit2=no			# SELECT with LIMIT #,#
select_table_update=no			# Update with sub select
select_without_from=no			# SELECT without FROM
server_version=mSQL server version 2.0.11	# server version
simple_joins=yes			# ANSI SQL simple joins
subqueries=no				# subqueries
table_alias=yes				# Table alias
table_name_case=no			# case independent table names
table_wildcard=no			# Select table_name.*
tempoary_table=no			# temporary tables
transactions=no				# transactions
type_extra_abstime=no			# Type abstime
type_extra_bfile=no			# Type bfile
type_extra_blob=no			# Type blob
type_extra_bool=no			# Type bool
type_extra_box=no			# Type box
type_extra_byte=no			# Type byte
type_extra_char(1_arg)_binary=no	# Type char(1 arg) binary
type_extra_circle=no			# Type circle
type_extra_clob=no			# Type clob
type_extra_datetime=no			# Type datetime
type_extra_double=yes			# Type double
type_extra_enum(1_arg)=no		# Type enum(1 arg)
type_extra_float(2_arg)=no		# Type float(2 arg)
type_extra_float4=no			# Type float4
type_extra_float8=no			# Type float8
type_extra_image=no			# Type image
type_extra_int(1_arg)_zerofill=no	# Type int(1 arg) zerofill
type_extra_int1=no			# Type int1
type_extra_int2=no			# Type int2
type_extra_int3=no			# Type int3
type_extra_int4=no			# Type int4
type_extra_int8=no			# Type int8
type_extra_int_auto_increment=no	# Type int not null auto_increment
type_extra_int_unsigned=no		# Type int unsigned
type_extra_interval=no			# Type interval
type_extra_line=no			# Type line
type_extra_long=no			# Type long
type_extra_long_raw=no			# Type long raw
type_extra_long_varbinary=no		# Type long varbinary
type_extra_long_varchar(1_arg)=no	# Type long varchar(1 arg)
type_extra_lseg=no			# Type lseg
type_extra_mediumint=no			# Type mediumint
type_extra_mediumtext=no		# Type mediumtext
type_extra_middleint=no			# Type middleint
type_extra_mlslabel=no			# Type mlslabel
type_extra_money=yes			# Type money
type_extra_nclob=no			# Type nclob
type_extra_number=no			# Type number
type_extra_number(1_arg)=no		# Type number(1 arg)
type_extra_number(2_arg)=no		# Type number(2 arg)
type_extra_nvarchar2(1_arg)=no		# Type nvarchar2(1 arg)
type_extra_path=no			# Type path
type_extra_point=no			# Type point
type_extra_polygon=no			# Type polygon
type_extra_raw(1_arg)=no		# Type raw(1 arg)
type_extra_reltime=no			# Type reltime
type_extra_rowid=no			# Type rowid
type_extra_serial=no			# Type serial
type_extra_set(1_arg)=no		# Type set(1 arg)
type_extra_smalldatetime=no		# Type smalldatetime
type_extra_smallfloat=no		# Type smallfloat
type_extra_smallmoney=no		# Type smallmoney
type_extra_text=no			# Type text
type_extra_text(1_arg)=yes		# Type text(1 arg)
type_extra_timespan=no			# Type timespan
type_extra_uint=yes			# Type uint
type_extra_varchar2(1_arg)=no		# Type varchar2(1 arg)
type_extra_year=no			# Type year
type_odbc_bigint=yes			# Type bigint
type_odbc_binary(1_arg)=no		# Type binary(1 arg)
type_odbc_datetime=no			# Type datetime
type_odbc_tinyint=yes			# Type tinyint
type_odbc_varbinary(1_arg)=no		# Type varbinary(1 arg)
type_sql_bit=no				# Type bit
type_sql_bit(1_arg)=no			# Type bit(1 arg)
type_sql_bit_varying(1_arg)=no		# Type bit varying(1 arg)
type_sql_char(1_arg)=yes		# Type char(1 arg)
type_sql_char_varying(1_arg)=no		# Type char varying(1 arg)
type_sql_character(1_arg)=yes		# Type character(1 arg)
type_sql_character_varying(1_arg)=no	# Type character varying(1 arg)
type_sql_date=yes			# Type date
type_sql_dec(2_arg)=no			# Type dec(2 arg)
type_sql_decimal(2_arg)=no		# Type decimal(2 arg)
type_sql_double_precision=no		# Type double precision
type_sql_float=yes			# Type float
type_sql_float(1_arg)=no		# Type float(1 arg)
type_sql_int=yes			# Type int
type_sql_integer=yes			# Type integer
type_sql_interval_day_to_second=no	# Type interval day to second
type_sql_interval_year=no		# Type interval year
type_sql_interval_year_to_month=no	# Type interval year to month
type_sql_national_char_varying(1_arg)=no	# Type national char varying(1 arg)
type_sql_national_character(1_arg)=no	# Type national character(1 arg)
type_sql_national_character_varying(1_arg)=no	# Type national character varying(1 arg)
type_sql_nchar(1_arg)=no		# Type nchar(1 arg)
type_sql_numeric(2_arg)=no		# Type numeric(2 arg)
type_sql_real=yes			# Type real
type_sql_smallint=yes			# Type smallint
type_sql_time=yes			# Type time
type_sql_timestamp=no			# Type timestamp
type_sql_timestamp_with_time_zone=no	# Type timestamp with time zone
type_sql_varchar(1_arg)=no		# Type varchar(1 arg)
union=no				# union
union_all=no				# union all
unique_in_create=no			# unique in create table
views=no				# views
where_string_size=131035		# constant string size in where