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

Allow non-reserved keywords as user defined type names

    XMLWordPrintable

    Details

      Description

      This task is similar to MDEV-20734, but for non-reserved keywords.

      To avoid compatibility problems in the future, let's allow non-conflicting non-reserved keywords as user defined type (UDT) names.

      The non-reserved keywords from the following rules will be allowed:

      non_reserved_keyword_udt:
                keyword_sp_var_not_label
              | keyword_sp_head
              | keyword_verb_clause
              | keyword_set_special_case
              | keyword_sp_block_section
              | keyword_sysvar_type
              | keyword_sp_var_and_label
              ;
      

      Non-reserved keywords from these rules won't work as UDT names, because they'd cause grammar conflicts:

      keyword_data_type:
                BIT_SYM
              | BOOLEAN_SYM
              | BOOL_SYM
              | CLOB_MARIADB_SYM
              | CLOB_ORACLE_SYM
              | DATE_SYM           %prec PREC_BELOW_CONTRACTION_TOKEN2
              | DATETIME
              | ENUM
              | FIXED_SYM
              | JSON_SYM
              | MEDIUM_SYM
              | NATIONAL_SYM
              | NCHAR_SYM
              | NUMBER_MARIADB_SYM
              | NUMBER_ORACLE_SYM
              | NVARCHAR_SYM
              | RAW_MARIADB_SYM
              | RAW_ORACLE_SYM
              | ROW_SYM
              | SERIAL_SYM
              | TEXT_SYM
              | TIMESTAMP          %prec PREC_BELOW_CONTRACTION_TOKEN2
              | TIME_SYM           %prec PREC_BELOW_CONTRACTION_TOKEN2
              | VARCHAR2_MARIADB_SYM
              | VARCHAR2_ORACLE_SYM
              | YEAR_SYM
              ;
       
       
      keyword_cast_type:
                SIGNED_SYM
              ;
      

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            bar Alexander Barkov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: