#3069 (ok 3.3.7) php error on view structure
Notice in ./libraries/string.lib.php#147
Undefined offset: 289
Backtrace
./libraries/sqlparser.lib.php#723: PMA_STR_binarySearchInArr(
string _UTF8,
array,
integer 291,
)
./tbl_structure.php#141: PMA_SQP_parse(string CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `customer_list` AS select `cu`.`customer_id` AS `ID`,concat(`cu`.`first_name`,_utf8' ',`cu`.`last_name`) AS `name`,`a`.`address` AS `address`,`a`.`postal_code` AS `zip code`,`a`.`phone` AS `phone`,`city`.`city` AS `city`,`country`.`country` AS `country`,if(`cu`.`active`,_utf8'active',_utf8'') AS `notes`,`cu`.`store_id` AS `SID` from (((`customer` `cu` join `address` `a` on((`cu`.`address_id` = `a`.`address_id`))) join `city` on((`a`.`city_id` = `city`.`city_id`))) join `country` on((`city`.`country_id` = `country`.`country_id`))))
Reproducible on: http://demo.phpmyadmin.net/trunk-config/tbl_structure.php?db=sakila&table=customer_list
Discussion
Fixed in Git.