GitHub user RuppMartin001 added a comment to the discussion: [Bug] Table
Compare not populating fields meant for error handling
I use table compare. One important thing is that the table compare uses the
main output stream and the error output stream.
You can find information about the details of the differences in the error
output stream.
But unfortunately there are only the information about:
- Values of the primary key columns with "and" between them to identify the
row. This string can be used as "'Where" condition in SQL statements.
- If there is a row with the same primary key values in the reference and
compare table and if column values are different:
- Value of a column in the reference table.
- Value of a column in the compare table.
But there is no information if the record is missing in the reference or
compare table.
And if the row is found in both tables and there is a difference: The name of
the column with different values.
These information would be so helpful and I don't understand why these
information is not in the output stream.
GitHub link:
https://github.com/apache/hop/discussions/5505#discussioncomment-14848541
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
