summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sql_sequence/next.test
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2017-06-19 17:28:08 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2017-06-19 17:28:08 +0300
commit1e3886ae80c44a39ec3e4061b4ea3131cdcef213 (patch)
treece95518792d1432b669ba13a248928e74e81a9bb /mysql-test/suite/sql_sequence/next.test
parent0fe7d8a2a221196d977e5efe3f3dedb22806bb53 (diff)
parent3a7201ea922f6d3373924c413fdb4b108f6208c5 (diff)
downloadmariadb-git-1e3886ae80c44a39ec3e4061b4ea3131cdcef213.tar.gz
Merge bb-10.2-ext into 10.3
Diffstat (limited to 'mysql-test/suite/sql_sequence/next.test')
-rw-r--r--mysql-test/suite/sql_sequence/next.test66
1 files changed, 33 insertions, 33 deletions
diff --git a/mysql-test/suite/sql_sequence/next.test b/mysql-test/suite/sql_sequence/next.test
index cf67b7a2752..271c4a6558a 100644
--- a/mysql-test/suite/sql_sequence/next.test
+++ b/mysql-test/suite/sql_sequence/next.test
@@ -8,27 +8,27 @@
CREATE SEQUENCE t1 start with 1 minvalue 1 maxvalue 10 increment by 1 cache 2 cycle;
show create table t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select NEXT VALUE for t1,seq from seq_1_to_20;
@@ -36,27 +36,27 @@ drop sequence t1;
CREATE SEQUENCE t1 minvalue 1 maxvalue 10 increment by -1 cache 2 cycle engine=aria;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select next value for t1;
-select next_value,round from t1;
+select next_not_cached_value,cycle_count from t1;
select NEXT VALUE for t1,seq from seq_1_to_20;
@@ -85,7 +85,7 @@ select next value for s1;
drop sequence s1;
#
-# Test that flush tables jumps to next next_value
+# Test that flush tables jumps to next next_not_cached_value
#
CREATE SEQUENCE t1 start with 1 minvalue 1 maxvalue 100 increment by 1 cache 10;
@@ -116,23 +116,23 @@ drop sequence t9;
CREATE SEQUENCE s1 cache=0;
select * from s1;
select next value for s1;
-select next_value from s1;
+select next_not_cached_value from s1;
select next value for s1;
-select next_value from s1;
+select next_not_cached_value from s1;
DROP SEQUENCE s1;
CREATE SEQUENCE s1 cache=1;
-select next_value from s1;
+select next_not_cached_value from s1;
select next value for s1;
-select next_value from s1;
+select next_not_cached_value from s1;
select next value for s1;
-select next_value from s1;
+select next_not_cached_value from s1;
DROP SEQUENCE s1;
CREATE SEQUENCE s1 cache=2;
-select next_value from s1;
+select next_not_cached_value from s1;
select next value for s1;
-select next_value from s1;
+select next_not_cached_value from s1;
select next value for s1;
-select next_value from s1;
+select next_not_cached_value from s1;
DROP SEQUENCE s1;
#
@@ -196,7 +196,7 @@ drop sequence s1;
CREATE SEQUENCE t1 start with 5 minvalue 1 maxvalue 10 increment by 1 cache 5 cycle;
explain select next value for t1;
-explain select next value for t1, min_value from t1;
+explain select next value for t1, minimum_value from t1;
drop table t1;
#
@@ -244,7 +244,7 @@ drop table t1;
create sequence t1;
select next value for t1;
--error ER_BAD_FIELD_ERROR
-select next value for t1, min_value;
+select next value for t1, minimum_value;
drop sequence t1;
--echo #