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

            People

            • Assignee:
              igor Igor Babaev
              Reporter:
              serg Sergei Golubchik
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: