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
