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

main.cte_nonrecursive failed in --embedded (again)

Details

    Description

      cte_nonrecursive fails in 10.3 in embedded builds like

      main.cte_nonrecursive                    w2 [ fail ]
              Test ended at 2018-02-09 19:58:17
       
      CURRENT_TEST: main.cte_nonrecursive
      mysqltest: At line 770: query '$q' failed: 1146: Table 'test.cte_i' doesn't exist
      

      The reason is the commit 3afc962 that fixed the bug MDEV-13453. It added this

      if (tl->with ||
          (tl->with= tl->select_lex->find_table_def_in_with_clauses(tl)))
        continue; 
      

      to check_grant() function. Which is wrong, privilege checking functions cannot have side-effects (like setting tl->with above) because they are not executed in embedded builds.

      For some reason, that I did not look into, this does not fail in 10.2, though.

      Attachments

        Activity

          The fix for this problem was pushed into 10.2
          (see 8411a8ff6080f346582878131ba4bd92cce7510c).
          It was not merged into 10.3.

          igor Igor Babaev (Inactive) added a comment - The fix for this problem was pushed into 10.2 (see 8411a8ff6080f346582878131ba4bd92cce7510c). It was not merged into 10.3.

          Oops. Sorry.

          I should've checked why it doesn't fail in 10.2

          serg Sergei Golubchik added a comment - Oops. Sorry. I should've checked why it doesn't fail in 10.2

          People

            igor Igor Babaev (Inactive)
            serg Sergei Golubchik
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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