Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-740

LP:459714 - Proper test suite for OQGRAPH

    Details

    • Type: Task
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Fix Version/s: 10.0.5
    • Component/s: None
    • Labels:

      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;

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            arjenlentz Arjen Lentz added a comment -

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

            Show
            arjenlentz Arjen Lentz added a comment - Re: Proper test suite for OQGRAPH Basic testsuite in place (as part of the env for MariaDB), will merge back shortly.
            Hide
            arjenlentz Arjen Lentz added a comment -

            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.
            Show
            arjenlentz Arjen Lentz added a comment - 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.
            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 459714

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 459714
            Hide
            arjen Arjen Lentz added a comment -

            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.

            Show
            arjen Arjen Lentz added a comment - 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.
            Hide
            arjen Arjen Lentz added a comment -

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

            Show
            arjen Arjen Lentz added a comment - This has been resolved for OQGraph v3 which is to be merged into MariaDB 10.0.
            Hide
            serg Sergei Golubchik added a comment -

            closing, as per the last comment

            Show
            serg Sergei Golubchik added a comment - closing, as per the last comment

              People

              • Assignee:
                Unassigned
                Reporter:
                arjenlentz Arjen Lentz
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: