Skip to content

Instantly share code, notes, and snippets.

@hawkingrei

hawkingrei/README.md

Created February 16, 2026 02:38
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save hawkingrei/32fa638c335bc1a12174895cb41b7ca2 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save hawkingrei/32fa638c335bc1a12174895cb41b7ca2 to your computer and use it in GitHub Desktop.
Download ZIP
TiDB runtime error index out of range repro assets (case_0008)
Raw
README.md

TiDB out-of-range repro assets

1) Prepare

mysql --comments --host 127.0.0.1 --port 4000 -u root -e "select tidb_version()\G"

2) Reproduce

bash repro.sh

It prepares tidb_issue_repro_case_0008, loads schema/data, then runs:

  • concurrent query workers
  • concurrent DDL add/drop index loops

Expected failure when hit:

ERROR 1105 (HY000): runtime error: index out of range [2] with length 2

3) Query under test

SELECT t3.id AS t0_id, t5.id AS t1_id
FROM (
  SELECT t3.id AS id, t3.c0 AS c0, t3.c1 AS c1, t3.c2 AS c2, t3.c3 AS c3
  FROM t3
  WHERE (t3.c1 = 's26')
) AS t3
JOIN (
  SELECT t5.id AS id, t5.c0 AS c0, t5.c1 AS c1, t5.c2 AS c2, t5.c3 AS c3
  FROM t5
  WHERE (t5.id = 120)
) AS t5
  ON ((t3.id = t5.id) AND (t5.c1 = 99))
