Project

General

Profile

Actions

Bug #17315

closed

AS _encrypt=(...) does not encrypt data or truncates sql statement

Added by Krzysztof Putyra 3 months ago. Updated about 1 month ago.

Status:
Closed
Priority:
Normal
Assignee:
Krzysztof Putyra
Target version:
Start date:
17.11.2023
Due date:
% Done:

0%

Estimated time:
Discuss:
Prio Planung:
No
Vote:

Description

Observed behavior

The following command does not encrypt data:

10.sql=SELECT 'Hello world!' AS '_encrypt=AES-128'

The following command does not print 'end':

10.sql=SELECT 'Hello world!' AS _encrypt=AES-128, 'end'

The following command raises a DB exception:

10.sql=SELECT 'Hello world AS _encrypt=AES-128'

Reason

For the first behavior:
  • column names are parsed in Report::splitColumnNames and searched for = character, but the name is tested against encrypt instead of _encrypt
For the second and third behavior:
  • Inside Database::prepareExecute the statement is split at AS _encrypt= and everything that follows is forgotten.
Actions #1

Updated by Krzysztof Putyra 3 months ago

  • Description updated (diff)
Actions #2

Updated by Krzysztof Putyra 3 months ago

Fixed in branch B17315encrypt

Actions #3

Updated by Carsten Rose about 1 month ago

  • Target version changed from 24.1.2 to 24.1.0.rc1
Actions #4

Updated by Carsten Rose about 1 month ago

  • Status changed from In Progress to Closed
Actions

Also available in: Atom PDF