Tuesday, March 20, 2012

Bug: Query Analyser (german): Cost, percentage, .. in graphical execution plan are wrong

Hi to all,
there is an anoying bug in the Query Analyser (german) version 8.00.760:
In the graphical execution plan costs, percentage, ... are wrong!
If I use set showplan_all on, I will get the right values.
I guess it might be the german decimal character!
If I change the country settings to english(usa) everything ist ok.
Couldn't find this on the msdn side.
Is there any bugfix.
markusi think this applies to all europeans versions that
use "," in place of the english "."
it is possible the numerical values are generated by sql
server, and the graphical display by QA, which may be
handling the european convention
-sorry don't know of fix, i mostly work with US settings
>--Original Message--
>Hi to all,
>there is an anoying bug in the Query Analyser (german)
version 8.00.760:
>In the graphical execution plan costs, percentage, ...
are wrong!
>If I use set showplan_all on, I will get the right values.
>I guess it might be the german decimal character!
>If I change the country settings to english(usa)
everything ist ok.
>Couldn't find this on the msdn side.
>Is there any bugfix.
>markus
>
>.
>|||I reported this as a bug back in April but I don't believe there is a fix
available.
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Markus Wimplinger" <markus.wimplinger@.cds.co.at> wrote in message
news:%23jZ5F6JmDHA.2488@.TK2MSFTNGP12.phx.gbl...
Hi to all,
there is an anoying bug in the Query Analyser (german) version 8.00.760:
In the graphical execution plan costs, percentage, ... are wrong!
If I use set showplan_all on, I will get the right values.
I guess it might be the german decimal character!
If I change the country settings to english(usa) everything ist ok.
Couldn't find this on the msdn side.
Is there any bugfix.
markus

No comments:

Post a Comment