Changeset: 615ce04ed0c6 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=615ce04ed0c6 Modified Files: sql/backends/monet5/bam/Tests/bam_lib.stable.out sql/backends/monet5/bam/Tests/sql/bam_lib.sql Branch: bamloader Log Message:
Included bulk version of seq_char in tests diffs (74 lines): diff --git a/sql/backends/monet5/bam/Tests/bam_lib.stable.out b/sql/backends/monet5/bam/Tests/bam_lib.stable.out --- a/sql/backends/monet5/bam/Tests/bam_lib.stable.out +++ b/sql/backends/monet5/bam/Tests/bam_lib.stable.out @@ -1,9 +1,9 @@ stdout of test 'bam_lib` in directory 'sql/backends/monet5/bam` itself: -# 10:07:17 > -# 10:07:17 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35421" "--set" "mapi_usock=/var/tmp/mtest-25140/.s.monetdb.35421" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/home/robin/MonetDB/PREFIX/var/MonetDB/mTests_sql_backends_monet5_bam" "--set" "mal_listing=0" "--set" "embedded_r=yes" -# 10:07:17 > +# 08:43:53 > +# 08:43:53 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35352" "--set" "mapi_usock=/var/tmp/mtest-9342/.s.monetdb.35352" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/home/robin/MonetDB/PREFIX/var/MonetDB/mTests_sql_backends_monet5_bam" "--set" "mal_listing=0" "--set" "embedded_r=yes" +# 08:43:53 > # MonetDB 5 server v11.20.0 # This is an unreleased version @@ -13,8 +13,8 @@ stdout of test 'bam_lib` in directory 's # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved # Visit http://www.monetdb.org/ for further information -# Listening for connection requests on mapi:monetdb://robin-xps13:35421/ -# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-25140/.s.monetdb.35421 +# Listening for connection requests on mapi:monetdb://robin-xps13:35352/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-9342/.s.monetdb.35352 # MonetDB/SQL module loaded # MonetDB/R module loaded @@ -51,9 +51,9 @@ Ready. # loading sql script: 90_generator.sql # loading sql script: 99_system.sql -# 10:07:18 > -# 10:07:18 > "/usr/bin/python2" "bam_lib.SQL.py" "bam_lib" -# 10:07:18 > +# 08:43:54 > +# 08:43:54 > "/usr/bin/python2" "bam_lib.SQL.py" "bam_lib" +# 08:43:54 > #SET SCHEMA bam; #SELECT bam_flag(1, 'mult_segm'); @@ -771,7 +771,15 @@ Ready. % char # type % 1 # length [ NULL ] +#SELECT 17922987 AS ref_pos, seq, pos, cigar, seq_char(17922987, seq, pos, cigar) AS seq_char +#FROM bam.alignments_1 +#WHERE seq_char(17922987, seq, pos, cigar) IS NOT NULL; +% .L, bam.alignments_1, bam.alignments_1, bam.alignments_1, .L # table_name +% ref_pos, seq, pos, cigar, seq_char # name +% int, clob, int, clob, char # type +% 8, 100, 8, 21, 1 # length +[ 17922987, "TATACTTATAGAACAAATGAACCCAAAACCACATAAGGTAAACAACAAAGCTACTGGTTCAAAATTAAGCCTAACTTCAACAGTACCAGGCAAAAACCAT", 17922987, "3=1X1=1X43=1X16=1X33=", "T" ] -# 10:07:18 > -# 10:07:18 > "Done." -# 10:07:18 > +# 08:43:54 > +# 08:43:54 > "Done." +# 08:43:54 > diff --git a/sql/backends/monet5/bam/Tests/sql/bam_lib.sql b/sql/backends/monet5/bam/Tests/sql/bam_lib.sql --- a/sql/backends/monet5/bam/Tests/sql/bam_lib.sql +++ b/sql/backends/monet5/bam/Tests/sql/bam_lib.sql @@ -131,7 +131,7 @@ SELECT seq_char(11, 'ACTAGAATGGCT', 5, ' SELECT seq_char(16, 'ACTAGAATGGCT', 5, '3M1I3M1D5M'); SELECT seq_char(17, 'ACTAGAATGGCT', 5, '3M1I3M1D5M'); -# Bulk, does not work properly yet... -# SELECT 17922987 AS ref_pos, seq, pos, cigar, seq_char(17922987, seq, pos, cigar) AS seq_char -# FROM bam.alignments_1 -# WHERE seq_char(17922987, seq, pos, cigar) IS NOT NULL; +# Bulk +SELECT 17922987 AS ref_pos, seq, pos, cigar, seq_char(17922987, seq, pos, cigar) AS seq_char +FROM bam.alignments_1 +WHERE seq_char(17922987, seq, pos, cigar) IS NOT NULL; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
