Re: [EXTERNAL] Re: COALESCE() does not short-circuit sometimes
Hick Gunter <hick-p6o8VmWS/[email protected]> Thu, 12 Mar 2020 08:00:51 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <f74460cd1ee8355e43bf6f45a1e41974550d12aa@localhost> |
RXhhY3RseSB3aGF0IEkgZ2FpbmVkIGZyb20gdGhlIEVYUExBSU4gb3V0cHV0Lg0KDQpUaGUgU1FM ICJjb21waWxlciIgaXMgZXh0cmFjdGluZyB0aGUgY29uc3RhbnQgZXhwcmVzc2lvbiBBQlMoLi4u KSBhbmQgZXZhbHVhdGluZyBpdCBpbiB0aGUgcHJvZ3JhbSBwcm9sb2cgKHdoZXJlIHNjaGVtYSBp cyBjaGVja2VkIGFuZCBsb2NrcyB0YWtlbikuIFNlZSBpbnN0cnVjdGlvbnMgMTEgYW5kIDEyDQoN CmFzcWw+IGV4cGxhaW4gc2VsZWN0IGNvYWxlc2NlKChTRUxFQ1QgJ2hlbGxvJyksQUJTKC05MjIz MzcyMDM2ODU0Nzc1ODA4KSk7DQphZGRyICBvcGNvZGUgICAgICAgICBwMSAgICBwMiAgICBwMyAg ICBwNCAgICAgICAgICAgICBwNSAgY29tbWVudA0KLS0tLSAgLS0tLS0tLS0tLS0tLSAgLS0tLSAg LS0tLSAgLS0tLSAgLS0tLS0tLS0tLS0tLSAgLS0gIC0tLS0tLS0tLS0tLS0NCjAgICAgIEluaXQg ICAgICAgICAgIDAgICAgIDExICAgIDAgICAgICAgICAgICAgICAgICAgIDAwICBTdGFydCBhdCAx MQ0KMSAgICAgT25jZSAgICAgICAgICAgMCAgICAgNiAgICAgMCAgICAgICAgICAgICAgICAgICAg MDANCjIgICAgIE51bGwgICAgICAgICAgIDAgICAgIDIgICAgIDIgICAgICAgICAgICAgICAgICAg IDAwICByWzIuLjJdPU5VTEw7IEluaXQgc3VicXVlcnkgcmVzdWx0DQozICAgICBJbnRlZ2VyICAg ICAgICAxICAgICAzICAgICAwICAgICAgICAgICAgICAgICAgICAwMCAgclszXT0xOyBMSU1JVCBj b3VudGVyDQo0ICAgICBTdHJpbmc4ICAgICAgICAwICAgICAyICAgICAwICAgICBoZWxsbyAgICAg ICAgICAwMCAgclsyXT0naGVsbG8nDQo1ICAgICBEZWNySnVtcFplcm8gICAzICAgICA2ICAgICAw ICAgICAgICAgICAgICAgICAgICAwMCAgaWYgKC0tclszXSk9PTAgZ290byA2DQo2ICAgICBTQ29w eSAgICAgICAgICAyICAgICAxICAgICAwICAgICAgICAgICAgICAgICAgICAwMCAgclsxXT1yWzJd DQo3ICAgICBOb3ROdWxsICAgICAgICAxICAgICA5ICAgICAwICAgICAgICAgICAgICAgICAgICAw MCAgaWYgclsxXSE9TlVMTCBnb3RvIDkNCjggICAgIFNDb3B5ICAgICAgICAgIDQgICAgIDEgICAg IDAgICAgICAgICAgICAgICAgICAgIDAwICByWzFdPXJbNF0NCjkgICAgIFJlc3VsdFJvdyAgICAg IDEgICAgIDEgICAgIDAgICAgICAgICAgICAgICAgICAgIDAwICBvdXRwdXQ9clsxXQ0KMTAgICAg SGFsdCAgICAgICAgICAgMCAgICAgMCAgICAgMCAgICAgICAgICAgICAgICAgICAgMDANCjExICAg IEludDY0ICAgICAgICAgIDAgICAgIDUgICAgIDAgICAgIC05MjIzMzcyMDM2ODU0Nzc1ODA4ICAw MCAgcls1XT0tOTIyMzM3MjAzNjg1NDc3NTgwOA0KMTIgICAgRnVuY3Rpb24wICAgICAgMSAgICAg NSAgICAgNCAgICAgYWJzKDEpICAgICAgICAgMDEgIHJbNF09ZnVuYyhyWzVdKQ0KMTMgICAgR290 byAgICAgICAgICAgMCAgICAgMSAgICAgMCAgICAgICAgICAgICAgICAgICAgMDANCg0KLS0tLS1V cnNwcsO8bmdsaWNoZSBOYWNocmljaHQtLS0tLQ0KVm9uOiBzcWxpdGUtdXNlcnMgW21haWx0bzpz cWxpdGUtdXNlcnMtYm91bmNlc0BtYWlsaW5nbGlzdHMuc3FsaXRlLm9yZ10gSW0gQXVmdHJhZyB2 b24gSmF5IEtyZWliaWNoDQpHZXNlbmRldDogTWl0dHdvY2gsIDExLiBNw6RyeiAyMDIwIDIwOjUz DQpBbjogU1FMaXRlIG1haWxpbmcgbGlzdCA8c3FsaXRlLXVzZXJzQG1haWxpbmdsaXN0cy5zcWxp dGUub3JnPg0KQ2M6IDM4ODY2NDI0ZjhmNmZjNDI5MTc0ZmYxYWIyMzU1ZjBiQG1haWwuZGVzc3Vz LmNvbQ0KQmV0cmVmZjogW0VYVEVSTkFMXSBSZTogW3NxbGl0ZV0gQ09BTEVTQ0UoKSBkb2VzIG5v dCBzaG9ydC1jaXJjdWl0IHNvbWV0aW1lcw0KDQoNCj4gT24gTWFyIDExLCAyMDIwLCBhdCAyOjE2 IFBNLCBKdXN0aW4gTmcgPGp1c3Rpbi5uZy4xOTk0QG91dGxvb2suY29tPiB3cm90ZToNCj4NCj4g VGhleSBnZW5lcmFsbHkgZG8gc2hvcnQtY2lyY3VpdCBidXQgdGhlcmUgYXJlIGVkZ2UgY2FzZXMg d2hlcmUgdGhleSBkb24ndC4gSXQgaXNuJ3QgZW50aXJlbHkgaW50dWl0aXZlIHRvIG1lIHdoYXQg dGhlIGNvbmRpdGlvbnMgYXJlLCB0aG91Z2guDQo+DQoNCg0KIkFCUygtOTIyMzM3MjAzNjg1NDc3 NTgwOCkiIGlzIGEgY29uc3RhbnQgZXhwcmVzc2lvbiwgYW5kIGFzIHN1Y2gsIGl0IG1ha2VzIHNl bnNlIHRoYXQgaXQgaXMgZXZhbHVhdGUgZHVyaW5nIHRoZSBwYXJzZS9wcmVwYXJlIHBoYXNlIG9m IHRoZSBwcm9jZXNzaW5nLCBub3QgdGhlIGV4ZWN1dGlvbi4gIFRoZXJlIGFyZSBzaW1pbGFyIHBy b2JsZW1zIGluIG1vcmUgdHJhZGl0aW9uYWwgbGFuZ3VhZ2VzIChlc3BlY2lhbGx5IHNjcmlwdGlu ZyBsYW5ndWFnZXMpIHRoYXQgYXR0ZW1wdCB0byBvcHRpbWl6ZSBvdXQgb3IgcHJlLWNvbXB1dGUg Y29uc3RhbnQgZXhwcmVzc2lvbnMuDQoNCklmIHRoYXTigJlzIHRoZSBjYXNlLCB0aGVuIHRoZSBp c3N1ZSBpcyBub3Qgc28gbXVjaCB0aGF0IHRoZSBDT0FMRVNDRSgpIGlzIGZhaWxpbmcgdG8gc2hv cnQtY2lyY3VpdCwgYnV0IHJhdGhlciB0aGFuIHRoZSBTUUwgc3RhdGVtZW50IGZhaWxpbmcgdG8g 4oCcY29tcGlsaW5n4oCdIGFuIGludmFsaWQgc3RhdGVtZW50Lg0KDQpJZiB5b3XigJlyZSBkb2lu ZyB0aGlzIGluIGNvZGUgYXMgc2VwYXJhdGUgcHJlcGFyZS9zdGVwL2ZpbmFsaXplLCBpdCB3b3Vs ZCBiZSBpbnRlcmVzdGluZyB0byBzZWUgd2hlcmUgaXQgZmFpbHMuICBNeSBndWVzcyBpcyBwcmVw YXJlLCBub3Qgc3RlcC4NCg0KICAtag0KDQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fXw0Kc3FsaXRlLXVzZXJzIG1haWxpbmcgbGlzdA0Kc3FsaXRlLXVzZXJz QG1haWxpbmdsaXN0cy5zcWxpdGUub3JnDQpodHRwOi8vbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcv Y2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3NxbGl0ZS11c2Vycw0KDQoNCl9fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX18NCiBHdW50ZXIgSGljayB8IFNvZnR3YXJlIEVu Z2luZWVyIHwgU2NpZW50aWZpYyBHYW1lcyBJbnRlcm5hdGlvbmFsIEdtYkggfCBLbGl0c2NoZ2Fz c2UgMi00LCBBLTExMzAgVmllbm5hIHwgRk4gMTU3Mjg0IGEsIEhHIFdpZW4sIERWUjogMDQzMDAx MyB8IChPKSArNDMgMSA4MDEwMCAtIDANCg0KTWF5IGJlIHByaXZpbGVnZWQuIE1heSBiZSBjb25m aWRlbnRpYWwuIFBsZWFzZSBkZWxldGUgaWYgbm90IHRoZSBhZGRyZXNzZWUuDQpfX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fXwpzcWxpdGUtdXNlcnMgbWFpbGlu ZyBsaXN0CnNxbGl0ZS11c2Vyc0BtYWlsaW5nbGlzdHMuc3FsaXRlLm9yZwpodHRwOi8vbWFpbGlu Z2xpc3RzLnNxbGl0ZS5vcmcvY2dpLWJpbi9tYWlsbWFuL2xpc3RpbmZvL3NxbGl0ZS11c2Vycwo=