[mysqldef] found syntax error when parsing trigger uses status column

[osjupiter]

Description

When creating a table with a column named status and a trigger that references this column, the parser throws a syntax error incorrectly identifying the column name as the source of the issue.

SQL

    CREATE TABLE test_trigger (
      id int(11) NOT NULL AUTO_INCREMENT,
      status int(4),
      PRIMARY KEY (id)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    CREATE TRIGGER `test_trigger_BEFORE_INSERT` before insert ON `test_trigger` FOR EACH ROW begin
    set NEW.status = 0;
    end;

Error

found syntax error when parsing DDL "CREATE TABLE test_trigger (
          id int(11) NOT NULL AUTO_INCREMENT,
          status int(4),
          PRIMARY KEY (id)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
        CREATE TRIGGER `test_trigger_BEFORE_INSERT` before insert ON `test_trigger` FOR EACH ROW begin
        set NEW.status = 0;
        end": syntax error at position 75 near 'status'

[osjupiter]

This happens because status is treated as a reserved keyword during parsing. The parser always recognizes status as a keyword, causing syntax errors when it's used as a column name.

Note that status is a keyword only in MySQL (not PostgreSQL/SQL Server), and DDL management tools rarely need to handle queries that actually use the status keyword.

I'll work on updating the parser to not treat status as a reserved keyword. This should resolve the issue without affecting normal use cases.

[osjupiter]

After checking various cases, I found that only status behaves incorrectly as a column name among reserved words.

This works:

CREATE TABLE test_trigger (
  id int(11) NOT NULL AUTO_INCREMENT,
  `status` int(4),
  `interval` int(4),
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TRIGGER `test_trigger_BEFORE_INSERT` before insert ON `test_trigger` FOR EACH ROW begin
set NEW.interval = 0;
end;

This causes an error:

CREATE TABLE test_trigger (
  id int(11) NOT NULL AUTO_INCREMENT,
  `status` int(4),
  `interval` int(4),
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TRIGGER `test_trigger_BEFORE_INSERT` before insert ON `test_trigger` FOR EACH ROW begin
set NEW.status = 0;
end;

testutils.go:145: found syntax error when parsing DDL "CREATE TRIGGER `test_trigger_BEFORE_INSERT` before insert ON `test_trigger` FOR EACH ROW begin
    set NEW.status = 0;
    end": syntax error at position 110 near 'status'

So it looks like we can fix this by modifying the behavior only for the status keyword.

[osjupiter]

fixed by #784