Mercurial > urweb

view tests/table.ur @ 2067:88841212f0ba

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
In computing command lines, put filenames inside of quotes, to support spaces and other funky characters nicely
author Adam Chlipala <adam@chlipala.net>
date Thu, 04 Sep 2014 08:40:14 -0400
parents 71bafe66dbe1
children
line wrap: on
line source
table t1 : {A : int, B : string, C : float}
table t2 : {A : float, D : int}

val q1 = (SELECT * FROM t1)

val q2 = (SELECT * FROM t1, t2)

(*val q3 = (SELECT * FROM t1, t1)*)
val q3 = (SELECT * FROM t1, t1 AS T2)

val q4 = (SELECT * FROM {{t1}} AS T, t1 AS T2)

val q5 = (SELECT t1.A FROM t1)
val q6 = (SELECT t1.B, t1.C, t1.A FROM t1)

val q7 = (SELECT t1.A, t2.A FROM t1, t2)