search

Trivadis / plsql-cop-cli

db* CODECOP Command Line
Other
24 stars 1 forks source link

Parse error when using new row_limiting_clause for similarity searches #42

Open PhilippSalvisberg opened 2 days ago

PhilippSalvisberg commented 2 days ago

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.