NetBSD Problem Report #59243

From www@netbsd.org  Mon Mar 31 15:52:41 2025
Return-Path: <www@netbsd.org>
Received: from mail.netbsd.org (mail.netbsd.org [199.233.217.200])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
	 key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256
	 client-signature RSA-PSS (2048 bits) client-digest SHA256)
	(Client CN "mail.NetBSD.org", Issuer "mail.NetBSD.org CA" (not verified))
	by mollari.NetBSD.org (Postfix) with ESMTPS id 3E6DA1A9239
	for <gnats-bugs@gnats.NetBSD.org>; Mon, 31 Mar 2025 15:52:41 +0000 (UTC)
Message-Id: <20250331155240.0F5011A923E@mollari.NetBSD.org>
Date: Mon, 31 Mar 2025 15:52:40 +0000 (UTC)
From: campbell+netbsd@mumble.net
Reply-To: campbell+netbsd@mumble.net
To: gnats-bugs@NetBSD.org
Subject: databases/sqlite3: missing test target
X-Send-Pr-Version: www-1.0

>Number:         59243
>Category:       pkg
>Synopsis:       databases/sqlite3: missing test target
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    pkg-manager
>State:          open
>Class:          sw-bug
>Submitter-Id:   net
>Arrival-Date:   Mon Mar 31 15:55:00 +0000 2025
>Closed-Date:    
>Last-Modified:  Tue Apr 01 21:10:12 +0000 2025
>Originator:     Taylor R Campbell
>Release:        current
>Organization:
The Netsqlite3DB Testation
>Environment:
>Description:
databases/sqlite3 has no test target.  How do we test a sqlite3 package?  Maybe we should have a separate databases/sqlite3-th3 package to run the tests at runtime?

https://www.sqlite.org/testing.html
https://www.sqlite.org/th3.html
>How-To-Repeat:
bmake test
>Fix:
Yes, please!

>Release-Note:

>Audit-Trail:
From: Thomas Klausner <wiz@gatalith.at>
To: NetBSD bugtracking <gnats-bugs@NetBSD.org>
Cc: 
Subject: Re: pkg/59243: databases/sqlite3: missing test target
Date: Mon, 31 Mar 2025 18:12:03 +0200

 > https://www.sqlite.org/th3.html

  TH3 License

 SQLite itself is in the public domain and can be used for any purpose. But TH3 is proprietary and requires a license.

 Even though open-source users do not have direct access to TH3, all users of SQLite benefit from TH3 indirectly since each version of SQLite is validated running TH3 on multiple platforms (Linux, Windows, WinRT, Mac, OpenBSD) prior to release. So anyone using an official release of SQLite can deploy their application with the confidence of knowing that it has been tested using TH3. They simply cannot rerun those tests themselves without purchasing a TH3 license.

State-Changed-From-To: open->closed
State-Changed-By: bsiegert@NetBSD.org
State-Changed-When: Tue, 01 Apr 2025 20:46:31 +0000
State-Changed-Why:
As far as I can tell, there is nothing you can do without a TH3 license.


State-Changed-From-To: closed->open
State-Changed-By: riastradh@NetBSD.org
State-Changed-When: Tue, 01 Apr 2025 21:10:12 +0000
State-Changed-Why:
There is still a free software sqlite3 test suite maintained alongside
sqlite3; I was just skimming quickly and didn't link directly to it:

https://www.sqlite.org/testing.html
https://www.sqlite.org/src/dir?ci=trunk&name=test


>Unformatted:

NetBSD Home
NetBSD PR Database Search

(Contact us) $NetBSD: query-full-pr,v 1.47 2022/09/11 19:34:41 kim Exp $
$NetBSD: gnats_config.sh,v 1.9 2014/08/02 14:16:04 spz Exp $
Copyright © 1994-2025 The NetBSD Foundation, Inc. ALL RIGHTS RESERVED.