gpcontrib/quicklz/sql/compression_quicklz.sql

-- Tests for quicklz compression.

-- Check that callbacks are registered
SELECT * FROM pg_compression WHERE compname = 'quicklz';

-- Test for appendonly row oriented
CREATE TABLE quicklztest_row (id int4, t text) WITH (appendonly=true, compresstype=quicklz, orientation=row);

-- Check that the reloptions on the table shows compression type
-- This is order sensitive to base on the order that the options were declared in the DDL of the table.
SELECT reloptions[1] FROM pg_class WHERE relname = 'quicklztest_row';

INSERT INTO quicklztest_row SELECT g, 'foo' || g FROM generate_series(1, 100) g;
INSERT INTO quicklztest_row SELECT g, 'bar' || g FROM generate_series(1, 100) g;

-- Check contents, at the beginning of the table and at the end.
SELECT * FROM quicklztest_row ORDER BY id LIMIT 4 ;--order 1, none
SELECT * FROM quicklztest_row ORDER BY id DESC LIMIT 4 ;--order 1, none

-- Check that we actually compressed data
SELECT get_ao_compression_ratio('quicklztest_row') >= 1.8 as get_ao_compression_ratio;

-- Test for appendonly column oriented
CREATE TABLE quicklztest_column (id int4, t text) WITH (appendonly=true, compresstype=quicklz, orientation=column);

INSERT INTO quicklztest_column SELECT g, 'foo' || g FROM generate_series(1, 100) g;
INSERT INTO quicklztest_column SELECT g, 'bar' || g FROM generate_series(1, 100) g;

-- Check contents, at the beginning of the table and at the end.
SELECT * FROM quicklztest_column ORDER BY id LIMIT 4 ;--order 1, none
SELECT * FROM quicklztest_column ORDER BY id DESC LIMIT 4 ;--order 1, none

-- Check that we actually compressed data
SELECT get_ao_compression_ratio('quicklztest_column') >= 1.2 as get_ao_compression_ratio;

-- Test the bounds of compresslevel. QuickLZ compresslevel 1 is the only one that should work.
CREATE TABLE quicklztest_invalid (id int4) WITH (appendonly=true, compresstype=quicklz, compresslevel=-1);
CREATE TABLE quicklztest_invalid (id int4) WITH (appendonly=true, compresstype=quicklz, compresslevel=0);
CREATE TABLE quicklztest_invalid (id int4) WITH (appendonly=true, compresstype=quicklz, compresslevel=3);

-- CREATE TABLE for heap table with compresstype=quicklz should fail
CREATE TABLE quicklztest_heap (id int4, t text) WITH (compresstype=quicklz);