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

LP:742556 - ./netware/static_init_db.sql contains deprecated TIMESTAMP(14) syntax

    Details

    • Type: Task
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Fix Version/s: None
    • Component/s: None

      Description

      Grepping the codebase for old TIMESTAMP() syntax realed the following lines:

      ./netware/static_init_db.sql:CREATE TABLE tables_priv (Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Table_name char(64) binary DEFAULT '' NOT NULL, Grantor char(77) DEFAULT '' NOT NULL, Timestamp timestamp(14), Table_priv set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter') DEFAULT '' NOT NULL, Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL, PRIMARY KEY (Host,Db,User,Table_name), KEY Grantor (Grantor)) comment='Table privileges';
      ./netware/static_init_db.sql:CREATE TABLE columns_priv (Host char(60) binary DEFAULT '' NOT NULL, Db char(64) binary DEFAULT '' NOT NULL, User char(16) binary DEFAULT '' NOT NULL, Table_name char(64) binary DEFAULT '' NOT NULL, Column_name char(64) binary DEFAULT '' NOT NULL, Timestamp timestamp(14), Column_priv set('Select','Insert','Update','References') DEFAULT '' NOT NULL, PRIMARY KEY (Host,Db,User,Table_name,Column_name)) comment='Column privileges';

      not sure if those are still relevant.

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            serg Sergei Golubchik added a comment -

            Re: ./netware/static_init_db.sql contains deprecated TIMESTAMP(14) syntax
            I'd rather keep it as is than to change it, creating the impression that netware configuration is still supported.

            Show
            serg Sergei Golubchik added a comment - Re: ./netware/static_init_db.sql contains deprecated TIMESTAMP(14) syntax I'd rather keep it as is than to change it, creating the impression that netware configuration is still supported.
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 742556

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 742556

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                philipstoev Philip Stoev
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: