On Sep 6, 2010, at 1:23 PM, werner wrote: > Michael, > > Thanks for the fast reply. > > On 06/09/2010 15:53, Michael Bayer wrote: >> engine = create_engine(...) >> >> m = MetaData() >> t = Table('foo', m, autoload=True, autoload_with=engine) #<--- boom > The table which errors has the following definition. It seems to have to do > with the two columns MINWITH and MAXWIDTH which have "default -1". FYI, when > I change this to '0' and then back to '-1' it becomes "DEFAULT -1" and > doesn't cause the exception anymore.
OK the bug is the SQL has "default -1" and not "DEFAULT -1" and apparently that comes back to us as lower case. So that's your workaround if possible. Or you can download the latest default tip where its fixed in r443b974a8013 . I also get the same error using 0.5. > > Werner > > /******************************************************************************/ > /* Generated by IBExpert 06/09/2010 19:05:50 > */ > /******************************************************************************/ > > /******************************************************************************/ > /* Following SET SQL DIALECT is just for the Database Comparer > */ > /******************************************************************************/ > SET SQL DIALECT 3; > > > > /******************************************************************************/ > /* Tables > */ > /******************************************************************************/ > > > CREATE GENERATOR "GEN_LISTCTRL_LISTCTRLID"; > > CREATE TABLE LISTCTRL ( > LISTCTRLID PKEYS NOT NULL /* PKEYS = BIGINT */, > LISTNAME VARCHAR(20) NOT NULL, > COLNUM INTEGER, > DBCOLNAME VARCHAR(100), > COLSIZE INTEGER, > CREATED DATE, > UPDATED DATE, > MINWIDTH INTEGER default -1 NOT NULL, > MAXWIDTH INTEGER default -1 NOT NULL, > FILLSPACE BOOLEAN /* BOOLEAN = SMALLINT DEFAULT 1 */, > GROUPCOL BOOLEAN /* BOOLEAN = SMALLINT DEFAULT 1 */ > ); > > > > > /******************************************************************************/ > /* Primary Keys > */ > /******************************************************************************/ > > ALTER TABLE LISTCTRL ADD CONSTRAINT FK_LISTCTRL PRIMARY KEY (LISTCTRLID); > > > /******************************************************************************/ > /* Triggers > */ > /******************************************************************************/ > > > SET TERM ^ ; > > > > /******************************************************************************/ > /* Triggers for tables > */ > /******************************************************************************/ > > > > /* Trigger: LISTCTRL_BI0 */ > CREATE OR ALTER TRIGGER LISTCTRL_BI0 FOR LISTCTRL > ACTIVE BEFORE INSERT POSITION 0 > AS BEGIN > IF(NEW."CREATED" IS NULL) THEN NEW."CREATED" = current_date; > IF(NEW."UPDATED" IS NULL) THEN NEW."UPDATED" = current_date; > IF(NEW."LISTCTRLID" IS NULL) THEN NEW."LISTCTRLID" = > GEN_ID("GEN_LISTCTRL_LISTCTRLID",1); > END > ^ > > > /* Trigger: LISTCTRL_BU0 */ > CREATE OR ALTER TRIGGER LISTCTRL_BU0 FOR LISTCTRL > ACTIVE BEFORE UPDATE POSITION 0 > AS BEGIN > NEW."UPDATED" = current_date; > END > ^ > > > SET TERM ; ^ > > > > /******************************************************************************/ > /* Privileges > */ > /******************************************************************************/ > > > /* Privileges of users */ > GRANT ALL ON LISTCTRL TO MYWINECB; > GRANT SELECT ON LISTCTRL TO MYWINECBREAD; > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.