summaryrefslogtreecommitdiff
path: root/mysql-test/t/partition_hash.test
diff options
context:
space:
mode:
authorMattias Jonsson <mattiasj@mysql.com>2008-06-03 13:25:41 +0200
committerMattias Jonsson <mattiasj@mysql.com>2008-06-03 13:25:41 +0200
commita8af693b5031019646c5bdffa50df760123182e5 (patch)
treeb16830a525163b32894bb97f2bb0546f6dfa0daf /mysql-test/t/partition_hash.test
parentc392457f7c234f55dfb74104771b216b15458383 (diff)
downloadmariadb-git-a8af693b5031019646c5bdffa50df760123182e5.tar.gz
Bug#31210: INSERT DELAYED crashes server when used on partitioned tables
Problem was an unclear error message since it could suggest that MyISAM did not support INSERT DELAYED. Changed the error message to say that DELAYED is not supported by the table, instead of the table's storage engine. The confusion is that a partitioned table is in somewhat sense using the partitioning storage engine, which in turn uses the ordinary storage engine. By saying that the table does not support DELAYED we do not give any extra informantion about the storage engine or if it is partitioned. mysql-test/r/innodb-replace.result: Bug#31210: INSERT DELAYED crashes server when used on partitioned tables changed error message mysql-test/t/innodb-replace.test: Bug#31210: INSERT DELAYED crashes server when used on partitioned tables changed error message mysql-test/t/merge.test: Bug#31210: INSERT DELAYED crashes server when used on partitioned tables changed error message mysql-test/t/partition_hash.test: Bug#31210: INSERT DELAYED crashes server when used on partitioned tables changed error message sql/share/errmsg.txt: Bug#31210: INSERT DELAYED crashes server when used on partitioned tables added error message for tables not supporting DELAYED sql/sql_insert.cc: Bug#31210: INSERT DELAYED crashes server when used on partitioned tables changed error message
Diffstat (limited to 'mysql-test/t/partition_hash.test')
-rw-r--r--mysql-test/t/partition_hash.test5
1 files changed, 3 insertions, 2 deletions
diff --git a/mysql-test/t/partition_hash.test b/mysql-test/t/partition_hash.test
index 362d5f747e9..5b9aa5707b9 100644
--- a/mysql-test/t/partition_hash.test
+++ b/mysql-test/t/partition_hash.test
@@ -165,8 +165,9 @@ drop table t1;
#
CREATE TABLE t1 (c1 INT) ENGINE=MyISAM PARTITION BY HASH(c1) PARTITIONS 1;
# The test succeeds in an embedded server because normal insert is done.
-# The test fails in a normal server with "engine doesn't have this option".
---error 0, ER_ILLEGAL_HA
+# The test fails in a normal server with
+# "DELAYED option not supported by table".
+--error 0, ER_DELAYED_NOT_SUPPORTED
INSERT DELAYED INTO t1 VALUES (1);
DROP TABLE t1;