Open aytrack opened 2 years ago
With TiDB v8.0.0 this happens:
tidb> SELECT REGEXP_INSTR(NULL, NULL);
ERROR 1139 (42000): Got error 'Not support binary collation so far' from regexp
MySQL 8.3.0 returns NULL
for the same query.
@aytrack , @xzhangxian1008 do you think this is the same issue?
With TiDB v8.0.0 this happens:
tidb> SELECT REGEXP_INSTR(NULL, NULL); ERROR 1139 (42000): Got error 'Not support binary collation so far' from regexp
MySQL 8.3.0 returns
NULL
for the same query.@aytrack , @xzhangxian1008 do you think this is the same issue?
Yes, it's the same issue.
create table test1 (c1 varchar(10), c2 varchar(10));
insert into test1 values (null, null);
select regexp_instr(c1, c2) from test1; # It will return null
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
3. What did you see instead (Required)
4. What is your TiDB version? (Required)