PDA

View Full Version : mql constraints



dmartynov
10-30-2008, 12:40 PM
Hi all.
Tell me please somebody should I check "is the formula exact" if I want to put mql constraint on business column

my constraint is
LIKE(;"aFN")

or maybe should I put this constraint on the whole business table(I mean add to BT new property "formula")


[B]1)My problem is: when I put MQL constraint on BC without checking "is the formula exact" I get

java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or co
lumn specification

because the query looks like:
SELECT DISTINCT
BT_PERSON_PERSON.LIKE([BT_PERSON_PERSON.BC_PERSON_FIRSTNAME];"aFN") AS COL0
FROM
PERSON BT_PERSON_PERSON


2) when I put MQL constraint on BC with checking "is the formula exact" I get

"StackOverFlowException"
at org.pentaho.pms.mql.PMSFormula.generateSQL(PMSFormula.java:534)
at org.pentaho.pms.mql.dialect.DefaultSQLFunctionGenerator.generateFunct
ionSQL(DefaultSQLFunctionGenerator.java:170)
at org.pentaho.pms.mql.PMSFormula.generateSQL(PMSFormula.java:554)
at org.pentaho.pms.mql.PMSFormula.generateSQL(PMSFormula.java:622)
at org.pentaho.pms.mql.SQLGenerator.getBusinessColumnSQL(SQLGenerator.ja
va:628)
at org.pentaho.pms.mql.PMSFormula.renderContextLookup(PMSFormula.java:59
7)
at org.pentaho.pms.mql.PMSFormula.generateSQL(PMSFormula.java:534)