[ https://issues.apache.org/jira/browse/CALCITE-6195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated CALCITE-6195: ------------------------------------ Labels: pull-request-available (was: ) > SqlValidator validateParameterizedExpression is not supporting qualified paths > ------------------------------------------------------------------------------ > > Key: CALCITE-6195 > URL: https://issues.apache.org/jira/browse/CALCITE-6195 > Project: Calcite > Issue Type: Bug > Components: core > Affects Versions: 1.36.0 > Reporter: David Dali Susanibar Arce > Priority: Major > Labels: pull-request-available > > The SQLValidator.validateParameterizedExpression method can be used to > validate parameterized expressions. > It is possible to register > [validateParameterizedExpression|https://github.com/apache/calcite/blob/1b11d99e65d03a15ae4b25c47250b6918ce9aa10/core/src/test/java/org/apache/calcite/test/SqlValidatorTest.java#L11421:L11435]: > {code:java} > final Map<String, RelDataType> nameToTypeMap = new HashMap<>(); > nameToTypeMap.put("A", intType); > nameToTypeMap.put("B", intTypeNull); > final String expr = "a + b"; > final SqlNode validated = validator.validateParameterizedExpression(sqlNode, > nameToTypeMap);{code} > > Problems appear if we are trying to register qualified paths: > {code:java} > final Map<String, RelDataType> nameToTypeMap = new HashMap<>(); > nameToTypeMap.put("EMP.A", intType); > nameToTypeMap.put("EMP.B", intTypeNull); > final String expr = "EMP.a + EMP.b"; > final SqlNode validated = validator.validateParameterizedExpression(sqlNode, > nameToTypeMap); > Error: > org.apache.calcite.runtime.CalciteContextException: From line 1, column 1 to > line 1, column 3: Unknown identifier 'EMP' > {code} > I would appreciate if you could provide me with some advice regarding how to > resolve this error. -- This message was sent by Atlassian Jira (v8.20.10#820010)