db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bpendle...@apache.org
Subject svn commit: r597922 - /db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out
Date Sat, 24 Nov 2007 22:02:51 GMT
Author: bpendleton
Date: Sat Nov 24 14:02:51 2007
New Revision: 597922

URL: http://svn.apache.org/viewvc?rev=597922&view=rev
Log:
DERBY-1734: Simplify building of SystemColumn array in CatalogRowFactory

This change is a merge of revision 566353 from the trunk.

The original change was made by Dan Debrunner (djd at apache dot org)


Modified:
    db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out

Modified: db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out?rev=597922&r1=597921&r2=597922&view=diff
==============================================================================
--- db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out
(original)
+++ db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/master/compressTable.out
Sat Nov 24 14:02:51 2007
@@ -1225,21 +1225,21 @@
 create table derby737table1 (c1 int, c2 int);
 0 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS  
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> -- create index on the table when the table is empty. No statistics will be
 --  generated for that index
 create index t1i1 on derby737table1(c1);
 0 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS  
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> -- the insert above will not add a row into sys.sysstatistics for index t1i1
 insert into derby737table1 values(1,1);
 1 row inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS  
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> -- now compress the table and as part of the compress, Derby should generate
 --  statistics for all the indexes provided the table is not empty
 call syscs_util.syscs_compress_table('APP','DERBY737TABLE1',1);
@@ -1247,9 +1247,9 @@
 ij> -- Will find statistics for index t1i1 on derby737table1 because compress
 --  table created it.
 select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS  
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true
|1          |numunique= &
+STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true
|1          |numunique= 1 n&
 ij> drop table derby737table1;
 0 rows inserted/updated/deleted
 ij> -- Next Test : Make sure that drop index will drop the existing statistics 
@@ -1258,59 +1258,59 @@
 ij> insert into derby737table2 values(1,1),(2,2);
 2 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS  
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> -- since there is data in derby737table2 when index is getting created, 
 --   statistics will be created for that index 
 create index t2i1 on derby737table2(c1);
 0 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS  
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true
|1          |numunique= &
+STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true
|1          |numunique= 2 n&
 ij> -- deleting all the rows in table will not drop the index statistics
 delete from derby737table2;
 2 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS  
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true
|1          |numunique= &
+STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true
|1          |numunique= 2 n&
 ij> -- dropping index will drop the index statistics, if they exist
 drop index t2i1;
 0 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS  
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> -- Next Test : Male sure that compress table will drop the existing statistics
 --  and will not recreate them if the table is empty
 insert into derby737table2 values(1,1),(2,2);
 2 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS  
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> -- since there is data in derby737table2 when index is getting created, 
 --   statistics will be created for that index 
 create index t2i1 on derby737table2(c1);
 0 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS  
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true
|1          |numunique= &
+STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true
|1          |numunique= 2 n&
 ij> -- deleting all the rows in table will not drop the index statistics
 delete from derby737table2;
 2 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS  
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true
|1          |numunique= &
+STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxFILTERED-UUIDxxxx|xxxxxxFILTERED-TIMESTAMPxxxxx|I|true
|1          |numunique= 2 n&
 ij> -- now compress the table and as part of the compress, Derby should drop
 --  statistics for all the indexes and should not recreate them if the
 --  user table is empty
 call syscs_util.syscs_compress_table('APP','DERBY737TABLE2',1);
 0 rows inserted/updated/deleted
 ij> select * from sys.sysstatistics;
-STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS  
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+STATID                              |REFERENCEID                         |TABLEID       
                     |CREATIONTIMESTAMP         |&|VALID|COLCOUNT   |STATISTICS     
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ij> --end derby-737 related test cases.
 -- DERBY-2057
 -- Use non-zero args other than 1s.



Mime
View raw message