日期函数使用错误

[jd-zhang]

*Issue migrated from trac ticket # 892 www.kunlunbase.com *

component: computing nodes | priority: major

2022-07-11 13:57:32: vito@zettadb.com created the issue

---

sql:
drop table if exists t1, t2;
create table t1 (f1 int);
create table t2 (f2 int, f3 numeric(8));
insert into t1 values (1), (2);
insert into t2 values (1,20050101), (2,20050202);
select str_to_date(concat(f3),'%Y%m%d') from t1,t2 where f1=f2 order by f1;

ERROR 1305 (42000): function str_to_date(text, unknown) does not existHINT:  No function matches the given name and argument types. You might need to add explicit type casts.
 at character: 8

FILE:  parse_func.c      LINE: 615      FUNCTION:  ParseFuncOrColumn