Bugs item #2787821, was opened at 2009-05-06 12:11 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2787821&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: Wont Fix Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: Removing all optimizers; 'remap: no implementation present' Initial Comment: sql>CREATE TABLE "sys"."way_nds_9" ( "way" int, "idx" int, "to_node" int); 0 tuples sql>insert into way_nds_9 select * from way_nds limit 9; Rows affected 9 sql>set optimizer=''; 0 tuples sql>select * from way_nds_9 as t1, way_nds_9 as t2 where t1.way = t2.way and t1.idx = t2.idx-1; !MALException:opt.remap:no implementation present 0 tuples Using optimizer='off' output is generated, and the message is gone. ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2009-05-13 14:25 Message: indeed set optimizer='' empty or any optimizer sequence where the defaults miss (multiplex and history) will lead to problems. Sinds we plan to replace the way we enable/disable optimizers (using boolean switches) we will not fix this problem. ---------------------------------------------------------------------- Comment By: Stefan Manegold (stmane) Date: 2009-05-06 12:53 Message: optimizer "multiplex" appears to be mandatory: (with Feb2009-SP2 release:) $ ( sleep 9 ; ( echo "select optimizer;" ; echo "select * from way_nds_9 as t1, way_nds_9 as t2 where t1.way = t2.way and t1.idx = t2.idx-1;" ) | mclient -lsql >&2 ) | mserver5 --dbinit='include sql;' --set monet_welcome=no ; for i in '' off history multiplex ; do echo $i ; ( sleep 9 ; ( echo "set optimizer='$i';" ; echo "select optimizer;" ; echo "select * from way_nds_9 as t1, way_nds_9 as t2 where t1.way = t2.way and t1.idx = t2.idx-1;" ) | mclient -lsql >&2 ) | mserver5 --dbinit='include sql;' --set monet_welcome=no ; done #warning: please don't forget to set your vault key! #(see /ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ >% . # table_name % single_value # name % varchar # type % 173 # length [ "inline,remap,evaluate,costModel,coercions,emptySet,aliases,mergetable,constants,commonTerms,joinPath,accumulators,deadcode,reduce,garbageCollector,dataflow,history,multiplex" ] % sys.t1, sys.t1, sys.t1, sys.t2, sys.t2, sys.t2 # table_name % way, idx, to_node, way, idx, to_node # name % int, int, int, int, int, int # type % 1, 1, 1, 1, 1, 1 # length #warning: please don't forget to set your vault key! #(see /ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ >% . # table_name % single_value # name % varchar # type % 0 # length [ "" ] MAPI = mone...@localhost:50000 QUERY = select * from way_nds_9 as t1, way_nds_9 as t2 where t1.way = t2.way and t1.idx = t2.idx-1; ERROR = !MALException:opt.remap:no implementation present off #warning: please don't forget to set your vault key! #(see /ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ >% . # table_name % single_value # name % varchar # type % 17 # length [ "history,multiplex" ] % sys.t1, sys.t1, sys.t1, sys.t2, sys.t2, sys.t2 # table_name % way, idx, to_node, way, idx, to_node # name % int, int, int, int, int, int # type % 2, 1, 9, 2, 1, 9 # length [ 35, 0, 200542, 35, 1, 274057218 ] [ 35, 1, 274057218, 35, 2, 200550 ] [ 35, 2, 200550, 35, 3, 200551 ] [ 35, 3, 200551, 35, 4, 200553 ] [ 37, 0, 200511, 37, 1, 177231081 ] [ 37, 1, 177231081, 37, 2, 200513 ] [ 37, 2, 200513, 37, 3, 177081428 ] history #warning: please don't forget to set your vault key! #(see /ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ >% . # table_name % single_value # name % varchar # type % 7 # length [ "history" ] MAPI = mone...@localhost:50000 QUERY = select * from way_nds_9 as t1, way_nds_9 as t2 where t1.way = t2.way and t1.idx = t2.idx-1; ERROR = !MALException:opt.remap:no implementation present multiplex #warning: please don't forget to set your vault key! #(see /ufs/manegold/_/scratch0/Monet/Testing/Stable/prefix.--enable-strict_--disable-debug_--enable-optimize_--disable-assert/etc/monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ >% . # table_name % single_value # name % varchar # type % 9 # length [ "multiplex" ] % sys.t1, sys.t1, sys.t1, sys.t2, sys.t2, sys.t2 # table_name % way, idx, to_node, way, idx, to_node # name % int, int, int, int, int, int # type % 2, 1, 9, 2, 1, 9 # length [ 35, 0, 200542, 35, 1, 274057218 ] [ 35, 1, 274057218, 35, 2, 200550 ] [ 35, 2, 200550, 35, 3, 200551 ] [ 35, 3, 200551, 35, 4, 200553 ] [ 37, 0, 200511, 37, 1, 177231081 ] [ 37, 1, 177231081, 37, 2, 200513 ] [ 37, 2, 200513, 37, 3, 177081428 ] ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2787821&group_id=56967 ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
