Trivadis / plsql-cop-cli

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

Parse error when using from_vector with returning clause #40

Open PhilippSalvisberg opened 4 days ago

PhilippSalvisberg commented 4 days ago

The following example works without parse errors

select from_vector(to_vector('[1.1, 2.2, 3.3]', 3, float32));

However, when using the returning clause in from_vector a syntax error is thrown by db* CODEOP:

select from_vector(to_vector('[1.1, 2.2, 3.3]', 3, float32) returning varchar2(1000 char));
select from_vector(to_vector('[1.1, 2.2, 3.3]', 3, float32) returning clob);