-----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-----
