Add timestamp tests, make postgres produce timestamp(0) if asked

[dbsrgits/SQL-Translator.git] / t / 16xml-parser.t

diff --git a/t/16xml-parser.t b/t/16xml-parser.t
index 49c0a26..433ec08 100644 (file)
--- a/t/16xml-parser.t
+++ b/t/16xml-parser.t
@@ -27,7 +27,7 @@ use constant DEBUG => (exists $opt{d} ? 1 : 0);
 #=============================================================================
 
 BEGIN {
-    maybe_plan(150, 'SQL::Translator::Parser::XML::SQLFairy');
+    maybe_plan(162, 'SQL::Translator::Parser::XML::SQLFairy');
 }
 
 my $testschema = "$Bin/data/xml/schema.xml";
@@ -119,6 +119,12 @@ schema_ok( $scma, {
                     is_nullable => 1,
                     comments => "Hello emptytagdef",
                 },
+                {
+                    name => "timest",
+                    data_type => "timestamp",
+                    size => "0",
+                    is_nullable => 1,
+                },
             ],
             constraints => [
                 {
@@ -168,7 +174,7 @@ schema_ok( $scma, {
             name                => 'foo_trigger',
             perform_action_when => 'after',
             database_event      => 'insert',
-            on_table            => 'foo',
+            on_table            => 'Basic',
             action              => 'update modified=timestamp();',
             extra => {
                 foo => "bar",