From d44dd54bc838e6679f451a8faf07a7f44efe2fa4 Mon Sep 17 00:00:00 2001 From: Sergei Petrunia Date: Fri, 17 Oct 2014 14:18:10 +0400 Subject: MDEV-6400: "ANALYZE SELECT ... INTO @var" doesn't set @var Make ANALYZE work for - ANALYZE SELECT ... INTO @var - ANALYZE INSERT SELECT ...; - ANALYZE SELECT .. INTO OUTFILE --- mysql-test/t/analyze_stmt.test | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'mysql-test/t/analyze_stmt.test') diff --git a/mysql-test/t/analyze_stmt.test b/mysql-test/t/analyze_stmt.test index 4c89890ac29..f5c5c432434 100644 --- a/mysql-test/t/analyze_stmt.test +++ b/mysql-test/t/analyze_stmt.test @@ -217,3 +217,19 @@ analyze replace t1 values (1,2); select * from t1; drop table t1; +--echo # +--echo # MDEV-6400 "ANALYZE SELECT ... INTO @var" doesn't set @var +--echo # +create table t1(a int); +insert into t1 values (1),(2); + +analyze select a from t1 where a <2 into @var; +--error ER_TOO_MANY_ROWS +analyze select a from t1 into @var; + +analyze insert into t1 select * from t1; + +analyze select * into outfile '../../tmp/data1.tmp' from t1; +--remove_file $MYSQLTEST_VARDIR/tmp/data1.tmp + +drop table t1; -- cgit v1.2.1