Mercurial > urweb

annotate tests/coalesce.ur @ 2295:e6c5bb62fef8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fix SQL parser JOIN bug and fix ON clause logic in Sqlcache.
author Ziv Scully <ziv@mit.edu>
date Thu, 19 Nov 2015 03:45:39 -0500
parents e44be6ece475
children
rev   line source
adam@1602 1 table t : { A : option int }
adam@1602 2
adam@1602 3 fun main () : transaction page =
adam@1602 4 queryX (SELECT COALESCE(t.A, 13)
adam@1602 5 FROM t)
adam@1602 6 (fn r => <xml>{[r.1]},</xml>)