<commit_before># 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
- output: [['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']]
---
- Statement: CREATE VIEW v0(a,b) AS VALUES(1,10),(2,20),(3,30)
---
- Statement: SELECT * FROM v0 WHERE a > 1
- output: [[2,20],[3,30]]
---
- Statement: CREATE SCHEMA test2
---
- CreateTable: test2.s (n decimal(4))
---
- Statement: INSERT INTO test2.s VALUES(1),(3),(9),(1),(2)
---
- Statement: CREATE VIEW s AS SELECT DISTINCT n FROM test2.s
---
- Statement: SELECT * FROM s
- output_ordered: [[1],[2],[3],[9]]
...<commit_msg>Views were preventing table from being dropped automatically, clean up views<commit_after># 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
- output: [['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']]
---
- Statement: CREATE VIEW v0(a,b) AS VALUES(1,10),(2,20),(3,30)
---
- Statement: SELECT * FROM v0 WHERE a > 1
- output: [[2,20],[3,30]]
---
- Statement: CREATE SCHEMA test2
---
- CreateTable: test2.s (n decimal(4))
---
- Statement: INSERT INTO test2.s VALUES(1),(3),(9),(1),(2)
---
- Statement: CREATE VIEW s AS SELECT DISTINCT n FROM test2.s
---
- Statement: SELECT * FROM s
- output_ordered: [[1],[2],[3],[9]]

# Clean up views so table can be dropped
---
- Statement: DROP VIEW s
---
- Statement: DROP VIEW v0
---
- Statement: DROP VIEW v3
---
- Statement: DROP VIEW v2
---
- Statement: DROP VIEW v1

# And explicitly drop table, for sanity
---
- DropTable: t

...
{'fraction_non_alphanumeric': 0.20324238829576907, 'fraction_numerical': 0.042704626334519574, 'mean_word_length': 3.1887417218543046, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3021069', 'n_tokens_mistral': 1026, 'n_tokens_neox': 928, 'n_words': 310}