annotate tests/selclause.ur @ 1866:9fc086e3c95a
Add hex SQL syntax for blobs, such as X'0ABC12343'. Works with sqlite.
| author |
Sergey Mironov <grrwlf@gmail.com> |
| date |
Fri, 13 Sep 2013 10:09:15 -0400 |
| parents |
5c1f10cdac63 |
| children |
|
| rev |
line source |
|
adam@1627
|
1 table t : { A : int, B : string, C : float }
|
|
adam@1627
|
2 table u : { D : int, E : string, F : float }
|
|
adam@1627
|
3
|
|
adam@1627
|
4 val q : transaction (list {T : { A : int, B : string, C : float}, U : { D : int }, X : string }) =
|
|
adam@1627
|
5 queryL (SELECT t.*, u.D, 'hi' AS X
|
|
adam@1627
|
6 FROM t, u)
|
