[
https://issues.apache.org/jira/browse/GROOVY-5436?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18075045#comment-18075045
]
ASF GitHub Bot commented on GROOVY-5436:
----------------------------------------
paulk-asert merged PR #2474:
URL: https://github.com/apache/groovy/pull/2474
> 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
> Priority: Major
>
> 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)
