You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by da...@apache.org on 2006/03/15 22:31:59 UTC
svn commit: r386169 [10/36] - in
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master:
DerbyNet/jdk16/ DerbyNetClient/jdk16/ jdk16/
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/secureUsers.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/secureUsers.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/secureUsers.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/secureUsers.out Wed Mar 15 13:31:53 2006
@@ -0,0 +1,205 @@
+ij> --
+----- Specifically test SECURE users and various authentication
+----- service/scheme configuration for different databases.
+-----
+----- Configure the 6 different databases with for each
+----- of them, a different authentication scheme.
+-----
+----- 'wombat' - default DERBY scheme &
+----- users known at system level.
+----- Some authorization restriction.
+----- 'guestSchemeDB' - No authentication
+----- 'derbySchemeDB' - BUILTIN authentication
+----- & some db authorization restriction.
+----- 'simpleSchemeDB' - BUILTIN authentication and
+----- some db authorization restriction.
+----- (was the old Cloudscape 1.5 simple scheme)
+-----
+----- let's create all the dbs and configure them.
+----- we will authenticate using a default system user that we
+----- have configured.
+----- A typical bad guy who cannot access any database but guest
+----- is Jamie.
+-----
+-----
+----- 'guestSchemeDB' database authentication/authorization config
+-----
+connect 'guestSchemeDB;create=true;user=system;password=manager';
+ij(CONNECTION1)> -- override requireAuthentication to be turned OFF at the database level
+autocommit off;
+ij(CONNECTION1)> prepare p1 as 'CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?,?)';
+ij(CONNECTION1)> execute p1 using 'values(''derby.connection.requireAuthentication'', ''false'')';
+Statement executed.
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> autocommit on;
+ij(CONNECTION1)> --
+----- 'derbySchemeDB' database authentication/authorization config
+-----
+connect 'derbySchemeDB;create=true;user=system;password=manager';
+ij(CONNECTION2)> autocommit off;
+ij(CONNECTION2)> prepare p2 as 'CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?,?)';
+ij(CONNECTION2)> execute p2 using 'values(''derby.authentication.provider'', ''BUILTIN'')';
+Statement executed.
+ij(CONNECTION2)> -- let's define users in this database (other than the ones
+----- known at the system level. This is for the test
+----- These 3 users will only be known in this database
+execute p2 using 'values(''derby.user.martin'', ''obfuscateIt'')';
+Statement executed.
+ij(CONNECTION2)> execute p2 using 'values(''derby.user.dan'', ''makeItFaster'')';
+Statement executed.
+ij(CONNECTION2)> execute p2 using 'values(''derby.user.mamta'', ''ieScape'')';
+Statement executed.
+ij(CONNECTION2)> execute p2 using 'values(''derby.database.propertiesOnly'', ''true'')';
+Statement executed.
+ij(CONNECTION2)> commit;
+ij(CONNECTION2)> autocommit on;
+ij(CONNECTION2)> --
+----- 'simpleSchemeDB' database authentication/authorization config
+-----
+connect 'simpleSchemeDB;create=true;user=system;password=manager';
+ij(CONNECTION3)> autocommit off;
+ij(CONNECTION3)> prepare p5 as 'CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?,?)';
+ij(CONNECTION3)> execute p5 using 'values(''derby.authentication.provider'', ''BUILTIN'')';
+Statement executed.
+ij(CONNECTION3)> --
+----- only allow these 3 users
+execute p5 using 'values(''derby.database.fullAccessUsers'', ''system,jeff,howardR'')';
+Statement executed.
+ij(CONNECTION3)> execute p5 using 'values(''derby.database.readOnlyAccessUsers'', ''francois'')';
+Statement executed.
+ij(CONNECTION3)> -- no access to Jamie only as he's a well known hooligan
+execute p5 using 'values(''derby.database.defaultConnectionMode'', ''noAccess'')';
+Statement executed.
+ij(CONNECTION3)> commit;
+ij(CONNECTION3)> autocommit on;
+ij(CONNECTION3)> --
+----- Shutdown the system for database properties to take effect
+-----
+disconnect all;
+ij> connect 'wombat;user=system;password=manager;shutdown=true';
+ERROR 08006: Database 'wombat' shutdown.
+ij> connect 'guestSchemeDB;user=system;password=manager;shutdown=true';
+ERROR 08006: Database 'guestSchemeDB' shutdown.
+ij> connect 'derbySchemeDB;user=system;password=manager;shutdown=true';
+ERROR (no SQLState): Connection authorization failure occurred. Reason: userid invalid.
+ij> connect 'simpleSchemeDB;user=system;password=manager;shutdown=true';
+ERROR 08006: Database 'simpleSchemeDB' shutdown.
+ij> disconnect all;
+ij> -- shuting down the system causes IJ to loose the protocol, therefore
+----- we'd be doomed :(
+#connect ';shutdown=true;user=system;password=manager';
+IJ ERROR: Unable to establish connection
+ij> -- 1) Valid authentication & authorization requests/ops
+-----
+connect 'wombat;create=true;user=kreg;password=IwasBornReady';
+ij> connect 'wombat;user=jeff;password=homeRun';
+ij(CONNECTION1)> connect 'wombat;user=howardR;password=takeItEasy';
+ij(CONNECTION2)> connect 'wombat;user=francois;password=paceesalute';
+ij(CONNECTION3)> -- Invalid ones:
+connect 'wombat;user=Jamie;password=theHooligan';
+ij(CONNECTION4)> show connections;
+CONNECTION0 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;create=true;user=kreg;password=IwasBornReady
+CONNECTION1 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=jeff;password=homeRun
+CONNECTION2 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=howardR;password=takeItEasy
+CONNECTION3 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=francois;password=paceesalute
+CONNECTION4* - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=Jamie;password=theHooligan
+* = current connection
+ij(CONNECTION4)> connect 'guestSchemeDB;user=kreg;password=IwasBornReady';
+ij(CONNECTION5)> connect 'guestSchemeDB;user=jeff;password=homeRun';
+ij(CONNECTION6)> connect 'guestSchemeDB;user=howardR;password=takeItEasy';
+ij(CONNECTION7)> connect 'guestSchemeDB;user=francois;password=paceesalute';
+ij(CONNECTION8)> -- Invalid ones:
+connect 'guestSchemeDB;user=Jamie;password=theHooligan';
+ij(CONNECTION9)> show connections;
+CONNECTION0 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;create=true;user=kreg;password=IwasBornReady
+CONNECTION1 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=jeff;password=homeRun
+CONNECTION2 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=howardR;password=takeItEasy
+CONNECTION3 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=francois;password=paceesalute
+CONNECTION4 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=Jamie;password=theHooligan
+CONNECTION5 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=kreg;password=IwasBornReady
+CONNECTION6 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=jeff;password=homeRun
+CONNECTION7 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=howardR;password=takeItEasy
+CONNECTION8 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=francois;password=paceesalute
+CONNECTION9* - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=Jamie;password=theHooligan
+* = current connection
+ij(CONNECTION9)> connect 'derbySchemeDB;user=mamta;password=ieScape';
+ij(CONNECTION10)> connect 'derbySchemeDB;user=dan;password=makeItFaster';
+ij(CONNECTION11)> connect 'derbySchemeDB;user=martin;password=obfuscateIt';
+ij(CONNECTION12)> -- Invalid ones:
+connect 'derbySchemeDB;user=Jamie;password=theHooligan';
+ERROR (no SQLState): Connection authorization failure occurred. Reason: userid invalid.
+ij(CONNECTION12)> connect 'derbySchemeDB;user=francois;password=paceesalute';
+ERROR (no SQLState): Connection authorization failure occurred. Reason: userid invalid.
+ij(CONNECTION12)> show connections;
+CONNECTION0 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;create=true;user=kreg;password=IwasBornReady
+CONNECTION1 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=jeff;password=homeRun
+CONNECTION10 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/derbySchemeDB;user=mamta;password=ieScape
+CONNECTION11 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/derbySchemeDB;user=dan;password=makeItFaster
+CONNECTION12* - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/derbySchemeDB;user=martin;password=obfuscateIt
+CONNECTION2 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=howardR;password=takeItEasy
+CONNECTION3 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=francois;password=paceesalute
+CONNECTION4 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=Jamie;password=theHooligan
+CONNECTION5 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=kreg;password=IwasBornReady
+CONNECTION6 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=jeff;password=homeRun
+CONNECTION7 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=howardR;password=takeItEasy
+CONNECTION8 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=francois;password=paceesalute
+CONNECTION9 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=Jamie;password=theHooligan
+* = current connection
+ij(CONNECTION12)> connect 'simpleSchemeDB;user=jeff;password=homeRun';
+ij(CONNECTION13)> connect 'simpleSchemeDB;user=howardR;password=takeItEasy';
+ij(CONNECTION14)> connect 'simpleSchemeDB;user=francois;password=paceesalute';
+ij(CONNECTION15)> -- Read-only user
+create table t1 (c1 int);
+ERROR 25503: DDL is not permitted for a read-only connection, user or database. :
+ij(CONNECTION15)> -- Invalid ones:
+connect 'simpleSchemeDB;user=Jamie;password=theHooligan';
+ERROR 04501: Database connection refused.
+ij(CONNECTION15)> connect 'simpleSchemeDB;user=dan;password=makeItFaster';
+ERROR (no SQLState): Connection authorization failure occurred. Reason: userid invalid.
+ij(CONNECTION15)> connect 'simpleSchemeDB;user=francois;password=corsica';
+ERROR (no SQLState): Connection authorization failure occurred. Reason: userid invalid.
+ij(CONNECTION15)> show connections;
+CONNECTION0 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;create=true;user=kreg;password=IwasBornReady
+CONNECTION1 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=jeff;password=homeRun
+CONNECTION10 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/derbySchemeDB;user=mamta;password=ieScape
+CONNECTION11 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/derbySchemeDB;user=dan;password=makeItFaster
+CONNECTION12 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/derbySchemeDB;user=martin;password=obfuscateIt
+CONNECTION13 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/simpleSchemeDB;user=jeff;password=homeRun
+CONNECTION14 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/simpleSchemeDB;user=howardR;password=takeItEasy
+CONNECTION15* - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/simpleSchemeDB;user=francois;password=paceesalute
+CONNECTION2 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=howardR;password=takeItEasy
+CONNECTION3 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=francois;password=paceesalute
+CONNECTION4 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/wombat;user=Jamie;password=theHooligan
+CONNECTION5 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=kreg;password=IwasBornReady
+CONNECTION6 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=jeff;password=homeRun
+CONNECTION7 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=howardR;password=takeItEasy
+CONNECTION8 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=francois;password=paceesalute
+CONNECTION9 - jdbc:derby:net://xxxFILTERED_HOSTNAMExxx:1527/guestSchemeDB;user=Jamie;password=theHooligan
+* = current connection
+ij(CONNECTION15)> disconnect all;
+ij> show connections;
+No connections available.
+ij> -- Database shutdown - check user - should fail
+connect 'derbySchemeDB;shutdown=true';
+ERROR (no SQLState): Connection authorization failure occurred. Reason: userid invalid.
+ij> show connections;
+No connections available.
+ij> -- Database shutdown - check user - should succeed
+connect 'wombat;user=jeff;password=homeRun;shutdown=true';
+ERROR 08006: Database 'wombat' shutdown.
+ij> connect 'guestSchemeDB;user=kreg;password=IwasBornReady;shutdown=true';
+ERROR 08006: Database 'guestSchemeDB' shutdown.
+ij> connect 'derbySchemeDB;user=mamta;password=ieScape;shutdown=true';
+ERROR 08006: Database 'derbySchemeDB' shutdown.
+ij> connect 'simpleSchemeDB;user=jeff;password=homeRun;shutdown=true';
+ERROR 08006: Database 'simpleSchemeDB' shutdown.
+ij> show connections;
+No connections available.
+ij> -- Derby system shutdown - check user - should fail
+connect ';user=jamie;password=LetMeIn;shutdown=true';
+ERROR (no SQLState): Connection authorization failure occurred. Reason: userid invalid.
+ij> disconnect all;
+ij> -- Derby system shutdown - check user - should succeed
+connect ';user=system;password=manager;shutdown=true';
+ERROR XJ015: Derby system shutdown.
+ij>
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/setTransactionIsolation.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/setTransactionIsolation.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/setTransactionIsolation.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/setTransactionIsolation.out Wed Mar 15 13:31:53 2006
@@ -0,0 +1,567 @@
+Creating table...
+done creating table and inserting data.
+*** testIsolation. makeNewStatements =true
+*** Test with no lock timeouts ***
+***testLevelsAndPrintStatistics sql:select * from t1 makenewStatements:true
+con.prepareStatement(select * from t1)
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+con.prepareStatement(select * from t1)
+select * from t1
+1
+-----
+Statement Name:
+ null
+Statement Text:
+ select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text:
+Table Scan ResultSet for T1 at read uncommitted isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+ constructor time (milliseconds) = 0
+ open time (milliseconds) = 0
+ next time (milliseconds) = 0
+ close time (milliseconds) = 0
+scan information:
+ Bit set of columns fetched=All
+ Number of columns fetched=2
+ Number of pages visited=0
+ Number of rows qualified=0
+ Number of rows visited=0
+ Scan type=heap
+ start position:
+null stop position:
+null qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+con.prepareStatement(select * from t1)
+select * from t1
+1
+-----
+Statement Name:
+ null
+Statement Text:
+ select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text:
+Table Scan ResultSet for T1 at repeatable read isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+ constructor time (milliseconds) = 0
+ open time (milliseconds) = 0
+ next time (milliseconds) = 0
+ close time (milliseconds) = 0
+scan information:
+ Bit set of columns fetched=All
+ Number of columns fetched=2
+ Number of pages visited=0
+ Number of rows qualified=0
+ Number of rows visited=0
+ Scan type=heap
+ start position:
+null stop position:
+null qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+con.prepareStatement(select * from t1)
+select * from t1
+1
+-----
+Statement Name:
+ null
+Statement Text:
+ select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text:
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+ constructor time (milliseconds) = 0
+ open time (milliseconds) = 0
+ next time (milliseconds) = 0
+ close time (milliseconds) = 0
+scan information:
+ Bit set of columns fetched=All
+ Number of columns fetched=2
+ Number of pages visited=0
+ Number of rows qualified=0
+ Number of rows visited=0
+ Scan type=heap
+ start position:
+null stop position:
+null qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+con.prepareStatement(select * from t1)
+select * from t1
+1
+-----
+Statement Name:
+ null
+Statement Text:
+ select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text:
+Table Scan ResultSet for T1 at serializable isolation level using share table locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+ constructor time (milliseconds) = 0
+ open time (milliseconds) = 0
+ next time (milliseconds) = 0
+ close time (milliseconds) = 0
+scan information:
+ Bit set of columns fetched=All
+ Number of columns fetched=2
+ Number of pages visited=0
+ Number of rows qualified=0
+ Number of rows visited=0
+ Scan type=heap
+ start position:
+null stop position:
+null qualifiers:
+None
+***testLevelsAndPrintStatistics sql:insert into t1copy (select * from t1) makenewStatements:true
+con.prepareStatement(insert into t1copy (select * from t1))
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+*** Test with lock timeouts on everything but read uncommitted***
+conn :insert into t1 values(4,'Forth Hello') (no commit)
+***testLevelsAndPrintStatistics sql:select * from t1 makenewStatements:true
+con.prepareStatement(select * from t1)
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+con.prepareStatement(select * from t1)
+select * from t1
+1
+-----
+Statement Name:
+ null
+Statement Text:
+ select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text:
+Table Scan ResultSet for T1 at read uncommitted isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+ constructor time (milliseconds) = 0
+ open time (milliseconds) = 0
+ next time (milliseconds) = 0
+ close time (milliseconds) = 0
+scan information:
+ Bit set of columns fetched=All
+ Number of columns fetched=2
+ Number of pages visited=0
+ Number of rows qualified=0
+ Number of rows visited=0
+ Scan type=heap
+ start position:
+null stop position:
+null qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+con.prepareStatement(select * from t1)
+select * from t1
+1
+-----
+Statement Name:
+ null
+Statement Text:
+ select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text:
+Table Scan ResultSet for T1 at repeatable read isolation level using share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+ constructor time (milliseconds) = 0
+ open time (milliseconds) = 0
+ next time (milliseconds) = 0
+ close time (milliseconds) = 0
+scan information:
+ Bit set of columns fetched=All
+ Number of columns fetched=2
+ Number of pages visited=0
+ Number of rows qualified=0
+ Number of rows visited=0
+ Scan type=heap
+ start position:
+null stop position:
+null qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+con.prepareStatement(select * from t1)
+select * from t1
+1
+-----
+Statement Name:
+ null
+Statement Text:
+ select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text:
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+ constructor time (milliseconds) = 0
+ open time (milliseconds) = 0
+ next time (milliseconds) = 0
+ close time (milliseconds) = 0
+scan information:
+ Bit set of columns fetched=All
+ Number of columns fetched=2
+ Number of pages visited=0
+ Number of rows qualified=0
+ Number of rows visited=0
+ Scan type=heap
+ start position:
+null stop position:
+null qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+con.prepareStatement(select * from t1)
+select * from t1
+A lock could not be obtained within the time requested :
+***testLevelsAndPrintStatistics sql:insert into t1copy (select * from t1) makenewStatements:true
+con.prepareStatement(insert into t1copy (select * from t1))
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested :
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested :
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+con.prepareStatement(insert into t1copy (select * from t1))
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested :
+*** testIsolation. makeNewStatements =false
+*** Test with no lock timeouts ***
+***testLevelsAndPrintStatistics sql:select * from t1 makenewStatements:false
+con.prepareStatement(select * from t1)
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+select * from t1
+1
+-----
+Statement Name:
+ null
+Statement Text:
+ select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text:
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+ constructor time (milliseconds) = 0
+ open time (milliseconds) = 0
+ next time (milliseconds) = 0
+ close time (milliseconds) = 0
+scan information:
+ Bit set of columns fetched=All
+ Number of columns fetched=2
+ Number of pages visited=0
+ Number of rows qualified=0
+ Number of rows visited=0
+ Scan type=heap
+ start position:
+null stop position:
+null qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+select * from t1
+1
+-----
+Statement Name:
+ null
+Statement Text:
+ select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text:
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+ constructor time (milliseconds) = 0
+ open time (milliseconds) = 0
+ next time (milliseconds) = 0
+ close time (milliseconds) = 0
+scan information:
+ Bit set of columns fetched=All
+ Number of columns fetched=2
+ Number of pages visited=0
+ Number of rows qualified=0
+ Number of rows visited=0
+ Scan type=heap
+ start position:
+null stop position:
+null qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+select * from t1
+1
+-----
+Statement Name:
+ null
+Statement Text:
+ select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text:
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+ constructor time (milliseconds) = 0
+ open time (milliseconds) = 0
+ next time (milliseconds) = 0
+ close time (milliseconds) = 0
+scan information:
+ Bit set of columns fetched=All
+ Number of columns fetched=2
+ Number of pages visited=0
+ Number of rows qualified=0
+ Number of rows visited=0
+ Scan type=heap
+ start position:
+null stop position:
+null qualifiers:
+None
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+select * from t1
+1
+-----
+Statement Name:
+ null
+Statement Text:
+ select * from t1
+Parse Time: 0
+Bind Time: 0
+Optimize Time: 0
+Generate Time: 0
+Compile Time: 0
+Execute Time: 0
+Begin Compilation Timestamp : null
+End Compilation Timestamp : null
+Begin Execution Timestamp : null
+End Execution Timestamp : null
+Statement Execution Plan Text:
+Table Scan ResultSet for T1 at read committed isolation level using instantaneous share row locking chosen by the optimizer
+Number of opens = 1
+Rows seen = 0
+Rows filtered = 0
+Fetch Size = 16
+ constructor time (milliseconds) = 0
+ open time (milliseconds) = 0
+ next time (milliseconds) = 0
+ close time (milliseconds) = 0
+scan information:
+ Bit set of columns fetched=All
+ Number of columns fetched=2
+ Number of pages visited=0
+ Number of rows qualified=0
+ Number of rows visited=0
+ Scan type=heap
+ start position:
+null stop position:
+null qualifiers:
+None
+***testLevelsAndPrintStatistics sql:insert into t1copy (select * from t1) makenewStatements:false
+con.prepareStatement(insert into t1copy (select * from t1))
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+insert into t1copy (select * from t1)
+null
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+insert into t1copy (select * from t1)
+null
+*** Test with lock timeouts on everything but read uncommitted***
+conn :insert into t1 values(4,'Forth Hello') (no commit)
+***testLevelsAndPrintStatistics sql:select * from t1 makenewStatements:false
+con.prepareStatement(select * from t1)
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+select * from t1
+A lock could not be obtained within the time requested :
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+select * from t1
+'Statement' already closed. :
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+select * from t1
+'Statement' already closed. :
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+select * from t1
+'Statement' already closed. :
+***testLevelsAndPrintStatistics sql:insert into t1copy (select * from t1) makenewStatements:false
+con.prepareStatement(insert into t1copy (select * from t1))
+con.setTransactionIsolation(TRANSACTION_READ_UNCOMMITTED:1)
+con.getTransactionIsolation() =TRANSACTION_READ_UNCOMMITTED:1
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested :
+con.setTransactionIsolation(TRANSACTION_REAPEATABLE_READ:4)
+con.getTransactionIsolation() =TRANSACTION_REAPEATABLE_READ:4
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested :
+con.setTransactionIsolation(TRANSACTION_READ_COMMITTED:2)
+con.getTransactionIsolation() =TRANSACTION_READ_COMMITTED:2
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested :
+con.setTransactionIsolation(TRANSACTION_SERIALIZABLE:8)
+con.getTransactionIsolation() =TRANSACTION_SERIALIZABLE:8
+insert into t1copy (select * from t1)
+A lock could not be obtained within the time requested :
+FAIL: setTransactionIsolation() did not throw exception with open hold cursor
Added: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/supersimple.out
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/supersimple.out?rev=386169&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/supersimple.out (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/jdk16/supersimple.out Wed Mar 15 13:31:53 2006
@@ -0,0 +1,194 @@
+ij> -- by default, holdability of ResultSet objects created using this Connection object is true. Following will set it to false for this connection.
+NoHoldForConnection;
+ij> create table a (a int);
+0 rows inserted/updated/deleted
+ij> insert into a values (1);
+1 row inserted/updated/deleted
+ij> select * from a;
+A
+-----
+1
+ij> drop table a;
+0 rows inserted/updated/deleted
+ij> create table b (si smallint,i int, bi bigint, r real, f float, d double precision, n5_2 numeric(5,2), dec10_3 decimal(10,3), ch20 char(20),vc varchar(20), lvc long varchar, blobCol blob(1000), clobCol clob(1000));
+0 rows inserted/updated/deleted
+ij> insert into b values(2,3,4,5.3,5.3,5.3,31.13,123456.123, 'one','one','one',cast(X'01ABCD' as blob(1000)),'one');
+1 row inserted/updated/deleted
+ij> insert into b values(-32768,-2147483648, -9223372036854775808 ,1.2E-37, 2.225E-307, +2.225E-307,-56.12, -123456.123,'one','one','one', cast(X'01ABCD' as blob(1000)),'one');
+1 row inserted/updated/deleted
+ij> insert into b values(null,null,null,null,null,null,null,null,null,null,null,null,null);
+1 row inserted/updated/deleted
+ij> insert into b values(32767,2147483647, 9223372036854775807 ,1.4 , 3.4028235E38 ,3.4028235E38 ,999.99, 9999999.999,'one','one','one',cast(X'01ABCD' as blob(1000)), 'one');
+1 row inserted/updated/deleted
+ij> select * from b;
+SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
+-----
+2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
+-----32768 |-2147483648 |-9223372036854775808 |1.2E-37 |2.225E-307 |2.225E-307 |-56.12 |-123456.123 |one |one |one |01abcd |one
+NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL |NULL
+32767 |2147483647 |9223372036854775807 |1.4 |3.4028235E38 |3.4028235E38 |999.99 |9999999.999 |one |one |one |01abcd |one
+ij> drop table b;
+0 rows inserted/updated/deleted
+ij> create table c (si smallint not null,i int not null , bi bigint not null, r real not null, f float not null, d double precision not null, n5_2 numeric(5,2) not null , dec10_3 decimal(10,3) not null, ch20 char(20) not null ,vc varchar(20) not null, lvc long varchar not null, blobCol blob(1000) not null, clobCol clob(1000) not null);
+0 rows inserted/updated/deleted
+ij> insert into c values(2,3,4,5.3,5.3,5.3,31.13,123456.123, 'one','one','one', cast(X'01ABCD' as blob(1000)), 'one');
+1 row inserted/updated/deleted
+ij> insert into c values(-32768,-2147483648, -9223372036854775808 ,1.2E-37, 2.225E-307, +2.225E-307,-56.12, -123456.123,'one','one','one', cast(X'01ABCD' as blob(1000)),'one');
+1 row inserted/updated/deleted
+ij> select * from c;
+SI |I |BI |R |F |D |N5_2 |DEC10_3 |CH20 |VC |LVC |BLOBCOL |CLOBCOL
+-----
+2 |3 |4 |5.3 |5.3 |5.3 |31.13 |123456.123 |one |one |one |01abcd |one
+-----32768 |-2147483648 |-9223372036854775808 |1.2E-37 |2.225E-307 |2.225E-307 |-56.12 |-123456.123 |one |one |one |01abcd |one
+ij> values(10);
+1
+-----
+10
+ij> values('hello');
+1
+-----
+hello
+ij> values(1.2);
+1
+-----
+1.2
+ij> drop table c;
+0 rows inserted/updated/deleted
+ij> -- bug 4430 aliasinfo nullability problem
+select aliasinfo from sys.sysaliases where aliasinfo is null;
+ALIASINFO
+-----
+ij> -- test commit and rollback
+autocommit off;
+ij> create table a(a int);
+0 rows inserted/updated/deleted
+ij> insert into a values (1);
+1 row inserted/updated/deleted
+ij> select * from a;
+A
+-----
+1
+ij> commit;
+ij> drop table a;
+0 rows inserted/updated/deleted
+ij> rollback;
+ij> select * from a;
+A
+-----
+1
+ij> drop table a;
+0 rows inserted/updated/deleted
+ij> commit;
+ij> autocommit on;
+ij> maximumdisplaywidth 5000;
+ij> --test 84 columns
+ values(1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
+11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
+21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
+31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
+41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
+51, 52, 53, 54, 55, 56, 57, 58, 59, 60,
+61, 62, 63, 64, 65, 66, 67, 68, 69, 70,
+71, 72, 73, 74, 75, 76, 77, 78, 79, 80,
+81, 82, 83, 84);
+1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21 |22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40 |41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59 |60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78 |79 |80 |81 |82 |83 |84
+-----
+1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21 |22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40 |41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59 |60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78 |79 |80 |81 |82 |83 |84
+ij> values(1, 2, 3, 4, 5, 6, 7, 8, 9, 10,
+11, 12, 13, 14, 15, 16, 17, 18, 19, 20,
+21, 22, 23, 24, 25, 26, 27, 28, 29, 30,
+31, 32, 33, 34, 35, 36, 37, 38, 39, 40,
+41, 42, 43, 44, 45, 46, 47, 48, 49, 50,
+51, 52, 53, 54, 55, 56, 57, 58, 59, 60,
+61, 62, 63, 64, 65, 66, 67, 68, 69, 70,
+71, 72, 73, 74, 75, 76, 77, 78, 79, 80,
+81, 82, 83, 84, 85, 86, 87, 88, 89, 90,
+91, 92, 93, 94, 95, 96, 97, 98, 99, 100);
+1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21 |22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40 |41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59 |60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78 |79 |80 |81 |82 |83 |84 |85 |86
+-----
+1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21 |22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40 |41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59 |60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78 |79 |80 |81 |82 |83 |84 |85 |86 |87 |88 |89 |90 |91 |92 |93 |94 |95 |96 |97 |98 |99 |100
+ij> -- test SQL Error with non-string arguments
+----- Make sure connection still ok (Bug 4657)
+create table a (a int);
+0 rows inserted/updated/deleted
+ij> insert into a values(2342323423) ;
+ERROR 22003: The resulting value is outside the range for the data type INTEGER. :
+ij> insert into a values(1);
+1 row inserted/updated/deleted
+ij> select * from a;
+A
+-----
+1
+ij> drop table a;
+0 rows inserted/updated/deleted
+ij> -- Bug 4694 Test automatic rollback with close of connection
+----- in ij
+connect 'wombat';
+ij(CONNECTION1)> autocommit off;
+ij(CONNECTION1)> create table a (a int);
+0 rows inserted/updated/deleted
+ij(CONNECTION1)> select count(*) from a;
+1
+-----
+0
+ij(CONNECTION1)> disconnect;
+ij> set connection connection0;
+ij> select count(*) from a;
+ERROR 42X05: Table 'A' does not exist. :
+ij> -- Bug 4758 - Store error does not return properly to client
+autocommit off;
+ij> create table t (i int);
+0 rows inserted/updated/deleted
+ij> insert into t values(1);
+1 row inserted/updated/deleted
+ij> commit;
+ij> insert into t values(2);
+1 row inserted/updated/deleted
+ij> connect 'wombat';
+ij(CONNECTION1)> -- by default, holdability of ResultSet objects created using this Connection object is true. Following will set it to false for this connection.
+NoHoldForConnection;
+ij(CONNECTION1)> prepare s1 as 'select * from t';
+ij(CONNECTION1)> execute s1;
+I
+-----
+ERROR 40XL1: A lock could not be obtained within the time requested :
+ij(CONNECTION1)> execute s1;
+I
+-----
+ERROR 40XL1: A lock could not be obtained within the time requested :
+ij(CONNECTION1)> -- Bug 5967 - Selecting from 2 lob columns w/ the first one having data of length 0
+create table t1 (c1 clob(10), c2 clob(10));
+0 rows inserted/updated/deleted
+ij(CONNECTION1)> insert into t1 values ('', 'some clob');
+1 row inserted/updated/deleted
+ij(CONNECTION1)> select * from t1;
+C1 |C2
+-----
+ |some clob
+ij(CONNECTION1)> select c2 from t1;
+C2
+-----
+some clob
+ij(CONNECTION1)> insert into t1 values ('', '');
+1 row inserted/updated/deleted
+ij(CONNECTION1)> insert into t1 values ('some clob', '');
+1 row inserted/updated/deleted
+ij(CONNECTION1)> select * from t1;
+C1 |C2
+-----
+ |some clob
+ |
+some clob |
+ij(CONNECTION1)> select c2 from t1;
+C2
+-----
+some clob
+ij(CONNECTION1)> drop table t1;
+0 rows inserted/updated/deleted
+ij(CONNECTION1)> commit;
+ij(CONNECTION1)> disconnect;
+ij> set connection connection0;
+ij> autocommit on;
+ij> drop table t;
+0 rows inserted/updated/deleted
+ij>