diff options
author | unknown <monty@donna.mysql.com> | 2000-11-29 05:09:28 +0200 |
---|---|---|
committer | unknown <monty@donna.mysql.com> | 2000-11-29 05:09:28 +0200 |
commit | 2c036ff7b95fd7350d9cb207470ae0022b81e76f (patch) | |
tree | ee9a533ec9c7faa983b88519569d772d4c829bc1 /sql-bench/limits | |
parent | 2c660371c9a8930883bdf8d8b1b46d57b5f6265c (diff) | |
download | mariadb-git-2c036ff7b95fd7350d9cb207470ae0022b81e76f.tar.gz |
Fixed bug in 'drop table'
Portability fixes
sql-bench/bench-init.pl.sh:
Change mode to -rw-rw-r--
sql-bench/compare-results.sh:
Change mode to -rw-rw-r--
sql-bench/run-all-tests.sh:
Change mode to -rw-rw-r--
sql-bench/test-ATIS.sh:
Change mode to -rw-rw-r--
sql-bench/test-alter-table.sh:
Change mode to -rw-rw-r--
sql-bench/test-big-tables.sh:
Change mode to -rw-rw-r--
sql-bench/test-connect.sh:
Change mode to -rw-rw-r--
sql-bench/test-create.sh:
Change mode to -rw-rw-r--
sql-bench/test-select.sh:
Change mode to -rw-rw-r--
sql-bench/test-wisconsin.sh:
Change mode to -rw-rw-r--
Docs/manual.texi:
Added documentation for perror
myisam/mi_check.c:
Portability fix
mysql-test/chew_on_this/select.res:
***MISSING WEAVE***
scripts/mysqlhotcopy.sh:
Added --noindices
sql-bench/Results/ATIS-mysql-Linux_2.2.13_SMP_alpha:
New benchmark results
sql-bench/Results/RUN-mysql-Linux_2.2.13_SMP_alpha:
New benchmark results
sql-bench/Results/alter-table-mysql-Linux_2.2.13_SMP_alpha:
New benchmark results
sql-bench/Results/big-tables-mysql-Linux_2.2.13_SMP_alpha:
New benchmark results
sql-bench/Results/connect-mysql-Linux_2.2.13_SMP_alpha:
New benchmark results
sql-bench/Results/create-mysql-Linux_2.2.13_SMP_alpha:
New benchmark results
sql-bench/Results/insert-mysql-Linux_2.2.13_SMP_alpha:
New benchmark results
sql-bench/Results/select-mysql-Linux_2.2.13_SMP_alpha:
New benchmark results
sql-bench/Results/wisconsin-mysql-Linux_2.2.13_SMP_alpha:
New benchmark results
sql-bench/copy-db.sh:
Changed multi_value_insert -> insert_multi_value
sql-bench/crash-me.sh:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/Adabas.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/access.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/access_odbc.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/frontbase.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/interbase.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/mimer.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/ms-sql.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/msql.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/mysql-3.22.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/mysql-3.23.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/mysql.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/oracle.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/limits/pg.cfg:
Changed multi_value_insert -> insert_multi_value
sql-bench/print-limit-table:
Better groups
sql-bench/server-cfg.sh:
Changed multi_value_insert -> insert_multi_value
sql-bench/test-insert.sh:
Changed multi_value_insert -> insert_multi_value
sql/ha_myisam.cc:
Added warning of number of rows changed in optimize
sql/mysqlbinlog.cc:
Portability fix
sql/mysqld.cc:
Changed mysqld to take less stack and safer shutdown
sql/share/swedish/errmsg.OLD:
update
sql/sql_base.cc:
Fixed 'drop table' bug
sql/sql_parse.cc:
Fixed bug in 'TRUNCATE'
sql/sql_show.cc:
Don't lock keycache when you do 'show variables'
Diffstat (limited to 'sql-bench/limits')
-rw-r--r-- | sql-bench/limits/Adabas.cfg | 2 | ||||
-rw-r--r-- | sql-bench/limits/access.cfg | 2 | ||||
-rw-r--r-- | sql-bench/limits/access_odbc.cfg | 2 | ||||
-rw-r--r-- | sql-bench/limits/frontbase.cfg | 6 | ||||
-rw-r--r-- | sql-bench/limits/interbase.cfg | 2 | ||||
-rw-r--r-- | sql-bench/limits/mimer.cfg | 2 | ||||
-rw-r--r-- | sql-bench/limits/ms-sql.cfg | 2 | ||||
-rw-r--r-- | sql-bench/limits/msql.cfg | 2 | ||||
-rw-r--r-- | sql-bench/limits/mysql-3.22.cfg | 2 | ||||
-rw-r--r-- | sql-bench/limits/mysql-3.23.cfg | 25 | ||||
-rw-r--r-- | sql-bench/limits/mysql.cfg | 25 | ||||
-rw-r--r-- | sql-bench/limits/oracle.cfg | 2 | ||||
-rw-r--r-- | sql-bench/limits/pg.cfg | 2 |
13 files changed, 43 insertions, 33 deletions
diff --git a/sql-bench/limits/Adabas.cfg b/sql-bench/limits/Adabas.cfg index 939d1731006..99aaa36ab52 100644 --- a/sql-bench/limits/Adabas.cfg +++ b/sql-bench/limits/Adabas.cfg @@ -302,7 +302,7 @@ 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 -multi_value_insert=no # Value lists in INSERT +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 diff --git a/sql-bench/limits/access.cfg b/sql-bench/limits/access.cfg index 19e59e98168..86d43bdee6a 100644 --- a/sql-bench/limits/access.cfg +++ b/sql-bench/limits/access.cfg @@ -343,7 +343,7 @@ multi_null_in_unique=yes # null in unique index multi_strings=no # Multiple line strings multi_table_delete=yes # DELETE FROM table1,table2... multi_table_update=yes # Update with many tables -multi_value_insert=no # Value lists in INSERT +insert_multi_value=no # Value lists in INSERT natural_join=no # natural join natural_join_incompat=no # natural join (incompatible lists) natural_left_outer_join=no # natural left outer join diff --git a/sql-bench/limits/access_odbc.cfg b/sql-bench/limits/access_odbc.cfg index fc06ce97fac..cc2e05c0154 100644 --- a/sql-bench/limits/access_odbc.cfg +++ b/sql-bench/limits/access_odbc.cfg @@ -309,7 +309,7 @@ multi_drop=yes # many tables to drop table multi_strings=no # Multiple line strings
multi_table_delete=yes # DELETE FROM table1,table2...
multi_table_update=yes # Update with many tables
-multi_value_insert=no # Value lists in INSERT
+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
diff --git a/sql-bench/limits/frontbase.cfg b/sql-bench/limits/frontbase.cfg index af7d9c55168..f8aad442131 100644 --- a/sql-bench/limits/frontbase.cfg +++ b/sql-bench/limits/frontbase.cfg @@ -349,7 +349,7 @@ multi_drop=no # many tables to drop table multi_strings=yes # Multiple line strings multi_table_delete=no # DELETE FROM table1,table2... multi_table_update=no # Update with many tables -multi_value_insert=yes # Value lists in INSERT +insert_multi_value=yes # Value lists in INSERT natural_join=no # natural join natural_join_incompat=no # natural join (incompatible lists) natural_left_outer_join=yes # natural left outer join @@ -388,14 +388,14 @@ select_limit2=no # SELECT with LIMIT #,# select_string_size=4199664 # constant string size in SELECT select_table_update=yes # Update with sub select select_without_from=no # SELECT without FROM -server_version=2.1 # server version +server_version=FrontBase 2.1 # server version simple_joins=yes # ANSI SQL simple joins storage_of_float=round # Storage of float values subqueries=yes # subqueries table_alias=yes # Table alias table_name_case=yes # case independent table names table_wildcard=yes # Select table_name.* -tempoary_table=no # temporary tables +temporary_table=no # temporary tables transactions=error # transactions truncate_table=no # truncate type_extra_abstime=no # Type abstime diff --git a/sql-bench/limits/interbase.cfg b/sql-bench/limits/interbase.cfg index 7427208df5d..994799e5ea0 100644 --- a/sql-bench/limits/interbase.cfg +++ b/sql-bench/limits/interbase.cfg @@ -315,7 +315,7 @@ 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 -multi_value_insert=no # Value lists in INSERT +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 diff --git a/sql-bench/limits/mimer.cfg b/sql-bench/limits/mimer.cfg index d18e43aa892..b3369f9a622 100644 --- a/sql-bench/limits/mimer.cfg +++ b/sql-bench/limits/mimer.cfg @@ -334,7 +334,7 @@ multi_drop=no # many tables to drop table multi_strings=yes # Multiple line strings multi_table_delete=no # DELETE FROM table1,table2... multi_table_update=no # Update with many tables -multi_value_insert=no # Value lists in INSERT +insert_multi_value=no # Value lists in INSERT natural_join=yes # natural join natural_left_outer_join=yes # natural left outer join no_primary_key=yes # Tables without primary key diff --git a/sql-bench/limits/ms-sql.cfg b/sql-bench/limits/ms-sql.cfg index b9cad41c1a1..9307590cd40 100644 --- a/sql-bench/limits/ms-sql.cfg +++ b/sql-bench/limits/ms-sql.cfg @@ -345,7 +345,7 @@ 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 -multi_value_insert=no # Value lists in INSERT +insert_multi_value=no # Value lists in INSERT natural_join=no # natural join natural_join_incompat=no # natural join (incompatible lists) natural_left_outer_join=no # natural left outer join diff --git a/sql-bench/limits/msql.cfg b/sql-bench/limits/msql.cfg index 028eb4cd399..382f3e2ae81 100644 --- a/sql-bench/limits/msql.cfg +++ b/sql-bench/limits/msql.cfg @@ -97,7 +97,7 @@ 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 -multi_value_insert=no # Value lists in INSERT +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 diff --git a/sql-bench/limits/mysql-3.22.cfg b/sql-bench/limits/mysql-3.22.cfg index 6f0ee740c5a..395673ee1e1 100644 --- a/sql-bench/limits/mysql-3.22.cfg +++ b/sql-bench/limits/mysql-3.22.cfg @@ -310,7 +310,7 @@ multi_drop=yes # many tables to drop table multi_strings=yes # Multiple line strings multi_table_delete=no # DELETE FROM table1,table2... multi_table_update=no # Update with many tables -multi_value_insert=yes # Value lists in INSERT +insert_multi_value=yes # Value lists in INSERT natural_join=no # natural join natural_left_outer_join=yes # natural left outer join no_primary_key=yes # Tables without primary key diff --git a/sql-bench/limits/mysql-3.23.cfg b/sql-bench/limits/mysql-3.23.cfg index 759208ad713..19bb3c67cc1 100644 --- a/sql-bench/limits/mysql-3.23.cfg +++ b/sql-bench/limits/mysql-3.23.cfg @@ -1,4 +1,4 @@ -#This file is automaticly generated by crash-me 1.51 +#This file is automaticly generated by crash-me 1.54 NEG=yes # update of column= -column Need_cast_for_null=no # Need to cast NULL for arithmetic @@ -18,10 +18,10 @@ alter_drop_unique=with drop key # Alter table drop unique alter_modify_col=yes # Alter table modify column alter_rename_table=yes # Alter table rename table atomic_updates=no # atomic updates -automatic_rowid=_rowid # Automatic rowid +automatic_rowid=_rowid # Automatic row id binary_numbers=no # binary numbers (0b1001) binary_strings=no # binary strings (b'0110') -case_insensitive_strings=yes # case insensitive compare +case_insensitive_strings=yes # Case insensitive compare char_is_space_filled=no # char are space filled column_alias=yes # Column alias columns_in_group_by=+64 # number of columns in group by @@ -36,7 +36,7 @@ constraint_check=no # Column constraints constraint_check_table=no # Table constraints constraint_null=yes # NULL constraint (SyBase style) crash_me_safe=yes # crash me safe -crash_me_version=1.51 # crash me version +crash_me_version=1.54 # crash me version create_default=yes # default value for column create_default_func=no # default value function for column create_if_not_exists=yes # create table if not exists @@ -55,6 +55,8 @@ dont_require_cast_to_float=yes # No need to cast from integer to float double_quotes=yes # Double '' as ' in strings drop_if_exists=yes # drop table if exists drop_index=with 'ON' # drop index +drop_requires_cascade=no # drop table require cascade/restrict +drop_restrict=yes # drop table with cascade/restrict end_colon=yes # allows end ';' except=no # except except_all=no # except all @@ -275,7 +277,7 @@ func_where_unique=no # Function UNIQUE functions=yes # Functions group_by=yes # Group by group_by_alias=yes # Group by alias -group_by_null=yes # group on column with null values +group_by_null=yes # Group on column with null values group_by_position=yes # Group by position group_distinct_functions=yes # Group functions with distinct group_func_extra_bit_and=yes # Group function BIT_AND @@ -297,18 +299,20 @@ group_func_sql_min_str=yes # Group function MIN on strings group_func_sql_some=no # Group function SOME group_func_sql_sum=yes # Group function SUM group_functions=yes # Group functions +group_on_unused=yes # Group on unused column has_true_false=no # TRUE and FALSE having=yes # Having having_with_alias=yes # Having on alias having_with_group=yes # Having with group function hex_numbers=yes # hex numbers (0x41) hex_strings=no # hex strings (x'1ace') -ignore_end_space=yes # ignore end space in compare +ignore_end_space=yes # Ignore end space in compare index_in_create=yes # index in create table index_namespace=yes # different namespace for index index_parts=yes # index on column part (extension) inner_join=yes # inner join insert_empty_string=yes # insert empty string +insert_multi_value=yes # INSERT with Value lists insert_select=yes # insert INTO ... SELECT ... insert_with_set=yes # INSERT with set syntax intersect=no # intersect @@ -351,7 +355,6 @@ multi_null_in_unique=yes # null in unique index multi_strings=yes # Multiple line strings multi_table_delete=no # DELETE FROM table1,table2... multi_table_update=no # Update with many tables -multi_value_insert=yes # Value lists in INSERT natural_join=yes # natural join natural_join_incompat=yes # natural join (incompatible lists) natural_left_outer_join=yes # natural left outer join @@ -360,6 +363,7 @@ null_concat_expr=yes # Is concat('a',NULL) = NULL null_in_index=yes # null in index null_in_unique=yes # null in unique index null_num_expr=yes # Is 1+NULL = NULL +nulls_in_unique=yes # null combination in unique index odbc_left_outer_join=yes # left outer join odbc style operating_system=Linux 2.2.13-SMP alpha # crash-me tested on order_by=yes # Order by @@ -367,6 +371,7 @@ order_by_alias=yes # Order by alias order_by_function=yes # Order by function order_by_position=yes # Order by position order_by_remember_desc=no # Order by DESC is remembered +order_on_unused=yes # Order by on unused column primary_key_in_create=yes # primary key in create table psm_functions=no # PSM functions (ANSI SQL) psm_modules=no # PSM modules (ANSI SQL) @@ -389,14 +394,14 @@ select_limit2=yes # SELECT with LIMIT #,# select_string_size=1048565 # constant string size in SELECT select_table_update=no # Update with sub select select_without_from=yes # SELECT without FROM -server_version=MySQL 3.23.28 gamma # server version +server_version=MySQL 3.23.29 gamma # server version simple_joins=yes # ANSI SQL simple joins storage_of_float=round # Storage of float values subqueries=no # subqueries table_alias=yes # Table alias table_name_case=no # case independent table names table_wildcard=yes # Select table_name.* -tempoary_table=yes # temporary tables +temporary_table=yes # temporary tables transactions=no # transactions truncate_table=yes # truncate type_extra_abstime=no # Type abstime @@ -515,4 +520,4 @@ unique_in_create=yes # unique in create table unique_null_in_create=yes # unique null in create user_comment=Alpha DS20 2x500 MHz, 2G memory, key_buffer=16M; ccc + cxx # comment views=no # views -where_string_size=1048540 # constant string size in where +where_string_size=1048539 # constant string size in where diff --git a/sql-bench/limits/mysql.cfg b/sql-bench/limits/mysql.cfg index 759208ad713..19bb3c67cc1 100644 --- a/sql-bench/limits/mysql.cfg +++ b/sql-bench/limits/mysql.cfg @@ -1,4 +1,4 @@ -#This file is automaticly generated by crash-me 1.51 +#This file is automaticly generated by crash-me 1.54 NEG=yes # update of column= -column Need_cast_for_null=no # Need to cast NULL for arithmetic @@ -18,10 +18,10 @@ alter_drop_unique=with drop key # Alter table drop unique alter_modify_col=yes # Alter table modify column alter_rename_table=yes # Alter table rename table atomic_updates=no # atomic updates -automatic_rowid=_rowid # Automatic rowid +automatic_rowid=_rowid # Automatic row id binary_numbers=no # binary numbers (0b1001) binary_strings=no # binary strings (b'0110') -case_insensitive_strings=yes # case insensitive compare +case_insensitive_strings=yes # Case insensitive compare char_is_space_filled=no # char are space filled column_alias=yes # Column alias columns_in_group_by=+64 # number of columns in group by @@ -36,7 +36,7 @@ constraint_check=no # Column constraints constraint_check_table=no # Table constraints constraint_null=yes # NULL constraint (SyBase style) crash_me_safe=yes # crash me safe -crash_me_version=1.51 # crash me version +crash_me_version=1.54 # crash me version create_default=yes # default value for column create_default_func=no # default value function for column create_if_not_exists=yes # create table if not exists @@ -55,6 +55,8 @@ dont_require_cast_to_float=yes # No need to cast from integer to float double_quotes=yes # Double '' as ' in strings drop_if_exists=yes # drop table if exists drop_index=with 'ON' # drop index +drop_requires_cascade=no # drop table require cascade/restrict +drop_restrict=yes # drop table with cascade/restrict end_colon=yes # allows end ';' except=no # except except_all=no # except all @@ -275,7 +277,7 @@ func_where_unique=no # Function UNIQUE functions=yes # Functions group_by=yes # Group by group_by_alias=yes # Group by alias -group_by_null=yes # group on column with null values +group_by_null=yes # Group on column with null values group_by_position=yes # Group by position group_distinct_functions=yes # Group functions with distinct group_func_extra_bit_and=yes # Group function BIT_AND @@ -297,18 +299,20 @@ group_func_sql_min_str=yes # Group function MIN on strings group_func_sql_some=no # Group function SOME group_func_sql_sum=yes # Group function SUM group_functions=yes # Group functions +group_on_unused=yes # Group on unused column has_true_false=no # TRUE and FALSE having=yes # Having having_with_alias=yes # Having on alias having_with_group=yes # Having with group function hex_numbers=yes # hex numbers (0x41) hex_strings=no # hex strings (x'1ace') -ignore_end_space=yes # ignore end space in compare +ignore_end_space=yes # Ignore end space in compare index_in_create=yes # index in create table index_namespace=yes # different namespace for index index_parts=yes # index on column part (extension) inner_join=yes # inner join insert_empty_string=yes # insert empty string +insert_multi_value=yes # INSERT with Value lists insert_select=yes # insert INTO ... SELECT ... insert_with_set=yes # INSERT with set syntax intersect=no # intersect @@ -351,7 +355,6 @@ multi_null_in_unique=yes # null in unique index multi_strings=yes # Multiple line strings multi_table_delete=no # DELETE FROM table1,table2... multi_table_update=no # Update with many tables -multi_value_insert=yes # Value lists in INSERT natural_join=yes # natural join natural_join_incompat=yes # natural join (incompatible lists) natural_left_outer_join=yes # natural left outer join @@ -360,6 +363,7 @@ null_concat_expr=yes # Is concat('a',NULL) = NULL null_in_index=yes # null in index null_in_unique=yes # null in unique index null_num_expr=yes # Is 1+NULL = NULL +nulls_in_unique=yes # null combination in unique index odbc_left_outer_join=yes # left outer join odbc style operating_system=Linux 2.2.13-SMP alpha # crash-me tested on order_by=yes # Order by @@ -367,6 +371,7 @@ order_by_alias=yes # Order by alias order_by_function=yes # Order by function order_by_position=yes # Order by position order_by_remember_desc=no # Order by DESC is remembered +order_on_unused=yes # Order by on unused column primary_key_in_create=yes # primary key in create table psm_functions=no # PSM functions (ANSI SQL) psm_modules=no # PSM modules (ANSI SQL) @@ -389,14 +394,14 @@ select_limit2=yes # SELECT with LIMIT #,# select_string_size=1048565 # constant string size in SELECT select_table_update=no # Update with sub select select_without_from=yes # SELECT without FROM -server_version=MySQL 3.23.28 gamma # server version +server_version=MySQL 3.23.29 gamma # server version simple_joins=yes # ANSI SQL simple joins storage_of_float=round # Storage of float values subqueries=no # subqueries table_alias=yes # Table alias table_name_case=no # case independent table names table_wildcard=yes # Select table_name.* -tempoary_table=yes # temporary tables +temporary_table=yes # temporary tables transactions=no # transactions truncate_table=yes # truncate type_extra_abstime=no # Type abstime @@ -515,4 +520,4 @@ unique_in_create=yes # unique in create table unique_null_in_create=yes # unique null in create user_comment=Alpha DS20 2x500 MHz, 2G memory, key_buffer=16M; ccc + cxx # comment views=no # views -where_string_size=1048540 # constant string size in where +where_string_size=1048539 # constant string size in where diff --git a/sql-bench/limits/oracle.cfg b/sql-bench/limits/oracle.cfg index b910f91fb05..ad2faf22971 100644 --- a/sql-bench/limits/oracle.cfg +++ b/sql-bench/limits/oracle.cfg @@ -345,7 +345,7 @@ multi_null_in_unique=yes # null in unique index multi_strings=no # Multiple line strings multi_table_delete=no # DELETE FROM table1,table2... multi_table_update=no # Update with many tables -multi_value_insert=no # Value lists in INSERT +insert_multi_value=no # Value lists in INSERT natural_join=no # natural join natural_join_incompat=no # natural join (incompatible lists) natural_left_outer_join=no # natural left outer join diff --git a/sql-bench/limits/pg.cfg b/sql-bench/limits/pg.cfg index 493d5f68150..1675cff71ef 100644 --- a/sql-bench/limits/pg.cfg +++ b/sql-bench/limits/pg.cfg @@ -343,7 +343,7 @@ multi_null_in_unique=yes # null in unique index multi_strings=yes # Multiple line strings multi_table_delete=no # DELETE FROM table1,table2... multi_table_update=no # Update with many tables -multi_value_insert=no # Value lists in INSERT +insert_multi_value=no # Value lists in INSERT natural_join=yes # natural join natural_join_incompat=yes # natural join (incompatible lists) natural_left_outer_join=no # natural left outer join |