DMARC-Filter: OpenDMARC Filter v1.4.2 delorie.com 52ONINLO2456324
Authentication-Results: delorie.com; dmarc=pass (p=none dis=none) header.from=cygwin.com
Authentication-Results: delorie.com; spf=pass smtp.mailfrom=cygwin.com
DKIM-Filter: OpenDKIM Filter v2.11.0 delorie.com 52ONINLO2456324
Authentication-Results: delorie.com;
	dkim=pass (1024-bit key, unprotected) header.d=cygwin.com header.i=@cygwin.com header.a=rsa-sha256 header.s=default header.b=Tm2S3iQB
X-Recipient: archive-cygwin@delorie.com
DKIM-Filter: OpenDKIM Filter v2.11.0 sourceware.org A1BD03858C2D
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cygwin.com;
	s=default; t=1742858301;
	bh=heeTZWJndmhMyw1oxUpXFTMHgkeRFMYxi5p+JdeQ/lg=;
	h=Date:To:Subject:List-Id:List-Unsubscribe:List-Archive:List-Post:
	 List-Help:List-Subscribe:From:Reply-To:From;
	b=Tm2S3iQBuFMJQvlMCajYxv7KakgqztrXZXkg0oFINhX76bH1s4gPstaY8xRdWJMdU
	 mjQdcSt3kz4kKrgR0gCmpVF0vzSg0rk2l+VYcQZoF14qT+OdqKWyiMoDHjQkVm62F/
	 epAVbfglNGsGOfOjmnIFGXyJGZ1Jg0VUf+sR6+dQ=
X-Original-To: cygwin@cygwin.com
Delivered-To: cygwin@cygwin.com
DMARC-Filter: OpenDMARC Filter v1.4.2 sourceware.org 6C6E63857838
ARC-Filter: OpenARC Filter v1.0.0 sourceware.org 6C6E63857838
ARC-Seal: i=1; a=rsa-sha256; d=sourceware.org; s=key; t=1742858113; cv=none;
 b=mtpUAeN1BvUdiY8FTvT02/v5S6McvmGBLdqQ7WF5kvSezdWYqsPNVwY38jAIFBLGlxiTlADNBw5VPJrqKlnF/Ui6HCUnfaI9SjHsRyxXo/dsFVfwMqsm2zbfUfCa8XrtvijNXkApqTwJ74COikMoOT+wU0VnrtMuqb442UOyPgs=
ARC-Message-Signature: i=1; a=rsa-sha256; d=sourceware.org; s=key;
 t=1742858113; c=relaxed/simple;
 bh=ZOUXoErcQZ4rFGGhel5r37TbYQG3ythg6nbK3I8NDIQ=;
 h=DKIM-Signature:Message-ID:Date:MIME-Version:To:From:Subject;
 b=xJHXc+LQKR6xaqh1jWO57RZCofZm+dhSzJF2lR7tvQBgisra31G7kdodqExS3PAdZuM1LO6uxSFqtqEvx0qnkARemDw97+My3mcwFlnLkrEq4971LWeUpd9k99XkCLm/WRSvrTYB59Pfs+rgfAPi2X4JlpvdSyIAMI0mQ/7YPZ4=
