From 9d2ac13b7b318be0540c6fc5d96b412e8c7bab02 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Sven=20Sch=C3=B6ling?= Date: Thu, 14 May 2009 13:03:15 +0000 Subject: [PATCH] =?utf8?q?aliased=20subqueries=20m=C3=BCssen=20mit=20ihrem?= =?utf8?q?=20alias=20im=20group=20by=20=20stehen.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Fix für Bug 983. --- SL/IC.pm | 2 ++ 1 file changed, 2 insertions(+) diff --git a/SL/IC.pm b/SL/IC.pm index 80781b7f7..f691a354f 100644 --- a/SL/IC.pm +++ b/SL/IC.pm @@ -914,6 +914,7 @@ sub all_parts { if ($form->{l_soldtotal}) { push @where_tokens, 'ioi.qty >= 0'; push @group_tokens, @select_tokens; + map { s/.*\sAS\s+//si } @group_tokens; push @select_tokens, 'SUM(ioi.qty)'; } @@ -927,6 +928,7 @@ sub all_parts { ordnumber => 'apoe.', make => 'mm.', quonumber => 'apoe.', model => 'mm.', invnumber => 'apoe.', partsgroup => 'pg.', + lastcost => ' ', factor => 'pfac.', 'SUM(ioi.qty)' => ' ', ); -- 2.20.1