summaryrefslogtreecommitdiff
path: root/mysql-test/t/create.test
diff options
context:
space:
mode:
authorunknown <gshchepa/uchum@gleb.loc>2007-07-26 03:33:43 +0500
committerunknown <gshchepa/uchum@gleb.loc>2007-07-26 03:33:43 +0500
commit2df3b7b0ea0681c6fafeda7d6c017404691d5cb9 (patch)
tree9586be2beae68dcf0a316792398609129103c820 /mysql-test/t/create.test
parent607ab14cf767ed0187e0c050ed61cb4ebaf34bb7 (diff)
parent0784d92414cba073201000ed0df23d136a6df077 (diff)
downloadmariadb-git-2df3b7b0ea0681c6fafeda7d6c017404691d5cb9.tar.gz
Merge gleb.loc:/home/uchum/work/bk/5.0
into gleb.loc:/home/uchum/work/bk/5.0-opt mysql-test/t/create.test: Auto merged sql/field.cc: Auto merged sql/sql_base.cc: Auto merged sql/table.cc: Auto merged mysql-test/r/create.result: Merge with 5.0 (main).
Diffstat (limited to 'mysql-test/t/create.test')
-rw-r--r--mysql-test/t/create.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/create.test b/mysql-test/t/create.test
index a6679cd674a..64081c0248a 100644
--- a/mysql-test/t/create.test
+++ b/mysql-test/t/create.test
@@ -1138,4 +1138,14 @@ create table t2(a int not null, b int not null, c int not null, primary key (a),
foreign key fk_bug26104 (b,c) references t1(a));
drop table t1;
+#
+# Bug#15130:CREATE .. SELECT was denied to use advantages of the SQL_BIG_RESULT.
+#
+create table t1(f1 int,f2 int);
+insert into t1 value(1,1),(1,2),(1,3),(2,1),(2,2),(2,3);
+flush status;
+create table t2 select sql_big_result f1,count(f2) from t1 group by f1;
+show status like 'handler_read%';
+drop table t1,t2;
+
--echo End of 5.0 tests