Skip to:

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

Native QoQ exception when column case differs

Description

qry = queryNew( 'col', 'varchar', [['foo'],['bar']] ); result = queryExecute(sql=" SELECT distinct col FROM qry where COL = 'foo' " ,params=[] ,options={dbtype="query"} );

With error

column name [COL] already exist;lucee.runtime.exp.DatabaseException: column name [COL] already exist

Environment

None

Activity

Show:

Pothys - MitrahSoft 12 July 2023 at 07:44

I checked this ticket with lucee versions 5.4.2.2-SNAPSHOT and 6.0.0.507-SNAPSHOT. Now native QoQ doesn't throw an error when the column name case was different. The issue was solved.

Zac Spitzer 11 July 2023 at 17:02

5.4

6.0

Brad Wood 11 July 2023 at 16:32
Edited

Lucee 6.0 pull

Brad Wood 11 July 2023 at 16:23

Lucee 5.4 pull

Brad Wood 11 July 2023 at 08:43

The source of this issue is I was using a Set<String> instead of Set<Key> which allowed duplicates.

Fixed

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

Sprint

Affects versions

Created 11 July 2023 at 08:39
Updated 20 May 2024 at 15:07
Resolved 12 July 2023 at 07:45