Skip to:

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

Issues

Select view

Select search mode

 
6 of 6

QoQ doesn't handle | and * correctly in LIKE expressions

Fixed

Description

Does using the LIKE operator with the combination of * (wildcard), such as '%3*562%', in a dbtype="query", make it compatible with ACF

Lucee Result:

ACF Result:

Environment

None

Attachments

2

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

Created 10 April 2024 at 13:26
Updated 24 April 2024 at 06:56
Resolved 24 April 2024 at 06:56

Activity

Show:

Pothys - MitrahSoft24 April 2024 at 06:56

I've checked this issue with Lucee latest version 6.0.2.19-SNAPSHOT. Now, QoQ successfully handles | and * in LIKE expressions and works fine.

Zac Spitzer14 April 2024 at 10:08
Edited

Need to escape | as well, test cases and fix added to PR

Zac Spitzer11 April 2024 at 14:05

Zac Spitzer11 April 2024 at 13:28

Pothys - MitrahSoft11 April 2024 at 11:36

, I’ve update the testcase PR :

Flag notifications