mirror of
https://github.com/neondatabase/neon.git
synced 2026-01-04 12:02:55 +00:00
cf9d817a21
## Problem Some extensions do not contain tests, which can be easily run on top of docker-compose or staging. ## Summary of changes Added the pg_regress based tests for `pg_tiktoken`, `pgx_ulid`, `pg_rag` Now they will be run on top of docker-compose, but I intend to adopt them to be run on top staging in the next PRs
61 lines
2.4 KiB
Plaintext
61 lines
2.4 KiB
Plaintext
-- Test basic ULID generation
|
|
-- Test gen_ulid() function
|
|
SELECT 'gen_ulid() returns a non-null value' as test_name,
|
|
gen_ulid() IS NOT NULL as result;
|
|
test_name | result
|
|
-------------------------------------+--------
|
|
gen_ulid() returns a non-null value | t
|
|
(1 row)
|
|
|
|
-- Test that multiple calls to gen_ulid() return different values
|
|
SELECT 'gen_ulid() returns unique values' as test_name,
|
|
gen_ulid() != gen_ulid() as result;
|
|
test_name | result
|
|
----------------------------------+--------
|
|
gen_ulid() returns unique values | t
|
|
(1 row)
|
|
|
|
-- Test that gen_ulid() returns a value with the correct format
|
|
SELECT 'gen_ulid() returns correctly formatted value' as test_name,
|
|
length(gen_ulid()::text) = 26 as result;
|
|
test_name | result
|
|
----------------------------------------------+--------
|
|
gen_ulid() returns correctly formatted value | t
|
|
(1 row)
|
|
|
|
-- Test monotonic ULID generation
|
|
SELECT 'gen_monotonic_ulid() returns a non-null value' as test_name,
|
|
gen_monotonic_ulid() IS NOT NULL as result;
|
|
test_name | result
|
|
-----------------------------------------------+--------
|
|
gen_monotonic_ulid() returns a non-null value | t
|
|
(1 row)
|
|
|
|
-- Test that multiple calls to gen_monotonic_ulid() return different values
|
|
SELECT 'gen_monotonic_ulid() returns unique values' as test_name,
|
|
gen_monotonic_ulid() != gen_monotonic_ulid() as result;
|
|
test_name | result
|
|
--------------------------------------------+--------
|
|
gen_monotonic_ulid() returns unique values | t
|
|
(1 row)
|
|
|
|
-- Test that gen_monotonic_ulid() returns a value with the correct format
|
|
SELECT 'gen_monotonic_ulid() returns correctly formatted value' as test_name,
|
|
length(gen_monotonic_ulid()::text) = 26 as result;
|
|
test_name | result
|
|
--------------------------------------------------------+--------
|
|
gen_monotonic_ulid() returns correctly formatted value | t
|
|
(1 row)
|
|
|
|
-- Test that monotonic ULIDs are ordered correctly
|
|
SELECT 'gen_monotonic_ulid() returns ordered values' as test_name,
|
|
u1 < u2 as result
|
|
FROM (
|
|
SELECT gen_monotonic_ulid() as u1, gen_monotonic_ulid() as u2
|
|
) subq;
|
|
test_name | result
|
|
---------------------------------------------+--------
|
|
gen_monotonic_ulid() returns ordered values | t
|
|
(1 row)
|
|
|