Changeset: f80d7e960167 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f80d7e960167
Added Files:
sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.sql
Modified Files:
sql/test/BugTracker-2014/Tests/All
Branch: default
Log Message:
Added a type-cast error bug 3622
diffs (56 lines):
diff --git a/sql/test/BugTracker-2014/Tests/All
b/sql/test/BugTracker-2014/Tests/All
--- a/sql/test/BugTracker-2014/Tests/All
+++ b/sql/test/BugTracker-2014/Tests/All
@@ -53,3 +53,4 @@ fk-property-assert.Bug-3612
coalesce.Bug-3616
hexadecimal_literals.Bug-3621
orderby_column_exp.Bug-3620
+typecast_error.Bug-3622
diff --git a/sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.sql
b/sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2014/Tests/typecast_error.Bug-3622.sql
@@ -0,0 +1,43 @@
+CREATE FUNCTION seq_char(val integer, seq string, pos integer, cigar string)
+RETURNS INTEGER
+BEGIN
+ RETURN 1;
+END;
+
+CREATE TABLE "bam"."alignments_2" (
+ "virtual_offset" BIGINT NOT NULL,
+ "qname" CHARACTER LARGE OBJECT NOT NULL,
+ "flag" SMALLINT NOT NULL,
+ "rname" CHARACTER LARGE OBJECT NOT NULL,
+ "pos" INTEGER NOT NULL,
+ "epos" INTEGER NOT NULL,
+ "mapq" SMALLINT NOT NULL,
+ "cigar" CHARACTER LARGE OBJECT NOT NULL,
+ "rnext" CHARACTER LARGE OBJECT NOT NULL,
+ "pnext" INTEGER NOT NULL,
+ "tlen" INTEGER NOT NULL,
+ "seq" CHARACTER LARGE OBJECT NOT NULL,
+ "qual" CHARACTER LARGE OBJECT NOT NULL,
+ CONSTRAINT "alignments_2_pkey_virtual_offset" PRIMARY KEY
("virtual_offset")
+);
+ALTER TABLE bam.alignments_2 SET READ ONLY;
+
+EXPLAIN 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
+ WHERE pos > 0
+ ) AS al
+ ON (
+ s.value >= al.pos AND s.value <= al."epos"
+ AND seq_char(s.value, al.seq, al.pos, al.cigar) IS NOT NULL
+ )
+GROUP BY refpos
+ORDER BY cnt DESC
+LIMIT 10;
+
+DROP TABLE bam.alignments_2;
+DROP FUNCTION seq_char;
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
