Mercurial > urweb

view tests/table.lac @ 223:bbe5899a9585

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Queries back to working as well as before, after start of refactoring to support grouping
author Adam Chlipala <adamc@hcoop.net>
date Thu, 21 Aug 2008 12:49:29 -0400
parents 79819a6346e2
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)