Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

5.4.3.2 QoQ incompatible data type with subquery IN operator

Description

I've run into a QofQ issue with Lucee 5.4.3.2 and using the 5.4.3.10-SNAPSHOT

The same QofQ has worked on all past versions of Lucee through 5.3.12.1

returning a single record

With the latest version, 5.4.3.2, I'm receiving the error "incompatible data type in conversion"

Is this a bug?

 

Initially reported at:

Environment

OS: Windows Server 2019 (10.0) 64bit
Java Version: 11.0.20 (Eclipse Adoptium) 64bit
Tomcat Version: 9.0.78
Lucee Version: Lucee 5.4.3.2 and 5.4.3.10-SNAPSHOT

Attachments

1

Activity

Show:

Zac Spitzer 20 September 2023 at 16:06

Marking won't fix, coz we can't fix it, that's the way the hsqldb engine works

Zac Spitzer 20 September 2023 at 16:01
Edited

yep, good catch. this is simply a case of the more modern version of hsqldb being more strict.

This ticket has enabled the above more flexible type handling, but didn’t allow this sub select string against a number.

Nothing more we can do. I have updated the test case to reflect this.

Pothys - MitrahSoft 20 September 2023 at 08:25

I have checked this issue with Lucee fixed versions 6.0.0.545-SNAPSHOT and 5.4.3.12-SNAPSHOT. Even now, I'm facing the same issue.

Zac Spitzer 15 September 2023 at 11:54
Edited

5.4

was published via manual compile with additional admin debug as 5.4.3.11, 5.4.3.12 removes this debug (no source changes)

6.0

Zac Spitzer 15 September 2023 at 11:27
Edited

enabling the sql.enforce_types setting to restore older hsqldb behavior

 

Table 14.20. Type Enforcement in Comparison and Assignment

Name

Default

Description

sql.enforce_types

false

enforcing type compatibility

This property, when set true, causes an error when an SQL statements contains comparisons or assignments that are non-standard due to type mismatch. Most illegal comparisons and assignments will cause an exception regardless of this setting. This setting applies to a small number of comparisons and assignments that are possible, but not standard conformant, and were allowed in previous versions of HSQLDB.

6.0

5.4

Won't Fix

Details

Assignee

Reporter

Priority

Labels

Fix versions

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Parent

Created 14 September 2023 at 16:15
Updated 20 September 2023 at 16:08
Resolved 20 September 2023 at 16:06