You can view the issue detail at the following URL:
<http://nagoya.apache.org/scarab/issues/id/TRQ54>
Type : Defect
Issue Id : TRQ54
Reported by: Kai Zhang
[EMAIL PROTECTED] - ([EMAIL PROTECTED])
Details:
Platform: All
Operating system: windows 2000
Summary: insert-sql (in build-torque.xml ) does not work correctly
Description: Everything is ok using torque, but when I try to add a field
<column
name="removed"
required="true"
type="BOOLEANCHAR"
description=""
/>
to a table, the schema is generated correctly, like:
CREATE TABLE dbCrystalReport
(
schedule_id INTEGER NOT NULL,
filepath VARCHAR (255),
status INTEGER,
removed CHAR NOT NULL,
ID VARCHAR (255) NOT NULL,
blobName VARCHAR (255),
description VARCHAR (255),
name VARCHAR (255),
archivePath VARCHAR (255),
latest VARCHAR (255),
scheduleinfo_id INTEGER,
retryinfo_id INTEGER,
PRIMARY KEY(schedule_id),
FOREIGN KEY (scheduleinfo_id) REFERENCES dbScheduleInfo (scheduleinfo_id),
FOREIGN KEY (retryinfo_id) REFERENCES dbRetryInfo (retryinfo_id)
);
then I call "ant -f build-torque.xml (, create-db,id-table-init-sql, insert-sql ), the
insert-sql stage does not generate correct schema in database, I have to call the
schema script manually, then it is ok.
the schema in database looks like the following, missing field of removed!
+-----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| schedule_id | int(11) | | PRI | 0 | |
| filepath | varchar(255) | YES | | NULL | |
| status | int(11) | YES | | NULL | |
| ID | varchar(255) | | | | |
| blobName | varchar(255) | YES | | NULL | |
| description | varchar(255) | YES | | NULL | |
| name | varchar(255) | YES | | NULL | |
| archivePath | varchar(255) | YES | | NULL | |
| latest | varchar(255) | YES | | NULL | |
| scheduleinfo_id | int(11) | YES | | NULL | |
| retryinfo_id | int(11) | YES | | NULL | |
+-----------------+--------------+------+-----+---------+-------+
Status: New
--
To unsubscribe, e-mail: <mailto:turbine-torque-dev-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-torque-dev-help@;jakarta.apache.org>
