# Test view construction and usage.
---
- CreateTable: t (id INT PRIMARY KEY NOT NULL, s VARCHAR(10))
---
- Statement: INSERT INTO t VALUES(1, 'foo'),(2, 'bar')
---
- Statement: SELECT * FROM t
- output_ordered: [[1, 'foo'],[2, 'bar']]
---
- Statement: CREATE VIEW v1 AS SELECT * FROM t
---
- Statement: SELECT * FROM v1
- output_ordered: [[1, 'foo'],[2, 'bar']]
---
- Statement: CREATE VIEW v2(x,y) AS SELECT s,id FROM t ORDER BY s
---
- Statement: SELECT * FROM v2
# TODO _ordered should not be needed
- output_ordered: [['bar', 2],['foo', 1]]
---
- Statement: CREATE VIEW v3 AS SELECT s||x FROM v1 INNER JOIN v2 ON v1.id = v2.y
---
- Statement: SELECT * FROM v3
- output_ordered: [['barbar'],['foofoo']]
...

Add some YAML tests for views.
Add some YAML tests for views.
