SQL syntax error w/ Dimensional Index on DuckDB

[carlineng]

What happens?

When attempting to run a dimensional index query in DuckDB, the following error occurs:

  query: search_index is {
    index:
      *,
      origin.*,
      carriers.*,
      destination.*
  }

Parser Error: syntax error at or near "WHEN"

To Reproduce

Run the dimensional index query in flights.malloy in the DuckDB FAA dataset in malloydata/malloy-samples: https://github.dev/malloydata/malloy-samples/blob/24c1ef51e23a641dc01180c88aa9daa6e5f1d898/duckdb/faa/flights.malloy#L145

OS:

macOS

Malloy Client:

web-based VSCode

Malloy Client Version:

v0.2.1695255498

Database Connection:

DuckDB