X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F44-xml-to-db2-array.t;h=6a872ca12f283bce448be6b55a6506c8c2478b6f;hb=HEAD;hp=c09d85066c596c23f2e5cb394d1484591c867c09;hpb=3910f24828cc4aade90168adc7a99b284211b0aa;p=dbsrgits%2FSQL-Translator.git diff --git a/t/44-xml-to-db2-array.t b/t/44-xml-to-db2-array.t index c09d850..6a872ca 100644 --- a/t/44-xml-to-db2-array.t +++ b/t/44-xml-to-db2-array.t @@ -44,13 +44,15 @@ q|CREATE TABLE Basic ( another_id INTEGER DEFAULT 2, timest TIMESTAMP, PRIMARY KEY (id), - CONSTRAINT emailuniqueindex UNIQUE (email) + CONSTRAINT emailuniqueindex UNIQUE (email), + CONSTRAINT very_long_index_name_on_title_field_which_should_be_truncated_for_various_rdbms UNIQUE (title) );|, 'DROP TABLE Another;', q|CREATE TABLE Another ( id INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL, + num NUMERIC(10,2), PRIMARY KEY (id) );|,