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

              Assignee:
              Unassigned Unassigned
              Reporter:
              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.