TenTwoBuddyTesting - Db-derby Wiki

Objective: Facilitate test coverage of the new features added to 10.2.

'Buddy Testing', wherein contributors test Derby 10.2 features added by other members. Each contributor is encouraged to signup for testing and providing feedback on multiple features. A single feature can also have multiple buddy testers, the more the better.

The test scenarios could be functionality testing, integration testing, stress/load testing etc. using the newly added features in 10.2. It's good to test by trying to use the feature following the user documentation, thus testing the code and the documentation at the same time. It would be great if any test (JUnit pretty please) written could be contributed back to Derby so that others can run and expand them.

Signup for testing new features in 10.2

New Feature	Link to JIRA entries	Members	Documentation Available	Comments
SUR
Scrollable Updatable ResultSets - Embedded	DERBY-690	Sunitha Kambhampati	Yes. Verified documentation exists	Tested. Found one known issue DERBY-1696. Found an unrelated doc issue as part of this testing effort. DERBY-1753
Scrollable Updatable ResultSets - Client	DERBY-775	Rajesh
JDBC4
* JDBC4 Ease of Development Support	DERBY-942	Bernt, Dan D	Briefly mentioned in the ref.guide. Nothing in the dev. guide.	Tested as far as JDK 6 b96 permits. No issues found. Needs to be revisited with a later build. Testing with b98 saw DERBY-1859 DERBY-1863 DERBY-1864 DERBY-1865
* New implementation of methods	DERBY-1238, DERBY-1180
* Miscellaneous methods in Connection, Statement, PreparedStatement, ResultSet, DatabaseMetaData classes	DERBY-945, DERBY-953, DERBY-947, DERBY-948, DERBY-946
* CLOB and BLOB specific support	DERBY-796
* New methods for empty LOBS	DERBY-1255	Fernanda		Tested. No issues found. Verified documentation is updated. -Fernanda
* AutoLoading of Derby client drivers	DERBY-930
* Statement Events	DERBY-941
* Jdbc4.0 implementation of EmbedPooledConnection and EmbedXAConnection	DERBY-1163
* ROWID methods for JDBC4 support	DERBY-944	Knut A.		RowId is not exposed to users. Removed empty implementation in DERBY-1768. - Knut A.
* New metadata API	DERBY-924, DERBY-925
* Lengthless streaming overloads	DERBY-1417 DERBY-1473		Mentioned breiefly in the Developers Guide. Usage documented by the Java SE 6 API documentation.
Unary plus/minus for parameters	DERBY-582	Deepa		Tested. No issues found. Verified documentation is updated. -Deepa
FOR UPDATE clause	DERBY-231	Fernanda		Tested. No issues found. Verified documentation is updated. -Fernanda
Client timeout mechanism	DERBY-506	Deepa		Tested. Found 1 issue - DERBY-1692. Opened DERBY-1698 to contribute the tests I have written for this. Verified that 10.2 documents do not mention this method as not implemented. No other documentation for this feature other than javadoc. - Deepa
Optimizer directives	DERBY-573	Deepa		Tested. Found 1 issue - DERBY-1707. This looks like a corner case. Verified documentation is okay. - Deepa
XML support for XPath and JDBC	DERBY-688	Suresh, Dan Debrunner	Operators and data type documented in second beta	Tested. issues - DERBY-1718 DERBY-1772 DERBY-1775 DERBY-1776
Grant Revoke	DERBY-464	Yip	Documentation checked in (Derby-1057)	Tested. Found 10 issues - DERBY-1858 DERBY-1847 DERBY-1738 DERBY-1724 DERBY-1723. DERBY-1716. DERBY-1715. DERBY-1708. DERBY-1538. DERBY-1583 (similar issue filed by Mamta). Opened DERBY-1736 to contribute additional tests that I wrote.
Online backup	DERBY-239	Rajesh	Documentation checked in
DRDA USRSSBPWD Security Mechanism	DERBY-528	Fernanda	Documentation checked in (DERBY-1747)	Tested. No issues found. Verified documentation is updated. -Fernanda
Identity value restart	DERBY-783	Suresh	Documentation checked in (DERBY-869)	Tested. Found one known issue DERBY-1495
insert functionality using JDBC 2.0 updatable resultset	DERBY-100	Knut A.	Described in the devguide.	Tested. Issues DERBY-1744 DERBY-1767 DERBY-1773. Verified documentation is updated.
New functions: ACOS, ASIN, ATAN, COS, SIN, TAN, ...	DERBY-475	Susan	Documentation checked in (Derby-1548)	Made doc comments on ReferenceManualTenTwo, submitted JUnit tests for contribution. [ http://issues.apache.org/jira/browse/DERBY-1802 DERBY-1802]
New JDBC escape functions: ACOS, ASIN, ATAN, COS, SIN, TAN ...	DERBY-592	Susan	Documentation checked in (Derby-1549)	Made doc comments on ReferenceManualTenTwo, submitted JUnit tests for contribution. [ http://issues.apache.org/jira/browse/DERBY-1802 DERBY-1802]
Restrict client connections,derby.drda.securityMechanism	DERBY-928	Mamta
Database Re-encryption	DERBY-1156		Not available yet (Derby-1636)
Invoke Java Procedures from triggers	DERBY-551	Yip, Dan D	Documentation checked in (Derby-1551)	Tested, found 1 issue - DERBY-1729
'show tables' and 'describe' commands in ij	DERBY-1164	Andreas	Doc in DERBY-1659	Found no bugs. Made one minor comment on doc.
Enhance GROUP BY clause to support expressions	DERBY-883			pending checkins
Improve Network Server large object Streaming	DERBY-326		Documentation checked in (DERBY-1278)
ALTER TABLE change nullability	DERBY-119		Documentation tracked by DERBY-1765