Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Reading mismatch data type pack. Cast from Int64 to String is NOT supported #6703

Closed
lilinghai opened this issue Feb 1, 2023 · 3 comments · Fixed by #6709
Closed

Reading mismatch data type pack. Cast from Int64 to String is NOT supported #6703

lilinghai opened this issue Feb 1, 2023 · 3 comments · Fixed by #6709
Assignees
Labels
report/community The community has encountered this bug. severity/critical type/bug The issue is confirmed as a bug.

Comments

@lilinghai
Copy link

lilinghai commented Feb 1, 2023

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> select count(*) from pk_is_handle1;
ERROR 1105 (HY000): other error for mpp stream: From MPP<query:<query_ts:1675219212921686072, local_query_id:172206, server_id:871855, start_ts:439148665346195457>,task_id:3>: Code: 0, e.displayText() = DB::Exception: Reading mismatch data type pack. Cast from Int64 to String is NOT supported!: (while reading from DTFile: /data0/db/data/t_98/stable/dmf_833), e.what() = DB::Exception,
mysql> set tidb_isolation_read_engines='tikv';
Query OK, 0 rows affected (0.05 sec)

mysql> set tidb_isolation_read_engines='tikv';
Query OK, 0 rows affected (0.04 sec)

mysql> select count(*) from pk_is_handle1;
+----------+
| count(*) |
+----------+
| 63159390 |
+----------+
1 row in set (2.39 sec)
CREATE TABLE `pk_is_handle1` (
  `a` bigint(20) NOT NULL,
  `b` int(11) DEFAULT NULL,
  `c` varchar(100) NOT NULL,
  `d` char(100) DEFAULT NULL,
  `e` float DEFAULT NULL,
  `g` double DEFAULT NULL,
  `h` decimal(8,4) DEFAULT NULL,
  `i` date DEFAULT NULL,
  `j` datetime DEFAULT NULL,
  PRIMARY KEY (`a`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin

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

3. What did you see instead (Required)

4. What is your TiFlash version? (Required)

master

@lilinghai lilinghai added the type/bug The issue is confirmed as a bug. label Feb 1, 2023
@ywqzzy
Copy link
Contributor

ywqzzy commented Feb 1, 2023

What's the plan? @lilinghai

@lilinghai
Copy link
Author

@seiya-annie
Copy link

/found community

@ti-chi-bot ti-chi-bot bot added the report/community The community has encountered this bug. label Jun 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
report/community The community has encountered this bug. severity/critical type/bug The issue is confirmed as a bug.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

6 participants