db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From banda...@apache.org
Subject 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/
Date Thu, 02 Jun 2005 23:52:46 GMT
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)



Mime
View raw message