[GROOVY-8128] Breaking change in 2.4.9 with Sql query with GString

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.4.9
• Fix Version/s: 2.4.11
• Component/s: groovy-runtime
• Environment: Windows 7
• Assignee: Paul King
• Reporter: Mike Sauer
• Created: 22/Mar/17 13:36
• Updated: 02/May/17 02:03
• Resolved: 28/Mar/17 02:48

Description

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.

Issue Links

• is related to: GROOVY-8082 Groovy sql.rows returns org.postgresql.util.PSQLException: No hstore extension installed