diff options
author | Sergei Petrunia <psergey@askmonty.org> | 2014-10-17 14:18:10 +0400 |
---|---|---|
committer | Sergei Petrunia <psergey@askmonty.org> | 2014-10-17 14:18:10 +0400 |
commit | d44dd54bc838e6679f451a8faf07a7f44efe2fa4 (patch) | |
tree | edb516de233b2d52f50f614965fda2c6e25e1c03 /mysql-test/t/analyze_stmt.test | |
parent | fec5ab5a56cb9a45c621207620cc85079cddf537 (diff) | |
download | mariadb-git-d44dd54bc838e6679f451a8faf07a7f44efe2fa4.tar.gz |
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
Diffstat (limited to 'mysql-test/t/analyze_stmt.test')
-rw-r--r-- | mysql-test/t/analyze_stmt.test | 16 |
1 files changed, 16 insertions, 0 deletions
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; |