ARC-Authentication-Results: i=1; server2.sourceware.org
DKIM-Filter: OpenDKIM Filter v2.11.0 sourceware.org 6C6E63857838
X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a
Message-ID: <739d9722-f031-4981-9398-78b75d4ea2c6@gmx.de>
Date: Tue, 25 Mar 2025 00:15:11 +0100
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Content-Language: en-US
To: cygwin <cygwin@cygwin.com>
Subject: sqlite 3.49.1-1 package bug changing return types signedness
Autocrypt: addr=matthias.andree@gmx.de; keydata=
 xsFNBFXwq5cBEADQxc9JeK4yqt1BX5tOMfzyIfEyBWXix0xqeAA/HQ2wd31NFcGFEbAevDsG
 oO7UcYQji1Gj/TggmclV37SHPDE++bU7O6Wur57FfTsVCmS6XjHj/n2qXgxrWtU7Fv9YOBz/
 wNge3sGAh2xbwh5dTt+Ew6TbuMbwXNonb4WUCo6yFMrDd2vg9RqcVSDpdLFO0JI9hNGLQDtH
 P2TbBfGj8V5qz9NFiGzRxmmFhMzqOSDCEs9uanr3TCLq7yZFTyAmXDCZuyFhxGwHDo6jB+9L
 bIprA/oH0uFol899hiIrZRm7kIAYsOSvp84x0XBFvSMoDY4ZA4Ucv3xk+aDqob0V5F4+W3Vg
 7bdlpbAuwov944Zawbm/sBGctNbfNeWjc+L7F43PbghzCfk6aLH0LwH3lNiu76F57lJqfTCn
 kBd0V0dUZ0/AJFskZu+aO/dCVkbfjotXDqsh55kBrSMsRX/rqt2d43q6o9AyWu5aMqLAG2ZN
 19qLu/a1vzbMEfRaimlFSo9LMY1jf5TcUc7mNlPDhm8c6o+Ivx/D0tSQ4V+3SqbroYgHo1A4
 Qyiau4sEP2YFtKbdRdpaN7WsdfdaZmrd9xa5lvp/gQZEdpLPzL0aBDEeUzaL/nee/EDQUbPu
 SYJCmDNyqxs/Y4j0ZGQmIPT1CY34AvdjIcLuT/BG1JZaIlKQ9QARAQABzShNYXR0aGlhcyBB
 bmRyZWUgPG1hdHRoaWFzLmFuZHJlZUBnbXguZGU+wsGUBBMBCgA+AhsDBQsJCAcDBRUKCQgL
 BRYCAwEAAh4BAheAFiEE3EplW9mTzUhx+oIQ5BKxVu/zhVoFAmZEAJQFCRX2730ACgkQ5BKx
 Vu/zhVoGfw/+NgdzCNX0Ma0brluHknO1fnntek35mQFOqNMOWDguIlW58z0Z4EHV1tJFPbqX
 jnPcUQiyRZ8RZ9eBlQs8qD2Mh6shkYUfwXyxl+ejJQLg5fcWNiZ3w/W5jTlk4R2FUD2w2oEk
 m6I20qxkeSdselTRWej9PvuIBrZSucvGz74xZtXjKr3Qv2G3iMYDneEnSzDZInlApQYPngEH
 MeiW7Jg35Y/91weC4kRsTeJF7XXJoUs1SYt/0LdkmGJouxh53DM9B02SCh3UiS8g3ZpzQVLo
 OKMuWsYkr6BKiBD50MdlEV2Fd7HYU8Ax+yc9YkQbdNXu1MXmg3+Xzgm4HJqZZCyVZqIQGdfT
 O95WYttVAbcihvkoC8nWYezAWWZexTF04PJ+iETirUwA+8TLjkja/kMC7aZV5ScIS6A7dL9a
 DCxRyILwecBwnKwV51dqNlqEvL5xJQ+thOOM5ahdW5h9aTty9KMOnrjf0o+qqiVYEMcnKhDO
 S3K0d78fsY/G5775Dcezx6n/0IRaWPNMF4TAJ5SO/V2odC5mMaYUraubbDupXrI+wMksNzrh
 AeuhgFdNmpVeWpjgSkf+jaMAeG4PbykD+ifZyCW046V6JTSDx0dmopac7kT82MApRr+YCIh+
 /O0zIFIiIWKNwReZplwbeV6QiycA6KhxBBEk8Qjdg6dYfdDOwU0EVfCrlwEQANcm7Ryn0O8l
 Xqblm756GabmqMTOsgikq65vzFZ8bsZOUfZg1bQRkDG6gzw8mVqpAxSnbZCTupEv1mR+rtxL
 Vujrs+LODABBydwYv//Aj4U2/yqoYGko3Cf0zN8GUS5autz6P2XgIUScApOq+PGy/hs5xKW2
 GuXnADbukpqdSweBaC5zCTiUB3VDpZNuuXHEBIMG746YxisJ7NwgXFAZ2cybupJQLC3ITHoT
 QIpeBfkdLZAq1XX+k8tKwiSIEZvaH/5q/zMWvbNSEFXHGao/F3t+JZq4ZZVRgM0jn27ZfZrS
 I0sGJFBP5jf+niwQgFe/4PdoidRYdDT9WAMVoSVz85mPaW7/LfRR3vu0h9pNIE/otC2ZxvlP
 dXO0ng6337RG/DlUiMCSKz4k7soBnqflMhb7u+QgL7Tiq44yaw7l/n/VejQ0WjMsEKufxk3n
 wZhHYSgHHrQ8yMMVTUyy8grtIOEPdt/gLYWdXYfZAKnQXhMf4aFVpuLsUbLnRVZyojjhAwj8
 gfinhaq38Vzx15UYLxgLx/o5wrocFq32JB9IDwuWFfdG2dRuXgMGXDgL4Rx9lKPPjmvhjdqH
 2XTtn6WshfBR3KmoYDWG+F4yhok1sWU1G/FgdjRRh55hrz/a2GgEPyZEmylK6tpB1friYmkG
 FkCv2O6UkqJyrJOBREpm6U1LABEBAAHCwXwEGAEKACYCGwwWIQTcSmVb2ZPNSHH6ghDkErFW
 7/OFWgUCZkQAtwUJFfbvoAAKCRDkErFW7/OFWsM+EACzYazhIR3zPhFU7pkPlOaSkgObA8Ht
 klXNjc2D2DHM9dV5FVkx6BW0dqzMYP13ATYePrlp9McFB+1MxAe6WObDbRr3CqFmie4vbxnn
 JS8K1SDy/yyovyA05cXIC9YZtdIlplD6PQFxtiN6j3gArDkfiJ89jwIMj4wou0y7P6Nu2CGd
 C1/ay4jjIqb5e8L37TOgsBrxYlZkYTzxZHT0E10AF2OtkXwN1rzVuJ0wV/8HnrrXA+ZdfjWb
 FZTo1PGez8ODlbMhm36AeL8W+PeBnTttGC7ibHC9gIlIiCTI7GrAv2IwE5d+2MXdx10df34a
 hZkyAxAzGhvm/KB1ADKNHUwRXCkon4l19LTlYpUOpqE4u6z0FisK6icZSHkuvMBitw9//mL1
 hmOKomzpMnhh31Jyihsv0a2MyzRQKmeMfXh5agVl0/QWgoJytgEcsAvvOrCedXssEzzdoZv+
 m9wEVYglslSWVR9TTP1X4ftL86S9gdZcIOLygbzJAttJI0MZ6+XbIhkPSonnfqCtSwwMC9mq
 TXFOelgFGe16RedBTORI3KB0JVSuoswtS1kS3vwFg2fwykd5YzDusMNe2UnUqSBa6ZrMvk4p
 d5tZa9f2Xh3V3DkOuUlBVzGFNj0kdU28JwIBWqi/2tHz0OORk/9+IteGPWYxG0vXoIhRiKbe
 hs+JzQ==
