merged

1 files changed, 14 insertions, 0 deletions

diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test
index ce85e530569..2ba726f29e2 100644
--- a/mysql-test/t/create.test
+++ b/mysql-test/t/create.test
@@ -460,3 +460,17 @@ insert into t2 values ();
 select * from t1;
 select * from t2;
 drop table t1,t2;
+#
+# Bug#10224 - ANALYZE TABLE crashing with simultaneous
+# CREATE ... SELECT statement.
+# This tests two additional possible errors and a hang if 
+# an improper fix is present.
+#
+create table t1 (a int);
+--error 1093
+create table t1 select * from t1;
+--error 1093
+create table t2 union = (t1) select * from t1;
+flush tables with read lock;
+unlock tables;
+drop table t1;