Debian Codegraph @

mysql-test/suite/sql_sequence/view.result

raw
1 create sequence s1;
2 create view v1 as select * from s1;
3 create view v2 as select next value for s1;
4 select * from v1;
5 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
6 1 1 9223372036854775806 1 1 1000 0 0
7 select * from v2;
8 next value for s1
9 1
10 select * from v2;
11 next value for s1
12 2
13 select next value for v1;
14 ERROR 42S02: 'test.v1' is not a SEQUENCE
15 drop sequence s1;
16 drop view v1,v2;
17 #
18 # MDEV 13020 Server crashes in Item_func_nextval::val_int upon
19 # selecting NEXT or PREVIOUS VALUE for a view
20 #
21 CREATE OR REPLACE VIEW v1 AS SELECT 1 AS f;
22 SELECT NEXT VALUE FOR v1;
23 ERROR 42S02: 'test.v1' is not a SEQUENCE
24 SELECT PREVIOUS VALUE FOR v1;
25 ERROR 42S02: 'test.v1' is not a SEQUENCE
26 drop view v1;
27 #
28 # MDEV 17978 Server crashes in mysqld_show_create_get_fields
29 # upon SHOW CREATE SEQUENCE on a broken view
30 #
31 CREATE TABLE t1 (a INT);
32 CREATE VIEW v1 AS SELECT * FROM t1;
33 DROP TABLE t1;
34 SHOW CREATE SEQUENCE v1;
35 ERROR 42S02: 'test.v1' is not a SEQUENCE
36 DROP VIEW v1;