List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 14 1999 5:14pm
Subject:Re: Parser buq
View as plain text  
James Fidell wrote:
> 
> Quoting leon.andonyadis@stripped (leon.andonyadis@stripped):
> >
> >
> > CREATE TABLE LOADPRESSREV (
> >   LOAD_PRESS_ID SMALLINT NOT NULL,
> >   PRESSURE DOUBLE PRECISION,
> >   LOAD SMALLINT,
> >   LI_MAIN SMALLINT,
> >   SI_MAIN SMALLINT,
> >   LI_ALT SMALLINT,
> >   SI_ALT SMALLINT,
> >   STEELBELT VARCHAR(2),
> >   PRLI SMALLINT NOT NULL,
> >   PRORLI SMALLINT NOT NULL,
> >   LAST_REV_NR SMALLINT NOT NULL,
> >   ACTIVATED SMALLINT,
> >   VISIBILITY SMALLINT,
> >   LOAD_PRESS_REV_ID SMALLINT NOT NULL,
> >   LOADPRESS_REVISION SMALLINT NOT NULL,
> >   DATUM DATE,
> >   SIGN CHAR(3),
> >   INFO VARCHAR(40)
> > )
> >
> > this table definition does not parse, if I change LOAD SMALLINT to LOAD1
> > SMALLINT then it works.(shareware mysql in win95)
> 
> "LOAD" is a reserved word ?
> 

Yes, it is, so this is supposed to fail! A feature - not a bug!

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
Parser buqleon.andonyadis14 Jul
  • Re: Parser buqJames Fidell14 Jul
  • Re: Parser buqSasha Pachev14 Jul
  • Re: Parser buqPaul DuBois15 Jul