Materialize/test/pgtest/copy-from-null.pt

send
Query {"query": "DROP TABLE IF EXISTS t"}
----

until ignore=NoticeResponse
ReadyForQuery
----
CommandComplete {"tag":"DROP TABLE"}
ReadyForQuery {"status":"I"}

send
Query {"query": "DROP TABLE IF EXISTS t"}
----

until ignore=NoticeResponse
ReadyForQuery
----
CommandComplete {"tag":"DROP TABLE"}
ReadyForQuery {"status":"I"}

send
Query {"query": "CREATE TABLE t (i INT8, t TEXT)"}
----

until
ReadyForQuery
----
CommandComplete {"tag":"CREATE TABLE"}
ReadyForQuery {"status":"I"}


send
Query {"query": "COPY t FROM STDIN WITH (NULL '')"}
CopyData "\t\n"
CopyData "1\t\n"
CopyData "\ttext\n"
CopyDone
----

until
ReadyForQuery
----
CopyIn {"format":"text","column_formats":["text","text"]}
CommandComplete {"tag":"COPY 3"}
ReadyForQuery {"status":"I"}


# Our NULL ordering differs from postgres, so use some tricks to
# make the results identical between mz and postgres.
send
Query {"query": "SELECT * FROM (select case when i is null then 'NULL' else i::text end as i, case when t is null then 'NULL' else t end as t from t) as t ORDER BY i, t"}
----

until ignore=RowDescription
ReadyForQuery
----
DataRow {"fields":["1","NULL"]}
DataRow {"fields":["NULL","NULL"]}
DataRow {"fields":["NULL","text"]}
CommandComplete {"tag":"SELECT 3"}
ReadyForQuery {"status":"I"}


send
Query {"query": "DROP TABLE IF EXISTS t"}
----

until ignore=NoticeResponse
ReadyForQuery
----
CommandComplete {"tag":"DROP TABLE"}
ReadyForQuery {"status":"I"}