Bugs item #2741829, was opened at 2009-04-07 23:10
Message generated for change (Comment added) made by stmane
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2741829&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 CVS Head
Status: Open
Resolution: Fixed
Priority: 6
Private: No
Submitted By: Stefan de Konink (skinkie)
Assigned to: Niels Nes (nielsnes)
>Summary: SQL: explain alter table add constraint results into badness
Initial Comment:
create table blabla(id integer);
explain alter table blabla add constraint dada unique (id);
explain alter table blabla add constraint dada unique (id);
!CONSTRAINT PRIMARY KEY: key dada already exists
alter table blabla drop constraint dada;
explain alter table blabla add constraint dada unique (id);
[Switching to Thread 0x7fffe1cd8950 (LWP 1752)]
0x00007fffe27ad4e6 in update_check_ukey (sql=0x128f9f8, updates=0x135b5b8,
k=0x132bd98, idx_updates=0x0, updcol=0) at ../../../src/server/rel_bin.mx:2474
2474 sql_kc *c = k->columns->h->data;
Missing separate debuginfos, use: debuginfo-install
bzip2-libs-1.0.5-3.fc10.x86_64 e2fsprogs-libs-1.41.4-4.fc10.x86_64
glibc-2.9-3.x86_64 keyutils-libs-1.2-3.fc9.x86_64
krb5-libs-1.6.3-16.fc10.x86_64 libselinux-2.0.78-1.fc10.x86_64
ncurses-libs-5.6-20.20080927.fc10.x86_64 openssl-0.9.8g-12.fc10.x86_64
pcre-7.8-1.fc10.x86_64 readline-5.2-13.fc9.x86_64 zlib-1.2.3-18.fc9.x86_64
(gdb) bt
#0 0x00007fffe27ad4e6 in update_check_ukey (sql=0x128f9f8, updates=0x135b5b8,
k=0x132bd98, idx_updates=0x0, updcol=0)
at ../../../src/server/rel_bin.mx:2474
#1 0x00007fffe27ae765 in sql_update_check_key (sql=0x128f9f8,
updates=0x135b5b8, k=0x132bd98, idx_updates=0x0, updcol=0, l=0x1315a58,
cascade=0x134f518)
at ../../../src/server/rel_bin.mx:2767
#2 0x00007fffe27af073 in update_idxs_and_check_keys (sql=0x128f9f8,
t=0x12d5a98, updates=0x135b5b8, l=0x1315a58, cascades=0x7fffe1cd7730)
at ../../../src/server/rel_bin.mx:2944
#3 0x00007fffe27af4c6 in sql_update (sql=0x128f9f8, t=0x12d5a98,
updates=0x135b5b8) at ../../../src/server/rel_bin.mx:3034
#4 0x00007fffe27af7e0 in rel2bin_update (sql=0x128f9f8, rel=0x134f388,
refs=0x135b0f8) at ../../../src/server/rel_bin.mx:3096
#5 0x00007fffe27b03eb in subrel_bin (sql=0x128f9f8, rel=0x134f388,
refs=0x135b0f8) at ../../../src/server/rel_bin.mx:3368
#6 0x00007fffe27b0499 in rel_bin (sql=0x128f9f8, rel=0x134f388) at
../../../src/server/rel_bin.mx:3388
#7 0x00007fffe2758de2 in sql_update_add_idx (sql=0x128f9f8, t=0x12d5a98,
idx=0x132bd98) at ../../../src/server/sql_schema.mx:1010
#8 0x00007fffe275a4e7 in table_constraint_type (sql=0x128f9f8, name=0x1291bc8
"dada", s=0x1291c38, ss=0x1263ab8, t=0x12d5a98, alter=1)
at ../../../src/server/sql_schema.mx:1477
#9 0x00007fffe275a645 in table_constraint (sql=0x128f9f8, s=0x1291cd8,
ss=0x1263ab8, t=0x12d5a98, alter=1) at ../../../src/server/sql_schema.mx:1508
#10 0x00007fffe275a89d in table_element (sql=0x128f9f8, s=0x1291cd8,
ss=0x1263ab8, t=0x12d5a98, alter=1) at ../../../src/server/sql_schema.mx:1556
#11 0x00007fffe275bcc5 in alter_table (sql=0x128f9f8, qname=0x1291b78,
te=0x1291cd8) at ../../../src/server/sql_schema.mx:1872
#12 0x00007fffe275c95d in schemas (sql=0x128f9f8, s=0x1291d78) at
../../../src/server/sql_schema.mx:2109
#13 0x00007fffe2762190 in semantic (sql=0x128f9f8, s=0x1291d78) at
../../../src/server/sql_semantic.mx:1032
#14 0x00007fffe27622c5 in output_semantic (sql=0x128f9f8, s=0x1291d78) at
../../../src/server/sql_semantic.mx:1094
#15 0x00007fffe26fe2ce in sql_symbol2stmt (c=0x128f9f8, sym=0x1291d78) at
../../../../src/backends/monet5/sql.mx:1095
#16 0x00007fffe2739ebd in SQLparser (c=0x604a68) at
../../../../src/backends/monet5/sql_scenario.mx:1019
#17 0x00007ffff7d32d79 in runPhase (c=0x604a68, phase=1) at
../../../src/mal/mal_scenario.mx:591
#18 0x00007ffff7d32e76 in runScenarioBody (c=0x604a68) at
../../../src/mal/mal_scenario.mx:627
#19 0x00007ffff7d330a9 in runScenario (c=0x604a68) at
../../../src/mal/mal_scenario.mx:661
#20 0x00007ffff7cef8bd in MSserveClient (dummy=0x604a68) at
../../../src/mal/mal_session.mx:460
#21 0x00007ffff7773e36 in wrapper_routine (data=0x7fffe325dbe0) at
../../../src/gdk/gdk_posix.mx:955
#22 0x0000003c1a4073da in start_thread () from /lib64/libpthread.so.0
#23 0x0000003c19ce62bd in clone () from /lib64/libc.so.6
----------------------------------------------------------------------
>Comment By: Stefan Manegold (stmane)
Date: 2009-08-14 14:03
Message:
tagged subject
----------------------------------------------------------------------
Comment By: Stefan Manegold (stmane)
Date: 2009-08-13 19:35
Message:
re-opened since the test produces different output since checkins on
2009/07/25 and/or 2009/07/26 on the CVS HEAD;
cf.,
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugTracker-2009/explain_gives_crash.SF-2741829.out.00.html
http://monetdb.cwi.nl/testing/projects/monetdb/Stable/sql/.mTests103/GNU.64.64.d.1-Fedora10/src_test_BugTracker-2009/explain_gives_crash.SF-2741829.err.00.html
----------------------------------------------------------------------
Comment By: Niels Nes (nielsnes)
Date: 2009-05-28 22:42
Message:
solved simply by disabling (again) explain and friends in schema statements
(as these are executed directly). test added to
explain_gives_crash.SF-2741829.sql
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2741829&group_id=56967
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
