[Bug] Left expr of binary predicate should be column name, predicate: minute(`date`) != 59, left expr type:TINYINT

[drgnchan]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Version

select version(); return 5.7.99

What's Wrong?

execute: delete from cost where minute(date) <> 59;

an error is reported: SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = errCode = 2, detailMessage = Left expr of binary predicate should be column name, predicate: minute(date) != 59, left expr type:TINYINT

What You Expected?

sql executed successfully.

How to Reproduce?

CREATE TABLE `cost` (
  `id` bigint(20) NULL,
  `name` varchar(20) NULL,
  `date` date NULL,
  `cost` bigint(20) SUM NULL
) ENGINE=OLAP
AGGREGATE KEY(`id`, `name`, `date`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`id`, `name`) BUCKETS 8
PROPERTIES (
"replication_allocation" = "tag.location.default: 1"
);

insert into cost values (1, 'abc', '2021-01-01', 100);

delete from cost where minute(date) <> 59;

Anything Else?

No response

Are you willing to submit PR?

• [X] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[yiguolei]

@drgnchan Currently, delete where clause does not support expr or function, it only supports literal. For example, it does not support delete from cost where minute(date) <> 59; but it support delete from cost where date = '2020-11-11';