plsql-cop-cli
plsql-cop-cli copied to clipboard
Trivadis
db* CODECOP Command Line
The following statement causes parser errors: ```sql update dept_dv v set v.data = json_transform( v.data, set '$.street' = '85 Albert Embankment', nested '$.emps[*]' ( set '@.sal' = path '@.sal *...
The following code works without parser error (generic function): ```sql 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...
The following use of [JSON_modifier_list](https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/SQL-JSON-Conditions.html#GUID-99B9493D-2929-4A09-BA39-A56F8E7319DA__GUID-127FFE89-5800-469C-BFDF-6BDB9AF0FCA6) works: ```sql select cast('[1,2,3]' as json) is json value; select cast('[1,2,3]' as json) is json object; select cast('[1,2,3]' as json) is json array; select cast('[1,2,3]'...
The parser should support the shorthand operators, introduced with Oracle 23.4 (vector functionality). Currently, the code below leads to parse errors. As a workaround, the classical syntax can be used....
The following statement is based on an example from https://docs.oracle.com/en/database/oracle/oracle-database/23/vecse/generate-and-use-embeddings-end-end-search.html: ```sql SELECT d.id id, row_number() over (partition by d.id order by d.id) chunk_id, vc.chunk_offset chunk_offset, vc.chunk_length chunk_length, vc.chunk_text chunk, vector_embedding(doc_model...
The following example work without parse errors ```sql select vector_serialize(vector('[1.1,2.2,3.3]', 3, float32)); ``` However, when using the returning clause in [vector_serialize](https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/vector_serialize.html) a syntax error is thrown by db* CODEOP: ```sql...
The following example works without parse errors ```sql select from_vector(to_vector('[1.1, 2.2, 3.3]', 3, float32)); ``` However, when using the returning clause in [from_vector](https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/from_vector.html) a syntax error is thrown by db*...
The following example works without parse errors: ```sql select * from graph_table (students_graph match (p1 is person) -[e is friends]- (p2 is person) where p1.name = 'Mary' columns ( e.friendship_id,...
The following query causes a parser error: ```sql 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...
The following code worked in 23.3 and is parsed correctly by db* CODECOP: ```sql create or replace function get42 return number is mle language javascript q'[return 42;]'; / select get42();...