Re: regression tests fails

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: regression tests fails
Дата
Msg-id CAFj8pRA68tAY9in8T=z=jp7uW=AuNrVQff0k6AAYHCymtkWFhA@mail.gmail.com
обсуждение исходный текст
Ответ на regression tests fails  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: regression tests fails
Список pgsql-hackers
Дерево обсуждения


2016-11-16 5:54 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:
Hi

I have a repeated problem with regress tests

master, Fedora 25,

running on port 50848 with PID 5548
============== creating database "regression"         ==============
CREATE DATABASE
ALTER DATABASE
============== running regression test queries        ==============
test ddl                      ... ok
test xact                     ... ok
test rewrite                  ... ok
test toast                    ... ok
test permissions              ... ok
test decoding_in_xact         ... ok
test decoding_into_rel        ... ok
test binary                   ... ok
test prepared                 ... ok
test replorigin               ... ok
test time                     ... ok
test messages                 ... ok
test spill                    ... FAILED
============== shutting down postmaster               ==============

The result is in unstable order.

I was wrong - there is ORDER BY clause

 SELECT (regexp_split_to_array(data, ':'))[4], COUNT(*), (array_agg(data))[1], (array_agg(data))[count(*)]
  FROM pg_logical_slot_get_changes('regression_slot', NULL,NULL) WHERE data ~ 'INSERT'
  GROUP BY 1 ORDER BY 1;

but result is sensitive on locales setting - doesn't work well with czech locales.

Regards

Pavel



Regards

Pavel

В списке pgsql-hackers по дате отправления: