[
https://issues.apache.org/jira/browse/IMPALA-14192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
weihua zhang updated IMPALA-14192:
----------------------------------
Description:
{code:sql}
SELECT 'huahua' ILIKE '%han%'
2025-06-27 03:57:08 [Exception] ERROR: Query 524963f4bf25a562:c84ba73900000000
failed:
AnalysisException: From line 1, column 8 to line 1, column 31: Invalid number
of arguments to function 'ILIKE'. Was expecting 0 arguments
CAUSED BY: SqlValidatorException: Invalid number of arguments to function
'ILIKE'. Was expecting 0 arguments
SELECT 'huahua' not ILIKE '%han%';
AnalysisException: From line 1, column 8 to line 1, column 34: No match found
for function signature NOT ILIKE
CAUSED BY: SqlValidatorException: No match found for function signature NOT
ILIKE
{code}
was:
{code:sql}
SELECT 'huahua' ILIKE '%han%'
2025-06-27 03:57:08 [Exception] ERROR: Query 524963f4bf25a562:c84ba73900000000
failed:
AnalysisException: From line 1, column 8 to line 1, column 31: Invalid number
of arguments to function 'ILIKE'. Was expecting 0 arguments
CAUSED BY: SqlValidatorException: Invalid number of arguments to function
'ILIKE'. Was expecting 0 arguments
{code}
> SqlValidatorException: Invalid number of arguments to function 'ILIKE'. Was
> expecting 0 arguments
> -------------------------------------------------------------------------------------------------
>
> Key: IMPALA-14192
> URL: https://issues.apache.org/jira/browse/IMPALA-14192
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: weihua zhang
> Priority: Major
>
> {code:sql}
> SELECT 'huahua' ILIKE '%han%'
> 2025-06-27 03:57:08 [Exception] ERROR: Query
> 524963f4bf25a562:c84ba73900000000 failed:
> AnalysisException: From line 1, column 8 to line 1, column 31: Invalid number
> of arguments to function 'ILIKE'. Was expecting 0 arguments
> CAUSED BY: SqlValidatorException: Invalid number of arguments to function
> 'ILIKE'. Was expecting 0 arguments
> SELECT 'huahua' not ILIKE '%han%';
> AnalysisException: From line 1, column 8 to line 1, column 34: No match found
> for function signature NOT ILIKE
> CAUSED BY: SqlValidatorException: No match found for function signature NOT
> ILIKE
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
