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/06/03 01:52:46 UTC
svn commit: r179674 [5/5] - in /incubator/derby/code/trunk/java:
engine/org/apache/derby/catalog/types/
testing/org/apache/derbyTesting/functionTests/master/
testing/org/apache/derbyTesting/functionTests/master/DerbyNet/
testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/
testing/org/apache/derbyTesting/functionTests/suites/
testing/org/apache/derbyTesting/functionTests/tests/lang/
Propchange: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/syscat.out
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/syscat.out
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/syscat.out?rev=179674&r1=179673&r2=179674&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/syscat.out (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/syscat.out Thu Jun 2 16:52:45 2005
@@ -586,6 +586,13 @@
TRIGGERNAME |REFERENCEDCOLU&
------------------------------------------------------------------------------------------------------------------------------------------------
T1 |NULL
+ij> --confirm for DERBY-318
+create table defaultAutoinc(autoinccol int generated by default as identity);
+0 rows inserted/updated/deleted
+ij> select * from SYS.SYSCOLUMNS where COLUMNNAME = 'AUTOINCCOL';
+REFERENCEID |COLUMNNAME |COLUMNNUMB&|COLUMNDATATYPE |COLUMNDEFAULT |COLUMNDEFAULTID |AUTOINCREMENTVALUE |AUTOINCREMENTSTART |AUTOINCREMENTINC
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
+xxxxFILTERED-UUIDxxxx|AUTOINCCOL |1 |INTEGER NOT NU&|GENERATED_BY_D&|xxxxFILTERED-UUIDxxxx|1 |1 |1
ij> -- drop tables
drop table t;
0 rows inserted/updated/deleted
@@ -602,6 +609,8 @@
ij> drop table unnamed_uniquekey2;
0 rows inserted/updated/deleted
ij> drop table uniquekey3;
+0 rows inserted/updated/deleted
+ij> drop table defaultAutoinc;
0 rows inserted/updated/deleted
ij> -- verify the consistency of the indexes on the system catalogs
select tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE('SYS', tablename)
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall?rev=179674&r1=179673&r2=179674&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/suites/derbynetmats.runall Thu Jun 2 16:52:45 2005
@@ -36,6 +36,7 @@
lang/supersimple.sql
lang/updatableResultSet.java
lang/wisconsin.sql
+lang/syscat.sql
store/holdCursorExternalSortJDBC30.sql
store/holdCursorJDBC30.sql
tools/importExport.java
Modified: incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/syscat.sql
URL: http://svn.apache.org/viewcvs/incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/syscat.sql?rev=179674&r1=179673&r2=179674&view=diff
==============================================================================
--- incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/syscat.sql (original)
+++ incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/syscat.sql Thu Jun 2 16:52:45 2005
@@ -155,6 +155,9 @@
select triggername, referencedcolumns
from sys.systriggers;
+--confirm for DERBY-318
+create table defaultAutoinc(autoinccol int generated by default as identity);
+select * from SYS.SYSCOLUMNS where COLUMNNAME = 'AUTOINCCOL';
-- drop tables
drop table t;
@@ -165,6 +168,7 @@
drop table uniquekey1;
drop table unnamed_uniquekey2;
drop table uniquekey3;
+drop table defaultAutoinc;
-- verify the consistency of the indexes on the system catalogs
select tablename, SYSCS_UTIL.SYSCS_CHECK_TABLE('SYS', tablename)