Test query2.12.sql (id 0177627dc2e1) (err)
query2.12.stable.out.int128.FILTERED 2019-09-20 22:27:32.355394395 +0200query2.12.test.out.FILTERED 2019-09-20 22:27:32.357394412 +0200
1 Statistics about stdout of test 'query2.12` in directory 'sql/backends/monet5/vaults/bam`: 1 1 Statistics about stdout of test 'query2.12` in directory 'sql/backends/monet5/vaults/bam`: 1
2 9 lines, 200 words, 1610 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 1 lines, 8 words, 80 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 9 lines, 200 words, 1610 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 1 lines, 8 words, 80 chars in lines not matching '^$|^(\| |)#` 3
4 # 67 lines, 523 words, 3817 chars in all lines 4 ! 4 # 29 lines, 142 words, 1288 chars in all lines 4
5 5 5 5
..................
# MonetDB/SQL module loaded
24 24 25 25
+ 26 # 22:26:32 > 26
+ 27 # 22:26:32 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-26757" "--port=35474" 27
+ 28 # 22:26:32 > 28
25 25 29 29
26 # 10:22:44 > 26 ! 30 30
27 # 10:22:44 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16074" "--port=32986" 27 ! 31 # 22:27:32 > 31
28 # 10:22:44 > 28 ! 32 # 22:27:32 > "Done." 32
29 29 ! 33 # 22:27:32 > 33
30 #WITH alig AS ( 30 -
31 # SELECT * 31 -
32 # FROM bam.alignments_1 32 -
33 # WHERE bam.bam_flag(flag, 'firs_segm') <> bam.bam_flag(flag, 'last_segm') 33 -
34 # AND bam.bam_flag(flag, 'seco_alig') = True 34 -
35 # AND rname <> '*' 35 -
36 # AND pos > 0 36 -
37 # AND rnext = '*' 37 -
38 # AND pnext = 0 38 -
39 #) 39 -
40 #SELECT * 40 -
41 #FROM ( 41 -
42 # SELECT l.qname AS qname, l.rname AS rname, l.flag AS l_flag, l.pos AS l_pos, l.mapq AS l_mapq, l.cigar AS l_cigar, 42 -
43 # l.rnext AS l_rnext, l.pnext AS l_pnext, l.tlen AS l_tlen, l.seq AS l_seq, l.qual AS l_qual, 43 -
44 # r.flag AS r_flag, r.pos AS r_pos, r.mapq AS r_mapq, r.cigar AS r_cigar, 44 -
45 % bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined # table_name 45 -
46 % qname, rname, l_flag, l_pos, l_mapq, l_cigar, l_rnext, l_pnext, l_tlen, l_seq, l_qual, r_flag, r_pos, r_mapq, r_cigar, r_rnext, r_pnext, r_tlen, r_seq, r_qual, distance # name 46 -
47 % clob, clob, smallint, int, smallint, clob, clob, int, int, clob, clob, smallint, int, smallint, clob, clob, int, int, clob, clob, hugeint # type 47 -
48 % 0, 0, 1, 1, 1, 0, 0, 1, 1, 0, 0, 1, 1, 1, 0, 0, 1, 1, 0, 0, 1 # length 48 -
49 #WITH alig AS ( 49 -
50 # SELECT * 50 -
51 # FROM bam.unpaired_alignments_3 51 -
52 # WHERE bam.bam_flag(flag, 'firs_segm') <> bam.bam_flag(flag, 'last_segm') 52 -
53 # AND bam.bam_flag(flag, 'seco_alig') = True 53 -
54 # AND rname <> '*' 54 -
55 # AND pos > 0 55 -
56 # AND rnext = '*' 56 -
57 # AND pnext = 0 57 -
58 #) 58 -
59 #SELECT * 59 -
60 #FROM ( 60 -
61 # SELECT l.qname AS qname, l.rname AS rname, l.flag AS l_flag, l.pos AS l_pos, l.mapq AS l_mapq, l.cigar AS l_cigar, 61 -
62 # l.rnext AS l_rnext, l.pnext AS l_pnext, l.tlen AS l_tlen, l.seq AS l_seq, l.qual AS l_qual, 62 -
63 # r.flag AS r_flag, r.pos AS r_pos, r.mapq AS r_mapq, r.cigar AS r_cigar, 63 -
64 % bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined, bam.alig_joined # table_name 64 -
65 % qname, rname, l_flag, l_pos, l_mapq, l_cigar, l_rnext, l_pnext, l_tlen, l_seq, l_qual, r_flag, r_pos, r_mapq, r_cigar, r_rnext, r_pnext, r_tlen, r_seq, r_qual, distance # name 65 -
66 % clob, clob, smallint, int, smallint, clob, clob, int, int, clob, clob, smallint, int, smallint, clob, clob, int, int, clob, clob, hugeint # type 66 -
67 % 0, 0, 1, 1, 1, 0, 0, 1, 1, 0, 0, 1, 1, 1, 0, 0, 1, 1, 0, 0, 1 # length 67 -
68 68 -
69 # 10:22:45 > 69 -
70 # 10:22:45 > "Done." 70 -
71 # 10:22:45 > 71 -
72 72 34 34