db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean Anderson <...@bristowhill.com>
Subject Re: Documentation errors
Date Fri, 27 Aug 2004 13:57:02 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

thanks for the reports!

~ -jean

Christian d'Heureuse wrote:

| Documentation errors:
|
| ---
|
| 1. NULLIF Function
|
| http://incubator.apache.org/derby/manuals/reference/sqlj66.html
| ("NULLIF and CASE expressions")
|
| The Description of the NULLIF function is incomplete.
|
| The definition in ISO 9075-2 could be used: NULLIF(V1,V2) is
| equivalent to the following: CASE WHEN V1=V2 THEN NULL ELSE V1 END
|
| ---
|
| 2. Commits in Stored Procedures
|
| There are contradicting rules on whether Commits are allowed in
| stored procedures that use nested connections:
|
| http://incubator.apache.org/derby/manuals/develop/develop50.html
| ("Database-Side JDBC Procedures and Nested Connections"): "Commits
| are permitted when the procedure is called within a CALL or VALUES
| statement."
|
| http://incubator.apache.org/derby/manuals/develop/develop63.html
| ("Transactions"): "Procedures that use nested connections are not
| permitted " ... " to commit or roll back."
|
| "Table 2. Summary of Application Behavior with Auto-Commit On or
| Off": ... "no explicit commits or rollbacks are allowed"
|
| ---
|
| 3. Documentation Request: SQLStates and ErrorCodes
|
| There should be a list and description of the SQLState and
| ErrorCodes that are generated by Derby.
|
| ---
|
| Christian
|

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBLz2uF0L6u5lYbCYRAkx/AJ9nLJKPza4vqPbbp+JDwsdDpEdv+wCfebao
5l6/fcVXsJwz5rnQlfOs6CA=
=0seu
-----END PGP SIGNATURE-----


Mime
View raw message