empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jörg Reiher (JIRA) <empire-db-...@incubator.apache.org>
Subject [jira] Created: (EMPIREDB-4) Bugs inside the DBDatabaseDriverHSql class
Date Tue, 26 Aug 2008 13:49:44 GMT
Bugs inside the DBDatabaseDriverHSql class

                 Key: EMPIREDB-4
                 URL: https://issues.apache.org/jira/browse/EMPIREDB-4
             Project: Empire-DB
          Issue Type: Bug
    Affects Versions: empire-db-2.0.3-incubating
            Reporter: Jörg Reiher
             Fix For: empire-db-2.0.3-incubating

- The SQL_CONCAT_EXPR "+" leads to problems if operands are case when statements that return
empty strings in HSQL: The concatenated string is always null!
- There's no "to_char()" function in HSQLDB that takes NUMBER and FORMAT string as parameters,
so an error should be thrown if this type of function is called on the HSQL driver
- drop relation doesn't work as expected for HSQL: It doesn't prefix "ALTER TABLE DROP CONSTRAINT"
to the drop statement
- INTEGER and AUTOINC db columns should be an 8 byte value
- data type DATETIME gets translated to only Date (without time information)
- data type CLOB gets translated to CLOB, but in HSQLDB it's called LONGVARCHAR
- data type BLOB gets translated to BLOB, but in HSQLDB it's called LONGVARBINARY

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message