wjHuang
wjHuang
> > Is it ok to remove the suffix `+08:00`? > > I think it is. Do you see any problem with that? I'm not sure, maybe we should request...
Hi, @sunnyfun888 JSON_UNQUTE is a special function that hard to apply the optimization. You can work around with ``` mysql> alter table person add index idx((cast(json_extract(`address_info`, _utf8mb4'$.city') as char(64)))); Query...
> Hi [@wjhuang2016](https://github.com/wjhuang2016), We're trying to migrate a legacy system from MySQL to TiDB. During the migration research, this issue was found. There're a variety of data types in the...
> > The problem is that the expression type and the generated column type need to be strictly equal. MySQL doesn't follow it, and it causes a bug in MySQL....
``` if the string is longer than 64 when insert or update, will get Data too long for column error, and the truncation will be rollbacked ``` It's not true...
/retest
/retest
> Could you please confirm whether the simplification process we applied has been helpful for developers in diagnosing and addressing this issue? > > query1: > > ```sql > (SELECT...
Analyze: ``` sql mysql> SELECT `col_bigint_key_signed` AS `f7`,`col_double_key_signed` FROM `table_7_utf8_undef` WHERE( (-col_double_key_signed) SELECT `col_bigint_key_signed` AS `f7`,`col_double_key_signed` FROM `table_7_utf8_undef` WHERE( (-col_double_key_signed) =ANY(SELECT `col_char(20)_key_signed` FROM `table_3_utf8_undef`)) ; +------+-----------------------+ | f7 | col_double_key_signed...