Sergei Petrunia
a52362b90c
MDEV-36389 Incorrect query results for an indexed text column
...
Fixes a scenario where an IN subquery returned the wrong result
because the pushed WHERE clause was not retained for downstream
result filtering. For example:
CREATE TABLE t1 (c1 TEXT, UNIQUE (c1(1)));
INSERT INTO t1 (c1) VALUES ('a');
SELECT 'abc' IN (SELECT c1 FROM t1);
Internally, he 'abc' IN subquery condition becomes the constant
condition:
'abc' = t1.c1 or t1.c1 is null
Prior to this patch, this condition was incorrectly removed when
converting the subquery engine to an index lookup-based engine.
Now eligible conditions are preserved during such engine rewrites.
2025-07-23 15:24:12 -04:00
..
2025-06-28 01:13:10 +02:00
2025-06-28 01:13:10 +02:00
2025-01-17 14:16:41 +01:00
2025-01-30 12:01:11 +01:00
2025-04-15 14:36:02 -04:00
2025-04-28 12:38:01 +03:00
2025-04-28 12:38:01 +03:00
2025-06-17 09:50:22 +02:00
2025-06-17 09:50:22 +02:00
2025-03-15 11:15:54 +01:00
2025-05-27 10:24:58 +02:00
2025-06-17 09:50:22 +02:00
2025-06-17 09:50:22 +02:00
2025-02-26 12:40:07 +02:00
2025-02-26 12:40:07 +02:00
2025-01-14 23:45:41 +01:00
2025-01-14 23:45:41 +01:00
2025-02-10 15:59:28 +02:00
2025-06-17 09:50:22 +02:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 12:01:11 +01:00
2025-01-30 11:55:13 +01:00
2025-01-24 11:36:47 +04:00
2025-01-24 11:36:47 +04:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 12:01:11 +01:00
2025-01-29 11:17:38 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-02-26 12:40:07 +02:00
2025-01-30 12:01:11 +01:00
2025-01-30 11:55:13 +01:00
2025-01-24 11:36:47 +04:00
2025-01-24 11:36:47 +04:00
2025-04-17 10:01:53 +04:00
2025-04-17 10:01:53 +04:00
2025-04-17 10:01:53 +04:00
2025-04-17 10:01:53 +04:00
2025-04-17 10:01:53 +04:00
2025-01-17 15:39:55 +04:00
2025-01-17 15:39:55 +04:00
2025-01-30 12:01:11 +01:00
2025-01-30 12:01:11 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-01-30 12:01:11 +01:00
2025-01-30 12:01:11 +01:00
2025-07-23 11:07:22 +03:00
2025-04-26 10:53:02 +02:00
2025-07-19 06:18:27 +11:00
2025-07-19 06:18:27 +11:00
2025-04-26 10:53:02 +02:00
2025-06-17 09:50:22 +02:00
2025-06-17 09:50:22 +02:00
2025-01-20 09:57:37 +02:00
2025-01-15 12:34:25 +02:00
2025-04-15 14:36:02 -04:00
2025-02-10 22:06:49 +02:00
2025-02-10 22:06:49 +02:00
2025-04-26 10:53:02 +02:00
2025-04-26 10:53:02 +02:00
2025-04-17 11:38:33 -04:00
2025-04-17 11:38:33 -04:00
2025-03-31 12:12:50 +02:00
2025-03-31 12:12:50 +02:00
2025-02-06 13:17:47 +11:00
2025-02-06 13:17:47 +11:00
2025-03-27 08:01:47 +02:00
2025-03-27 08:01:47 +02:00
2025-02-10 22:06:49 +02:00
2025-02-10 22:06:49 +02:00
2025-04-26 10:53:02 +02:00
2025-04-26 10:53:02 +02:00
2025-03-28 13:55:21 +02:00
2025-03-28 13:55:21 +02:00
2025-04-26 10:53:02 +02:00
2025-04-26 10:53:02 +02:00
2025-04-26 10:53:02 +02:00
2025-04-26 10:53:02 +02:00
2025-04-26 10:53:02 +02:00
2025-04-25 15:10:36 +02:00
2025-06-17 09:50:22 +02:00
2025-06-17 09:50:22 +02:00
2025-05-28 16:33:49 +10:00
2025-05-28 16:33:49 +10:00
2025-05-28 16:33:49 +10:00
2025-03-03 11:07:56 +02:00
2025-03-03 11:07:56 +02:00
2025-03-28 13:55:21 +02:00
2025-03-28 13:55:21 +02:00
2025-03-28 13:55:21 +02:00
2025-07-23 15:24:12 -04:00
2025-04-26 10:53:02 +02:00
2025-01-29 11:17:38 +01:00
2025-01-29 11:17:38 +01:00
2025-03-26 17:05:44 +02:00
2025-03-26 17:05:44 +02:00
2025-03-26 17:05:44 +02:00
2025-01-30 11:55:13 +01:00
2025-01-14 23:45:41 +01:00
2025-05-23 14:46:35 +03:00
2025-05-26 08:10:47 +03:00
2025-03-28 13:55:21 +02:00
2025-03-28 13:55:21 +02:00
2025-04-26 10:53:02 +02:00
2025-04-25 15:10:36 +02:00
2025-04-25 15:10:36 +02:00
2025-03-31 18:37:06 +02:00
2025-03-31 18:37:06 +02:00
2025-04-09 09:42:15 +10:00
2025-04-09 09:42:15 +10:00
2025-04-26 10:53:02 +02:00
2025-04-26 10:53:02 +02:00
2025-01-14 23:45:41 +01:00
2025-04-26 10:53:02 +02:00
2025-04-26 10:53:02 +02:00
2025-02-23 19:09:05 +02:00
2025-02-23 19:09:05 +02:00
2025-02-23 19:09:05 +02:00
2025-03-06 09:40:55 +02:00
2025-03-06 09:40:55 +02:00
2025-03-03 11:07:56 +02:00
2025-03-31 22:28:52 +02:00
2025-03-31 22:28:52 +02:00
2025-03-27 21:25:05 +01:00
2025-03-27 21:25:05 +01:00
2025-01-30 12:01:11 +01:00
2025-06-17 09:50:22 +02:00
2025-06-04 14:09:23 +02:00
2025-01-30 12:01:11 +01:00
2025-01-17 15:39:55 +04:00
2025-01-30 11:55:13 +01:00
2025-03-31 22:28:52 +02:00
2025-01-30 12:01:11 +01:00
2025-01-30 12:01:11 +01:00
2025-03-31 22:28:52 +02:00
2025-03-31 22:28:52 +02:00
2025-03-21 14:01:52 +04:00
2025-03-21 14:01:52 +04:00
2025-03-17 18:11:51 +07:00
2025-03-17 18:11:51 +07:00
2025-01-30 12:01:11 +01:00
2025-06-17 09:50:22 +02:00
2025-06-17 09:50:22 +02:00
2025-06-17 09:50:22 +02:00
2025-04-27 22:16:17 -04:00
2025-06-17 09:50:22 +02:00
2025-06-17 09:50:22 +02:00
2025-02-10 15:59:28 +02:00
2025-01-27 15:59:47 +07:00
2025-02-10 15:59:28 +02:00
2025-04-15 14:36:02 -04:00
2025-01-30 12:01:11 +01:00
2025-01-30 12:01:11 +01:00
2025-04-01 19:45:30 +02:00
2025-04-01 19:45:30 +02:00
2025-01-13 17:51:51 +04:00
2025-01-13 17:51:51 +04:00
2025-07-02 17:50:24 +07:00
2025-07-02 17:50:24 +07:00
2025-04-26 10:53:02 +02:00
2025-04-26 10:47:03 +02:00
2025-03-03 11:07:56 +02:00
2025-03-03 11:07:56 +02:00
2025-02-10 21:14:01 +02:00
2025-02-10 21:14:01 +02:00
2025-04-27 22:16:17 -04:00
2025-02-10 22:06:49 +02:00
2025-04-27 22:16:17 -04:00
2025-02-10 22:06:49 +02:00
2025-01-13 11:56:19 +11:00
2025-01-13 11:56:19 +11:00
2025-04-15 14:36:02 -04:00
2025-04-15 14:36:02 -04:00
2025-01-30 11:55:13 +01:00
2025-01-30 11:55:13 +01:00
2025-03-28 13:55:21 +02:00
2025-03-28 13:55:21 +02:00
2025-01-29 11:17:38 +01:00
2025-01-25 20:37:51 +01:00
2025-04-19 20:57:54 +04:00
2025-04-19 20:57:54 +04:00
2025-03-26 17:09:57 +02:00
2025-03-21 09:25:15 +01:00
2025-04-04 13:36:56 +07:00
2025-04-04 13:36:56 +07:00
2025-04-22 21:06:55 +03:00
2025-02-09 13:56:19 +04:00
2025-02-09 13:56:19 +04:00
2025-03-28 13:55:21 +02:00
2025-03-27 08:01:47 +02:00
2025-02-10 15:59:28 +02:00
2025-01-30 12:01:11 +01:00
2025-01-16 23:04:59 +01:00
2025-01-20 09:57:37 +02:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-04-15 14:36:02 -04:00
2025-04-25 15:10:36 +02:00
2025-04-25 15:10:36 +02:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-04-26 10:53:02 +02:00
2025-05-28 16:33:49 +10:00
2025-02-10 22:06:49 +02:00
2025-02-24 12:10:32 +11:00
2025-02-24 12:10:32 +11:00
2025-03-31 11:10:12 +02:00
2025-03-31 22:28:52 +02:00
2025-01-17 23:42:56 +01:00
2025-01-17 23:42:56 +01:00
2025-03-27 08:01:47 +02:00
2025-03-27 08:01:47 +02:00
2025-01-17 15:39:55 +04:00
2025-04-18 12:44:17 -04:00
2025-04-18 12:44:17 -04:00
2025-04-26 10:53:02 +02:00
2025-04-18 12:44:17 -04:00
2025-02-28 09:00:16 +02:00
2025-01-30 12:01:11 +01:00
2025-01-30 11:55:13 +01:00
2025-01-27 16:33:09 +04:00
2025-01-27 16:33:09 +04:00
2025-04-18 12:44:17 -04:00
2025-04-18 12:44:17 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 15:24:12 -04:00
2025-07-23 00:06:52 +02:00
2025-07-23 00:06:52 +02:00
2025-03-03 11:07:56 +02:00
2025-03-03 11:07:56 +02:00
2025-04-26 10:53:02 +02:00
2025-04-13 12:19:56 +02:00
2025-04-26 10:53:02 +02:00
2025-04-26 10:53:02 +02:00
2025-04-26 10:53:02 +02:00
2025-04-26 10:53:02 +02:00
2025-01-30 12:01:11 +01:00
2025-01-30 12:01:11 +01:00
2025-04-18 14:54:48 +04:00
2025-04-18 14:54:48 +04:00