Mercurial > urweb

annotate tests/sql_if.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 34364e383bed
children
rev   line source
adam@1573 1 table t : { A : int, B : int }
adam@1573 2
adam@1573 3 fun main () =
adam@1573 4 x <- queryX (SELECT * FROM t WHERE IF t.A = 6 THEN t.B < 2 ELSE t.B > 5)
adam@1573 5 (fn r => <xml><li>{[r.T.A]}, {[r.T.B]}</li></xml>);
adam@1573 6 return <xml><body>{x}</body></xml>