Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13778

sql_sequence.alter fails in buildbot and outside with embedded (query 'select nextval(s1)' succeeded - should have failed with errno 1142)

    Details

      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);
      

        Attachments

          Activity

            People

            • Assignee:
              monty Michael Widenius
              Reporter:
              alice Alice Sherepa
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: