Mercurial > urweb

annotate tests/fitem.ur @ 1394:d328983dc5a6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Allow subqueries to reference aggregate-only columns of free tables; treat non-COUNT aggregate functions as possibly returning NULL
author Adam Chlipala <adam@chlipala.net>
date Sat, 15 Jan 2011 14:53:13 -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)}})