Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
-
None
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.