db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r809632 [6/7] - in /db/derby/code/trunk/java: engine/org/apache/derby/iapi/util/ engine/org/apache/derby/impl/sql/execute/rts/ testing/org/apache/derbyTesting/functionTests/master/ testing/org/apache/derbyTesting/functionTests/tests/lang/ t...
Date Mon, 31 Aug 2009 15:47:24 GMT
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/wisconsin.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/wisconsin.out?rev=809632&r1=809631&r2=809632&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/wisconsin.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/wisconsin.out Mon Aug 31 15:47:23 2009
@@ -86,7 +86,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -95,16 +95,16 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- Wisconsin Query 4
 get cursor c as
@@ -147,7 +147,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -156,16 +156,16 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- Wisconsin Query 5
 get cursor c as
@@ -208,7 +208,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -217,16 +217,16 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- Wisconsin Query 6
 get cursor c as
@@ -269,7 +269,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -278,16 +278,16 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- Wisconsin Query 7
 get cursor c as
@@ -332,7 +332,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -341,16 +341,16 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- Wisconsin Query 12
 get cursor c as
@@ -406,7 +406,7 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=2
 			Number of deleted rows visited=0
@@ -415,14 +415,14 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	None
-			stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				None
+			stop position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			qualifiers:
-None
+				None
 Right result set:
 	Index Row to Base Row ResultSet for TENKTUP2:
 	<filtered number of opens>
@@ -451,20 +451,20 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	None
-			stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				None
+			stop position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			scan qualifiers:
-None
+				None
 			next qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+				Column[0][0] Id: 0
+				Operator: =
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- Wisconsin Query 13
 get cursor c as
@@ -523,17 +523,19 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=16
 			<filtered number of pages visited>
 			<filtered number of rows qualified>
 			<filtered number of rows visited>
 			Scan type=heap
-			start position: 
-null			stop position: 
-null			qualifiers:
-None
+			start position:
+				null
+			stop position:
+				null
+			qualifiers:
+				None
 	Right result set:
 		Index Row to Base Row ResultSet for TENKTUP1:
 		<filtered number of opens>
@@ -552,7 +554,7 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-			scan information: 
+			scan information:
 				Bit set of columns fetched=All
 				Number of columns fetched=2
 				Number of deleted rows visited=0
@@ -561,14 +563,14 @@
 				<filtered number of rows visited>
 				Scan type=btree
 				Tree height=2
-				start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-				stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+				start position:
+					>= on first 1 column(s).
+					Ordered null semantics on the following columns: 
+				stop position:
+					> on first 1 column(s).
+					Ordered null semantics on the following columns: 
 				qualifiers:
-None
+					None
 ij> commit;
 ij> -- Wisconsin query 14
 -- NOTE: This could benefit from transitive closure, which our optimizer
@@ -635,21 +637,23 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=16
 			<filtered number of pages visited>
 			<filtered number of rows qualified>
 			<filtered number of rows visited>
 			Scan type=heap
-			start position: 
-null			stop position: 
-null			qualifiers:
-Column[0][0] Id: 1
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+			start position:
+				null
+			stop position:
+				null
+			qualifiers:
+				Column[0][0] Id: 1
+				Operator: <
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 	Right result set:
 		Index Row to Base Row ResultSet for TENKTUP1:
 		<filtered number of opens>
@@ -668,7 +672,7 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-			scan information: 
+			scan information:
 				Bit set of columns fetched=All
 				Number of columns fetched=2
 				Number of deleted rows visited=0
@@ -677,20 +681,20 @@
 				<filtered number of rows visited>
 				Scan type=btree
 				Tree height=2
-				start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-				stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-				qualifiers:
-Column[0][0] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+				start position:
+					>= on first 1 column(s).
+					Ordered null semantics on the following columns: 
+					0 
+				stop position:
+					> on first 1 column(s).
+					Ordered null semantics on the following columns: 
+					0 
+				qualifiers:
+					Column[0][0] Id: 0
+					Operator: <
+					Ordered nulls: false
+					Unknown return value: false
+					Negate comparison result: false
 Right result set:
 	Index Row to Base Row ResultSet for TENKTUP2:
 	<filtered number of opens>
@@ -709,7 +713,7 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=2
 			Number of deleted rows visited=0
