mirror of
https://github.com/dimitri/pgloader.git
synced 2025-08-08 07:16:58 +02:00
150d288d7a
Next parallelism improvements will allow pgloader to use more than one
COPY thread to load data, with the impact of changing the order of rows
in the database.
Rather than doing a copy out and `diff` of the data just loaded, load
the reference data and do the diff in SQL:
select * from loaded.data
except
select * from expected.data
If such a query returns any row, we know we didn't load what was
expected and the regression test is failing.
This regression testing facility should also allow us to finally add
support for multiple-table regression tests (sqlite, mysql, etc).
8 lines
239 B
Plaintext
8 lines
239 B
Plaintext
0 2006-11-11 nov. the 11th should go
|
|
1 2006-10-12 12th of oct. should go
|
|
4 2006-05-12 month should be may, ok
|
|
6 \N some null date to play with
|
|
7 \N and a ragged line
|
|
8 2014-01-23 and a line with extra columns
|
|
9 2014-01-22 and another line
|