Mercurial > urweb

annotate tests/fitem.ur @ 1887:2e6795cc992f

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
A fancier test for the new SQL constraints subtyping
author Adam Chlipala <adam@chlipala.net>
date Mon, 04 Nov 2013 16:00:48 -0500
parents e8d68fd8ed4b
children
rev   line source
adamc@1265 1 table t : { A : int, B : string }
adamc@1265 2 table u : { A : int, C : float }
adamc@1265 3
adamc@1265 4 val q : sql_query [] [T = [A = int, B = string], U = [C = option float]] [] =
adamc@1265 5 (SELECT t.A, t.B, u.C
adamc@1265 6 FROM {{sql_left_join (FROM t) (FROM u) (WHERE TRUE)}})