Re: COALESCE() does not short-circuit sometimes
Jose Isaias Cabrera <[email protected]> Wed, 11 Mar 2020 12:38:14 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <VI1P195MB06545F03A24D50DD2785AC2BDEFC0@VI1P195MB0654.EURP195.PROD.OUTLOOK.COM> |
Ckp1c3RpbiBOZywgb24gV2VkbmVzZGF5LCBNYXJjaCAxMSwgMjAyMCAwNzowMyBBTSwgd3JvdGUu Li4KPgo+IFRoaXMgaGFwcGVucyBpbiBTUUxpdGUgMy4yOCBhbmQgMy4zMS4KPgo+IENvbnNpZGVy IHRoZSBmb2xsb3dpbmcgcXVlcmllcywKPgo+IC0tIFF1ZXJ5IDEKPiBTRUxFQ1QKPiAgIENPQUxF U0NFKAo+ICAgICBOVUxMLAo+IChTRUxFQ1QgU1VNKDkyMjMzNzIwMzY4NTQ3NzU4MDcpIEZST00g KFNFTEVDVCBOVUxMIFVOSU9OIEFMTCBTRUxFQ1QKPiBOVUxMKSkKPiAgICk7CgpPbiAzLjI0LjAs IHRoaXMgd29ya2VkIGNvcnJlY3RseToKIDg6MzI6MjAuNTY+c3FsaXRlMwpTUUxpdGUgdmVyc2lv biAzLjI0LjAgMjAxOC0wNi0wNCAxOToyNDo0MQpFbnRlciAiLmhlbHAiIGZvciB1c2FnZSBoaW50 cy4KQ29ubmVjdGVkIHRvIGEgdHJhbnNpZW50IGluLW1lbW9yeSBkYXRhYmFzZS4KVXNlICIub3Bl biBGSUxFTkFNRSIgdG8gcmVvcGVuIG9uIGEgcGVyc2lzdGVudCBkYXRhYmFzZS4Kc3FsaXRlPiBT RUxFQ1QKICAgLi4uPiAgIENPQUxFU0NFKAogICAuLi4+ICAgICBOVUxMLAogICAuLi4+ICAgICAo U0VMRUNUIFNVTSg5MjIzMzcyMDM2ODU0Nzc1ODA3KSBGUk9NIChTRUxFQ1QgTlVMTCBVTklPTiBB TEwgU0VMRUNUIE5VTEwpKQogICAuLi4+ICAgKTsKRXJyb3I6IGludGVnZXIgb3ZlcmZsb3cKCgo+ IC0tIFF1ZXJ5IDIKPiBTRUxFQ1QKPiAgIENPQUxFU0NFKAo+ICAgICAoU0VMRUNUICdoZWxsbycp LAo+IChTRUxFQ1QgU1VNKDkyMjMzNzIwMzY4NTQ3NzU4MDcpIEZST00gKFNFTEVDVCBOVUxMIFVO SU9OIEFMTCBTRUxFQ1QKPiBOVUxMKSkKPiAgICk7CgpBbHNvLCBvbiAzLjI0LjAuIHRoaXMgd29y a2VkIGNvcnJlY3RseToKc3FsaXRlPiBTRUxFQ1QKICAgLi4uPiAgIENPQUxFU0NFKAogICAuLi4+ ICAgICAoU0VMRUNUICdoZWxsbycpLAogICAuLi4+ICAgICAoU0VMRUNUIFNVTSg5MjIzMzcyMDM2 ODU0Nzc1ODA3KSBGUk9NIChTRUxFQ1QgTlVMTCBVTklPTiBBTEwgU0VMRUNUIE5VTEwpKQogICAu Li4+ICAgKTsKaGVsbG8KCj4gLS0gUXVlcnkgMwo+IFNFTEVDVAo+ICAgQ09BTEVTQ0UoCj4gICAg IChTRUxFQ1QgJ2hlbGxvJyksCj4gICAgIEFCUygtOTIyMzM3MjAzNjg1NDc3NTgwOCkKPiAgICk7 CgpUaGlzIG9uZSwgYWJvdmUsIHdhcyBiYWQgYXQgMy4yNC4wIGFsc28uCnNxbGl0ZT4gU0VMRUNU CiAgIC4uLj4gICBDT0FMRVNDRSgKICAgLi4uPiAgICAgKFNFTEVDVCAnaGVsbG8nKSwKICAgLi4u PiAgICAgQUJTKC05MjIzMzcyMDM2ODU0Nzc1ODA4KQogICAuLi4+ICAgKTsKRXJyb3I6IGludGVn ZXIgb3ZlcmZsb3cKCj4gUXVlcnkgMSBzaG91bGQgdGhyb3cgYGludGVnZXIgb3ZlcmZsb3dgLgo+ IFF1ZXJ5IDIgc2hvdWxkIHJldHVybiAnaGVsbG8nLgo+IFF1ZXJ5IDMgc2hvdWxkIHJldHVybiAn aGVsbG8nLgo+Cj4gSG93ZXZlciwgUXVlcnkgMyB0aHJvd3MgYGludGVnZXIgb3ZlcmZsb3dgLiBJ dCBzaG91bGQgc2hvcnQtY2lyY3VpdCBhbmQKPiBub3QgZXZhbHVhdGUgQUJTKCkKCldoeSBkbyB5 b3UgdGhpbmsgdGhhdCB0aGF0IGl0IHNob3VsZCBub3QgZXZhbHVhdGUgQUJTPyAgSXQgaXMgdGhl cmUgYW5kIHlvdSBhc2tlZCBmb3IgaXQuICBJIGJlbGlldmUgaXQncyBhIGdvb2QgaWRlYSB0byBz YXksICJoZXksIHRoZSBhbW91bnQgeW91IHBsYWNlZCBoZXJlIGlzIG91dCBvZiBib3VuZGFyeSwg dGhpbmsgYWJvdXQgd2hhdCB5b3UgYXJlIGRvaW5nIGhlcmUuIiBJTU8sIG9mIGNvdXJzZS4gVGhh bmtzLgoKam9zw6kKX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X18Kc3FsaXRlLXVzZXJzIG1haWxpbmcgbGlzdApzcWxpdGUtdXNlcnNAbWFpbGluZ2xpc3RzLnNx bGl0ZS5vcmcKaHR0cDovL21haWxpbmdsaXN0cy5zcWxpdGUub3JnL2NnaS1iaW4vbWFpbG1hbi9s aXN0aW5mby9zcWxpdGUtdXNlcnMK