Now if we have a target table with schema:
and validate a query like:
It would throw exception because the target table fields count is 3 but the query is 1,
actually the table t1 columns b and c have strategy that we can not insert into, so we better
ignore these columns when do validation.
The following query in SQLSERVER-2017 passed: