Mercurial > gemma

comparison schema/run_tests.sh @ 4431:8fcabb6f971e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix operator support functions Operators used in an operator class should not be based on SQL functions, which might be inlined, thus preventing index usage based on the operator. Schema qualify functions called inside functions to make the outer function work independendly from search_path setting. This makes it possible to use the operators using the 'OPERATOR(<schema>.<opname>)' syntax. Most importantly, it fixes the usage of isrs_diff() during autovacuum.
author Tom Gottfried <tom@intevation.de>
date Wed, 18 Sep 2019 17:26:28 +0200
parents 5e38667f740c
children 0f2c3cb139cc
comparison
equal deleted inserted replaced
4430:86c89824aab4 4431:8fcabb6f971e
78 # Drop test roles, add test data and run tests 78 # Drop test roles, add test data and run tests
79 psql -qXv ON_ERROR_STOP= -v -d "$db" -p "$port" \ 79 psql -qXv ON_ERROR_STOP= -v -d "$db" -p "$port" \
80 -c 'SET client_min_messages TO WARNING' \ 80 -c 'SET client_min_messages TO WARNING' \
81 -c "DROP ROLE IF EXISTS $TEST_ROLES" \ 81 -c "DROP ROLE IF EXISTS $TEST_ROLES" \
82 -f "$BASEDIR"/tap_tests_data.sql \ 82 -f "$BASEDIR"/tap_tests_data.sql \
83 -c "SELECT plan(74 + ( 83 -c "SELECT plan(75 + (
84 SELECT count(*)::int 84 SELECT count(*)::int
85 FROM information_schema.tables 85 FROM information_schema.tables
86 WHERE table_schema = 'waterway'))" \ 86 WHERE table_schema = 'waterway'))" \
87 -f "$BASEDIR"/gemma_tests.sql \ 87 -f "$BASEDIR"/gemma_tests.sql \
88 -f "$BASEDIR"/isrs_tests.sql \ 88 -f "$BASEDIR"/isrs_tests.sql \