groovy-core/src/test/groovy/bugs/ForAndSqlBug.groovy

package groovy.bugs

import groovy.sql.TestHelper

/**
 * @author Jonathan Carlson
 * @version $Revision$
 */
class ForAndSqlBug extends GroovyTestCase {
    
    void testBugInNormalMethod() {
        def sql = TestHelper.makeSql()
        
        def li = ["a", "b"]
        for (x in li) {
            sql.eachRow("SELECT count(*) FROM FOOD") { e ->
            	println " ${x}"

	            assert x != null
            }
        }
    }

    void testBugInsideScript() {
        assertScript( """
import groovy.sql.TestHelper
def sql = TestHelper.makeSql()

def li = ["a", "b"]
for (x in li) {
    sql.eachRow("SELECT count(*) FROM FOOD") { e ->
    	println " \${x}"
    	
    	assert x != null
    }
}
""")        
	}

}