[
https://issues.apache.org/jira/browse/GROOVY-5436?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Paul King resolved GROOVY-5436.
-------------------------------
Fix Version/s: 6.0.0-alpha-1
Assignee: Paul King
Resolution: Fixed
> add Sql.inList for collection expansion in SQL IN clauses
> ---------------------------------------------------------
>
> Key: GROOVY-5436
> URL: https://issues.apache.org/jira/browse/GROOVY-5436
> Project: Groovy
> Issue Type: Improvement
> Components: SQL processing
> Affects Versions: 1.8.6
> Reporter: Gerhard Stuhlpfarrer
> Assignee: Paul King
> Priority: Major
> Fix For: 6.0.0-alpha-1
>
>
> Groovy SQL (groovy.sql.Sql) provides methods to bind an Array of parameters
> to sql (e.g. rows, eachRow, execute, executeUpdate, ...).
> But you have a problem if you need to pass parameter lists to your sql
> statement which has a IN clause.
> There exists a workaround for this problem, but this is not very groovy.
> see discussions here:
> http://groovy.329449.n5.nabble.com/In-operator-in-Groovy-SQL-td4768856.html
> http://stackoverflow.com/questions/2861230/what-is-the-best-approach-using-jdbc-for-parameterizing-an-in-clause
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
