Bug #114290 ENUM and operator IN bug

• Submitted: 9 Mar 2024 23:51
• Modified: 10 Mar 2024 8:24
• Reporter: Roman Roman
• Status: Not a Bug
• Category: MySQL Server: General
• Severity: S2 (Serious)
• Version: 8.0.36
• OS: Any
• CPU Architecture: Any

[9 Mar 2024 23:51] Roman Roman

Description:
CREATE TABLE test_test (
target ENUM('part_book','full_book') CHARACTER SET latin1 COLLATE latin1_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;

INSERT INTO test_test (target) VALUES ('part_book');

How to repeat:
This query return empty result:
SELECT * FROM test_test WHERE target IN ('part_book, full_book')

This query return record as expected:
SELECT * FROM test_test WHERE target = 'part_book' OR target = 'full_book'

[10 Mar 2024 8:24] MySQL Verification Team

Try:
 SELECT * FROM test_test WHERE target IN ('part_book', 'full_book');