X-Provags-ID: V03:K1:Vt8MWC2L/ZHQIdFiWZocwVJViZW04dMomjLKXUH66zEu+iRSL6L
 kZvO88bEg771TRZEs2EXzCuLyLgJ4k6I/E4zA+oW0aLIzRbG3GcN+r7TYaEH9QY6McT3uM6
 VynpXgOVQrTOCyr/j3eh1oDM8+BzOKhvRB9HJSDH+wwBlNtZcNQxAmr/ZgX1k8ROOA7eMof
 cEirkTAXz7pjndBEQIs1Q==
UI-OutboundReport: notjunk:1;M01:P0:YCHXd2SPBhM=;lt5wTJ8tiRPm70PcyAs6IOHmJSE
 1WnjR8YFZJddEc3INQfHfbG4Ioa9sOQZ67oSNpNpLYadZzUaxKsn/MiPNCAxvzpOFYt54x7PA
 KXMB28AbMVkwVE03l+Tg44Qjj9Oz4lwapAsiw+PTK0stRHWUw58wXGlNwyuGxdOvKUhmiws7y
 hZ8UuNVfW5Hb+KqCPA97Cdk/RnW41d99UXfBQ+mEewG9b+X1F3cFiUNJjA1r98nY3g0RR6MIw
 u/JlY+2x+2eogwiLcqs116l3Px4zGI0cAxnlbAMSl4FT8M41E1ywfvQ6vboAz08NS8qt9EAkX
 pLoVcxll1ezEH1h9pIGen4R/qSWEtEb/QQ655skB0VnBHjRZCP320QEEAexrqtJMwHXgisT5d
 4i8LNEmIRhrOYfg3AHZ+8Bf5BgsbyVoQP1FKhrz1r7Hw+jfeBdli38PzwyGCW1en8hU/F7STe
 ji57LdZC8bN5BR49t8rlRM6SB7HQkInsP8LLq5N9bofgDNlAbncIriAaYdSXb5v/SY0ayutW6
 B7IwEi2rRc1KWOGDWtyaKtuq+myUDjlJ5n9bTq08O6X1WZrYQ8koGVLXYyODcqn85c49pUWCZ
 sgzWqbcTTnFuNBa8bDS0Y6uKNluM4PUjiSWUX2jM3l5QIChhsDU1fGinZyjN8HN9L7Hiha8xq
 MLEROEe4cofWi0WD4rtDeQo1i5cWFKC8VpNmSRD4pZJkVaWGFJ562hQcPnU7iRX13xry4w+oP
 hwSQgpax5LCTMIpzIp9ZZ1/YU0SnIdFJzpB/EpDAg/7drn40B+ma6VssYZwrSm+hAF8iFX1lK
 TWuiwOvcBFSKVPyVu9ceXY0fuMswW3K3Isy13Y62CAm5jn/cSaNlAVvKn9Qemjt+NM8nEQIO/
 9ZtcL6ZOT4p9q01rw7piO0yeg5VMdh29UfWo9AkYDcRM08rLLU5iMLTyHKyey29Ig97rDfBDB
 kF6FYPsFI77DNQobvjXXePH9okLc07zzUEHX8fYJE2omVnE4LDCSH44iIQyvsKndNMffdgsUA
 tpD4EuBLSji057MAvGsV0AQ7VKtIlnY/D1WWc4gxeXMAhtmQ1ynsjwvss2qTWDjFMkmeQ+KC2
 Unnp45ESNxSugdA18mkXRiJZg38Z+clAYxfMm268MUJmX7ISaX+EdB6nYACscZKSTQ68wzSVo
 cr3Klmv2OcWHOon3NFr1eYNiHqOC9UXboZ8q2JbKctH38OoVlXmTE0V0+ygy9OywAJ4kGuJv+
 caPYorKDM3AUW6F1TUfSAPGDn/wpS8qrGifhX6pk172Tux/JQ3T1Q8tzn6UpdPfvtqibCmqQS
 h5hHm9oBCuuxya8Nkf8vuLdwoab9ZbjXuVs76gOg3+19hVjAQn6Yktn3l/TUzdmbeflZuzsOh
 uPIqoTgElq4+0XfzlyFcnaHjxiDzd5UGBlcjp4LRWEKDrl/Yr42AcdnpUTgkLFSqh35k5yzoX
 jRTCvRytqb4yeA7Yr7bfO3X+Ecqo=
