[#DERBY-4049] SELECT statement topic in Reference Manual should reflect current WHERE clause behavior

Derby

SELECT statement topic in Reference Manual should reflect current WHERE clause behavior

Created: 04/Feb/09 03:48 PM Updated: 04/May/09 06:22 PM

Component/s:

Documentation

Affects Version/s:

10.4.2.0

Fix Version/s:

10.5.1.1

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
DERBY-4049.diff	2009-02-04 03:56 PM	Kim Haase	0.6 kB
rrefsqlj41360.html	2009-02-04 03:56 PM	Kim Haase	8 kB

Issue Links:

Reference

This issue is related to:

~~DERBY-4045~~ Subquery causes error: 'updateString' not allowed because the ResultSet is not an updatable ResultSet

Resolution Date:

05/Feb/09 03:48 PM

Description

« Hide

Currently, according to ~~DERBY-4045~~, SELECT statements do not allow WHERE clauses in subqueries if the SELECT statement is used for an updatable ResultSet. This behavior may need to change, but in the meantime the documentation should reflect the current situation. The SELECT statement topic in the Reference Manual is rrefsqlj41360.dita.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

[ Permlink | « Hide ]

Kim Haase added a comment - 04/Feb/09 03:56 PM

Attaching ~~DERBY-4049~~.diff and rrefsqlj41360.html. This patch adds a bullet item to the list of requirements for updatable cursors and updatable result sets.

[ Permlink | « Hide ]

Knut Anders Hatlen added a comment - 05/Feb/09 09:06 AM

Thanks for fixing this, Kim. +1 to commit.

[ Permlink | « Hide ]

Kim Haase added a comment - 05/Feb/09 03:48 PM

Thanks very much, Knut Anders.

Committed patch ~~DERBY-4049~~.diff to documentation trunk at revision 741149.

[ Permlink | « Hide ]

Kim Haase added a comment - 11/Feb/09 02:43 PM

Change has appeared in Latest Alpha Manuals, so closing.