• unknown's avatar
    Bug#20589 Missing some table level privileges after upgrade · b33cbd35
    unknown authored
     - The table_priv column of table_privs table was altered to a enum type
       with fewer enums causing the SHOW/CREATE VIEW grants to be truncated.
     - Improved comments and moved all declarations for table_privs, column_privs
       and proc_privs to one section for each table making it easy to see hat alterations
       are performed on each table
     - Reduced the number of ALTER's slightly, but as this is an upgrade script we need
       to take all possibilites into account.
    
    
    scripts/mysql_fix_privilege_tables.sql:
      Collect everything for tables_priv, columns_priv and procs_priv in one section for each table
      Remove duplicate ALTERS
      Remove the ALTERS that truncated "SHOW VIEW" and "CREATE VIEW" from
      the enum type for Table_priv.
    mysql-test/r/fix_priv_tables.result:
      New BitKeeper file ``mysql-test/r/fix_priv_tables.result''
    mysql-test/r/fix_priv_tabs.result:
      New BitKeeper file ``mysql-test/r/fix_priv_tabs.result''
    mysql-test/t/fix_priv_tables.test:
      New BitKeeper file ``mysql-test/t/fix_priv_tables.test''
    b33cbd35
fix_priv_tabs.result 0 Bytes