Changeset 64 for hw

Timestamp:

10/15/07 13:49:02 (5 years ago)

Author:

cs186

Message:

make sure to turn off bitmap scans too!

Location:

hw/hw2/MyStuff

Files:

• runtests.sh (modified) (1 diff)
• runtests_setup.sql (modified) (2 diffs)

hw/hw2/MyStuff/runtests.sh

@@ -12 +12 @@
 
 # check output
-if ( `diff runtests.out/1 runtests.out/2` != '' ) echo 'OnePageNN failure'
-if ( `diff runtests.out/3 runtests.out/4` != '' ) echo 'BasicNN failure'
-if ( `diff runtests.out/5 runtests.out/6` != '' ) echo 'SelectionNN failure'
-if ( `cat runtests.out/10` != '') echo 'Rectangle failure: mismatch on zeros'
-if ( `diff runtests.out/7 runtests.out/8` != '' ) echo 'Rectangle failure'
+if ( "`gdiff -q runtests.out/1 runtests.out/2`" != "" ) echo 'OnePageNN failure'
+if ( "`gdiff -q runtests.out/3 runtests.out/4`" != "" ) echo 'BasicNN failure'
+if ( "`gdiff -q runtests.out/5 runtests.out/6`" != "" ) echo 'SelectionNN failure'
+if ( "`cat runtests.out/10`" != "") echo 'Rectangle failure: mismatch on zeros'
+if ( "`gdiff -q runtests.out/7 runtests.out/8`" != "" ) echo 'Rectangle failure'

hw/hw2/MyStuff/runtests_setup.sql

@@ -7 +7 @@
 drop table if exists testscan25;
 create table testgist(id integer, the_box box);
-copy testgist from '/Users/joeh/devel/hw2/MyStuff/randomboxes' delimiter ';' ;
+copy testgist from '/home/cc/cs186/fa07/class/cs186-ee/Hw2/MyStuff/randomboxes' delimiter ';' ;
 create index testgistix on testgist using gist (the_box box_ops);
 
 create table testscan(id integer, the_box box);
-copy testscan from '/Users/joeh/devel/hw2/MyStuff/randomboxes' delimiter ';' ;
+copy testscan from '/home/cc/cs186/fa07/class/cs186-ee/Hw2/MyStuff/randomboxes' delimiter ';' ;
 
 create table testgist25 (id integer, the_box box);
-copy testgist25 from '/Users/joeh/devel/hw2/MyStuff/randomboxes25' delimiter ';' ;
+copy testgist25 from '/home/cc/cs186/fa07/class/cs186-ee/Hw2/MyStuff/randomboxes25' delimiter ';' ;
 create index testgist25ix on testgist25 using gist (the_box box_ops);
 
 create table testscan25(id integer, the_box box);
-copy testscan25 from '/Users/joeh/devel/hw2/MyStuff/randomboxes25' delimiter ';' ;
-
+copy testscan25 from '/home/cc/cs186/fa07/class/cs186-ee/Hw2/MyStuff/randomboxes25' delimiter ';' ;
 
 --
@@ -30 +29 @@
 -- SeqScan: 
 set enable_seqscan to off;
+set enable_bitmapscan to off;
+
 \o runtests.out/1
 select id, box_mindistance(the_box, '(0.5,0.5,0.5,0.5)') as dist from testscan25 where the_box ~~ '(0.5,0.5,0.5,0.5)' and box_mindistance(the_box, '(0.5,0.5,0.5,0.5)') > 0 order by dist;