Re: COALESCE() does not short-circuit sometimes
Jay Kreibich <jay-m2zl/UuQNF/[email protected]> Wed, 11 Mar 2020 14:53:24 -0500
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
Cj4gT24gTWFyIDExLCAyMDIwLCBhdCAyOjE2IFBNLCBKdXN0aW4gTmcgPGp1c3Rpbi5uZy4xOTk0 QG91dGxvb2suY29tPiB3cm90ZToKPiAKPiBUaGV5IGdlbmVyYWxseSBkbyBzaG9ydC1jaXJjdWl0 IGJ1dCB0aGVyZSBhcmUgZWRnZSBjYXNlcyB3aGVyZSB0aGV5IGRvbid0LiBJdCBpc24ndCBlbnRp cmVseSBpbnR1aXRpdmUgdG8gbWUgd2hhdCB0aGUgY29uZGl0aW9ucyBhcmUsIHRob3VnaC4KPiAK CgoiQUJTKC05MjIzMzcyMDM2ODU0Nzc1ODA4KSIgaXMgYSBjb25zdGFudCBleHByZXNzaW9uLCBh bmQgYXMgc3VjaCwgaXQgbWFrZXMgc2Vuc2UgdGhhdCBpdCBpcyBldmFsdWF0ZSBkdXJpbmcgdGhl IHBhcnNlL3ByZXBhcmUgcGhhc2Ugb2YgdGhlIHByb2Nlc3NpbmcsIG5vdCB0aGUgZXhlY3V0aW9u LiAgVGhlcmUgYXJlIHNpbWlsYXIgcHJvYmxlbXMgaW4gbW9yZSB0cmFkaXRpb25hbCBsYW5ndWFn ZXMgKGVzcGVjaWFsbHkgc2NyaXB0aW5nIGxhbmd1YWdlcykgdGhhdCBhdHRlbXB0IHRvIG9wdGlt aXplIG91dCBvciBwcmUtY29tcHV0ZSBjb25zdGFudCBleHByZXNzaW9ucy4KCklmIHRoYXTigJlz IHRoZSBjYXNlLCB0aGVuIHRoZSBpc3N1ZSBpcyBub3Qgc28gbXVjaCB0aGF0IHRoZSBDT0FMRVND RSgpIGlzIGZhaWxpbmcgdG8gc2hvcnQtY2lyY3VpdCwgYnV0IHJhdGhlciB0aGFuIHRoZSBTUUwg c3RhdGVtZW50IGZhaWxpbmcgdG8g4oCcY29tcGlsaW5n4oCdIGFuIGludmFsaWQgc3RhdGVtZW50 LgoKSWYgeW914oCZcmUgZG9pbmcgdGhpcyBpbiBjb2RlIGFzIHNlcGFyYXRlIHByZXBhcmUvc3Rl cC9maW5hbGl6ZSwgaXQgd291bGQgYmUgaW50ZXJlc3RpbmcgdG8gc2VlIHdoZXJlIGl0IGZhaWxz LiAgTXkgZ3Vlc3MgaXMgcHJlcGFyZSwgbm90IHN0ZXAuCgogIC1qCgpfX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpzcWxpdGUtdXNlcnMgbWFpbGluZyBsaXN0 CnNxbGl0ZS11c2Vyc0BtYWlsaW5nbGlzdHMuc3FsaXRlLm9yZwpodHRwOi8vbWFpbGluZ2xpc3Rz LnNxbGl0ZS5vcmcvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3NxbGl0ZS11c2Vycwo=