[SERVER-39054] 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: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-39055 Error: expected PlanStage for table D... Closed
Operating System: ALL
Steps To Reproduce:

Run SQL like following against MongoDB BI Connector 2.6 on MongoDB 4.0.2

 

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`.`tsupply`
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   

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`.`tsupply`
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

Comment by Adarshdeep Cheema [ 16/Jan/19 ]

Please close this defect as another defect is logged with correct informantion at https://jira.mongodb.org/browse/SERVER-39055

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