Re: [EXTERNAL] Re: COALESCE() does not short-circuit sometimes
Hick Gunter <hick-p6o8VmWS/[email protected]> Wed, 11 Mar 2020 17:53:59 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <795c11bec2e9824f0085ff1fb6b7f698e6858623@localhost> |
V2hpbGUgT1JBQ0xFIGRvZXMgc3RhdGUgdGhhdCBDT0FMRVNDRSB3aWxsIHNob3J0IGNpcmN1aXQs IFNRTGl0ZSBkb2VzIG5vdC4NCg0KTWF5IEkgc3VnZ2VzdCBpbXBsZW1lbnRpbmcgeW91ciBvd24g dXNlciBkZWZpbmVkIGZ1bmN0aW9uIHRvIGRvIHRoaXMgaW5zdGVhZC4NCg0Kdm9pZCBUSFJPV19J Rl9OVUxMKA0KICAgIHNxbGl0ZTNfY29udGV4dCAqY3R4LA0KICAgIGludCBhcmdjLA0KICAgIHNx bGl0ZTNfdmFsdWUqKmFyZ3YpIHsNCg0KICAgIGludCBpaTsNCg0KICAgIGZvciggaWkgPT0gMDsg aWkgPCBhcmdjOyBpaSsrKQ0KICAgIHsNCiAgICAgICAgaWYgKHNxbGl0ZTNfdmFsdWVfdHlwZShh cmd2W2lpXSkgIT0gU1FMSVRFX05VTEwpDQogICAgICAgIHsNCiAgICAgICAgICAgIHNxbGl0ZTNf cmVzdWx0X3ZhbHVlKGN0eCxhcmd2W2lpXSkpOw0KICAgICAgICAgICAgcmV0dXJuOw0KICAgICAg ICB9DQogICAgfQ0KDQogICAgc3FsaXRlM19yZXN1bHRfZXJyb3IoY3R4LCJOVUxMIG9yIGVtcHR5 IiwgU1FMSVRFX1RSQU5TSUVOVCk7DQp9DQoNCi0tLS0tVXJzcHLDvG5nbGljaGUgTmFjaHJpY2h0 LS0tLS0NClZvbjogc3FsaXRlLXVzZXJzIFttYWlsdG86c3FsaXRlLXVzZXJzLWJvdW5jZXNAbWFp bGluZ2xpc3RzLnNxbGl0ZS5vcmddIEltIEF1ZnRyYWcgdm9uIEp1c3RpbiBOZw0KR2VzZW5kZXQ6 IE1pdHR3b2NoLCAxMS4gTcOkcnogMjAyMCAxNjoyNA0KQW46IHNxbGl0ZS11c2Vyc0BtYWlsaW5n bGlzdHMuc3FsaXRlLm9yZw0KQ2M6IFZJMVAxOTVNQjA2NTQ1RjAzQTI0RDUwREQyNzg1QUMyQkRF RkMwQFZJMVAxOTVNQjA2NTQuRVVSUDE5NS5QUk9ELk9VVExPT0suQ09NDQpCZXRyZWZmOiBbRVhU RVJOQUxdIFJlOiBbc3FsaXRlXSBDT0FMRVNDRSgpIGRvZXMgbm90IHNob3J0LWNpcmN1aXQgc29t ZXRpbWVzDQoNCj4gV2h5IGRvIHlvdSB0aGluayB0aGF0IHRoYXQgaXQgc2hvdWxkIG5vdCBldmFs dWF0ZSBBQlM/ICBJdCBpcyB0aGVyZSBhbmQgeW91IGFza2VkIGZvciBpdC4gIEkgYmVsaWV2ZSBp dCdzIGEgZ29vZCBpZGVhIHRvIHNheSwgImhleSwgdGhlIGFtb3VudCB5b3UgcGxhY2VkIGhlcmUg aXMgb3V0IG9mIGJvdW5kYXJ5LCB0aGluayBhYm91dCB3aGF0IHlvdSBhcmUgZG9pbmcgaGVyZS4i IElNTywgb2YgY291cnNlLiBUaGFua3MuDQo+DQo+IGpvc8OpDQoNClNvbWV0aW1lcywgd2hlbiBx dWVyeWluZyBkYXRhLCByYXRoZXIgdGhhbiBsZXR0aW5nIE5VTExzIHByb3BhZ2F0ZSwgaXQgbWln aHQgYmUgYmV0dGVyIHRvIHRocm93IGFuIGVycm9yIGlmIE5VTExzIGFyZSBub3QgZXhwZWN0ZWQg ZnJvbSBhbiBleHByZXNzaW9uLg0KDQpUaGUgcHJlc2VuY2Ugb2YgTlVMTHMgbWlnaHQgaW5kaWNh dGUgYW4gZXJyb3IgaW4gbG9naWMsIGRhdGEsIG9yIGJvdGguDQoNClNvLCB0aGUgQ09BTEVTQ0Uo eCwgQUJTKC05MjIzMzcyMDM2ODU0Nzc1ODA4KSkgY29uc3RydWN0IGlzIGEgaGFjayB0byBzYW5p dHktY2hlY2sgcXVlcmllcy4NCg0KU29tZXRoaW5nIGxpa2UgVEhST1dfSUZfTlVMTCh4KQ0KX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18NCnNxbGl0ZS11c2Vy cyBtYWlsaW5nIGxpc3QNCnNxbGl0ZS11c2Vyc0BtYWlsaW5nbGlzdHMuc3FsaXRlLm9yZw0KaHR0 cDovL21haWxpbmdsaXN0cy5zcWxpdGUub3JnL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxp dGUtdXNlcnMNCg0KDQpfX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f DQogR3VudGVyIEhpY2sgfCBTb2Z0d2FyZSBFbmdpbmVlciB8IFNjaWVudGlmaWMgR2FtZXMgSW50 ZXJuYXRpb25hbCBHbWJIIHwgS2xpdHNjaGdhc3NlIDItNCwgQS0xMTMwIFZpZW5uYSB8IEZOIDE1 NzI4NCBhLCBIRyBXaWVuLCBEVlI6IDA0MzAwMTMgfCAoTykgKzQzIDEgODAxMDAgLSAwDQoNCk1h eSBiZSBwcml2aWxlZ2VkLiBNYXkgYmUgY29uZmlkZW50aWFsLiBQbGVhc2UgZGVsZXRlIGlmIG5v dCB0aGUgYWRkcmVzc2VlLg0KX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fX19fX18Kc3FsaXRlLXVzZXJzIG1haWxpbmcgbGlzdApzcWxpdGUtdXNlcnNAbWFpbGluZ2xp c3RzLnNxbGl0ZS5vcmcKaHR0cDovL21haWxpbmdsaXN0cy5zcWxpdGUub3JnL2NnaS1iaW4vbWFp bG1hbi9saXN0aW5mby9zcWxpdGUtdXNlcnMK