/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/modules/test_saslprep/expected/test_saslprep.out
152 строки
5 KB
Michael Paquier
Make implementation of SASLprep compliant for ASCII characters
24 мар 2026, 02:29
24 мар 2026, 02:29
3d10ece
Код
Авторство
О чём код?
-- Tests for SASLprep CREATE EXTENSION test_saslprep; -- Incomplete UTF-8 sequence. SELECT test_saslprep('\xef'); test_saslprep ----------------- (,INVALID_UTF8) (1 row) -- Range of ASCII characters. SELECT CASE WHEN a = 0 THEN '<NUL>' WHEN a < 32 THEN '<CTL_' || a::text || '>' WHEN a = 127 THEN '<DEL>' ELSE chr(a) END AS dat, set_byte('\x00'::bytea, 0, a) AS byt, test_saslprep(set_byte('\x00'::bytea, 0, a)) AS saslprep FROM generate_series(0,127) AS a; dat | byt | saslprep ----------+------+------------------- <NUL> | \x00 | (,PROHIBITED) <CTL_1> | \x01 | (,PROHIBITED) <CTL_2> | \x02 | (,PROHIBITED) <CTL_3> | \x03 | (,PROHIBITED) <CTL_4> | \x04 | (,PROHIBITED) <CTL_5> | \x05 | (,PROHIBITED) <CTL_6> | \x06 | (,PROHIBITED) <CTL_7> | \x07 | (,PROHIBITED) <CTL_8> | \x08 | (,PROHIBITED) <CTL_9> | \x09 | (,PROHIBITED) <CTL_10> | \x0a | (,PROHIBITED) <CTL_11> | \x0b | (,PROHIBITED) <CTL_12> | \x0c | (,PROHIBITED) <CTL_13> | \x0d | (,PROHIBITED) <CTL_14> | \x0e | (,PROHIBITED) <CTL_15> | \x0f | (,PROHIBITED) <CTL_16> | \x10 | (,PROHIBITED) <CTL_17> | \x11 | (,PROHIBITED) <CTL_18> | \x12 | (,PROHIBITED) <CTL_19> | \x13 | (,PROHIBITED) <CTL_20> | \x14 | (,PROHIBITED) <CTL_21> | \x15 | (,PROHIBITED) <CTL_22> | \x16 | (,PROHIBITED) <CTL_23> | \x17 | (,PROHIBITED) <CTL_24> | \x18 | (,PROHIBITED) <CTL_25> | \x19 | (,PROHIBITED) <CTL_26> | \x1a | (,PROHIBITED) <CTL_27> | \x1b | (,PROHIBITED) <CTL_28> | \x1c | (,PROHIBITED) <CTL_29> | \x1d | (,PROHIBITED) <CTL_30> | \x1e | (,PROHIBITED) <CTL_31> | \x1f | (,PROHIBITED) | \x20 | ("\\x20",SUCCESS) ! | \x21 | ("\\x21",SUCCESS) " | \x22 | ("\\x22",SUCCESS) # | \x23 | ("\\x23",SUCCESS) $ | \x24 | ("\\x24",SUCCESS) % | \x25 | ("\\x25",SUCCESS) & | \x26 | ("\\x26",SUCCESS) ' | \x27 | ("\\x27",SUCCESS) ( | \x28 | ("\\x28",SUCCESS) ) | \x29 | ("\\x29",SUCCESS) * | \x2a | ("\\x2a",SUCCESS) + | \x2b | ("\\x2b",SUCCESS) , | \x2c | ("\\x2c",SUCCESS) - | \x2d | ("\\x2d",SUCCESS) . | \x2e | ("\\x2e",SUCCESS) / | \x2f | ("\\x2f",SUCCESS) 0 | \x30 | ("\\x30",SUCCESS) 1 | \x31 | ("\\x31",SUCCESS) 2 | \x32 | ("\\x32",SUCCESS) 3 | \x33 | ("\\x33",SUCCESS) 4 | \x34 | ("\\x34",SUCCESS) 5 | \x35 | ("\\x35",SUCCESS) 6 | \x36 | ("\\x36",SUCCESS) 7 | \x37 | ("\\x37",SUCCESS) 8 | \x38 | ("\\x38",SUCCESS) 9 | \x39 | ("\\x39",SUCCESS) : | \x3a | ("\\x3a",SUCCESS) ; | \x3b | ("\\x3b",SUCCESS) < | \x3c | ("\\x3c",SUCCESS) = | \x3d | ("\\x3d",SUCCESS) > | \x3e | ("\\x3e",SUCCESS) ? | \x3f | ("\\x3f",SUCCESS) @ | \x40 | ("\\x40",SUCCESS) A | \x41 | ("\\x41",SUCCESS) B | \x42 | ("\\x42",SUCCESS) C | \x43 | ("\\x43",SUCCESS) D | \x44 | ("\\x44",SUCCESS) E | \x45 | ("\\x45",SUCCESS) F | \x46 | ("\\x46",SUCCESS) G | \x47 | ("\\x47",SUCCESS) H | \x48 | ("\\x48",SUCCESS) I | \x49 | ("\\x49",SUCCESS) J | \x4a | ("\\x4a",SUCCESS) K | \x4b | ("\\x4b",SUCCESS) L | \x4c | ("\\x4c",SUCCESS) M | \x4d | ("\\x4d",SUCCESS) N | \x4e | ("\\x4e",SUCCESS) O | \x4f | ("\\x4f",SUCCESS) P | \x50 | ("\\x50",SUCCESS) Q | \x51 | ("\\x51",SUCCESS) R | \x52 | ("\\x52",SUCCESS) S | \x53 | ("\\x53",SUCCESS) T | \x54 | ("\\x54",SUCCESS) U | \x55 | ("\\x55",SUCCESS) V | \x56 | ("\\x56",SUCCESS) W | \x57 | ("\\x57",SUCCESS) X | \x58 | ("\\x58",SUCCESS) Y | \x59 | ("\\x59",SUCCESS) Z | \x5a | ("\\x5a",SUCCESS) [ | \x5b | ("\\x5b",SUCCESS) \ | \x5c | ("\\x5c",SUCCESS) ] | \x5d | ("\\x5d",SUCCESS) ^ | \x5e | ("\\x5e",SUCCESS) _ | \x5f | ("\\x5f",SUCCESS) ` | \x60 | ("\\x60",SUCCESS) a | \x61 | ("\\x61",SUCCESS) b | \x62 | ("\\x62",SUCCESS) c | \x63 | ("\\x63",SUCCESS) d | \x64 | ("\\x64",SUCCESS) e | \x65 | ("\\x65",SUCCESS) f | \x66 | ("\\x66",SUCCESS) g | \x67 | ("\\x67",SUCCESS) h | \x68 | ("\\x68",SUCCESS) i | \x69 | ("\\x69",SUCCESS) j | \x6a | ("\\x6a",SUCCESS) k | \x6b | ("\\x6b",SUCCESS) l | \x6c | ("\\x6c",SUCCESS) m | \x6d | ("\\x6d",SUCCESS) n | \x6e | ("\\x6e",SUCCESS) o | \x6f | ("\\x6f",SUCCESS) p | \x70 | ("\\x70",SUCCESS) q | \x71 | ("\\x71",SUCCESS) r | \x72 | ("\\x72",SUCCESS) s | \x73 | ("\\x73",SUCCESS) t | \x74 | ("\\x74",SUCCESS) u | \x75 | ("\\x75",SUCCESS) v | \x76 | ("\\x76",SUCCESS) w | \x77 | ("\\x77",SUCCESS) x | \x78 | ("\\x78",SUCCESS) y | \x79 | ("\\x79",SUCCESS) z | \x7a | ("\\x7a",SUCCESS) { | \x7b | ("\\x7b",SUCCESS) | | \x7c | ("\\x7c",SUCCESS) } | \x7d | ("\\x7d",SUCCESS) ~ | \x7e | ("\\x7e",SUCCESS) <DEL> | \x7f | (,PROHIBITED) (128 rows) DROP EXTENSION test_saslprep;