Dear Wiki user, You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification. The "DerbyTenSixOneRelease" page has been changed by TiagoEspinha. http://wiki.apache.org/db-derby/DerbyTenSixOneRelease?action=diff&rev1=66&rev2=67 -------------------------------------------------- ||<> ||SHOW FUNCTIONS ||[[https://issues.apache.org/jira/browse/DERBY-3809|DERBY-3809]] ||Add a command that lists stored functions in ij. ||Done. See [[https://issues.apache.org/jira/browse/DERBY-4445|DERBY-4445]] ||Mamta || ||<> ||In-memory back end enhancements ||[[https://issues.apache.org/jira/browse/DERBY-4428|DERBY-4428]] ||Add a proper delete mechanism. ||Done. [[https://issues.apache.org/jira/browse/DERBY-4525|DERBY-4525]] ||Rick: Looks good. Logged a minor documentation issue related to this feature: [[https://issues.apache.org/jira/browse/DERBY-4637|DERBY-4637]] || ||<> ||ORDER BY in subqueries (F851, F852, F855) ||[[https://issues.apache.org/jira/browse/DERBY-4397|DERBY-4397]] ||Add syntax for explicit ordering of rows returned by subqueries. ||Done. See [[https://issues.apache.org/jira/browse/DERBY-4518|DERBY-4518]] ||Mikem, testing done, no new problems found. verified cases on a windows machine and read over new documentation. || - ||<> ||OFFSET, FETCH FIRST/NEXT in subqueries (F856,F857,F858,F859,F861,F862,F863,F864) ||[[https://issues.apache.org/jira/browse/DERBY-4398|DERBY-4398]] ||Generalize allowed syntax for retrieving row subsets. ||Done. See [[https://issues.apache.org/jira/browse/DERBY-4518|DERBY-4518]] ||Tiago || + ||<> ||OFFSET, FETCH FIRST/NEXT in subqueries (F856,F857,F858,F859,F861,F862,F863,F864) ||[[https://issues.apache.org/jira/browse/DERBY-4398|DERBY-4398]] ||Generalize allowed syntax for retrieving row subsets. ||Done. See [[https://issues.apache.org/jira/browse/DERBY-4518|DERBY-4518]] ||Tiago. [[Testing Report||https://docs.google.com/Doc?docid=0AexkcI9uV8jZZGdkcnczeHRfMTdjaGpiYjlocA&hl=en]] || ||<> ||NATURAL JOIN (F401-01) ||[[https://issues.apache.org/jira/browse/DERBY-4495|DERBY-4495]] ||Add support for NATURAL JOIN. ||Done. [[https://issues.apache.org/jira/browse/DERBY-4506|DERBY-4506]] ||Dag. This feature looks good, including documentation. I have not managed to shoot holes in it so far.. ;-) || ||<> ||Qualified identifers in ij ||[[https://issues.apache.org/jira/browse/DERBY-4550|DERBY-4550]] ||Add ability to reference cursors and prepared statements in other connections. ||Done. [[https://issues.apache.org/jira/browse/DERBY-4567|DERBY-4567]] ||Eranda || ||<> ||Configurable hash algorithm ||[[https://issues.apache.org/jira/browse/DERBY-4483|DERBY-4483]] ||Add ability to customize the hash algorithm used by BUILTIN authentication. ||Done. [[https://issues.apache.org/jira/browse/DERBY-4579|DERBY-4579]] ||Rick: Verified the following: 1) Specifying a missing algorithm generates errors when you try to set a password. 2) Old credentials work even after changing the default hash algorithm. 3) The new hash algorithm property is ignored after soft-upgrade to 10.6. 4) Password substitution is rejected if engine is at level 10.6. ||