sybase test that doesn't fail
Rafael Kitover [Mon, 17 Jan 2011 05:32:28 +0000 (00:32 -0500)]
t/15sybase_common.t

index cf5d124..91f3953 100644 (file)
@@ -76,6 +76,24 @@ my $tester = dbixcsl_common_tests->new(
         'binary(2)'    => { data_type => 'binary', size => 2 },
         'varbinary(2)' => { data_type => 'varbinary', size => 2 },
     },
+    # test that named constraints aren't picked up as tables
+    extra => {
+        create => [
+            q{
+                CREATE TABLE sybase_loader_test1 (
+                    id int identity primary key
+                )
+            },
+            q{
+                CREATE TABLE sybase_loader_test2 (
+                    id int identity primary key,
+                    sybase_loader_test1_id int,
+                    CONSTRAINT sybase_loader_test2_ref_slt1 FOREIGN KEY (sybase_loader_test1_id) REFERENCES sybase_loader_test1 (id)
+                )
+            },
+        ],
+        drop => [ qw/sybase_loader_test1 sybase_loader_test2/ ],
+    },
 );
 
 if( !$dsn || !$user ) {
@@ -84,3 +102,5 @@ if( !$dsn || !$user ) {
 else {
     $tester->run_tests();
 }
+
+# vim:et sts=4 sw=4 tw=0: