Issue Details (XML | Word | Printable)

Key: DOC-35
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Helen Borrie
Reporter: Paul Vinkenoog
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.

Error in UPDATE OR INSERT syntax, 2.1 Rlsnotes

Created: 10/Jan/09 11:04 PM   Updated: 10/Sep/10 03:13 AM
Component/s: None
Affects Version/s: None
Fix Version/s: None

File Attachments: None
Image Attachments:

1. screenshot-1.jpg
(66 kB)

 Description  « Hide
In the 2.1 Release Notes, the MATCHING clause of the UPDATE OR INSERT statement is given as:

  [MATCHING <column_list>]

This should be:

  [MATCHING (<column_list>)]

README.update_or_insert.txt contains the same error (which explains the error in the Notes)

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Helen Borrie added a comment - 07/Sep/10 12:17 AM
I don't know which version of release notes is referred to here. Syntax is correct in v.0213_14 dated 4 Feb 2010. I don't have anything local that's earlier than that, to figure out when the correction was done.

Paul V, if README.update_or_insert.txt hasn't been corrected, it's Adriano you'll need to contact. I doubt he ever looks at DOC tickets!

Paul Vinkenoog added a comment - 08/Sep/10 01:22 PM
My report was based on the 2.1.1 notes (15 Jul 2008).
The error was still there in 2.1.2 RC1 (31 Jan 2009, doc.v. 0212_02) but fixed in RC2 (25 Feb 2009, doc.v. 0212_04), so you can close this issue.

In the README, the error is still present in 2.1.3 final; I'll let Adriano know.

Helen Borrie added a comment - 08/Sep/10 07:45 PM - edited
Fixed prior to v.2.1.2 release; keep open until Adriano has fixed the Readme.

Paul Vinkenoog added a comment - 10/Sep/10 02:37 AM
Adriano just emailed me that he fixed the Readme.
But he pointed out that the RETURNING clause has an error too. It should be:

    [RETURNING <value_list> [INTO <variable_list>]]

(value_list instead of column_list)

Helen Borrie added a comment - 10/Sep/10 03:08 AM
Ugggh, I wonder what this <value_list> looks like...

Paul Vinkenoog added a comment - 10/Sep/10 03:13 AM
...and the same correction should be made (several times) in section "The RETURNING Clause" (2.1.x Notes)
and section "RETURNING Clause for Insert Statements" (2.0.x Notes).
It's always a value list; you can enter all kinds of expressions here, not just column names.