groovy/modules/classic/src/test/groovy/bugs/ForAndSqlBug.groovy

import groovy.sql.TestHelper

/**
 * @author Jonathan Carlson
 * @version $Revision$
 */
class ForAndSqlBug extends GroovyTestCase {
    
    void testBugInNormalMethod() {
        sql = TestHelper.makeSql()
        
        li = ["a", "b"]
        for (x in li) {
            sql.eachRow("SELECT count(*) FROM FOOD") { e |
            	println " ${x}"
            
	            assert x != null
            }
        }
    }
    
    void testBugInsideScript() {
        assertScript( <<<EOF
import groovy.sql.TestHelper
sql = TestHelper.makeSql()

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

}