Enum with comma produces incorrect search dropdown

[ChrisHSandN]

Describe the bug

When a comma is used within the value of an ENUM field the search dropdown incorrectly splits this.

To Reproduce

Steps to reproduce the behavior:

CREATE TABLE `1_test` (
 `foo` enum('foo,bar') COLLATE utf8_unicode_ci NOT NULL,
 PRIMARY KEY (`foo`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

From search tab:
Dropdown next to field foo shows separate values for ‘foo’, ‘bar’ (incorrect)

From structure tab
Change field foo > Edit ENUM/SET values > shows ‘foo,bar’ as single value (correct)

Expected behavior

However the structure tab is splitting the ENUM needs to be applied to the search tab dropdown, rather than just exploding around comma as it currently seems to do.

Screenshots

Server configuration

• Database version: 10.2.15-MariaDB
• phpMyAdmin version: 4.8.2

[lem9]

The Insert page is correct; it uses Util::parseEnumSetValues() which correctly parses commas inside a quoted string. The Search page is buggy; it uses templates/table/search/input_box.twig which splits on the comma.

[williamdes]

Affects master and QA_4_8