WHERE (((t5.c3 = 84) AND (t3.c2 = '2023-08-08 22:19:45')) AND (t3.c0 = '2024-02-18 02:32:31'));
Raw
case_0008_inserts.sql
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (90, 59, 58, '2026-06-16 22:51:49', '2024-05-27', 61, '2024-03-08 03:22:34');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (91, 14.19, 56, '2025-09-22 13:06:59', '2024-04-22', 60, '2026-09-12 18:14:18'), (92, 55.97, 87, '2026-06-03 21:54:36', '2023-12-28', 72, '2026-05-21 17:40:38'), (93, 23.67, 15, '2023-03-06 00:03:44', '2026-01-08', 18, '2024-12-19 19:51:53');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (94, 48.75, 62, '2023-02-15 13:53:49', '2023-06-22', 43, '2025-01-18 14:40:51'), (95, 7.56, 84, '2026-11-05 01:54:16', '2025-08-20', 84, '2023-04-22 10:40:41'), (96, 10.22, 86, '2023-09-26 23:56:33', '2024-09-27', 37, '2025-09-03 03:25:27');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (97, 78.86, 43, '2025-03-13 12:30:01', '2023-10-22', 88, '2025-11-12 16:24:00');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (71, 24, '2024-04-11', 76.41, 2.83, 14, 98.37), (72, 73, '2024-11-29', 98.58, 12.38, 98, 86.34);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (76, '2025-03-03 17:20:21', 's67', '2026-10-29 20:53:34', 60), (77, '2023-10-19 17:31:45', 's8', '2026-10-11 10:23:42', 28), (78, '2026-03-09 20:36:24', 's33', '2026-03-04 08:19:21', 52);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (68, 74, 19, 96, 57);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (79, '2024-02-05 15:02:29', 's99', '2025-08-30 09:38:58', 75), (80, '2025-12-10 13:15:39', 's25', '2023-08-10 07:27:52', 62), (81, '2024-12-31 05:20:25', 's90', '2024-06-07 15:03:27', 63);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (73, 78, '2026-02-22', 98.2, 31.58, 11, 31.29);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (83, 78, 67, 55.46, '2024-10-27 10:03:52'), (84, 13, 33.07, 74.85, '2024-02-23 11:43:55'), (85, 2, 38.58, 83.74, '2024-12-10 00:04:41');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (82, '2023-11-09 09:23:32', 's71', '2024-07-13 00:35:25', 19);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (86, 23, 21.01, 32.37, '2023-01-31 02:43:11'), (87, 87, 76.77, 78.28, '2023-10-16 16:08:42'), (88, 76, 82.9, 4.81, '2026-10-23 04:34:08');
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (89, 86, 83.76, 41.37, '2024-12-02 21:18:43'), (90, 74, 81.44, 33.49, '2025-05-19 09:27:38'), (91, 86, 78.84, 92.83, '2024-09-19 15:55:22');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (83, '2026-02-14 04:00:52', 's10', '2023-05-03 13:33:23', 44);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (69, 9, 56, 74, 62), (70, 89, 1, 51, 50);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (74, 33, '2023-10-23', 91.37, 92.79, 33, 2.32), (75, 4, '2026-01-11', 16.19, 59.78, 97, 48);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (92, 80, 25.67, 90.17, '2024-07-18 02:35:13'), (93, 17, 6.87, 74.02, '2024-11-30 06:03:06'), (94, 66, 24.63, 22.55, '2024-06-29 18:38:35');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (98, 28.92, 43, '2026-06-17 20:40:05', '2024-04-09', 2, '2025-11-09 23:40:53'), (99, 83.08, 81, '2025-10-30 16:59:53', '2024-11-28', 55, '2024-09-01 09:22:30');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (84, '2023-07-20 00:28:10', 's71', '2024-11-01 09:34:10', 31), (85, '2023-02-25 09:33:05', 's72', '2025-07-29 17:56:30', 79), (86, '2025-11-19 04:08:20', 's76', '2025-12-23 12:03:33', 90);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (71, 0, 23, 76, 45), (72, 11, 37, 91, 76);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (95, 87, 50.81, 47.58, '2026-12-16 10:55:00'), (96, 10, 64.57, 70.23, '2026-07-11 01:23:36');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (76, 5, '2025-06-18', 9.93, 83.8, 45, 90.28), (77, 88, '2026-09-23', 28.6, 73.37, 49, 50.22), (78, 1, '2025-04-26', 40.07, 31.53, 51, 30.74);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (79, 23, '2023-12-14', 10.45, 78.23, 92, 97.2), (80, 60, '2025-03-08', 57.53, 70.05, 61, 70.39);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (87, '2024-02-23 10:11:45', 's44', '2023-02-19 15:07:58', 17);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (100, 61.57, 60, '2023-06-03 02:31:59', '2024-03-21', 75, '2026-10-21 21:38:35'), (101, 78.76, 42, '2024-08-08 02:06:54', '2024-12-26', 4, '2024-11-14 06:22:28');
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (73, 6, 87, 95, 38);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (97, 33, 80.77, 42.32, '2024-05-06 08:22:35'), (98, 72, 11.22, 76.57, '2025-11-28 12:01:30');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (88, '2025-03-07 20:36:48', 's52', '2024-08-23 15:49:21', 83), (89, '2024-08-08 00:07:41', 's20', '2023-10-15 09:24:15', 27);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (99, 27, 97.32, 28.7, '2023-10-09 08:44:57'), (100, 13, 65.25, 15.93, '2026-04-16 04:27:20'), (101, 35, 33.49, 96.01, '2024-01-19 10:33:34');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (81, 78, '2025-09-23', 54.02, 76.59, 82, 83.88), (82, 51, '2023-01-14', 85.63, 4.08, 45, 92.54), (83, 55, '2026-11-12', 40.78, 36.89, 56, 20.24);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (102, 81.36, 10, '2025-12-03 07:23:52', '2024-10-05', 17, '2023-08-22 19:55:53');
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (74, 12, 67, 57, 11), (75, 37, 48, 5, 14), (76, 76, 19, 21, 58);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (102, 54, 49.29, 25.79, '2026-12-11 00:21:16'), (103, 40, 75.11, 70.54, '2026-10-20 21:58:18');
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (104, 36, 59.73, 69.63, '2023-10-13 17:55:29'), (105, 19, 43.39, 9.68, '2025-08-13 09:39:16'), (106, 58, 19.76, 81.21, '2025-10-25 20:38:47');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (103, 67.88, 98, '2025-01-19 11:40:32', '2023-10-13', 54, '2023-09-22 20:48:53'), (104, 55.96, 70, '2025-11-08 12:15:39', '2023-11-01', 99, '2026-11-13 20:21:26');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (90, '2026-05-30 10:43:33', 's71', '2024-08-10 06:54:56', 8), (91, '2024-12-12 05:54:16', 's52', '2025-04-30 22:32:35', 20), (92, '2026-07-24 20:42:11', 's9', '2026-10-15 19:08:46', 47);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (84, 22, '2026-11-19', 30.51, 54.25, 74, 51.52);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (107, 73, 85.8, 20.06, '2024-10-17 08:13:08'), (108, 35, 73.47, 68.32, '2025-02-26 19:02:24');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (93, '2025-10-22 19:46:03', 's56', '2026-01-08 20:58:58', 19), (94, '2026-12-12 18:00:43', 's48', '2023-07-23 14:59:56', 97), (95, '2025-05-13 03:36:32', 's40', '2023-01-10 19:44:05', 13);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (109, 72, 99.99, 15.44, '2025-10-04 22:03:35'), (110, 60, 46.43, 69.55, '2025-03-02 17:04:09');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (96, '2026-03-09 20:20:24', 's47', '2025-10-27 06:06:43', 80), (97, '2026-03-09 13:07:56', 's86', '2025-12-09 03:10:33', 62);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (111, 24, 19.01, 37.25, '2025-11-13 18:35:55');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (85, 74, '2026-06-25', 97.69, 99.89, 5, 88.71), (86, 64, '2023-09-21', 50.84, 84.42, 98, 47.47), (87, 9, '2024-03-17', 24.99, 86.38, 46, 40.85);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (98, '2025-03-07 12:01:25', 's72', '2026-06-21 17:15:04', 96);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (77, 86, 60, 32, 24), (78, 84, 45, 0, 36), (79, 32, 30, 22, 25);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (112, 41, 14.7, 19.42, '2026-05-08 03:04:04'), (113, 40, 59.22, 58.83, '2026-06-23 00:35:37'), (114, 5, 30.63, 7.58, '2026-02-19 08:21:55');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (99, '2024-08-04 11:37:36', 's28', '2025-08-26 07:04:08', 60);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (80, 61, 77, 35, 91), (81, 68, 47, 50, 23);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (115, 37, 1.82, 42.79, '2024-09-01 05:44:16');
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (116, 38, 29.79, 51.56, '2025-04-28 06:14:06'), (117, 99, 99.03, 26.18, '2026-05-22 10:21:47'), (118, 62, 72.77, 86.7, '2024-01-21 23:14:57');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (88, 33, '2026-09-04', 83.04, 25.96, 78, 41.2), (89, 94, '2026-06-17', 23.14, 1.89, 71, 90.19), (90, 82, '2026-11-18', 85.31, 71.2, 2, 17.22);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (119, 36, 19.05, 61.34, '2026-10-01 21:15:18');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (100, '2025-06-20 10:21:49', 's18', '2025-12-08 14:35:11', 35);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (82, 2, 84, 10, 27), (83, 8, 33, 27, 77);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (120, 19, 32.59, 50.84, '2026-02-02 00:44:55');
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (84, 80, 60, 12, 40), (85, 53, 73, 77, 47);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (86, 83, 9, 11, 80);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (101, '2024-08-22 06:10:08', 's65', '2023-01-19 01:26:48', 84), (102, '2024-01-19 22:34:35', 's14', '2025-03-13 07:53:09', 55), (103, '2023-11-16 12:23:12', 's27', '2025-04-03 06:55:15', 90);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (87, 86, 92, 20, 82);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (104, '2024-06-28 09:44:52', 's48', '2026-04-22 13:35:30', 39), (105, '2026-04-26 14:35:41', 's5', '2025-09-28 07:25:53', 67);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (105, 64.15, 70, '2024-12-21 14:04:14', '2024-01-10', 74, '2026-01-19 15:33:21');
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (121, 13, 1.61, 11.02, '2024-10-22 13:00:52');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (106, 58.35, 60, '2024-06-25 07:48:16', '2023-08-12', 90, '2023-12-05 16:47:56'), (107, 12.82, 68, '2024-01-31 03:05:11', '2023-06-05', 56, '2023-03-25 08:57:00');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (108, 25.86, 28, '2023-02-06 02:45:21', '2025-09-13', 80, '2026-09-27 00:30:11'), (109, 97.31, 97, '2024-01-21 11:42:50', '2026-08-14', 7, '2024-08-20 21:41:20');
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (88, 61, 38, 56, 7), (89, 46, 43, 22, 35), (90, 18, 96, 60, 82);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (91, 75, 77, 42, 96), (92, 61, 22, 33, 68), (93, 36, 1, 3, 38);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (122, 83, 51.59, 87.22, '2024-06-20 04:08:35');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (91, 5, '2024-10-09', 9.2, 45.79, 89, 25.95), (92, 40, '2025-11-16', 40.11, 21.19, 37, 59.93);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (106, '2025-09-22 08:08:19', 's12', '2023-07-14 16:47:54', 89), (107, '2026-06-27 00:13:55', 's36', '2026-10-07 10:43:12', 2);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (123, 12, 20.28, 20.55, '2024-08-24 15:18:28');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (110, 33.89, 12, '2024-06-20 06:24:50', '2025-11-20', 92, '2024-10-06 14:25:08'), (111, 12.72, 48, '2024-09-10 09:22:35', '2024-06-23', 35, '2024-11-03 08:49:26'), (112, 82.66, 44, '2026-06-22 13:40:16', '2024-01-12', 74, '2024-01-07 12:19:02');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (113, 13.86, 50, '2024-06-07 15:41:24', '2024-10-08', 93, '2026-02-21 23:19:16'), (114, 14.9, 38, '2023-11-06 01:54:27', '2024-11-15', 61, '2026-06-23 02:53:28');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (115, 19.2, 12, '2026-01-04 05:32:07', '2025-04-15', 3, '2023-07-04 06:20:44');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (93, 50, '2025-09-23', 28.58, 48.78, 47, 84.53), (94, 75, '2023-11-28', 48.13, 58.84, 41, 77.25), (95, 59, '2024-01-31', 31.02, 78.3, 15, 77.34);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (116, 63.72, 38, '2024-09-29 14:19:35', '2024-02-25', 7, '2023-10-18 12:09:29'), (117, 89.53, 7, '2026-05-29 07:53:45', '2026-07-29', 16, '2023-05-20 12:33:27'), (118, 13.23, 46, '2026-01-16 16:35:10', '2025-11-02', 89, '2025-04-16 16:42:40');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (108, '2026-10-20 12:05:04', 's12', '2025-08-28 08:50:12', 41), (109, '2023-08-17 02:59:46', 's67', '2024-04-13 04:23:59', 43);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (110, '2024-11-11 09:30:24', 's4', '2023-04-16 13:32:57', 13), (111, '2024-09-18 12:29:04', 's40', '2026-04-13 19:47:55', 76);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (112, '2025-03-08 06:53:10', 's49', '2024-12-03 08:50:12', 22), (113, '2024-02-06 12:05:22', 's42', '2024-11-18 16:29:21', 12);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (94, 64, 69, 17, 14);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (124, 85, 10.63, 69.59, '2026-08-04 12:38:34'), (125, 46, 68.1, 13.52, '2025-03-31 07:08:22'), (126, 84, 55.76, 15.71, '2026-03-04 19:48:09');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (114, '2026-05-08 13:55:02', 's28', '2024-08-20 01:54:08', 20), (115, '2026-05-25 18:34:44', 's54', '2025-08-20 20:41:34', 18), (116, '2024-08-03 20:12:50', 's7', '2024-07-18 12:14:15', 67);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (117, '2024-02-02 14:38:12', 's76', '2026-08-10 09:29:48', 88);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (119, 81.49, 18, '2025-04-09 12:14:39', '2025-08-25', 5, '2023-05-28 09:47:31');
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (127, 93, 11.91, 11.45, '2023-07-06 11:21:06'), (128, 92, 84.37, 73.11, '2025-04-18 14:11:13');
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (95, 98, 26, 5, 2), (96, 2, 80, 7, 73);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (118, '2023-02-16 22:57:27', 's15', '2026-05-25 11:25:15', 69), (119, '2024-03-11 13:53:16', 's61', '2024-10-04 05:22:13', 1);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (129, 23, 4.85, 10.9, '2023-11-26 19:28:23'), (130, 89, 55.23, 57.29, '2024-04-09 17:33:57'), (131, 40, 52.25, 29.48, '2024-05-27 02:22:13');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (120, 94.38, 73, '2024-11-22 23:57:34', '2023-08-22', 99, '2025-11-20 13:01:42'), (121, 59.34, 49, '2025-01-12 18:20:40', '2024-03-21', 18, '2026-04-16 04:11:26');
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (132, 87, 93.85, 94.62, '2023-07-15 03:05:36'), (133, 61, 71.48, 45.03, '2026-04-19 01:01:11');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (96, 53, '2025-05-05', 5.15, 51.13, 99, 75.23), (97, 21, '2026-06-03', 60.87, 52.14, 60, 83.38), (98, 1, '2023-11-28', 43.92, 7.2, 34, 11.89);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (122, 72.91, 34, '2026-11-15 01:07:33', '2026-08-09', 45, '2023-06-05 21:22:40');
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (134, 27, 94.85, 77.94, '2026-12-22 11:27:42'), (135, 21, 27.67, 89.71, '2024-11-14 15:31:02');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (120, '2025-07-20 23:19:30', 's26', '2023-08-08 22:19:45', 4), (121, '2023-05-02 07:56:05', 's21', '2025-05-20 02:56:01', 27), (122, '2025-05-03 22:01:30', 's47', '2023-05-03 20:12:59', 79);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (99, 8, '2024-12-24', 99.98, 16.2, 12, 44.39);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (123, 50.68, 41, '2026-07-23 02:19:00', '2023-05-21', 51, '2026-01-15 14:28:22'), (124, 53.65, 0, '2025-09-28 10:44:01', '2023-04-26', 4, '2024-06-15 13:28:14'), (125, 12.59, 24, '2026-12-10 11:07:19', '2025-03-29', 15, '2024-11-20 17:34:21');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (123, '2023-02-10 23:36:22', 's98', '2024-01-27 14:55:31', 9), (124, '2023-02-10 03:59:48', 's85', '2023-11-14 03:03:03', 54), (125, '2023-12-05 15:03:05', 's86', '2024-06-14 11:35:22', 79);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (100, 50, '2024-11-03', 0.99, 29.77, 82, 86.8);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (136, 95, 71.37, 35.46, '2024-10-10 23:37:54'), (137, 7, 56.9, 62.62, '2024-10-15 09:53:29'), (138, 69, 27.57, 10.95, '2024-01-30 20:29:43');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (126, 64.73, 92, '2024-09-02 15:22:29', '2023-11-02', 51, '2023-01-22 13:58:33'), (127, 20.02, 19, '2026-01-22 16:39:43', '2024-02-08', 94, '2026-12-07 17:03:47'), (128, 48.54, 16, '2023-11-17 13:37:54', '2024-03-21', 52, '2023-02-12 05:38:11');
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (139, 26, 61.82, 10.26, '2025-12-09 05:13:15'), (140, 42, 36.33, 45.16, '2026-10-22 05:21:28');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (129, 29.05, 2, '2025-04-19 04:05:08', '2023-02-01', 39, '2025-10-30 18:13:08');
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (141, 51, 31.34, 26.14, '2023-03-24 03:35:10');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (126, '2024-12-13 19:59:29', 's21', '2025-07-19 19:35:16', 79), (127, '2024-10-20 02:40:32', 's37', '2025-06-06 23:03:09', 57), (128, '2025-03-21 16:59:30', 's96', '2026-01-25 22:39:36', 7);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (129, '2023-08-23 02:02:26', 's0', '2025-07-21 13:18:00', 76), (130, '2026-10-25 06:14:33', 's91', '2025-05-07 05:12:41', 9);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (97, 61, 20, 5, 68);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (142, 92, 89.3, 24.19, '2023-10-22 16:46:56'), (143, 90, 33.9, 17.95, '2023-01-05 03:18:20'), (144, 29, 27.39, 25.23, '2023-04-08 12:05:39');
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (145, 48, 9.46, 46.77, '2026-09-15 03:44:56'), (146, 43, 2.66, 85.88, '2025-02-02 18:56:47');
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (98, 45, 75, 15, 85), (99, 67, 53, 86, 42), (100, 11, 35, 31, 84);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (101, 8, '2025-07-12', 84.28, 92.4, 43, 66.67);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (131, '2023-12-23 06:12:03', 's58', '2024-10-20 00:22:29', 38);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (147, 85, 1.76, 56.59, '2026-06-26 13:41:56'), (148, 98, 24.77, 33.5, '2024-10-01 14:43:48');
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (101, 92, 40, 53, 92), (102, 29, 81, 69, 77), (103, 23, 50, 91, 78);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (149, 63, 18.07, 67.87, '2026-07-21 13:07:35');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (132, '2024-12-08 02:51:28', 's14', '2023-05-16 18:50:00', 50), (133, '2025-10-04 22:14:29', 's1', '2023-09-08 18:54:01', 10);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (102, 74, '2026-02-21', 28.86, 15.07, 0, 23.79);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (104, 39, 91, 87, 28);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (105, 94, 24, 96, 32);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (134, '2024-05-20 02:07:26', 's34', '2026-06-12 01:33:24', 70), (135, '2025-04-09 00:26:11', 's64', '2023-09-19 11:16:25', 52);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (103, 71, '2023-11-17', 43.24, 99.65, 65, 31.51);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (136, '2024-10-28 10:42:13', 's67', '2023-01-06 17:29:20', 32), (137, '2025-03-13 10:58:52', 's53', '2025-01-30 02:53:41', 65);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (138, '2025-02-23 17:24:15', 's70', '2025-12-21 23:12:58', 82);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (139, '2024-06-04 14:12:55', 's25', '2024-06-27 22:29:20', 5), (140, '2024-10-06 01:56:19', 's65', '2025-09-11 11:58:24', 58);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (141, '2023-03-28 19:11:56', 's35', '2023-12-24 07:58:24', 72), (142, '2023-09-19 14:01:17', 's6', '2025-09-18 05:05:02', 46), (143, '2024-02-24 07:28:22', 's64', '2024-02-21 07:22:59', 82);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (144, '2023-06-06 06:18:28', 's35', '2025-10-14 05:36:46', 9), (145, '2025-04-09 18:46:59', 's64', '2025-11-11 12:20:58', 22);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (106, 86, 71, 24, 11);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (146, '2024-06-19 01:57:23', 's46', '2023-03-12 13:48:30', 25), (147, '2024-08-27 17:18:09', 's12', '2024-02-06 06:06:41', 80);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (104, 88, '2025-08-14', 79.53, 86.83, 66, 77.08);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (148, '2026-07-18 15:25:12', 's38', '2023-06-08 05:26:27', 75), (149, '2025-03-19 00:55:30', 's65', '2023-03-14 06:06:53', 28), (150, '2025-05-08 01:42:59', 's67', '2025-03-22 22:23:43', 28);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (130, 9.61, 4, '2024-01-22 04:39:40', '2023-04-17', 61, '2025-06-10 04:48:40'), (131, 45.97, 85, '2026-06-19 09:33:24', '2025-01-18', 36, '2025-03-07 15:31:21'), (132, 62.37, 12, '2025-01-01 22:56:29', '2025-05-31', 34, '2024-01-18 21:44:52');
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (150, 85, 60.81, 26.28, '2026-10-21 16:27:38');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (133, 51.63, 1, '2025-11-07 11:48:49', '2025-02-11', 64, '2026-03-28 04:42:06'), (134, 16.43, 21, '2025-10-19 22:52:46', '2026-12-03', 26, '2026-02-15 12:44:17');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (135, 41.83, 42, '2023-01-01 07:42:28', '2025-07-11', 99, '2026-10-12 10:37:55'), (136, 31.71, 14, '2024-10-26 15:30:55', '2023-10-09', 41, '2024-09-16 19:40:16');
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (107, 50, 90, 32, 17);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (108, 65, 48, 31, 72);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (105, 34, '2023-10-09', 25.01, 31.08, 29, 48.84);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (109, 63, 89, 63, 98);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (151, '2026-02-03 04:13:57', 's51', '2024-09-15 07:39:09', 43);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (137, 25.18, 98, '2024-10-11 20:57:57', '2023-09-22', 17, '2025-05-26 18:53:06');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (106, 90, '2026-02-22', 77.08, 85.99, 38, 83.91), (107, 63, '2024-12-04', 58.63, 60.29, 41, 70.73), (108, 41, '2023-12-24', 29.16, 57.12, 87, 22.36);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (110, 46, 3, 94, 35), (111, 18, 46, 88, 15);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (138, 17.45, 69, '2026-12-19 01:40:51', '2025-11-02', 72, '2025-07-01 09:21:51'), (139, 51.11, 51, '2025-09-26 20:13:17', '2025-12-07', 16, '2023-11-07 17:29:00'), (140, 31.66, 13, '2023-01-25 05:34:29', '2025-03-26', 43, '2024-04-26 04:01:01');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (109, 38, '2026-08-06', 91.91, 66.12, 71, 70.21), (110, 55, '2026-05-23', 36.26, 99.15, 76, 65.79);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (141, 55.5, 79, '2025-12-03 02:33:34', '2023-08-16', 26, '2026-03-20 01:13:11');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (142, 35.25, 17, '2026-05-31 20:50:07', '2024-11-23', 6, '2023-01-21 13:21:08'), (143, 86.71, 88, '2026-02-04 10:15:40', '2026-04-22', 13, '2025-06-28 16:14:54'), (144, 45.06, 19, '2023-08-19 21:31:20', '2025-07-30', 10, '2026-12-16 15:06:53');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (111, 5, '2026-08-06', 67.73, 26.6, 67, 3.47);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (112, 66, '2025-10-04', 43.81, 14.99, 7, 74.08), (113, 51, '2024-06-21', 42.87, 34.92, 26, 49.43);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (152, '2025-01-18 20:31:40', 's47', '2023-06-13 14:30:48', 3), (153, '2026-07-30 14:38:21', 's45', '2024-04-06 12:31:21', 77);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (114, 69, '2026-08-15', 11.44, 23.79, 25, 51.2), (115, 24, '2023-12-12', 45.99, 37.33, 58, 18.66), (116, 86, '2026-08-23', 14.42, 39.56, 31, 38.22);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (117, 18, '2023-05-29', 57.49, 63.09, 42, 9.02), (118, 44, '2024-06-19', 47.97, 2.64, 38, 19.68);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (119, 57, '2025-11-10', 66.17, 67.14, 11, 44.72), (120, 98, '2024-12-04', 8.7, 46.02, 82, 72.92), (121, 80, '2023-04-10', 98.7, 39.06, 4, 72.52);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (145, 77.14, 81, '2024-07-05 17:24:43', '2025-05-23', 70, '2023-03-19 03:54:01');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (154, '2025-12-17 02:20:56', 's4', '2026-10-24 20:44:36', 92);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (155, '2023-07-24 11:15:55', 's91', '2025-05-18 14:57:47', 17), (156, '2025-01-14 07:59:52', 's26', '2024-08-26 02:15:26', 14);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (122, 64, '2025-09-12', 10.24, 56.64, 68, 14.46), (123, 27, '2023-05-15', 30.88, 13.91, 89, 8.74), (124, 1, '2025-05-25', 37.38, 99.15, 91, 5.43);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (157, '2024-02-07 01:58:52', 's54', '2024-12-11 04:54:05', 33), (158, '2026-10-29 05:07:26', 's79', '2024-08-18 02:01:10', 88);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (159, '2025-05-01 02:31:50', 's48', '2025-02-15 04:30:50', 79), (160, '2024-09-01 07:02:18', 's77', '2024-10-04 22:07:38', 94);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (146, 17.41, 88, '2026-04-06 07:09:07', '2025-11-27', 31, '2024-11-04 03:13:58'), (147, 85.48, 4, '2024-09-06 01:37:40', '2026-05-19', 57, '2026-09-02 05:46:10'), (148, 78.68, 33, '2024-10-21 18:56:02', '2024-01-30', 32, '2026-05-24 00:15:19');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (149, 34.44, 69, '2025-04-05 21:08:39', '2025-09-11', 81, '2023-02-06 11:48:52'), (150, 22.72, 73, '2025-04-23 06:06:48', '2023-03-12', 76, '2025-10-04 01:16:22');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (125, 13, '2023-02-13', 46.85, 53.39, 0, 33.9), (126, 39, '2025-02-18', 35.2, 22.65, 62, 66.94);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (151, 61.59, 80, '2023-10-23 07:18:11', '2026-05-30', 41, '2025-11-28 03:32:28'), (152, 94.92, 98, '2026-08-25 18:06:26', '2026-12-29', 4, '2023-10-13 07:28:04');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (161, '2025-03-15 14:41:30', 's88', '2023-12-31 10:55:25', 83), (162, '2023-03-07 00:13:45', 's8', '2025-07-06 07:18:24', 77), (163, '2026-10-20 04:26:07', 's70', '2025-04-21 08:54:30', 25);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (153, 52.36, 93, '2023-12-02 11:59:01', '2023-03-24', 71, '2025-10-17 19:48:48'), (154, 26.08, 86, '2024-05-12 16:26:37', '2026-08-18', 37, '2023-03-04 16:27:06');
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (112, 60, 55, 90, 53);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (164, '2024-03-12 18:59:23', 's93', '2025-03-14 08:51:29', 23);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (127, 37, '2023-10-16', 85.92, 18.22, 14, 88.83);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (155, 6.39, 15, '2026-05-18 22:28:43', '2025-06-15', 30, '2025-12-09 02:44:27');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (156, 76.49, 54, '2025-01-23 19:42:10', '2023-05-10', 46, '2023-06-26 10:50:38');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (165, '2024-02-18 08:27:18', 's19', '2026-05-23 18:42:13', 4), (166, '2023-04-26 21:34:14', 's59', '2026-06-05 08:58:13', 98), (167, '2025-09-22 14:32:02', 's18', '2023-02-10 06:11:23', 29);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (168, '2024-07-21 11:17:58', 's43', '2024-01-24 15:36:39', 30), (169, '2024-09-30 14:48:32', 's71', '2023-02-08 13:53:53', 64);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (157, 19.19, 36, '2026-04-12 19:44:06', '2023-12-11', 31, '2026-06-21 12:36:20'), (158, 19.42, 11, '2024-08-29 06:54:59', '2024-07-06', 13, '2026-05-12 04:05:11');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (128, 84, '2026-06-02', 72.08, 49.36, 78, 93.9), (129, 18, '2026-01-13', 42.66, 66.27, 62, 50.07);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (165, 67, 49.19, 43.98, '2025-10-03 20:43:24'), (166, 76, 0.43, 47.88, '2026-01-31 16:17:11'), (167, 6, 71.26, 14.99, '2025-08-05 16:48:15');
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (170, '2024-07-29 08:06:43', 's56', '2023-09-01 23:49:53', 47), (171, '2023-01-04 09:22:45', 's34', '2026-05-28 00:40:09', 32);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (172, '2023-01-23 22:28:06', 's82', '2024-12-29 23:00:04', 58), (173, '2026-08-28 10:05:20', 's19', '2023-08-19 21:45:55', 76), (174, '2026-11-15 23:32:23', 's31', '2026-08-23 10:29:16', 38);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (175, '2024-06-06 19:22:46', 's1', '2026-09-22 01:36:37', 73);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (168, 73, 87.73, 88.89, '2023-01-17 14:47:26'), (169, 25, 75.36, 47.15, '2024-11-22 14:59:38');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (130, 64, '2026-11-29', 94.63, 8.78, 23, 23.51), (131, 47, '2025-12-31', 27.15, 82.88, 47, 65);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (170, 32, 55.32, 98.71, '2025-04-20 03:48:32'), (171, 89, 2.23, 44.17, '2023-03-07 15:38:42'), (172, 86, 79.15, 12.1, '2023-02-06 01:08:59');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (132, 57, '2025-10-18', 86.32, 75.49, 80, 63.15), (133, 14, '2023-09-21', 37.48, 92.28, 57, 20.25), (134, 17, '2024-12-18', 65.81, 8.58, 98, 6.02);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (176, '2024-10-24 21:23:20', 's94', '2023-10-29 22:11:23', 20);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (159, 18.31, 34, '2025-03-02 18:05:13', '2026-07-30', 22, '2024-04-16 08:41:38'), (160, 8.19, 11, '2024-06-27 21:58:06', '2023-01-30', 25, '2025-01-11 17:32:53'), (161, 4.13, 39, '2024-09-24 10:42:52', '2024-03-01', 68, '2024-08-09 11:29:39');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (135, 73, '2026-01-21', 81.37, 88.41, 55, 84.62);
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (136, 99, '2024-11-23', 1.76, 82.07, 26, 99.59);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (177, '2023-03-23 22:38:33', 's64', '2026-04-03 09:45:42', 47);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (113, 98, 89, 85, 99);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (178, '2023-06-11 13:17:06', 's41', '2026-06-02 00:13:48', 25), (179, '2026-04-22 12:17:11', 's57', '2023-05-31 11:14:24', 69);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (114, 86, 74, 74, 51), (115, 55, 81, 88, 77), (116, 8, 19, 13, 52);
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (117, 1, 69, 81, 19), (118, 95, 66, 75, 9);
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (162, 14.39, 67, '2024-06-26 03:54:44', '2025-06-18', 88, '2023-05-20 00:40:30'), (163, 85.63, 60, '2026-06-20 13:07:42', '2025-04-13', 61, '2024-07-03 22:34:12'), (164, 70.38, 16, '2026-06-10 22:03:08', '2023-07-04', 69, '2026-03-04 13:35:30');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (165, 21.67, 50, '2024-09-13 16:53:42', '2026-10-02', 23, '2025-04-16 13:55:06'), (166, 25.1, 87, '2023-02-09 12:12:22', '2025-02-13', 19, '2026-09-09 20:21:04'), (167, 73.75, 78, '2025-11-14 14:07:05', '2023-11-16', 61, '2025-10-09 01:33:53');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (168, 2.2, 13, '2025-08-20 23:54:32', '2024-02-24', 86, '2024-02-22 19:07:28');
INSERT INTO t2 (id, c0, c1, c2, c3, c4, c5) VALUES (137, 55, '2024-02-10', 3.46, 13.17, 88, 94.06);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (173, 62, 64.57, 62.96, '2026-12-11 23:21:19'), (174, 39, 58.31, 63.02, '2026-07-21 16:08:34'), (175, 76, 99.93, 59.18, '2025-02-27 07:51:20');
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (176, 95, 61.17, 94.48, '2026-11-19 15:53:53'), (177, 98, 14.89, 83.8, '2024-10-23 09:59:08');
INSERT INTO t1 (id, c0, c1, c2, c3, c4, c5) VALUES (169, 13.46, 43, '2025-01-28 21:08:50', '2026-04-06', 45, '2024-08-14 01:53:42');
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (119, 91, 47, 15, 5), (120, 34, 99, 2, 84);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (180, '2025-09-23 00:38:52', 's8', '2023-12-24 06:16:16', 43), (181, '2026-12-13 22:05:05', 's61', '2026-04-19 04:57:39', 94), (182, '2025-03-06 13:51:10', 's1', '2025-11-08 23:27:40', 35);
INSERT INTO t3 (id, c0, c1, c2, c3) VALUES (183, '2024-08-07 18:03:05', 's18', '2024-11-22 14:26:57', 36), (184, '2024-12-18 21:19:12', 's63', '2023-11-05 20:06:22', 79);
INSERT INTO t0 (id, c0, c1, c2, c3) VALUES (178, 97, 58.33, 91.97, '2024-02-15 22:40:23');
INSERT INTO t5 (id, c0, c1, c2, c3) VALUES (121, 14, 20, 68, 82);
Raw
case_0008_schema.sql
SET FOREIGN_KEY_CHECKS=0;
DROP VIEW IF EXISTS v4;
DROP VIEW IF EXISTS v3;
DROP VIEW IF EXISTS v2;
DROP VIEW IF EXISTS v1;
DROP VIEW IF EXISTS v0;
DROP TABLE IF EXISTS t5;
DROP TABLE IF EXISTS t4;
DROP TABLE IF EXISTS t3;
DROP TABLE IF EXISTS t2;
DROP TABLE IF EXISTS t1;
DROP TABLE IF EXISTS t0;
CREATE TABLE `t0` (
`id` bigint NOT NULL,
`c0` int NOT NULL,
`c1` float DEFAULT NULL,
`c2` float NOT NULL,
`c3` timestamp NOT NULL,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
KEY `idx_c1_3` (`c1`),
KEY `idx_c2_9` (`c2`),
KEY `idx_c3_15` (`c3`),
KEY `idx_id_17` (`id`),
KEY `idx_c0_21` (`c0`),
KEY `idx_c2_c1_c0_25` (`c2`,`c1`,`c0`),
KEY `idx_c3_c0_25` (`c3`,`c0`),
CONSTRAINT `fk_125` FOREIGN KEY (`id`) REFERENCES `t3` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `t1` (
`id` bigint NOT NULL,
`c0` decimal(12,2) NOT NULL,
`c1` bigint NOT NULL,
`c2` datetime NOT NULL,
`c3` date NOT NULL,
`c4` int NOT NULL,
`c5` timestamp NOT NULL,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
KEY `idx_c0` (`c0`),
KEY `idx_c5` (`c5`),
KEY `idx_id_1` (`id`),
KEY `idx_c2_13` (`c2`),
KEY `idx_c3_c0_15` (`c3`,`c0`),
KEY `idx_c1_18` (`c1`),
KEY `idx_c3_19` (`c3`),
KEY `idx_c4_22` (`c4`),
KEY `idx_c5_c2_c0_25` (`c5`,`c2`,`c0`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
PARTITION BY HASH (`id`) PARTITIONS 3;
CREATE TABLE `t2` (
`id` bigint NOT NULL,
`c0` int NOT NULL,
`c1` date DEFAULT NULL,
`c2` float NOT NULL,
`c3` decimal(12,2) NOT NULL,
`c4` bigint NOT NULL,
`c5` decimal(12,2) NOT NULL,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
KEY `idx_c0` (`c0`),
KEY `idx_c4` (`c4`),
KEY `idx_c5` (`c5`),
KEY `idx_c2_0` (`c2`),
KEY `idx_c3_4` (`c3`),
KEY `idx_id_5` (`id`),
KEY `idx_c1_7` (`c1`),
KEY `idx_c4_c2_c5_26` (`c4`,`c2`,`c5`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `t3` (
`id` bigint NOT NULL,
`c0` datetime NOT NULL,
`c1` varchar(64) NOT NULL,
`c2` timestamp NOT NULL,
`c3` int NOT NULL,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
KEY `idx_c2` (`c2`),
KEY `idx_c0_2` (`c0`),
KEY `idx_c1_8` (`c1`),
KEY `idx_id_10` (`id`),
KEY `idx_c3_11` (`c3`),
KEY `idx_c0_c1_c2_26` (`c0`,`c1`,`c2`),
KEY `idx_c3_c2_26` (`c3`,`c2`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `t4` (
`id` bigint NOT NULL,
`c0` varchar(64) NOT NULL,
`c1` bigint NOT NULL,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
KEY `fk_0` (`id`),
KEY `idx_c1_6` (`c1`),
KEY `idx_id_16` (`id`),
KEY `idx_c0_20` (`c0`),
KEY `idx_c1_c0_22` (`c1`,`c0`),
CONSTRAINT `fk_0` FOREIGN KEY (`id`) REFERENCES `t3` (`id`),
CONSTRAINT `fk_108` FOREIGN KEY (`id`) REFERENCES `t2` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
CREATE TABLE `t5` (
`id` bigint NOT NULL,
`c0` bigint DEFAULT NULL,
`c1` int DEFAULT NULL,
`c2` bigint NOT NULL,
`c3` int DEFAULT NULL,
PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */,
KEY `idx_c0` (`c0`),
KEY `idx_c1` (`c1`),
KEY `idx_c2` (`c2`),
KEY `idx_c3_12` (`c3`),
KEY `idx_id_14` (`id`),
KEY `idx_c3_c1_15` (`c3`,`c1`),
KEY `idx_c1_c0_25` (`c1`,`c0`),
KEY `idx_c0_c3_c2_25` (`c0`,`c3`,`c2`),
KEY `idx_c2_c0_25` (`c2`,`c0`),
KEY `idx_c3_c2_c1_25` (`c3`,`c2`,`c1`),
KEY `idx_c0_c2_c1_25` (`c0`,`c2`,`c1`),
KEY `idx_c2_c1_c0_26` (`c2`,`c1`,`c0`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
PARTITION BY HASH (`id`) PARTITIONS 4;
CREATE ALGORITHM=UNDEFINED SQL SECURITY INVOKER VIEW `v0` (`c0`) AS SELECT DISTINCT `t0`.`c3` AS `c0` FROM (SELECT `t0`.`id` AS `id`,`t0`.`c0` AS `c0`,`t0`.`c1` AS `c1`,`t0`.`c2` AS `c2`,`t0`.`c3` AS `c3` FROM `t0`) AS `t0` RIGHT JOIN `t1` ON (1=0) WHERE (NOT EXISTS (SELECT COUNT(1) AS `cnt` FROM `t1` WHERE (`t1`.`id`=`t1`.`c0`)) OR NOT EXISTS (SELECT COUNT(1) AS `cnt` FROM `t1` WHERE ((`t1`.`c2`>`t1`.`c3`) OR (`t1`.`c5`>=`t1`.`c3`))));
CREATE ALGORITHM=UNDEFINED SQL SECURITY INVOKER VIEW `v1` (`cnt`, `sum1`) AS SELECT DISTINCT COUNT(1) AS `cnt`,SUM(`t1`.`c0`) AS `sum1` FROM ((SELECT `t1`.`id` AS `id`,`t1`.`c0` AS `c0`,`t1`.`c1` AS `c1`,`t1`.`c2` AS `c2`,`t1`.`c3` AS `c3`,`t1`.`c4` AS `c4`,`t1`.`c5` AS `c5` FROM `t1`) AS `t1` JOIN (SELECT `v0`.`c0` AS `c0` FROM `v0`) AS `v0` ON (1=0)) LEFT JOIN `t0` ON (1=0) WHERE (NOT (`t0`.`c3` IN (_UTF8MB4'2026-07-13 12:55:30')) OR (NOT EXISTS (SELECT `v0`.`c0` AS `c0` FROM `v0` WHERE (_UTF8MB4'2023-11-13'<_UTF8MB4'2023-01-30')) AND ((`v0`.`c0`>`t1`.`c5`) AND NOT EXISTS (SELECT `t0`.`c1` AS `c0` FROM `t0` WHERE ((`t0`.`c1`>=`t0`.`id`) AND (`t0`.`c2`>=`t0`.`id`)))))) ORDER BY 1,2 LIMIT 13;
CREATE ALGORITHM=UNDEFINED SQL SECURITY INVOKER VIEW `v2` (`cnt`, `sum1`) AS SELECT COUNT(1) AS `cnt`,SUM(`t1`.`c0`) AS `sum1` FROM (((`v1` LEFT JOIN `t2` ON (1=0)) JOIN `t0` ON (1=0)) JOIN (SELECT `v0`.`c0` AS `c0` FROM `v0`) AS `v0` ON (1=0)) JOIN `t1` ON (1=0) WHERE (((`t1`.`c2`=`t2`.`c1`) AND EXISTS (SELECT `v0`.`c0` AS `c0` FROM `v0` WHERE ((65.28>19.2) AND (`v0`.`c0`<=_UTF8MB4'2024-05-04 20:28:29')) ORDER BY UPPER(_UTF8MB4's54') DESC,`v0`.`c0` LIMIT 7)) AND NOT EXISTS (SELECT COUNT(1) AS `cnt` FROM `t1` WHERE (`t1`.`c4`!=`t1`.`c0`))) ORDER BY 1 DESC,2 DESC;
CREATE ALGORITHM=UNDEFINED SQL SECURITY INVOKER VIEW `v3` (`cnt`, `sum1`) AS SELECT COUNT(1) AS `cnt`,SUM(`t2`.`c3`) AS `sum1` FROM (`t0` RIGHT JOIN (SELECT `t2`.`id` AS `id`,`t2`.`c0` AS `c0`,`t2`.`c1` AS `c1`,`t2`.`c2` AS `c2`,`t2`.`c3` AS `c3`,`t2`.`c4` AS `c4`,`t2`.`c5` AS `c5` FROM `t2`) AS `t2` ON (1=0)) RIGHT JOIN (SELECT `t1`.`id` AS `id`,`t1`.`c0` AS `c0`,`t1`.`c1` AS `c1`,`t1`.`c2` AS `c2`,`t1`.`c3` AS `c3`,`t1`.`c4` AS `c4`,`t1`.`c5` AS `c5` FROM `t1`) AS `t1` ON (1=0) WHERE NOT (`t0`.`c2` IN (10.01,34.14,40.7));
CREATE ALGORITHM=UNDEFINED SQL SECURITY INVOKER VIEW `v4` (`c0`, `c1`) AS SELECT `v3`.`cnt` AS `c0`,`v0`.`c0` AS `c1` FROM ((((SELECT `v2`.`cnt` AS `cnt`,`v2`.`sum1` AS `sum1` FROM `v2`) AS `v2` LEFT JOIN `v3` ON (1=0)) LEFT JOIN `v0` ON (1=0)) RIGHT JOIN `t1` ON (1=0)) RIGHT JOIN (SELECT `v1`.`cnt` AS `cnt`,`v1`.`sum1` AS `sum1` FROM `v1`) AS `v1` ON (1=0) WHERE NOT EXISTS (SELECT `t0`.`c3` AS `c0` FROM `t0` WHERE ((`t0`.`c2`=`t0`.`c0`) AND (`t0`.`c0`=`t0`.`c1`)));
SET FOREIGN_KEY_CHECKS=1;
Raw
repro.sh
#!/usr/bin/env bash
set -euo pipefail
HOST="${HOST:-127.0.0.1}"
PORT="${PORT:-4000}"
USER="${USER:-root}"
DB="${DB:-tidb_issue_repro_case_0008}"
WORKERS="${WORKERS:-6}"
QUERY_LOOPS="${QUERY_LOOPS:-2500}"
DDL_CYCLES="${DDL_CYCLES:-20}"
MYSQL=(mysql --comments --host "$HOST" --port "$PORT" -u "$USER")
"${MYSQL[@]}" -e "DROP DATABASE IF EXISTS \`${DB}\`; CREATE DATABASE \`${DB}\`;"
"${MYSQL[@]}" -D "$DB" < case_0008_schema.sql
"${MYSQL[@]}" -D "$DB" -e "SET SESSION FOREIGN_KEY_CHECKS=0;"
"${MYSQL[@]}" -D "$DB" < case_0008_inserts.sql
"${MYSQL[@]}" -D "$DB" -e "SET SESSION FOREIGN_KEY_CHECKS=1;"
SQL="SELECT t3.id AS t0_id, t5.id AS t1_id FROM (SELECT t3.id AS id, t3.c0 AS c0, t3.c1 AS c1, t3.c2 AS c2, t3.c3 AS c3 FROM t3 WHERE (t3.c1 = 's26')) AS t3 JOIN (SELECT t5.id AS id, t5.c0 AS c0, t5.c1 AS c1, t5.c2 AS c2, t5.c3 AS c3 FROM t5 WHERE (t5.id = 120)) AS t5 ON ((t3.id = t5.id) AND (t5.c1 = 99)) WHERE (((t5.c3 = 84) AND (t3.c2 = '2023-08-08 22:19:45')) AND (t3.c0 = '2024-02-18 02:32:31'));"
STOP_FILE="/tmp/tidb_issue_case0008_stop.flag"
HIT_FILE="/tmp/tidb_issue_case0008_hit.log"
rm -f "$STOP_FILE"
: > "$HIT_FILE"
q() {
local wid="$1"
local i=0
while [ ! -f "$STOP_FILE" ] && [ "$i" -lt "$QUERY_LOOPS" ]; do
i=$((i+1))
out=$("${MYSQL[@]}" -D "$DB" -e "$SQL" 2>&1 || true)
if echo "$out" | grep -q "runtime error: index out of range"; then
{
echo "HIT query worker=$wid iter=$i"
echo "$out" | grep "runtime error: index out of range" | head -n 1
} >> "$HIT_FILE"
touch "$STOP_FILE"
break
fi
done
}
d() {
local i=0
while [ ! -f "$STOP_FILE" ] && [ "$i" -lt "$DDL_CYCLES" ]; do
i=$((i+1))
"${MYSQL[@]}" -D "$DB" -e "ALTER TABLE t3 ADD INDEX idx_tmp_meta_a (c1,c0);" >/dev/null 2>&1 || true
"${MYSQL[@]}" -D "$DB" -e "ALTER TABLE t5 ADD INDEX idx_tmp_meta_b (c1,c3);" >/dev/null 2>&1 || true
out_add=$("${MYSQL[@]}" -D "$DB" -e "$SQL" 2>&1 || true)
if echo "$out_add" | grep -q "runtime error: index out of range"; then
{
echo "HIT ddl-after-add cycle=$i"
echo "$out_add" | grep "runtime error: index out of range" | head -n 1
} >> "$HIT_FILE"
touch "$STOP_FILE"
break
fi
"${MYSQL[@]}" -D "$DB" -e "ALTER TABLE t3 DROP INDEX idx_tmp_meta_a;" >/dev/null 2>&1 || true
"${MYSQL[@]}" -D "$DB" -e "ALTER TABLE t5 DROP INDEX idx_tmp_meta_b;" >/dev/null 2>&1 || true
done
}
pids=()
for w in $(seq 1 "$WORKERS"); do q "$w" & pids+=("$!"); done
d & pids+=("$!")
for p in "${pids[@]}"; do wait "$p"; done
if [ -s "$HIT_FILE" ]; then
echo "RESULT=HIT"
cat "$HIT_FILE"
else
echo "RESULT=NO_HIT"
fi
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment