Re: COALESCE() does not short-circuit sometimes
Justin Ng <[email protected]> Wed, 11 Mar 2020 19:16:36 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <e3d649c1cfde42228bad24fec0530599DM6PR06MB62666469B3B29AD977153D88CFFC0@DM6PR06MB6266.namprd06.prod.outlook.com> |
PiBJdCBpcyBub3QgYSAiaGFjayIgYmVjYXVzZSBpdCBkb2VzIG5vdCB3b3JrLiAgSXQgaXMgd2hh dCBpcyBjYWxsZWQgYSAiZmFpbGVkIGF0dGVtcHQiIGF0IGEgaGFjay4KClllYWgsIHRoZSBBQlMo KSBoYWNrIGRvZXMgbm90IHdvcmsuCgpXaGljaCBsZWQgbWUgdG8gdXNlIGAoU0VMRUNUIFNVTSg5 MjIzMzcyMDM2ODU0Nzc1ODA3KSBGUk9NIChTRUxFQ1QgTlVMTCBVTklPTiBBTEwgU0VMRUNUIE5V TEwpKWAKd2hpY2ggKipkb2VzKiogd29yay4KCj4gSG93ZXZlciwgeW91ciBhc3Nlc3NtZW50IHRo YXQgY29hbGVzY2UgaXMgbm90ICJzaG9ydC1jaXJjdWl0aW5nIiBpcyBpbmNvcnJlY3QuCj4gSWYg eCBpcyBub3QgbnVsbCwgdGhlbiB4IGlzIHJldHVybmVkIGFuZCB0aGUgY29uc3RhbnQgZXhwcmVz c2lvbiBpcyBub3QgcmV0dXJuZWQuCj4gSWYgdGhlIGNvbnN0YW50IGV4cHJlc3Npb24gd2VyZSBh IGNvcnJlbGF0ZWQgZXhwcmVzc2lvbiwgdGhlbiBpdCB3b3VsZCBub3QgYmUgZXZhbHVhdGVkIGlu IHRoZSBjYW5kaWRhdGUgY29udGV4dC4KPiBJZiB4IHdlcmUgbnVsbCBhbmQgdGhlIGV4cHJlc3Np b24gd2FzIG5vdCBjb25zdGFudCAoYW5kIHRodXMgcmVxdWlyZWQgZXZhbHVhdGlvbikKPiB0aGVu IGl0IHdvdWxkIGJlIGV2YWx1YXRlZCB3aXRoaW4gdGhlIGN1cnJlbnQgY29udGV4dCBhbmQgaXRz IHJlc3VsdCByZXR1cm5lZC4KPgo+IFRoZSBkb2N1bWVudGF0aW9uIERPRVMgTk9UIHNheSB0aGF0 IHRoZSBhcmd1bWVudHMgdG8gY29hbGVzY2Ugd2lsbCBub3QgYmUgZXZhbHVhdGVkLCBtZXJlbHkg dGhhdCB0aGUgZmlyc3Qgb25lIHRoYXQgaXMgbm90LW51bGwgd2lsbCBiZSByZXR1cm5lZC4KPgo+ IGh0dHBzOi8vc3FsaXRlLm9yZy9sYW5nX2NvcmVmdW5jLmh0bWwjY29hbGVzY2UKCllvdSdyZSBy aWdodCB0aGF0IHRoZSBkb2N1bWVudGF0aW9uIGRvZXNuJ3Qgc2F5IHNvLgoKSSBkaWQgYXNzdW1l IENPQUxFU0NFKCkgd291bGQgYWx3YXlzIHNob3J0LWNpcmN1aXQgYmVjYXVzZSB0aGUgU1FMIHN0 YW5kYXJkIHNheXMgQ09BTEVTQ0UoKSBpcwplcXVpdmFsZW50IHRvIENBU0UgZXhwcmVzc2lvbnMu CgpBbmQgSSB3YXMgcHJldHR5IHN1cmUgQ0FTRSBleHByZXNzaW9ucyBzaG91bGQgYWx3YXlzIHNo b3J0LWNpcmN1aXQuCgpIb3dldmVyLCB0dXJucyBvdXQsIENBU0UgZXhwcmVzc2lvbnMgZG9uJ3Qg YWx3YXlzIHNob3J0LWNpcmN1aXQsIGVpdGhlci4gVGhleSBnZW5lcmFsbHkgZG8gc2hvcnQtY2ly Y3VpdCBidXQgdGhlcmUgYXJlIGVkZ2UgY2FzZXMgd2hlcmUgdGhleSBkb24ndC4gSXQgaXNuJ3Qg ZW50aXJlbHkgaW50dWl0aXZlIHRvIG1lIHdoYXQgdGhlIGNvbmRpdGlvbnMgYXJlLCB0aG91Z2gu CgpTbywgSSBndWVzcyBJIGxlYXJuZWQgc29tZXRoaW5nIG5ldyB0b2RheS4KCj4gPiBTb21ldGhp bmcgbGlrZSBUSFJPV19JRl9OVUxMKHgpCj4KPiBZb3UgY291bGQgY2VydGFpbmx5IHdyaXRlIGEg ZnVuY3Rpb24gdGhhdCBkaWQgdGhhdC4gIEl0IHdvdWxkIGNlcnRhaW5seSBiZSBiZXR0ZXIgdGhh biBhICJoYWNrIiB0aGF0IGRvZXMgbm90IGV2ZW4gd29yay4KCkknZCByYXRoZXIga2VlcCB0aGUg aGFjayB0aGF0IGRvZXMgd29yayB0aGFuIHVzZSBhIHVzZXItZGVmaW5lZCBmdW5jdGlvbiwgaWYg SSBjYW4gaGVscCBpdC4KCkkgZmVlbCBsaWtlIHVzZXItZGVmaW5lZCBmdW5jdGlvbnMgc2hvdWxk IGJlIGEgbGFzdCByZXNvcnQuCgpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fXwpzcWxpdGUtdXNlcnMgbWFpbGluZyBsaXN0CnNxbGl0ZS11c2Vyc0BtYWlsaW5n bGlzdHMuc3FsaXRlLm9yZwpodHRwOi8vbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcvY2dpLWJpbi9t YWlsbWFuL2xpc3RpbmZvL3NxbGl0ZS11c2Vycwo=