@@ -718,25 +722,25 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-			stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-			qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
-Column[0][1] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+			start position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
+			stop position:
+				> on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
+			qualifiers:
+				Column[0][0] Id: 0
+				Operator: =
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
+				Column[0][1] Id: 0
+				Operator: <
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- Wisconsin Query 15
 get cursor c as
@@ -792,7 +796,7 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=2
 			Number of deleted rows visited=0
@@ -801,14 +805,14 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	None
-			stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				None
+			stop position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			qualifiers:
-None
+				None
 Right result set:
 	Index Row to Base Row ResultSet for TENKTUP2:
 	<filtered number of opens>
@@ -837,20 +841,20 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	None
-			stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				None
+			stop position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			scan qualifiers:
-None
+				None
 			next qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+				Column[0][0] Id: 0
+				Operator: =
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- Wisconsin Query 16
 get cursor c as
@@ -909,17 +913,19 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=16
 			<filtered number of pages visited>
 			<filtered number of rows qualified>
 			<filtered number of rows visited>
 			Scan type=heap
-			start position: 
-null			stop position: 
-null			qualifiers:
-None
+			start position:
+				null
+			stop position:
+				null
+			qualifiers:
+				None
 	Right result set:
 		Index Row to Base Row ResultSet for TENKTUP1:
 		<filtered number of opens>
@@ -938,7 +944,7 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-			scan information: 
+			scan information:
 				Bit set of columns fetched=All
 				Number of columns fetched=2
 				Number of deleted rows visited=0
@@ -947,14 +953,14 @@
 				<filtered number of rows visited>
 				Scan type=btree
 				Tree height=2
-				start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-				stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+				start position:
+					>= on first 1 column(s).
+					Ordered null semantics on the following columns: 
+				stop position:
+					> on first 1 column(s).
+					Ordered null semantics on the following columns: 
 				qualifiers:
-None
+					None
 ij> commit;
 ij> -- Wisconsin Query 17
 -- NOTE: This could benefit from transitive closure, which our optimizer
@@ -1021,21 +1027,23 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=16
 			<filtered number of pages visited>
 			<filtered number of rows qualified>
 			<filtered number of rows visited>
 			Scan type=heap
-			start position: 
-null			stop position: 
-null			qualifiers:
-Column[0][0] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+			start position:
+				null
+			stop position:
+				null
+			qualifiers:
+				Column[0][0] Id: 0
+				Operator: <
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 	Right result set:
 		Index Row to Base Row ResultSet for TENKTUP1:
 		<filtered number of opens>
@@ -1054,7 +1062,7 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-			scan information: 
+			scan information:
 				Bit set of columns fetched=All
 				Number of columns fetched=2
 				Number of deleted rows visited=0
@@ -1063,20 +1071,20 @@
 				<filtered number of rows visited>
 				Scan type=btree
 				Tree height=2
-				start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-				stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-				qualifiers:
-Column[0][0] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+				start position:
+					>= on first 1 column(s).
+					Ordered null semantics on the following columns: 
+					0 
+				stop position:
+					> on first 1 column(s).
+					Ordered null semantics on the following columns: 
+					0 
+				qualifiers:
+					Column[0][0] Id: 0
+					Operator: <
+					Ordered nulls: false
+					Unknown return value: false
+					Negate comparison result: false
 Right result set:
 	Index Row to Base Row ResultSet for TENKTUP2:
 	<filtered number of opens>
@@ -1095,7 +1103,7 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=2
 			Number of deleted rows visited=0
@@ -1104,25 +1112,25 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-			stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-			qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
-Column[0][1] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+			start position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
+			stop position:
+				> on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
+			qualifiers:
+				Column[0][0] Id: 0
+				Operator: =
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
+				Column[0][1] Id: 0
+				Operator: <
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- This is the end of the Wisconsin queries.  Now do some queries that are
 -- not part of the original Wisconsin benchmark, using the Wisconsin schema.
@@ -1168,7 +1176,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -1177,14 +1185,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 50% selectivity index with 0 matching rows - should do index scan
 get cursor c as
@@ -1227,7 +1235,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -1236,14 +1244,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 100% of rows - should do table scan
 get cursor c as
@@ -1278,21 +1286,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 2
-Operator: <
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 2
+		Operator: <
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 0 rows - should do index scan
 get cursor c as
@@ -1335,7 +1345,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -1344,13 +1354,13 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	None
+		start position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			None
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 50% selectivity index that covers query - should do index scan
 get cursor c as
@@ -1385,7 +1395,7 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched={0}
 	Number of columns fetched=1
 	Number of deleted rows visited=0
