[MDEV-10106] Testing for MDEV-8989 Created: 2016-05-23  Updated: 2016-06-08  Resolved: 2016-06-08

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

Type: Task Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Fixed Votes: 0
Labels: None


 Description   

test this tree:
https://github.com/MariaDB/server/commits/bb-10.1-mdev8989

for crashes and wrong query results?

things to test for

  • ORDER BY/GROUP BY with various columns
  • WHERE clause should have equalities involving the same columns
  • there should be indexes that allow to resolve ORDER/GROUP BY and use the same
    columns. Try without these indexes, too.
  • VIEWS with algorithm=merge receive a slightly different handling in the
    patch, so it would be nice to cover them,too.

 Comments   
Comment by Elena Stepanova [ 2016-05-25 ]

Servers were amended to avoid MDEV-10098 and alike.

Lots of crashes due to MDEV-10045.
Some crashes due to MDEV-6453.

Prepared statements:
Some crashes due to MDEV-9619.

Comment by Elena Stepanova [ 2016-06-08 ]

From Slack of May 30:

elenst
spetrunia: i haven't got anything for MDEV-8989. It feels weird, makes me doubt myself But I can't hold you forever, if you want to push it already, please do. If I can, I'll run more tests on the main tree. Just for a note, what I did ​not​ do is performance comparison – it's supposed to be performance improvement, right?

spetrunia
elenst: re MDEV-8989: thanks. Yes this is supposed to be a performance improvement. But regressions are possible, that's why it will be wrapped in an optimizer switch.

Note: the optimizer switch wasn't tested in the work tree.

Generated at Thu Feb 08 07:39:43 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.