Bug with multi dataset queries. MSSQL plugin-driver error.

Description

Hi,
When sql-proc returns multiple datasets - Lucee returns error. “The key [SP_HELP_RES5] does not exist, but there is a similar key with name [sp_help_res1] available.“
That happens only with newer mssql drivers from 7.2.0. With 6.4.0.jre8 works well.

Environment

Microsoft SQL Server (Vendor Microsoft) Driver - 7.2.0 - 7.2.2

Activity

Show:
Pothys - MitrahSoft
February 5, 2020, 10:46 AM

I've checked this ticket & confirmed the issue happened on the extension MSSQL - 7.2.2.jre8 version. Both the ( 6.4.0.jre8 and 7.2.2.jre8 ) version results are different. And it throws an error as you said. I made a test with your code. but, it returns results are based upon your table. So, some difference has from both above versions. So, Micha will confirm about this issue.

Assignee

Michael Offner

Reporter

Guardian

Priority

Major

Labels

None

Fix versions

None

Affects versions

Configure