Assertion error that does not match expectations
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Bug Report
Please answer these questions before submitting your issue. Thanks!
### 1. Minimal reproduce step (Required)
```
USE test;
DROP DATABASE IF EXISTS database0;
CREATE DATABASE database0;
USE database0;
CREATE TABLE t0(c0 BIGINT UNSIGNED ZEROFILL NOT NULL DEFAULT 746248156 );
CREATE TABLE t1 LIKE t0;
ANALYZE TABLE t1 WITH 951 BUCKETS;
REPLACE INTO t1(c0) VALUES (2133733368);
ALTER TABLE t0 ORDER BY c0 ASC;
REPLACE INTO t0 VALUES (183117259);
INSERT IGNORE INTO t0 VALUES (-1526175653) ON DUPLICATE KEY UPDATE c0=DEFAULT(t0.c0);
INSERT IGNORE INTO t0(c0) VALUES (-1820592177);
REPLACE INTO t0(c0) VALUES (436691248);
INSERT IGNORE INTO t0 VALUES (-812292664), (1778184175) ON DUPLICATE KEY UPDATE c0=DEFAULT(t0.c0);
ADMIN CHECKSUM TABLE t0;
CREATE VIEW v0(c0) AS SELECT (BINARY (t1.c0)) FROM t0, t1 WHERE ((t0.c0)>(t1.c0));
INSERT INTO t0(c0) VALUES (1612225688) ON DUPLICATE KEY UPDATE c0=t0.c0;
REPLACE INTO t1(c0) VALUES (1057457590);
UPDATE t1 SET c0=t1.c0 WHERE ((((((t1.c0)^(t1.c0)))=('m')))OR(0.9126466167575598));
UPDATE t1 SET c0='238120233';
INSERT INTO t0 VALUES (1725580826) ON DUPLICATE KEY UPDATE c0=(BINARY (COALESCE(-1481430704)));
INSERT IGNORE INTO t1 VALUES (-1650369747), (-438868656) ON DUPLICATE KEY UPDATE c0='0';
UPDATE t0 SET c0=0.30071932851630767;
INSERT LOW_PRIORITY IGNORE INTO t1 VALUES (NULL) ON DUPLICATE KEY UPDATE c0=((t1.c0) IS NULL);
INSERT IGNORE INTO t1(c0) VALUES (-1770300835), (-1477782318);
CREATE INDEX i0 ON t0(c0);
INSERT IGNORE INTO t0 VALUES (1886536298) ON DUPLICATE KEY UPDATE c0=t0.c0;
INSERT IGNORE INTO t1 VALUES (-893539262) ON DUPLICATE KEY UPDATE c0=((1187389577)NOT REGEXP((('0.5324915654055873')LIKE(((false)<('(꠷%q'))))));
INSERT INTO t0 VALUES (1193977911);
INSERT IGNORE INTO t1 VALUES (NULL) ON DUPLICATE KEY UPDATE c0=t1.c0;
INSERT INTO t1 VALUES (395156263);
REPLACE INTO t0(c0) VALUES (544562698);
SELECT t1.c0, v0.c0 FROM t1 INNER JOIN v0 ON ((t1.c0)AND(t1.c0)) WHERE ((DEFAULT(t1.c0))>(INSERT((CASE (CASE 181636071 WHEN v0.c0 THEN NULL WHEN t1.c0 THEN 1343712004 ELSE t1.c0 END ) WHEN (CASE '-' WHEN t1.c0 THEN '1' ELSE -1387665832 END ) THEN v0.c0 WHEN INET6_ATON((CASE v0.c0 WHEN '31910362' THEN v0.c0 WHEN t1.c0 THEN v0.c0 ELSE 0.768062322723344 END )) THEN ((v0.c0)^(v0.c0)) ELSE t1.c0 END ), true, (CASE ((t1.c0) IS NOT NULL) WHEN ((v0.c0)NOT LIKE(t1.c0)) THEN ((v0.c0)!=(t1.c0)) ELSE '-' END ), 1146652354)));
```
### 2. What did you expect to see? (Required)
The statement returns the result successfully.
### 3. What did you see instead (Required)
AssertionError:ERROR 1411 (HY000): Incorrect string value: '395156263
### 4. What is your TiDB version? (Required)
8.0.11-TiDB-v7.5.1
Contributor guide
Assessment
This issue has not been assessed yet.