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

Richard Hipp <[email protected]> Wed, 11 Mar 2020 14:19:58 -0400
Newsgroups gmane.comp.db.sqlite.general
Message-ID <CALwJ=MyUsVw+6hSnXb2Dkkz52V+7XoNiCpeua_wGdB7Su1536Q@mail.gmail.com>
T24gMy8xMS8yMCwgSGljayBHdW50ZXIgPGhpY2tAc2NpZ2FtZXMuYXQ+IHdyb3RlOgo+IFdoaWxl
IE9SQUNMRSBkb2VzIHN0YXRlIHRoYXQgQ09BTEVTQ0Ugd2lsbCBzaG9ydCBjaXJjdWl0LAoKQSBz
aW1pbGFyIHByb2JsZW0gd2FzIHJlcG9ydGVkIG9uIGEgdGlja2V0IGhlcmU6Cmh0dHBzOi8vd3d3
LnNxbGl0ZS5vcmcvc3JjL3RrdHZpZXc/bmFtZT0zYzllYWRkMmE2ICAoVGhlIHByb2JsZW0KcmVw
b3J0ZWQgb24gdGhhdCB0aWNrZXQgbWlnaHQgbm90IHNlZW0gdG8gYmUgdGhlIHNhbWUgYXQgZmly
c3QgZ2xhbmNlLApidXQgZGVlcCBkb3duIHRoZXkgYXJlIGJvdGggdGhlIHNhbWUgaXNzdWUuKQoK
SSBoYXZlIGEgcGF0Y2ggdG8gZml4IHRoZSBwcm9ibGVtIG9uIGEgYnJhbmNoCihodHRwczovL3d3
dy5zcWxpdGUub3JnL3NyYy90aW1lbGluZT9yPWRvLW5vdC1mYWN0b3ItZnVuY3Rpb25zKSB3aGlj
aAp5b3UgY2FuIGV4cGVyaW1lbnQgd2l0aC4gTW9yZSBjaGFuZ2VzIGFuZCBhbmFseXNpcyBhcmUg
bmVlZGVkIHByaW9yIHRvCmxhbmRpbmcgb24gdHJ1bmsuICBJIGNhbm5vdCBndWFyYW50ZWUgdGhh
dCBzdWNoIGEgbGFuZGluZyB3aWxsIGluIGZhY3QKb2NjdXIsIHRob3VnaCBpdCBzZWVtcyBtb3Jl
IGxpa2VseSB0aGFuIG5vdCBhdCB0aGlzIHBvaW50LgoKLS0gCkQuIFJpY2hhcmQgSGlwcApkcmhA
c3FsaXRlLm9yZwpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f
XwpzcWxpdGUtdXNlcnMgbWFpbGluZyBsaXN0CnNxbGl0ZS11c2Vyc0BtYWlsaW5nbGlzdHMuc3Fs
aXRlLm9yZwpodHRwOi8vbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcvY2dpLWJpbi9tYWlsbWFuL2xp
c3RpbmZvL3NxbGl0ZS11c2Vycwo=