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

support assisted discovery in oqgraph v3

Details

    Description

      OQGraph v3 tables have fixed structure, the manual says

      The CREATE statement must match the format below - any difference will result in an error.

      It would be much more user friendly to support assisted discovery and not force the user to specify the table structure at all. Then a user would only need to type, say,

      CREATE TABLE oq_graph
      ENGINE=OQGRAPH 
      data_table='oq_backing' origid='origid' destid='destid';

      Assisted discovery is easy, see federatedx.cc and sequence.cc for examples.

      Attachments

        Activity

          serg Sergei Golubchik created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Description OQGraph v3 tables have fixed structure, the [[manual|https://mariadb.com/kb/en/oqgraph-examples/]] says "The CREATE statement must match the format below - any difference will result in an error."

          It would be much more user friendly to support assisted discovery and not force the user to specify the table structure at all. Then a user would only need to type, say,
          {code:sql}
          CREATE TABLE oq_graph
          ENGINE=OQGRAPH
          data_table='oq_backing' origid='origid' destid='destid';
          {code}

          Assisted discovery is easy, see federatedx.cc and sequence.cc for examples.
          OQGraph v3 tables have fixed structure, the [manual|https://mariadb.com/kb/en/oqgraph-examples/] says "The CREATE statement must match the format below - any difference will result in an error."

          It would be much more user friendly to support assisted discovery and not force the user to specify the table structure at all. Then a user would only need to type, say,
          {code:sql}
          CREATE TABLE oq_graph
          ENGINE=OQGRAPH
          data_table='oq_backing' origid='origid' destid='destid';
          {code}

          Assisted discovery is easy, see federatedx.cc and sequence.cc for examples.
          serg Sergei Golubchik made changes -
          Description OQGraph v3 tables have fixed structure, the [manual|https://mariadb.com/kb/en/oqgraph-examples/] says "The CREATE statement must match the format below - any difference will result in an error."

          It would be much more user friendly to support assisted discovery and not force the user to specify the table structure at all. Then a user would only need to type, say,
          {code:sql}
          CREATE TABLE oq_graph
          ENGINE=OQGRAPH
          data_table='oq_backing' origid='origid' destid='destid';
          {code}

          Assisted discovery is easy, see federatedx.cc and sequence.cc for examples.
          OQGraph v3 tables have fixed structure, the [manual|https://mariadb.com/kb/en/oqgraph-examples/] says {quote}The CREATE statement must match the format below - any difference will result in an error.{quote}

          It would be much more user friendly to support assisted discovery and not force the user to specify the table structure at all. Then a user would only need to type, say,
          {code:sql}
          CREATE TABLE oq_graph
          ENGINE=OQGRAPH
          data_table='oq_backing' origid='origid' destid='destid';
          {code}

          Assisted discovery is easy, see federatedx.cc and sequence.cc for examples.
          arjen Arjen Lentz made changes -
          Assignee Arjen Lentz [ arjen ] Andrew McDonnell [ andymc73 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.12 [ 15201 ]
          Fix Version/s 10.0.11 [ 15200 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 36819 ] MariaDB v2 [ 42605 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0.13 [ 16000 ]
          Fix Version/s 10.0.12 [ 15201 ]
          serg Sergei Golubchik made changes -
          Labels oqgraph
          serg Sergei Golubchik made changes -
          Assignee Andrew McDonnell [ andymc73 ] Sergei Golubchik [ serg ]
          serg Sergei Golubchik made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Andrew McDonnell [ andymc73 ]
          serg Sergei Golubchik made changes -
          Attachment oqgraph_assisted_discovery.patch [ 31302 ]
          serg Sergei Golubchik made changes -
          Due Date 2014-10-06
          serg Sergei Golubchik made changes -
          Assignee Andrew McDonnell [ andymc73 ] Sergei Golubchik [ serg ]
          serg Sergei Golubchik made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.1.2 [ 15801 ]
          Fix Version/s 10.0 [ 16000 ]
          serg Sergei Golubchik made changes -
          Due Date 2014-10-06
          serg Sergei Golubchik made changes -
          Component/s Storage Engine - OQGRAPH [ 10130 ]
          serg Sergei Golubchik made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          serg Sergei Golubchik made changes -
          Resolution Fixed [ 1 ]
          Status Stalled [ 10000 ] Closed [ 6 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 42605 ] MariaDB v3 [ 65353 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 65353 ] MariaDB v4 [ 132294 ]

          People

            serg Sergei Golubchik
            serg Sergei Golubchik
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.