We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Describe the bug
The following ECSQL query fails to prepare:
WITH FilteringInfo(ECInstanceId, FilteredChildrenPaths) AS ( VALUES (0x13, '[]') ) SELECT [q].* FROM ( SELECT childModel.* FROM ( SELECT ec_ClassName(model.ECClassId) AS FullClassName, model.ECInstanceId AS ECInstanceId FROM BisCore.GeometricModel3d model ) childModel JOIN BisCore.GeometricModel3d this ON this.ECInstanceId = childModel.ECInstanceId ) [q] JOIN FilteringInfo [f] ON [f].[ECInstanceId] = [q].[ECInstanceId]
with an error BE_SQLITE_ERROR ambiguous column name: ECInstanceId.
BE_SQLITE_ERROR ambiguous column name: ECInstanceId
To Reproduce Steps to reproduce the behavior:
Expected behavior
The query is prepared and executed successfully
Desktop:
Additional context
The given query is simplified version of a much larger query - it's not expected to make much sense in this form.
This workaround seems to solve the issue:
WITH FilteringInfo(ECInstanceId, FilteredChildrenPaths) AS ( VALUES (0x13, '[]') ) SELECT [q].* FROM ( SELECT childModel.ECInstanceId AS ECInstanceId, childModel.* FROM ( SELECT ec_ClassName(model.ECClassId) AS FullClassName, model.ECInstanceId AS ECInstanceId FROM BisCore.GeometricModel3d model ) childModel JOIN BisCore.GeometricModel3d this ON this.ECInstanceId = childModel.ECInstanceId ) [q] JOIN FilteringInfo [f] ON [f].[ECInstanceId] = [q].[ECInstanceId]
The text was updated successfully, but these errors were encountered:
khanaffan
No branches or pull requests
Describe the bug
The following ECSQL query fails to prepare:
with an error
BE_SQLITE_ERROR ambiguous column name: ECInstanceId
.To Reproduce
Steps to reproduce the behavior:
Expected behavior
The query is prepared and executed successfully
Desktop:
Additional context
The given query is simplified version of a much larger query - it's not expected to make much sense in this form.
This workaround seems to solve the issue:
The text was updated successfully, but these errors were encountered: