Change structure does not surface errors

[ChrisHSandN]

Describe the bug

If a structure change is made which causes an error, the error is never shown and PHPMyAdmin returns to the structure view as if it has worked.

To Reproduce

Steps to reproduce the behaviour:

CREATE TABLE `1_test` (
  `id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB;

INSERT INTO `1_test` SELECT 'abc';

1. Go to 'Structure'
2. Click on 'Change' next to id
3. Change Length/Values to 1 (e.g. too small to contain 'abc')
4. Click "Save"
5. No error is shown and VARCHAR is still length 10

Expected behaviour

Error should be shown

Screenshots

Server configuration

• Operating system: CentOS
• Web server: Apache/2.4.6
• Database version: mariadb 10.4.20
• PHP version: 7.4.21
• phpMyAdmin version: 5.1.1-1

Client configuration

• Browser: Chrome
• Operating system: Windows 10

Additional context

#17016 sounds similar, but in this case I am not ticking the checkbox "Online Transaction".

Running the query produced by "Preview SQL" manaually shows the expected error:

[williamdes]

Hi @ChrisHSandN
I can confirm that using PerconaDb 5.7
#1265 - Data truncated for column 'id' at row 1 should be displayed