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

view protocol: version.* tests fails: select .. as of now.. for update should have failed with error ER_TABLE_NOT_LOCKED_FOR_WRITE (but succeded)

    XMLWordPrintable

Details

    Description

      multiple versioning suite tests:

      CURRENT_TEST: versioning.select2
      mysqltest: At line 140: query 'select * from t1 for system_time as of now() for update' succeeded - should have failed with error ER_TABLE_NOT_LOCKED_FOR_WRITE (1099)...
       
      The result from queries just before the failure was:
      < snip >
      called_bad
      called_bad
      called_bad
      called_bad
      # bad() is good.
      # wildcard expansion on hidden fields.
      create or replace table t1(
      A int
      ) with system versioning;
      insert into t1 values(1);
      select * from t1;
      A
      1
      create or replace table t1 (x int);
      insert into t1 values (1);
      select * from t1 for system_time all;
      ERROR HY000: Table `t1` is not system-versioned
      create or replace table t1 (x int) with system versioning;
      insert into t1 values (1);
      select * from t1 for system_time as of now() for update;
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.