• Georgi Kodinov's avatar
    Bug #46019: ERROR 1356 When selecting from within another · 06655369
    Georgi Kodinov authored
    view that has Group By
          
    Table access rights checking function check_grant() assumed
    that no view is opened when it's called.
    This is not true with nested views where the inner view
    needs materialization. In this case the view is already 
    materialized when check_grant() is called for it.
    This caused check_grant() to not look for table level
    grants on the materialized view table.
    Fixed by checking if a view is already materialized and if 
    it is check table level grants using the original table name
    (not the ones of the materialized temp table).
    06655369
view_grant.result 38.7 KB