X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F43xml-to-db2.t;h=933ee69b2744da6f9b9a443217e844d240f20bd6;hb=c0ec0e22d3f0e3852c00daac5ef5763010b410c3;hp=b7771b14491f6b5f5606ae0386b69a1edb28787b;hpb=bc2ed06a8bade37c1bfdc8a918c41b6cab49474d;p=dbsrgits%2FSQL-Translator.git

diff --git a/t/43xml-to-db2.t b/t/43xml-to-db2.t
index b7771b1..933ee69 100644
--- a/t/43xml-to-db2.t
+++ b/t/43xml-to-db2.t
@@ -39,20 +39,22 @@ CREATE TABLE Basic (
   id INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL,
   title VARCHAR(100) NOT NULL DEFAULT 'hello',
   description VARCHAR(0) DEFAULT '',
-  email VARCHAR(255),
+  email VARCHAR(500),
   explicitnulldef VARCHAR(0),
   explicitemptystring VARCHAR(0) DEFAULT '',
   emptytagdef VARCHAR(0) DEFAULT '',
   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;
 
 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)
 );
 
@@ -61,7 +63,7 @@ ALTER TABLE Basic ADD FOREIGN KEY (another_id) REFERENCES Another(id);
 CREATE INDEX titleindex ON Basic ( title );
 
 CREATE VIEW email_list AS
-SELECT email FROM Basic WHERE email IS NOT NULL;
+SELECT email FROM Basic WHERE (email IS NOT NULL);
 
 CREATE TRIGGER foo_trigger after insert ON Basic REFERENCING OLD AS oldrow NEW AS newrow FOR EACH ROW MODE DB2SQL update modified=timestamp();