Data compare output does not seem correct
It identifies all rows as different even though they are all the same, with this exception: table 1 has an extra column.
If table 1 has columns A, B, C and table 2 has columns B, C is there a way to tell DataGrip to ignore column A?
请先登录再写评论。
Please can you include a screenshot with your row examples from the compare data dialog window.
We'll have a look
Both tables have a UUID column which is the column we want to use as the key for comparisons.
But, the second table has an ID column (not present in the first table) which is defined as the primary key, so that's what DataGrip appears to be using, and thus finding differences where there are none, or at least none as we define differences for this table.
What you described is pretty much accurate. We do look into differences and highlight the portion with values not present in the compared table. You can exclude or remove a specific column by right-clicking on the header and selecting the action you need