db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From myrn...@apache.org
Subject svn commit: r1443812 [3/6] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/ suites/ tests/store/
Date Fri, 08 Feb 2013 00:51:10 GMT
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/longRow.out
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/longRow.out?rev=1443812&r1=1443811&r2=1443812&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/longRow.out (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/longRow.out Fri Feb  8 00:51:09 2013
@@ -1,4 +1,4 @@
-ij> --
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -16,8 +16,8 @@ ij> --
 --
 -- create a table with 5 rows, with 4K pageSize,
 -- this should expand over 3 pages
-run resource 'createTestProcedures.subsql';
-ij> --
+run resource '/org/apache/derbyTesting/functionTests/tests/store/createTestProcedures.subsql';
+ij(CONNECTION1)> --
 --   Licensed to the Apache Software Foundation (ASF) under one or more
 --   contributor license agreements.  See the NOTICE file distributed with
 --   this work for additional information regarding copyright ownership.
@@ -35,52 +35,52 @@ ij> --
 --
 CREATE FUNCTION  PADSTRING (DATA VARCHAR(32000), LENGTH INTEGER) RETURNS VARCHAR(32000) EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.Formatters.padString' LANGUAGE JAVA PARAMETER STYLE JAVA;
 0 rows inserted/updated/deleted
-ij> CREATE PROCEDURE WAIT_FOR_POST_COMMIT() DYNAMIC RESULT SETS 0 LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.T_Access.waitForPostCommitToFinish' PARAMETER STYLE JAVA;
+ij(CONNECTION1)> CREATE PROCEDURE WAIT_FOR_POST_COMMIT() DYNAMIC RESULT SETS 0 LANGUAGE JAVA EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.T_Access.waitForPostCommitToFinish' PARAMETER STYLE JAVA;
 0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');
+ij(CONNECTION1)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');
 0 rows inserted/updated/deleted
-ij> create table testing 
+ij(CONNECTION1)> create table testing 
 	(a varchar(2024), b varchar(1024), c varchar(1024), d varchar(2048), e varchar(300)) ;
 0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', NULL);
+ij(CONNECTION1)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', NULL);
 0 rows inserted/updated/deleted
-ij> -- insert 9 rows into the table
+ij(CONNECTION1)> -- insert 9 rows into the table
 insert into testing values (PADSTRING('1',2024),  PADSTRING('2',1024), 
        PADSTRING('3',1024), PADSTRING('4',2048),  PADSTRING('5',300));
 1 row inserted/updated/deleted
-ij> insert into testing values (PADSTRING('10',2024),  
+ij(CONNECTION1)> insert into testing values (PADSTRING('10',2024),  
        PADSTRING('20',1024), PADSTRING('30',1024), 
        PADSTRING('40',2048), PADSTRING('50',300));
 1 row inserted/updated/deleted
-ij> insert into testing values (PADSTRING('100',2024),  
+ij(CONNECTION1)> insert into testing values (PADSTRING('100',2024),  
        PADSTRING('200',1024), PADSTRING('300',1024), 
        PADSTRING('400',2048), PADSTRING('500',300));
 1 row inserted/updated/deleted
-ij> insert into testing values (PADSTRING('1000',2024),  
+ij(CONNECTION1)> insert into testing values (PADSTRING('1000',2024),  
        PADSTRING('2000',1024), PADSTRING('3000',1024), 
        PADSTRING('4000',2048), PADSTRING('5000',300));
 1 row inserted/updated/deleted
-ij> insert into testing values (PADSTRING('10000',2024),  
+ij(CONNECTION1)> insert into testing values (PADSTRING('10000',2024),  
        PADSTRING('20000',1024),	PADSTRING('30000',1024), 
        PADSTRING('40000',2048), PADSTRING('50000',300));
 1 row inserted/updated/deleted
-ij> insert into testing values (PADSTRING('100000',2024), 
+ij(CONNECTION1)> insert into testing values (PADSTRING('100000',2024), 
        PADSTRING('200000',1024), PADSTRING('300000',1024), 
        PADSTRING('400000',2048), PADSTRING('500000',300));
 1 row inserted/updated/deleted
-ij> insert into testing values (PADSTRING('1000000',2024), 
+ij(CONNECTION1)> insert into testing values (PADSTRING('1000000',2024), 
        PADSTRING('2000000',1024), PADSTRING('3000000',1024), 
        PADSTRING('4000000',2048), PADSTRING('5000000',300));
 1 row inserted/updated/deleted
-ij> insert into testing values (PADSTRING('10000000',2024), 
+ij(CONNECTION1)> insert into testing values (PADSTRING('10000000',2024), 
        PADSTRING('20000000',1024), PADSTRING('30000000',1024), 
        PADSTRING('40000000',2048), PADSTRING('50000000',300));
 1 row inserted/updated/deleted
-ij> insert into testing values (PADSTRING('100000000',2024), 
+ij(CONNECTION1)> insert into testing values (PADSTRING('100000000',2024), 
        PADSTRING('200000000',1024), PADSTRING('300000000',1024), 
        PADSTRING('400000000',2048), PADSTRING('500000000',300));
 1 row inserted/updated/deleted
-ij> -- select the whole row, or individual columns.
+ij(CONNECTION1)> -- select the whole row, or individual columns.
 -- 9 rows should be returned from each of the following selects
 select * from testing;
 A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
@@ -94,7 +94,7 @@ A                                       
 1000000                                                                                                                        &|2000000                                                                                                                        &|3000000                                                                                                                        &|4000000                                                                                                                        &|5000000                                                                                                                        &
 10000000                                                                                                                       &|20000000                                                                                                                       &|30000000                                                                                                                       &|40000000                                                                                                                       &|50000000                                                                                                                       &
 100000000                                                                                                                      &|200000000                                                                                                                      &|300000000                                                                                                                      &|400000000                                                                                                                      &|500000000                                                                                                                      &
-ij> select a from testing;
+ij(CONNECTION1)> select a from testing;
 A                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------
 1                                                                                                                              &
@@ -106,7 +106,7 @@ A                                       
 1000000                                                                                                                        &
 10000000                                                                                                                       &
 100000000                                                                                                                      &
-ij> select b from testing;
+ij(CONNECTION1)> select b from testing;
 B                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------
 2                                                                                                                              &
@@ -118,7 +118,7 @@ B                                       
 2000000                                                                                                                        &
 20000000                                                                                                                       &
 200000000                                                                                                                      &
-ij> select c from testing;
+ij(CONNECTION1)> select c from testing;
 C                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------
 3                                                                                                                              &
@@ -130,7 +130,7 @@ C                                       
 3000000                                                                                                                        &
 30000000                                                                                                                       &
 300000000                                                                                                                      &
-ij> select d from testing;
+ij(CONNECTION1)> select d from testing;
 D                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------
 4                                                                                                                              &
@@ -142,7 +142,7 @@ D                                       
 4000000                                                                                                                        &
 40000000                                                                                                                       &
 400000000                                                                                                                      &
-ij> select e from testing;
+ij(CONNECTION1)> select e from testing;
 E                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------
 5                                                                                                                              &
@@ -154,22 +154,22 @@ E                                       
 5000000                                                                                                                        &
 50000000                                                                                                                       &
 500000000                                                                                                                      &
-ij> -- insert some partial rows. 
+ij(CONNECTION1)> -- insert some partial rows. 
 insert into testing(a)  values (PADSTRING('a',2024));
 1 row inserted/updated/deleted
-ij> insert into testing(a,b) values (PADSTRING('a',2024), PADSTRING('b',1024));
+ij(CONNECTION1)> insert into testing(a,b) values (PADSTRING('a',2024), PADSTRING('b',1024));
 1 row inserted/updated/deleted
-ij> insert into testing(a,b,c) values (PADSTRING('a',2024), PADSTRING('b',1024)
+ij(CONNECTION1)> insert into testing(a,b,c) values (PADSTRING('a',2024), PADSTRING('b',1024)
 			   , PADSTRING('c',1024));
 1 row inserted/updated/deleted
-ij> insert into testing(a,b,c,d) values (PADSTRING('a',2024), PADSTRING('b',1024),
+ij(CONNECTION1)> insert into testing(a,b,c,d) values (PADSTRING('a',2024), PADSTRING('b',1024),
         PADSTRING('c',1024), PADSTRING('d',2048));
 1 row inserted/updated/deleted
-ij> insert into testing(a,b,c,d,e) values (PADSTRING('a',2024), 
+ij(CONNECTION1)> insert into testing(a,b,c,d,e) values (PADSTRING('a',2024), 
        PADSTRING('b',1024), PADSTRING('c',1024),
        PADSTRING('d',2048), PADSTRING('e',300));
 1 row inserted/updated/deleted
-ij> -- select some partial rows.
+ij(CONNECTION1)> -- select some partial rows.
 -- should select 14 rows
 select * from testing;
 A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
@@ -188,7 +188,7 @@ a                                       
 a                                                                                                                              &|b                                                                                                                              &|c                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            
 a                                                                                                                              &|b                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &|NULL                                                                                                                            
 a                                                                                                                              &|b                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &|e                                                                                                                              &
-ij> -- should select 5 rows
+ij(CONNECTION1)> -- should select 5 rows
 select * from testing where a = PADSTRING('a',2024);
 A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -197,7 +197,7 @@ a                                       
 a                                                                                                                              &|b                                                                                                                              &|c                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            
 a                                                                                                                              &|b                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &|NULL                                                                                                                            
 a                                                                                                                              &|b                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &|e                                                                                                                              &
-ij> -- should select 4 rows
+ij(CONNECTION1)> -- should select 4 rows
 select a,c,d from testing where b = PADSTRING('b',1024);
 A                                                                                                                               |C                                                                                                                               |D                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -205,12 +205,12 @@ a                                       
 a                                                                                                                              &|c                                                                                                                              &|NULL                                                                                                                            
 a                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &
 a                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &
-ij> -- should select 1 row
+ij(CONNECTION1)> -- should select 1 row
 select b, e from testing where e = PADSTRING('e',300);
 B                                                                                                                               |E                                                                                                                               
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 b                                                                                                                              &|e                                                                                                                              &
-ij> -- should select 14 rows
+ij(CONNECTION1)> -- should select 14 rows
 select a,c,e from testing order by a;
 A                                                                                                                               |C                                                                                                                               |E                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -228,14 +228,14 @@ a                                       
 a                                                                                                                              &|c                                                                                                                              &|NULL                                                                                                                            
 a                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            
 a                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            
-ij> -- update 5 rows on the main data page
+ij(CONNECTION1)> -- update 5 rows on the main data page
 update testing set a = PADSTRING('aa',2024) where a = PADSTRING('a',2024);
 5 rows inserted/updated/deleted
-ij> -- following select should return 0 rows
+ij(CONNECTION1)> -- following select should return 0 rows
 select * from testing where a = PADSTRING('a',2024);
 A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-ij> -- following select should return 5 rows
+ij(CONNECTION1)> -- following select should return 5 rows
 select * from testing where a = PADSTRING('aa',2024);
 A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ -244,95 +244,95 @@ aa                                      
 aa                                                                                                                             &|b                                                                                                                              &|c                                                                                                                              &|NULL                                                                                                                            |NULL                                                                                                                            
 aa                                                                                                                             &|b                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &|NULL                                                                                                                            
 aa                                                                                                                             &|b                                                                                                                              &|c                                                                                                                              &|d                                                                                                                              &|e                                                                                                                              &
-ij> -- update 3 rows on the overflow page
+ij(CONNECTION1)> -- update 3 rows on the overflow page
 update testing set c = PADSTRING('cc',1024) where c = PADSTRING('c',1024);
 3 rows inserted/updated/deleted
-ij> -- following should return 0 rows
+ij(CONNECTION1)> -- following should return 0 rows
 select * from testing where c = PADSTRING('c',1024);
 A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-ij> -- followign should return 3 rows
+ij(CONNECTION1)> -- followign should return 3 rows
 select a, b, c, d, e from testing where c = PADSTRING('cc',1024);
 A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 aa                                                                                                                             &|b                                                                                                                              &|cc                                                                                                                             &|NULL                                                                                                                            |NULL                                                                                                                            
 aa                                                                                                                             &|b                                                                                                                              &|cc                                                                                                                             &|d                                                                                                                              &|NULL                                                                                                                            
 aa                                                                                                                             &|b                                                                                                                              &|cc                                                                                                                             &|d                                                                                                                              &|e                                                                                                                              &
-ij> -- update 1 row on second overflow page
+ij(CONNECTION1)> -- update 1 row on second overflow page
 update testing set e = PADSTRING('ee',300) where e = PADSTRING('e',300);
 1 row inserted/updated/deleted
-ij> -- following select should return 0 rows
+ij(CONNECTION1)> -- following select should return 0 rows
 select e from testing where e = PADSTRING('e',300);
 E                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------
-ij> -- following should return 1 row
+ij(CONNECTION1)> -- following should return 1 row
 select e from testing where e = PADSTRING('ee',300);
 E                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------
 ee                                                                                                                             &
-ij> -- update all columns for 2 rows
+ij(CONNECTION1)> -- update all columns for 2 rows
 update testing set a = PADSTRING('aaa',2024), b = PADSTRING('bbb',1024), 
        c = PADSTRING('ccc',1024), d = PADSTRING('ddd',2048), 
        e = PADSTRING('eee',300) 
 	where d = PADSTRING('d',2048);
 2 rows inserted/updated/deleted
-ij> -- following select should return 0 rows
+ij(CONNECTION1)> -- following select should return 0 rows
 select * from testing where d = PADSTRING('d',2048);
 A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-ij> -- following select should return 2 rows
+ij(CONNECTION1)> -- following select should return 2 rows
 select * from testing where d = PADSTRING('ddd',2048);
 A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 aaa                                                                                                                            &|bbb                                                                                                                            &|ccc                                                                                                                            &|ddd                                                                                                                            &|eee                                                                                                                            &
 aaa                                                                                                                            &|bbb                                                                                                                            &|ccc                                                                                                                            &|ddd                                                                                                                            &|eee                                                                                                                            &
-ij> -- create a table with 6 rows
+ij(CONNECTION1)> -- create a table with 6 rows
 drop table testing;
 0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');
+ij(CONNECTION1)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');
 0 rows inserted/updated/deleted
-ij> create table testing (a varchar(500), b varchar(500), c varchar(500), d varchar(500),
+ij(CONNECTION1)> create table testing (a varchar(500), b varchar(500), c varchar(500), d varchar(500),
 	e varchar(500), f varchar(500), g varchar(500), z varchar(3900)) ;
 0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', NULL);
+ij(CONNECTION1)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', NULL);
 0 rows inserted/updated/deleted
-ij> insert into testing values (PADSTRING('1',500), PADSTRING('2',500), 
+ij(CONNECTION1)> insert into testing values (PADSTRING('1',500), PADSTRING('2',500), 
        PADSTRING('3',500), PADSTRING('4',500),
        PADSTRING('5',500), PADSTRING('6',500), 
        PADSTRING('7',500), PADSTRING('1000',3900));
 1 row inserted/updated/deleted
-ij> insert into testing values (PADSTRING('1',500), PADSTRING('2',500), 
+ij(CONNECTION1)> insert into testing values (PADSTRING('1',500), PADSTRING('2',500), 
        PADSTRING('3',500), PADSTRING('4',500),
        PADSTRING('5',500), PADSTRING('6',500), 
        PADSTRING('7',500), PADSTRING('1000',2000));
 1 row inserted/updated/deleted
-ij> select * from testing;
+ij(CONNECTION1)> select * from testing;
 A                                                                                                                               |B                                                                                                                               |C                                                                                                                               |D                                                                                                                               |E                                                                                                                               |F                                                                                                                               |G                                                                                                                               |Z                                                                                     
                                    
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 -----------------------------------
 1                                                                                                                              &|2                                                                                                                              &|3                                                                                                                              &|4                                                                                                                              &|5                                                                                                                              &|6                                                                                                                              &|7                                                                                                                              &|1000                                                                                  
                                          &
 1                                                                                                                              &|2                                                                                                                              &|3                                                                                                                              &|4                                                                                                                              &|5                                                                                                                              &|6                                                                                                                              &|7                                                                                                                              &|1000                                                                                  
                                          &
-ij> select e from testing;
+ij(CONNECTION1)> select e from testing;
 E                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------
 5                                                                                                                              &
 5                                                                                                                              &
-ij> select g from testing;
+ij(CONNECTION1)> select g from testing;
 G                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------
 7                                                                                                                              &
 7                                                                                                                              &
-ij> select z from testing;
+ij(CONNECTION1)> select z from testing;
 Z                                                                                                                               
 --------------------------------------------------------------------------------------------------------------------------------
 1000                                                                                                                           &
 1000                                                                                                                           &
-ij> -- create long rows which expand over 3 or more pages. Test that various
+ij(CONNECTION1)> -- create long rows which expand over 3 or more pages. Test that various
 -- qualifier work on the long row columns.
 drop table testing;
 0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');
+ij(CONNECTION1)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', '4096');
 0 rows inserted/updated/deleted
-ij> create table testing (
+ij(CONNECTION1)> create table testing (
     key1    int, 
     filler1 varchar(2500), 
     filler2 varchar(2500), 
@@ -344,94 +344,96 @@ ij> create table testing (
     filler6 varchar(2400),
     key4    int) ;
 0 rows inserted/updated/deleted
-ij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', NULL);
+ij(CONNECTION1)> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.pageSize', NULL);
 0 rows inserted/updated/deleted
-ij> insert into testing values (3, PADSTRING('fill1',2500), PADSTRING('fill2',2500), 30, PADSTRING('fill3',2500), PADSTRING('fill4',2500), 300, PADSTRING('fill5',2400), PADSTRING('fill6',2400), 3000);
+ij(CONNECTION1)> insert into testing values (3, PADSTRING('fill1',2500), PADSTRING('fill2',2500), 30, PADSTRING('fill3',2500), PADSTRING('fill4',2500), 300, PADSTRING('fill5',2400), PADSTRING('fill6',2400), 3000);
 1 row inserted/updated/deleted
-ij> insert into testing values (4, PADSTRING('fill1',2500), PADSTRING('fill2',2500), 40, PADSTRING('fill3',2500), PADSTRING('fill4',2500), 400, PADSTRING('fill5',2400), PADSTRING('fill6',2400), 4000);
+ij(CONNECTION1)> insert into testing values (4, PADSTRING('fill1',2500), PADSTRING('fill2',2500), 40, PADSTRING('fill3',2500), PADSTRING('fill4',2500), 400, PADSTRING('fill5',2400), PADSTRING('fill6',2400), 4000);
 1 row inserted/updated/deleted
-ij> insert into testing values (1, PADSTRING('fill1',2500), PADSTRING('fill2',2500), 10, PADSTRING('fill3',2500), PADSTRING('fill4',2500), 100, PADSTRING('fill5',2400), PADSTRING('fill6',2400), 1000);
+ij(CONNECTION1)> insert into testing values (1, PADSTRING('fill1',2500), PADSTRING('fill2',2500), 10, PADSTRING('fill3',2500), PADSTRING('fill4',2500), 100, PADSTRING('fill5',2400), PADSTRING('fill6',2400), 1000);
 1 row inserted/updated/deleted
-ij> insert into testing values (2, PADSTRING('fill1',2500), PADSTRING('fill2',2500), 20, PADSTRING('fill3',2500), PADSTRING('fill4',2500), 200, PADSTRING('fill5',2400), PADSTRING('fill6',2400), 2000);
+ij(CONNECTION1)> insert into testing values (2, PADSTRING('fill1',2500), PADSTRING('fill2',2500), 20, PADSTRING('fill3',2500), PADSTRING('fill4',2500), 200, PADSTRING('fill5',2400), PADSTRING('fill6',2400), 2000);
 1 row inserted/updated/deleted
-ij> select * from testing;
+ij(CONNECTION1)> select * from testing;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |fill1                                                                                                                          &|fill2                                                                                                                          &|30         |fill3                                                                                                                          &|fill4                                                                                                                          &|300        |fill5                                                                                                                          &|fill6                                                                                                                          &|3000       
 4          |fill1                                                                                                                          &|fill2                                                                                                                          &|40         |fill3                                                                                                                          &|fill4                                                                                                                          &|400        |fill5                                                                                                                          &|fill6                                                                                                                          &|4000       
 1          |fill1                                                                                                                          &|fill2                                                                                                                          &|10         |fill3                                                                                                                          &|fill4                                                                                                                          &|100        |fill5                                                                                                                          &|fill6                                                                                                                          &|1000       
 2          |fill1                                                                                                                          &|fill2                                                                                                                          &|20         |fill3                                                                                                                          &|fill4                                                                                                                          &|200        |fill5                                                                                                                          &|fill6                                                                                                                          &|2000       
-ij> select key2 from testing;
+ij(CONNECTION1)> select key2 from testing;
 KEY2       
 -----------
 30         
 40         
 10         
 20         
-ij> select key3 from testing;
+ij(CONNECTION1)> select key3 from testing;
 KEY3       
 -----------
 300        
 400        
 100        
 200        
-ij> select key4 from testing;
+ij(CONNECTION1)> select key4 from testing;
 KEY4       
 -----------
 3000       
 4000       
 1000       
 2000       
-ij> select * from testing where key1 = 1;
+ij(CONNECTION1)> select * from testing where key1 = 1;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |fill1                                                                                                                          &|fill2                                                                                                                          &|10         |fill3                                                                                                                          &|fill4                                                                                                                          &|100        |fill5                                                                                                                          &|fill6                                                                                                                          &|1000       
-ij> select * from testing where key2 = 20;
+ij(CONNECTION1)> select * from testing where key2 = 20;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 2          |fill1                                                                                                                          &|fill2                                                                                                                          &|20         |fill3                                                                                                                          &|fill4                                                                                                                          &|200        |fill5                                                                                                                          &|fill6                                                                                                                          &|2000       
-ij> select * from testing where key3 = 300;
+ij(CONNECTION1)> select * from testing where key3 = 300;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |fill1                                                                                                                          &|fill2                                                                                                                          &|30         |fill3                                                                                                                          &|fill4                                                                                                                          &|300        |fill5                                                                                                                          &|fill6                                                                                                                          &|3000       
-ij> select * from testing where key4 = 4000;
+ij(CONNECTION1)> select * from testing where key4 = 4000;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 4          |fill1                                                                                                                          &|fill2                                                                                                                          &|40         |fill3                                                                                                                          &|fill4                                                                                                                          &|400        |fill5                                                                                                                          &|fill6                                                                                                                          &|4000       
-ij> select * from testing where key1 = 1 and key2 = 10;
+ij(CONNECTION1)> select * from testing where key1 = 1 and key2 = 10;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |fill1                                                                                                                          &|fill2                                                                                                                          &|10         |fill3                                                                                                                          &|fill4                                                                                                                          &|100        |fill5                                                                                                                          &|fill6                                                                                                                          &|1000       
-ij> select * from testing where key2 = 20 and key3 = 200;
+ij(CONNECTION1)> select * from testing where key2 = 20 and key3 = 200;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 2          |fill1                                                                                                                          &|fill2                                                                                                                          &|20         |fill3                                                                                                                          &|fill4                                                                                                                          &|200        |fill5                                                                                                                          &|fill6                                                                                                                          &|2000       
-ij> select * from testing where key3 = 300 and key4 = 3000;
+ij(CONNECTION1)> select * from testing where key3 = 300 and key4 = 3000;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |fill1                                                                                                                          &|fill2                                                                                                                          &|30         |fill3                                                                                                                          &|fill4                                                                                                                          &|300        |fill5                                                                                                                          &|fill6                                                                                                                          &|3000       
-ij> select * from testing where key4 = 4000 and key1 = 4;
+ij(CONNECTION1)> select * from testing where key4 = 4000 and key1 = 4;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 4          |fill1                                                                                                                          &|fill2                                                                                                                          &|40         |fill3                                                                                                                          &|fill4                                                                                                                          &|400        |fill5                                                                                                                          &|fill6                                                                                                                          &|4000       
-ij> select * from testing where key1 = 1 or key2 = 20;
+ij(CONNECTION1)> select * from testing where key1 = 1 or key2 = 20;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 1          |fill1                                                                                                                          &|fill2                                                                                                                          &|10         |fill3                                                                                                                          &|fill4                                                                                                                          &|100        |fill5                                                                                                                          &|fill6                                                                                                                          &|1000       
 2          |fill1                                                                                                                          &|fill2                                                                                                                          &|20         |fill3                                                                                                                          &|fill4                                                                                                                          &|200        |fill5                                                                                                                          &|fill6                                                                                                                          &|2000       
-ij> select * from testing where key2 = 20 or key3 = 300;
+ij(CONNECTION1)> select * from testing where key2 = 20 or key3 = 300;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |fill1                                                                                                                          &|fill2                                                                                                                          &|30         |fill3                                                                                                                          &|fill4                                                                                                                          &|300        |fill5                                                                                                                          &|fill6                                                                                                                          &|3000       
 2          |fill1                                                                                                                          &|fill2                                                                                                                          &|20         |fill3                                                                                                                          &|fill4                                                                                                                          &|200        |fill5                                                                                                                          &|fill6                                                                                                                          &|2000       
-ij> select * from testing where key3 = 300 or key4 = 4000;
+ij(CONNECTION1)> select * from testing where key3 = 300 or key4 = 4000;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 3          |fill1                                                                                                                          &|fill2                                                                                                                          &|30         |fill3                                                                                                                          &|fill4                                                                                                                          &|300        |fill5                                                                                                                          &|fill6                                                                                                                          &|3000       
 4          |fill1                                                                                                                          &|fill2                                                                                                                          &|40         |fill3                                                                                                                          &|fill4                                                                                                                          &|400        |fill5                                                                                                                          &|fill6                                                                                                                          &|4000       
-ij> select * from testing where key4 = 4000 or key1 = 1;
+ij(CONNECTION1)> select * from testing where key4 = 4000 or key1 = 1;
 KEY1       |FILLER1                                                                                                                         |FILLER2                                                                                                                         |KEY2       |FILLER3                                                                                                                         |FILLER4                                                                                                                         |KEY3       |FILLER5                                                                                                                         |FILLER6                                                                                                                         |KEY4       
 -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[... 8 lines stripped ...]


Mime
View raw message