plsql-cop-cli icon indicating copy to clipboard operation
plsql-cop-cli copied to clipboard

Parse error using vector/to_vector with asterisk in 2nd/3rd parameter

Open PhilippSalvisberg opened this issue 1 year ago • 0 comments

The following code works without parser error (generic function):

select vector('[0,1,1,0,0]', 5, int8);
select to_vector('[0,1,1,0,0]', 5, int8);

However, when using an asterisk in the 2nd or 3rd parameter a syntax error is produced by the db* CODECOP parser:

select vector('[0,1,1,0,0]', *, int8);
select vector('[0,1,1,0,0]', 5, *);
select vector('[0,1,1,0,0]', *, *);
select to_vector('[0,1,1,0,0]', *, int8);
select to_vector('[0,1,1,0,0]', 5, *);
select to_vector('[0,1,1,0,0]', *, *);

PhilippSalvisberg avatar Jul 03 '24 13:07 PhilippSalvisberg