MySQL Forums
Forum List  »  General

Re: "Incorrect prefix key" error during inplace 5.7 to 8.0 upgrade
Posted by: Christos Chatzaras
Date: January 08, 2022 03:36AM

I found this query which shows spatial data types and then I can manually check for the indexes:


select col.table_schema as database_name,
col.table_name,
col.ordinal_position as column_id,
col.column_name,
col.data_type,
col.is_nullable
from information_schema.columns col
join information_schema.tables tab
on col.table_schema = tab.table_schema
and col.table_name = tab.table_name
and table_type = 'BASE TABLE'
where col.data_type in ('geometry', 'point', 'linestring', 'polygon',
'multipoint', 'multilinestring', 'multipolygon',
'geometrycollection')
and col.table_schema not in ('information_schema', 'sys',
'performance_schema', 'mysql')
-- and table_schema = 'database_name' -- put your database name here
order by col.table_schema,
col.table_name;

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.