File: nosparse.sql

package info (click to toggle)
postgresql-hll 2.18-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 58,720 kB
  • sloc: ansic: 2,805; sql: 2,160; cpp: 201; makefile: 22; sh: 1
file content (17 lines) | stat: -rw-r--r-- 547 bytes parent folder | download | duplicates (5)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
-- ----------------------------------------------------------------
-- Regression tests for explicit threshold control.
-- ----------------------------------------------------------------

SELECT hll_set_output_version(1);

-- Should display sparseon = 1
SELECT hll_print(hll_empty(12,5,0,1));

-- Should display sparseon = 0
SELECT hll_print(hll_empty(12,5,0,0));

-- Should become sparse
SELECT hll_add(hll_empty(12,5,0,1), hll_hash_integer(1,0));

-- Should go straight to compressed
SELECT hll_add(hll_empty(12,5,0,0), hll_hash_integer(1,0));