Creator fails on INSERT with SET and ON DUPLICATE KEY

[andrews05]

This statement fails with PHPSQLParser\exceptions\UnableToCreateSQLException: unknown [expr_type] = reserved in "SET" [1]

INSERT INTO `wp_options` SET `option_name` = 'some_key', `option_value` = 'some_value', `autoload` = 'yes' ON DUPLICATE KEY UPDATE `option_value` = 'some_value'

[BrockleyJohn]

Probably related: when parsed and reassembled, this one fails with unknown [expr_type] = reserved in "record" [2] INSERT INTO mytable (column1, column2, column3) SELECT myalias.column1, myalias.column2, 'mynewid' FROM mytable myalias WHERE myalias.column3 = 'myoldid' ON DUPLICATE KEY UPDATE column1 = VALUES(column1), column2 = VALUES(column2)