CREATE SERVER binary_nullable_json_loopback FOREIGN DATA WRAPPER clickhouse_fdw
	OPTIONS(dbname 'binary_nullable_json_test', driver 'binary');
CREATE USER MAPPING FOR CURRENT_USER SERVER binary_nullable_json_loopback;
CREATE SERVER binary_nullable_json_admin FOREIGN DATA WRAPPER clickhouse_fdw;
CREATE USER MAPPING FOR CURRENT_USER SERVER binary_nullable_json_admin;
CALL clickhouse_perform('binary_nullable_json_admin', 'DROP DATABASE IF EXISTS binary_nullable_json_test');
CALL clickhouse_perform('binary_nullable_json_admin', 'CREATE DATABASE binary_nullable_json_test');
CALL clickhouse_perform('binary_nullable_json_admin', 'CREATE TABLE binary_nullable_json_test.json_vals (
	c1 Int32, c2 Nullable(JSON)
) ENGINE = MergeTree ORDER BY (c1);');
ERROR:  pg_clickhouse: Code: 43. DB::Exception: Nested type Object('json') cannot be inside Nullable type. (ILLEGAL_TYPE_OF_ARGUMENT)
DETAIL:  Remote Query: CREATE TABLE binary_nullable_json_test.json_vals (
	c1 Int32, c2 Nullable(JSON)
) ENGINE = MergeTree ORDER BY (c1);
CONTEXT:  HTTP status code: 500
CREATE FOREIGN TABLE json_vals (c1 int, c2 jsonb)
	SERVER binary_nullable_json_loopback OPTIONS (table_name 'json_vals');
INSERT INTO json_vals VALUES (1, '{"a": 1}'), (2, NULL), (3, '{"b": 2}');
ERROR:  pg_clickhouse: could not prepare insert - DB::Exception: Table binary_nullable_json_test.json_vals does not exist
SELECT * FROM json_vals ORDER BY c1;
ERROR:  pg_clickhouse: DB::Exception: Table binary_nullable_json_test.json_vals does not exist
DETAIL:  Remote Query: SELECT c1, c2 FROM binary_nullable_json_test.json_vals ORDER BY c1 ASC NULLS LAST
DROP FOREIGN TABLE json_vals;
DROP USER MAPPING FOR CURRENT_USER SERVER binary_nullable_json_loopback;
CALL clickhouse_perform('binary_nullable_json_admin', 'DROP DATABASE binary_nullable_json_test');
DROP SERVER binary_nullable_json_loopback CASCADE;