@@ -1394,14 +1404,14 @@
 	<filtered number of rows visited>
 	Scan type=btree
 	Tree height=2
-	start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-	stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+	start position:
+		>= on first 1 column(s).
+		Ordered null semantics on the following columns: 
+	stop position:
+		> on first 1 column(s).
+		Ordered null semantics on the following columns: 
 	qualifiers:
-None
+		None
 ij> commit;
 ij> -- Single-table queries using index on column 'four'
 -- 25% selectivity index that doesn't cover query - should do index scan
@@ -1445,7 +1455,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -1454,14 +1464,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 25% selectivity index with 0 matching rows - should do index scan
 get cursor c as
@@ -1504,7 +1514,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -1513,14 +1523,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 75% of rows - should do table scan
 get cursor c as
@@ -1555,21 +1565,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 3
-Operator: <
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 3
+		Operator: <
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 0 rows - should do index scan
 get cursor c as
@@ -1612,7 +1624,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -1621,13 +1633,13 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	None
+		start position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			None
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 25% selectivity index that covers query - should do index scan
 get cursor c as
@@ -1662,7 +1674,7 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched={0}
 	Number of columns fetched=1
 	Number of deleted rows visited=0
@@ -1671,14 +1683,14 @@
 	<filtered number of rows visited>
 	Scan type=btree
 	Tree height=2
-	start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-	stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+	start position:
+		>= on first 1 column(s).
+		Ordered null semantics on the following columns: 
+	stop position:
+		> on first 1 column(s).
+		Ordered null semantics on the following columns: 
 	qualifiers:
-None
+		None
 ij> commit;
 ij> -- Single-table queries using index on column 'twentyPercent'
 -- 20% selectivity index that doesn't cover query - should use index
@@ -1722,7 +1734,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -1731,14 +1743,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 20% selectivity index with 0 matching rows - should do index scan
 get cursor c as
@@ -1781,7 +1793,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -1790,14 +1802,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 60% of rows - should do table scan
 get cursor c as
@@ -1832,21 +1844,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 8
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 8
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 0 rows - should do index scan
 get cursor c as
@@ -1889,7 +1903,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -1898,13 +1912,13 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	None
+		start position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			None
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 20% selectivity index that covers query - should do index scan
 get cursor c as
@@ -1939,7 +1953,7 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched={0}
 	Number of columns fetched=1
 	Number of deleted rows visited=0
@@ -1948,14 +1962,14 @@
 	<filtered number of rows visited>
 	Scan type=btree
 	Tree height=2
-	start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-	stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+	start position:
+		>= on first 1 column(s).
+		Ordered null semantics on the following columns: 
+	stop position:
+		> on first 1 column(s).
+		Ordered null semantics on the following columns: 
 	qualifiers:
-None
+		None
 ij> commit;
 ij> -- Single-table queries using index on column 'ten'
 -- 10% selectivity index that doesn't cover query - should use index
@@ -1999,7 +2013,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -2008,14 +2022,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 10% selectivity index with 0 matching rows - should do index scan
 get cursor c as
@@ -2058,7 +2072,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -2067,14 +2081,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 50% of rows - should do index scan
 get cursor c as
@@ -2117,7 +2131,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -2126,13 +2140,13 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	None
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			None
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 60% of rows - should do table scan
 get cursor c as
@@ -2167,21 +2181,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 4
-Operator: <=
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 4
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: false
+		Negate comparison result: false
 ij> commit;
 ij> -- matches 0 rows - should do index scan
 get cursor c as
@@ -2224,7 +2240,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -2233,13 +2249,13 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	None
+		start position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			None
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 10% selectivity index that covers query - should do index scan
 get cursor c as
@@ -2274,7 +2290,7 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched={0}
 	Number of columns fetched=1
 	Number of deleted rows visited=0
@@ -2283,14 +2299,14 @@
 	<filtered number of rows visited>
 	Scan type=btree
 	Tree height=2
-	start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-	stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+	start position:
+		>= on first 1 column(s).
+		Ordered null semantics on the following columns: 
+	stop position:
+		> on first 1 column(s).
+		Ordered null semantics on the following columns: 
 	qualifiers:
-None
+		None
 ij> commit;
 ij> -- Single-table queries using index on column 'twenty'
 -- 5% selectivity index that doesn't cover query - should use index
