[HOP-2584] Execute SQL script error with select into error

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.70
• Fix Version/s: 0.99
• Component/s: Database
• Assignee: Hans Van Akelyen
• Reporter: Benoit Mouchard
• Created: 03/Mar/21 07:31
• Updated: 02/May/21 20:11
• Resolved: 02/May/21 20:11

Description

• 
  In Workflow, add Execute SQL script and put this

drop table if exists t;
drop table if exists tt;

select 1 as a, 2 as b into t;
select 3 as aa, 4 as bb into tt;

Connect to a postgres database, uncheck "Send as Single statement".

This  issue was report 5 years ago in PDI Jira with patch
https://jira.pentaho.com/browse/PDI-15395

Test on hop-client-0.70-20210302.151218