You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
CREATETABLEt0(c0 INTEGER UNSIGNED NOT NULL AUTO_INCREMENT ) PARTITION BY HASH(c0) PARTITIONS 2;
CREATETABLEt1(c0 INTEGER UNSIGNED NOT NULL AUTO_INCREMENT );
INSERT INTO t0 VALUES (1), (2);
INSERT INTO t1 VALUES (1), (2);
UPDATE t0 SET c0=1;
UPDATE t1 SET c0=1;
insert into t0 values(0);
insert into t1 values(0);
SELECTt0.c0FROM t0 order by c0;
SELECTt1.c0FROM t1 order by c0;
2. What did you expect to see? (Required)
two queries produce same result
3. What did you see instead (Required)
MySQL [d0]>SELECTt0.c0FROM t0 order by c0;
+----+
| c0 |
+----+
| 1 |
| 1 |
| 6 |
+----+3 rows inset (0.01 sec)
MySQL [d0]>SELECTt1.c0FROM t1 order by c0;
+----+
| c0 |
+----+
| 1 |
| 1 |
| 5 |
+----+3 rows inset (0.00 sec)
4. What is your TiDB version? (Required)
release version 8.0.0
The text was updated successfully, but these errors were encountered:
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
two queries produce same result
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
release version 8.0.0
The text was updated successfully, but these errors were encountered: