diff options
author | Aleksey Midenkov <midenok@gmail.com> | 2017-11-13 13:00:00 +0300 |
---|---|---|
committer | Aleksey Midenkov <midenok@gmail.com> | 2017-11-15 00:22:11 +0300 |
commit | cc6701a7b3fbc0ed38b3be2b46314991741b7617 (patch) | |
tree | 243b97ff257979dfcc8b60a084603d8eb62cd928 | |
parent | 27b3642a7c50e5f482948af6956fda104a3167af (diff) | |
download | mariadb-git-cc6701a7b3fbc0ed38b3be2b46314991741b7617.tar.gz |
Tests: vtmd, optimized, partition
-rw-r--r-- | mysql-test/suite/versioning/r/optimized.result | 54 | ||||
-rw-r--r-- | mysql-test/suite/versioning/r/partition.result | 12 | ||||
-rw-r--r-- | mysql-test/suite/versioning/r/vtmd.result | 9 | ||||
-rw-r--r-- | mysql-test/suite/versioning/t/vtmd.test | 3 |
4 files changed, 40 insertions, 38 deletions
diff --git a/mysql-test/suite/versioning/r/optimized.result b/mysql-test/suite/versioning/r/optimized.result index a89180bbabd..046b3d0d4f2 100644 --- a/mysql-test/suite/versioning/r/optimized.result +++ b/mysql-test/suite/versioning/r/optimized.result @@ -17,61 +17,61 @@ a b b+0 1 NULL NULL 3 NULL NULL Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select * from t for system_time as of timestamp now(6); a b 1 NULL 3 NULL Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select count(*) from t group by b system_time as of timestamp now(6); count(*) 2 Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select * from t for system_time as of timestamp now(6) order by b asc; a b 1 NULL 3 NULL Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select * from t for system_time as of timestamp now(6) order by b desc; a b 1 NULL 3 NULL Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select * from t group by a having a=2 system_time as of timestamp now(6); a b Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select * from t group by b having b=2 system_time as of timestamp now(6); a b Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select a from t where b=2 system_time as of timestamp now(6); a Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select a from t where b=NULL system_time as of timestamp now(6); a Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select a from t where b is NULL system_time as of timestamp now(6); a 1 3 Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select count(*), b from t group by b having b=NULL system_time as of timestamp now(6); count(*) b Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select a, b from t; a b 1 2 @@ -80,31 +80,31 @@ select count(*) from t for system_time as of timestamp now(6) group by b; count(*) 2 Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select * from t for system_time as of timestamp now(6) group by b having b=2; a b Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select a from t for system_time as of timestamp now(6) where b=2; a Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select a from t for system_time as of timestamp now(6) where b=NULL; a Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select a from t for system_time as of timestamp now(6) where b is NULL; a 1 3 Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select count(*), b from t for system_time as of timestamp now(6) group by b having b=NULL; count(*) b Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query create or replace table t ( a int, b int not null without system versioning @@ -115,12 +115,12 @@ a b 1 NULL 3 NULL Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query select * from t for system_time as of timestamp now(6) where b is NULL; a b 1 NULL 3 NULL Warnings: -Warning 4102 Attempt to read unversioned field `b` in historical query -Warning 4102 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query +Warning 4109 Attempt to read unversioned field `b` in historical query drop table t; diff --git a/mysql-test/suite/versioning/r/partition.result b/mysql-test/suite/versioning/r/partition.result index 39811452431..607556ca964 100644 --- a/mysql-test/suite/versioning/r/partition.result +++ b/mysql-test/suite/versioning/r/partition.result @@ -147,7 +147,7 @@ ERROR HY000: Wrong partitions consistency for `t1`: must have at least one 'VERS alter table t1 add partition ( partition p1 versioning); Warnings: -Warning 4105 Maybe missing parameters: no rotation condition for multiple `VERSIONING` partitions. +Warning 4112 Maybe missing parameters: no rotation condition for multiple `VERSIONING` partitions. show create table t1; Table Create Table t1 CREATE TABLE `t1` ( @@ -290,7 +290,7 @@ x 2 delete from t1; Warnings: -Note 4106 Switching from partition `p0` to `p1` +Note 4113 Switching from partition `p0` to `p1` select * from t1 partition (p0) for system_time all; x 1 @@ -300,7 +300,7 @@ x insert into t1 values (3); delete from t1; Warnings: -Warning 4104 Using full partition `p1`, need more VERSIONING partitions! +Warning 4111 Using full partition `p1`, need more VERSIONING partitions! select * from t1 partition (p1) for system_time all; x 2 @@ -333,7 +333,7 @@ x insert into t1 values (4); delete from t1; Warnings: -Note 4106 Switching from partition `p0` to `p1` +Note 4113 Switching from partition `p0` to `p1` select * from t1 partition (p1) for system_time all; x 4 @@ -355,8 +355,8 @@ x 2 delete from t1; Warnings: -Note 4106 Switching from partition `p0` to `p1` -Warning 4104 Using full partition `p1`, need more VERSIONING partitions! +Note 4113 Switching from partition `p0` to `p1` +Warning 4111 Using full partition `p1`, need more VERSIONING partitions! select * from t1 partition (p0sp0) for system_time all; x 1 diff --git a/mysql-test/suite/versioning/r/vtmd.result b/mysql-test/suite/versioning/r/vtmd.result index 3dd31abea0d..ece5f5af61a 100644 --- a/mysql-test/suite/versioning/r/vtmd.result +++ b/mysql-test/suite/versioning/r/vtmd.result @@ -48,7 +48,8 @@ create or replace procedure show_tables() begin show tables; select table_name, table_schema from information_schema.tables -where table_schema not in ('mysql', 'performance_schema', 'information_schema', 'mtr'); +where table_schema not in ('mysql', 'performance_schema', 'information_schema', 'mtr') +order by table_name; end~~ set versioning_alter_history= keep; create table t0 (z int) with system versioning; @@ -150,7 +151,7 @@ x0_vtmd drop table x0_vtmd; rename table x0 to d0; Warnings: -Warning 4115 `test.d0_vtmd` table already exists! +Warning 4122 `test.d0_vtmd` table already exists! show tables; Tables_in_test d0 @@ -331,11 +332,11 @@ t3_TIMESTAMP_SUFFIX t3_TIMESTAMP_SUFFIX t3_vtmd table_name table_schema -t1_TIMESTAMP_SUFFIX db1 t0_TIMESTAMP_SUFFIX test t0_TIMESTAMP_SUFFIX test t0_TIMESTAMP_SUFFIX test t0_TIMESTAMP_SUFFIX test +t1_TIMESTAMP_SUFFIX db1 t2 test t2_vtmd test t3 test @@ -353,7 +354,7 @@ t3_vtmd u0_vtmd u0_vtmd_vtmd Warnings: -Warning 4115 Table `test.u0_vtmd` is not a VTMD table +Warning 4122 Table `test.u0_vtmd` is not a VTMD table set versioning_alter_history= survive; create or replace table t (x int) with system versioning; select * from t for system_time all; diff --git a/mysql-test/suite/versioning/t/vtmd.test b/mysql-test/suite/versioning/t/vtmd.test index c5483c182cc..56bdb3d2546 100644 --- a/mysql-test/suite/versioning/t/vtmd.test +++ b/mysql-test/suite/versioning/t/vtmd.test @@ -61,7 +61,8 @@ create or replace procedure show_tables() begin show tables; select table_name, table_schema from information_schema.tables - where table_schema not in ('mysql', 'performance_schema', 'information_schema', 'mtr'); + where table_schema not in ('mysql', 'performance_schema', 'information_schema', 'mtr') + order by table_name; end~~ delimiter ;~~ |