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

main.cte_nonrecursive failed in --embedded (again)

    XMLWordPrintable

    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: