You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by Noctarius <me...@noctarius.com> on 2011/09/07 18:40:50 UTC

Wrong SQL creation for HSQLDB

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi guys

Just at this moment I remember a long forgotten bug in creation of
HSQLDB (which was at least in torque 3.3).

If you define a Integer column with a length the generated SQL was
not valid for HSQLDB (we used an old version 1.8.x or something)
since this database have not supported length for Integers.

I'm not sure if this has changed in torque 4 or maybe newer
versions of HSQLDB but I wanted to mention it.

I'm not at the company anymore but a to create a testcase should
be no problem.

Chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.12 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBAgAGBQJOZ56SAAoJEH/g+YBfahrqko0QAKifpr/RVHaT/xMsgW4gB0IV
xOtbsAZvLRx5CB/Fa1/1dhXsWurAvzsHhN1XXtk7xP4O4aSPZCGadtAwy5MdNt1b
nv2CcJ5iXmoyNr2zhElTP2cXbDmd/GJ6AIpWylNvhHbV6kU0Ymtrt/Cte4SD7j+d
U1HSbnEU/D3dZJ06rgpdozANamVAc9RyAYAOzU9cfTPteZs1RG7d9nJuVCEalI0m
aASAEo1N2nocwcH1ZqX4x948ZMPAgQ4ygJ3LzwfKV6ANm1q5FZsNjld2tPUpzoLu
FXNmbvLoydA2CWlWJF8zMB6iS3kiyAxHNLewed9724G2//Jn6qHf95EVrgafKskC
Xrv+Awpo2EkrZslbpgnGMxIBEA0K3aw2c+BQyBzy2GVeNNjkyQinZFQ+WAgSZR+H
upzxB71EPU+56iqCXvUCmOpiEBmnNIYfOc45KAt2mPTQV6leW7wEtGgckT7eGTYb
GPfpMYv5wl/brVpg7bFDzwDz1fQalbgqIIByfnadxz0ZYD4S6WNPP7j7prG+4NqY
qeQ5IjsBVwaQgdHrUN2ifywOoBG/1Psts60VJdKMQYsyys9VLXd6BlhWrvsZXSVD
tc4zpkPMn58ftMg58IjYyv6ZjSgOGyo3TJVzRzp2hWtlbAvic6Bs++SwINaQE7rI
FFKp2qe7iBH087Z0e/jY
=p4z5
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org

RE: Wrong SQL creation for HSQLDB

Posted by Thomas Fox <Th...@seitenbau.net>.
Could you please cerate a bug in jira and set the version to 3.3 ?

I'll then check torque 4 once hsqldb support is implemented.

  Thanks

    Thomas


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi guys
>
> Just at this moment I remember a long forgotten bug in creation of
> HSQLDB (which was at least in torque 3.3).
>
> If you define a Integer column with a length the generated SQL was
> not valid for HSQLDB (we used an old version 1.8.x or something)
> since this database have not supported length for Integers.
>
> I'm not sure if this has changed in torque 4 or maybe newer
> versions of HSQLDB but I wanted to mention it.
>
> I'm not at the company anymore but a to create a testcase should
> be no problem.
>
> Chris
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.12 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iQIcBAEBAgAGBQJOZ56SAAoJEH/g+YBfahrqko0QAKifpr/RVHaT/xMsgW4gB0IV
> xOtbsAZvLRx5CB/Fa1/1dhXsWurAvzsHhN1XXtk7xP4O4aSPZCGadtAwy5MdNt1b
> nv2CcJ5iXmoyNr2zhElTP2cXbDmd/GJ6AIpWylNvhHbV6kU0Ymtrt/Cte4SD7j+d
> U1HSbnEU/D3dZJ06rgpdozANamVAc9RyAYAOzU9cfTPteZs1RG7d9nJuVCEalI0m
> aASAEo1N2nocwcH1ZqX4x948ZMPAgQ4ygJ3LzwfKV6ANm1q5FZsNjld2tPUpzoLu
> FXNmbvLoydA2CWlWJF8zMB6iS3kiyAxHNLewed9724G2//Jn6qHf95EVrgafKskC
> Xrv+Awpo2EkrZslbpgnGMxIBEA0K3aw2c+BQyBzy2GVeNNjkyQinZFQ+WAgSZR+H
> upzxB71EPU+56iqCXvUCmOpiEBmnNIYfOc45KAt2mPTQV6leW7wEtGgckT7eGTYb
> GPfpMYv5wl/brVpg7bFDzwDz1fQalbgqIIByfnadxz0ZYD4S6WNPP7j7prG+4NqY
> qeQ5IjsBVwaQgdHrUN2ifywOoBG/1Psts60VJdKMQYsyys9VLXd6BlhWrvsZXSVD
> tc4zpkPMn58ftMg58IjYyv6ZjSgOGyo3TJVzRzp2hWtlbAvic6Bs++SwINaQE7rI
> FFKp2qe7iBH087Z0e/jY
> =p4z5
> -----END PGP SIGNATURE-----
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-dev-help@db.apache.org
>


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org