Re: [EXTERNAL] Re: COALESCE() does not short-circuit sometimes

[email protected] Wed, 11 Mar 2020 14:24:17 -0400
Newsgroups	gmane.comp.db.sqlite.general
Message-ID	<CAFkD5vtf9cKZtascqD3hJG3q1UT+6rW018MtMuQaNrGrf1380Q@mail.gmail.com>
SSByZWNlbnRseSB0cmllZCB1c2luZyBDb2FsZXNjZSgpIHRvIGNoZWNrIGV4aXN0ZW5jZSBvZiBh
IGNvbHVtbiBuYW1lLgpTRUxFQ1QgRElTVElOQ1QgQ09BTEVTQ0UoKFNFTEVDVCAnQUNvbHVtblRo
YXREb2VzTm90RXhpc3QnIEZST00gVEQpLCAtOTk5KQpGUk9NIFREOwpCdXQsIHRoZSBTUUwgZXJy
b3IgY29kZSBkb21pbmF0ZXM/ICJubyBzdWNoIGNvbHVtbjogQUNvbHVtblRoYXREb2VzTm90RXhp
c3QiCkhhZCB0byByZXNvcnQgdG86ClNFTEVDVCBuYW1lIEZST00gcHJhZ21hX3RhYmxlX2luZm8o
J1REJykgV0hFUkUgbmFtZSA9CidBQ29sdW1uVGhhdERvZXNOb3RFeGlzdCc7CkFuZCBvZGRseSwg
cHJhZ21hX3RhYmxlX2luZm8oKSBmYWlscyBiZWxvdyBpZiB0aGUgVGFibGUgVEQgaXMgdW5hZG9y
bmVkPwpTRUxFQ1QgbmFtZSBGUk9NIHByYWdtYV90YWJsZV9pbmZvKFREKSBXSEVSRSBuYW1lID0K
J0FDb2x1bW5UaGF0RG9lc05vdEV4aXN0JzsKCk9uIFdlZCwgTWFyIDExLCAyMDIwIGF0IDI6MjAg
UE0gUmljaGFyZCBIaXBwIDxkcmhAc3FsaXRlLm9yZz4gd3JvdGU6Cgo+IE9uIDMvMTEvMjAsIEhp
Y2sgR3VudGVyIDxoaWNrQHNjaWdhbWVzLmF0PiB3cm90ZToKPiA+IFdoaWxlIE9SQUNMRSBkb2Vz
IHN0YXRlIHRoYXQgQ09BTEVTQ0Ugd2lsbCBzaG9ydCBjaXJjdWl0LAo+Cj4gQSBzaW1pbGFyIHBy
b2JsZW0gd2FzIHJlcG9ydGVkIG9uIGEgdGlja2V0IGhlcmU6Cj4gaHR0cHM6Ly93d3cuc3FsaXRl
Lm9yZy9zcmMvdGt0dmlldz9uYW1lPTNjOWVhZGQyYTYgIChUaGUgcHJvYmxlbQo+IHJlcG9ydGVk
IG9uIHRoYXQgdGlja2V0IG1pZ2h0IG5vdCBzZWVtIHRvIGJlIHRoZSBzYW1lIGF0IGZpcnN0IGds
YW5jZSwKPiBidXQgZGVlcCBkb3duIHRoZXkgYXJlIGJvdGggdGhlIHNhbWUgaXNzdWUuKQo+Cj4g
SSBoYXZlIGEgcGF0Y2ggdG8gZml4IHRoZSBwcm9ibGVtIG9uIGEgYnJhbmNoCj4gKGh0dHBzOi8v
d3d3LnNxbGl0ZS5vcmcvc3JjL3RpbWVsaW5lP3I9ZG8tbm90LWZhY3Rvci1mdW5jdGlvbnMpIHdo
aWNoCj4geW91IGNhbiBleHBlcmltZW50IHdpdGguIE1vcmUgY2hhbmdlcyBhbmQgYW5hbHlzaXMg
YXJlIG5lZWRlZCBwcmlvciB0bwo+IGxhbmRpbmcgb24gdHJ1bmsuICBJIGNhbm5vdCBndWFyYW50
ZWUgdGhhdCBzdWNoIGEgbGFuZGluZyB3aWxsIGluIGZhY3QKPiBvY2N1ciwgdGhvdWdoIGl0IHNl
ZW1zIG1vcmUgbGlrZWx5IHRoYW4gbm90IGF0IHRoaXMgcG9pbnQuCj4KPiAtLQo+IEQuIFJpY2hh
cmQgSGlwcAo+IGRyaEBzcWxpdGUub3JnCj4gX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX19fX18KPiBzcWxpdGUtdXNlcnMgbWFpbGluZyBsaXN0Cj4gc3FsaXRlLXVz
ZXJzQG1haWxpbmdsaXN0cy5zcWxpdGUub3JnCj4gaHR0cDovL21haWxpbmdsaXN0cy5zcWxpdGUu
b3JnL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxpdGUtdXNlcnMKPgpfX19fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpzcWxpdGUtdXNlcnMgbWFpbGluZyBs
aXN0CnNxbGl0ZS11c2Vyc0BtYWlsaW5nbGlzdHMuc3FsaXRlLm9yZwpodHRwOi8vbWFpbGluZ2xp
c3RzLnNxbGl0ZS5vcmcvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3NxbGl0ZS11c2Vycwo=