Re: [EXTERNAL] Re: COALESCE() does not short-circuit sometimes
Richard Hipp <[email protected]> Thu, 12 Mar 2020 10:40:55 -0400
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CALwJ=Mw1Ks_gWxPfJjsRrBqrYNE2NFQkmSc2k6EXe7rEPqjZ2Q@mail.gmail.com> |
T24gMy8xMi8yMCwgRG91ZyA8ZG91Z2YuY2NuQGNvbWNhc3QubmV0PiB3cm90ZToKPiBSaWNoYXJk LCB3aGF0IGRvZXMgdGhlIGV4cGxhaW4gbG9vayBsaWtlIHdpdGggeW91ciBjb2RlIGNoYW5nZSwg cGxlYXNlLgoKVGVzdCBjYXNlOgoKQ1JFQVRFIFRBQkxFIHQxKGEpOwpleHBsYWluIFNFTEVDVCBj b2FsZXNjZShhLCBhYnMoLTkyMjMzNzIwMzY4NTQ3NzU4MDgpKSBGUk9NIHQxOwoKQmVmb3JlIHRo ZSBjaGFuZ2U6CgphZGRyICBvcGNvZGUgICAgICAgICBwMSAgICBwMiAgICBwMyAgICBwNCAgICAg ICAgICAgICBwNSAgY29tbWVudAotLS0tICAtLS0tLS0tLS0tLS0tICAtLS0tICAtLS0tICAtLS0t ICAtLS0tLS0tLS0tLS0tICAtLSAgLS0tLS0tLS0tLS0tLQowICAgICBJbml0ICAgICAgICAgICAw ICAgICAxMCAgICAwICAgICAgICAgICAgICAgICAgICAwMCAgU3RhcnQgYXQgMTAKMSAgICAgT3Bl blJlYWQgICAgICAgMCAgICAgMiAgICAgMCAgICAgMSAgICAgICAgICAgICAgMDAgIHJvb3Q9MiBp RGI9MDsgdDEKMiAgICAgRXhwbGFpbiAgICAgICAgMiAgICAgMCAgICAgMCAgICAgU0NBTiBUQUJM RSB0MSAgMDAKMyAgICAgUmV3aW5kICAgICAgICAgMCAgICAgOSAgICAgMCAgICAgICAgICAgICAg ICAgICAgMDAKNCAgICAgICBDb2x1bW4gICAgICAgICAwICAgICAwICAgICAxICAgICAgICAgICAg ICAgICAgICAwMCAgclsxXT10MS5hCjUgICAgICAgTm90TnVsbCAgICAgICAgMSAgICAgNyAgICAg MCAgICAgICAgICAgICAgICAgICAgMDAgIGlmIHJbMV0hPU5VTEwgZ290byA3CjYgICAgICAgU0Nv cHkgICAgICAgICAgMiAgICAgMSAgICAgMCAgICAgICAgICAgICAgICAgICAgMDAgIHJbMV09clsy XQo3ICAgICAgIFJlc3VsdFJvdyAgICAgIDEgICAgIDEgICAgIDAgICAgICAgICAgICAgICAgICAg IDAwICBvdXRwdXQ9clsxXQo4ICAgICBOZXh0ICAgICAgICAgICAwICAgICA0ICAgICAwICAgICAg ICAgICAgICAgICAgICAwMQo5ICAgICBIYWx0ICAgICAgICAgICAwICAgICAwICAgICAwICAgICAg ICAgICAgICAgICAgICAwMAoxMCAgICBUcmFuc2FjdGlvbiAgICAwICAgICAwICAgICAxICAgICAw ICAgICAgICAgICAgICAwMSAgdXNlc1N0bXRKb3VybmFsPTAKMTEgICAgSW50NjQgICAgICAgICAg MCAgICAgMyAgICAgMCAgICAgLTkyMjMzNzIwMzY4NTQ3NzU4MDggIDAwCnJbM109LTkyMjMzNzIw MzY4NTQ3NzU4MDgKMTIgICAgRnVuY3Rpb24gICAgICAgMSAgICAgMyAgICAgMiAgICAgYWJzKDEp ICAgICAgICAgMDAgIHJbMl09ZnVuYyhyWzNdKQoxMyAgICBHb3RvICAgICAgICAgICAwICAgICAx ICAgICAwICAgICAgICAgICAgICAgICAgICAwMAoKTm90aWNlIHRoYXQgdGhlIGFicygpIGZ1bmN0 aW9uIGlzIGludm9rZWQgaW4gdGhlICJwcm9sb2d1ZSIgY29kZS4gIFRoZQpwcm9sb2d1ZSBiZWdp bnMgb24gaW5zdHJ1Y3Rpb24gMTAgYW5kIGNvbnRpbnVlcyB0aHJvdWdoIHRoZSBHb3RvIGF0Cmlu c3RydWN0aW9uIDEzLgoKQWZ0ZXIgdGhlIGNoYW5nZToKCmFkZHIgIG9wY29kZSAgICAgICAgIHAx ICAgIHAyICAgIHAzICAgIHA0ICAgICAgICAgICAgIHA1ICBjb21tZW50Ci0tLS0gIC0tLS0tLS0t LS0tLS0gIC0tLS0gIC0tLS0gIC0tLS0gIC0tLS0tLS0tLS0tLS0gIC0tICAtLS0tLS0tLS0tLS0t CjAgICAgIEluaXQgICAgICAgICAgIDAgICAgIDEzICAgIDAgICAgICAgICAgICAgICAgICAgIDAw ICBTdGFydCBhdCAxMwoxICAgICBPcGVuUmVhZCAgICAgICAwICAgICAyICAgICAwICAgICAxICAg ICAgICAgICAgICAwMCAgcm9vdD0yIGlEYj0wOyB0MQoyICAgICBFeHBsYWluICAgICAgICAyICAg ICAwICAgICAwICAgICBTQ0FOIFRBQkxFIHQxICAwMAozICAgICBSZXdpbmQgICAgICAgICAwICAg ICAxMiAgICAwICAgICAgICAgICAgICAgICAgICAwMAo0ICAgICAgIENvbHVtbiAgICAgICAgIDAg ICAgIDAgICAgIDEgICAgICAgICAgICAgICAgICAgIDAwICByWzFdPXQxLmEKNSAgICAgICBOb3RO dWxsICAgICAgICAxICAgICAxMCAgICAwICAgICAgICAgICAgICAgICAgICAwMCAgaWYKclsxXSE9 TlVMTCBnb3RvIDEwCjYgICAgICAgT25jZSAgICAgICAgICAgMCAgICAgOSAgICAgMCAgICAgICAg ICAgICAgICAgICAgMDAKNyAgICAgICBJbnQ2NCAgICAgICAgICAwICAgICAzICAgICAwICAgICAt OTIyMzM3MjAzNjg1NDc3NTgwOCAgMDAKclszXT0tOTIyMzM3MjAzNjg1NDc3NTgwOAo4ICAgICAg IEZ1bmN0aW9uICAgICAgIDEgICAgIDMgICAgIDIgICAgIGFicygxKSAgICAgICAgIDAwICByWzJd PWZ1bmMoclszXSkKOSAgICAgICBTQ29weSAgICAgICAgICAyICAgICAxICAgICAwICAgICAgICAg ICAgICAgICAgICAwMCAgclsxXT1yWzJdCjEwICAgICAgUmVzdWx0Um93ICAgICAgMSAgICAgMSAg ICAgMCAgICAgICAgICAgICAgICAgICAgMDAgIG91dHB1dD1yWzFdCjExICAgIE5leHQgICAgICAg ICAgIDAgICAgIDQgICAgIDAgICAgICAgICAgICAgICAgICAgIDAxCjEyICAgIEhhbHQgICAgICAg ICAgIDAgICAgIDAgICAgIDAgICAgICAgICAgICAgICAgICAgIDAwCjEzICAgIFRyYW5zYWN0aW9u ICAgIDAgICAgIDAgICAgIDEgICAgIDAgICAgICAgICAgICAgIDAxICB1c2VzU3RtdEpvdXJuYWw9 MAoxNCAgICBHb3RvICAgICAgICAgICAwICAgICAxICAgICAwICAgICAgICAgICAgICAgICAgICAw MAoKTm93IHRoZSBwcm9sb2d1ZSBpcyBqdXN0IGluc3RydWN0aW9ucyAxMyBhbmQgMTQgYW5kIG9t aXRzIHRoZSBhYnMoKQpmdW5jdGlvbi4gIFRoZSBhYnMoKSBmdW5jdGlvbiBpcyBub3cgY29tcHV0 ZWQgb24gaW5zdHJ1Y3Rpb25zIDcgYW5kIDgsCmJ1dCB0aG9zZSBpbnN0cnVjdGlvbnMgb25seSBy dW4gb25lIHRpbWUgZHVlIHRvIHRoZSAiT25jZSIgb3Bjb2RlIG9uCmluc3RydWN0aW9uIDYuCgot LSAKRC4gUmljaGFyZCBIaXBwCmRyaEBzcWxpdGUub3JnCl9fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fCnNxbGl0ZS11c2VycyBtYWlsaW5nIGxpc3QKc3FsaXRl LXVzZXJzQG1haWxpbmdsaXN0cy5zcWxpdGUub3JnCmh0dHA6Ly9tYWlsaW5nbGlzdHMuc3FsaXRl Lm9yZy9jZ2ktYmluL21haWxtYW4vbGlzdGluZm8vc3FsaXRlLXVzZXJzCg==