Bugs item #2770608, was opened at 2009-04-17 14:02 Message generated for change (Comment added) made by mlkersten 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: Closed >Resolution: Works For Me 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. ---------------------------------------------------------------------- >Comment By: Martin Kersten (mlkersten) Date: 2009-06-07 17:28 Message: this particular example works on the current version. Given the overhaul of Mitosis (et.al.) it is closed until a better example is given. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2770608&group_id=56967 ------------------------------------------------------------------------------ OpenSolaris 2009.06 is a cutting edge operating system for enterprises looking to deploy the next generation of Solaris that includes the latest innovations from Sun and the OpenSource community. Download a copy and enjoy capabilities such as Networking, Storage and Virtualization. Go to: http://p.sf.net/sfu/opensolaris-get _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
