/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/pl/plpython/expected/plpython_unicode.out
60 строк
2 KB
Noah Misch
EUC_CN, EUC_JP, EUC_KR, EUC_TW: Skip U+00A0 tests instead of failing.
26 фев 2026, 05:13
26 фев 2026, 05:13
0163951
Код
Авторство
О чём код?
-- -- Unicode handling -- -- This test case would fail if the database encoding is EUC_CN, EUC_JP, -- EUC_KR, or EUC_TW, for lack of any equivalent to U+00A0 (no-break space) in -- those encodings. However, testing with plain ASCII data would be rather -- useless, so we must live with that. -- SELECT getdatabaseencoding() IN ('EUC_CN', 'EUC_JP', 'EUC_KR', 'EUC_TW') AS skip_test \gset \if :skip_test \quit \endif SET client_encoding TO UTF8; CREATE TABLE unicode_test ( testvalue text NOT NULL ); CREATE FUNCTION unicode_return() RETURNS text AS E' return "\\xA0" ' LANGUAGE plpython3u; CREATE FUNCTION unicode_trigger() RETURNS trigger AS E' TD["new"]["testvalue"] = "\\xA0" return "MODIFY" ' LANGUAGE plpython3u; CREATE TRIGGER unicode_test_bi BEFORE INSERT ON unicode_test FOR EACH ROW EXECUTE PROCEDURE unicode_trigger(); CREATE FUNCTION unicode_plan1() RETURNS text AS E' plan = plpy.prepare("SELECT $1 AS testvalue", ["text"]) rv = plpy.execute(plan, ["\\xA0"], 1) return rv[0]["testvalue"] ' LANGUAGE plpython3u; CREATE FUNCTION unicode_plan2() RETURNS text AS E' plan = plpy.prepare("SELECT $1 || $2 AS testvalue", ["text", "text"]) rv = plpy.execute(plan, ["foo", "bar"], 1) return rv[0]["testvalue"] ' LANGUAGE plpython3u; SELECT unicode_return(); unicode_return ---------------- (1 row) INSERT INTO unicode_test (testvalue) VALUES ('test'); SELECT * FROM unicode_test; testvalue ----------- (1 row) SELECT unicode_plan1(); unicode_plan1 --------------- (1 row) SELECT unicode_plan2(); unicode_plan2 --------------- foobar (1 row)