postgres_vectorization_test/input/create.source at master · citusdata/postgres_vectorization_test · GitHub

49 lines (36 loc) · 1.53 KB

-- Test the CREATE statements related to cstore_fdw.

-- Install cstore_fdw

CREATE EXTENSION cstore_fdw;

CREATE SERVER cstore_server FOREIGN DATA WRAPPER cstore_fdw;

-- Validator tests

CREATE FOREIGN TABLE test_validator_invalid_option ()

SERVER cstore_server

OPTIONS(filename 'data.cstore', bad_option_name '1'); -- ERROR

CREATE FOREIGN TABLE test_validator_invalid_stripe_row_count ()

SERVER cstore_server

OPTIONS(filename 'data.cstore', stripe_row_count '0'); -- ERROR

CREATE FOREIGN TABLE test_validator_invalid_block_row_count ()

SERVER cstore_server

OPTIONS(filename 'data.cstore', block_row_count '0'); -- ERROR

CREATE FOREIGN TABLE test_validator_invalid_compression_type ()

SERVER cstore_server

OPTIONS(filename 'data.cstore', compression 'invalid_compression'); -- ERROR

-- Invalid file path test

CREATE FOREIGN TABLE test_invalid_file_path ()

SERVER cstore_server

OPTIONS(filename 'bad_directory_path/bad_file_path'); --ERROR

-- Create uncompressed table

CREATE FOREIGN TABLE contestant (handle TEXT, birthdate DATE, rating INT,

percentile FLOAT, country CHAR(3), achievements TEXT[])

SERVER cstore_server

OPTIONS(filename '@abs_srcdir@/data/contestant.cstore');

-- Create compressed table with automatically determined file path

CREATE FOREIGN TABLE contestant_compressed (handle TEXT, birthdate DATE, rating INT,

percentile FLOAT, country CHAR(3), achievements TEXT[])

SERVER cstore_server

OPTIONS(compression 'pglz');

-- Test that querying an empty table works

ANALYZE contestant;

SELECT count(*) FROM contestant;

Expand file tree