search

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

FIX E161, T351 #71

Closed makssent closed 1 month ago

makssent commented 1 month ago

Fixes #54, #61.

  1. Запрос: SELECT Cust_code FROM Customer --Comments from query Ошибка: You have an error in your SQL syntax: SELECT Cust_code FROM Customer --Comments from query no viable alternative at input '--' at line 1 position 32 near @432:33='--'<41>1:32

    Пример вывода со скипом комментариев для проверки 1 запрос (select (combineClause (selectClause SELECT (projections (projection (columnName (name (identifier Cust_code))))) (fromClause FROM (tableReferences (escapedTableReference (tableReference (tableFactor (tableName (name (identifier Customer)))))))))))

  2. Запрос: SELECT AGENT_NAME FROM agents /Bracketed SQL comments/ WHERE AGENT_NAME like '%u%' Ошибка:You have an error in your SQL syntax: SELECT AGENT_NAME FROM agents /Bracketed SQL comments/ WHERE AGENT_NAME like '%u%' no viable alternative at input '/' at line 1 position 31 near @431:31='/'<16>1:31

    Пример вывода со скипом комментариев для проверки 2 запрос (select (combineClause (selectClause SELECT (projections (projection (columnName (name (identifier AGENT_NAME))))) (fromClause FROM (tableReferences (escapedTableReference (tableReference (tableFactor (tableName (name (identifier agents)))))))))))