From 68d07cbcc46b7690c23e5f112ab12cba7233fd81 Mon Sep 17 00:00:00 2001 From: unknown Date: Wed, 5 May 2004 12:31:17 +0300 Subject: Fixed crashing bug with alter table when table was in use (Bug #3643) We didn't use 'only index' for tables of type 'const'. (Bug #3497) mysql-test/r/func_str.result: New testfin mysql-test/r/key.result: New test mysql-test/r/key_primary.result: Update after "We didn't use 'only index' for tables of type 'const'" fix. mysql-test/r/null_key.result: Update after "We didn't use 'only index' for tables of type 'const'" fix. mysql-test/r/subselect.result: Update after "We didn't use 'only index' for tables of type 'const'" fix. mysql-test/t/func_str.test: Updated bug texts Added test for conversion of long string value to integer (Bug #3472) mysql-test/t/key.test: Test of key read with primary key (Bug #3497) sql/item.cc: Added assert sql/sql_base.cc: Fixed crashing bug with alter table when table was in use (Bug #3643) sql/sql_load.cc: Indentation fixes sql/sql_select.cc: We didn't use 'only index' for tables of type 'const'. (Bug #3497) --- mysql-test/r/func_str.result | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'mysql-test/r/func_str.result') diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index d3225679b3e..bdba9e4c3e4 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -639,3 +639,14 @@ name aaaaaaaaaaccccc bbbbbbbbbbddddd drop table t1, t2; +create table t1 (c1 INT); +insert into t1 (c1) values ('21474836461'); +Warnings: +Warning 1265 Data truncated for column 'c1' at row 1 +show warnings; +Level Code Message +Warning 1265 Data truncated for column 'c1' at row 1 +select * from t1; +c1 +2147483647 +drop table t1; -- cgit v1.2.1