Bugs item #2770608, was opened at 2009-04-17 14:02 Message generated for change (Tracker Item Submitted) made by cornuz You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2770608&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: Roberto Cornacchia (cornuz) Assigned to: Niels Nes (nielsnes) Summary: SQL: mitosis goes wild Initial Comment: Many of my recent experiments showed wrong/unexpected behaviours when executed with the mitosis optimizer on (default in development). However, it was always difficult to come up with a reproducible bug. This one is very easy to reproduce. It executes a primary key self-join on the system-table 'types'. The expected result is the relation itself. sql>select * from types t1, types t2 where t1.id = t2.id; 26 tuples The count is indeed correct, but there is no output. The EXPLAIN of this query is something fun to see, I won't paste it here as it is very long. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2770608&group_id=56967 ------------------------------------------------------------------------------ Stay on top of everything new and different, both inside and around Java (TM) technology - register by April 22, and save $200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco. 300 plus technical and hands-on sessions. Register today. Use priority code J9JMT32. http://p.sf.net/sfu/p _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
