Re: [EXTERNAL] Re: COALESCE() does not short-circuit sometimes
Richard Hipp <[email protected]> Thu, 12 Mar 2020 15:00:35 -0400
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <CALwJ=Mzn7QPPqBd6RdkfZ9GjhmRVRAwah0Qu+qj=5ni6+=4haQ@mail.gmail.com> |
T24gMy8xMi8yMCwgRG91ZyA8ZG91Z2YuY2NuQGNvbWNhc3QubmV0PiB3cm90ZToKPgo+IFNvbWV0 aGluZyB0cmlnZ2VyZWQgbWUgd2hlbiBJIGxvb2tlZCBhdCB0aGUgZ2VuZXJhdGVkIGNvZGU6IHlv dSB1c2UgdGhlCj4gY29udGVudHMgb2YgcmVnaXN0ZXIgMiBmb3IgdGhlIGNvbnN0YW50IHZhbHVl IGVhY2ggdGltZSB0aHJvdWdoIHRoZSBsb29wLgo+IFdoYXQgaWYgdGhlIHNlbGVjdCBsb29rcyBs aWtlIHRoaXMsIHdpdGggbW9yZSB0aGFuIG9uZSBmdW5jdGlvbiBjYWxsIGluIHRoZQo+IGNvYWxl c2NlPyBEbyB5b3UgaGFuZGxlIGl0IHByb3Blcmx5Pwo+Cj4gU0VMRUNUIGNvYWxlc2NlKGEsIGFi cygwKSwgYWJzKDEpLCBhYnMoMikpIEZST00gdDE7CgphZGRyICBvcGNvZGUgICAgICAgICBwMSAg ICBwMiAgICBwMyAgICBwNCAgICAgICAgICAgICBwNSAgY29tbWVudAotLS0tICAtLS0tLS0tLS0t LS0tICAtLS0tICAtLS0tICAtLS0tICAtLS0tLS0tLS0tLS0tICAtLSAgLS0tLS0tLS0tLS0tLQow ICAgICBJbml0ICAgICAgICAgICAwICAgICAyMyAgICAwICAgICAgICAgICAgICAgICAgICAwMCAg U3RhcnQgYXQgMjMKMSAgICAgT3BlblJlYWQgICAgICAgMCAgICAgMiAgICAgMCAgICAgMSAgICAg ICAgICAgICAgMDAgIHJvb3Q9MiBpRGI9MDsgdDEKMiAgICAgRXhwbGFpbiAgICAgICAgMiAgICAg MCAgICAgMCAgICAgU0NBTiBUQUJMRSB0MSAgMDAKMyAgICAgUmV3aW5kICAgICAgICAgMCAgICAg MjIgICAgMCAgICAgICAgICAgICAgICAgICAgMDAKNCAgICAgICBDb2x1bW4gICAgICAgICAwICAg ICAwICAgICAxICAgICAgICAgICAgICAgICAgICAwMCAgclsxXT10MS5hCjUgICAgICAgTm90TnVs bCAgICAgICAgMSAgICAgMjAgICAgMCAgICAgICAgICAgICAgICAgICAgMDAgIGlmCnJbMV0hPU5V TEwgZ290byAyMAo2ICAgICAgIE9uY2UgICAgICAgICAgIDAgICAgIDkgICAgIDAgICAgICAgICAg ICAgICAgICAgIDAwCjcgICAgICAgSW50ZWdlciAgICAgICAgMCAgICAgMyAgICAgMCAgICAgICAg ICAgICAgICAgICAgMDAgIHJbM109MAo4ICAgICAgIEZ1bmN0aW9uICAgICAgIDEgICAgIDMgICAg IDIgICAgIGFicygxKSAgICAgICAgIDAwICByWzJdPWZ1bmMoclszXSkKOSAgICAgICBTQ29weSAg ICAgICAgICAyICAgICAxICAgICAwICAgICAgICAgICAgICAgICAgICAwMCAgclsxXT1yWzJdCjEw ICAgICAgTm90TnVsbCAgICAgICAgMSAgICAgMjAgICAgMCAgICAgICAgICAgICAgICAgICAgMDAg IGlmCnJbMV0hPU5VTEwgZ290byAyMAoxMSAgICAgIE9uY2UgICAgICAgICAgIDAgICAgIDE0ICAg IDAgICAgICAgICAgICAgICAgICAgIDAwCjEyICAgICAgSW50ZWdlciAgICAgICAgMSAgICAgNSAg ICAgMCAgICAgICAgICAgICAgICAgICAgMDAgIHJbNV09MQoxMyAgICAgIEZ1bmN0aW9uICAgICAg IDEgICAgIDUgICAgIDQgICAgIGFicygxKSAgICAgICAgIDAwICByWzRdPWZ1bmMocls1XSkKMTQg ICAgICBTQ29weSAgICAgICAgICA0ICAgICAxICAgICAwICAgICAgICAgICAgICAgICAgICAwMCAg clsxXT1yWzRdCjE1ICAgICAgTm90TnVsbCAgICAgICAgMSAgICAgMjAgICAgMCAgICAgICAgICAg ICAgICAgICAgMDAgIGlmCnJbMV0hPU5VTEwgZ290byAyMAoxNiAgICAgIE9uY2UgICAgICAgICAg IDAgICAgIDE5ICAgIDAgICAgICAgICAgICAgICAgICAgIDAwCjE3ICAgICAgSW50ZWdlciAgICAg ICAgMiAgICAgNyAgICAgMCAgICAgICAgICAgICAgICAgICAgMDAgIHJbN109MgoxOCAgICAgIEZ1 bmN0aW9uICAgICAgIDEgICAgIDcgICAgIDYgICAgIGFicygxKSAgICAgICAgIDAwICByWzZdPWZ1 bmMocls3XSkKMTkgICAgICBTQ29weSAgICAgICAgICA2ICAgICAxICAgICAwICAgICAgICAgICAg ICAgICAgICAwMCAgclsxXT1yWzZdCjIwICAgICAgUmVzdWx0Um93ICAgICAgMSAgICAgMSAgICAg MCAgICAgICAgICAgICAgICAgICAgMDAgIG91dHB1dD1yWzFdCjIxICAgIE5leHQgICAgICAgICAg IDAgICAgIDQgICAgIDAgICAgICAgICAgICAgICAgICAgIDAxCjIyICAgIEhhbHQgICAgICAgICAg IDAgICAgIDAgICAgIDAgICAgICAgICAgICAgICAgICAgIDAwCjIzICAgIFRyYW5zYWN0aW9uICAg IDAgICAgIDAgICAgIDEgICAgIDAgICAgICAgICAgICAgIDAxICB1c2VzU3RtdEpvdXJuYWw9MAoy NCAgICBHb3RvICAgICAgICAgICAwICAgICAxICAgICAwICAgICAgICAgICAgICAgICAgICAwMAoK LS0gCkQuIFJpY2hhcmQgSGlwcApkcmhAc3FsaXRlLm9yZwpfX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fXwpzcWxpdGUtdXNlcnMgbWFpbGluZyBsaXN0CnNxbGl0 ZS11c2Vyc0BtYWlsaW5nbGlzdHMuc3FsaXRlLm9yZwpodHRwOi8vbWFpbGluZ2xpc3RzLnNxbGl0 ZS5vcmcvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3NxbGl0ZS11c2Vycwo=