sql: regression test MovR

[awoods187]

MovR is an important sample workload that we ship in our workload package for demos, use in education (e.g., documentation, training), and encourage SE use for customer demos. However, we don't regularly run tests against MovR to ensure that workload doesn't regress with changes to CockroachDB. We need to invest the same rigor of performance tests as we do with other benchmarks like TPC-C and TPC-H to ensure that MovR always works well for our end customers.

Examples of issues include this or this slack conversation.

Jira issue: CRDB-2892

[awoods187]

cc @jordanlewis @vy-ton @nstewart

[nstewart]

Also this example from 20.1 - #49658

[rafiss]

We can add a nightly test that executes the steps of the Movr demo. The demo script is here https://github.com/cockroachlabs/scripted-demos/blob/master/geo-partitioned-replicas-demo.sh

We won't be able to commit to fixing all the issues that come up with this test, since there's such a broad range of features in the demo, but hopefully this is a good starting point for catching regressions and routing them to the correct team.

[vy-ton]

@rafiss @solongordon Can we add this for 21.1 stability or a quality initiative for 21.2?

[github-actions]

We have marked this issue as stale because it has been inactive for
18 months. If this issue is still relevant, removing the stale label
or adding a comment will keep it active. Otherwise, we'll close it in
10 days to keep the issue queue tidy. Thank you for your contribution
to CockroachDB!