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 ba...@apache.org on 2005/10/28 14:52:21 UTC
svn commit: r329187 [47/66] - in /db/derby/code/trunk: ./
frameworks/NetworkServer/ frameworks/NetworkServer/bin/
frameworks/embedded/bin/ java/build/ java/build/org/apache/derbyBuild/
java/build/org/apache/derbyBuild/eclipse/ java/build/org/apache/der...
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/intersect.sql
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/intersect.sql?rev=329187&r1=329186&r2=329187&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/intersect.sql (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/intersect.sql Fri Oct 28 04:51:50 2005
@@ -1,162 +1,162 @@
-create table t1( id integer not null primary key, i1 integer, i2 integer, c10 char(10), c30 char(30), tm time);
-create table t2( id integer not null primary key, i1 integer, i2 integer, vc20 varchar(20), d double, dt date);
-insert into t1(id,i1,i2,c10,c30) values
- (1,1,1,'a','123456789012345678901234567890'),
- (2,1,2,'a','bb'),
- (3,1,3,'b','bb'),
- (4,1,3,'zz','5'),
- (5,null,null,null,'1.0'),
- (6,null,null,null,'a');
-insert into t2(id,i1,i2,vc20,d) values
- (1,1,1,'a',1.0),
- (2,1,2,'a',1.1),
- (5,null,null,'12345678901234567890',3),
- (100,1,3,'zz',3),
- (101,1,2,'bb',null),
- (102,5,5,'',null),
- (103,1,3,' a',null),
- (104,1,3,'null',7.4);
-
--- no duplicates
-select id,i1,i2 from t1 intersect select id,i1,i2 from t2 order by id DESC,i1,i2;
-select id,i1,i2 from t1 intersect distinct select id,i1,i2 from t2 order by id DESC,i1,i2;
-select id,i1,i2 from t1 intersect all select id,i1,i2 from t2 order by 1,2,3;
-
--- Only specify order by on some columns
-select id,i1,i2 from t1 intersect select id,i1,i2 from t2 order by i2, id DESC;
-select id,i1,i2 from t1 intersect all select id,i1,i2 from t2 order by 3 DESC, 1;
-
--- duplicates
-select i1,i2 from t1 intersect select i1,i2 from t2 order by 1,2;
-select i1,i2 from t1 intersect distinct select i1,i2 from t2 order by 1,2;
-select i1,i2 from t1 intersect all select i1,i2 from t2 order by 1,2;
-
--- right side is empty
-select i1,i2 from t1 intersect select i1,i2 from t2 where id = -1;
-select i1,i2 from t1 intersect all select i1,i2 from t2 where id = -1;
-
--- left side is empty
-select i1,i2 from t1 where id = -1 intersect all select i1,i2 from t2;
-
--- check precedence
-select i1,i2 from t1 intersect all select i1,i2 from t2 intersect values(5,5),(1,3) order by 1,2;
-(select i1,i2 from t1 intersect all select i1,i2 from t2) intersect values(5,5),(1,3) order by 1,2;
-
-values(-1,-1,-1) union select id,i1,i2 from t1 intersect select id,i1,i2 from t2 order by 1,2,3;
-select id,i1,i2 from t1 intersect select id,i1,i2 from t2 union values(-1,-1,-1) order by 1,2,3;
-
--- check conversions
-select c10 from t1 intersect select vc20 from t2 order by 1;
-select c30 from t1 intersect select vc20 from t2;
-select c30 from t1 intersect all select vc20 from t2;
-
--- check insert intersect into table and intersect without order by
-create table r( i1 integer, i2 integer);
-insert into r select i1,i2 from t1 intersect select i1,i2 from t2;
-select i1,i2 from r order by 1,2;
-delete from r;
-
-insert into r select i1,i2 from t1 intersect all select i1,i2 from t2;
-select i1,i2 from r order by 1,2;
-delete from r;
-
--- test LOB
-create table t3( i1 integer, cl clob(64), bl blob(1M));
-insert into t3 values
- (1, cast( 'aa' as clob(64)), cast(X'01' as blob(1M)));
-create table t4( i1 integer, cl clob(64), bl blob(1M));
-insert into t4 values
- (1, cast( 'aa' as clob(64)), cast(X'01' as blob(1M)));
-
-select cl from t3 intersect select cl from t4 order by 1;
-
-select bl from t3 intersect select bl from t4 order by 1;
-
--- invalid conversion
-select tm from t1 intersect select dt from t2;
-select c30 from t1 intersect select d from t2;
-
--- different number of columns
-select i1 from t1 intersect select i1,i2 from t2;
-
--- ? in select list of intersect
-select ? from t1 intersect select i1 from t2;
-select i1 from t1 intersect select ? from t2;
-
--- except tests
-select id,i1,i2 from t1 except select id,i1,i2 from t2 order by id,i1,i2;
-select id,i1,i2 from t1 except distinct select id,i1,i2 from t2 order by id,i1,i2;
-select id,i1,i2 from t1 except all select id,i1,i2 from t2 order by 1 DESC,2,3;
-select id,i1,i2 from t2 except select id,i1,i2 from t1 order by 1,2,3;
-select id,i1,i2 from t2 except all select id,i1,i2 from t1 order by 1,2,3;
-
-select i1,i2 from t1 except select i1,i2 from t2 order by 1,2;
-select i1,i2 from t1 except distinct select i1,i2 from t2 order by 1,2;
-select i1,i2 from t1 except all select i1,i2 from t2 order by 1,2;
-select i1,i2 from t2 except select i1,i2 from t1 order by 1,2;
-select i1,i2 from t2 except all select i1,i2 from t1 order by 1,2;
-
--- right side is empty
-select i1,i2 from t1 except select i1,i2 from t2 where id = -1 order by 1,2;
-select i1,i2 from t1 except all select i1,i2 from t2 where id = -1 order by 1,2;
-
--- left side is empty
-select i1,i2 from t1 where id = -1 except select i1,i2 from t2 order by 1,2;
-select i1,i2 from t1 where id = -1 except all select i1,i2 from t2 order by 1,2;
-
--- Check precedence. Union and except have the same precedence. Intersect has higher precedence.
-select i1,i2 from t1 except select i1,i2 from t2 intersect values(-1,-1) order by 1,2;
-select i1,i2 from t1 except (select i1,i2 from t2 intersect values(-1,-1)) order by 1,2;
-select i1,i2 from t2 except select i1,i2 from t1 union values(5,5) order by 1,2;
-(select i1,i2 from t2 except select i1,i2 from t1) union values(5,5) order by 1,2;
-select i1,i2 from t2 except all select i1,i2 from t1 except select i1,i2 from t1 where id = 3 order by 1,2;
-(select i1,i2 from t2 except all select i1,i2 from t1) except select i1,i2 from t1 where id = 3 order by 1,2;
-
--- check conversions
-select c10 from t1 except select vc20 from t2 order by 1;
-select c30 from t1 except select vc20 from t2 order by 1;
-select c30 from t1 except all select vc20 from t2;
-
--- check insert except into table and except without order by
-insert into r select i1,i2 from t2 except select i1,i2 from t1;
-select i1,i2 from r order by 1,2;
-delete from r;
-
-insert into r select i1,i2 from t2 except all select i1,i2 from t1;
-select i1,i2 from r order by 1,2;
-delete from r;
-
--- test LOB
-select cl from t3 except select cl from t4 order by 1;
-select bl from t3 except select bl from t4 order by 1;
-
--- invalid conversion
-select tm from t1 except select dt from t2;
-select c30 from t1 except select d from t2;
-
--- different number of columns
-select i1 from t1 except select i1,i2 from t2;
-
--- ? in select list of except
-select ? from t1 except select i1 from t2;
-
--- Invalid order by
-select id,i1,i2 from t1 intersect select id,i1,i2 from t2 order by t1.i1;
-select id,i1,i2 from t1 except select id,i1,i2 from t2 order by t1.i1;
-
--- views using intersect and except
-create view view_intr_uniq as select id,i1,i2 from t1 intersect select id,i1,i2 from t2;
-select * from view_intr_uniq order by 1 DESC,2,3;
-
-create view view_intr_all as select id,i1,i2 from t1 intersect all select id,i1,i2 from t2;
-select * from view_intr_all order by 1,2,3;
-
-create view view_ex_uniq as select id,i1,i2 from t1 except select id,i1,i2 from t2;
-select * from view_ex_uniq order by 1,2,3;
-
-create view view_ex_all as select id,i1,i2 from t1 except all select id,i1,i2 from t2;
-select * from view_ex_all order by 1 DESC,2,3;
-
--- intersect joins
-select t1.id,t1.i1,t2.i1 from t1 join t2 on t1.id = t2.id
-intersect select t1.id,t1.i2,t2.i2 from t1 join t2 on t1.id = t2.id;
+create table t1( id integer not null primary key, i1 integer, i2 integer, c10 char(10), c30 char(30), tm time);
+create table t2( id integer not null primary key, i1 integer, i2 integer, vc20 varchar(20), d double, dt date);
+insert into t1(id,i1,i2,c10,c30) values
+ (1,1,1,'a','123456789012345678901234567890'),
+ (2,1,2,'a','bb'),
+ (3,1,3,'b','bb'),
+ (4,1,3,'zz','5'),
+ (5,null,null,null,'1.0'),
+ (6,null,null,null,'a');
+insert into t2(id,i1,i2,vc20,d) values
+ (1,1,1,'a',1.0),
+ (2,1,2,'a',1.1),
+ (5,null,null,'12345678901234567890',3),
+ (100,1,3,'zz',3),
+ (101,1,2,'bb',null),
+ (102,5,5,'',null),
+ (103,1,3,' a',null),
+ (104,1,3,'null',7.4);
+
+-- no duplicates
+select id,i1,i2 from t1 intersect select id,i1,i2 from t2 order by id DESC,i1,i2;
+select id,i1,i2 from t1 intersect distinct select id,i1,i2 from t2 order by id DESC,i1,i2;
+select id,i1,i2 from t1 intersect all select id,i1,i2 from t2 order by 1,2,3;
+
+-- Only specify order by on some columns
+select id,i1,i2 from t1 intersect select id,i1,i2 from t2 order by i2, id DESC;
+select id,i1,i2 from t1 intersect all select id,i1,i2 from t2 order by 3 DESC, 1;
+
+-- duplicates
+select i1,i2 from t1 intersect select i1,i2 from t2 order by 1,2;
+select i1,i2 from t1 intersect distinct select i1,i2 from t2 order by 1,2;
+select i1,i2 from t1 intersect all select i1,i2 from t2 order by 1,2;
+
+-- right side is empty
+select i1,i2 from t1 intersect select i1,i2 from t2 where id = -1;
+select i1,i2 from t1 intersect all select i1,i2 from t2 where id = -1;
+
+-- left side is empty
+select i1,i2 from t1 where id = -1 intersect all select i1,i2 from t2;
+
+-- check precedence
+select i1,i2 from t1 intersect all select i1,i2 from t2 intersect values(5,5),(1,3) order by 1,2;
+(select i1,i2 from t1 intersect all select i1,i2 from t2) intersect values(5,5),(1,3) order by 1,2;
+
+values(-1,-1,-1) union select id,i1,i2 from t1 intersect select id,i1,i2 from t2 order by 1,2,3;
+select id,i1,i2 from t1 intersect select id,i1,i2 from t2 union values(-1,-1,-1) order by 1,2,3;
+
+-- check conversions
+select c10 from t1 intersect select vc20 from t2 order by 1;
+select c30 from t1 intersect select vc20 from t2;
+select c30 from t1 intersect all select vc20 from t2;
+
+-- check insert intersect into table and intersect without order by
+create table r( i1 integer, i2 integer);
+insert into r select i1,i2 from t1 intersect select i1,i2 from t2;
+select i1,i2 from r order by 1,2;
+delete from r;
+
+insert into r select i1,i2 from t1 intersect all select i1,i2 from t2;
+select i1,i2 from r order by 1,2;
+delete from r;
+
+-- test LOB
+create table t3( i1 integer, cl clob(64), bl blob(1M));
+insert into t3 values
+ (1, cast( 'aa' as clob(64)), cast(X'01' as blob(1M)));
+create table t4( i1 integer, cl clob(64), bl blob(1M));
+insert into t4 values
+ (1, cast( 'aa' as clob(64)), cast(X'01' as blob(1M)));
+
+select cl from t3 intersect select cl from t4 order by 1;
+
+select bl from t3 intersect select bl from t4 order by 1;
+
+-- invalid conversion
+select tm from t1 intersect select dt from t2;
+select c30 from t1 intersect select d from t2;
+
+-- different number of columns
+select i1 from t1 intersect select i1,i2 from t2;
+
+-- ? in select list of intersect
+select ? from t1 intersect select i1 from t2;
+select i1 from t1 intersect select ? from t2;
+
+-- except tests
+select id,i1,i2 from t1 except select id,i1,i2 from t2 order by id,i1,i2;
+select id,i1,i2 from t1 except distinct select id,i1,i2 from t2 order by id,i1,i2;
+select id,i1,i2 from t1 except all select id,i1,i2 from t2 order by 1 DESC,2,3;
+select id,i1,i2 from t2 except select id,i1,i2 from t1 order by 1,2,3;
+select id,i1,i2 from t2 except all select id,i1,i2 from t1 order by 1,2,3;
+
+select i1,i2 from t1 except select i1,i2 from t2 order by 1,2;
+select i1,i2 from t1 except distinct select i1,i2 from t2 order by 1,2;
+select i1,i2 from t1 except all select i1,i2 from t2 order by 1,2;
+select i1,i2 from t2 except select i1,i2 from t1 order by 1,2;
+select i1,i2 from t2 except all select i1,i2 from t1 order by 1,2;
+
+-- right side is empty
+select i1,i2 from t1 except select i1,i2 from t2 where id = -1 order by 1,2;
+select i1,i2 from t1 except all select i1,i2 from t2 where id = -1 order by 1,2;
+
+-- left side is empty
+select i1,i2 from t1 where id = -1 except select i1,i2 from t2 order by 1,2;
+select i1,i2 from t1 where id = -1 except all select i1,i2 from t2 order by 1,2;
+
+-- Check precedence. Union and except have the same precedence. Intersect has higher precedence.
+select i1,i2 from t1 except select i1,i2 from t2 intersect values(-1,-1) order by 1,2;
+select i1,i2 from t1 except (select i1,i2 from t2 intersect values(-1,-1)) order by 1,2;
+select i1,i2 from t2 except select i1,i2 from t1 union values(5,5) order by 1,2;
+(select i1,i2 from t2 except select i1,i2 from t1) union values(5,5) order by 1,2;
+select i1,i2 from t2 except all select i1,i2 from t1 except select i1,i2 from t1 where id = 3 order by 1,2;
+(select i1,i2 from t2 except all select i1,i2 from t1) except select i1,i2 from t1 where id = 3 order by 1,2;
+
+-- check conversions
+select c10 from t1 except select vc20 from t2 order by 1;
+select c30 from t1 except select vc20 from t2 order by 1;
+select c30 from t1 except all select vc20 from t2;
+
+-- check insert except into table and except without order by
+insert into r select i1,i2 from t2 except select i1,i2 from t1;
+select i1,i2 from r order by 1,2;
+delete from r;
+
+insert into r select i1,i2 from t2 except all select i1,i2 from t1;
+select i1,i2 from r order by 1,2;
+delete from r;
+
+-- test LOB
+select cl from t3 except select cl from t4 order by 1;
+select bl from t3 except select bl from t4 order by 1;
+
+-- invalid conversion
+select tm from t1 except select dt from t2;
+select c30 from t1 except select d from t2;
+
+-- different number of columns
+select i1 from t1 except select i1,i2 from t2;
+
+-- ? in select list of except
+select ? from t1 except select i1 from t2;
+
+-- Invalid order by
+select id,i1,i2 from t1 intersect select id,i1,i2 from t2 order by t1.i1;
+select id,i1,i2 from t1 except select id,i1,i2 from t2 order by t1.i1;
+
+-- views using intersect and except
+create view view_intr_uniq as select id,i1,i2 from t1 intersect select id,i1,i2 from t2;
+select * from view_intr_uniq order by 1 DESC,2,3;
+
+create view view_intr_all as select id,i1,i2 from t1 intersect all select id,i1,i2 from t2;
+select * from view_intr_all order by 1,2,3;
+
+create view view_ex_uniq as select id,i1,i2 from t1 except select id,i1,i2 from t2;
+select * from view_ex_uniq order by 1,2,3;
+
+create view view_ex_all as select id,i1,i2 from t1 except all select id,i1,i2 from t2;
+select * from view_ex_all order by 1 DESC,2,3;
+
+-- intersect joins
+select t1.id,t1.i1,t2.i1 from t1 join t2 on t1.id = t2.id
+intersect select t1.id,t1.i2,t2.i2 from t1 join t2 on t1.id = t2.id;
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/intersect.sql
------------------------------------------------------------------------------
svn:eol-style = native
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/joinDeadlock.sql1
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/joinDeadlock.sql1?rev=329187&r1=329186&r2=329187&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/joinDeadlock.sql1 (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/joinDeadlock.sql1 Fri Oct 28 04:51:50 2005
@@ -1,14 +1,14 @@
--- user 1 for bug 1573
--- a deadlock when reopening a join gets an assertion
--- violation in close()
-create table outer1(c1 int);
-create index o1_i1 on outer1(c1);
-insert into outer1 values 1, 2;
-insert into inner1 values 1, 2;
-insert into inner2 values 1, 2;
-autocommit off;
--- this user will get lock timeout in subquery on 2nd next
-get cursor c1 as 'select * from outer1 where c1 <= (select count(*) from inner1 properties index = i1_i1, inner2 properties index = i2_i1 where outer1.c1 = outer1.c1)';
-next c1;
-next c1;
-values 1;
+-- user 1 for bug 1573
+-- a deadlock when reopening a join gets an assertion
+-- violation in close()
+create table outer1(c1 int);
+create index o1_i1 on outer1(c1);
+insert into outer1 values 1, 2;
+insert into inner1 values 1, 2;
+insert into inner2 values 1, 2;
+autocommit off;
+-- this user will get lock timeout in subquery on 2nd next
+get cursor c1 as 'select * from outer1 where c1 <= (select count(*) from inner1 properties index = i1_i1, inner2 properties index = i2_i1 where outer1.c1 = outer1.c1)';
+next c1;
+next c1;
+values 1;
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/joinDeadlock.sql1
------------------------------------------------------------------------------
svn:eol-style = native
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/joinDeadlock.sql2
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/joinDeadlock.sql2?rev=329187&r1=329186&r2=329187&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/joinDeadlock.sql2 (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/joinDeadlock.sql2 Fri Oct 28 04:51:50 2005
@@ -1,12 +1,12 @@
--- user 2 for bug 1573
--- a deadlock when reopening a join gets an assertion
--- violation in close()
-create table inner1(c1 int, c2 char(500));
-create index i1_i1 on inner1(c1);
-create table inner2(c1 int, c2 char(500));
-create index i2_i1 on inner2(c1);
-values 1;
-autocommit off;
-values 1;
-update inner1 set c1 = c1 where c1 = 1;
-values 1;
+-- user 2 for bug 1573
+-- a deadlock when reopening a join gets an assertion
+-- violation in close()
+create table inner1(c1 int, c2 char(500));
+create index i1_i1 on inner1(c1);
+create table inner2(c1 int, c2 char(500));
+create index i2_i1 on inner2(c1);
+values 1;
+autocommit off;
+values 1;
+update inner1 set c1 = c1 where c1 = 1;
+values 1;
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/joinDeadlock.sql2
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/langUnitTests.sql
------------------------------------------------------------------------------
svn:eol-style = native
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/langUnitTests_derby.properties
------------------------------------------------------------------------------
svn:eol-style = native
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure_app.properties
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure_app.properties?rev=329187&r1=329186&r2=329187&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure_app.properties (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure_app.properties Fri Oct 28 04:51:50 2005
@@ -1,6 +1,6 @@
-# disabling running with j9 because of slightly different behavior.
-runwithj9=false
-usedefaults=true
-
-#Exclude for J2ME/Foundation - test requires java.math.BigDecimal
+# disabling running with j9 because of slightly different behavior.
+runwithj9=false
+usedefaults=true
+
+#Exclude for J2ME/Foundation - test requires java.math.BigDecimal
runwithfoundation=false
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/procedure_app.properties
------------------------------------------------------------------------------
svn:eol-style = native
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/stmtCacheAliases.subsql
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/stmtCacheAliases.subsql?rev=329187&r1=329186&r2=329187&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/stmtCacheAliases.subsql (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/stmtCacheAliases.subsql Fri Oct 28 04:51:50 2005
@@ -1,6 +1,6 @@
---
--- this script registers the various consistency checks for
--- statement caching as simple aliases for ease of scripting
---
-
-create view SC_CONTENTS as select CAST (SUBSTR (CAST (SQL_TEXT as char(200)), 1, 30) AS CHAR(30)) AS SQL_TEXT from syscs_diag.STATEMENT_CACHE;
+--
+-- this script registers the various consistency checks for
+-- statement caching as simple aliases for ease of scripting
+--
+
+create view SC_CONTENTS as select CAST (SUBSTR (CAST (SQL_TEXT as char(200)), 1, 30) AS CHAR(30)) AS SQL_TEXT from syscs_diag.STATEMENT_CACHE;
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/stmtCacheAliases.subsql
------------------------------------------------------------------------------
svn:eol-style = native
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/stmtCacheAliasesRemove.subsql
URL: http://svn.apache.org/viewcvs/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/stmtCacheAliasesRemove.subsql?rev=329187&r1=329186&r2=329187&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/stmtCacheAliasesRemove.subsql (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/stmtCacheAliasesRemove.subsql Fri Oct 28 04:51:50 2005
@@ -1,8 +1,8 @@
-
---
--- this script de-registers the various consistency checks for
--- statement caching
---
-
-drop view SC_CONTENTS;
-
+
+--
+-- this script de-registers the various consistency checks for
+-- statement caching
+--
+
+drop view SC_CONTENTS;
+
Propchange: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/stmtCacheAliasesRemove.subsql
------------------------------------------------------------------------------
svn:eol-style = native