Materialize/test/pgtest/binary.pt

# Test binary encodings

# Intervals

send
Parse {"query": "SELECT INTERVAL '2147483647 days 2147483647 hours 59 minutes 59.999999 seconds'"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["[107, 73, 209, 255, 255, 255, 255, 255, 127, 255, 255, 255, 0, 0, 0, 0]"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT INTERVAL '2147483647 months 2147483647 days 2147483647 hours 59 minutes 59.999999 seconds'"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["[107, 73, 209, 255, 255, 255, 255, 255, 127, 255, 255, 255, 127, 255, 255, 255]"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT INTERVAL '-2147483648 days -48 hrs';"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["[255, 255, 255, 215, 196, 81, 64, 0, 128, 0, 0, 0, 0, 0, 0, 0]"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT INTERVAL '-2147483648 days -2147483648 hours -59 minutes -59.999999 seconds'"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["[148, 182, 45, 255, 41, 108, 92, 1, 128, 0, 0, 0, 0, 0, 0, 0]"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT INTERVAL '-2147483648 months -2147483648 days -2147483648 hours -59 minutes -59.999999 seconds'"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["[148, 182, 45, 255, 41, 108, 92, 1, 128, 0, 0, 0, 128, 0, 0, 0]"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT INTERVAL '-2147483647 days -2147483647 hours -59 minutes -59.999999 seconds'"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["[148, 182, 46, 0, 0, 0, 0, 1, 128, 0, 0, 1, 0, 0, 0, 0]"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

# Integers

send
Parse {"query": "SELECT 42::int2"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["\u0000*"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT 42::uint2"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["\u0000*"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT -32768::int2"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["[128, 0]"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT 32768::uint2"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["[128, 0]"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT 42::int4"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["\u0000\u0000\u0000*"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT 42::uint4"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["\u0000\u0000\u0000*"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT -2147483648::int4"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["[128, 0, 0, 0]"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT 2147483648::uint4"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["[128, 0, 0, 0]"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT 42::int8"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["\u0000\u0000\u0000\u0000\u0000\u0000\u0000*"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT 42::uint8"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["\u0000\u0000\u0000\u0000\u0000\u0000\u0000*"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT -9223372036854775808::int8"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["[128, 0, 0, 0, 0, 0, 0, 0]"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}

send
Parse {"query": "SELECT 9223372036854775808::uint8"}
Bind {"result_formats": [1]}
Execute
Sync
----

until
ReadyForQuery
----
ParseComplete
BindComplete
DataRow {"fields":["[128, 0, 0, 0, 0, 0, 0, 0]"]}
CommandComplete {"tag":"SELECT 1"}
ReadyForQuery {"status":"I"}