[MDEV-15974] Run optimizer tests with system versioned tables Created: 2018-04-22  Updated: 2022-09-19  Resolved: 2022-09-19

Status: Closed
Project: MariaDB Server
Component/s: Tests
Fix Version/s: N/A

Type: Task Priority: Minor
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Incomplete Votes: 0
Labels: None


 Description   

Run optimizer tests on tables with system versioning, at least InnoDB and MyISAM, if there is time, then also Aria and RocksDB:

  • "traditional" optimizer tests for crashes;
  • transformation tests with most common transformers;
  • result comparison between versioned and not versioned tables on the same branch/revision;
  • CTE tests (see MDEV-14820, probably need to wait till it's fixed);
  • Window functions;
  • anything else you can think of in context of optimizer;

Nice to do:

  • poor man's rough optimizer performance comparison for versioned vs non-versioned tables, see for example lib/GenTest/Validator/ExecutionTimeComparator.pm
Generated at Thu Feb 08 08:25:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.