Skip to:

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

QoQ: data exception: string data, right truncation ; size limit: 1

Description

update this can also be caused by using reserved column names in queries like maxlength

the new hsqldb engine is stricter, so if you are having problems, make sure you’re not using such column names

Environment

None

Activity

Show:

Pothys - MitrahSoft 6 July 2023 at 08:35

I checked this issue with Lucee versions 6.0.0.499-SNAPSHOT and 5.4.1.5. Now QoQ works fine and the issue was solved.

Zac Spitzer 6 July 2023 at 07:11
Edited

5.4

6.0

Zac Spitzer 6 July 2023 at 07:01
Edited

5.4

6.0

Zac Spitzer 6 July 2023 at 06:47

cool, found the problem

which defaults to 1, so I’m gonna change the temp table to store char as varchar

Andrew Kretzer 6 July 2023 at 06:25
Edited

example failing test case:

In MySQL db, the 3rd column in q1 is set as char(2). Changing it from char to varchar or changing the value from AK to A and the QoQ works in the above example.

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

Created 6 July 2023 at 06:11
Updated 20 May 2024 at 15:07
Resolved 6 July 2023 at 08:35