Bug #114290 ENUM and operator IN bug
Submitted: 9 Mar 23:51 Modified: 10 Mar 8:24
Reporter: Roman Roman Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: General Severity:S2 (Serious)
Version:8.0.36 OS:Any
Assigned to: CPU Architecture:Any

[9 Mar 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 8:24] MySQL Verification Team
Try:
 SELECT * FROM test_test WHERE target IN ('part_book', 'full_book');