[GROOVY-2856] groovy.sql.DataSet should alias table name in SQL to accomodate http://download.oracle.com/docs/cd/B14117_01/java.101/b10979/resltset.htm#sthref1543 17.2.2.1.1 Workaround

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Component/s: SQL processing
• Environment: any Oracle environment
• Assignee: Paul King
• Reporter: Matthew Osborn
• Created: 23/May/08 10:10
• Updated: 07/Apr/15 19:13
• Resolved: 30/Dec/10 08:58

Description

The example at http://groovy.codehaus.org/Database+features ...

// allow resultSets to be able to be changed
sql.resultSetConcurrency = java.sql.ResultSet.CONCUR_UPDATABLE

// change the data
sql.eachRow("select * from PERSON") {
it.firstname = it.firstname * 2
}

will not work with Oracle because Oracle disallows ResultSet CONCUR_UPDATABLE on "select * from t". However, Oracle allows it for "select t1.* from t t1" per the link in this ticket's summary. Looked to me like groovy.sql.DataSet.java would do this with a little tweaking, and should be harmless to other database environments.