diff options
| author | unknown <sergefp@mysql.com> | 2005-04-18 05:21:44 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-04-18 05:21:44 +0400 |
| commit | 955ec71f78a16cd6de19cd48cb7faa2874f5cdc9 (patch) | |
| tree | 666579fabdd2725c17ffedc83d49cbd6276c1daf /mysql-test/r/update.result | |
| parent | b51f70b81e6af314093dd28728a3dc68d1a28fff (diff) | |
| download | mariadb-git-955ec71f78a16cd6de19cd48cb7faa2874f5cdc9.tar.gz | |
Fix for BUG#9103:
Don't produce data truncation warnings from within cp_buffer_from_ref(). This function
is only used to make index search tuples and data truncation that occurs here has no
relation with truncated values being saved into tables.
mysql-test/r/update.result:
Testcase for BUG#9103
mysql-test/t/update.test:
Testcase for BUG#9103
sql/opt_range.cc:
cp_buffer_from_ref now has THD* parameter
sql/sql_select.h:
cp_buffer_from_ref now has THD* parameter
Diffstat (limited to 'mysql-test/r/update.result')
| -rw-r--r-- | mysql-test/r/update.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/update.result b/mysql-test/r/update.result index 4a9e95fb89e..d83952e118b 100644 --- a/mysql-test/r/update.result +++ b/mysql-test/r/update.result @@ -226,3 +226,17 @@ select * from t1; a b 0 2 drop table t1; +create table t1 (a int, b varchar(10), key b(b(5))) engine=myisam; +create table t2 (a int, b varchar(10)) engine=myisam; +insert into t1 values ( 1, 'abcd1e'); +insert into t1 values ( 2, 'abcd2e'); +insert into t2 values ( 1, 'abcd1e'); +insert into t2 values ( 2, 'abcd2e'); +analyze table t1,t2; +Table Op Msg_type Msg_text +test.t1 analyze status OK +test.t2 analyze status OK +update t1, t2 set t1.a = t2.a where t2.b = t1.b; +show warnings; +Level Code Message +drop table t1, t2; |