@@ -2334,7 +2350,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -2343,14 +2359,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 5% selectivity index with 0 matching rows - should do index scan
 get cursor c as
@@ -2393,7 +2409,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -2402,14 +2418,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 50% of rows - should do index scan
 get cursor c as
@@ -2452,7 +2468,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -2461,13 +2477,13 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	None
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			None
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 55% of rows - should do table scan
 get cursor c as
@@ -2502,21 +2518,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 5
-Operator: <=
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 5
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: false
+		Negate comparison result: false
 ij> commit;
 ij> -- matches 0 rows - should do index scan
 get cursor c as
@@ -2559,7 +2577,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -2568,13 +2586,13 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	None
-		stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			None
+		stop position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 5% selectivity index that covers query - should do index scan
 get cursor c as
@@ -2609,7 +2627,7 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched={0}
 	Number of columns fetched=1
 	Number of deleted rows visited=0
@@ -2618,14 +2636,14 @@
 	<filtered number of rows visited>
 	Scan type=btree
 	Tree height=2
-	start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-	stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+	start position:
+		>= on first 1 column(s).
+		Ordered null semantics on the following columns: 
+	stop position:
+		> on first 1 column(s).
+		Ordered null semantics on the following columns: 
 	qualifiers:
-None
+		None
 ij> commit;
 ij> -- Single-table queries using index on column 'onePercent'
 -- 1% selectivity index that doesn't cover query - should use index
@@ -2669,7 +2687,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -2678,14 +2696,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 1% selectivity index with 0 matching rows - should do index scan
 get cursor c as
@@ -2728,7 +2746,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -2737,14 +2755,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 50% of rows - should do index scan
 get cursor c as
@@ -2779,21 +2797,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 6
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 6
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 60% of rows - should do table scan
 get cursor c as
@@ -2828,21 +2848,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 6
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 6
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 0 rows - should do index scan
 get cursor c as
@@ -2885,7 +2907,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -2894,13 +2916,13 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	None
+		start position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			None
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 1% selectivity index that covers query - should do index scan
 get cursor c as
@@ -2935,7 +2957,7 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched={0}
 	Number of columns fetched=1
 	Number of deleted rows visited=0
@@ -2944,14 +2966,14 @@
 	<filtered number of rows visited>
 	Scan type=btree
 	Tree height=2
-	start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-	stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+	start position:
+		>= on first 1 column(s).
+		Ordered null semantics on the following columns: 
+	stop position:
+		> on first 1 column(s).
+		Ordered null semantics on the following columns: 
 	qualifiers:
-None
+		None
 ij> commit;
 ij> -- Single-table queries using index on column 'evenOnePercent'
 -- 1% selectivity index that doesn't cover query - should use index
@@ -2995,7 +3017,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -3004,14 +3026,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 1% selectivity index with 0 matching rows - should do index scan
 get cursor c as
@@ -3054,7 +3076,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -3063,14 +3085,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 50% of rows - should do index scan
 get cursor c as
@@ -3105,21 +3127,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 11
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 11
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 60% of rows - should do table scan
 get cursor c as
@@ -3154,21 +3178,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 11
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 11
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 0 rows - should do index scan
 get cursor c as
@@ -3211,7 +3237,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -3220,13 +3246,13 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	None
+		start position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			None
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 1% selectivity index that covers query - should do index scan
 get cursor c as
@@ -3261,7 +3287,7 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched={0}
 	Number of columns fetched=1
 	Number of deleted rows visited=0
@@ -3270,14 +3296,14 @@
 	<filtered number of rows visited>
 	Scan type=btree
 	Tree height=2
-	start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-	stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+	start position:
+		>= on first 1 column(s).
+		Ordered null semantics on the following columns: 
+	stop position:
+		> on first 1 column(s).
+		Ordered null semantics on the following columns: 
 	qualifiers:
-None
+		None
 ij> commit;
 ij> -- Single-table queries using index on column 'oddOnePercent'
 -- 1% selectivity index that doesn't cover query - should use index
@@ -3321,7 +3347,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -3330,14 +3356,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 1% selectivity index with 0 matching rows - should do index scan
 get cursor c as
@@ -3380,7 +3406,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -3389,14 +3415,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 40% of rows - should do index scan
 get cursor c as
@@ -3439,7 +3465,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -3448,13 +3474,13 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	None
+		start position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			None
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 60% of rows - should do table scan
 get cursor c as
@@ -3489,21 +3515,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 12
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 12
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 0 rows - should do index scan
 get cursor c as
