Changeset: 6cb7f375f65d for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6cb7f375f65d
Added Files:
sql/backends/monet5/bam/Tests/mergetable.SQL.py
sql/backends/monet5/bam/Tests/sql/mergetable.sql
Modified Files:
sql/backends/monet5/bam/Tests/All
Branch: default
Log Message:
Add test case for creating a merge table over two BAM files, which causes a
server crash
diffs (53 lines):
diff --git a/sql/backends/monet5/bam/Tests/All
b/sql/backends/monet5/bam/Tests/All
--- a/sql/backends/monet5/bam/Tests/All
+++ b/sql/backends/monet5/bam/Tests/All
@@ -24,3 +24,4 @@ HAVE_SAMTOOLS?query2.9
HAVE_SAMTOOLS?query2.10
HAVE_SAMTOOLS?query2.11
HAVE_SAMTOOLS?query2.12
+HAVE_SAMTOOLS?mergetable
\ No newline at end of file
diff --git a/sql/backends/monet5/bam/Tests/mergetable.SQL.py
b/sql/backends/monet5/bam/Tests/mergetable.SQL.py
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/bam/Tests/mergetable.SQL.py
@@ -0,0 +1,3 @@
+import bam
+
+bam.exec_sql_file("mergetable.sql", {'PWD': bam.SRCDIR})
\ No newline at end of file
diff --git a/sql/backends/monet5/bam/Tests/sql/mergetable.sql
b/sql/backends/monet5/bam/Tests/sql/mergetable.sql
new file mode 100644
--- /dev/null
+++ b/sql/backends/monet5/bam/Tests/sql/mergetable.sql
@@ -0,0 +1,30 @@
+SET SCHEMA bam;
+
+# Load files
+CALL bam_loader_repos('PWD/files', 0, 4);
+
+# Add a merge table over these files
+CREATE MERGE TABLE alignments (
+ "virtual_offset" BIGINT NOT NULL,
+ "qname" STRING NOT NULL,
+ "flag" SMALLINT NOT NULL,
+ "rname" STRING NOT NULL,
+ "pos" INT NOT NULL,
+ "mapq" SMALLINT NOT NULL,
+ "cigar" STRING NOT NULL,
+ "rnext" STRING NOT NULL,
+ "pnext" INT NOT NULL,
+ "tlen" INT NOT NULL,
+ "seq" STRING NOT NULL,
+ "qual" STRING NOT NULL
+);
+
+SELECT COUNT(*) FROM alignments;
+
+ALTER TABLE alignments ADD TABLE alignments_1;
+
+SELECT COUNT(*) FROM alignments;
+
+ALTER TABLE alignments ADD TABLE alignments_2;
+
+SELECT COUNT(*) FROM alignments;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
