<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR>
<STYLE>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:2.0cm 69.6pt 2.0cm 69.6pt;}
div.Section1
{page:Section1;}
-->
</STYLE>
</HEAD>
<BODY lang=RU vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=575265915-10072007><FONT face=Verdana
color=#000080 size=2>Seems like a parser bug. The query succeeds if there are
braces around the expression, viz</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=575265915-10072007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=575265915-10072007><FONT face=Verdana>
<P class=MsoPlainText><SPAN lang=EN-US style="FONT-SIZE: 10pt"><FONT
color=#000080>with set [Set1] as '<SPAN
class=575265915-10072007>{</SPAN>[Product].[Drink]:[Product].[Food]<SPAN
class=575265915-10072007>}</SPAN>' <o:p></o:p></FONT></SPAN></P>
<P class=MsoPlainText><FONT face="Courier New"><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><FONT color=#000080>select [Set1] on columns,
{[Measures].defaultMember} on rows <o:p></o:p></FONT></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New"><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><FONT color=#000080>from
Sales<o:p></o:p></FONT></SPAN></FONT></P></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=575265915-10072007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=575265915-10072007><FONT face=Verdana
color=#000080 size=2>Please log a bug at SF.net.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=575265915-10072007><FONT face=Verdana
color=#000080 size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=575265915-10072007><FONT face=Verdana
color=#000080 size=2>Julian</FONT></SPAN></DIV><FONT face=Verdana color=#000080
size=2></FONT><BR>
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mondrian-bounces@pentaho.org
[mailto:mondrian-bounces@pentaho.org] <B>On Behalf Of </B>Anton
Nikitin<BR><B>Sent:</B> Tuesday, July 10, 2007 7:56 AM<BR><B>To:</B> 'Mondrian
developer mailing list'<BR><B>Subject:</B> [Mondrian] Bug: Named set +
range<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Just have found the following bug (version
2.3.2.8944).<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Not sure about latest
sources.<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt">The following MDX fails (MSAS 2000
succeedes):<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt">with set [Set1] as
'[Product].[Drink]:[Product].[Food]' <o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt">select [Set1] on columns, {[Measures].defaultMember}
on rows <o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt">from Sales<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Result:<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><o:p> </o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt">mondrian.olap.MondrianException: Mondrian Error:Syntax
error in MDX expression
'[Product].[Drink]:[Product].[Food]'<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:755)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.Parser.parseExpression(Parser.java:796)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.Parser.recursivelyParseExp(Parser.java:730)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1359)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.Parser.do_action(Parser.java:685)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
java_cup.runtime.lr_parser.parse(lr_parser.java:569)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.Parser.parseInternal(Parser.java:755)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.web.servlet.MDXQueryServlet.processRequest(MDXQueryServlet.java:85)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.web.servlet.MDXQueryServlet.doGet(MDXQueryServlet.java:228)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
java.lang.Thread.run(Thread.java:595)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt">Caused by: mondrian.olap.MondrianException: Mondrian
Error:Syntax error at line 1, column 19, token
':'<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.resource.MondrianResource$_Def4.ex(MondrianResource.java:825)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.Parser.syntax_error(Parser.java:886)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
java_cup.runtime.lr_parser.parse(lr_parser.java:595)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.Parser.parseExpression(Parser.java:791)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> ... 25
more<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt">mondrian.olap.MondrianException: Mondrian Error:Syntax
error at line 1, column 19, token ':'<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.resource.MondrianResource$_Def4.ex(MondrianResource.java:825)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.Parser.syntax_error(Parser.java:886)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
java_cup.runtime.lr_parser.parse(lr_parser.java:595)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.Parser.parseExpression(Parser.java:791)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.Parser.recursivelyParseExp(Parser.java:730)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.CUP$Parser$actions.CUP$Parser$do_action(Parser.java:1359)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.Parser.do_action(Parser.java:685)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
java_cup.runtime.lr_parser.parse(lr_parser.java:569)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.Parser.parseInternal(Parser.java:755)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:74)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.olap.ConnectionBase.parseQuery(ConnectionBase.java:59)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.web.servlet.MDXQueryServlet.processRequest(MDXQueryServlet.java:85)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
mondrian.web.servlet.MDXQueryServlet.doGet(MDXQueryServlet.java:228)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:689)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)<o:p></o:p></SPAN></FONT></P>
<P class=MsoPlainText><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"> at
java.lang.Thread.run(Thread.java:595)<o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>