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 [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> 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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
