Toad for Data Analysts 3.0.1. MySQL DB. Cannot compare two query results. TDA is asking for Prima (4289860)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Toad for Data Analysts 3.0.1. MySQL DB. Cannot compare two query results. TDA is asking for Prima
Description

Toad for Data Analysts 3.0.1. MySQL DB. Cannot compare two query results. Asking for Primary Key. Why is this? Is this a normal behavior?
ERROR:
Invalid primary key specified.
These columns don’t currently have unique values.
Resolution

Per the developers, the way that the compare engine works is that it has to be unique. This is a normal behavior or it is working as designed.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title