summaryrefslogtreecommitdiff
path: root/mysql-test/r/heap_btree.result
diff options
context:
space:
mode:
authorunknown <venu@myvenu.com>2003-04-30 00:07:37 -0700
committerunknown <venu@myvenu.com>2003-04-30 00:07:37 -0700
commitb85712945457d5455f603678f8bcb15d2f929e82 (patch)
tree19e2ae7cf49f8bfd63f42100781c94f9338f4e54 /mysql-test/r/heap_btree.result
parent05af39d59102c5b46f71ca4d3626feba2c3c777a (diff)
downloadmariadb-git-b85712945457d5455f603678f8bcb15d2f929e82.tar.gz
Updated warning test
Updated all tests to catchup warnings for all field conversions mysql-test/t/ctype_many.test: Disable the warnings for misc conversion mysql-test/t/warnings.test: More warning tests
Diffstat (limited to 'mysql-test/r/heap_btree.result')
-rw-r--r--mysql-test/r/heap_btree.result6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/heap_btree.result b/mysql-test/r/heap_btree.result
index bf24f78321f..7f6c9f8e591 100644
--- a/mysql-test/r/heap_btree.result
+++ b/mysql-test/r/heap_btree.result
@@ -180,6 +180,12 @@ select * from t1 where btn like "q%";
btn
alter table t1 add column new_col char(1) not null, add key using BTREE (btn,new_col), drop key btn;
update t1 set new_col=btn;
+Warnings:
+Warning 1263 Data truncated for column 'new_col' at row 1
+Warning 1263 Data truncated for column 'new_col' at row 2
+Warning 1263 Data truncated for column 'new_col' at row 3
+Warning 1263 Data truncated for column 'new_col' at row 4
+Warning 1263 Data truncated for column 'new_col' at row 5
explain select * from t1 where btn="a";
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE t1 ref btn btn 10 const 1 Using where