Add list of InnoDB tables without a PK/UNIQUE as part of schema report

Registered by markus_albe on 2013-11-13

When using RBR or MIXED replication, InnoDB tables without a PK/UNIQUE key will suffer from this bug: http://bugs.mysql.com/bug.php?id=53375 having information about such tables readily available should help us shorten time to diagnose this one. To get the information you can run a query like the one in Giuseppe's post (see Spec URL):

select
    t.table_schema,t.table_name,engine
from
    information_schema.tables t
    inner join information_schema .columns c
        on t.table_schema=c.table_schema and t.table_name=c.table_name
group by
    t.table_schema,t.table_name
having
    sum(if(column_key in ('PRI','UNI'), 1,0)) =0;

The query is expensive, so maybe a switch like --show-tables-without-PK might be a good idea.

Blueprint information

Status:
Not started
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Needs approval
Assignee:
None
Definition:
New
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.