Skip to content

Invalid value for $current: null when sql command is executed #3583

@lekmaneb

Description

@lekmaneb

Hi,

Got an error while sending a SQL payload:

Error on transaction commit Invalid value for $current: null.

and in console:

2026-03-05 11:01:01.220 INFO [PostCommandHandler] <ArcadeDB_0> Error on transaction execution (PostCommandHandler): Error on executing command

Easy to reproduce with the following SQL command and the backup db:

SELECT expand($c) 
LET 
  $a = (
    SELECT identity, @rid as id FROM NER 
    WHERE identity.replace('\n', ' ').replace('\t', ' ').replace('  ', ' ') ILIKE ('%' + :keyWordIdentifier_0 + '%')
      AND identity.replace('\n', ' ').replace('\t', ' ').replace('  ', ' ') ILIKE ('%' + :keyWordIdentifier_1 + '%')
  ), 
  $b = (
    SELECT identity, @rid as id FROM THEME 
    WHERE identity.replace('\n', ' ').replace('\t', ' ').replace('  ', ' ') ILIKE ('%' + :keyWordIdentifier_0 + '%')
      AND identity.replace('\n', ' ').replace('\t', ' ').replace('  ', ' ') ILIKE ('%' + :keyWordIdentifier_1 + '%')
  ), 
  $c = UNIONALL($a, $b)

Best regards,

Malek

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions