red-soft-ru / shardingsphere

Distributed SQL transaction & query engine for data sharding, scaling, encryption, and more - on any database.
Apache License 2.0
0 stars 1 forks source link

T615/T617 WINDOW FUNCTION #76

Closed makssent closed 1 month ago

makssent commented 1 month ago

Fixes #62, #63.

Ошибка: You have an error in your SQL syntax: SELECT CUST_CODE CUST_NAME rank() over (order by opening_amt) lead(opening_amt1) over (order by opening_amt) FROM CUSTOMER order by opening_amt no viable alternative at input '(' at line 1 position 42 near @942:42='('<29>1:42

Ошибка: You have an error in your SQL syntax: SELECT CUST_CODE CUST_NAME rank() over (order by opening_amt) first_value (opening_amt) over (order by opening_amt) FROM CUSTOMER order by opening_amt no viable alternative at input '(' at line 1 position 42 near @942:42='('<29>1:42

Новая ошибка: Cannot invoke "org.antlr.v4.runtime.tree.ParseTree.accept(org.antlr.v4.runtime.tree.ParseTreeVisitor)" because "tree" is null

makssent commented 1 month ago

Нужны корректировки