Robin, about bug 621357,
in a query like
UPDATE mytable set myfield = 1
the parser thinks that "set" is a column type.
If I add SET to the list of reserved words, now the UPDATE statement colorizes ok, but in an ALTER TABLE with a column type of SET, the SET does not go orange.
Marc
On Fri, Oct 11, 2002 at 10:28:34AM -0400, Marc Delisle wrote:
in a query like
UPDATE mytable set myfield = 1
the parser thinks that "set" is a column type.
If I add SET to the list of reserved words, now the UPDATE statement colorizes ok, but in an ALTER TABLE with a column type of SET, the SET does not go orange.
I'll try see about a full solution for this later on. The basic algorithm is that when you hit 'SET' you need to check the next token.
If it's a '(' then it's a column type, else it's a reserved word. There was a big batch of stuff i've been working on in the parser system anyway. I'll see about getting some of it in soon, even if it's just that bugfix for the moment.
On Fri, Oct 11, 2002 at 02:58:44PM -0700, Robin Johnson wrote:
If I add SET to the list of reserved words, now the UPDATE statement colorizes ok, but in an ALTER TABLE with a column type of SET, the SET does not go orange.
I'll try see about a full solution for this later on. The basic algorithm is that when you hit 'SET' you need to check the next token.
If it's a '(' then it's a column type, else it's a reserved word. There was a big batch of stuff i've been working on in the parser system anyway. I'll see about getting some of it in soon, even if it's just that bugfix for the moment.
I've put a simple fix in place for the moment.
-
Marc Delisle -
Robin Johnson