Bugs item #2947841, was opened at 2010-02-08 14:54
Message generated for change (Tracker Item Submitted) made by vzzzbx
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2947841&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL "candidate"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Wouter Alink (vzzzbx)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: got assertion for type-mismatch
Initial Comment:
Feb2010
given a table 'x' with tuples (id1 varchar(1000), id2 int)
and a table dict with tuples (id int, x varchar)
The following raises an assertion (i guess it should have been a SQL error that
the types do not match):
UPDATE dict SET id = (SELECT id2 FROM "x" WHERE id1=dict.id);
gdb says:
Program received signal SIGABRT, Aborted.
[Switching to Thread 0x7f16b1caf710 (LWP 14596)]
0x00000039f62326c5 in raise () from /lib64/libc.so.6
(gdb) bt
#0 0x00000039f62326c5 in raise () from /lib64/libc.so.6
#1 0x00000039f6233ea5 in abort () from /lib64/libc.so.6
#2 0x00000039f622b7b5 in __assert_fail () from /lib64/libc.so.6
#3 0x00007f16b30fb867 in rel_select_exp (sql=0x7f16a4005518,
rel=0x7f16a4dbb748, outer=0x7f16a4e41c78, sn=0x7f16a4125158, ek=...)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/server/rel_select.mx:4372
#4 0x00007f16b30fc6c8 in rel_query (sql=0x7f16a4005518, rel=0x7f16a4e67248,
sq=0x7f16a4125158, toplevel=0, ek=...)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/server/rel_select.mx:4607
#5 0x00007f16b30fdb47 in rel_subquery (sql=0x7f16a4005518, rel=0x7f16a4e67248,
sq=0x7f16a4125158, ek=...)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/server/rel_select.mx:4950
#6 0x00007f16b30fa428 in rel_value_exp2 (sql=0x7f16a4005518,
rel=0x7f16b1caea18, se=0x7f16a4125158, f=3, ek=..., is_last=0x7f16b1cae9b4)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/server/rel_select.mx:4007
#7 0x00007f16b30fa6c3 in rel_value_exp (sql=0x7f16a4005518,
rel=0x7f16b1caea18, se=0x7f16a4125158, f=3, ek=...)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/server/rel_select.mx:4071
#8 0x00007f16b30ff34c in update_table (sql=0x7f16a4005518,
qname=0x7f16a4124b08, assignmentlist=0x7f16a4125268, opt_where=0x0)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/server/rel_updates.mx:398
#9 0x00007f16b3100991 in rel_updates (sql=0x7f16a4005518, s=0x7f16a4125368)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/server/rel_updates.mx:744
#10 0x00007f16b30ec44e in rel_semantic (sql=0x7f16a4005518, s=0x7f16a4125368)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/server/rel_semantic.mx:242
#11 0x00007f16b3054cdf in sql_symbol2stmt (c=0x7f16a4005518, sym=0x7f16a4125368)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/backends/monet5/sql.mx:1277
#12 0x00007f16b309f1ab in SQLparser (c=0x604e70)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/backends/monet5/sql_scenario.mx:1153
#13 0x00007f16c9fd690b in runPhase (c=0x604e70, phase=1)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/MonetDB5/src/mal/mal_scenario.mx:602
#14 0x00007f16c9fd6a62 in runScenarioBody (c=0x604e70) at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/MonetDB5/src/mal/mal_scenario.mx:645
#15 0x00007f16c9fd6cbe in runScenario (c=0x604e70) at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/MonetDB5/src/mal/mal_scenario.mx:679
#16 0x00007f16c9f8b334 in MSserveClient (dummy=0x604e70)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/MonetDB5/src/mal/mal_session.mx:474
#17 0x00000039f6e06a3a in start_thread () from /lib64/libpthread.so.0
#18 0x00000039f62de67d in clone () from /lib64/libc.so.6
#19 0x0000000000000000 in ?? ()
(gdb) frame 3
#3 0x00007f16b30fb867 in rel_select_exp (sql=0x7f16a4005518,
rel=0x7f16a4dbb748, outer=0x7f16a4e41c78, sn=0x7f16a4125158, ek=...)
at
/export/scratch0/alink/workspace/MonetDB-installer/MonetDB-Feb2010/sql/src/server/rel_select.mx:4372
4372 assert(re->type == e_column);
(gdb) l
4367 for (n = ce->h; n; n = n->next) {
4368 sql_exp *e = n->data;
4369 sql_exp *re = e->r;
4370
4371 assert(e->type == e_cmp);
4372 assert(re->type == e_column);
4373 re =
exp_column(rel_name(inner), re->r, exp_subtype(re), inner->card, has_nil(re),
is_intern(re));
4374 e = exp_compare( exp_dup(e->l),
re, e->flag);
4375 append(jexps, e);
4376 }
(gdb)
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2947841&group_id=56967
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
