MonetDB: default - make test typecast_error.Bug-3622 work also w...

[Stefan Manegold]

Changeset: 5bb9e125f99c for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5bb9e125f99c
Modified Files:
        sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.sql
        sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.stable.out
Branch: default
Log Message:

make test typecast_error.Bug-3622 work also without SAMTOOLS / BAM support,

i.e., without schema "bam" existing


diffs (74 lines):

diff --git a/sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.sql 
b/sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.sql
--- a/sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.sql
+++ b/sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.sql
@@ -4,7 +4,7 @@ BEGIN
        RETURN 1;
 END;
 
-CREATE TABLE "bam"."alignments_2" (
+CREATE TABLE "alignments_2" (
     "virtual_offset" BIGINT        NOT NULL,
     "qname"          CHARACTER LARGE OBJECT NOT NULL,
     "flag"           SMALLINT      NOT NULL,
@@ -20,14 +20,14 @@ CREATE TABLE "bam"."alignments_2" (
     "qual"           CHARACTER LARGE OBJECT NOT NULL,
     CONSTRAINT "alignments_2_pkey_virtual_offset" PRIMARY KEY 
("virtual_offset")
 );
-ALTER TABLE bam.alignments_2 SET READ ONLY;
+ALTER TABLE alignments_2 SET READ ONLY;
 
 SELECT s.value AS refpos, COUNT(*) AS cnt
 FROM 
     generate_series(128, 18960) AS s
     JOIN (
         SELECT epos, pos, seq, cigar
-        FROM bam.alignments_2
+        FROM alignments_2
         WHERE pos > 0 
     ) AS al
     ON (
@@ -38,6 +38,6 @@ GROUP BY refpos
 ORDER BY cnt DESC
 LIMIT 10;
 
-DROP TABLE bam.alignments_2;
+DROP TABLE alignments_2;
 DROP FUNCTION seq_char;
 
diff --git a/sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.stable.out 
b/sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.stable.out
--- a/sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.stable.out
+++ b/sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.stable.out
@@ -30,7 +30,7 @@ Ready.
 #BEGIN
 #      RETURN 1;
 #END;
-#CREATE TABLE "bam"."alignments_2" (
+#CREATE TABLE "alignments_2" (
 #    "virtual_offset" BIGINT        NOT NULL,
 #    "qname"          CHARACTER LARGE OBJECT NOT NULL,
 #    "flag"           SMALLINT      NOT NULL,
@@ -41,13 +41,13 @@ Ready.
 #    "cigar"          CHARACTER LARGE OBJECT NOT NULL,
 #    "rnext"          CHARACTER LARGE OBJECT NOT NULL,
 #    "pnext"          INTEGER       NOT NULL,
-#ALTER TABLE bam.alignments_2 SET READ ONLY;
+#ALTER TABLE alignments_2 SET READ ONLY;
 #SELECT s.value AS refpos, COUNT(*) AS cnt
 #FROM 
 #    generate_series(128, 18960) AS s
 #    JOIN (
 #        SELECT epos, pos, seq, cigar
-#        FROM bam.alignments_2
+#        FROM alignments_2
 #        WHERE pos > 0 
 #    ) AS al
 #    ON (
@@ -61,7 +61,7 @@ Ready.
 % refpos,      cnt # name
 % smallint,    wrd # type
 % 1,   1 # length
-#DROP TABLE bam.alignments_2;
+#DROP TABLE alignments_2;
 #DROP FUNCTION seq_char;
 
 # 16:59:10 >  
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list