Proper test suite for OQGRAPH

[Arjen Lentz]

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;

[Arjen Lentz (arjen-lentz)]

Basic testsuite in place (as part of the env for MariaDB), will merge back shortly.

[Arjen Lentz (arjen-lentz)]

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.

[Arjen Lentz (arjen-lentz)]

Existing testsuite adapted for v3 engine (basic modified, binlog removed as no longer relevant)
New checks for CREATE/ALTER TABLE added (create_attr) including some appropriate rejection scenarios.

Looking at best approach to include a suitable bigger dataset in the testsuite.

[Andrew McDonnell (andymc73)]

I have extended the coverage of basic.test and added a separate file for edge cases.

http://bazaar.launchpad.net/~andymc73/oqgraph/10.0-oqgraph3-varchar/revision/3656

[Andrew McDonnell (andymc73)]

I'm going to resolve this. We now test on MyISAM, Innodb and ariadb, so other backing engines can have specific bugs if needed.
Same for other coverage.