From ec65b1d0d58b39994eb81046f3a5464e033c1d8a Mon Sep 17 00:00:00 2001
From: thatch <devnull@localhost>
Date: Thu, 14 Aug 2008 23:29:59 -0700
Subject: Forgot sqlite3 example file

---
 tests/examplefiles/sqlite3.sqlite3-console | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100644 tests/examplefiles/sqlite3.sqlite3-console

(limited to 'tests/examplefiles/sqlite3.sqlite3-console')

diff --git a/tests/examplefiles/sqlite3.sqlite3-console b/tests/examplefiles/sqlite3.sqlite3-console
new file mode 100644
index 00000000..3ec27135
--- /dev/null
+++ b/tests/examplefiles/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> 
-- 
cgit v1.2.1