Re: [EXTERNAL] Re: COALESCE() does not short-circuit sometimes
"Doug" <[email protected]> Thu, 12 Mar 2020 11:36:43 -0700
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
VGhhbmtzLCBSaWNoYXJkLgoKU29tZXRoaW5nIHRyaWdnZXJlZCBtZSB3aGVuIEkgbG9va2VkIGF0 IHRoZSBnZW5lcmF0ZWQgY29kZTogeW91IHVzZSB0aGUgY29udGVudHMgb2YgcmVnaXN0ZXIgMiBm b3IgdGhlIGNvbnN0YW50IHZhbHVlIGVhY2ggdGltZSB0aHJvdWdoIHRoZSBsb29wLiBXaGF0IGlm IHRoZSBzZWxlY3QgbG9va3MgbGlrZSB0aGlzLCB3aXRoIG1vcmUgdGhhbiBvbmUgZnVuY3Rpb24g Y2FsbCBpbiB0aGUgY29hbGVzY2U/IERvIHlvdSBoYW5kbGUgaXQgcHJvcGVybHk/CgpTRUxFQ1Qg Y29hbGVzY2UoYSwgYWJzKDApLCBhYnMoMSksIGFicygyKSkgRlJPTSB0MTsKCkp1c3QgY3VyaW91 cy4uLgpEb3VnCgo+IC0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tCj4gRnJvbTogc3FsaXRlLXVz ZXJzIDxzcWxpdGUtdXNlcnMtYm91bmNlc0BtYWlsaW5nbGlzdHMuc3FsaXRlLm9yZz4KPiBPbiBC ZWhhbGYgT2YgUmljaGFyZCBIaXBwCj4gU2VudDogVGh1cnNkYXksIE1hcmNoIDEyLCAyMDIwIDc6 NDEgQU0KPiBUbzogU1FMaXRlIG1haWxpbmcgbGlzdCA8c3FsaXRlLXVzZXJzQG1haWxpbmdsaXN0 cy5zcWxpdGUub3JnPgo+IFN1YmplY3Q6IFJlOiBbc3FsaXRlXSBbRVhURVJOQUxdIFJlOiBDT0FM RVNDRSgpIGRvZXMgbm90IHNob3J0LQo+IGNpcmN1aXQgc29tZXRpbWVzCj4gCj4gT24gMy8xMi8y MCwgRG91ZyA8ZG91Z2YuY2NuQGNvbWNhc3QubmV0PiB3cm90ZToKPiA+IFJpY2hhcmQsIHdoYXQg ZG9lcyB0aGUgZXhwbGFpbiBsb29rIGxpa2Ugd2l0aCB5b3VyIGNvZGUgY2hhbmdlLAo+IHBsZWFz ZS4KPiAKPiBUZXN0IGNhc2U6Cj4gCj4gQ1JFQVRFIFRBQkxFIHQxKGEpOwo+IGV4cGxhaW4gU0VM RUNUIGNvYWxlc2NlKGEsIGFicygtOTIyMzM3MjAzNjg1NDc3NTgwOCkpIEZST00gdDE7Cj4gCj4g QmVmb3JlIHRoZSBjaGFuZ2U6Cj4gCj4gYWRkciAgb3Bjb2RlICAgICAgICAgcDEgICAgcDIgICAg cDMgICAgcDQgICAgICAgICAgICAgcDUgIGNvbW1lbnQKPiAtLS0tICAtLS0tLS0tLS0tLS0tICAt LS0tICAtLS0tICAtLS0tICAtLS0tLS0tLS0tLS0tICAtLSAgLS0tLS0tLS0KPiAtLS0tLQo+IDAg ICAgIEluaXQgICAgICAgICAgIDAgICAgIDEwICAgIDAgICAgICAgICAgICAgICAgICAgIDAwICBT dGFydCBhdAo+IDEwCj4gMSAgICAgT3BlblJlYWQgICAgICAgMCAgICAgMiAgICAgMCAgICAgMSAg ICAgICAgICAgICAgMDAgIHJvb3Q9Mgo+IGlEYj0wOyB0MQo+IDIgICAgIEV4cGxhaW4gICAgICAg IDIgICAgIDAgICAgIDAgICAgIFNDQU4gVEFCTEUgdDEgIDAwCj4gMyAgICAgUmV3aW5kICAgICAg ICAgMCAgICAgOSAgICAgMCAgICAgICAgICAgICAgICAgICAgMDAKPiA0ICAgICAgIENvbHVtbiAg ICAgICAgIDAgICAgIDAgICAgIDEgICAgICAgICAgICAgICAgICAgIDAwCj4gclsxXT10MS5hCj4g NSAgICAgICBOb3ROdWxsICAgICAgICAxICAgICA3ICAgICAwICAgICAgICAgICAgICAgICAgICAw MCAgaWYKPiByWzFdIT1OVUxMIGdvdG8gNwo+IDYgICAgICAgU0NvcHkgICAgICAgICAgMiAgICAg MSAgICAgMCAgICAgICAgICAgICAgICAgICAgMDAKPiByWzFdPXJbMl0KPiA3ICAgICAgIFJlc3Vs dFJvdyAgICAgIDEgICAgIDEgICAgIDAgICAgICAgICAgICAgICAgICAgIDAwCj4gb3V0cHV0PXJb MV0KPiA4ICAgICBOZXh0ICAgICAgICAgICAwICAgICA0ICAgICAwICAgICAgICAgICAgICAgICAg ICAwMQo+IDkgICAgIEhhbHQgICAgICAgICAgIDAgICAgIDAgICAgIDAgICAgICAgICAgICAgICAg ICAgIDAwCj4gMTAgICAgVHJhbnNhY3Rpb24gICAgMCAgICAgMCAgICAgMSAgICAgMCAgICAgICAg ICAgICAgMDEKPiB1c2VzU3RtdEpvdXJuYWw9MAo+IDExICAgIEludDY0ICAgICAgICAgIDAgICAg IDMgICAgIDAgICAgIC05MjIzMzcyMDM2ODU0Nzc1ODA4ICAwMAo+IHJbM109LTkyMjMzNzIwMzY4 NTQ3NzU4MDgKPiAxMiAgICBGdW5jdGlvbiAgICAgICAxICAgICAzICAgICAyICAgICBhYnMoMSkg ICAgICAgICAwMAo+IHJbMl09ZnVuYyhyWzNdKQo+IDEzICAgIEdvdG8gICAgICAgICAgIDAgICAg IDEgICAgIDAgICAgICAgICAgICAgICAgICAgIDAwCj4gCj4gTm90aWNlIHRoYXQgdGhlIGFicygp IGZ1bmN0aW9uIGlzIGludm9rZWQgaW4gdGhlICJwcm9sb2d1ZSIgY29kZS4KPiBUaGUKPiBwcm9s b2d1ZSBiZWdpbnMgb24gaW5zdHJ1Y3Rpb24gMTAgYW5kIGNvbnRpbnVlcyB0aHJvdWdoIHRoZSBH b3RvCj4gYXQKPiBpbnN0cnVjdGlvbiAxMy4KPiAKPiBBZnRlciB0aGUgY2hhbmdlOgo+IAo+IGFk ZHIgIG9wY29kZSAgICAgICAgIHAxICAgIHAyICAgIHAzICAgIHA0ICAgICAgICAgICAgIHA1ICBj b21tZW50Cj4gLS0tLSAgLS0tLS0tLS0tLS0tLSAgLS0tLSAgLS0tLSAgLS0tLSAgLS0tLS0tLS0t LS0tLSAgLS0gIC0tLS0tLS0tCj4gLS0tLS0KPiAwICAgICBJbml0ICAgICAgICAgICAwICAgICAx MyAgICAwICAgICAgICAgICAgICAgICAgICAwMCAgU3RhcnQgYXQKPiAxMwo+IDEgICAgIE9wZW5S ZWFkICAgICAgIDAgICAgIDIgICAgIDAgICAgIDEgICAgICAgICAgICAgIDAwICByb290PTIKPiBp RGI9MDsgdDEKPiAyICAgICBFeHBsYWluICAgICAgICAyICAgICAwICAgICAwICAgICBTQ0FOIFRB QkxFIHQxICAwMAo+IDMgICAgIFJld2luZCAgICAgICAgIDAgICAgIDEyICAgIDAgICAgICAgICAg ICAgICAgICAgIDAwCj4gNCAgICAgICBDb2x1bW4gICAgICAgICAwICAgICAwICAgICAxICAgICAg ICAgICAgICAgICAgICAwMAo+IHJbMV09dDEuYQo+IDUgICAgICAgTm90TnVsbCAgICAgICAgMSAg ICAgMTAgICAgMCAgICAgICAgICAgICAgICAgICAgMDAgIGlmCj4gclsxXSE9TlVMTCBnb3RvIDEw Cj4gNiAgICAgICBPbmNlICAgICAgICAgICAwICAgICA5ICAgICAwICAgICAgICAgICAgICAgICAg ICAwMAo+IDcgICAgICAgSW50NjQgICAgICAgICAgMCAgICAgMyAgICAgMCAgICAgLTkyMjMzNzIw MzY4NTQ3NzU4MDggIDAwCj4gclszXT0tOTIyMzM3MjAzNjg1NDc3NTgwOAo+IDggICAgICAgRnVu Y3Rpb24gICAgICAgMSAgICAgMyAgICAgMiAgICAgYWJzKDEpICAgICAgICAgMDAKPiByWzJdPWZ1 bmMoclszXSkKPiA5ICAgICAgIFNDb3B5ICAgICAgICAgIDIgICAgIDEgICAgIDAgICAgICAgICAg ICAgICAgICAgIDAwCj4gclsxXT1yWzJdCj4gMTAgICAgICBSZXN1bHRSb3cgICAgICAxICAgICAx ICAgICAwICAgICAgICAgICAgICAgICAgICAwMAo+IG91dHB1dD1yWzFdCj4gMTEgICAgTmV4dCAg ICAgICAgICAgMCAgICAgNCAgICAgMCAgICAgICAgICAgICAgICAgICAgMDEKPiAxMiAgICBIYWx0 ICAgICAgICAgICAwICAgICAwICAgICAwICAgICAgICAgICAgICAgICAgICAwMAo+IDEzICAgIFRy YW5zYWN0aW9uICAgIDAgICAgIDAgICAgIDEgICAgIDAgICAgICAgICAgICAgIDAxCj4gdXNlc1N0 bXRKb3VybmFsPTAKPiAxNCAgICBHb3RvICAgICAgICAgICAwICAgICAxICAgICAwICAgICAgICAg ICAgICAgICAgICAwMAo+IAo+IE5vdyB0aGUgcHJvbG9ndWUgaXMganVzdCBpbnN0cnVjdGlvbnMg MTMgYW5kIDE0IGFuZCBvbWl0cyB0aGUKPiBhYnMoKQo+IGZ1bmN0aW9uLiAgVGhlIGFicygpIGZ1 bmN0aW9uIGlzIG5vdyBjb21wdXRlZCBvbiBpbnN0cnVjdGlvbnMgNwo+IGFuZCA4LAo+IGJ1dCB0 aG9zZSBpbnN0cnVjdGlvbnMgb25seSBydW4gb25lIHRpbWUgZHVlIHRvIHRoZSAiT25jZSIgb3Bj b2RlCj4gb24KPiBpbnN0cnVjdGlvbiA2Lgo+IAo+IC0tCj4gRC4gUmljaGFyZCBIaXBwCj4gZHJo QHNxbGl0ZS5vcmcKPiBfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fXwo+IHNxbGl0ZS11c2VycyBtYWlsaW5nIGxpc3QKPiBzcWxpdGUtdXNlcnNAbWFpbGluZ2xp c3RzLnNxbGl0ZS5vcmcKPiBodHRwOi8vbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcvY2dpLWJpbi9t YWlsbWFuL2xpc3RpbmZvL3NxbGl0ZS0KPiB1c2VycwoKX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX18Kc3FsaXRlLXVzZXJzIG1haWxpbmcgbGlzdApzcWxpdGUt dXNlcnNAbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcKaHR0cDovL21haWxpbmdsaXN0cy5zcWxpdGUu b3JnL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxpdGUtdXNlcnMK