CPC G06F 16/24534 (2019.01) | 19 Claims |
1. A method of interpreting query syntax, comprising:
receiving a query statement having a conditional expression for data retrieval from a multidimensional database;
identifying a Boolean expression in the query statement directed towards the multidimensional database by:
tagging Boolean expressions appearing in a filter context in the query statement, the query statement defined by SQL in a first pass; and
tagging all Boolean expressions irrespective of a filter context in a successive second pass;
determining that the conditional expression contains a value of an unsupported type based on the Boolean expression occurring in a value context based on whether the Boolean expression is double-tagged, where the query statement is directed to a database that rejects Boolean expressions in a value context;
removing the double-tagged Boolean expressions;
transforming, based on the determination of an unsupported type denoted by the remaining tagged Boolean Expressions, the unsupported value of the conditional expression to a value of a supported type by replacing the identified Boolean expression with a sentinel value denoting a Boolean constant.
|