X-BeenThere: cygwin@cygwin.com
X-Mailman-Version: 2.1.30
List-Id: General Cygwin discussions and problem reports <cygwin.cygwin.com>
List-Archive: <https://cygwin.com/pipermail/cygwin/>
List-Post: <mailto:cygwin@cygwin.com>
List-Help: <mailto:cygwin-request@cygwin.com?subject=help>
List-Subscribe: <https://cygwin.com/mailman/listinfo/cygwin>,
 <mailto:cygwin-request@cygwin.com?subject=subscribe>
From: Matthias Andree via Cygwin <cygwin@cygwin.com>
Reply-To: Matthias Andree <matthias.andree@gmx.de>
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="us-ascii"; Format="flowed"
Sender: "Cygwin" <cygwin-bounces~archive-cygwin=delorie.com@cygwin.com>

Hi @Jan Nijtmans,

thank you very much for updating the Cygwin package to 3.49.1.

I would like to ask you to stop changing API return types, such as the
one here, where your patch converts the sqlite3_column_bytes return from
int to unsigned int. This is from sqlite3-3.49.1-1's patch

-SQLITE_API int sqlite3_column_bytes(sqlite3_stmt*, int iCol);
-SQLITE_API int sqlite3_column_bytes16(sqlite3_stmt*, int iCol);
+SQLITE_API unsigned int sqlite3_column_bytes(sqlite3_stmt*, int iCol);
+SQLITE_API unsigned int sqlite3_column_bytes16(sqlite3_stmt*, int iCol);

While I appreciate that it would have been adequate if the original
return type had been unsigned int or size_t for that matter, you cannot
change this in a downstream package. This would take sqlite 4.0 to change.

This does break applications! Who would special-case applications
because some downstream packager changed API?

See
https://softwareengineering.stackexchange.com/questions/175253/why-does-an-unsigned-int-compared-with-a-signed-character-turn-out-with-an-unexp
and (C++ based but has the same underlying problem because C++ uses the
same type promotion rules for int-like types):

Useful context also here:
https://flak.tedunangst.com/post/subtraction-is-not-comparison

Please revise the sqlite3 package and make sure its API functions return
the publicly documented return types even if you do not like them or
feel they're wrong because good applications will have adapted.

Thanks in advance.

Best regards,
Matthias


-- 
Problem reports:      https://cygwin.com/problems.html
FAQ:                  https://cygwin.com/faq/
Documentation:        https://cygwin.com/docs.html
Unsubscribe info:     https://cygwin.com/ml/#unsubscribe-simple