@@ -3546,7 +3574,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -3555,13 +3583,13 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=2
-		start position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	None
+		start position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			None
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 1% selectivity index that covers query - should do index scan
 get cursor c as
@@ -3596,7 +3624,7 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched={0}
 	Number of columns fetched=1
 	Number of deleted rows visited=0
@@ -3605,14 +3633,14 @@
 	<filtered number of rows visited>
 	Scan type=btree
 	Tree height=2
-	start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-	stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+	start position:
+		>= on first 1 column(s).
+		Ordered null semantics on the following columns: 
+	stop position:
+		> on first 1 column(s).
+		Ordered null semantics on the following columns: 
 	qualifiers:
-None
+		None
 ij> commit;
 ij> -- Single-table queries using index on column 'stringu1'
 -- unique index that doesn't cover query - should use index
@@ -3656,7 +3684,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -3665,16 +3693,16 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=3
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- unique index with 0 matching rows - should do index scan
 get cursor c as
@@ -3717,7 +3745,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -3726,16 +3754,16 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=3
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 50% of rows - should do index scan
 get cursor c as
@@ -3770,21 +3798,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 13
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 13
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 51% of rows - should do table scan
 get cursor c as
@@ -3819,21 +3849,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 13
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 13
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 0 rows - should do index scan
 get cursor c as
@@ -3876,7 +3908,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -3885,14 +3917,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=3
-		start position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-		stop position: 
-	None
+		start position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
+		stop position:
+			None
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- unique index that covers query - should do index scan
 get cursor c as
@@ -3927,7 +3959,7 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched={0}
 	Number of columns fetched=1
 	Number of deleted rows visited=0
@@ -3936,16 +3968,16 @@
 	<filtered number of rows visited>
 	Scan type=btree
 	Tree height=3
-	start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-	stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+	start position:
+		>= on first 1 column(s).
+		Ordered null semantics on the following columns: 
+		0 
+	stop position:
+		> on first 1 column(s).
+		Ordered null semantics on the following columns: 
+		0 
 	qualifiers:
-None
+		None
 ij> commit;
 ij> -- Single-table queries using index on column 'stringu2'
 -- unique index that doesn't cover query - should use index
@@ -3989,7 +4021,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -3998,16 +4030,16 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=3
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- unique index with 0 matching rows - should do index scan
 get cursor c as
@@ -4050,7 +4082,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -4059,16 +4091,16 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=3
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 50% of rows - should do index scan
 get cursor c as
@@ -4103,21 +4135,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 14
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 14
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 51% of rows - should do table scan
 get cursor c as
@@ -4152,21 +4186,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 14
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 14
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 0 rows - should do index scan
 get cursor c as
@@ -4209,7 +4245,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -4218,14 +4254,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=3
-		start position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-		stop position: 
-	None
+		start position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+			0 
+		stop position:
+			None
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- unique index that covers query - should do index scan
 get cursor c as
@@ -4260,7 +4296,7 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched={0}
 	Number of columns fetched=1
 	Number of deleted rows visited=0
@@ -4269,16 +4305,16 @@
 	<filtered number of rows visited>
 	Scan type=btree
 	Tree height=3
-	start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-	stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+	start position:
+		>= on first 1 column(s).
+		Ordered null semantics on the following columns: 
+		0 
+	stop position:
+		> on first 1 column(s).
+		Ordered null semantics on the following columns: 
+		0 
 	qualifiers:
-None
+		None
 ij> commit;
 ij> -- Single-table queries using index on column 'string4'
 -- 25% selectivity index that doesn't cover query - should do index scan
@@ -4322,7 +4358,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -4331,14 +4367,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=3
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 25% selectivity index with 0 matching rows - should do index scan
 get cursor c as
@@ -4381,7 +4417,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -4390,14 +4426,14 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=3
-		start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+		start position:
+			>= on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- matches 50% of rows - should do index scan
 get cursor c as
@@ -4432,21 +4468,23 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched=All
 	Number of columns fetched=16
 	<filtered number of pages visited>
 	<filtered number of rows qualified>
 	<filtered number of rows visited>
 	Scan type=heap
