[ https://issues.apache.org/jira/browse/IGNITE-22418?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Maksim Zhuravkov updated IGNITE-22418: -------------------------------------- Description: Both queries return parse error: Failed to parse query: Encountered "USING" {noformat} SELECT POSITION('a' IN 'abc' USING CHARACTERS) {noformat} {noformat} SELECT POSITION('a' IN 'abc' USING OCTETS) {noformat} *Expected behaviour*: - POSITION function for character strings supports USING clause. - POSITION function for binary string still return an error (preferably it should be validation error as there is no POSITION (b IN binary string USING) function). was: Both queries return parse error: Failed to parse query: Encountered "USING" {noformat} SELECT POSITION('a' IN 'abc' USING CHARACTERS) {noformat} {noformat} SELECT POSITION('a' IN 'abc' USING OCTETS) {noformat} > Sql. POSITION function does not support USING POSITION | OCTETS clause > ---------------------------------------------------------------------- > > Key: IGNITE-22418 > URL: https://issues.apache.org/jira/browse/IGNITE-22418 > Project: Ignite > Issue Type: Bug > Components: sql > Reporter: Maksim Zhuravkov > Priority: Minor > Labels: ignite-3 > > Both queries return parse error: Failed to parse query: Encountered "USING" > {noformat} > SELECT POSITION('a' IN 'abc' USING CHARACTERS) > {noformat} > {noformat} > SELECT POSITION('a' IN 'abc' USING OCTETS) > {noformat} > *Expected behaviour*: > - POSITION function for character strings supports USING clause. > - POSITION function for binary string still return an error (preferably it > should be validation error as there is no POSITION (b IN binary string USING) > function). -- This message was sent by Atlassian Jira (v8.20.10#820010)