Skip to content

Parse error when using new row_limiting_clause for similarity searches #42

@PhilippSalvisberg

Description

@PhilippSalvisberg

The following query causes a parser error:

select name, embedding
  from galaxies
 order by vector_distance(embedding, vector('[0,1,1,0,0]', 5, int8), dot)
 fetch approx first 3 rows only
  with target accuracy 80 percent;

The reason is the new row_limiting_clause introduced in 23.4 to allow similarity searches. Changes in this clause are not covered by the underlying parser.

Metadata

Metadata

Labels

23.4bugSomething isn't working

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions