[Phpmyadmin-devel] MySQL 5.0.13 'view' becomes 'VIEW'

Marc Delisle Marc.Delisle at cegepsherbrooke.qc.ca
Tue Oct 4 13:36:42 CEST 2005


Sebastian Mendel a écrit :
> Marc Delisle schrieb:
> 
> 
>>Sebastian Mendel a écrit :
>>
>>
>>>SHOW FULL TABLES now returns 'VIEW' instead of 'view'
>>>
>>>should phpMyAdmin recognice both? or cause 'view' was only used in BETA
>>>drop support for 'view' and now only support 'VIEW' (beside this that at
>>>the moment PMA only supports 'view' and reports an error on MySQL 5.0.13)
>>
>>It should recognize both, IMO. Are you working on this?
> 
> 
> no, i just stumbled over, as upgrading my MySQL
> 
> 

Initial testing indicates that changing line 40 in 
tbl_properties_table_info.php to

if (PMA_MYSQL_INT_VERSION >= 50000 && !isset($showtable['Type']) && 
isset($showtable['Comment']) && strtolower($showtable['Comment']) == 
'view') {

might be enough, please confirm.

Marc




More information about the Developers mailing list