Re: COALESCE() does not short-circuit sometimes
"Keith Medcalf" <[email protected]> Wed, 11 Mar 2020 11:46:43 -0600
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Organization | This Side Up |
| Message-ID | <[email protected]> |
Ck9uIFdlZG5lc2RheSwgMTEgTWFyY2gsIDIwMjAgMDk6MjQsIEp1c3RpbiBOZyA8anVzdGluLm5n LjE5OTRAb3V0bG9vay5jb20+IHdyb3RlOgoKPlNvbWV0aW1lcywgd2hlbiBxdWVyeWluZyBkYXRh LCByYXRoZXIgdGhhbiBsZXR0aW5nIE5VTExzIHByb3BhZ2F0ZSwKPml0IG1pZ2h0IGJlIGJldHRl ciB0byB0aHJvdyBhbiBlcnJvciBpZiBOVUxMcyBhcmUgbm90IGV4cGVjdGVkIGZyb20gYW4KPmV4 cHJlc3Npb24uCgo+VGhlIHByZXNlbmNlIG9mIE5VTExzIG1pZ2h0IGluZGljYXRlIGFuIGVycm9y IGluIGxvZ2ljLCBkYXRhLCBvciBib3RoLgoKWWVzLCBpdCB2ZXJ5IHdlbGwgbWlnaHQuICBJIGJl bGlldmUgdGhlcmUgaXMgYSB0ZXJtIGZvciBhIHByb2dyYW1tZXIgdGhhdCB1c2VzIHNlbnRpbmVs cyBhbmQgdGhlbiBmb3JnZXRzIHRvIGhhbmRsZSB0aGVtLiAgVGhlcmUgaXMgZXZlbiBhIGRpYWdu b3N0aWMgY29kZSBmb3IgaXQuICBTb21lIHBlb3BsZSBvZmZlbmQgdGhlbXNlbHZlcyB3aGVuIHRo ZXkgc2VlIHRoZSBjb2RlLCBob3dldmVyLCBiZWNhdXNlIGl0IGxldHMgdGhlaXIgc2VjcmV0IG91 dCBvZiB0aGUgYmFnLgoKCj5TbywgdGhlIENPQUxFU0NFKHgsIEFCUygtOTIyMzM3MjAzNjg1NDc3 NTgwOCkpIGNvbnN0cnVjdCBpcyBhIGhhY2sgdG8KPnNhbml0eS1jaGVjayBxdWVyaWVzLgoKSXQg aXMgbm90IGEgImhhY2siIGJlY2F1c2UgaXQgZG9lcyBub3Qgd29yay4gIEl0IGlzIHdoYXQgaXMg Y2FsbGVkIGEgImZhaWxlZCBhdHRlbXB0IiBhdCBhIGhhY2suCgpIb3dldmVyLCB5b3VyIGFzc2Vz c21lbnQgdGhhdCBjb2FsZXNjZSBpcyBub3QgInNob3J0LWNpcmN1aXRpbmciIGlzIGluY29ycmVj dC4gIElmIHggaXMgbm90IG51bGwsIHRoZW4geCBpcyByZXR1cm5lZCBhbmQgdGhlIGNvbnN0YW50 IGV4cHJlc3Npb24gaXMgbm90IHJldHVybmVkLiAgSWYgdGhlIGNvbnN0YW50IGV4cHJlc3Npb24g d2VyZSBhIGNvcnJlbGF0ZWQgZXhwcmVzc2lvbiwgdGhlbiBpdCB3b3VsZCBub3QgYmUgZXZhbHVh dGVkIGluIHRoZSBjYW5kaWRhdGUgY29udGV4dC4gIElmIHggd2VyZSBudWxsIGFuZCB0aGUgZXhw cmVzc2lvbiB3YXMgbm90IGNvbnN0YW50IChhbmQgdGh1cyByZXF1aXJlZCBldmFsdWF0aW9uKSB0 aGVuIGl0IHdvdWxkIGJlIGV2YWx1YXRlZCB3aXRoaW4gdGhlIGN1cnJlbnQgY29udGV4dCBhbmQg aXRzIHJlc3VsdCByZXR1cm5lZC4KClRoZSBkb2N1bWVudGF0aW9uIERPRVMgTk9UIHNheSB0aGF0 IHRoZSBhcmd1bWVudHMgdG8gY29hbGVzY2Ugd2lsbCBub3QgYmUgZXZhbHVhdGVkLCBtZXJlbHkg dGhhdCB0aGUgZmlyc3Qgb25lIHRoYXQgaXMgbm90LW51bGwgd2lsbCBiZSByZXR1cm5lZC4KCmh0 dHBzOi8vc3FsaXRlLm9yZy9sYW5nX2NvcmVmdW5jLmh0bWwjY29hbGVzY2UKCj5Tb21ldGhpbmcg bGlrZSBUSFJPV19JRl9OVUxMKHgpCgpZb3UgY291bGQgY2VydGFpbmx5IHdyaXRlIGEgZnVuY3Rp b24gdGhhdCBkaWQgdGhhdC4gIEl0IHdvdWxkIGNlcnRhaW5seSBiZSBiZXR0ZXIgdGhhbiBhICJo YWNrIiB0aGF0IGRvZXMgbm90IGV2ZW4gd29yay4KCi0tIApUaGUgZmFjdCB0aGF0IHRoZXJlJ3Mg YSBIaWdod2F5IHRvIEhlbGwgYnV0IG9ubHkgYSBTdGFpcndheSB0byBIZWF2ZW4gc2F5cyBhIGxv dCBhYm91dCBhbnRpY2lwYXRlZCB0cmFmZmljIHZvbHVtZS4KCgoKCl9fX19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCnNxbGl0ZS11c2VycyBtYWlsaW5nIGxpc3QK c3FsaXRlLXVzZXJzQG1haWxpbmdsaXN0cy5zcWxpdGUub3JnCmh0dHA6Ly9tYWlsaW5nbGlzdHMu c3FsaXRlLm9yZy9jZ2ktYmluL21haWxtYW4vbGlzdGluZm8vc3FsaXRlLXVzZXJzCg==