-	start position: 
-null	stop position: 
-null	qualifiers:
-Column[0][0] Id: 15
-Operator: <=
-Ordered nulls: false
-Unknown return value: true
-Negate comparison result: true
+	start position:
+		null
+	stop position:
+		null
+	qualifiers:
+		Column[0][0] Id: 15
+		Operator: <=
+		Ordered nulls: false
+		Unknown return value: true
+		Negate comparison result: true
 ij> commit;
 ij> -- matches 0 rows - should do index scan
 get cursor c as
@@ -4489,7 +4527,7 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=2
 		Number of deleted rows visited=0
@@ -4498,13 +4536,13 @@
 		<filtered number of rows visited>
 		Scan type=btree
 		Tree height=3
-		start position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-		stop position: 
-	None
+		start position:
+			> on first 1 column(s).
+			Ordered null semantics on the following columns: 
+		stop position:
+			None
 		qualifiers:
-None
+			None
 ij> commit;
 ij> -- 25% selectivity index that covers query - should do index scan
 get cursor c as
@@ -4539,7 +4577,7 @@
 	open time (milliseconds) = 0
 	next time (milliseconds) = 0
 	close time (milliseconds) = 0
-scan information: 
+scan information:
 	Bit set of columns fetched={0}
 	Number of columns fetched=1
 	Number of deleted rows visited=0
@@ -4548,14 +4586,14 @@
 	<filtered number of rows visited>
 	Scan type=btree
 	Tree height=3
-	start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-	stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
+	start position:
+		>= on first 1 column(s).
+		Ordered null semantics on the following columns: 
+	stop position:
+		> on first 1 column(s).
+		Ordered null semantics on the following columns: 
 	qualifiers:
-None
+		None
 ij> commit;
 ij> -- Now test equijoins with different selectivities and different numbers
 -- of outer rows.  The approach taken is that different join columns are
@@ -4609,17 +4647,19 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=16
 		<filtered number of pages visited>
 		<filtered number of rows qualified>
 		<filtered number of rows visited>
 		Scan type=heap
-		start position: 
-null		stop position: 
-null		qualifiers:
-None
+		start position:
+			null
+		stop position:
+			null
+		qualifiers:
+			None
 Right result set:
 	Index Row to Base Row ResultSet for TENKTUP2:
 	<filtered number of opens>
@@ -4638,7 +4678,7 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=2
 			Number of deleted rows visited=0
@@ -4647,16 +4687,16 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-			stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
+			stop position:
+				> on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			qualifiers:
-None
+				None
 ij> commit;
 ij> -- Join on unique1, 60% of rows in TENKTUP2
 get cursor c as
@@ -4704,21 +4744,23 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=16
 		<filtered number of pages visited>
 		<filtered number of rows qualified>
 		<filtered number of rows visited>
 		Scan type=heap
-		start position: 
-null		stop position: 
-null		qualifiers:
-Column[0][0] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+		start position:
+			null
+		stop position:
+			null
+		qualifiers:
+			Column[0][0] Id: 0
+			Operator: <
+			Ordered nulls: false
+			Unknown return value: false
+			Negate comparison result: false
 Right result set:
 	Index Row to Base Row ResultSet for TENKTUP2:
 	<filtered number of opens>
@@ -4737,7 +4779,7 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=2
 			Number of deleted rows visited=0
@@ -4746,20 +4788,20 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-			stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-			qualifiers:
-Column[0][0] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+			start position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
+			stop position:
+				> on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
+			qualifiers:
+				Column[0][0] Id: 0
+				Operator: <
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- Join on unique1, 25% of rows in TENKTUP2
 get cursor c as
@@ -4815,7 +4857,7 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=2
 			Number of deleted rows visited=0
@@ -4824,14 +4866,14 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	None
-			stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				None
+			stop position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			qualifiers:
-None
+				None
 Right result set:
 	Index Row to Base Row ResultSet for TENKTUP2:
 	<filtered number of opens>
@@ -4860,20 +4902,20 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	None
-			stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				None
+			stop position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			scan qualifiers:
-None
+				None
 			next qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+				Column[0][0] Id: 0
+				Operator: =
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- Join on unique1, 10% of rows in TENKTUP2
 get cursor c as
@@ -4929,7 +4971,7 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=2
 			Number of deleted rows visited=0
@@ -4938,14 +4980,14 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	None
-			stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				None
+			stop position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			qualifiers:
-None
+				None
 Right result set:
 	Index Row to Base Row ResultSet for TENKTUP2:
 	<filtered number of opens>
@@ -4974,20 +5016,20 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	None
-			stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				None
+			stop position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			scan qualifiers:
-None
+				None
 			next qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+				Column[0][0] Id: 0
