/
githubmirror
/
postgres
Обзор
Документация
Войти
/
githubmirror
/
postgres
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/isolation/expected/sequence-ddl.out
91 строка
2 KB
Tom Lane
Improve display of query results in isolation tests.
23 июн 2021, 18:13
23 июн 2021, 18:13
4a05406
Код
Авторство
О чём код?
Parsed test spec with 2 sessions starting permutation: s1alter s1commit s2nv step s1alter: ALTER SEQUENCE seq1 MAXVALUE 10; step s1commit: COMMIT; step s2nv: SELECT nextval('seq1') FROM generate_series(1, 15); ERROR: nextval: reached maximum value of sequence "seq1" (10) starting permutation: s1alter s2nv s1commit step s1alter: ALTER SEQUENCE seq1 MAXVALUE 10; step s2nv: SELECT nextval('seq1') FROM generate_series(1, 15); <waiting ...> step s1commit: COMMIT; step s2nv: <... completed> ERROR: nextval: reached maximum value of sequence "seq1" (10) starting permutation: s1restart s2nv s1commit step s1restart: ALTER SEQUENCE seq1 RESTART WITH 5; step s2nv: SELECT nextval('seq1') FROM generate_series(1, 15); <waiting ...> step s1commit: COMMIT; step s2nv: <... completed> nextval ------- 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 (15 rows) starting permutation: s1restart s2nv s1commit step s1restart: ALTER SEQUENCE seq1 RESTART WITH 5; step s2nv: SELECT nextval('seq1') FROM generate_series(1, 15); <waiting ...> step s1commit: COMMIT; step s2nv: <... completed> nextval ------- 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 (15 rows) starting permutation: s2begin s2nv s1alter2 s2commit s1commit step s2begin: BEGIN; step s2nv: SELECT nextval('seq1') FROM generate_series(1, 15); nextval ------- 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 (15 rows) step s1alter2: ALTER SEQUENCE seq1 MAXVALUE 20; <waiting ...> step s2commit: COMMIT; step s1alter2: <... completed> step s1commit: COMMIT;