[SERVER-39055] Error: expected PlanStage for table DBname.t4, got <nil> SQLState: HY000 ErrorCode: 1105, MongoDB 2.6 server Created: 16/Jan/19  Updated: 16/Jan/19  Resolved: 16/Jan/19

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: 4.0.2
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Adarshdeep Cheema Assignee: Danny Hatcher (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
is duplicated by SERVER-39054 Error: expected PlanStage for table D... Closed
Operating System: ALL
Steps To Reproduce:

This issue is specific to MONGO 2.6 server.

When we try to run the following query against MongoDB BI Connector 2.6 on MongoDB 4.0.2 server then it throws the ERROR: error cross join optimizer: expected PlanStage for table dbcert.t4, got <nil>
SQLState: HY000
ErrorCode: 1105

PLEASE NOTE: This issue does not occur when we use the same query against MongoDB BI Connector 2.7 on MongoDB 4.0.3 and MongoDB BI Connector 2.8 on MongoDB 4.0.5

 

QUERY:

SELECT
`t1`.`col1` AS `C1`,
`t1`.`col2` AS `C2`,
`t1`.`col3` AS `C3`
FROM
`dbName`.`Table1` `t2`,
`dbName`.`Table1` `t3`,
(
SELECT
`col2`,
1 AS `c2`
FROM
`dbName`.`Table1`
WHERE
`col2` IN (
'P1',
'c' )
) `t4`,
(
SELECT
`col1`,
`col2`,
`col3`
FROM
`dbName`.`Table2`
WHERE
`col1` = 'S1' AND
`col2` = 'P1'
) `t1`
WHERE
`t2`.`col2` = `t1`.`col2` AND
`t2`.`col2` = `t4`.`col2` AND
`t2`.`col2` = `t3`.`col2` AND
`t2`.`col2` IN (
'P1',
'a' ) AND
`t3`.`col2` IN (
'P1',
'b' )
ORDER BY
`C3` ASC

Participants:

 Description   

SELECT
`t1`.`col1` AS `C1`,
`t1`.`col2` AS `C2`,
`t1`.`col3` AS `C3`
FROM
`dbName`.`Table1` `t2`,
`dbName`.`Table1` `t3`,
(
SELECT
`col2`,
1 AS `c2`
FROM
`dbName`.`Table1`
WHERE
`col2` IN (
'P1',
'c' )
) `t4`,
(
SELECT
`col1`,
`col2`,
`col3`
FROM
`dbName`.`Table2`
WHERE
`col1` = 'S1' AND
`col2` = 'P1'
) `t1`
WHERE
`t2`.`col2` = `t1`.`col2` AND
`t2`.`col2` = `t4`.`col2` AND
`t2`.`col2` = `t3`.`col2` AND
`t2`.`col2` IN (
'P1',
'a' ) AND
`t3`.`col2` IN (
'P1',
'b' )
ORDER BY
`C3` ASC



 Comments   
Comment by Danny Hatcher (Inactive) [ 16/Jan/19 ]

Hello,

Thanks for your report. Please note that SERVER project is for reporting bugs or feature suggestions for the MongoDB server. For MongoDB-related support discussion please post on the mongodb-user group or Stack Overflow with the mongodb tag. A question like this involving more discussion would be best posted on the mongodb-user group. BI Connector Support from MongoDB engineers is included in our Enterprise Advanced package.

Please note that we recommend using the latest edition of BI Connector which is currently 2.9.0.

Thank you,

Danny

Generated at Thu Feb 08 04:50:53 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.