Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(170)

Unified Diff: third_party/sqlite/sqlite-src-3070603/ext/rtree/tkt3363.test

Issue 949043002: Add //third_party/sqlite to dirs_to_snapshot, remove net_sql.patch (Closed) Base URL: git@github.com:domokit/mojo.git@master
Patch Set: Created 5 years, 10 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
Index: third_party/sqlite/sqlite-src-3070603/ext/rtree/tkt3363.test
diff --git a/third_party/sqlite/sqlite-src-3070603/ext/rtree/tkt3363.test b/third_party/sqlite/sqlite-src-3070603/ext/rtree/tkt3363.test
new file mode 100644
index 0000000000000000000000000000000000000000..db05ed527a125cbda255261cc79f1be8acb1c779
--- /dev/null
+++ b/third_party/sqlite/sqlite-src-3070603/ext/rtree/tkt3363.test
@@ -0,0 +1,50 @@
+# 2008 Sep 08
+#
+# The author disclaims copyright to this source code. In place of
+# a legal notice, here is a blessing:
+#
+# 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.
+#
+#***********************************************************************
+#
+# The focus of this file is testing that ticket #3363 is fixed.
+#
+
+if {![info exists testdir]} {
+ set testdir [file join [file dirname [info script]] .. .. test]
+}
+source [file join [file dirname [info script]] rtree_util.tcl]
+source $testdir/tester.tcl
+
+ifcapable !rtree {
+ finish_test
+ return
+}
+
+do_test tkt3363.1.1 {
+ execsql { CREATE VIRTUAL TABLE t1 USING rtree(ii, x1, x2, y1, y2) }
+} {}
+
+do_test tkt3363.1.2 {
+ for {set ii 1} {$ii < 50} {incr ii} {
+ set x 1000000
+ set y [expr 4000000 + $ii*10]
+ execsql { INSERT INTO t1 VALUES($ii, $x, $x, $y, $y) }
+ }
+} {}
+
+do_test tkt3363.1.3 {
+ execsql {
+ SELECT count(*) FROM t1 WHERE +y2>4000425.0;
+ }
+} {7}
+
+do_test tkt3363.1.4 {
+ execsql {
+ SELECT count(*) FROM t1 WHERE y2>4000425.0;
+ }
+} {7}
+
+finish_test

Powered by Google App Engine
This is Rietveld 408576698