Changeset: b7681c154e83 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b7681c154e83
Added Files:
sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct.Bug-6411.stable.err
sql/test/BugTracker-2017/Tests/sqlitelogictest-aggregation-distinct.Bug-6411.stable.out
sql/test/bugs/Tests/in.sql
sql/test/bugs/Tests/in.stable.err
sql/test/bugs/Tests/in.stable.out
Modified Files:
monetdb5/optimizer/opt_mergetable.c
sql/backends/monet5/rel_bin.c
sql/backends/monet5/vaults/bam/Tests/query2.1.stable.out
sql/backends/monet5/vaults/bam/Tests/query2.10.stable.out
sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out
sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out.int128
sql/backends/monet5/vaults/bam/Tests/query2.6.sql
sql/backends/monet5/vaults/bam/Tests/query2.6.stable.out
sql/server/rel_dump.c
sql/server/rel_exp.c
sql/server/rel_exp.h
sql/server/rel_optimizer.c
sql/server/rel_rel.c
sql/server/rel_select.c
sql/server/sql_semantic.c
sql/test/BugDay_2005-10-06_2.9.3/Tests/simple_union.SF-1005596.stable.out
sql/test/BugTracker-2012/Tests/null_except_null.Bug-3040.stable.out
sql/test/BugTracker-2015/Tests/and_or_in.Bug-3655.stable.out
sql/test/BugTracker-2016/Tests/memory-consumption-query-PLAN-25joins.Bug-3972.stable.out
sql/test/BugTracker-2017/Tests/caching_stats_bug.6374.stable.out
sql/test/Dependencies/Tests/Dependencies.stable.out
sql/test/Dependencies/Tests/Dependencies.stable.out.int128
sql/test/bugs/Tests/All
sql/test/bugs/Tests/subselect_multiple_unionall_where_1=1-bug-sf-1005596.stable.out
sql/test/bugs/Tests/union_all-bug-sf-941788.stable.out
sql/test/mergetables/Tests/part-elim.stable.out
Branch: Jul2017
Log Message:
reimplemented IN/NOT IN. Fixed bug 6411
diffs (truncated from 2529 to 300 lines):
diff --git a/monetdb5/optimizer/opt_mergetable.c
b/monetdb5/optimizer/opt_mergetable.c
--- a/monetdb5/optimizer/opt_mergetable.c
+++ b/monetdb5/optimizer/opt_mergetable.c
@@ -520,6 +520,14 @@ mat_setop(MalBlkPtr mb, InstrPtr p, matl
s =
pushArgument(mb,s,getArg(mat[n].mi,j));
}
}
+ if (s->retc == 1 && s->argc == 2){ /* only one input,
change into an assignment */
+ getFunctionId(s) = NULL;
+ getModuleId(s) = NULL;
+ s->token = ASSIGNsymbol;
+ s->typechk = TYPE_UNKNOWN;
+ s->fcn = NULL;
+ s->blk = NULL;
+ }
pushInstruction(mb,s);
getArg(q,0) = newTmpVariable(mb, tpe);
diff --git a/sql/backends/monet5/rel_bin.c b/sql/backends/monet5/rel_bin.c
--- a/sql/backends/monet5/rel_bin.c
+++ b/sql/backends/monet5/rel_bin.c
@@ -616,22 +616,28 @@ exp_bin(backend *be, sql_exp *e, stmt *l
if (e->flag == cmp_in || e->flag == cmp_notin) {
return handle_in_exps(be, e->l, e->r, left, right, grp,
ext, cnt, sel, (e->flag == cmp_in), 0);
}
- if (e->flag == cmp_or && (!right || right->nrcols == 1)) {
+ if (get_cmp(e) == cmp_or && (!right || right->nrcols == 1)) {
+ sql_subtype *bt = sql_bind_localtype("bit");
list *l = e->l;
node *n;
stmt *sel1 = NULL, *sel2 = NULL;
+ int anti = is_anti(e);
sel1 = sel;
sel2 = sel;
for( n = l->h; n; n = n->next ) {
+ sql_exp *c = n->data;
stmt *sin = (sel1 && sel1->nrcols)?sel1:NULL;
- s = exp_bin(be, n->data, left, right, grp, ext,
cnt, sin);
+ /* propagate the anti flag */
+ if (anti)
+ set_anti(c);
+ s = exp_bin(be, c, left, right, grp, ext, cnt,
sin);
if (!s)
return s;
+
if (!sin && sel1 && sel1->nrcols == 0 &&
s->nrcols == 0) {
- sql_subtype *bt =
sql_bind_localtype("bit");
- sql_subfunc *f = sql_bind_func(sql->sa,
sql->session->schema, "and", bt, bt, F_FUNC);
+ sql_subfunc *f = sql_bind_func(sql->sa,
sql->session->schema, anti?"or":"and", bt, bt, F_FUNC);
assert(f);
s = stmt_binop(be, sel1, s, f);
} else if (sel1 && (sel1->nrcols == 0 ||
s->nrcols == 0)) {
@@ -639,22 +645,26 @@ exp_bin(backend *be, sql_exp *e, stmt *l
predicate = stmt_const(be, predicate,
stmt_bool(be, 1));
if (s->nrcols == 0)
- s = stmt_uselect(be, predicate,
s, cmp_equal, sel1, 0);
+ s = stmt_uselect(be, predicate,
s, cmp_equal, sel1, anti);
else
- s = stmt_uselect(be, predicate,
sel1, cmp_equal, s, 0);
+ s = stmt_uselect(be, predicate,
sel1, cmp_equal, s, anti);
}
sel1 = s;
}
l = e->r;
for( n = l->h; n; n = n->next ) {
+ sql_exp *c = n->data;
stmt *sin = (sel2 && sel2->nrcols)?sel2:NULL;
- s = exp_bin(be, n->data, left, right, grp, ext,
cnt, sin);
+ /* propagate the anti flag */
+ if (anti)
+ set_anti(c);
+ s = exp_bin(be, c, left, right, grp, ext, cnt,
sin);
if (!s)
return s;
+
if (!sin && sel2 && sel2->nrcols == 0 &&
s->nrcols == 0) {
- sql_subtype *bt =
sql_bind_localtype("bit");
- sql_subfunc *f = sql_bind_func(sql->sa,
sql->session->schema, "and", bt, bt, F_FUNC);
+ sql_subfunc *f = sql_bind_func(sql->sa,
sql->session->schema, anti?"or":"and", bt, bt, F_FUNC);
assert(f);
s = stmt_binop(be, sel2, s, f);
} else if (sel2 && (sel2->nrcols == 0 ||
s->nrcols == 0)) {
@@ -662,15 +672,14 @@ exp_bin(backend *be, sql_exp *e, stmt *l
predicate = stmt_const(be, predicate,
stmt_bool(be, 1));
if (s->nrcols == 0)
- s = stmt_uselect(be, predicate,
s, cmp_equal, sel2, 0);
+ s = stmt_uselect(be, predicate,
s, cmp_equal, sel2, anti);
else
- s = stmt_uselect(be, predicate,
sel2, cmp_equal, s, 0);
+ s = stmt_uselect(be, predicate,
sel2, cmp_equal, s, anti);
}
sel2 = s;
}
if (sel1->nrcols == 0 && sel2->nrcols == 0) {
- sql_subtype *bt = sql_bind_localtype("bit");
- sql_subfunc *f = sql_bind_func(sql->sa,
sql->session->schema, "or", bt, bt, F_FUNC);
+ sql_subfunc *f = sql_bind_func(sql->sa,
sql->session->schema, anti?"and":"or", bt, bt, F_FUNC);
assert(f);
return stmt_binop(be, sel1, sel2, f);
}
@@ -678,17 +687,19 @@ exp_bin(backend *be, sql_exp *e, stmt *l
stmt *predicate = bin_first_column(be, left);
predicate = stmt_const(be, predicate,
stmt_bool(be, 1));
- sel1 = stmt_uselect(be, predicate, sel1,
cmp_equal, NULL, 0);
+ sel1 = stmt_uselect(be, predicate, sel1,
cmp_equal, NULL, anti);
}
if (sel2->nrcols == 0) {
stmt *predicate = bin_first_column(be, left);
predicate = stmt_const(be, predicate,
stmt_bool(be, 1));
- sel2 = stmt_uselect(be, predicate, sel2,
cmp_equal, NULL, 0);
+ sel2 = stmt_uselect(be, predicate, sel2,
cmp_equal, NULL, anti);
}
+ if (anti)
+ return stmt_project(be, stmt_tinter(be, sel1,
sel2), sel1);
return stmt_tunion(be, sel1, sel2);
}
- if (e->flag == cmp_or && right) { /* join */
+ if (get_cmp(e) == cmp_or && right) { /* join */
assert(0);
}
@@ -775,13 +786,13 @@ exp_bin(backend *be, sql_exp *e, stmt *l
/* value compare or select */
if (l->nrcols == 0 && r->nrcols == 0) {
sql_subfunc *f = sql_bind_func(sql->sa,
sql->session->schema,
-
compare_func((comp_type)e->flag, is_anti(e)),
+
compare_func((comp_type)get_cmp(e), is_anti(e)),
tail_type(l),
tail_type(l), F_FUNC);
assert(f);
s = stmt_binop(be, l, r, f);
} else {
/* this can still be a join (as
relational algebra and single value subquery results still means joins */
- s = stmt_uselect(be, l, r,
(comp_type)e->flag, sel, is_anti(e));
+ s = stmt_uselect(be, l, r,
(comp_type)get_cmp(e), sel, is_anti(e));
}
}
}
@@ -1261,7 +1272,7 @@ exp2bin_args(backend *be, sql_exp *e, li
case e_psm:
return args;
case e_cmp:
- if (e->flag == cmp_or || get_cmp(e) == cmp_filter) {
+ if (get_cmp(e) == cmp_or || get_cmp(e) == cmp_filter) {
args = exps2bin_args(be, e->l, args);
args = exps2bin_args(be, e->r, args);
} else if (e->flag == cmp_in || e->flag == cmp_notin) {
@@ -1726,8 +1737,8 @@ rel2bin_join(backend *be, sql_rel *rel,
prop *p;
/* only handle simple joins here */
- if ((exp_has_func(e) && e->flag != cmp_filter) ||
- (e->flag == cmp_or &&
+ if ((exp_has_func(e) && get_cmp(e) != cmp_filter) ||
+ (get_cmp(e) == cmp_or &&
exps_card(e->l) == CARD_MULTI &&
exps_card(e->r) == CARD_MULTI)
) {
@@ -1935,8 +1946,8 @@ rel2bin_semijoin(backend *be, sql_rel *r
/* only handle simple joins here */
if (list_length(lje) && (idx || e->type != e_cmp ||
e->flag != cmp_equal))
break;
- if ((exp_has_func(e) && e->flag != cmp_filter) ||
- (e->flag == cmp_or &&
+ if ((exp_has_func(e) && get_cmp(e) != cmp_filter) ||
+ (get_cmp(e) == cmp_or &&
exps_card(e->l) == CARD_MULTI &&
exps_card(e->r) == CARD_MULTI) ) {
break;
@@ -4965,7 +4976,7 @@ exp_deps(sql_allocator *sa, sql_exp *e,
cond_append(l, &a->aggr->base.id);
} break;
case e_cmp: {
- if (e->flag == cmp_or || get_cmp(e) == cmp_filter) {
+ if (get_cmp(e) == cmp_or || get_cmp(e) == cmp_filter) {
if (get_cmp(e) == cmp_filter) {
sql_subfunc *f = e->f;
cond_append(l, &f->func->base.id);
diff --git a/sql/backends/monet5/vaults/bam/Tests/query2.1.stable.out
b/sql/backends/monet5/vaults/bam/Tests/query2.1.stable.out
--- a/sql/backends/monet5/vaults/bam/Tests/query2.1.stable.out
+++ b/sql/backends/monet5/vaults/bam/Tests/query2.1.stable.out
@@ -36,7 +36,7 @@ Ready.
# FROM alig
# WHERE qname IN (
# SELECT qname
-% bam.L47, bam.L51, bam.L53, bam.L55, bam.L57 #
table_name
+% bam.L46, bam.L50, bam.L52, bam.L54, bam.L56 #
table_name
% qname, l_seq, qual1, r_seq, qual2 # name
% clob, clob, clob, clob, clob # type
% 0, 0, 0, 0, 0 # length
diff --git a/sql/backends/monet5/vaults/bam/Tests/query2.10.stable.out
b/sql/backends/monet5/vaults/bam/Tests/query2.10.stable.out
--- a/sql/backends/monet5/vaults/bam/Tests/query2.10.stable.out
+++ b/sql/backends/monet5/vaults/bam/Tests/query2.10.stable.out
@@ -37,7 +37,7 @@ Ready.
# GROUP BY qname
# HAVING COUNT(*) = 2
# AND SUM(bam.bam_flag(flag, 'firs_segm')) = 1
-% bam.L27, bam.L31, bam.L33, bam.L35, bam.L37,
bam.L41, bam.L43, bam.L45, bam.L47, bam.L51,
bam.L53, bam.L55, bam.L57, bam.L61, bam.L63,
bam.L65, bam.L67, bam.L71, bam.L73, bam.L75,
bam.L77 # table_name
+% bam.L26, bam.L30, bam.L32, bam.L34, bam.L36,
bam.L40, bam.L42, bam.L44, bam.L46, bam.L50,
bam.L52, bam.L54, bam.L56, bam.L60, bam.L62,
bam.L64, bam.L66, bam.L70, bam.L72, bam.L74,
bam.L76 # table_name
% qname, l_flag, l_rname, l_pos, l_mapq, l_cigar,
l_rnext, l_pnext, l_tlen, l_seq, qual1, r_flag, r_rname,
r_pos, r_mapq, r_cigar, r_rnext, r_pnext, r_tlen, r_seq,
qual2 # name
% clob, smallint, clob, int, smallint, clob, clob,
int, int, clob, clob, smallint, clob, int, smallint,
clob, clob, int, int, clob, clob # type
% 0, 1, 0, 1, 1, 0, 0, 1, 1, 0,
0, 1, 0, 1, 1, 0, 0, 1, 1, 0,
0 # length
diff --git a/sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out
b/sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out
--- a/sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out
+++ b/sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out
@@ -36,7 +36,7 @@ Ready.
# GROUP BY qname
# HAVING COUNT(*) = 2
# AND SUM(bam.bam_flag(flag, 'firs_segm')) = 1
-% bam.L36, bam.L41 # table_name
+% bam.L35, bam.L40 # table_name
% distance, nr_alignments # name
% bigint, bigint # type
% 3, 1 # length
diff --git a/sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out.int128
b/sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out.int128
--- a/sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out.int128
+++ b/sql/backends/monet5/vaults/bam/Tests/query2.2.stable.out.int128
@@ -36,7 +36,7 @@ Ready.
# GROUP BY qname
# HAVING COUNT(*) = 2
# AND SUM(bam.bam_flag(flag, 'firs_segm')) = 1
-% bam.L36, bam.L41 # table_name
+% bam.L35, bam.L40 # table_name
% distance, nr_alignments # name
% hugeint, bigint # type
% 3, 1 # length
diff --git a/sql/backends/monet5/vaults/bam/Tests/query2.6.sql
b/sql/backends/monet5/vaults/bam/Tests/query2.6.sql
--- a/sql/backends/monet5/vaults/bam/Tests/query2.6.sql
+++ b/sql/backends/monet5/vaults/bam/Tests/query2.6.sql
@@ -18,7 +18,7 @@ WHERE qname IN (
SELECT *
FROM qnames_insct
)
-ORDER BY qname;
+ORDER BY qname, 1, flag, cigar;
WITH qnames_insct AS (
SELECT distinct qname
@@ -40,4 +40,4 @@ WHERE qname IN (
SELECT *
FROM qnames_insct
)
-ORDER BY qname;
+ORDER BY qname, 1, flag, cigar;
diff --git a/sql/backends/monet5/vaults/bam/Tests/query2.6.stable.out
b/sql/backends/monet5/vaults/bam/Tests/query2.6.stable.out
--- a/sql/backends/monet5/vaults/bam/Tests/query2.6.stable.out
+++ b/sql/backends/monet5/vaults/bam/Tests/query2.6.stable.out
@@ -48,148 +48,148 @@ Ready.
% L22, qname, flag, rname, pos, mapq, cigar, rnext, pnext, tlen,
seq, qual # name
% char, clob, smallint, clob, int, smallint, clob,
clob, int, int, clob, clob # type
% 2, 11, 3, 5, 9, 3, 27, 1, 8, 1,
100, 100 # length
-[ "f1", "sim_22_1_1", 419, "chr22", 39994332, 0,
"5=1X11=1885D83=", "=", 39995061, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
-[ "f2", "sim_22_1_1", 385, "chr22", 39996047, 0,
"3=1I1=1X13=171D81=", "*", 0, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
-[ "f2", "sim_22_1_1", 419, "chr22", 39995910, 0,
"5=1X12=307D82=", "=", 39996123, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
-[ "f2", "sim_22_1_1", 339, "chr22", 39995061, 0,
"11=1368D51=1X37=", "=", 39994332, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
-[ "f2", "sim_22_1_1", 419, "chr22", 39994332, 0,
"5=1X11=1885D83=", "=", 39995061, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
-[ "f2", "sim_22_1_1", 385, "chr22", 39994467, 0,
"3=1I1=1X14=1751D80=", "*", 0, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
[ "f1", "sim_22_1_1", 83, "chr22", 39996429, 255,
"62=1X37=", "=", 39996217, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
-[ "f2", "sim_22_1_1", 339, "chr22", 39996123, 0,
"4=1X1I10=307D46=1X37=", "=", 39995910, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
-[ "f2", "sim_22_1_1", 163, "chr22", 39996217, 255,
"100=", "=", 39996429, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
-[ "f2", "sim_22_1_1", 83, "chr22", 39996429, 255,
"62=1X37=", "=", 39996217, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
[ "f1", "sim_22_1_1", 163, "chr22", 39996217, 255,
"100=", "=", 39996429, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
+[ "f1", "sim_22_1_1", 339, "chr22", 39995061, 0,
"11=1368D51=1X37=", "=", 39994332, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
[ "f1", "sim_22_1_1", 339, "chr22", 39996123, 0,
"4=1X1I10=307D46=1X37=", "=", 39995910, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
[ "f1", "sim_22_1_1", 385, "chr22", 39996047, 0,
"3=1I1=1X13=171D81=", "*", 0, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
+[ "f1", "sim_22_1_1", 385, "chr22", 39994467, 0,
"3=1I1=1X14=1751D80=", "*", 0, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
+[ "f1", "sim_22_1_1", 419, "chr22", 39994332, 0,
"5=1X11=1885D83=", "=", 39995061, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
[ "f1", "sim_22_1_1", 419, "chr22", 39995910, 0,
"5=1X12=307D82=", "=", 39996123, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
-[ "f1", "sim_22_1_1", 339, "chr22", 39995061, 0,
"11=1368D51=1X37=", "=", 39994332, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
-[ "f1", "sim_22_1_1", 385, "chr22", 39994467, 0,
"3=1I1=1X14=1751D80=", "*", 0, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
-[ "f2", "sim_22_1_10", 147, "chr22", 24428413, 255,
"66=1X33=", "=", 24428205, 0,
"ATGCCTTATAAATAAATTTATAAGATGACTACTTTGTAGGCACATCTTGTTATAAGAAAAGTCAATGATATGTGTCCCTTTAATTTTCAAAATGAAAAAT",
"#GD###A#5ED#B5.#BE==5FG#E3-@#AB7CA)@DEFF=FF#@AEFDFD4>DF2CCCGGA:DGB'FFDG9AEF?3;DGAE?CGCFD2GAG?GB@GFGF"
]
-[ "f2", "sim_22_1_10", 99, "chr22", 24428205, 255,
"28=1X54=1X16=", "=", 24428413, 0,
"TAATAATCTCAAAAGATAGTTCAATGTAGAACCTAATTAATTCAGTAGGATGACCAGCTCAGTAGCAGTAAGTAGCAGTGCAATATAAGTGGCATTTTAA",
"EFE:FC@D?5FGGCAEDAFEGG3GEDA5(CFFFEGD#GEFFG?EDCFC?GBAGEFADCFBGCG@FGCF2F0ED>C@E:DAF:A-BF;:/#;#E##A#A?C"
]
+[ "f2", "sim_22_1_1", 83, "chr22", 39996429, 255,
"62=1X37=", "=", 39996217, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
+[ "f2", "sim_22_1_1", 163, "chr22", 39996217, 255,
"100=", "=", 39996429, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
+[ "f2", "sim_22_1_1", 339, "chr22", 39995061, 0,
"11=1368D51=1X37=", "=", 39994332, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
+[ "f2", "sim_22_1_1", 339, "chr22", 39996123, 0,
"4=1X1I10=307D46=1X37=", "=", 39995910, 0,
"ACTCTGTCGCCCAGGCCGGGGCGTAGCCATGCAAACACGGCTCACTGCAGCCTCGACCTCCCCGGCTCAAGCCATCCTCCCACCTCAACCTCCCAAGTAG",
"##?#-@=#?D5?EBC##=2#E6A=E8A:F5+F>=CF8#BDFDF?7B8BAGC2EF?FFFG>EE*F=GDBGDGFEFEFG=FBGFFBFFBGEDCF5EFGGGDG"
]
+[ "f2", "sim_22_1_1", 385, "chr22", 39996047, 0,
"3=1I1=1X13=171D81=", "*", 0, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
+[ "f2", "sim_22_1_1", 385, "chr22", 39994467, 0,
"3=1I1=1X14=1751D80=", "*", 0, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
+[ "f2", "sim_22_1_1", 419, "chr22", 39994332, 0,
"5=1X11=1885D83=", "=", 39995061, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
+[ "f2", "sim_22_1_1", 419, "chr22", 39995910, 0,
"5=1X12=307D82=", "=", 39996123, 0,
"AGTAGATGGGATTACAGGCACCCGCCACCGCGCCCAGCTAATTTTTATATATTTTTTAAGTAGAGATGGGGTTTCACCATGTTGGCCAGGCTGGTCTTGA",
"EEEEEFAG=GCDAGBF8F:EFGGDEGCFFBAAGCE?DD?5?DGF#DC##BD;D=BD@G?A0F9G6AFC?5#CCCAE6AD-F#CA0#.ADCD;#-#6#A##"
]
[ "f1", "sim_22_1_10", 99, "chr22", 24428205, 255,
"28=1X54=1X16=", "=", 24428413, 0,
"TAATAATCTCAAAAGATAGTTCAATGTAGAACCTAATTAATTCAGTAGGATGACCAGCTCAGTAGCAGTAAGTAGCAGTGCAATATAAGTGGCATTTTAA",
"EFE:FC@D?5FGGCAEDAFEGG3GEDA5(CFFFEGD#GEFFG?EDCFC?GBAGEFADCFBGCG@FGCF2F0ED>C@E:DAF:A-BF;:/#;#E##A#A?C"
]
[ "f1", "sim_22_1_10", 147, "chr22", 24428413, 255,
"66=1X33=", "=", 24428205, 0,
"ATGCCTTATAAATAAATTTATAAGATGACTACTTTGTAGGCACATCTTGTTATAAGAAAAGTCAATGATATGTGTCCCTTTAATTTTCAAAATGAAAAAT",
"#GD###A#5ED#B5.#BE==5FG#E3-@#AB7CA)@DEFF=FF#@AEFDFD4>DF2CCCGGA:DGB'FFDG9AEF?3;DGAE?CGCFD2GAG?GB@GFGF"
]
+[ "f2", "sim_22_1_10", 99, "chr22", 24428205, 255,
"28=1X54=1X16=", "=", 24428413, 0,
"TAATAATCTCAAAAGATAGTTCAATGTAGAACCTAATTAATTCAGTAGGATGACCAGCTCAGTAGCAGTAAGTAGCAGTGCAATATAAGTGGCATTTTAA",
"EFE:FC@D?5FGGCAEDAFEGG3GEDA5(CFFFEGD#GEFFG?EDCFC?GBAGEFADCFBGCG@FGCF2F0ED>C@E:DAF:A-BF;:/#;#E##A#A?C"
]
+[ "f2", "sim_22_1_10", 147, "chr22", 24428413, 255,
"66=1X33=", "=", 24428205, 0,
"ATGCCTTATAAATAAATTTATAAGATGACTACTTTGTAGGCACATCTTGTTATAAGAAAAGTCAATGATATGTGTCCCTTTAATTTTCAAAATGAAAAAT",
"#GD###A#5ED#B5.#BE==5FG#E3-@#AB7CA)@DEFF=FF#@AEFDFD4>DF2CCCGGA:DGB'FFDG9AEF?3;DGAE?CGCFD2GAG?GB@GFGF"
]
[ "f1", "sim_22_1_11", 83, "chr22", 41987433, 255,
"19=1X50=1X26=1X2=", "=", 41987203, 0,
"TGACTATTCTAGGAGACCACGAGTTGGGAAAGGTATGGCAAGGCACCCACAGGAGAGCTGATGACAACTGTGAGGATCAGTGACTGTGGATGATGGAACA",
"=?GF3A:EA#GF6#D5=EF##AG>*EE==A#GB=GA.DE'B@AACDECGB3G>DGFDCGFBFE?EFFD;E7GBFGDCAEGBGDAEFB;5GD=GEECF0FE"
]
-[ "f1", "sim_22_1_11", 337, "chr22", 41987433, 0,
"19=1X50=1X26=1I1=1I", "*", 0, 0,
"TGACTATTCTAGGAGACCACGAGTTGGGAAAGGTATGGCAAGGCACCCACAGGAGAGCTGATGACAACTGTGAGGATCAGTGACTGTGGATGATGGAACA",
"=?GF3A:EA#GF6#D5=EF##AG>*EE==A#GB=GA.DE'B@AACDECGB3G>DGFDCGFBFE?EFFD;E7GBFGDCAEGBGDAEFB;5GD=GEECF0FE"
]
[ "f1", "sim_22_1_11", 163, "chr22", 41987203, 255,
"68=1X31=", "=", 41987433, 0,
"GCCTGGATGGAGCCCTGGGGCTGGAGGCTGGCACTTCCAATCGAGACTGCCCGTTTGGTCCTGCCCTGTGTGACAGTATACAGGCTTATCTTGGCCACCC",
"GGGF:GFGG?EGFEG?DAFBEF=FA+>EGG=E:EDBEB7DCCE=DG@?:?CAE4E=DCBGFG@FE8EB>FDAE#CE=ECA@#D-D?:CEA#BD#E#B#EA"
]
-[ "f2", "sim_22_1_11", 337, "chr22", 41987433, 0,
"19=1X50=1X26=1I1=1I", "*", 0, 0,
"TGACTATTCTAGGAGACCACGAGTTGGGAAAGGTATGGCAAGGCACCCACAGGAGAGCTGATGACAACTGTGAGGATCAGTGACTGTGGATGATGGAACA",
"=?GF3A:EA#GF6#D5=EF##AG>*EE==A#GB=GA.DE'B@AACDECGB3G>DGFDCGFBFE?EFFD;E7GBFGDCAEGBGDAEFB;5GD=GEECF0FE"
]
+[ "f1", "sim_22_1_11", 337, "chr22", 41987433, 0,
"19=1X50=1X26=1I1=1I", "*", 0, 0,
"TGACTATTCTAGGAGACCACGAGTTGGGAAAGGTATGGCAAGGCACCCACAGGAGAGCTGATGACAACTGTGAGGATCAGTGACTGTGGATGATGGAACA",
"=?GF3A:EA#GF6#D5=EF##AG>*EE==A#GB=GA.DE'B@AACDECGB3G>DGFDCGFBFE?EFFD;E7GBFGDCAEGBGDAEFB;5GD=GEECF0FE"
]
+[ "f2", "sim_22_1_11", 83, "chr22", 41987433, 255,
"19=1X50=1X26=1X2=", "=", 41987203, 0,
"TGACTATTCTAGGAGACCACGAGTTGGGAAAGGTATGGCAAGGCACCCACAGGAGAGCTGATGACAACTGTGAGGATCAGTGACTGTGGATGATGGAACA",
"=?GF3A:EA#GF6#D5=EF##AG>*EE==A#GB=GA.DE'B@AACDECGB3G>DGFDCGFBFE?EFFD;E7GBFGDCAEGBGDAEFB;5GD=GEECF0FE"
]
[ "f2", "sim_22_1_11", 163, "chr22", 41987203, 255,
"68=1X31=", "=", 41987433, 0,
"GCCTGGATGGAGCCCTGGGGCTGGAGGCTGGCACTTCCAATCGAGACTGCCCGTTTGGTCCTGCCCTGTGTGACAGTATACAGGCTTATCTTGGCCACCC",
"GGGF:GFGG?EGFEG?DAFBEF=FA+>EGG=E:EDBEB7DCCE=DG@?:?CAE4E=DCBGFG@FE8EB>FDAE#CE=ECA@#D-D?:CEA#BD#E#B#EA"
]
-[ "f2", "sim_22_1_11", 83, "chr22", 41987433, 255,
"19=1X50=1X26=1X2=", "=", 41987203, 0,
"TGACTATTCTAGGAGACCACGAGTTGGGAAAGGTATGGCAAGGCACCCACAGGAGAGCTGATGACAACTGTGAGGATCAGTGACTGTGGATGATGGAACA",
"=?GF3A:EA#GF6#D5=EF##AG>*EE==A#GB=GA.DE'B@AACDECGB3G>DGFDCGFBFE?EFFD;E7GBFGDCAEGBGDAEFB;5GD=GEECF0FE"
]
+[ "f2", "sim_22_1_11", 337, "chr22", 41987433, 0,
"19=1X50=1X26=1I1=1I", "*", 0, 0,
"TGACTATTCTAGGAGACCACGAGTTGGGAAAGGTATGGCAAGGCACCCACAGGAGAGCTGATGACAACTGTGAGGATCAGTGACTGTGGATGATGGAACA",
"=?GF3A:EA#GF6#D5=EF##AG>*EE==A#GB=GA.DE'B@AACDECGB3G>DGFDCGFBFE?EFFD;E7GBFGDCAEGBGDAEFB;5GD=GEECF0FE"
]
+[ "f1", "sim_22_1_13", 83, "chr22", 32902057, 255,
"100=", "=", 32901856, 0,
"AGAGCAAAACATTCTGGCAGATGCACAGCAGGTGGTGGGGCAAAAAGGGACCCGGATGGGGATCAAGAGGCTCACAAGATAGTCTCAGCTCTGCCGCTTA",
";5#GFC#@@#AE@FE@E@4B=BE:6;ADA>E#:GF=?#=:?/EA?G>GF3CFCDEB:EFGDG?G@GGFEG=F5FDGE?#GDFGGFEE@AGADGFGEDEEG"
]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
