From d38e91c632dabefeaf480d5c695f8f6785c0403e Mon Sep 17 00:00:00 2001
From: dan <dan@noemail.net>
Date: Thu, 23 Jun 2011 16:40:26 +0000
Subject: [PATCH] Add a test for ticket [91e2e8ba6f]. No changes to code.

FossilOrigin-Name: c271f7e88fc081a460dd3f4afb24aa9fb7fa2917
---
 manifest                 | 13 +++++-----
 manifest.uuid            |  2 +-
 test/tkt-91e2e8ba6f.test | 52 ++++++++++++++++++++++++++++++++++++++++
 3 files changed, 60 insertions(+), 7 deletions(-)
 create mode 100644 test/tkt-91e2e8ba6f.test

diff --git a/manifest b/manifest
index 1613c5fb78..674d6dedb7 100644
--- a/manifest
+++ b/manifest
@@ -1,5 +1,5 @@
-C Do\snot\sdo\saffinity\stransformations\son\sinserts\sinto\san\sindex\sfor\sthe\nmanifestation\sof\sa\sview\sor\ssubquery.\s\sFix\sfor\sticket\s[91e2e8ba6ff2e2].
-D 2011-06-23T16:18:26.708
+C Add\sa\stest\sfor\sticket\s[91e2e8ba6f].\sNo\schanges\sto\scode.
+D 2011-06-23T16:40:26.224
 F Makefile.arm-wince-mingw32ce-gcc d6df77f1f48d690bd73162294bbba7f59507c72f
 F Makefile.in c1d7a7f4fd8da6b1815032efca950e3d5125407e
 F Makefile.linux-gcc 91d710bdc4998cb015f39edf3cb314ec4f4d7e23
@@ -725,6 +725,7 @@ F test/tkt-78e04e52ea.test ab52f0c1e2de6e46c910f4cc16b086bba05952b7
 F test/tkt-80ba201079.test a09684db1a0bd55b8838f606adccee456a51ddbf
 F test/tkt-80e031a00f.test 9a154173461a4dbe2de49cda73963e04842d52f7
 F test/tkt-8454a207b9.test c583a9f814a82a2b5ba95207f55001c9f0cd816c
+F test/tkt-91e2e8ba6f.test 08c4f94ae07696b05c9b822da0b4e5337a2f54c5
 F test/tkt-94c04eaadb.test be5ea61cb04dfdc047d19b5c5a9e75fa3da67a7f
 F test/tkt-9d68c883.test 458f7d82a523d7644b54b497c986378a7d8c8b67
 F test/tkt-b351d95f9.test d14a503c414c5c58fdde3e80f9a3cfef986498c0
@@ -948,7 +949,7 @@ F tool/symbols.sh bc2a3709940d47c8ac8e0a1fdf17ec801f015a00
 F tool/tostr.awk 11760e1b94a5d3dcd42378f3cc18544c06cfa576
 F tool/vdbe-compress.tcl d70ea6d8a19e3571d7ab8c9b75cba86d1173ff0f
 F tool/warnings.sh 347d974d143cf132f953b565fbc03026f19fcb4d
-P 8dca748b23fa6f9abf47a186dcd1766f4dcf3ab7
-R 8a2977c4b779153cca71718dadb8abe7
-U drh
-Z c7801050cf22d76dd7a2a355fe09f4f2
+P 0b3174e0b1364ccc31853dce02bce5f7d3d431db
+R f6237300c8e94b60ef9cb6b4fc0d6ad4
+U dan
+Z 66a01206844bd880ddebccebd0a5e317
diff --git a/manifest.uuid b/manifest.uuid
index 157a733d62..bffb816668 100644
--- a/manifest.uuid
+++ b/manifest.uuid
@@ -1 +1 @@
-0b3174e0b1364ccc31853dce02bce5f7d3d431db
\ No newline at end of file
+c271f7e88fc081a460dd3f4afb24aa9fb7fa2917
\ No newline at end of file
diff --git a/test/tkt-91e2e8ba6f.test b/test/tkt-91e2e8ba6f.test
new file mode 100644
index 0000000000..57f13740a2
--- /dev/null
+++ b/test/tkt-91e2e8ba6f.test
@@ -0,0 +1,52 @@
+# 2011 June 23
+#
+#    May you do good and not evil.
+#    May you find forgiveness for yourself and forgive others.
+#    May you share freely, never taking more than you give.
+#
+#***********************************************************************
+#
+# This file contains tests for SQLite. Specifically, it tests that SQLite
+# does not crash and an error is returned if localhost() fails. This 
+# is the problem reported by ticket 91e2e8ba6f.
+#
+
+set testdir [file dirname $argv0]
+source $testdir/tester.tcl
+
+set testprefix tkt-91e2e8ba6f
+
+
+do_execsql_test 1.1 {
+  CREATE TABLE t1(x INTEGER, y REAL);
+  INSERT INTO t1 VALUES(11, 11);
+} {}
+
+do_execsql_test 1.2 {
+  SELECT x/10, y/10 FROM t1;
+} {1 1.1}
+
+do_execsql_test 1.3 {
+  SELECT x/10, y/10 FROM (SELECT * FROM t1);
+} {1 1.1}
+
+do_execsql_test 1.4 {
+  SELECT x/10, y/10 FROM (SELECT * FROM t1 LIMIT 5 OFFSET 0);
+} {1 1.1}
+
+do_execsql_test 1.5 {
+  SELECT x/10, y/10 FROM (SELECT * FROM t1 LIMIT 5 OFFSET 0) LIMIT 5 OFFSET 0;
+} {1 1.1}
+
+do_execsql_test 1.6 {
+  SELECT a.x/10, a.y/10 FROM 
+    (SELECT * FROM t1 LIMIT 5 OFFSET 0) AS a, t1 AS b WHERE a.x = b.x
+  LIMIT 5 OFFSET 0;
+} {1 1.1}
+
+do_execsql_test 1.7 {
+  CREATE VIEW v1 AS SELECT * FROM t1 LIMIT 5;
+  SELECT a.x/10, a.y/10 FROM v1 AS a, t1 AS b WHERE a.x = b.x LIMIT 5 OFFSET 0;
+} {1 1.1}
+
+finish_test
-- 
2.47.2