Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-169

MariaDB RT data insert/update with MVA fields

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Component/s: Other
    • Labels:

      Description

      I have create one rt table in MariaDB. data not geting inserted in MariaDB. Same query is
      running fine in sphinxQL.

      Please help me in this issue for MariaDB RT data insert/update.

      CREATE TABLE `rt1` (
      `id` BIGINT UNSIGNED NOT NULL,
      `title` VARCHAR(100) NOT NULL,
      `content` VARCHAR(5000) NOT NULL,
      `gid` INT UNSIGNED,
      `skills` BIGINT UNSIGNED NOT NULL,
      PRIMARY KEY (`id`)
      ) ENGINE=SPHINX CONNECTION='sphinxql://192.168.2.10:9306/rt1';

      Query: INSERT INTO rt1 (id,title,content, gid ) VALUES (40,'sales', 'sales
      manager','(2,3)')

      Error Code: 1430
      There was a problem processing the query on the foreign data source. Data source error:
      row 1, column 5: non-MVA value specified for a MVA column

      Execution Time : 0 sec
      Transfer Time : 0 sec
      Total Time : 0.060 sec
      ---------------------------------------------------

      MySQL [(none)]> INSERT INTO rt1 (id,title,content,skills ) VALUES (40,'sales', 'sales
      manager',(2,3));
      Query OK, 1 row affected (0.00 sec)

      MySQL [(none)]> select * from rt1;
      ----------------------------------

      id gid title content skills

      ----------------------------------

      40 0 sales sales manager 2,3

      ----------------------------------
      1 row in set (0.00 sec)

      MySQL [(none)]>

        Attachments

          Activity

            People

            Assignee:
            diego dupin Diego Dupin
            Reporter:
            nagarajum Nagaraju Movva
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.