From nobody Tue Jan 28 14:57:34 2025 X-Original-To: ports-bugs@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4Yj7gL6CQYz5lZ8l for ; Tue, 28 Jan 2025 14:57:34 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R11" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4Yj7gL47PYz3dmG for ; Tue, 28 Jan 2025 14:57:34 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1738076254; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=mTKkRnChAzQ7eGWFiANFNrW6x9WcBvIzZvy8DBpDofE=; b=nQn+lw7RX9BizeDJlWnpuP0BjZdJTD0VdP2VQbMeof2BTHU/YszshsoPgV26d+y82XIyoi 1tVXwvMJC1uNkX9LwytmjHFJ9tnxwPHJFiFq2vhjZE0iy8KhEHj1y18m5rmMv/W07PmyMD +NR4UrWJO0YlLPI22waE+Mipxt41mE15+02gW85aZlt5xBZXUQual8XhK+379IQGzA8im6 I/deVmtUbv9zfq+eM2P+dWQjKkQ5/tYwYHcbQU/ncFrpwWFCXjYrW+nKmFcdOTODQrzigT ASHOqmf1eIi7p/IYjMpyQ0ZMt5ZzVp7dnWI8Mn961rLMGmiOI0ZXUsVf37C0hA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1738076254; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=mTKkRnChAzQ7eGWFiANFNrW6x9WcBvIzZvy8DBpDofE=; b=udqASbE/9qy1AJ/dohBvc3CBej5SrEWP5238WlFhm8xVxYJZTAXt44MD9+Te5V7dFT/de+ KEbIY1FC2uJX8mXBm0lBu46Jj9XxzALBdLCoz611uk1eok93jXpFcyZQdWpIqEIE3Tu3uH 548yy66nIoY9e1SuAyqSqujRP4i+sf3fgnV+ThcVOk/ao7Qo1h9km9gvTO4chzRrfwS1Th gKYSh7e6pYGth4TSPmOWl7Rnb2pslWK1O+AJ/JzDZ3AKoOq043mz110lVe55HsfMvrkmJ1 G5+COvvMbN81x8kWM3zDEle43836S28kkqoUYrVaA254WPGD2qDqu3oJ+wRppg== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1738076254; a=rsa-sha256; cv=none; b=Arz2e8vdtJS2LaVxE2ThLKi4SG0z8F9JrJGHMy1STqdhtxrIM47ZlK0uT6oOMZpTCALScB D3XsjGxa50+/7lUNbhmcD2lr0b1xcXADj+D3a+TASFb9UHyHJH8BlrZ371EEoiw5BIY7X+ NZVbv7QVa5jSVF3PKjRBYXUqd3ikmJuhoQVvG6ars/iuuVvkBnf9qNUdwhMn9u2gAdfJVb GadqkLKrPz5PEH6KubuS2qifNZjd6RZc2wDXB37qV9K79nZfEUKDZJw7gdHMaxflZW1lzW pPDiIh0HGoTVSFds6BRheP5LXdso3m7Clee6UCZE4RtrzLLn1O65aPkQsPQX/g== ARC-Authentication-Results: i=1; mx1.freebsd.org; none Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4Yj7gL3H6fz4Yd for ; Tue, 28 Jan 2025 14:57:34 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 50SEvYeB037966 for ; Tue, 28 Jan 2025 14:57:34 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 50SEvYhE037965 for ports-bugs@FreeBSD.org; Tue, 28 Jan 2025 14:57:34 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 284411] ports-mgmt/pkg: alias 'prime-origins' - introduced pipe fails Date: Tue, 28 Jan 2025 14:57:34 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Some People X-Bugzilla-Who: erichanskrs@gmail.com X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pkg@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter flagtypes.name Message-ID: Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="UTF-8" X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: freebsd-ports-bugs@freebsd.org Sender: owner-freebsd-ports-bugs@FreeBSD.org MIME-Version: 1.0 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D284411 Bug ID: 284411 Summary: ports-mgmt/pkg: alias 'prime-origins' - introduced pipe fails Product: Ports & Packages Version: Latest Hardware: amd64 OS: Any Status: New Severity: Affects Some People Priority: --- Component: Individual Port(s) Assignee: pkg@FreeBSD.org Reporter: erichanskrs@gmail.com Assignee: pkg@FreeBSD.org Flags: maintainer-feedback?(pkg@FreeBSD.org) Reference forum starts at: https://forums.freebsd.org/threads/pkg-2-0-0-problems.96540/page-4#post-687= 722 Using 14.2R and the 'latest' repository, using the pkg alias: prime-origins: "query -e '%a =3D 0' '%o' | sort -u", as defined in /usr/local/etc/pkg.conf introduces a pipe; it seems for the first time. Related commits: https://github.com/freebsd/pkg/commit/e52fcfac6b1a02b046da36b1d324fb84e5a00= bb1 https://github.com/freebsd/pkg/commit/cce9724f190a1dbedac66cbdac2c1031c22cb= 864 The implementation of the pipe fails to work using pkg(8) 1.21.3 and, confi= rmed in the forum, for 2.0.4. The command sequence below details the unexpected empty result of=20 pkg prim-origins and its likely cause in the underlying query by using debug level 4. Also shown that using the previous non-pipe variant of the alias and uapply= ing the pipe externally gets the exepected result. An empty line was added in t= he debug output to indicate the first immediate occurrence in a 'LEFT JOIN'.=20 --- [0-0] # pkg -v 1.21.3 [1-0] # pkg -vv | sed -n -e '/DEBUG/ p' -e '/^Repositories:/,$ p' DBG(1)[2298]> PkgConfig: loading repositories in /etc/pkg/ DBG(1)[2298]> PKgConfig: loading /etc/pkg//FreeBSD.conf DBG(1)[2298]> PkgConfig: parsing key 'FreeBSD' DBG(1)[2298]> PkgConfig: parsing repository object FreeBSD DBG(1)[2298]> PkgConfig: loading repositories in /usr/local/etc/pkg/repos/ DBG(1)[2298]> PKgConfig: loading /usr/local/etc/pkg/repos//FreeBSD.conf DBG(1)[2298]> PkgConfig: parsing key 'FreeBSD' DBG(1)[2298]> PkgConfig: overwriting repository FreeBSD DBG(1)[2298]> PkgConfig: parsing repository object FreeBSD DBG(1)[2298]> PKgConfig: loading /usr/local/etc/pkg/repos//kmods.conf DBG(1)[2298]> PkgConfig: parsing key 'FreeBSD-kmods' DBG(1)[2298]> PkgConfig: parsing repository object FreeBSD-kmods DEBUG_SCRIPTS =3D false; DEBUG_LEVEL =3D 4; Repositories: FreeBSD: { url : "pkg+https://pkg.freebsd.org/FreeBSD:14:amd64/latest", enabled : yes, priority : 0, mirror_type : "SRV", signature_type : "FINGERPRINTS", fingerprints : "/usr/share/keys/pkg" } FreeBSD-kmods: { url : "pkg+https://pkg.freebsd.org/FreeBSD:14:amd64/kmods_latest_2", enabled : yes, priority : 0, mirror_type : "SRV", signature_type : "FINGERPRINTS", fingerprints : "/usr/share/keys/pkg" } [2-0] # pkg alias prime-origins DBG(1)[2301]> PkgConfig: loading repositories in /etc/pkg/ DBG(1)[2301]> PKgConfig: loading /etc/pkg//FreeBSD.conf DBG(1)[2301]> PkgConfig: parsing key 'FreeBSD' DBG(1)[2301]> PkgConfig: parsing repository object FreeBSD DBG(1)[2301]> PkgConfig: loading repositories in /usr/local/etc/pkg/repos/ DBG(1)[2301]> PKgConfig: loading /usr/local/etc/pkg/repos//FreeBSD.conf DBG(1)[2301]> PkgConfig: parsing key 'FreeBSD' DBG(1)[2301]> PkgConfig: overwriting repository FreeBSD DBG(1)[2301]> PkgConfig: parsing repository object FreeBSD DBG(1)[2301]> PKgConfig: loading /usr/local/etc/pkg/repos//kmods.conf DBG(1)[2301]> PkgConfig: parsing key 'FreeBSD-kmods' DBG(1)[2301]> PkgConfig: parsing repository object FreeBSD-kmods prime-origins 'query -e '%a =3D 0' '%o' | sort -u' [3-0] # pkg prime-origins DBG(1)[2305]> PkgConfig: loading repositories in /etc/pkg/ DBG(1)[2305]> PKgConfig: loading /etc/pkg//FreeBSD.conf DBG(1)[2305]> PkgConfig: parsing key 'FreeBSD' DBG(1)[2305]> PkgConfig: parsing repository object FreeBSD DBG(1)[2305]> PkgConfig: loading repositories in /usr/local/etc/pkg/repos/ DBG(1)[2305]> PKgConfig: loading /usr/local/etc/pkg/repos//FreeBSD.conf DBG(1)[2305]> PkgConfig: parsing key 'FreeBSD' DBG(1)[2305]> PkgConfig: overwriting repository FreeBSD DBG(1)[2305]> PkgConfig: parsing repository object FreeBSD DBG(1)[2305]> PKgConfig: loading /usr/local/etc/pkg/repos//kmods.conf DBG(1)[2305]> PkgConfig: parsing key 'FreeBSD-kmods' DBG(1)[2305]> PkgConfig: parsing repository object FreeBSD-kmods DBG(4)[2305]> Pkgdb: running: 'PRAGMA user_version;' DBG(4)[2305]> Pkgdb: executing 'PRAGMA foreign_keys =3D ON;' DBG(4)[2305]> Pkgdb: executing 'PRAGMA mmap_size=3D268435456;' DBG(4)[2305]> Pkgdb: running: 'WITH flavors AS (SELECT package_id, value.annotation AS flavor FROM pkg_annotation LEFT JOIN annotation tag = ON pkg_annotation.tag_id =3D tag.annotation_id LEFT JOIN annotation value ON pkg_annotation.value_id =3D value.annotation_id WHERE tag.annotation =3D 'flavor') SELECT DISTINCT(p.id), origin, p.name, p.name as uniqueid,=20=20= =20 version, comment, desc, message, arch, maintainer, www, prefix, flats= ize, licenselogic, automatic, locked, time, manifestdigest, vital FROM packages AS p LEFT JOIN pkg_categories ON p.id =3D pkg_categories.packag= e_id=20=20 LEFT JOIN categories ON categories.id =3D pkg_categories.category_id=20=20= =20=20 LEFT JOIN flavors ON flavors.package_id =3D p.id WHERE (p.name =3D '|'= COLLATE NOCASE OR p.name || '-' || version =3D '|' COLLATE NOCASE) AND (automatic= =3D0) ORDER BY p.name;' DBG(4)[2305]> Pkgdb: running: 'WITH flavors AS (SELECT package_id, value.annotation AS flavor FROM pkg_annotation LEFT JOIN annotation tag = ON pkg_annotation.tag_id =3D tag.annotation_id LEFT JOIN annotation value ON pkg_annotation.value_id =3D value.annotation_id WHERE tag.annotation =3D 'flavor') SELECT DISTINCT(p.id), origin, p.name, p.name as uniqueid,=20=20= =20 version, comment, desc, message, arch, maintainer, www, prefix, flats= ize, licenselogic, automatic, locked, time, manifestdigest, vital FROM packages AS p LEFT JOIN pkg_categories ON p.id =3D pkg_categories.packag= e_id=20=20 LEFT JOIN categories ON categories.id =3D pkg_categories.category_id LE= FT JOIN flavors ON flavors.package_id =3D p.id WHERE (p.name =3D 'sort' C= OLLATE NOCASE OR p.name || '-' || version =3D 'sort' COLLATE NOCASE) AND (automati= c=3D0) ORDER BY p.name;' DBG(4)[2305]> Pkgdb: running: 'WITH flavors AS (SELECT package_id, value.annotation AS flavor FROM pkg_annotation LEFT JOIN annotation tag = ON pkg_annotation.tag_id =3D tag.annotation_id LEFT JOIN annotation value ON pkg_annotation.value_id =3D value.annotation_id WHERE tag.annotation =3D 'flavor') SELECT DISTINCT(p.id), origin, p.name, p.name as uniqueid,=20=20= =20 version, comment, desc, message, arch, maintainer, www, prefix, flats= ize, licenselogic, automatic, locked, time, manifestdigest, vital FROM packages AS p LEFT JOIN pkg_categories ON p.id =3D pkg_categories.packag= e_id=20=20 LEFT JOIN categories ON categories.id =3D pkg_categories.category_id LE= FT JOIN flavors ON flavors.package_id =3D p.id WHERE (p.name =3D '-u' COL= LATE NOCASE OR p.name || '-' || version =3D '-u' COLLATE NOCASE) AND (automatic= =3D0) ORDER BY p.name;' [4->1<] # --- Combining the 'core' of prime-origins with the pipe used outside of the ali= as works fine: [20-0] # pkg alias ppp ppp 'query -e '%a =3D 0' '%o'' [21-0] # pkg ppp | sort -u misc/freebsd-doc-nl x11/xorg [22-0] # --=20 You are receiving this mail because: You are the assignee for the bug.=