You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by Apache Wiki <wi...@apache.org> on 2010/05/18 12:40:45 UTC

[Db-derby Wiki] Update of "DerbyTenSixOneRelease" by Jayaram Subramanian

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 Jayaram Subramanian.
http://wiki.apache.org/db-derby/DerbyTenSixOneRelease?action=diff&rev1=67&rev2=68

--------------------------------------------------

  ||<<Icon(alert.png)>> ||XPLAIN statistics collection ||[[https://issues.apache.org/jira/browse/DERBY-2487|DERBY-2487]] ||Capture statistics about the execution of a query into database tables for further analysis ||Done. See [[https://issues.apache.org/jira/browse/DERBY-4065|DERBY-4065]] ||Mamta ||
  ||<<Icon(checkmark.png)>> ||GROUP BY ROLLUP (T431, limited) ||[[https://issues.apache.org/jira/browse/DERBY-3002|DERBY-3002]] ||Implement a subset of the SQL Standard ROLLUP functionality on the GROUP BY clause ||Done. See [[https://issues.apache.org/jira/browse/DERBY-4394|DERBY-4394]] ||Knut A. - No new problems found. ||
  ||<<Icon(checkmark.png)>> ||CROSS JOIN (F401-04) ||[[https://issues.apache.org/jira/browse/DERBY-4355|DERBY-4355]] ||Implement SQL Standard CROSS JOIN syntax. ||Done. See [[https://issues.apache.org/jira/browse/DERBY-4374|DERBY-4374]] ||Dag. Reads the docs and tested the stated equivalences between the shown queries from from tours db. ||
- ||<<Icon(alert.png)>> ||Named columns join ||[[https://issues.apache.org/jira/browse/DERBY-4370|DERBY-4370]] ||Allow USING clauses in joins. ||Done. [[https://issues.apache.org/jira/browse/DERBY-4401|DERBY-4401]] ||Jayaram ||
+ ||<<Icon(alert.png)>> ||Named columns join ||[[https://issues.apache.org/jira/browse/DERBY-4370|DERBY-4370]] ||Allow USING clauses in joins. ||Done. [[https://issues.apache.org/jira/browse/DERBY-4401|DERBY-4401]] ||Jayaram. No problems found except for one scenario which was recorded under Derby 4631. ||
  ||<<Icon(alert.png)>> ||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 ||
  ||<<Icon(checkmark.png)>> ||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]] ||
  ||<<Icon(checkmark.png)>> ||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. ||
- ||<<Icon(checkmark.png)>> ||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]] ||
+ ||<<Icon(checkmark.png)>> ||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]] ||
  ||<<Icon(checkmark.png)>> ||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.. ;-) ||
  ||<<Icon(alert.png)>> ||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 ||
  ||<<Icon(checkmark.png)>> ||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. ||
@@ -62, +62 @@

  ||Kristian W. ||2010-05-04 ||Verified that the two source bundles have the same contents (.tar.gz and .zip) || ||
  ||Kristian W. ||2010-05-04 ||Built Derby from the source bundle (.zip) on !OpenSolaris dev_137 using Sun Java SE 6 (1.6.0_18) and on Linux Mint 8 using OpenJDK 6 (!IcedTea 1.6.1) || ||
  ||Rick ||5/4/2010 ||Build a release from the source distribution ||Did so on Mac OS X 10.5.8 ||
- ||Myrna ||5/10/2010 ||verified workings of /bin scripts || sh scripts on cygwin on windows XP (SP3) and SUSE Linux (10); bat scripts on DOS (windows XP SP3). ||
+ ||Myrna ||5/10/2010 ||verified workings of /bin scripts ||sh scripts on cygwin on windows XP (SP3) and SUSE Linux (10); bat scripts on DOS (windows XP SP3). ||
- ||Myrna ||5/10/2010 ||basic test of eclipse plugins || eclipse 4.3.2 (ganymede) on windows XP with ibm 1.6. New install (both eclipse & plugins) & project without classes only. ||
+ ||Myrna ||5/10/2010 ||basic test of eclipse plugins ||eclipse 4.3.2 (ganymede) on windows XP with ibm 1.6. New install (both eclipse & plugins) & project without classes only. ||