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"+
