db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r124989 - in incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master tests/lang
Date Wed, 12 Jan 2005 20:31:06 GMT
Author: djd
Date: Wed Jan 12 12:31:03 2005
New Revision: 124989

URL: http://svn.apache.org/viewcvs?view=rev&rev=124989
Log:
Add initial test case to autoincrement.sql of IDENTITY_VAL_LOCAL (one that returns NULL)
Modify predicatesIntoViews to allow passing on Linux/Unix.

Modified:
   incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/autoincrement.out
   incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/predicatesIntoViews.out
   incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/autoincrement.sql
   incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/predicatesIntoViews.sql

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/autoincrement.out
Url: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/autoincrement.out?view=diff&rev=124989&p1=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/autoincrement.out&r1=124988&p2=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/autoincrement.out&r2=124989
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/autoincrement.out
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/autoincrement.out
Wed Jan 12 12:31:03 2005
@@ -97,7 +97,12 @@
 ij> drop table ai4;
 0 rows inserted/updated/deleted
 ij> -- **** simple increment tests.
-create table ai_short (i int, 
+-- should return null as no single insert has been executed
+values IDENTITY_VAL_LOCAL();
+1                              
+-------------------------------
+NULL                           
+ij> create table ai_short (i int, 
 				       ais smallint generated always as identity (start with 0, increment by 2));
 0 rows inserted/updated/deleted
 ij> insert into ai_short (i) values (0);

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/predicatesIntoViews.out
Url: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/predicatesIntoViews.out?view=diff&rev=124989&p1=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/predicatesIntoViews.out&r1=124988&p2=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/predicatesIntoViews.out&r2=124989
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/predicatesIntoViews.out
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/predicatesIntoViews.out
Wed Jan 12 12:31:03 2005
@@ -35,7 +35,7 @@
 8 rows inserted/updated/deleted
 ij> call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
 0 rows inserted/updated/deleted
-ij> maximumdisplaywidth 2000;
+ij> maximumdisplaywidth 20000;
 ij> -- predicate should get pushed into scan
 select c1, c2 from sv1 where c1 = 1 order by c1, c2;
 C1         |C2         
@@ -109,7 +109,25 @@
 			Rows filtered = 0
 			Fetch Size = 1
 				constructor time (milliseconds) = 0
-				open time&
+				open time (milliseconds) = 0
+				next time (milliseconds) = 0
+				close time (milliseconds) = 0
+				next time in milliseconds/row = 0
+			scan information: 
+				Bit set of columns fetched=All
+				Number of columns fetched=3
+				Number of pages visited=1
+				Number of rows qualified=4
+				Number of rows visited=8
+				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
 ij> select c1, c2 from sv1 where c1 = 1  + 1 order by c1, c2;
 C1         |C2         
 -----------------------
@@ -182,7 +200,24 @@
 			Fetch Size = 1
 				constructor time (milliseconds) = 0
 				open time (milliseconds) = 0
-				next time (mi&
+				next time (milliseconds) = 0
+				close time (milliseconds) = 0
+				next time in milliseconds/row = 0
+			scan information: 
+				Bit set of columns fetched=All
+				Number of columns fetched=3
+				Number of pages visited=1
+				Number of rows qualified=4
+				Number of rows visited=8
+				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
 ij> select x1, x2 from sv2 where x1 = 1 order by x1, x2;
 X1         |X2         
 -----------------------
@@ -255,7 +290,24 @@
 			Fetch Size = 1
 				constructor time (milliseconds) = 0
 				open time (milliseconds) = 0
-				next time (millise&
+				next time (milliseconds) = 0
+				close time (milliseconds) = 0
+				next time in milliseconds/row = 0
+			scan information: 
+				Bit set of columns fetched=All
+				Number of columns fetched=3
+				Number of pages visited=1
+				Number of rows qualified=4
+				Number of rows visited=8
+				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
 ij> select y1, y2 from sv3 where y1 = 1 order by y1, y2;
 Y1         |Y2         
 -----------------------
@@ -331,7 +383,34 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-				res&
+				restriction time (milliseconds) = 0
+				projection time (milliseconds) = 0
+			Source result set:
+				Table Scan ResultSet for T1 at serializable isolation level using share table locking
chosen by the optimizer
+				Number of opens = 1
+				Rows seen = 4
+				Rows filtered = 0
+				Fetch Size = 1
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+					next time in milliseconds/row = 0
+				scan information: 
+					Bit set of columns fetched=All
+					Number of columns fetched=3
+					Number of pages visited=1
+					Number of rows qualified=4
+					Number of rows visited=8
+					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
 ij> select z1, z2, z4, z5 from sv4 where z1 = z4 and z2 = z5
 order by z1, z2, z4, z5;
 Z1         |Z2         |Z4         |Z5         
@@ -419,7 +498,64 @@
 			Rows returned = 16
 				constructor time (milliseconds) = 0
 				open time (milliseconds) = 0
-				next time (milliseco&
+				next time (milliseconds) = 0
+				close time (milliseconds) = 0
+			Left result set:
+				Table Scan ResultSet for T1 at serializable isolation level using share table locking
chosen by the optimizer
+				Number of opens = 1
+				Rows seen = 8
+				Rows filtered = 0
+				Fetch Size = 1
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+					next time in milliseconds/row = 0
+				scan information: 
+					Bit set of columns fetched=All
+					Number of columns fetched=3
+					Number of pages visited=1
+					Number of rows qualified=8
+					Number of rows visited=8
+					Scan type=heap
+					start position: 
+null					stop position: 
+null					qualifiers:
+None
+			Right result set:
+				Hash Scan ResultSet for T1 at serializable isolation level using share table locking:

+				Number of opens = 8
+				Hash table size = 4
+				Hash keys are column numbers (0,1)
+				Rows seen = 16
+				Rows filtered = 0
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+					next time in milliseconds/row = 0
+				scan information: 
+					Bit set of columns fetched=All
+					Number of columns fetched=3
+					Number of pages visited=1
+					Number of rows qualified=8
+					Number of rows visited=8
+					Scan type=heap
+					start position: 
+null					stop position: 
+null					scan qualifiers:
+None
+					next qualifiers:
+Column[0][0] Id: 0
+Operator: =
+Ordered nulls: false
+Unknown return value: false
+Negate comparison result: false
+Column[0][1] Id: 1
+Operator: =
+Ordered nulls: false
+Unknown return value: false
+Negate comparison result: false
 ij> select * from av1 where c1 = 1;
 C1         |C2         
 -----------------------
@@ -489,7 +625,23 @@
 				constructor time (milliseconds) = 0
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
-				close ti&
+				close time (milliseconds) = 0
+				next time in milliseconds/row = 0
+			scan information: 
+				Bit set of columns fetched={0, 1}
+				Number of columns fetched=2
+				Number of pages visited=1
+				Number of rows qualified=4
+				Number of rows visited=8
+				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
 ij> select * from av2 where x1 = 2;
 X1         |X2         
 -----------------------
@@ -561,7 +713,60 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-				restriction time (millisec&
+				restriction time (milliseconds) = 0
+				projection time (milliseconds) = 0
+			Source result set:
+				Grouped Aggregate ResultSet:
+				Number of opens = 1
+				Rows input = 4
+				Has distinct aggregate = false
+				In sorted order = false
+				Sort information: 
+					Number of rows input=4
+					Number of rows output=1
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+				Source result set:
+					Project-Restrict ResultSet (4):
+					Number of opens = 1
+					Rows seen = 4
+					Rows filtered = 0
+					restriction = false
+					projection = true
+						constructor time (milliseconds) = 0
+						open time (milliseconds) = 0
+						next time (milliseconds) = 0
+						close time (milliseconds) = 0
+						restriction time (milliseconds) = 0
+						projection time (milliseconds) = 0
+					Source result set:
+						Table Scan ResultSet for T1 at serializable isolation level using share table locking
chosen by the optimizer
+						Number of opens = 1
+						Rows seen = 4
+						Rows filtered = 0
+						Fetch Size = 1
+							constructor time (milliseconds) = 0
+							open time (milliseconds) = 0
+							next time (milliseconds) = 0
+							close time (milliseconds) = 0
+							next time in milliseconds/row = 0
+						scan information: 
+							Bit set of columns fetched={0, 1}
+							Number of columns fetched=2
+							Number of pages visited=1
+							Number of rows qualified=4
+							Number of rows visited=8
+							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
 ij> select * from av3;
 Y1         |Y2         |Y3         |Y4         
 -----------------------------------------------
@@ -641,7 +846,70 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-				rest&
+				restriction time (milliseconds) = 0
+				projection time (milliseconds) = 0
+			Source result set:
+				Hash Join ResultSet:
+				Number of opens = 1
+				Rows seen from the left = 8
+				Rows seen from the right = 32
+				Rows filtered = 0
+				Rows returned = 32
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+				Left result set:
+					Table Scan ResultSet for T1 at serializable isolation level using share table locking
chosen by the optimizer
+					Number of opens = 1
+					Rows seen = 8
+					Rows filtered = 0
+					Fetch Size = 1
+						constructor time (milliseconds) = 0
+						open time (milliseconds) = 0
+						next time (milliseconds) = 0
+						close time (milliseconds) = 0
+						next time in milliseconds/row = 0
+					scan information: 
+						Bit set of columns fetched={0, 1}
+						Number of columns fetched=2
+						Number of pages visited=1
+						Number of rows qualified=8
+						Number of rows visited=8
+						Scan type=heap
+						start position: 
+null						stop position: 
+null						qualifiers:
+None
+				Right result set:
+					Hash Scan ResultSet for T1 at serializable isolation level using share table locking:

+					Number of opens = 8
+					Hash table size = 2
+					Hash key is column number 0
+					Rows seen = 32
+					Rows filtered = 0
+						constructor time (milliseconds) = 0
+						open time (milliseconds) = 0
+						next time (milliseconds) = 0
+						close time (milliseconds) = 0
+						next time in milliseconds/row = 0
+					scan information: 
+						Bit set of columns fetched={0, 1}
+						Number of columns fetched=2
+						Number of pages visited=1
+						Number of rows qualified=8
+						Number of rows visited=8
+						Scan type=heap
+						start position: 
+null						stop position: 
+null						scan qualifiers:
+None
+						next qualifiers:
+Column[0][0] Id: 0
+Operator: =
+Ordered nulls: false
+Unknown return value: false
+Negate comparison result: false
 ij> select * from cv1;
 C1         |C2         
 -----------------------
@@ -718,7 +986,34 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-				restriction time (millisec&
+				restriction time (milliseconds) = 0
+				projection time (milliseconds) = 0
+			Source result set:
+				Table Scan ResultSet for T1 at serializable isolation level using share table locking
chosen by the optimizer
+				Number of opens = 1
+				Rows seen = 4
+				Rows filtered = 0
+				Fetch Size = 1
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+					next time in milliseconds/row = 0
+				scan information: 
+					Bit set of columns fetched={0, 1}
+					Number of columns fetched=2
+					Number of pages visited=1
+					Number of rows qualified=4
+					Number of rows visited=8
+					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
 ij> create index t1_c1 on t1(c1);
 0 rows inserted/updated/deleted
 ij> select c1, c2 from sv1 where c1 = 1 order by c1, c2;
@@ -794,7 +1089,33 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-				optimizer estimated r&
+				Index Scan ResultSet for T1 using index T1_C1 at serializable isolation level using share
row locking chosen by the optimizer
+				Number of opens = 1
+				Rows seen = 4
+				Rows filtered = 0
+				Fetch Size = 1
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+					next time in milliseconds/row = 0
+				scan information: 
+					Bit set of columns fetched=All
+					Number of columns fetched=2
+					Number of deleted rows visited=0
+					Number of pages visited=1
+					Number of rows qualified=4
+					Number of rows visited=5
+					Scan type=btree
+					Tree height=1
+					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
 ij> select x1, x2 from sv2 where x1 = 1 order by x1, x2;
 X1         |X2         
 -----------------------
@@ -868,7 +1189,33 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-				optimizer estimated r&
+				Index Scan ResultSet for T1 using index T1_C1 at serializable isolation level using share
row locking chosen by the optimizer
+				Number of opens = 1
+				Rows seen = 4
+				Rows filtered = 0
+				Fetch Size = 1
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+					next time in milliseconds/row = 0
+				scan information: 
+					Bit set of columns fetched=All
+					Number of columns fetched=2
+					Number of deleted rows visited=0
+					Number of pages visited=1
+					Number of rows qualified=4
+					Number of rows visited=5
+					Scan type=btree
+					Tree height=1
+					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
 ij> select y1, y2 from sv3 where y1 = 1 order by y1, y2;
 Y1         |Y2         
 -----------------------
@@ -944,7 +1291,44 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-				res&
+				restriction time (milliseconds) = 0
+				projection time (milliseconds) = 0
+			Source result set:
+				Index Row to Base Row ResultSet for T1:
+				Number of opens = 1
+				Rows seen = 4
+				Columns accessed from heap = {1, 2}
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+					Index Scan ResultSet for T1 using index T1_C1 at serializable isolation level using
share row locking chosen by the optimizer
+					Number of opens = 1
+					Rows seen = 4
+					Rows filtered = 0
+					Fetch Size = 1
+						constructor time (milliseconds) = 0
+						open time (milliseconds) = 0
+						next time (milliseconds) = 0
+						close time (milliseconds) = 0
+						next time in milliseconds/row = 0
+					scan information: 
+						Bit set of columns fetched=All
+						Number of columns fetched=2
+						Number of deleted rows visited=0
+						Number of pages visited=1
+						Number of rows qualified=4
+						Number of rows visited=5
+						Scan type=btree
+						Tree height=1
+						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
 ij> select z1, z2, z4, z5 from sv4 where z1 = z4 and z2 = z5
 order by z1, z2, z4, z5;
 Z1         |Z2         |Z4         |Z5         
@@ -1032,7 +1416,64 @@
 			Rows returned = 16
 				constructor time (milliseconds) = 0
 				open time (milliseconds) = 0
-				next time (milliseco&
+				next time (milliseconds) = 0
+				close time (milliseconds) = 0
+			Left result set:
+				Table Scan ResultSet for T1 at serializable isolation level using share table locking
chosen by the optimizer
+				Number of opens = 1
+				Rows seen = 8
+				Rows filtered = 0
+				Fetch Size = 1
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+					next time in milliseconds/row = 0
+				scan information: 
+					Bit set of columns fetched=All
+					Number of columns fetched=3
+					Number of pages visited=1
+					Number of rows qualified=8
+					Number of rows visited=8
+					Scan type=heap
+					start position: 
+null					stop position: 
+null					qualifiers:
+None
+			Right result set:
+				Hash Scan ResultSet for T1 at serializable isolation level using share table locking:

+				Number of opens = 8
+				Hash table size = 4
+				Hash keys are column numbers (0,1)
+				Rows seen = 16
+				Rows filtered = 0
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+					next time in milliseconds/row = 0
+				scan information: 
+					Bit set of columns fetched=All
+					Number of columns fetched=3
+					Number of pages visited=1
+					Number of rows qualified=8
+					Number of rows visited=8
+					Scan type=heap
+					start position: 
+null					stop position: 
+null					scan qualifiers:
+None
+					next qualifiers:
+Column[0][0] Id: 0
+Operator: =
+Ordered nulls: false
+Unknown return value: false
+Negate comparison result: false
+Column[0][1] Id: 1
+Operator: =
+Ordered nulls: false
+Unknown return value: false
+Negate comparison result: false
 ij> select * from av1 where c1 = 1;
 C1         |C2         
 -----------------------
@@ -1099,7 +1540,33 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-				Index Scan ResultSet for T1 using index T1&
+				Index Scan ResultSet for T1 using index T1_C1 at serializable isolation level using share
row locking chosen by the optimizer
+				Number of opens = 1
+				Rows seen = 4
+				Rows filtered = 0
+				Fetch Size = 1
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+					next time in milliseconds/row = 0
+				scan information: 
+					Bit set of columns fetched=All
+					Number of columns fetched=2
+					Number of deleted rows visited=0
+					Number of pages visited=1
+					Number of rows qualified=4
+					Number of rows visited=5
+					Scan type=btree
+					Tree height=1
+					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
 ij> select * from av2 where x1 = 2;
 X1         |X2         
 -----------------------
@@ -1171,7 +1638,67 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-				restriction time (millisec&
+				restriction time (milliseconds) = 0
+				projection time (milliseconds) = 0
+			Source result set:
+				Grouped Aggregate ResultSet:
+				Number of opens = 1
+				Rows input = 4
+				Has distinct aggregate = false
+				In sorted order = true
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+				Source result set:
+					Project-Restrict ResultSet (5):
+					Number of opens = 1
+					Rows seen = 4
+					Rows filtered = 0
+					restriction = false
+					projection = true
+						constructor time (milliseconds) = 0
+						open time (milliseconds) = 0
+						next time (milliseconds) = 0
+						close time (milliseconds) = 0
+						restriction time (milliseconds) = 0
+						projection time (milliseconds) = 0
+					Source result set:
+						Index Row to Base Row ResultSet for T1:
+						Number of opens = 1
+						Rows seen = 4
+						Columns accessed from heap = {1}
+							constructor time (milliseconds) = 0
+							open time (milliseconds) = 0
+							next time (milliseconds) = 0
+							close time (milliseconds) = 0
+							Index Scan ResultSet for T1 using index T1_C1 at serializable isolation level using
share row locking chosen by the optimizer
+							Number of opens = 1
+							Rows seen = 4
+							Rows filtered = 0
+							Fetch Size = 1
+								constructor time (milliseconds) = 0
+								open time (milliseconds) = 0
+								next time (milliseconds) = 0
+								close time (milliseconds) = 0
+								next time in milliseconds/row = 0
+							scan information: 
+								Bit set of columns fetched=All
+								Number of columns fetched=2
+								Number of deleted rows visited=0
+								Number of pages visited=1
+								Number of rows qualified=4
+								Number of rows visited=4
+								Scan type=btree
+								Tree height=1
+								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
 ij> select y1, y2, y3, y4 + 0 from av3 where y1 = y2;
 Y1         |Y2         |Y3         |4          
 -----------------------------------------------
@@ -1244,7 +1771,70 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-				rest&
+				restriction time (milliseconds) = 0
+				projection time (milliseconds) = 0
+			Source result set:
+				Hash Join ResultSet:
+				Number of opens = 1
+				Rows seen from the left = 8
+				Rows seen from the right = 32
+				Rows filtered = 0
+				Rows returned = 32
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+				Left result set:
+					Table Scan ResultSet for T1 at serializable isolation level using share table locking
chosen by the optimizer
+					Number of opens = 1
+					Rows seen = 8
+					Rows filtered = 0
+					Fetch Size = 1
+						constructor time (milliseconds) = 0
+						open time (milliseconds) = 0
+						next time (milliseconds) = 0
+						close time (milliseconds) = 0
+						next time in milliseconds/row = 0
+					scan information: 
+						Bit set of columns fetched={0, 1}
+						Number of columns fetched=2
+						Number of pages visited=1
+						Number of rows qualified=8
+						Number of rows visited=8
+						Scan type=heap
+						start position: 
+null						stop position: 
+null						qualifiers:
+None
+				Right result set:
+					Hash Scan ResultSet for T1 at serializable isolation level using share table locking:

+					Number of opens = 8
+					Hash table size = 2
+					Hash key is column number 0
+					Rows seen = 32
+					Rows filtered = 0
+						constructor time (milliseconds) = 0
+						open time (milliseconds) = 0
+						next time (milliseconds) = 0
+						close time (milliseconds) = 0
+						next time in milliseconds/row = 0
+					scan information: 
+						Bit set of columns fetched={0, 1}
+						Number of columns fetched=2
+						Number of pages visited=1
+						Number of rows qualified=8
+						Number of rows visited=8
+						Scan type=heap
+						start position: 
+null						stop position: 
+null						scan qualifiers:
+None
+						next qualifiers:
+Column[0][0] Id: 0
+Operator: =
+Ordered nulls: false
+Unknown return value: false
+Negate comparison result: false
 ij> select * from cv1 where c1 = 1;
 C1         |C2         
 -----------------------
@@ -1316,7 +1906,44 @@
 				open time (milliseconds) = 0
 				next time (milliseconds) = 0
 				close time (milliseconds) = 0
-				restriction time (millisec&
+				restriction time (milliseconds) = 0
+				projection time (milliseconds) = 0
+			Source result set:
+				Index Row to Base Row ResultSet for T1:
+				Number of opens = 1
+				Rows seen = 4
+				Columns accessed from heap = {1}
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+					Index Scan ResultSet for T1 using index T1_C1 at serializable isolation level using
share row locking chosen by the optimizer
+					Number of opens = 1
+					Rows seen = 4
+					Rows filtered = 0
+					Fetch Size = 1
+						constructor time (milliseconds) = 0
+						open time (milliseconds) = 0
+						next time (milliseconds) = 0
+						close time (milliseconds) = 0
+						next time in milliseconds/row = 0
+					scan information: 
+						Bit set of columns fetched=All
+						Number of columns fetched=2
+						Number of deleted rows visited=0
+						Number of pages visited=1
+						Number of rows qualified=4
+						Number of rows visited=5
+						Scan type=btree
+						Tree height=1
+						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
 ij> -- cleanup
 drop view cv1;
 0 rows inserted/updated/deleted
@@ -5223,7 +5850,7 @@
 ij> -- Now do really what I wanted (this gets NullPointerException before the fix):
 call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
 0 rows inserted/updated/deleted
-ij> maximumdisplaywidth 20000;
+ij> maximumdisplaywidth 40000;
 ij> SELECT id, versionid, name, versionName, folderid, uri, versionuri, ownerid, ownername,
ownerauthid,
        description, versionComment, objecttype, subtypeid, subtype, createdate,versiondate,
        changedate, deletedate, versioncontrolled, currentversion, previousversion, checkedout,
@@ -5739,6 +6366,74 @@
 						constructor time (milliseconds) = 0
 						open time (milliseconds) = 0
 						next time (milliseconds) = 0
-						close time (milliseco&
+						close time (milliseconds) = 0
+					scan information: 
+						start position: 
+null						stop position: 
+null						scan qualifiers:
+None
+						next qualifiers:
+Column[0][0] Id: 0
+Operator: =
+Ordered nulls: false
+Unknown return value: false
+Negate comparison result: false
+			Right result set:
+				Hash Scan ResultSet for CLASSIFICATIONSCHEME at serializable isolation level using share
table locking: 
+				Number of opens = 0
+				Hash table size = 0
+				Hash key is column number 0
+				Rows seen = 0
+				Rows filtered = 0
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+				scan information: 
+					start position: 
+null					stop position: 
+null					scan qualifiers:
+None
+					next qualifiers:
+Column[0][0] Id: 0
+Operator: =
+Ordered nulls: false
+Unknown return value: false
+Negate comparison result: false
+		Right result set:
+			Project-Restrict ResultSet (31):
+			Number of opens = 0
+			Rows seen = 0
+			Rows filtered = 0
+			restriction = true
+			projection = false
+				constructor time (milliseconds) = 0
+				open time (milliseconds) = 0
+				next time (milliseconds) = 0
+				close time (milliseconds) = 0
+				restriction time (milliseconds) = 0
+				projection time (milliseconds) = 0
+			Source result set:
+				Hash Scan ResultSet for VERSIONLABEL at serializable isolation level using share table
locking: 
+				Number of opens = 0
+				Hash table size = 0
+				Hash key is column number 0
+				Rows seen = 0
+				Rows filtered = 0
+					constructor time (milliseconds) = 0
+					open time (milliseconds) = 0
+					next time (milliseconds) = 0
+					close time (milliseconds) = 0
+				scan information: 
+					start position: 
+null					stop position: 
+null					scan qualifiers:
+None
+					next qualifiers:
+Column[0][0] Id: 0
+Operator: =
+Ordered nulls: false
+Unknown return value: false
+Negate comparison result: false
 ij> rollback;
 ij> 

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/autoincrement.sql
Url: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/autoincrement.sql?view=diff&rev=124989&p1=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/autoincrement.sql&r1=124988&p2=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/autoincrement.sql&r2=124989
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/autoincrement.sql
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/autoincrement.sql
Wed Jan 12 12:31:03 2005
@@ -60,6 +60,10 @@
 
 -- **** simple increment tests.
 
+-- should return null as no single insert has been executed
+values IDENTITY_VAL_LOCAL();
+
+
 create table ai_short (i int, 
 				       ais smallint generated always as identity (start with 0, increment by 2));
 insert into ai_short (i) values (0);

Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/predicatesIntoViews.sql
Url: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/predicatesIntoViews.sql?view=diff&rev=124989&p1=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/predicatesIntoViews.sql&r1=124988&p2=incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/predicatesIntoViews.sql&r2=124989
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/predicatesIntoViews.sql
(original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/predicatesIntoViews.sql
Wed Jan 12 12:31:03 2005
@@ -32,7 +32,7 @@
 
 
 call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
-maximumdisplaywidth 2000;
+maximumdisplaywidth 20000;
 
 -- predicate should get pushed into scan
 select c1, c2 from sv1 where c1 = 1 order by c1, c2;
@@ -4174,7 +4174,7 @@
 -- Now do really what I wanted (this gets NullPointerException before the fix):
 
 call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
-maximumdisplaywidth 20000;
+maximumdisplaywidth 40000;
 
 SELECT id, versionid, name, versionName, folderid, uri, versionuri, ownerid, ownername, ownerauthid,
        description, versionComment, objecttype, subtypeid, subtype, createdate,versiondate,

Mime
View raw message