db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julius Siska" <Julius_Si...@nbs.sk>
Subject bug in SAPDB sql generation
Date Fri, 28 Feb 2003 13:32:06 GMT
 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


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message