Hello,

I've found probably unknown bug in the generation of sql statements from 
xml description.
Following schema 

<database>
    <table name="ABC">
        <column name="ID" primaryKey="true" required="true" 
type="INTEGER"/>
        <column name="CMD" type="BLOB"/>
        <column name="SIG" size="1024" type="BINARY"/>
    </table>
</database>

is translated by Torque into:

drop table ABC cascade ;

CREATE TABLE ABC
(
    ID INTEGER NOT NULL,
    CMD LONG BYTE,
    SIG CHAR(254) BYTE (1024)
);

ALTER TABLE ABC
    ADD PRIMARY KEY (ID) ;

which has obviously two length identifiers for column SIG.

With best regards,

   Julius Siska

Reply via email to