[MDEV-740] LP:459714 - Proper test suite for OQGRAPH Created: 2010-10-22  Updated: 2013-07-19  Resolved: 2013-07-19

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: 10.0.5

Type: Task Priority: Minor
Reporter: Arjen Lentz (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug459714.xml    

 Description   

Given that OQGRAPH is not a 'normal' general purpose storage engine, we can't simply derive a test suite from existing ones.
However, we would like to test all aspects of the engine, including interaction in complex join constructs and replication.

Perhaps some basics can be adapted from existing tests, the rest will have to be new.
This will probably be a step-wise and ongoing thing. If you can help, please do!

What we need: (based on feedback from Philip Stoev)

  • a complete MTR test suite that covers at least the following:
  • INSERTS, especially with weight and those that will be rejected by the engine;
  • the SELECT statements that are accepted by the engine, as described in the manual, including those with latch=0 or latch = NULL;
  • the DML/DDL/ALTER statements that are and are not accepted by the engine, so that all the engine capabilities the handler advertises and all the API calls are exercised;
  • a dataset that is sized appropriately for MTR execution (10K nodes?). Either in the form of INSERT statements or a stored procedure, plus some SELECT queries on top of that dataset;


 Comments   
Comment by Arjen Lentz (Inactive) [ 2009-12-17 ]

Re: Proper test suite for OQGRAPH
Basic testsuite in place (as part of the env for MariaDB), will merge back shortly.

Comment by Arjen Lentz (Inactive) [ 2010-10-22 ]

Re: Proper test suite for OQGRAPH
Created two simple data generators:

  • examples/randoms/randtree which can create a simple unidirectional tree structure (like a menu tree)
  • examples/randoms/randsocial can create a social network with friends/weight and fans
    both can be specific at arbitrary size, with variable # of friends and fans, and random weight within a range.
    This should enable more stringent testing of some aspects.
Comment by Rasmus Johansson (Inactive) [ 2010-10-22 ]

Launchpad bug id: 459714

Comment by Arjen Lentz [ 2013-03-20 ]

Seems that some earlier changes didn't stick? Rasmus changed the Assignee to me last October, but it's listed as "Unassigned" now.

The test suite issue is resolved for OQGRAPH v3 implementation, which is in a branch of MariaDB 10 and will be submitted for merging soon.
It has proper coverage of the basic functions and related syntax checks, and also uses a data generator as recommended earlier.

Comment by Arjen Lentz [ 2013-07-19 ]

This has been resolved for OQGraph v3 which is to be merged into MariaDB 10.0.

Comment by Sergei Golubchik [ 2013-07-19 ]

closing, as per the last comment

Generated at Thu Feb 08 06:30:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.