Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.3(EOL)
-
None
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/10121/steps/test_1/logs/stdio
sql_sequence.alter 'innodb' w4 [ fail ]
|
Test ended at 2017-09-08 13:20:39
|
|
CURRENT_TEST: sql_sequence.alter
|
Warning: /mnt/buildbot/build/mariadb-10.3.2/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-ca=/mnt/buildbot/build/mariadb-10.3.2/mysql-test/std_data/cacert.pem'
|
Warning: /mnt/buildbot/build/mariadb-10.3.2/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-cert=/mnt/buildbot/build/mariadb-10.3.2/mysql-test/std_data/client-cert.pem'
|
Warning: /mnt/buildbot/build/mariadb-10.3.2/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-key=/mnt/buildbot/build/mariadb-10.3.2/mysql-test/std_data/client-key.pem'
|
Warning: /mnt/buildbot/build/mariadb-10.3.2/libmysqld/examples/mysqltest_embedded: unknown option '--loose-skip-ssl'
|
mysqltest: At line 154: query 'select nextval(s1)' succeeded - should have failed with errno 1142...
|
|
The result from queries just before the failure was:
|
< snip >
|
alter sequence t1 restart;
|
select next value for t1;
|
next value for t1
|
50
|
alter sequence t1 restart with 90;
|
select next value for t1;
|
next value for t1
|
90
|
drop sequence t1;
|
|
GRANT
|
|
create database s_db;
|
create sequence s_db.s1;
|
grant select on s_db.s1 to normal_1@'%' identified by 'pass';
|
connect m_normal_1, localhost, normal_1, pass, s_db;
|
select * from s1;
|
next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
|
1 1 9223372036854775806 1 1 1000 0 0
|
select nextval(s1);
|