Bugs item #1841727, was opened at 2007-11-30 14:14 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1841727&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: None Priority: 5 Private: No Submitted By: Romulo Goncalves (romulog) Assigned to: Niels Nes (nielsnes) Summary: pkey in temp table Initial Comment: Dear developers if I run the following query against M5-SQL server: >CREATE TEMP TABLE PKTABLE (ptest1 int PRIMARY KEY); Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 46912517404944 (LWP 10828)] 0x00002aaabc428bbf in sql_trans_create_kc (tr=0xb5c638, k=0x0, c=0x13edde8) at /ufs/goncalve/MonetDB/sql/src/storage/store.mx:3580 3580 int nr = list_length(k->columns); (gdb) Regards, Romulo ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2007-11-30 21:16 Message: Logged In: YES user_id=43556 Originator: NO temp tables can do without key checking.. So make a nice warning. ---------------------------------------------------------------------- Comment By: Romulo Goncalves (romulog) Date: 2007-11-30 15:13 Message: Logged In: YES user_id=1498628 Originator: YES After some debug I found out that in MonetDB we do not allow temp tables with primary key. This line of code is in the SQL code: sql_trans_create_ukey (tr=0xf534b8, t=0x1152a98, name=0x2aaabc674020 "pktable_ptest1_pkey", kt=pkey) at /ufs/goncalve/MonetDB/sql/src/storage/store.mx:3487 if (isTempTable(t)) 3495 return NULL; Why? I would like to know if we want to continue like this (so I need to create warning message to avoid the segmentation fault) or I should I change it? I take the second option. Regards, Romulo ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1841727&group_id=56967 ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
