diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2018-11-11 14:20:37 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2019-03-12 13:10:49 +0100 |
| commit | 22f1cf9292f859f2f59208f267917481b29d4739 (patch) | |
| tree | 13fd60bcaad9487c60db585afaa5281d367c0c0f /mysql-test | |
| parent | dda2e940fb035d41852e95a1c2f513ab1534b041 (diff) | |
| download | mariadb-git-22f1cf9292f859f2f59208f267917481b29d4739.tar.gz | |
cleanup: misc
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/analyze_stmt.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/analyze_stmt.test | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/r/analyze_stmt.result b/mysql-test/r/analyze_stmt.result index c3c98593210..3ae49c5eeb6 100644 --- a/mysql-test/r/analyze_stmt.result +++ b/mysql-test/r/analyze_stmt.result @@ -247,7 +247,7 @@ drop table t1; # create table t1 (i int); insert into t1 values (1); -analyze select * from t1 into @var; +analyze select * into @var from t1 ; id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra 1 SIMPLE t1 system NULL NULL NULL NULL 1 NULL 100.00 NULL drop table t1; @@ -281,10 +281,10 @@ drop table t1; # create table t1(a int); insert into t1 values (1),(2); -analyze select a from t1 where a <2 into @var; +analyze select a into @var from t1 where a <2 ; id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra 1 SIMPLE t1 ALL NULL NULL NULL NULL 2 2.00 100.00 50.00 Using where -analyze select a from t1 into @var; +analyze select a into @var from t1 ; ERROR 42000: Result consisted of more than one row analyze insert into t1 select * from t1; id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra diff --git a/mysql-test/t/analyze_stmt.test b/mysql-test/t/analyze_stmt.test index d02139fe0c8..15fc00a321d 100644 --- a/mysql-test/t/analyze_stmt.test +++ b/mysql-test/t/analyze_stmt.test @@ -196,7 +196,7 @@ drop table t1; --echo # create table t1 (i int); insert into t1 values (1); -analyze select * from t1 into @var; +analyze select * into @var from t1 ; drop table t1; --echo # @@ -223,9 +223,9 @@ drop table t1; create table t1(a int); insert into t1 values (1),(2); -analyze select a from t1 where a <2 into @var; +analyze select a into @var from t1 where a <2 ; --error ER_TOO_MANY_ROWS -analyze select a from t1 into @var; +analyze select a into @var from t1 ; analyze insert into t1 select * from t1; |