+				Operator: =
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- Join on unique1, 5% of rows in TENKTUP2
 get cursor c as
@@ -5043,7 +5085,7 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=2
 			Number of deleted rows visited=0
@@ -5052,14 +5094,14 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	None
-			stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				None
+			stop position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			qualifiers:
-None
+				None
 Right result set:
 	Index Row to Base Row ResultSet for TENKTUP2:
 	<filtered number of opens>
@@ -5088,20 +5130,20 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	None
-			stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				None
+			stop position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			scan qualifiers:
-None
+				None
 			next qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+				Column[0][0] Id: 0
+				Operator: =
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- Join on unique1, 1% of rows in TENKTUP2
 get cursor c as
@@ -5157,7 +5199,7 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=2
 			Number of deleted rows visited=0
@@ -5166,14 +5208,14 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	None
-			stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				None
+			stop position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			qualifiers:
-None
+				None
 Right result set:
 	Index Row to Base Row ResultSet for TENKTUP2:
 	<filtered number of opens>
@@ -5202,20 +5244,20 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	None
-			stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				None
+			stop position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			scan qualifiers:
-None
+				None
 			next qualifiers:
-Column[0][0] Id: 0
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+				Column[0][0] Id: 0
+				Operator: =
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- Join on unique1, 1 row in TENKTUP2
 get cursor c as
@@ -5271,7 +5313,7 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=2
 			Number of deleted rows visited=0
@@ -5280,16 +5322,16 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-			stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
+			stop position:
+				> on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			qualifiers:
-None
+				None
 Right result set:
 	Index Row to Base Row ResultSet for TENKTUP2:
 	<filtered number of opens>
@@ -5308,7 +5350,7 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=2
 			Number of deleted rows visited=0
@@ -5317,16 +5359,16 @@
 			<filtered number of rows visited>
 			Scan type=btree
 			Tree height=2
-			start position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
-			stop position: 
-	> on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+			start position:
+				>= on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
+			stop position:
+				> on first 1 column(s).
+				Ordered null semantics on the following columns: 
+				0 
 			qualifiers:
-None
+				None
 ij> commit;
 ij> -- Joins on two
 -- Join on two, all rows in TENKTUP2
@@ -5373,17 +5415,19 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=16
 		<filtered number of pages visited>
 		<filtered number of rows qualified>
 		<filtered number of rows visited>
 		Scan type=heap
-		start position: 
-null		stop position: 
-null		qualifiers:
-None
+		start position:
+			null
+		stop position:
+			null
+		qualifiers:
+			None
 Right result set:
 	Table Scan ResultSet for TENKTUP2 at serializable isolation level using share table locking chosen by the optimizer
 	<filtered number of opens>
@@ -5394,21 +5438,23 @@
 		open time (milliseconds) = 0
 		next time (milliseconds) = 0
 		close time (milliseconds) = 0
-	scan information: 
+	scan information:
 		Bit set of columns fetched=All
 		Number of columns fetched=16
 		<filtered number of pages visited>
 		<filtered number of rows qualified>
 		<filtered number of rows visited>
 		Scan type=heap
-		start position: 
-null		stop position: 
-null		qualifiers:
-Column[0][0] Id: 2
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+		start position:
+			null
+		stop position:
+			null
+		qualifiers:
+			Column[0][0] Id: 2
+			Operator: =
+			Ordered nulls: false
+			Unknown return value: false
+			Negate comparison result: false
 ij> commit;
 ij> -- Join on two, 60% of rows in TENKTUP2
 get cursor c as
@@ -5469,21 +5515,23 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=16
 			<filtered number of pages visited>
 			<filtered number of rows qualified>
 			<filtered number of rows visited>
 			Scan type=heap
-			start position: 
-null			stop position: 
-null			qualifiers:
-Column[0][0] Id: 0
-Operator: <
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+			start position:
+				null
+			stop position:
+				null
+			qualifiers:
+				Column[0][0] Id: 0
+				Operator: <
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 	Right result set:
 		Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
 		<filtered number of opens>
@@ -5494,21 +5542,23 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=16
 			<filtered number of pages visited>
 			<filtered number of rows qualified>
 			<filtered number of rows visited>
 			Scan type=heap
-			start position: 
-null			stop position: 
-null			qualifiers:
-Column[0][0] Id: 2
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+			start position:
+				null
+			stop position:
+				null
+			qualifiers:
+				Column[0][0] Id: 2
+				Operator: =
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- Join on two, 25% of rows in TENKTUP2
 get cursor c as
