Horton

copy-test-results.txt

text/plain

Download
Filename: copy-test-results.txt
Type: text/plain
Part: 2
Message: Re: Fixing backslash dot for COPY FROM...CSV 
Case A
+----------+----------------+----------------+------------------+------------------+
|  method  | patched-server+| patched-server+| unpatched-server+| unpatched-server+|
|          |  patched-psql  | unpatched-psql |   patched-psql   |  unpatched-psql  |
+----------+----------------+----------------+------------------+------------------+
| \copy    | OK             | Failed         | OK               | Failed           |
| copy     | OK             | OK             | OK               | OK               |
| embedded | Failed         | Failed         | Failed           | Failed           |
| pstdin   | OK             | Failed         | OK               | Failed           |
+----------+----------------+----------------+------------------+------------------+

Case B
+----------+----------------+----------------+------------------+------------------+
|  method  | patched-server+| patched-server+| unpatched-server+| unpatched-server+|
|          |  patched-psql  | unpatched-psql |   patched-psql   |  unpatched-psql  |
+----------+----------------+----------------+------------------+------------------+
| \copy    | OK             | Data mismatch  | Data mismatch    | Data mismatch    |
| copy     | OK             | OK             | Data mismatch    | Data mismatch    |
| embedded | Failed         | Failed         | Failed           | Failed           |
| pstdin   | OK             | Data mismatch  | Data mismatch    | Data mismatch    |
+----------+----------------+----------------+------------------+------------------+

Case C
+----------+----------------+----------------+------------------+------------------+
|  method  | patched-server+| patched-server+| unpatched-server+| unpatched-server+|
|          |  patched-psql  | unpatched-psql |   patched-psql   |  unpatched-psql  |
+----------+----------------+----------------+------------------+------------------+
| \copy    | OK             | OK             | OK               | OK               |
| copy     | OK             | OK             | OK               | OK               |
| embedded | OK             | Data mismatch  | OK               | OK               |
| pstdin   | OK             | OK             | OK               | OK               |
+----------+----------------+----------------+------------------+------------------+

Case D
+----------+------------------+------------------+----------------+----------------+
|  method  | unpatched-server+| unpatched-server+| patched-server+| patched-server+|
|          |  unpatched-psql  |   patched-psql   |  patched-psql  | unpatched-psql |
+----------+------------------+------------------+----------------+----------------+
| \copy    | OK               | OK               | OK             | OK             |
| copy     | OK               | OK               | OK             | OK             |
| embedded | OK               | OK               | OK             | OK             |
| pstdin   | OK               | OK               | OK             | OK             |
+----------+------------------+------------------+----------------+----------------+

Case E
+----------+----------------+----------------+------------------+------------------+
|  method  | patched-server+| patched-server+| unpatched-server+| unpatched-server+|
|          |  patched-psql  | unpatched-psql |   patched-psql   |  unpatched-psql  |
+----------+----------------+----------------+------------------+------------------+
| \copy    | OK             | OK             | OK               | OK               |
| copy     | OK             | OK             | OK               | OK               |
| embedded | OK             | OK             | OK               | OK               |
| pstdin   | OK             | OK             | OK               | OK               |
+----------+----------------+----------------+------------------+------------------+