mirror of
https://github.com/neondatabase/neon.git
synced 2025-12-27 16:12:56 +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
33 lines
1.1 KiB
SQL
33 lines
1.1 KiB
SQL
-- Create a test ULID value
|
|
CREATE TEMP TABLE test_ulids AS
|
|
SELECT '01GV5PA9EQG7D82Q3Y4PKBZSYV'::ulid as test_ulid;
|
|
|
|
-- Test conversion to text
|
|
SELECT 'ulid to text conversion' as test_name,
|
|
test_ulid::text = '01GV5PA9EQG7D82Q3Y4PKBZSYV' as result
|
|
FROM test_ulids;
|
|
|
|
-- Test conversion to UUID
|
|
SELECT 'ulid to UUID conversion' as test_name,
|
|
test_ulid::uuid::text = '0186cb65-25d7-81da-815c-7e25a6bfe7db' as result
|
|
FROM test_ulids;
|
|
|
|
-- Test conversion to bytea
|
|
SELECT 'ulid to bytea conversion' as test_name,
|
|
length(test_ulid::bytea) = 16 as result
|
|
FROM test_ulids;
|
|
|
|
-- Test conversion to timestamp
|
|
SELECT 'ulid to timestamp conversion' as test_name,
|
|
to_char(test_ulid::timestamp, 'YYYY-MM-DD HH24:MI:SS.MS') = '2023-03-10 04:00:49.111' as result
|
|
FROM test_ulids;
|
|
|
|
-- Test conversion from UUID
|
|
SELECT 'UUID to ulid conversion' as test_name,
|
|
'0186cb65-25d7-81da-815c-7e25a6bfe7db'::uuid::ulid::text = '01GV5PA9EQG7D82Q3Y4PKBZSYV' as result;
|
|
|
|
-- Test conversion from timestamp
|
|
SELECT 'timestamp to ulid conversion' as test_name,
|
|
'2023-03-10 12:00:49.111'::timestamp::ulid::text = '01GV5PA9EQ0000000000000000' as result;
|
|
|