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

Get unexpected error when executing nested subquery #58762

Open
joechenrh opened this issue Jan 7, 2025 · 0 comments
Open

Get unexpected error when executing nested subquery #58762

joechenrh opened this issue Jan 7, 2025 · 0 comments
Labels
type/bug The issue is confirmed as a bug.

Comments

@joechenrh
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

CREATE TABLE t1 (ctime time, cbit bit(32));
insert into t1 values(now(), 1);

CREATE TABLE t2 (col_bit bit(32));
insert into t2 values(1);

CREATE TABLE t3 (col_time time);
insert into t3 values(now());

update t1 set cbit = 1 where cbit in ( select col_bit from t2 where ctime in ( select col_time from t3 where t1.cbit = 1 or t1.ctime < '18:00:00.00') );

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

Success.

3. What did you see instead (Required)

ERROR 1105 (HY000): Data Too Long, field len 10, data len 15

4. What is your TiDB version? (Required)

23ed0df

@joechenrh joechenrh added the type/bug The issue is confirmed as a bug. label Jan 7, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug The issue is confirmed as a bug.
Projects
None yet
Development

No branches or pull requests

1 participant