Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
None
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)]>