diff options
| author | Oleh Prypin <oleh@pryp.in> | 2021-01-20 10:48:45 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-01-20 10:48:45 +0100 |
| commit | 6f4309217326430145564ae8b1bb393ea684f39f (patch) | |
| tree | bf4025a5e709426dc927c4afc4fd2286f8450ed9 /tests/examplefiles/sqlite3/sqlite3.sqlite3-console | |
| parent | f0445be718da83541ea3401aad882f3937147263 (diff) | |
| download | pygments-git-6f4309217326430145564ae8b1bb393ea684f39f.tar.gz | |
Also add auto-updatable output-based tests to examplefiles (#1689)
Co-authored-by: Georg Brandl <georg@python.org>
Diffstat (limited to 'tests/examplefiles/sqlite3/sqlite3.sqlite3-console')
| -rw-r--r-- | tests/examplefiles/sqlite3/sqlite3.sqlite3-console | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/tests/examplefiles/sqlite3/sqlite3.sqlite3-console b/tests/examplefiles/sqlite3/sqlite3.sqlite3-console new file mode 100644 index 00000000..3ec27135 --- /dev/null +++ b/tests/examplefiles/sqlite3/sqlite3.sqlite3-console @@ -0,0 +1,27 @@ +SQLite version 3.4.2 +Enter ".help" for instructions +sqlite> .schema +CREATE TABLE paste (paste_id integer, code text, parsed_code text, pub_date +varchar(24), language varchar(64), parent_id integer, url varchar(128)); +CREATE TABLE vars (key varchar(24), value varchar(128)); +sqlite> a ' + ...> ' + ...> ; +SQL error: near "a": syntax error +sqlite> %; +SQL error: near "%": syntax error +sqlite> select count(language), language from paste group by language order + ...> by count(language) desc; +144|python +76|text +22|pycon +9|ruby +7|c +7|js +6|html+django +4|html +4|tex +2|html+php +1|cpp +1|scheme +sqlite> |