mariadb/mysql-test/suite
Dave Gosselin f4833ceb41 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-15 16:29:02 -04:00
..
archive Merge remote-tracking branch 'github/bb-11.4-release' into bb-11.8-serg 2025-04-27 19:40:00 +02:00
atomic Fix the test: changing charset should be dome when we can not skip the test. 2025-05-09 07:36:15 +02:00
binlog Merge remote-tracking branch 'github/bb-11.4-release' into bb-11.8-serg 2025-04-27 19:40:00 +02:00
binlog_encryption Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
client MDEV-14978 fix client.client-env-variable test 2024-10-19 16:53:16 +02:00
compat Merge remote-tracking branch 'github/bb-11.4-release' into bb-11.8-serg 2025-04-27 19:40:00 +02:00
csv MDEV-36050 DATA/INDEX DIRECTORY handling is inconsistent 2025-04-18 09:41:23 +02:00
encryption Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
engines Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
events Merge 11.4 into 11.7 2024-12-02 17:51:17 +02:00
federated Merge remote-tracking branch 'github/bb-11.4-release' into bb-11.8-serg 2025-04-27 19:40:00 +02:00
funcs_1 Merge branch '11.4' into 11.8 2025-06-18 07:43:24 +02:00
funcs_2 Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
galera Merge branch '11.4' into 11.8 2025-06-18 07:43:24 +02:00
galera_3nodes Merge branch '11.4' into 11.8 2025-06-18 07:43:24 +02:00
galera_3nodes_sr Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
galera_sr Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
gcol MDEV-36389 Incorrect query results for an indexed text column 2025-07-15 16:29:02 -04:00
handler Merge 11.4 into 11.7 2025-01-09 09:41:38 +02:00
heap Merge branch '11.4' into 11.7 2025-02-06 16:46:36 +01:00
innodb MDEV-35049: Improve test coverage 2025-06-26 11:45:33 +03:00
innodb_fts Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00
innodb_gis Merge branch '11.4' into 11.8 2025-06-18 07:43:24 +02:00
innodb_i_s
innodb_zip fix incorrect merge 15700f54c2 2025-04-18 09:41:24 +02:00
jp
json Merge remote-tracking branch 'github/bb-11.4-release' into bb-11.8-serg 2025-04-27 19:40:00 +02:00
large_tests
maria Merge branch '11.4' into 11.8 2025-06-18 07:43:24 +02:00
mariabackup Merge remote-tracking branch 'github/bb-11.4-release' into bb-11.8-serg 2025-04-27 19:40:00 +02:00
merge Merge remote-tracking branch 'github/bb-11.4-release' into bb-11.8-serg 2025-04-27 19:40:00 +02:00
mtr/t Remove dates from all rdiff files 2025-01-05 16:40:11 +02:00
mtr2
multi_source fix for post-test check of multi_source.master_info_file 2025-04-18 09:41:23 +02:00
optimizer_unfixed_bugs
parts MDEV-36050 DATA/INDEX DIRECTORY handling is inconsistent 2025-04-18 09:41:23 +02:00
perfschema Merge branch '11.4' into 11.8 2025-06-18 07:43:24 +02:00
perfschema_stress
period cleanup: select ... into tests 2025-02-11 20:31:25 +01:00
plugins MDEV-34933 remove MSAN exclusion on test plugins.rpl_auth 2025-06-16 12:00:45 +10:00
roles Merge branch '11.7' into 11.8 2025-02-11 20:29:43 +01:00
rpl Merge branch '11.4' into 11.8 2025-05-21 15:57:16 +02:00
s3 Merge branch '11.4' into 11.8 2025-06-18 07:43:24 +02:00
sql_sequence Merge branch '11.4' into 11.8 2025-06-18 07:43:24 +02:00
storage_engine
stress
sys_vars Merge branch '11.4' into 11.8 2025-06-18 07:43:24 +02:00
sysschema MDEV-31736: format_bytes implementation 2024-11-26 13:10:01 +04:00
unit
vcol Merge branch '11.4' into 11.8 2025-06-18 07:43:24 +02:00
versioning Merge branch '11.4' into 11.8 2025-06-18 07:43:24 +02:00
wsrep Merge 11.4 into 11.8 2025-04-02 14:07:01 +03:00