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

Syntax error reserverd keyword

    XMLWordPrintable

Details

    Description

      Script below fails on column name 'public', works fine in 10.2
      Code is used in https://releases.openstack.org/queens/#queens-neutron

      CREATE TABLE `firewall_rules_v2` (
      		 
        `public` tinyint(1) DEFAULT NULL,
      		 
        CONSTRAINT `CONSTRAINT_1` CHECK (`public` in (0,1)));
      		 
       
      		 
      ALTER TABLE firewall_rules_v2 CHANGE `public` shared BOOL NULL;

      ERROR 1054 (42S22): Unknown column 'public' in 'CHECK'

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13508 ALTER TABLE that renames columns and CHECK constraints

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              Unassigned Unassigned
              Ruud rvdgijp
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.