Error Executing Query with empty queryparam value list

Description

An error occurs anytime a run a database query using the syntax below on mysql 8

Note: the value of id is empty/blank ""
I get the following error : Error (java.lang.IndexOutOfBoundsException)

Please help look into this

Environment

Servlet Container : Apache Tomcat/9.0.11
Java: 13 (Oracle Corporation) 64bit
OS Mac OS X (10.15.1) 64bit
Database: mysql 8

Activity

Show:
Pothys - MitrahSoft
December 12, 2019, 10:07 AM

I've checked and added a test case for this ticket & confirmed the issue happened on lucee latest version 5.3.5.52-SNAPSHOT.

Pull request: https://github.com/lucee/Lucee/pull/816

Abram Adams
May 29, 2020, 11:27 PM

Just noting here that we're running into this issue trying to migrate apps to Lucee.

Adam Tuttle
November 3, 2020, 2:55 PM

We are also running into this in a migration project from ACF to Lucee. It would be nice if it were fixed, or at least if the error message made any sense at all. “Index 0 out of bounds for length 0” sent me on a wild goose chase to find some rogue code using arrays or array notation.

Assignee

Michael Offner

Reporter

Arowolo Abiodun

Priority

Major

Fix versions

None

Affects versions

Configure