Error [types:1690]%s value is out of range in '%s'

[bajinsheng]

Bug Report

Unexpected Error.

1. Minimal reproduce step (Required)

CREATE TABLE t0(c0 DECIMAL, c1 BLOB(146) NOT NULL , c2 TEXT(438) );
INSERT INTO t0 VALUES (1337129865, '\\', 1248373951);
INSERT INTO t0(c0, c1) VALUES (1838451691, 498566332), (-1238701268, 1901594276) ON DUPLICATE KEY UPDATE c2=(CASE ((t0.c0)NOT REGEXP((('4') IS NULL))) WHEN '' THEN ((DEFAULT(t0.c0))>((CASE t0.c0 WHEN true THEN t0.c2 ELSE t0.c1 END ))) ELSE t0.c1 END );
INSERT IGNORE  INTO t0 VALUES ('e', -1064475704, NULL), (-9223372036854775808, -1404202394, false);
CREATE INDEX i0 ON t0(c2(149));
INSERT IGNORE  INTO t0(c1, c0, c2) VALUES ('', 0.5230300650126698, 1469316612) ON DUPLICATE KEY UPDATE c2=(CASE '㔜' WHEN t0.c2 THEN (CASE '' WHEN 908831379 THEN ((t0.c1)OR(t0.c2)) WHEN DEFAULT(t0.c1) THEN '{' ELSE (CASE 915621893 WHEN '1802686235' THEN t0.c2 ELSE -55981900 END ) END ) WHEN t0.c1 THEN 'lJ{*V' ELSE t0.c0 END );

ANALYZE TABLE t0; -- ERROR 1105 (HY000) at line 12: other error: [types:1690]%s value is out of range in '%s'

2. What did you expect to see? (Required)

No error.

3. What did you see instead (Required)

Error

4. What is your TiDB version? (Required)

| Release Version: v6.4.0-alpha-12-g51a6684fb
Edition: Community
Git Commit Hash: 51a6684fb767cfd86a8312e0e6447963b927c791
Git Branch: master
UTC Build Time: 2022-10-05 12:40:23
GoVersion: go1.19.1
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: unistore |

[ChenPeng2013]

i can't reproduce in latest master

[bajinsheng]

I can't reproduce it in today's version either. It should have been fixed in the past few days.
Thanks!