You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by to...@apache.org on 2006/03/01 00:19:39 UTC
svn commit: r381819 -
/db/ddlutils/trunk/src/test/org/apache/ddlutils/io/TestConstraints.java
Author: tomdz
Date: Tue Feb 28 15:19:36 2006
New Revision: 381819
URL: http://svn.apache.org/viewcvs?rev=381819&view=rev
Log:
Added sizes to the VARCHAR columns in the tests to avoid hitting limits in Firebird
Modified:
db/ddlutils/trunk/src/test/org/apache/ddlutils/io/TestConstraints.java
Modified: db/ddlutils/trunk/src/test/org/apache/ddlutils/io/TestConstraints.java
URL: http://svn.apache.org/viewcvs/db/ddlutils/trunk/src/test/org/apache/ddlutils/io/TestConstraints.java?rev=381819&r1=381818&r2=381819&view=diff
==============================================================================
--- db/ddlutils/trunk/src/test/org/apache/ddlutils/io/TestConstraints.java (original)
+++ db/ddlutils/trunk/src/test/org/apache/ddlutils/io/TestConstraints.java Tue Feb 28 15:19:36 2006
@@ -91,7 +91,7 @@
" <table name='roundtrip'>\n"+
" <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+
" <column name='value_1' type='DOUBLE'/>\n"+
- " <column name='value_2' type='VARCHAR'/>\n"+
+ " <column name='value_2' type='VARCHAR' size='32'/>\n"+
" <unique name='test_index'>\n"+
" <unique-column name='value_2'/>\n"+
" <unique-column name='value_1'/>\n"+
@@ -104,7 +104,7 @@
"<database name='roundtriptest'>\n"+
" <table name='roundtrip'>\n"+
" <column name='pk_1' type='INTEGER' primaryKey='true' required='true'/>\n"+
- " <column name='pk_2' type='VARCHAR' primaryKey='true' required='true'/>\n"+
+ " <column name='pk_2' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+
" <column name='avalue' type='DOUBLE'/>\n"+
" <index name='test_index'>\n"+
" <index-column name='avalue'/>\n"+
@@ -120,7 +120,7 @@
" <column name='pk' type='INTEGER' primaryKey='true' required='true'/>\n"+
" </table>\n"+
" <table name='roundtrip_2'>\n"+
- " <column name='pk' type='VARCHAR' primaryKey='true' required='true'/>\n"+
+ " <column name='pk' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+
" <column name='avalue' type='INTEGER' required='true'/>\n"+
" <foreign-key foreignTable='roundtrip_1'>\n"+
" <reference local='avalue' foreign='pk'/>\n"+
@@ -133,13 +133,13 @@
"<database name='roundtriptest'>\n"+
" <table name='roundtrip_1'>\n"+
" <column name='pk_1' type='INTEGER' primaryKey='true' required='true'/>\n"+
- " <column name='pk_2' type='VARCHAR' primaryKey='true' required='true'/>\n"+
+ " <column name='pk_2' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+
" </table>\n"+
" <table name='roundtrip_2'>\n"+
- " <column name='pk' type='VARCHAR' primaryKey='true' required='true'/>\n"+
+ " <column name='pk' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+
" <column name='value_1' type='INTEGER' required='true'/>\n"+
" <column name='value_2' type='INTEGER'/>\n"+
- " <column name='value_3' type='VARCHAR'/>\n"+
+ " <column name='value_3' type='VARCHAR' size='32'/>\n"+
" <foreign-key name='fk_1' foreignTable='roundtrip_1'>\n"+
" <reference local='value_1' foreign='pk_1'/>\n"+
" <reference local='value_3' foreign='pk_2'/>\n"+
@@ -156,9 +156,9 @@
"<database name='roundtriptest'>\n"+
" <table name='roundtrip_1'>\n"+
" <column name='pk_1' type='INTEGER' primaryKey='true' required='true'/>\n"+
- " <column name='pk_2' type='VARCHAR' primaryKey='true' required='true'/>\n"+
+ " <column name='pk_2' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+
" <column name='value_1' type='INTEGER'/>\n"+
- " <column name='value_2' type='VARCHAR'/>\n"+
+ " <column name='value_2' type='VARCHAR' size='32'/>\n"+
" <foreign-key foreignTable='roundtrip_2'>\n"+
" <reference local='value_1' foreign='pk_1'/>\n"+
" <reference local='value_2' foreign='pk_2'/>\n"+
@@ -166,8 +166,8 @@
" </table>\n"+
" <table name='roundtrip_2'>\n"+
" <column name='pk_1' type='INTEGER' primaryKey='true' required='true'/>\n"+
- " <column name='pk_2' type='VARCHAR' primaryKey='true' required='true'/>\n"+
- " <column name='value_1' type='VARCHAR' required='true'/>\n"+
+ " <column name='pk_2' type='VARCHAR' size='32' primaryKey='true' required='true'/>\n"+
+ " <column name='value_1' type='VARCHAR' size='32' required='true'/>\n"+
" <column name='value_2' type='INTEGER' required='true'/>\n"+
" <foreign-key foreignTable='roundtrip_1'>\n"+
" <reference local='value_2' foreign='pk_1'/>\n"+