diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/storage/t/update_virtual_column.test')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/storage/t/update_virtual_column.test | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/storage/t/update_virtual_column.test b/storage/mroonga/mysql-test/mroonga/storage/t/update_virtual_column.test new file mode 100644 index 00000000000..f5d85de4043 --- /dev/null +++ b/storage/mroonga/mysql-test/mroonga/storage/t/update_virtual_column.test @@ -0,0 +1,43 @@ +# Copyright(C) 2010 Tetsuro IKEDA +# +# This library is free software; you can redistribute it and/or +# modify it under the terms of the GNU Lesser General Public +# License as published by the Free Software Foundation; either +# version 2.1 of the License, or (at your option) any later version. +# +# This library is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU +# Lesser General Public License for more details. +# +# You should have received a copy of the GNU Lesser General Public +# License along with this library; if not, write to the Free Software +# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA + +--source include/not_embedded.inc +--source ../../include/mroonga/have_mroonga.inc + +--disable_warnings +drop table if exists t1, t2, t3; +--enable_warnings + +# for virtual columns +create table t1 (c1 int, _id int); +insert into t1 values(1,null); +insert into t1 values(2,null); +insert into t1 values(3,null); +select * from t1; +set sql_mode=""; +# warning WARN_DATA_TRUNCATED +update t1 set _id = 10 where c1 = 1; +select * from t1; +set sql_mode="strict_all_tables"; +# We can't use WARN_DATA_TRUNCATED here because "WXXX" isn't supported +# MySQL 5.5, 5.6 and MariaDB 5.6. MariaDB 10.0 only supports it. +# We share this test with all MySQL servers. So we use number here. +--error 1265 +update t1 set _id = 11 where c1 = 1; +select * from t1; +drop table t1; + +--source ../../include/mroonga/have_mroonga_deinit.inc |