db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christian d'Heureuse" <c...@inventec.ch>
Subject Documentation errors
Date Thu, 26 Aug 2004 21:24:47 GMT
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


Mime
View raw message