@@ -5577,7 +5627,7 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-			scan information: 
+			scan information:
 				Bit set of columns fetched=All
 				Number of columns fetched=2
 				Number of deleted rows visited=0
@@ -5586,14 +5636,14 @@
 				<filtered number of rows visited>
 				Scan type=btree
 				Tree height=2
-				start position: 
-	None
-				stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+				start position:
+					None
+				stop position:
+					>= on first 1 column(s).
+					Ordered null semantics on the following columns: 
+					0 
 				qualifiers:
-None
+					None
 	Right result set:
 		Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
 		<filtered number of opens>
@@ -5604,21 +5654,23 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=16
 			<filtered number of pages visited>
 			<filtered number of rows qualified>
 			<filtered number of rows visited>
 			Scan type=heap
-			start position: 
-null			stop position: 
-null			qualifiers:
-Column[0][0] Id: 2
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+			start position:
+				null
+			stop position:
+				null
+			qualifiers:
+				Column[0][0] Id: 2
+				Operator: =
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- Join on two, 10% of rows in TENKTUP2
 get cursor c as
@@ -5687,7 +5739,7 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-			scan information: 
+			scan information:
 				Bit set of columns fetched=All
 				Number of columns fetched=2
 				Number of deleted rows visited=0
@@ -5696,14 +5748,14 @@
 				<filtered number of rows visited>
 				Scan type=btree
 				Tree height=2
-				start position: 
-	None
-				stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+				start position:
+					None
+				stop position:
+					>= on first 1 column(s).
+					Ordered null semantics on the following columns: 
+					0 
 				qualifiers:
-None
+					None
 	Right result set:
 		Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
 		<filtered number of opens>
@@ -5714,21 +5766,23 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=16
 			<filtered number of pages visited>
 			<filtered number of rows qualified>
 			<filtered number of rows visited>
 			Scan type=heap
-			start position: 
-null			stop position: 
-null			qualifiers:
-Column[0][0] Id: 2
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+			start position:
+				null
+			stop position:
+				null
+			qualifiers:
+				Column[0][0] Id: 2
+				Operator: =
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- Join on two, 5% of rows in TENKTUP2
 get cursor c as
@@ -5797,7 +5851,7 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-			scan information: 
+			scan information:
 				Bit set of columns fetched=All
 				Number of columns fetched=2
 				Number of deleted rows visited=0
@@ -5806,14 +5860,14 @@
 				<filtered number of rows visited>
 				Scan type=btree
 				Tree height=2
-				start position: 
-	None
-				stop position: 
-	>= on first 1 column(s).
-	Ordered null semantics on the following columns: 
-0 
+				start position:
+					None
+				stop position:
+					>= on first 1 column(s).
+					Ordered null semantics on the following columns: 
+					0 
 				qualifiers:
-None
+					None
 	Right result set:
 		Table Scan ResultSet for TENKTUP1 at serializable isolation level using share table locking chosen by the optimizer
 		<filtered number of opens>
@@ -5824,21 +5878,23 @@
 			open time (milliseconds) = 0
 			next time (milliseconds) = 0
 			close time (milliseconds) = 0
-		scan information: 
+		scan information:
 			Bit set of columns fetched=All
 			Number of columns fetched=16
 			<filtered number of pages visited>
 			<filtered number of rows qualified>
 			<filtered number of rows visited>
 			Scan type=heap
-			start position: 
-null			stop position: 
-null			qualifiers:
-Column[0][0] Id: 2
-Operator: =
-Ordered nulls: false
-Unknown return value: false
-Negate comparison result: false
+			start position:
+				null
+			stop position:
+				null
+			qualifiers:
+				Column[0][0] Id: 2
+				Operator: =
+				Ordered nulls: false
+				Unknown return value: false
+				Negate comparison result: false
 ij> commit;
 ij> -- Join on two, 1% of rows in TENKTUP2
 get cursor c as
@@ -5907,7 +5963,7 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-			scan information: 
+			scan information:
 				Bit set of columns fetched=All
 				Number of columns fetched=2
 				Number of deleted rows visited=0
@@ -5916,14 +5972,14 @@
 				<filtered number of rows visited>
 				Scan type=btree
 				Tree height=2
-				start position: 
-	None

[... 13005 lines stripped ...]


Mime
View raw message