[
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)
