diff options
| author | Monty <monty@mariadb.org> | 2017-05-08 02:44:55 +0300 |
|---|---|---|
| committer | Monty <monty@mariadb.org> | 2017-05-08 02:44:55 +0300 |
| commit | 71fa413c165e644f8f1433356f95fed12579fe3e (patch) | |
| tree | f319474716dc55b3174fbf29a9dc510983d040a1 /mysql-test/suite/sql_sequence/next.test | |
| parent | 1e04ad284c6ac0a9ce433f827bc6dbfbd6029007 (diff) | |
| download | mariadb-git-71fa413c165e644f8f1433356f95fed12579fe3e.tar.gz | |
MDEV-10139 Support for SEQUENCE objects
- SETVAL(sequence_name, next_value, is_used, round)
- ALTER SEQUENCE, including RESTART WITH
Other things:
- Added handler::extra() option HA_EXTRA_PREPARE_FOR_ALTER_TABLE to signal
ha_sequence() that it should allow write_row statments.
- ALTER ONLINE TABLE now works with SEQUENCE:s
Diffstat (limited to 'mysql-test/suite/sql_sequence/next.test')
| -rw-r--r-- | mysql-test/suite/sql_sequence/next.test | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/suite/sql_sequence/next.test b/mysql-test/suite/sql_sequence/next.test index 426ee5709a1..472feafb2c6 100644 --- a/mysql-test/suite/sql_sequence/next.test +++ b/mysql-test/suite/sql_sequence/next.test @@ -182,9 +182,10 @@ drop table t1,s1; CREATE OR REPLACE SEQUENCE s1 MINVALUE 1 MAXVALUE 9999999999 INCREMENT BY 1 START WITH 3984356 nocache CYCLE engine='innodb'; select * from s1; select next value for s1; +explain extended select next value for s1; +explain extended select previous value for s1; drop sequence s1; - # # Some error testing # |