[SERVER-32567] Replace queryoptimizer3.js with FSM test Created: 05/Jan/18  Updated: 30/Oct/23  Resolved: 20/Nov/19

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: 4.2.3, 4.0.14, 4.3.2

Type: Improvement Priority: Major - P3
Reporter: Benety Goh Assignee: James Wahlin
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
Related
related to SERVER-43403 Index creation may be allowed to star... Closed
related to SERVER-39224 Explore why queryoptimizer3.js fails ... Closed
related to SERVER-46872 yield_with_drop.js FSM workload shoul... Closed
is related to SERVER-4400 attempt to record query plan for a dr... Closed
is related to SERVER-31615 Blacklist queryoptimizer3.js from all... Closed
Backwards Compatibility: Fully Compatible
Backport Requested:
v4.2, v4.0, v3.6
Sprint: Query 2018-06-18, Query 2018-07-02
Participants:
Linked BF Score: 45

 Description   

This test was written a long time ago for SERVER-4400. We should consider rewriting it as a C++ unit test or remove it. It does not really work well with the passthrough suites we run these days.



 Comments   
Comment by Githook User [ 13/Dec/19 ]

Author:

{'name': 'James Wahlin', 'email': 'james.wahlin@mongodb.com', 'username': 'jameswahlin'}

Message: SERVER-32567 Replace queryoptimizer3.js with yield_with_drop.js FSM test

(cherry picked from commit d86e8a5bf40f1c6edbab37bef38cd0f1d5dc062d)
(cherry picked from commit b5a58d9c335857ab1d414f4f48574e514f640b59)
Branch: v4.0
https://github.com/mongodb/mongo/commit/4abca26280003a57133d6d2ea9f2c03c03291e47

Comment by Githook User [ 10/Dec/19 ]

Author:

{'name': 'James Wahlin', 'username': 'jameswahlin', 'email': 'james.wahlin@mongodb.com'}

Message: SERVER-32567 Replace queryoptimizer3.js with yield_with_drop.js FSM test

(cherry picked from commit d86e8a5bf40f1c6edbab37bef38cd0f1d5dc062d)
Branch: v4.2
https://github.com/mongodb/mongo/commit/b5a58d9c335857ab1d414f4f48574e514f640b59

Comment by Githook User [ 20/Nov/19 ]

Author:

{'name': 'James Wahlin', 'username': 'jameswahlin', 'email': 'james.wahlin@mongodb.com'}

Message: SERVER-32567 Replace queryoptimizer3.js with yield_with_drop.js FSM test
Branch: master
https://github.com/mongodb/mongo/commit/d86e8a5bf40f1c6edbab37bef38cd0f1d5dc062d

Comment by Craig Homa [ 11/Apr/19 ]

Closing as the test failure doesn't seem to be happening any more and re-writing this test in a way that preserves the coverage will take more time than the team can currently allocate. 

Comment by Kyle Suarez [ 08/Jun/18 ]

After inspection, I'd like to extend yield.js instead. That test features concurrent updates and deletes, but does not drop the collection; I think it would be reasonable to extend that test to have a state that drops and recreates the collection, and then extend it further to test counts, updates, deletes and distincts.

Comment by Kyle Suarez [ 01/Jun/18 ]

After speaking with Max, I'm going to take a look at the tests in create_database.js and its related friends. I'm going to make sure that they cover all of the types of query plans tested by queryoptimizer3.js and add them, if any, and then delete queryoptimizer3.js.

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