Files
greptimedb/tests/cases/standalone/common/function/system.result
Ning Sun f1b29ece3c feat: process id for session, query context and postgres (#6301)
* feat: process id for session, query context and postgres

Signed-off-by: Ning Sun <sunning@greptime.com>

* feat: add sql functions to retrieve connection/process id

Signed-off-by: Ning Sun <sunning@greptime.com>

---------

Signed-off-by: Ning Sun <sunning@greptime.com>
2025-06-12 16:53:57 +00:00

35 lines
829 B
Plaintext

-- SQLNESS REPLACE branch:\s+.+ branch: BRANCH
-- SQLNESS REPLACE commit:\s+.+ commit: COMMIT
-- SQLNESS REPLACE commit_short:\s+.+ commit_short: COMMIT_SHORT
-- SQLNESS REPLACE clean:\s+.+ clean: CLEAN
-- SQLNESS REPLACE version:\s+.+ version: VERSION
-- SQLNESS REPLACE [\s\-]+
SELECT build();
++|build()|++|branch:BRANCH|commit:COMMIT|commit_short:COMMIT_SHORT|clean:CLEAN|version:VERSION++
-- SQLNESS REPLACE (\d+\.\d+\.\d+) VERSION
-- SQLNESS REPLACE [\s\-]+
SELECT version();
++|version()|++|VERSION|++
-- SQLNESS REPLACE \d+ PID
SELECT pg_backend_pid();
+------------------+
| pg_backend_pid() |
+------------------+
| PID |
+------------------+
-- SQLNESS REPLACE \d+ PID
SELECT connection_id();
+-----------------+
| connection_id() |
+-----------------+
| PID |
+-----------------+