Re: COALESCE() does not short-circuit sometimes

Justin Ng <[email protected]> Wed, 11 Mar 2020 15:24:19 +0000

Newsgroups	gmane.comp.db.sqlite.general
Message-ID	<DM6PR06MB6266732247E32C75787DBD3FCFFC0@DM6PR06MB6266.namprd06.prod.outlook.com>

PiBXaHkgZG8geW91IHRoaW5rIHRoYXQgdGhhdCBpdCBzaG91bGQgbm90IGV2YWx1YXRlIEFCUz8g
IEl0IGlzIHRoZXJlIGFuZCB5b3UgYXNrZWQgZm9yIGl0LiAgSSBiZWxpZXZlIGl0J3MgYSBnb29k
IGlkZWEgdG8gc2F5LCAiaGV5LCB0aGUgYW1vdW50IHlvdSBwbGFjZWQgaGVyZSBpcyBvdXQgb2Yg
Ym91bmRhcnksIHRoaW5rIGFib3V0IHdoYXQgeW91IGFyZSBkb2luZyBoZXJlLiIgSU1PLCBvZiBj
b3Vyc2UuIFRoYW5rcy4KPgo+IGpvc8OpCgpTb21ldGltZXMsIHdoZW4gcXVlcnlpbmcgZGF0YSwg
cmF0aGVyIHRoYW4gbGV0dGluZyBOVUxMcyBwcm9wYWdhdGUsCml0IG1pZ2h0IGJlIGJldHRlciB0
byB0aHJvdyBhbiBlcnJvciBpZiBOVUxMcyBhcmUgbm90IGV4cGVjdGVkIGZyb20gYW4gZXhwcmVz
c2lvbi4KClRoZSBwcmVzZW5jZSBvZiBOVUxMcyBtaWdodCBpbmRpY2F0ZSBhbiBlcnJvciBpbiBs
b2dpYywgZGF0YSwgb3IgYm90aC4KClNvLCB0aGUgQ09BTEVTQ0UoeCwgQUJTKC05MjIzMzcyMDM2
ODU0Nzc1ODA4KSkgY29uc3RydWN0IGlzIGEgaGFjayB0byBzYW5pdHktY2hlY2sgcXVlcmllcy4K
ClNvbWV0aGluZyBsaWtlIFRIUk9XX0lGX05VTEwoeCkKX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX18Kc3FsaXRlLXVzZXJzIG1haWxpbmcgbGlzdApzcWxpdGUt
dXNlcnNAbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcKaHR0cDovL21haWxpbmdsaXN0cy5zcWxpdGUu
b3JnL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxpdGUtdXNlcnMK