COALESCE() does not short-circuit sometimes
Justin Ng <[email protected]> Wed, 11 Mar 2020 11:03:37 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <DM6PR06MB6266761D2425FC45280F35E7CFFC0@DM6PR06MB6266.namprd06.prod.outlook.com> |
VGhpcyBoYXBwZW5zIGluIFNRTGl0ZSAzLjI4IGFuZCAzLjMxLgoKQ29uc2lkZXIgdGhlIGZvbGxv d2luZyBxdWVyaWVzLAoKLS0gUXVlcnkgMQpTRUxFQ1QKICBDT0FMRVNDRSgKICAgIE5VTEwsCiAg ICAoU0VMRUNUIFNVTSg5MjIzMzcyMDM2ODU0Nzc1ODA3KSBGUk9NIChTRUxFQ1QgTlVMTCBVTklP TiBBTEwgU0VMRUNUIE5VTEwpKQogICk7CgotLSBRdWVyeSAyClNFTEVDVAogIENPQUxFU0NFKAog ICAgKFNFTEVDVCAnaGVsbG8nKSwKICAgIChTRUxFQ1QgU1VNKDkyMjMzNzIwMzY4NTQ3NzU4MDcp IEZST00gKFNFTEVDVCBOVUxMIFVOSU9OIEFMTCBTRUxFQ1QgTlVMTCkpCiAgKTsKCi0tIFF1ZXJ5 IDMKU0VMRUNUCiAgQ09BTEVTQ0UoCiAgICAoU0VMRUNUICdoZWxsbycpLAogICAgQUJTKC05MjIz MzcyMDM2ODU0Nzc1ODA4KQogICk7CgoKUXVlcnkgMSBzaG91bGQgdGhyb3cgYGludGVnZXIgb3Zl cmZsb3dgLgpRdWVyeSAyIHNob3VsZCByZXR1cm4gJ2hlbGxvJy4KUXVlcnkgMyBzaG91bGQgcmV0 dXJuICdoZWxsbycuCgpIb3dldmVyLCBRdWVyeSAzIHRocm93cyBgaW50ZWdlciBvdmVyZmxvd2Au IEl0IHNob3VsZCBzaG9ydC1jaXJjdWl0IGFuZCBub3QgZXZhbHVhdGUgQUJTKCkKX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18Kc3FsaXRlLXVzZXJzIG1haWxp bmcgbGlzdApzcWxpdGUtdXNlcnNAbWFpbGluZ2xpc3RzLnNxbGl0ZS5vcmcKaHR0cDovL21haWxp bmdsaXN0cy5zcWxpdGUub3JnL2NnaS1iaW4vbWFpbG1hbi9saXN0aW5mby9zcWxpdGUtdXNlcnMK