Re: [EXTERNAL] Re: COALESCE() does not short-circuit sometimes
Hick Gunter <hick-p6o8VmWS/[email protected]> Wed, 11 Mar 2020 12:39:01 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <03c56c7319cccca695c6c94160e7eb3a2008e29c@localhost> |
SXQgaXMgcG9zc2libGUgdG8gaW5mZXIsIGZyb20gdGhlIEVYUExBSU4gb3V0cHV0LCB0aGF0IHRo ZSBTUUxpdGUgcHJvZ3JhbSBnZW5lcmF0b3IgYXR0ZW1wdHMgdG8gaXNvbGF0ZSBjb25zdGFudCBl eHByZXNzaW9ucyBhbmQgZXZhbHVhdGVzIHRoZW0gZmlyc3QsIGJlZm9yZSBpdCBlbnRlcnMgdGhl IENPQUxFU0NFIGxvb3AuDQoNCkZyb20gbXkgZXhwZXJpZW5jZSBpbiByZWFkaW5nIFNRTCBQcm9n cmFtcywgdGhlIGdlbmVyYWwgc3RydWN0dXJlIGlzDQoNCkdPVE8gSU5JVA0KU1RBUlQ6DQotIGxv YWQgY29uc3RhbnQgdmFsdWVzDQotIGxvYWQgcGFyYW10ZXJzDQotIG9wZW4gdGFibGVzDQpMT09Q Og0KLSBjcmVhdGUgbmV4dCByZXN1bHQgcm93DQpJRiBlbmQtb2YtcmVzdWx0cyBUSEVOIEVYSVQg RUxTRSBHT1RPIExPT1ANCklOSVQ6DQotIGNoZWNrIHNjaGVtYSB2ZXJzaW9uDQotIHRha2UgcmVx dWlyZWQgbG9ja3MNCi0gZXZhbHVhdGUgY29uc3RhbnQgZXhwcmVzc2lvbnMNCkdPVE8gU1RBUlQN Cg0KV2hpY2ggaXMgcXVpdGUgbmlmdHksIGFzIGl0IGFsbG93cyBzdHVmZiB1bmtub3duIHVudGls IHRoZSBlbmQgb2YgcGFyc2luZyB0byBiZSBhcHBlbmRlZCB0byB0aGUgcHJvZ3JhbQ0KDQotLS0t LVVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNodC0tLS0tDQpWb246IHNxbGl0ZS11c2VycyBbbWFpbHRv OnNxbGl0ZS11c2Vycy1ib3VuY2VzQG1haWxpbmdsaXN0cy5zcWxpdGUub3JnXSBJbSBBdWZ0cmFn IHZvbiBEb21pbmlxdWUgRGV2aWVubmUNCkdlc2VuZGV0OiBNaXR0d29jaCwgMTEuIE3DpHJ6IDIw MjAgMTM6MTkNCkFuOiBTUUxpdGUgbWFpbGluZyBsaXN0IDxzcWxpdGUtdXNlcnNAbWFpbGluZ2xp c3RzLnNxbGl0ZS5vcmc+DQpCZXRyZWZmOiBbRVhURVJOQUxdIFJlOiBbc3FsaXRlXSBDT0FMRVND RSgpIGRvZXMgbm90IHNob3J0LWNpcmN1aXQgc29tZXRpbWVzDQoNCk9uIFdlZCwgTWFyIDExLCAy MDIwIGF0IDEyOjAzIFBNIEp1c3RpbiBOZyA8anVzdGluLm5nLjE5OTRAb3V0bG9vay5jb20+IHdy b3RlOg0KPiAtLSBRdWVyeSAzDQo+IFNFTEVDVA0KPiAgIENPQUxFU0NFKA0KPiAgICAgKFNFTEVD VCAnaGVsbG8nKSwNCj4gICAgIEFCUygtOTIyMzM3MjAzNjg1NDc3NTgwOCkNCj4gICApOw0KPiBb Li4uXS4gSXQgc2hvdWxkIHNob3J0LWNpcmN1aXQgYW5kIG5vdCBldmFsdWF0ZSBBQlMoKQ0KDQpJ bnRlcmVzdGluZ2x5LCBmb3VuZCB0aGlzIGFzIHdlbGw6DQpodHRwczovL2dpdGh1Yi5jb20vQW55 aG93U3RlcC90c3FsL2lzc3Vlcy8yMzMNClNRTGl0ZSBDT0FMRVNDRSgpIGRvZXMgbm90IHNob3J0 LWNpcmN1aXQgc29tZXRpbWVzICMyMzMgX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX19fX19fX18NCnNxbGl0ZS11c2VycyBtYWlsaW5nIGxpc3QNCnNxbGl0ZS11c2Vyc0Bt YWlsaW5nbGlzdHMuc3FsaXRlLm9yZw0KaHR0cDovL21haWxpbmdsaXN0cy5zcWxpdGUub3JnL2Nn aS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxpdGUtdXNlcnMNCg0KDQpfX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fDQogR3VudGVyIEhpY2sgfCBTb2Z0d2FyZSBFbmdp bmVlciB8IFNjaWVudGlmaWMgR2FtZXMgSW50ZXJuYXRpb25hbCBHbWJIIHwgS2xpdHNjaGdhc3Nl IDItNCwgQS0xMTMwIFZpZW5uYSB8IEZOIDE1NzI4NCBhLCBIRyBXaWVuLCBEVlI6IDA0MzAwMTMg fCAoTykgKzQzIDEgODAxMDAgLSAwDQoNCk1heSBiZSBwcml2aWxlZ2VkLiBNYXkgYmUgY29uZmlk ZW50aWFsLiBQbGVhc2UgZGVsZXRlIGlmIG5vdCB0aGUgYWRkcmVzc2VlLg0KX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18Kc3FsaXRlLXVzZXJzIG1haWxpbmcg bGlzdApzcWxpdGUtdXNlcnNAbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcKaHR0cDovL21haWxpbmds aXN0cy5zcWxpdGUub3JnL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxpdGUtdXNlcnMK