Unexpected SQL exception returned

[sayJason]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

I run the following statement through JDBC with version 8.3.0

CREATE TABLE t1 ( c1 int, c2 int);
CREATE TABLE t2 ( c1 int unsigned);
INSERT INTO t1 (c1,c2) VALUES (8,4);
INSERT INTO t2 (c1) VALUES (2454396638);
SELECT ca4 AS ca1 FROM (SELECT c2 AS ca4 FROM t1) AS ta2 CROSS JOIN (SELECT c1 FROM t2) AS ta3 UNION ALL SELECT c1 AS ca13 FROM t2; 

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

The JDBC should return {2454396638, 4}

3. What did you see instead (Required)

A SQLException is returned.

java.sql.SQLException: Out of range value for column 'ca1' : value 2454396638 is not in class java.lang.Integer range
	at org.mariadb.jdbc.internal.com.read.resultset.rowprotocol.RowProtocol.rangeCheck(RowProtocol.java:283)
	at org.mariadb.jdbc.internal.com.read.resultset.rowprotocol.TextRowProtocol.getInternalInt(TextRowProtocol.java:255)
	at org.mariadb.jdbc.internal.com.read.resultset.rowprotocol.TextRowProtocol.getInternalObject(TextRowProtocol.java:900)
	at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getObject(SelectResultSet.java:1159)
	in JdbcHelperImpl.getObject(JdbcHelperImpl.java:353)

4. What is your TiDB version? (Required)

Release Version: v8.0.0
Edition: Community
Git Commit Hash: 8ba1fa4
Git Branch: HEAD
UTC Build Time: 2024-03-28 14:22:15
GoVersion: go1.21.4
Race Enabled: false
Check Table Before Drop: false
Store: tikv

[sayJason]

Moreover, I can reproduce it with the client like DataGrip with JDBC version 8.2.0.

[aytrack]

simple reproduce is select c2 from t1 union select c1 from t2;. It's about int uninion int unsigned
for tidb

mysql> select c2 from t1 union select c1 from t2;
Field   1:  `c2`
Catalog:    `def`
Database:   ``
Table:      ``
Org_table:  ``
Type:       LONG
Collation:  binary (63)
Length:     11
Max_length: 10
Decimals:   0
Flags:      BINARY NUM


+------------+
| c2         |
+------------+
|          4 |
| 2454396638 |
+------------+
2 rows in set (0.00 sec)

+------------------------------+---------+-----------+---------------+-------------------------------------------------------+
| id                           | estRows | task      | access object | operator info                                         |
+------------------------------+---------+-----------+---------------+-------------------------------------------------------+
| HashAgg_9                    | 2.00    | root      |               | group by:Column#6, funcs:firstrow(Column#6)->Column#6 |
| └─Union_10                   | 2.00    | root      |               |                                                       |
|   ├─TableReader_13           | 1.00    | root      |               | data:TableFullScan_12                                 |
|   │ └─TableFullScan_12       | 1.00    | cop[tikv] | table:t1      | keep order:false, stats:pseudo                        |
|   └─Projection_14            | 1.00    | root      |               | cast(test.t2.c1, int(11) BINARY)->Column#6            |
|     └─TableReader_16         | 1.00    | root      |               | data:TableFullScan_15                                 |
|       └─TableFullScan_15     | 1.00    | cop[tikv] | table:t2      | keep order:false, stats:pseudo                        |
+------------------------------+---------+-----------+---------------+-------------------------------------------------------+
7 rows in set (0.01 sec)

for mysql

mysql> select c2 from t1 union select c1 from t2;
Field   1:  `c2`
Catalog:    `def`
Database:   ``
Table:      ``
Org_table:  ``
Type:       LONGLONG
Collation:  binary (63)
Length:     11
Max_length: 10
Decimals:   0
Flags:      NUM


+------------+
| c2         |
+------------+
|          4 |
| 2454396638 |
+------------+
2 rows in set (0.00 sec)