1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
# fmt: off
from conftest import ShellTest
def test_get_env(shell):
test = (
ShellTest(shell)
.statement('.null NULL')
.statement("SET default_null_order=getenv('DEFAULT_NULL_ORDER');")
.statement("SELECT * FROM (VALUES (42), (NULL)) ORDER BY 1 LIMIT 1;")
)
test.environment['DEFAULT_NULL_ORDER'] = 'NULLS_FIRST'
result = test.run()
result.check_stdout('NULL')
test.environment['DEFAULT_NULL_ORDER'] = 'NULLS_LAST'
result = test.run()
result.check_stdout('42')
def test_get_env_permissions(shell):
test = (
ShellTest(shell)
.statement('SET enable_external_access=false')
.statement("SELECT getenv('DEFAULT_NULL_ORDER');")
)
test.environment['DEFAULT_NULL_ORDER'] = 'NULLS_FIRST'
result = test.run()
result.check_stderr('disabled through configuration')
# fmt: on
|
