Skip to:

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

QUERY error not thrown on 2 requests in one cfquery, and rollback is not executed

Description

When error occurred for global tmp tables, transaction won't rollback, and don't throw any error.

Table exists after executing query.

ColdFusion 10 works as expected

Environment

Microsoft SQL Server 2014

Activity

Show:

Pothys - MitrahSoft 13 May 2021 at 08:19

This issue was fixed from 5.3.8.169-SNAPSHOT onwards by the ticket LDEV-3127. Could please check with that version and report it here back?.


Guardian 14 October 2020 at 08:59
Edited

Recheck some others example:
Lucee can’t throw errors most of the time.
I thought, maybe, it can’t throw error if first query return some dataset - but it seems wrong, can’t find why this is happening.

Lucee Show exception as expected
1,4,7

Lucee not Shown exception
2,3,5,6,8

ACF Show exception as expected
1,2,4,5,6,7,8

ACF not Shown exception
3

Михаил Анцибор 12 October 2020 at 13:51

also this “bug” is valid for NON -tmp tables MSSQL

NO exception is displayed




Pothys - MitrahSoft 23 July 2020 at 14:42

I've checked this ticket and confirmed the issue happened on lucee latest version 5.2.8.17-SNAPSHOT also. In Lucie, no error is thrown while there is an issue with query. Also, there is no rollback. The table exists in lucee. But Avf works fine and also rollback working as correctly for this. So, the table doesn't create with ACF. And I've added a test case for this ticket.

Pull Request: https://github.com/lucee/Lucee/pull/987

Guardian 23 July 2020 at 13:20

Another example:

Updated data in 'test' table, doesn’t rollback when INSERT fails.

Details

Assignee

Reporter

Priority

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

Affects versions

Created 22 July 2020 at 08:08
Updated 6 October 2022 at 12:05