• Sergey Glukhov's avatar
    Bug#22763 Disrepancy between SHOW CREATE VIEW and I_S.VIEWS · 7c67be63
    Sergey Glukhov authored
    The problem:
    I_S views table does not check the presence of SHOW_VIEW_ACL|SELECT_ACL
    privileges for a view. It leads to discrepancy between SHOW CREATE VIEW
    and I_S.VIEWS.
    The fix:
    added appropriate check.
    
    
    mysql-test/r/information_schema_db.result:
      test result
    mysql-test/t/information_schema_db.test:
      test case
    sql/sql_show.cc:
      The problem:
      I_S views table does not check the presence of SHOW_VIEW_ACL|SELECT_ACL
      privileges for a view. It leads to discrepancy between SHOW CREATE VIEW
      and I_S.VIEWS.
      The fix:
      added appropriate check.
    7c67be63
information_schema_db.test 6.38 KB