[package - 132powerpc-quarterly][databases/libpg_query] Failed for libpg_query-15.4.2.3 in build
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Mon, 12 Feb 2024 00:38:50 UTC
You are receiving this mail as a port that you maintain
is failing to build on the FreeBSD package build server.
Please investigate the failure and submit a PR to fix
build.
Maintainer: mfechner@FreeBSD.org
Log URL: https://pkg-status.freebsd.org/foul1/data/132powerpc-quarterly/aa3532662c1f/logs/libpg_query-15.4.2.3.log
Build URL: https://pkg-status.freebsd.org/foul1/build.html?mastername=132powerpc-quarterly&build=aa3532662c1f
Log:
=>> Building databases/libpg_query
build started at Mon Feb 12 00:35:06 UTC 2024
port directory: /usr/ports/databases/libpg_query
package name: libpg_query-15.4.2.3
building for: FreeBSD 132powerpc-quarterly-job-13 13.2-RELEASE FreeBSD 13.2-RELEASE powerpc
maintained by: mfechner@FreeBSD.org
Makefile datestamp: -rw-r--r-- 1 root wheel 735 Feb 3 01:03 /usr/ports/databases/libpg_query/Makefile
Ports top last git commit: aa3532662
Ports top unclean checkout: no
Port dir last git commit: aa3532662
Port dir unclean checkout: no
Poudriere version: poudriere-git-3.4.1
Host OSVERSION: 1500003
Jail OSVERSION: 1302001
Job Id: 13
---Begin Environment---
SHELL=/bin/csh
BLOCKSIZE=K
MAIL=/var/mail/root
MM_CHARSET=UTF-8
LANG=C.UTF-8
OSVERSION=1302001
STATUS=1
HOME=/root
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/root/bin
MAKE_OBJDIR_CHECK_WRITABLE=0
UNAME_m=powerpc
UNAME_p=powerpc
UNAME_r=13.2-RELEASE
LOCALBASE=/usr/local
UNAME_v=FreeBSD 13.2-RELEASE
USER=root
POUDRIERE_NAME=poudriere-git
LIBEXECPREFIX=/usr/local/libexec/poudriere
POUDRIERE_VERSION=3.4.1
MASTERMNT=/usr/local/poudriere/data/.m/132powerpc-quarterly/ref
LC_COLLATE=C
POUDRIERE_BUILD_TYPE=bulk
PACKAGE_BUILDING=yes
SAVED_TERM=
OUTPUT_REDIRECTED_STDERR=4
OUTPUT_REDIRECTED=1
PWD=/usr/local/poudriere/data/.m/132powerpc-quarterly/13/.p
OUTPUT_REDIRECTED_STDOUT=3
P_PORTS_FEATURES=FLAVORS SUBPACKAGES SELECTED_OPTIONS
MASTERNAME=132powerpc-quarterly
SCRIPTPREFIX=/usr/local/share/poudriere
SCRIPTNAME=bulk.sh
OLDPWD=/usr/local/poudriere/data/.m/132powerpc-quarterly/ref/.p/pool
POUDRIERE_PKGNAME=poudriere-git-3.4.1
SCRIPTPATH=/usr/local/share/poudriere/bulk.sh
POUDRIEREPATH=/usr/local/bin/poudriere
---End Environment---
---Begin Poudriere Port Flags/Env---
PORT_FLAGS=
PKGENV=
FLAVOR=
MAKE_ARGS=
---End Poudriere Port Flags/Env---
---Begin OPTIONS List---
---End OPTIONS List---
--MAINTAINER--
mfechner@FreeBSD.org
--End MAINTAINER--
--CONFIGURE_ARGS--
--End CONFIGURE_ARGS--
--CONFIGURE_ENV--
MAKE=gmake XDG_DATA_HOME=/wrkdirs/usr/ports/databases/libpg_query/work XDG_CONFIG_HOME=/wrkdirs/usr/ports/databases/libpg_query/work XDG_CACHE_HOME=/wrkdirs/usr/ports/databases/libpg_query/work/.cache HOME=/wrkdirs/usr/ports/databases/libpg_query/work TMPDIR="/tmp" PATH=/wrkdirs/usr/ports/databases/libpg_query/work/.bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/root/bin PKG_CONFIG_LIBDIR=/wrkdirs/usr/ports/databases/libpg_query/work/.pkgconfig:/usr/local/libdata/pkgconfig:/usr/local/share/pkgconfig:/usr/libdata/pkgconfig SHELL=/bin/sh CONFIG_SHELL=/bin/sh
--End CONFIGURE_ENV--
--MAKE_ENV--
XDG_DATA_HOME=/wrkdirs/usr/ports/databases/libpg_query/work XDG_CONFIG_HOME=/wrkdirs/usr/ports/databases/libpg_query/work XDG_CACHE_HOME=/wrkdirs/usr/ports/databases/libpg_query/work/.cache HOME=/wrkdirs/usr/ports/databases/libpg_query/work TMPDIR="/tmp" PATH=/wrkdirs/usr/ports/databases/libpg_query/work/.bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/root/bin PKG_CONFIG_LIBDIR=/wrkdirs/usr/ports/databases/libpg_query/work/.pkgconfig:/usr/local/libdata/pkgconfig:/usr/local/share/pkgconfig:/usr/libdata/pkgconfig MK_DEBUG_FILES=no MK_KERNEL_SYMBOLS=no SHELL=/bin/sh NO_LINT=YES PREFIX=/usr/local LOCALBASE=/usr/local CC="cc" CFLAGS="-O2 -pipe -fstack-protector-strong -fno-strict-aliasing " CPP="cpp" CPPFLAGS="-I/usr/local/include" LDFLAGS=" -L/usr/local/lib -fstack-protector-strong " LIBS="" CXX="c++" CXXFLAGS="-O2 -pipe -fstack-protector-strong -fno-strict-aliasing " MANPREFIX="/usr/local" BSD_INSTALL_PROGRAM="install -s -m 555" BSD_INSTALL_LIB="install
-s -m 0644" BSD_INSTALL_SCRIPT="install -m 555" BSD_INSTALL_DATA="install -m 0644" BSD_INSTALL_MAN="install -m 444"
--End MAKE_ENV--
--PLIST_SUB--
OSREL=13.2 PREFIX=%D LOCALBASE=/usr/local RESETPREFIX=/usr/local LIB32DIR=lib DOCSDIR="share/doc/libpg_query" EXAMPLESDIR="share/examples/libpg_query" DATADIR="share/libpg_query" WWWDIR="www/libpg_query" ETCDIR="etc/libpg_query"
--End PLIST_SUB--
--SUB_LIST--
PREFIX=/usr/local LOCALBASE=/usr/local DATADIR=/usr/local/share/libpg_query DOCSDIR=/usr/local/share/doc/libpg_query EXAMPLESDIR=/usr/local/share/examples/libpg_query WWWDIR=/usr/local/www/libpg_query ETCDIR=/usr/local/etc/libpg_query
--End SUB_LIST--
---Begin make.conf---
USE_PACKAGE_DEPENDS=yes
BATCH=yes
WRKDIRPREFIX=/wrkdirs
PORTSDIR=/usr/ports
PACKAGES=/packages
DISTDIR=/distfiles
PACKAGE_BUILDING=yes
PACKAGE_BUILDING_FLAVORS=yes
MACHINE=powerpc
MACHINE_ARCH=powerpc
ARCH=${MACHINE_ARCH}
#### ####
# XXX: We really need this but cannot use it while 'make checksum' does not
# try the next mirror on checksum failure. It currently retries the same
# failed mirror and then fails rather then trying another. It *does*
# try the next if the size is mismatched though.
#MASTER_SITE_FREEBSD=yes
# Build ALLOW_MAKE_JOBS_PACKAGES with 3 jobs
MAKE_JOBS_NUMBER=3
#### Misc Poudriere ####
.include "/etc/make.conf.ports_env"
GID=0
UID=0
---End make.conf---
--Resource limits--
cpu time (seconds, -t) unlimited
file size (512-blocks, -f) unlimited
data seg size (kbytes, -d) 1048576
stack size (kbytes, -s) 65536
core file size (512-blocks, -c) unlimited
max memory size (kbytes, -m) unlimited
locked memory (kbytes, -l) unlimited
max user processes (-u) 89999
open files (-n) 8192
virtual mem size (kbytes, -v) unlimited
swap limit (kbytes, -w) unlimited
socket buffer size (bytes, -b) unlimited
pseudo-terminals (-p) unlimited
kqueues (-k) unlimited
umtx shared locks (-o) unlimited
--End resource limits--
=======================<phase: check-sanity >============================
===== env: NO_DEPENDS=yes USER=root UID=0 GID=0
===> License BSD3CLAUSE accepted by the user
===========================================================================
=======================<phase: pkg-depends >============================
===== env: USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0
===> libpg_query-15.4.2.3 depends on file: /usr/local/sbin/pkg - not found
===> Installing existing package /packages/All/pkg-1.20.9.pkg
[132powerpc-quarterly-job-13] Installing pkg-1.20.9...
[132powerpc-quarterly-job-13] Extracting pkg-1.20.9: .......... done
===> libpg_query-15.4.2.3 depends on file: /usr/local/sbin/pkg - found
===> Returning to build of libpg_query-15.4.2.3
===========================================================================
=======================<phase: fetch-depends >============================
===== env: USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0
===========================================================================
=======================<phase: fetch >============================
===== env: NO_DEPENDS=yes USER=root UID=0 GID=0
===> License BSD3CLAUSE accepted by the user
===> Fetching all distfiles required by libpg_query-15.4.2.3 for building
===========================================================================
=======================<phase: checksum >============================
===== env: NO_DEPENDS=yes USER=root UID=0 GID=0
===> License BSD3CLAUSE accepted by the user
===> Fetching all distfiles required by libpg_query-15.4.2.3 for building
=> SHA256 Checksum OK for lfittl-libpg_query-15-4.2.3_GH0.tar.gz.
===========================================================================
=======================<phase: extract-depends>============================
===== env: USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0
===========================================================================
=======================<phase: extract >============================
===== env: NO_DEPENDS=yes USER=root UID=0 GID=0
===> License BSD3CLAUSE accepted by the user
===> Fetching all distfiles required by libpg_query-15.4.2.3 for building
===> Extracting for libpg_query-15.4.2.3
=> SHA256 Checksum OK for lfittl-libpg_query-15-4.2.3_GH0.tar.gz.
===========================================================================
=======================<phase: patch-depends >============================
===== env: USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0
===========================================================================
=======================<phase: patch >============================
===== env: NO_DEPENDS=yes USER=root UID=0 GID=0
===> Patching for libpg_query-15.4.2.3
===========================================================================
=======================<phase: build-depends >============================
===== env: USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0
===> libpg_query-15.4.2.3 depends on package: gmake>=4.3 - not found
===> Installing existing package /packages/All/gmake-4.3_2.pkg
[132powerpc-quarterly-job-13] Installing gmake-4.3_2...
[132powerpc-quarterly-job-13] `-- Installing gettext-runtime-0.22.3...
[132powerpc-quarterly-job-13] | `-- Installing indexinfo-0.3.1...
[132powerpc-quarterly-job-13] | `-- Extracting indexinfo-0.3.1: .... done
[132powerpc-quarterly-job-13] `-- Extracting gettext-runtime-0.22.3: .......... done
[132powerpc-quarterly-job-13] Extracting gmake-4.3_2: .......... done
===> libpg_query-15.4.2.3 depends on package: gmake>=4.3 - found
===> Returning to build of libpg_query-15.4.2.3
===========================================================================
=======================<phase: lib-depends >============================
===== env: USE_PACKAGE_DEPENDS_ONLY=1 USER=root UID=0 GID=0
===> libpg_query-15.4.2.3 depends on shared library: libpq.so.5 - not found
===> Installing existing package /packages/All/postgresql15-client-15.5.pkg
[132powerpc-quarterly-job-13] Installing postgresql15-client-15.5...
[132powerpc-quarterly-job-13] `-- Installing readline-8.2.7...
[132powerpc-quarterly-job-13] `-- Extracting readline-8.2.7: .......... done
[132powerpc-quarterly-job-13] Extracting postgresql15-client-15.5: .......... done
=====
Message from postgresql15-client-15.5:
<snip>
"," = [ 2327, 2328, ASCII_44, NO_KEYWORD ]
"?" = [ 2329, 2330, Op, NO_KEYWORD ]
"," = [ 2330, 2331, ASCII_44, NO_KEYWORD ]
"?" = [ 2332, 2333, Op, NO_KEYWORD ]
"," = [ 2333, 2334, ASCII_44, NO_KEYWORD ]
"?" = [ 2335, 2336, Op, NO_KEYWORD ]
"," = [ 2336, 2337, ASCII_44, NO_KEYWORD ]
"?" = [ 2338, 2339, Op, NO_KEYWORD ]
"," = [ 2339, 2340, ASCII_44, NO_KEYWORD ]
"?" = [ 2341, 2342, Op, NO_KEYWORD ]
")" = [ 2342, 2343, ASCII_41, NO_KEYWORD ]
"," = [ 2343, 2344, ASCII_44, NO_KEYWORD ]
"(" = [ 2345, 2346, ASCII_40, NO_KEYWORD ]
"?" = [ 2346, 2347, Op, NO_KEYWORD ]
"," = [ 2347, 2348, ASCII_44, NO_KEYWORD ]
"?" = [ 2349, 2350, Op, NO_KEYWORD ]
"," = [ 2350, 2351, ASCII_44, NO_KEYWORD ]
"?" = [ 2352, 2353, Op, NO_KEYWORD ]
"," = [ 2353, 2354, ASCII_44, NO_KEYWORD ]
"?" = [ 2355, 2356, Op, NO_KEYWORD ]
"," = [ 2356, 2357, ASCII_44, NO_KEYWORD ]
"?" = [ 2358, 2359, Op, NO_KEYWORD ]
"," = [ 2359, 2360, ASCII_44, NO_KEYWORD ]
"?" = [ 2361, 2362, Op, NO_KEYWORD ]
"," = [ 2362, 2363, ASCII_44, NO_KEYWORD ]
"?" = [ 2364, 2365, Op, NO_KEYWORD ]
")" = [ 2365, 2366, ASCII_41, NO_KEYWORD ]
"," = [ 2366, 2367, ASCII_44, NO_KEYWORD ]
"(" = [ 2368, 2369, ASCII_40, NO_KEYWORD ]
"?" = [ 2369, 2370, Op, NO_KEYWORD ]
"," = [ 2370, 2371, ASCII_44, NO_KEYWORD ]
"?" = [ 2372, 2373, Op, NO_KEYWORD ]
"," = [ 2373, 2374, ASCII_44, NO_KEYWORD ]
"?" = [ 2375, 2376, Op, NO_KEYWORD ]
"," = [ 2376, 2377, ASCII_44, NO_KEYWORD ]
"?" = [ 2378, 2379, Op, NO_KEYWORD ]
"," = [ 2379, 2380, ASCII_44, NO_KEYWORD ]
"?" = [ 2381, 2382, Op, NO_KEYWORD ]
"," = [ 2382, 2383, ASCII_44, NO_KEYWORD ]
"?" = [ 2384, 2385, Op, NO_KEYWORD ]
"," = [ 2385, 2386, ASCII_44, NO_KEYWORD ]
"?" = [ 2387, 2388, Op, NO_KEYWORD ]
")" = [ 2388, 2389, ASCII_41, NO_KEYWORD ]
"," = [ 2389, 2390, ASCII_44, NO_KEYWORD ]
"(" = [ 2391, 2392, ASCII_40, NO_KEYWORD ]
"?" = [ 2392, 2393, Op, NO_KEYWORD ]
"," = [ 2393, 2394, ASCII_44, NO_KEYWORD ]
"?" = [ 2395, 2396, Op, NO_KEYWORD ]
"," = [ 2396, 2397, ASCII_44, NO_KEYWORD ]
"?" = [ 2398, 2399, Op, NO_KEYWORD ]
"," = [ 2399, 2400, ASCII_44, NO_KEYWORD ]
"?" = [ 2401, 2402, Op, NO_KEYWORD ]
"," = [ 2402, 2403, ASCII_44, NO_KEYWORD ]
"?" = [ 2404, 2405, Op, NO_KEYWORD ]
"," = [ 2405, 2406, ASCII_44, NO_KEYWORD ]
"?" = [ 2407, 2408, Op, NO_KEYWORD ]
"," = [ 2408, 2409, ASCII_44, NO_KEYWORD ]
"?" = [ 2410, 2411, Op, NO_KEYWORD ]
")" = [ 2411, 2412, ASCII_41, NO_KEYWORD ]
"ON" = [ 2413, 2415, ON, RESERVED_KEYWORD ]
"CONFLICT" = [ 2416, 2424, CONFLICT, UNRESERVED_KEYWORD ]
"(" = [ 2425, 2426, ASCII_40, NO_KEYWORD ]
"table_id" = [ 2426, 2434, IDENT, NO_KEYWORD ]
"," = [ 2434, 2435, ASCII_44, NO_KEYWORD ]
"name" = [ 2436, 2440, NAME_P, UNRESERVED_KEYWORD ]
")" = [ 2440, 2441, ASCII_41, NO_KEYWORD ]
"WHERE" = [ 2442, 2447, WHERE, RESERVED_KEYWORD ]
"invalidated_at_snapshot_id" = [ 2448, 2474, IDENT, NO_KEYWORD ]
"IS" = [ 2475, 2477, IS, TYPE_FUNC_NAME_KEYWORD ]
"NULL" = [ 2478, 2482, NULL_P, RESERVED_KEYWORD ]
"DO" = [ 2483, 2485, DO, RESERVED_KEYWORD ]
"UPDATE" = [ 2486, 2492, UPDATE, UNRESERVED_KEYWORD ]
"SET" = [ 2493, 2496, SET, UNRESERVED_KEYWORD ]
"(" = [ 2497, 2498, ASCII_40, NO_KEYWORD ]
"position" = [ 2498, 2506, POSITION, COL_NAME_KEYWORD ]
"," = [ 2506, 2507, ASCII_44, NO_KEYWORD ]
"data_type" = [ 2508, 2517, IDENT, NO_KEYWORD ]
"," = [ 2517, 2518, ASCII_44, NO_KEYWORD ]
"default_value" = [ 2519, 2532, IDENT, NO_KEYWORD ]
"," = [ 2532, 2533, ASCII_44, NO_KEYWORD ]
"not_null" = [ 2534, 2542, IDENT, NO_KEYWORD ]
")" = [ 2542, 2543, ASCII_41, NO_KEYWORD ]
"=" = [ 2544, 2545, ASCII_61, NO_KEYWORD ]
"(" = [ 2546, 2547, ASCII_40, NO_KEYWORD ]
"EXCLUDED" = [ 2547, 2555, IDENT, NO_KEYWORD ]
"." = [ 2555, 2556, ASCII_46, NO_KEYWORD ]
"position" = [ 2556, 2564, POSITION, COL_NAME_KEYWORD ]
"," = [ 2564, 2565, ASCII_44, NO_KEYWORD ]
"EXCLUDED" = [ 2566, 2574, IDENT, NO_KEYWORD ]
"." = [ 2574, 2575, ASCII_46, NO_KEYWORD ]
"data_type" = [ 2575, 2584, IDENT, NO_KEYWORD ]
"," = [ 2584, 2585, ASCII_44, NO_KEYWORD ]
"EXCLUDED" = [ 2586, 2594, IDENT, NO_KEYWORD ]
"." = [ 2594, 2595, ASCII_46, NO_KEYWORD ]
"default_value" = [ 2595, 2608, IDENT, NO_KEYWORD ]
"," = [ 2608, 2609, ASCII_44, NO_KEYWORD ]
"EXCLUDED" = [ 2610, 2618, IDENT, NO_KEYWORD ]
"." = [ 2618, 2619, ASCII_46, NO_KEYWORD ]
"not_null" = [ 2619, 2627, IDENT, NO_KEYWORD ]
")" = [ 2627, 2628, ASCII_41, NO_KEYWORD ]
"RETURNING" = [ 2629, 2638, RETURNING, RESERVED_KEYWORD ]
"id" = [ 2639, 2641, IDENT, NO_KEYWORD ]
"," = [ 2641, 2642, ASCII_44, NO_KEYWORD ]
"table_id" = [ 2643, 2651, IDENT, NO_KEYWORD ]
"," = [ 2651, 2652, ASCII_44, NO_KEYWORD ]
"name" = [ 2653, 2657, NAME_P, UNRESERVED_KEYWORD ]
")" = [ 2657, 2658, ASCII_41, NO_KEYWORD ]
"," = [ 2658, 2659, ASCII_44, NO_KEYWORD ]
"all_ids" = [ 2660, 2667, IDENT, NO_KEYWORD ]
"AS" = [ 2668, 2670, AS, RESERVED_KEYWORD ]
"(" = [ 2671, 2672, ASCII_40, NO_KEYWORD ]
"SELECT" = [ 2672, 2678, SELECT, RESERVED_KEYWORD ]
"id" = [ 2679, 2681, IDENT, NO_KEYWORD ]
"FROM" = [ 2682, 2686, FROM, RESERVED_KEYWORD ]
"upsert" = [ 2687, 2693, IDENT, NO_KEYWORD ]
")" = [ 2693, 2694, ASCII_41, NO_KEYWORD ]
"," = [ 2694, 2695, ASCII_44, NO_KEYWORD ]
"cleanup" = [ 2696, 2703, IDENT, NO_KEYWORD ]
"AS" = [ 2704, 2706, AS, RESERVED_KEYWORD ]
"(" = [ 2707, 2708, ASCII_40, NO_KEYWORD ]
"UPDATE" = [ 2708, 2714, UPDATE, UNRESERVED_KEYWORD ]
"schema_columns" = [ 2715, 2729, IDENT, NO_KEYWORD ]
"SET" = [ 2730, 2733, SET, UNRESERVED_KEYWORD ]
"invalidated_at_snapshot_id" = [ 2734, 2760, IDENT, NO_KEYWORD ]
"=" = [ 2761, 2762, ASCII_61, NO_KEYWORD ]
"?" = [ 2763, 2764, Op, NO_KEYWORD ]
"WHERE" = [ 2765, 2770, WHERE, RESERVED_KEYWORD ]
"table_id" = [ 2771, 2779, IDENT, NO_KEYWORD ]
"=" = [ 2780, 2781, ASCII_61, NO_KEYWORD ]
"?" = [ 2782, 2783, Op, NO_KEYWORD ]
"AND" = [ 2784, 2787, AND, RESERVED_KEYWORD ]
"invalidated_at_snapshot_id" = [ 2788, 2814, IDENT, NO_KEYWORD ]
"IS" = [ 2815, 2817, IS, TYPE_FUNC_NAME_KEYWORD ]
"NULL" = [ 2818, 2822, NULL_P, RESERVED_KEYWORD ]
"AND" = [ 2823, 2826, AND, RESERVED_KEYWORD ]
"id" = [ 2827, 2829, IDENT, NO_KEYWORD ]
"NOT" = [ 2830, 2833, NOT, RESERVED_KEYWORD ]
"IN" = [ 2834, 2836, IN_P, RESERVED_KEYWORD ]
"(" = [ 2837, 2838, ASCII_40, NO_KEYWORD ]
"SELECT" = [ 2838, 2844, SELECT, RESERVED_KEYWORD ]
"id" = [ 2845, 2847, IDENT, NO_KEYWORD ]
"FROM" = [ 2848, 2852, FROM, RESERVED_KEYWORD ]
"all_ids" = [ 2853, 2860, IDENT, NO_KEYWORD ]
")" = [ 2860, 2861, ASCII_41, NO_KEYWORD ]
")" = [ 2861, 2862, ASCII_41, NO_KEYWORD ]
"SELECT" = [ 2863, 2869, SELECT, RESERVED_KEYWORD ]
"*" = [ 2870, 2871, ASCII_42, NO_KEYWORD ]
"FROM" = [ 2872, 2876, FROM, RESERVED_KEYWORD ]
"upsert" = [ 2877, 2883, IDENT, NO_KEYWORD ]
SELECT $foo$test$foo$, '123' FROM "xy", abc
version: 150001, tokens: 8, size: 76
"SELECT" = [ 0, 6, SELECT, RESERVED_KEYWORD ]
"$foo$test$foo$" = [ 7, 21, SCONST, NO_KEYWORD ]
"," = [ 21, 22, ASCII_44, NO_KEYWORD ]
"'123'" = [ 23, 28, SCONST, NO_KEYWORD ]
"FROM" = [ 29, 33, FROM, RESERVED_KEYWORD ]
""xy"" = [ 34, 38, IDENT, NO_KEYWORD ]
"," = [ 38, 39, ASCII_44, NO_KEYWORD ]
"abc" = [ 40, 43, IDENT, NO_KEYWORD ]
SELECT '/*not a comment*/', E'\134', B'10', X'12', -Infinity, U&"d!0061t!+000061" UESCAPE '!'
version: 150001, tokens: 15, size: 135
"SELECT" = [ 0, 6, SELECT, RESERVED_KEYWORD ]
"'/*not a comment*/'" = [ 7, 26, SCONST, NO_KEYWORD ]
"," = [ 26, 27, ASCII_44, NO_KEYWORD ]
"E'\134'" = [ 28, 35, SCONST, NO_KEYWORD ]
"," = [ 35, 36, ASCII_44, NO_KEYWORD ]
"B'10'" = [ 37, 42, BCONST, NO_KEYWORD ]
"," = [ 42, 43, ASCII_44, NO_KEYWORD ]
"X'12'" = [ 44, 49, XCONST, NO_KEYWORD ]
"," = [ 49, 50, ASCII_44, NO_KEYWORD ]
"-" = [ 51, 52, ASCII_45, NO_KEYWORD ]
"Infinity" = [ 52, 60, IDENT, NO_KEYWORD ]
"," = [ 60, 61, ASCII_44, NO_KEYWORD ]
"U" = [ 62, 63, UIDENT, NO_KEYWORD ]
"UESCAPE" = [ 82, 89, UESCAPE, UNRESERVED_KEYWORD ]
"'!'" = [ 90, 93, SCONST, NO_KEYWORD ]
examples/normalize
SELECT $1
examples/simple_error
error: syntax error at or near "FROM" at location 8 (scanner_yyerror in scan.l:1202)
examples/normalize_error
error: unterminated dollar-quoted string at or near "$$$" at location 8 (scan.l:1202)
examples/simple_plpgsql
[
{"PLpgSQL_function":{"datums":[{"PLpgSQL_var":{"refname":"v_name","datatype":{"PLpgSQL_type":{"typname":"UNKNOWN"}}}},{"PLpgSQL_var":{"refname":"v_version","datatype":{"PLpgSQL_type":{"typname":"UNKNOWN"}}}},{"PLpgSQL_var":{"refname":"found","datatype":{"PLpgSQL_type":{"typname":"UNKNOWN"}}}}],"action":{"PLpgSQL_stmt_block":{"lineno":1,"body":[{"PLpgSQL_stmt_if":{"lineno":1,"cond":{"PLpgSQL_expr":{"query":"v_version IS NULL"}},"then_body":[{"PLpgSQL_stmt_return":{"lineno":1,"expr":{"PLpgSQL_expr":{"query":"v_name"}}}}]}},{"PLpgSQL_stmt_return":{"lineno":1,"expr":{"PLpgSQL_expr":{"query":"v_name || '/' || v_version"}}}}]}}}}
]
test/complex
......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.
test/concurrency
......................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
............................................!
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
............................................!
..........!
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
............................................!
..........!
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
............................................!
..........!
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
............................................!
..........!
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
............................................!
..........!
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
............................................!
..........!
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
............................................!
..........!
.....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................
......................................................................................................................................
test/deparse
gmake[1]: *** [Makefile:250: test] Segmentation fault (core dumped)
gmake[1]: Leaving directory '/wrkdirs/usr/ports/databases/libpg_query/work/libpg_query-15-4.2.3'
===> Compilation failed unexpectedly.
Try to set MAKE_JOBS_UNSAFE=yes and rebuild before reporting the failure to
the maintainer.
*** Error code 1
Stop.
make: stopped in /usr/ports/databases/libpg_query