[jira] [Created] (GROOVY-8128) Breaking change in 2.4.9 with Sql query with GString

["Mike Sauer (JIRA)" <ji...@apache.org>]

Mike Sauer created GROOVY-8128:
----------------------------------

             Summary: Breaking change in 2.4.9 with Sql query with GString
                 Key: GROOVY-8128
                 URL: https://issues.apache.org/jira/browse/GROOVY-8128
             Project: Groovy
          Issue Type: Bug
          Components: groovy-runtime
    Affects Versions: 2.4.9
         Environment: Windows 7
            Reporter: Mike Sauer
            Priority: Critical


The following code worked for releases 2.4.8 and below:
    def query = """\
    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED\r\n\
    select u5f_documenttype from DocVersion dv left outer join ClassDefinition cd on dv.object_class_id = cd.object_id 
    where cd.symbolic_name in ('Retail', 'RetailWeb') and dv.is_current = 1
    and u59_accountnumber = $acctNum and u5f_documenttype = 'Signature Card'
    """
    def docFound = 'No Doc'
    consumerSql.eachRow(query) {

This code now fails in 2.4.9 and 2.4.10 with:
Mar 22, 2017 9:23:43 AM groovy.sql.Sql eachRow
WARNING: Failed to execute:     SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
    select u5f_documenttype from DocVersion dv left outer join ClassDefinition cd on dv.object_class_id = cd.object_id 
    where cd.symbolic_name in ('Retail', 'RetailWeb') and dv.is_current = 1
    and u59_accountnumber = ? and u5f_documenttype = 'Signature Card'
     because: com.microsoft.sqlserver.jdbc.SQLServerException: Unable to identify the table     SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
    select u5f_documenttype from DocVersion dv left outer join ClassDefinition cd on dv.object_class_id = cd.object_id 
    where cd.symbolic_name in ('Retail', 'RetailWeb') and dv.is_current = 1
    and u59_accountnumber = ? and u5f_documenttype = 'Signature Card'
     for the metadata.

I have tried changing to using placeholders and name parameters and I get similar results.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)