[GROOVY-3807] Sql.expand not working in Sql.eachRow(GString sql, Closure metaClosure, Closure rowClosure)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.7-beta-1
• Fix Version/s: 1.6.6, 1.7-rc-1
• Component/s: SQL processing
• Assignee: Paul King
• Reporter: Albatross
• Created: 04/Oct/09 02:41
• Updated: 07/Apr/15 19:12
• Resolved: 13/Nov/09 22:36

Description

The sample script below shows that Sql.expand does work for:
Sql.eachRow(GString sql, Closure rowClosure)
but NOT for
Sql.eachRow(GString sql, Closure metaClosure, Closure rowClosure)

-----------
import groovy.sql.Sql

import java.util.logging.*
Logger.getLogger('groovy.sql').level=Level.FINE

db = Sql.newInstance( 'jdbc:hsqldb:mem:GinA'
, 'sa'
, ''
, 'org.hsqldb.jdbcDriver')
db.execute "create table emp (name varchar(10))"

def tableName = "Emp"

// Line below logs: select * from Emp
db.eachRow("select * from ${Sql.expand tableName}") {}

// Line below logs: select * from groovy.sql.Sql$35@8ab08f
db.eachRow("select * from ${Sql.expand tableName}", {} ) {}