Yes it is.
The DOUBLE(p,s) type definition should be supported for compatibility,
although we do not enforce the precision and scale.
Fred
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 10 October 2003 16:35
Subject: [Hsqldb-developers] BUG ?
Hi,
I am testing the HSQLDB 1.7.2a-Q version and I think I found a bug.
In the 1.7.1, the following SQL command works:
create table PARAM_OCV_CONV_CURNCY(
ENTITY_MATI VARCHAR(8) not null,
CURNCY_MATI VARCHAR(8) not null,
CURNCY_SYCO VARCHAR(8) not null,
AMOUNT_CONV_RATE DOUBLE(38,10) not null,
RULE_CODE VARCHAR(32) not null,
CREATION_DATE DATETIME not null,
constraint CPK_PARAM_OCV_CONV_CURNCY primary key(CURNCY_MATI,
NTITY_MATI) )
In the 1.7.2a-Q, I get the following error:
Caused by: java.sql.SQLException: Unexpected token in
statement [create table PARAM_OCV_CONV_CURNCY( ENTITY_MATI VARCHAR(8) not
null, CURNCY_MATI VARCHAR(8) not null, CURNCY_SYCO VARCHAR(8) not null,
AMOUNT_CONV_RATE DOUBLE(38, 10) not]
at org.hsqldb.jdbcDriver.sqlException(jdbcDriver.java:140)
at org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:1640)
at org.hsqldb.jdbcStatement.executeUpdate(jdbcStatement.java:248)
at
com.bnpparibas.ism.modules.treatment.sql.DatabaseImplementation.createTable(
DatabaseImplementation.java:773)
at
com.bnpparibas.ism.modules.treatment.sql.DatabaseImplementation.loadData(Dat
abaseImplementation.java:562)
at
com.bnpparibas.ism.modules.treatment.sql.DatabaseImplementation.load(Databas
eImplementation.java:139)
... 1 more
The last part of the SQL command is truncated :-(
Is it due to the "DOUBLE(38,10)" data type?
Loïc
This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.
---------------------------------------------
Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.
-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
SourceForge.net hosts over 70,000 Open Source Projects.
See the people who have HELPED US provide better services:
Click here: http://sourceforge.net/supporters.php
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
SourceForge.net hosts over 70,000 Open Source Projects.
See the people who have HELPED US provide better services:
Click here: http://sourceforge.net/supporters.php
_______________________________________________
hsqldb-developers mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
