diff options
| author | Sergei Petrunia <psergey@askmonty.org> | 2014-10-12 20:48:07 +0400 |
|---|---|---|
| committer | Sergei Petrunia <psergey@askmonty.org> | 2014-10-12 20:48:07 +0400 |
| commit | fec5ab5a56cb9a45c621207620cc85079cddf537 (patch) | |
| tree | 3db33493c57db3b0acfdd2fe18e4eab7a9f960fd /mysql-test/r/analyze_stmt.result | |
| parent | 5c33632b50ab37641b2b0a60729ffda3dbeac31c (diff) | |
| download | mariadb-git-fec5ab5a56cb9a45c621207620cc85079cddf537.tar.gz | |
MDEV-6396: ANALYZE INSERT/REPLACE is accepted, but does not produce a plan
Add ANALYZE STMT handling into INSERT command.
Diffstat (limited to 'mysql-test/r/analyze_stmt.result')
| -rw-r--r-- | mysql-test/r/analyze_stmt.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/analyze_stmt.result b/mysql-test/r/analyze_stmt.result index 53c3188cd4c..e5b3b804202 100644 --- a/mysql-test/r/analyze_stmt.result +++ b/mysql-test/r/analyze_stmt.result @@ -259,3 +259,20 @@ analyze delete from t1 returning *; 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 0 0 100.00 100.00 drop table t1; +# +# MDEV-6396: ANALYZE INSERT/REPLACE is accepted, but does not produce a plan +# +create table t1 (a int primary key, b int); +analyze insert into t1 values (1,1); +id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra +1 INSERT t1 ALL NULL NULL NULL NULL NULL NULL 100.00 100.00 NULL +select * from t1; +a b +1 1 +analyze replace t1 values (1,2); +id select_type table type possible_keys key key_len ref rows r_rows filtered r_filtered Extra +1 INSERT t1 ALL NULL NULL NULL NULL NULL NULL 100.00 100.00 NULL +select * from t1; +a b +1 2 +drop table t1; |