Mercurial > urweb
annotate tests/init.ur @ 1168:69f1d39d3f2d
Use COALESCE to hide NULL results of aggregate functions; fix bug with improper ordering of query result columns
author | Adam Chlipala <adamc@hcoop.net> |
---|---|
date | Thu, 25 Feb 2010 14:55:35 -0500 |
parents | 0657e5adc938 |
children | 8a169fc0838b |
rev | line source |
---|---|
adamc@1073 | 1 sequence seq |
adamc@1073 | 2 table fred : {A : int, B : int} |
adamc@1073 | 3 |
adamc@1075 | 4 task initialize = |
adamc@1073 | 5 setval seq 1; |
adamc@1073 | 6 dml (INSERT INTO fred (A, B) VALUES (0, 1)) |