"SfR Fresh" - the SfR Freeware/Shareware Archive

Member "mysql-4.1.22-win32/sql-bench/limits/Adabas.cfg" of archive mysql-noinstall-4.1.22-win32.zip:


As a special service "SfR Fresh" has tried to format the requested source page into HTML format using source code syntax highlighting with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file. That can be also achieved for any archive member file by clicking within an archive contents listing on the first character of the file(path) respectively on the according byte size field.
    1 #This file is automaticly generated by crash-me 1.20b
    2 
    3 NEG=yes					# update of column= -column
    4 alter_add_col=yes			# Alter table add column
    5 alter_add_multi_col=without add		# 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=yes			# Alter table drop column
    9 alter_modify_col=yes			# Alter table modify column
   10 alter_rename_table=no			# Alter table rename table
   11 atomic_updates=no			# atomic updates
   12 binary_items=yes			# binary items (0x41)
   13 case_insensitive_strings=no		# case insensitive compare
   14 char_is_space_filled=no			# char are space filled
   15 column_alias=yes			# Column alias
   16 columns_in_group_by=16			# number of columns in group by
   17 columns_in_order_by=16			# number of columns in order by
   18 comment_#=no				# # as comment
   19 comment_--=no				# -- as comment
   20 comment_/**/=no				# /* */ as comment
   21 compute=no				# Compute
   22 connections=1				# Simultaneous connections
   23 crash_me_safe=no			# crash me safe
   24 crash_me_version=1.20b			# crash me version
   25 create_default=yes			# default value for column
   26 create_index=yes			# create index
   27 cross_join=no				# cross join (same as from a,b)
   28 date_as_string=yes			# String functions on date columns
   29 date_with_YY=no				# Supports YY-MM-DD dates
   30 date_zero=no				# Supports 0000-00-00 dates
   31 double_quotes=yes			# Double '' as ' in strings
   32 drop_index=yes				# drop index
   33 end_colon=no				# allows end ';'
   34 except=yes				# except
   35 except_all=yes				# except all
   36 float_int_expr=yes			# mixing of integer and float in expression
   37 foreign_key=yes				# foreign keys
   38 foreign_key_syntax=yes			# foreign key syntax
   39 full_outer_join=no			# full outer join
   40 func_extra_!=no				# Function NOT as '!' in SELECT
   41 func_extra_%=no				# Function MOD as %
   42 func_extra_&=no				# Function & (bitwise and)
   43 func_extra_&&=no			# Function AND as '&&'
   44 func_extra_<>=no			# Function <> in SELECT
   45 func_extra_==no				# Function =
   46 func_extra_add_months=no		# Function ADD_MONTHS
   47 func_extra_and_or=no			# Function AND and OR in SELECT
   48 func_extra_atn2=no			# Function ATN2
   49 func_extra_auto_num2string=no		# Function automatic num->string convert
   50 func_extra_auto_string2num=no		# Function automatic string->num convert
   51 func_extra_between=no			# Function BETWEEN in SELECT
   52 func_extra_binary_shifts=no		# Function << and >> (bitwise shifts)
   53 func_extra_bit_count=no			# Function BIT_COUNT
   54 func_extra_ceil=yes			# Function CEIL
   55 func_extra_charindex=no			# Function CHARINDEX
   56 func_extra_chr=error			# Function CHR
   57 func_extra_concat_as_+=no		# Function concatenation with +
   58 func_extra_concat_list=no		# Function CONCAT(list)
   59 func_extra_convert=no			# Function CONVERT
   60 func_extra_cosh=yes			# Function COSH
   61 func_extra_date_format=no		# Function DATE_FORMAT
   62 func_extra_dateadd=no			# Function DATEADD
   63 func_extra_datediff=no			# Function DATEDIFF
   64 func_extra_datename=no			# Function DATENAME
   65 func_extra_datepart=no			# Function DATEPART
   66 func_extra_elt=no			# Function ELT
   67 func_extra_encrypt=no			# Function ENCRYPT
   68 func_extra_field=no			# Function FIELD
   69 func_extra_format=no			# Function FORMAT
   70 func_extra_from_days=no			# Function FROM_DAYS
   71 func_extra_from_unixtime=no		# Function FROM_UNIXTIME
   72 func_extra_getdate=no			# Function GETDATE
   73 func_extra_greatest=yes			# Function GREATEST
   74 func_extra_if=no			# Function IF
   75 func_extra_in_num=no			# Function IN on numbers in SELECT
   76 func_extra_in_str=no			# Function IN on strings in SELECT
   77 func_extra_initcap=yes			# Function INITCAP
   78 func_extra_instr=no			# Function LOCATE as INSTR 
   79 func_extra_instrb=no			# Function INSTRB
   80 func_extra_interval=no			# Function INTERVAL
   81 func_extra_last_day=no			# Function LAST_DAY
   82 func_extra_last_insert_id=no		# Function LAST_INSERT_ID
   83 func_extra_least=yes			# Function LEAST
   84 func_extra_lengthb=no			# Function LENGTHB
   85 func_extra_like=no			# Function LIKE in SELECT
   86 func_extra_like_escape=no		# Function LIKE ESCAPE in SELECT
   87 func_extra_ln=yes			# Function LN
   88 func_extra_log(m_n)=no			# Function LOG(m,n)
   89 func_extra_logn=no			# Function LOGN
   90 func_extra_lpad=no			# Function LPAD
   91 func_extra_max_num=no			# Function MAX on numbers
   92 func_extra_mdy=no			# Function MDY
   93 func_extra_mid=no			# Function SUBSTRING as MID
   94 func_extra_min_num=no			# Function MIN on numbers
   95 func_extra_months_between=no		# Function MONTHS_BETWEEN
   96 func_extra_not=no			# Function NOT in SELECT
   97 func_extra_not_between=no		# Function NOT BETWEEN in SELECT
   98 func_extra_not_like=no			# Function NOT LIKE in SELECT
   99 func_extra_odbc_convert=no		# Function ODBC CONVERT
  100 func_extra_password=no			# Function PASSWORD
  101 func_extra_patindex=no			# Function PATINDEX
  102 func_extra_period_add=no		# Function PERIOD_ADD
  103 func_extra_period_diff=no		# Function PERIOD_DIFF
  104 func_extra_pow=no			# Function POW
  105 func_extra_range=no			# Function RANGE
  106 func_extra_regexp=no			# Function REGEXP in SELECT
  107 func_extra_replicate=no			# Function REPLICATE
  108 func_extra_reverse=no			# Function REVERSE
  109 func_extra_root=no			# Function ROOT
  110 func_extra_round1=yes			# Function ROUND(1 arg)
  111 func_extra_rpad=no			# Function RPAD
  112 func_extra_sec_to_time=no		# Function SEC_TO_TIME
  113 func_extra_sinh=yes			# Function SINH
  114 func_extra_str=no			# Function STR
  115 func_extra_strcmp=no			# Function STRCMP
  116 func_extra_stuff=no			# Function STUFF
  117 func_extra_substrb=no			# Function SUBSTRB
  118 func_extra_substring_index=no		# Function SUBSTRING_INDEX
  119 func_extra_tanh=error			# Function TANH
  120 func_extra_time_to_sec=no		# Function TIME_TO_SEC
  121 func_extra_to_days=no			# Function TO_DAYS
  122 func_extra_translate=yes		# Function TRANSLATE
  123 func_extra_trim_many_char=no		# Function TRIM; Many char extension
  124 func_extra_trim_substring=no		# Function TRIM; Substring extension
  125 func_extra_trunc=yes			# Function TRUNC
  126 func_extra_uid=no			# Function UID
  127 func_extra_unix_timestamp=no		# Function UNIX_TIMESTAMP
  128 func_extra_userenv=no			# Function USERENV
  129 func_extra_version=no			# Function VERSION
  130 func_extra_weekday=no			# Function WEEKDAY
  131 func_extra_|=no				# Function | (bitwise or)
  132 func_extra_||=no			# Function OR as '||'
  133 func_odbc_abs=yes			# Function ABS
  134 func_odbc_acos=yes			# Function ACOS
  135 func_odbc_ascii=error			# Function ASCII
  136 func_odbc_asin=yes			# Function ASIN
  137 func_odbc_atan=yes			# Function ATAN
  138 func_odbc_atan2=yes			# Function ATAN2
  139 func_odbc_ceiling=yes			# Function CEILING
  140 func_odbc_char=no			# Function CHAR
  141 func_odbc_concat=no			# Function CONCAT(2 arg)
  142 func_odbc_cos=yes			# Function COS
  143 func_odbc_cot=yes			# Function COT
  144 func_odbc_curdate=yes			# Function CURDATE
  145 func_odbc_curtime=yes			# Function CURTIME
  146 func_odbc_database=yes			# Function DATABASE
  147 func_odbc_dayname=yes			# Function DAYNAME
  148 func_odbc_dayofmonth=yes		# Function DAYOFMONTH
  149 func_odbc_dayofweek=error		# Function DAYOFWEEK
  150 func_odbc_dayofyear=yes			# Function DAYOFYEAR
  151 func_odbc_degrees=yes			# Function DEGREES
  152 func_odbc_difference=no			# Function DIFFERENCE()
  153 func_odbc_exp=yes			# Function EXP
  154 func_odbc_extract=no			# Function EXTRACT
  155 func_odbc_floor=yes			# Function FLOOR
  156 func_odbc_fn_left=no			# Function ODBC syntax LEFT & RIGHT
  157 func_odbc_hour=yes			# Function HOUR
  158 func_odbc_hour_time=no			# Function ANSI HOUR
  159 func_odbc_ifnull=yes			# Function IFNULL
  160 func_odbc_insert=no			# Function INSERT
  161 func_odbc_lcase=yes			# Function LCASE
  162 func_odbc_left=yes			# Function LEFT
  163 func_odbc_length=error			# Function REAL LENGTH
  164 func_odbc_length_without_space=yes	# Function ODBC LENGTH
  165 func_odbc_locate_2=no			# Function LOCATE(2 arg)
  166 func_odbc_locate_3=no			# Function LOCATE(3 arg)
  167 func_odbc_log=yes			# Function LOG
  168 func_odbc_log10=yes			# Function LOG10
  169 func_odbc_ltrim=yes			# Function LTRIM
  170 func_odbc_minute=yes			# Function MINUTE
  171 func_odbc_mod=no			# Function MOD
  172 func_odbc_month=yes			# Function MONTH
  173 func_odbc_monthname=yes			# Function MONTHNAME
  174 func_odbc_now=yes			# Function NOW
  175 func_odbc_pi=yes			# Function PI
  176 func_odbc_power=yes			# Function POWER
  177 func_odbc_quarter=no			# Function QUARTER
  178 func_odbc_radians=yes			# Function RADIANS
  179 func_odbc_rand=no			# Function RAND
  180 func_odbc_repeat=no			# Function REPEAT
  181 func_odbc_replace=yes			# Function REPLACE
  182 func_odbc_right=yes			# Function RIGHT
  183 func_odbc_round=yes			# Function ROUND(2 arg)
  184 func_odbc_rtrim=yes			# Function RTRIM
  185 func_odbc_second=yes			# Function SECOND
  186 func_odbc_sign=yes			# Function SIGN
  187 func_odbc_sin=yes			# Function SIN
  188 func_odbc_soundex=yes			# Function SOUNDEX
  189 func_odbc_space=no			# Function SPACE
  190 func_odbc_sqrt=yes			# Function SQRT
  191 func_odbc_substring=no			# Function ODBC SUBSTRING
  192 func_odbc_tan=yes			# Function TAN
  193 func_odbc_timestampadd=no		# Function TIMESTAMPADD
  194 func_odbc_timestampdiff=no		# Function TIMESTAMPDIFF
  195 func_odbc_truncate=yes			# Function TRUNCATE
  196 func_odbc_ucase=yes			# Function UCASE
  197 func_odbc_user=yes			# Function USER
  198 func_odbc_user()=yes			# Function USER()
  199 func_odbc_week=no			# Function WEEK
  200 func_odbc_year=yes			# Function YEAR
  201 func_sql_+=yes				# Function +, -, * and /
  202 func_sql_bit_length=no			# Function BIT_LENGTH
  203 func_sql_case=no			# Function CASE
  204 func_sql_cast=no			# Function CAST
  205 func_sql_char_length=no			# Function CHAR_LENGTH
  206 func_sql_character_length=no		# Function CHARACTER_LENGTH
  207 func_sql_concat_as_||=yes		# Function concatenation with ||
  208 func_sql_current_date=no		# Function CURRENT_DATE
  209 func_sql_current_date()=no		# Function CURRENT_DATE()
  210 func_sql_current_time=no		# Function CURRENT_TIME
  211 func_sql_current_time()=no		# Function CURRENT_TIME()
  212 func_sql_current_timestamp=no		# Function CURRENT_TIMESTAMP
  213 func_sql_current_timestamp()=no		# Function CURRENT_TIMESTAMP()
  214 func_sql_lower=yes			# Function LOWER
  215 func_sql_octet_length=no		# Function OCTET_LENGTH
  216 func_sql_position=no			# Function POSITION
  217 func_sql_session_user=no		# Function SESSION_USER
  218 func_sql_substring=no			# Function ANSI SQL SUBSTRING
  219 func_extra_sysdate=no			# Function SYSDATE
  220 func_sql_system_user=no			# Function SYSTEM_USER
  221 func_sql_trim=no			# Function TRIM
  222 func_sql_upper=yes			# Function UPPER
  223 func_where_between=yes			# Function BETWEEN
  224 func_where_eq_all=yes			# Function = ALL
  225 func_where_eq_any=yes			# Function = ANY
  226 func_where_eq_some=yes			# Function = SOME
  227 func_where_exists=yes			# Function EXISTS
  228 func_where_in_num=yes			# Function IN on numbers
  229 func_where_like=yes			# Function LIKE
  230 func_where_like_escape=yes		# Function LIKE ESCAPE
  231 func_where_match=no			# Function MATCH
  232 func_where_match_unique=no		# Function MATCH UNIQUE
  233 func_where_matches=no			# Function MATCHES
  234 func_where_not_between=yes		# Function NOT BETWEEN
  235 func_where_not_exists=yes		# Function NOT EXISTS
  236 func_where_not_like=yes			# Function NOT LIKE
  237 func_where_not_unique=no		# Function NOT UNIQUE
  238 func_where_unique=no			# Function UNIQUE
  239 functions=yes				# Functions
  240 group_by=yes				# Group by
  241 group_by_alias=no			# Group by alias
  242 group_by_null=yes			# null values in group by
  243 group_by_position=no			# Group by position
  244 group_distinct_functions=yes		# Group functions with distinct
  245 group_func_extra_bit_and=no		# Group function BIT_AND
  246 group_func_extra_bit_or=no		# Group function BIT_OR
  247 group_func_extra_std=no			# Group function STD
  248 group_func_extra_stddev=yes		# Group function STDDEV
  249 group_func_extra_variance=yes		# Group function VARIANCE
  250 group_func_sql_avg=yes			# Group function AVG
  251 group_func_sql_count_*=yes		# Group function COUNT (*)
  252 group_func_sql_count_column=yes		# Group function COUNT column name
  253 group_func_sql_count_distinct=yes	# Group function COUNT DISTINCT column name
  254 group_func_sql_max=yes			# Group function MAX on numbers
  255 group_func_sql_max_str=yes		# Group function MAX on strings
  256 group_func_sql_min=yes			# Group function MIN on numbers
  257 group_func_sql_min_str=yes		# Group function MIN on strings
  258 group_func_sql_sum=yes			# Group function SUM
  259 group_functions=yes			# Group functions
  260 having=yes				# Having
  261 having_with_alias=no			# Having on alias
  262 having_with_group=yes			# Having with group function
  263 ignore_end_space=yes			# ignore end space in compare
  264 index_in_create=no			# index in create table
  265 index_namespace=no			# different namespace for index
  266 index_parts=no				# index on column part (extension)
  267 insert_empty_string=yes			# insert empty string
  268 insert_select=yes			# insert INTO ... SELECT ...
  269 insert_with_set=yes			# INSERT with set syntax
  270 intersect=yes				# intersect
  271 intersect_all=yes			# intersect all
  272 join_tables=16				# tables in join
  273 left_outer_join=no			# left outer join
  274 left_outer_join_using=no		# left outer join using
  275 like_with_column=yes			# column LIKE column
  276 like_with_number=no			# LIKE on numbers
  277 lock_tables=yes				# lock table
  278 logical_value=not supported		# Value of logical operation (1=1)
  279 max_big_expressions=1			# big expressions
  280 max_char_size=4000			# max char() size
  281 max_column_name=+512			# column name length
  282 max_columns=254				# Columns in table
  283 max_conditions=252			# OR and AND in WHERE
  284 max_expressions=1723			# simple expressions
  285 max_index=+64				# max index
  286 max_index_length=254			# index length
  287 max_index_name=+512			# index name length
  288 max_index_part_length=254		# max index part length
  289 max_index_parts=15			# index parts
  290 max_index_varchar_part_length=254	# index varchar part length
  291 max_row_length=3991			# max table row length (without blobs)
  292 max_row_length_with_null=3991		# table row length with nulls (without blobs)
  293 max_select_alias_name=+512		# select alias name length
  294 max_stack_expression=1022		# stacked expressions
  295 max_table_alias_name=+512		# table alias name length
  296 max_table_name=+512			# table name length
  297 max_unique_index=+64			# unique indexes
  298 max_varchar_size=4000			# max varchar() size
  299 minus=no				# minus
  300 minus_neg=yes				# Calculate 1--1
  301 multi_drop=no				# many tables to drop table
  302 multi_strings=no			# Multiple line strings
  303 multi_table_delete=no			# DELETE FROM table1,table2...
  304 multi_table_update=no			# Update with many tables
  305 insert_multi_value=no			# Value lists in INSERT
  306 natural_join=no				# natural join
  307 natural_left_outer_join=no		# natural left outer join
  308 no_primary_key=yes			# Tables without primary key
  309 null_concat_expr=yes			# Is 'a' || NULL = NULL
  310 null_in_index=yes			# null in index
  311 null_in_unique=yes			# null in unique
  312 null_num_expr=yes			# Is 1+NULL = NULL
  313 odbc_left_outer_join=yes		# left outer join odbc style
  314 operating_system=Linux 2.0.35 i686	# crash-me tested on
  315 order_by=yes				# Order by
  316 order_by_alias=yes			# Order by alias
  317 order_by_position=yes			# Order by position
  318 primary_key_in_create=yes		# primary key in create table
  319 query_size=8202				# query size
  320 quote_with_"=no				# Allows ' and " as string markers
  321 recursive_subqueries=223		# recursive subqueries
  322 remember_end_space=no			# Remembers end space in char()
  323 remember_end_space_varchar=no		# Remembers end space in varchar()
  324 right_outer_join=no			# right outer join
  325 round_on_store=yes			# Correct rounding when storing float values
  326 select_constants=yes			# Select constants
  327 select_string_size=4023			# constant string size in SELECT
  328 select_table_update=no			# Update with sub select
  329 select_without_from=no			# SELECT without FROM
  330 server_version=Adabas 10.01.00		# server version
  331 simple_joins=yes			# ANSI SQL simple joins
  332 subqueries=yes				# subqueries
  333 table_alias=no				# Table alias
  334 table_name_case=no			# case independent table names
  335 table_wildcard=yes			# Select table_name.*
  336 transactions=yes			# transactions
  337 type_extra_abstime=no			# Type abstime
  338 type_extra_bfile=no			# Type bfile
  339 type_extra_blob=no			# Type blob
  340 type_extra_bool=no			# Type bool
  341 type_extra_box=no			# Type box
  342 type_extra_byte=no			# Type byte
  343 type_extra_char(1_arg)_binary=no		# Type char(1 arg) binary
  344 type_extra_char16=no			# Type char16
  345 type_extra_char2=no			# Type char2
  346 type_extra_char4=no			# Type char4
  347 type_extra_char8=no			# Type char8
  348 type_extra_circle=no			# Type circle
  349 type_extra_clob=no			# Type clob
  350 type_extra_datetime=no			# Type datetime
  351 type_extra_enum(1_arg)=no			# Type enum(1 arg)
  352 type_sql_float(1_arg)=yes			# Type float(1 arg)
  353 type_extra_float4=no			# Type float4
  354 type_extra_float8=no			# Type float8
  355 type_extra_image=no			# Type image
  356 type_extra_int(1_arg)_zerofill=no		# Type int(1 arg) zerofill
  357 type_extra_int1=no			# Type int1
  358 type_extra_int2=no			# Type int2
  359 type_extra_int3=no			# Type int3
  360 type_extra_int4=no			# Type int4
  361 type_extra_int8=no			# Type int8
  362 type_extra_int_auto_increment=no	# Type int not null auto_increment
  363 type_extra_line=no			# Type line
  364 type_extra_long=yes			# Type long
  365 type_extra_long_raw=no			# Type long raw
  366 type_extra_long_varbinary=no		# Type long varbinary
  367 type_extra_long_varchar(1_arg)=no		# Type long varchar(1 arg)
  368 type_extra_lseg=no			# Type lseg
  369 type_extra_mediumint=no			# Type mediumint
  370 type_extra_mediumtext=no		# Type mediumtext
  371 type_extra_middleint=no			# Type middleint
  372 type_extra_mlslabel=no			# Type mlslabel
  373 type_extra_money=no			# Type money
  374 type_sql_nchar(1_arg)=no			# Type nchar(1 arg)
  375 type_extra_nclob=no			# Type nclob
  376 type_extra_number=no			# Type number
  377 type_extra_number(1_arg)=no			# Type number(1 arg)
  378 type_extra_nvarchar(2_arg)=no		# Type nvarchar(2 arg)
  379 type_extra_nvarchar2(1_arg)=no		# Type nvarchar2(1 arg)
  380 type_extra_path=no			# Type path
  381 type_extra_point=no			# Type point
  382 type_extra_polygon=no			# Type polygon
  383 type_extra_raw(1_arg)=no			# Type raw(1 arg)
  384 type_extra_reltime=no			# Type reltime
  385 type_extra_rowid=no			# Type rowid
  386 type_extra_serial=no			# Type serial
  387 type_extra_set(1_arg)=no			# Type set(1 arg)
  388 type_extra_smalldatetime=no		# Type smalldatetime
  389 type_extra_smallfloat=no		# Type smallfloat
  390 type_extra_smallmoney=no		# Type smallmoney
  391 type_extra_text=no			# Type text
  392 type_extra_text(1_arg)=no			# Type text(1 arg)
  393 type_extra_timespan=no			# Type timespan
  394 type_extra_varchar2(1_arg)=no		# Type varchar2(1 arg)
  395 type_extra_year=no			# Type year
  396 type_odbc_bigint=no			# Type bigint
  397 type_odbc_binary(1_arg)=yes			# Type binary(1 arg)
  398 type_odbc_datetime=no			# Type datetime
  399 type_sql_smallint=yes			# Type smallint
  400 type_odbc_tinyint=no			# Type tinyint
  401 type_odbc_varbinary(1_arg)=no		# Type varbinary(1 arg)
  402 type_sql_bit=no				# Type bit
  403 type_sql_bit(1_arg)=no			# Type bit(1 arg)
  404 type_sql_bit_varying(1_arg)=no		# Type bit varying(1 arg)
  405 type_sql_char(1_arg)=yes			# Type char(1 arg)
  406 type_sql_char_varying(1_arg)=no		# Type char varying(1 arg)
  407 type_sql_character(1_arg)=yes		# Type character(1 arg)
  408 type_sql_character_varying(1_arg)=no		# Type character varying(1 arg)
  409 type_sql_date=yes			# Type date
  410 type_sql_dec(2_arg)=yes			# Type dec(2 arg)
  411 type_sql_decimal(2_arg)=yes			# Type decimal(2 arg)
  412 type_extra_double=no			# Type double
  413 type_sql_double_precision=yes		# Type double precision
  414 type_sql_float=yes			# Type float
  415 type_extra_float(2_arg)=no			# Type float(1 arg)
  416 type_sql_int=yes			# Type int
  417 type_sql_integer=yes			# Type integer
  418 type_sql_interval_year=no		# Type interval year
  419 type_sql_numeric(2_arg)=no			# Type numeric(2 arg)
  420 type_sql_real=yes			# Type real
  421 type_sql_time=yes			# Type time
  422 type_sql_timestamp=yes			# Type timestamp
  423 type_sql_varchar(1_arg)=yes			# Type varchar(1 arg)
  424 union=yes				# union
  425 union_all=yes				# union all
  426 unique_in_create=yes			# unique in create table
  427 unique_null_in_create=yes		# unique null in create
  428 views=yes				# views
  429 where_string_size=4023			# constant string size in where