Vex · Errors

Value in a column position

compile throws invalid_dsl when a value is given where a column reference is required. Either operand of a comparison may be a column or a value, but the first operand of like, ilike, in and notIn must be a column, and so must every field, sort key and group key. Example: an ilike with the pattern and the column swapped.

Query

{
  from: ['shows'],
  fields: ['shows.night'],
  filter: { ilike: ['%tempest%', 'shows.title'] },
}

Table

CREATE TABLE shows (night text PRIMARY KEY, title text NOT NULL)

Error

invalid_dsl
Invalid field path "%tempest%". Expected format: entity.field

Output matches the expected value

Runs in this page on the installed package. The input and the expected output are defined by the example.