[MDEV-5987] SELECT from empty OQGraph table results in query being killed. Created: 2014-03-31  Updated: 2014-03-31  Resolved: 2014-03-31

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.10
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Heinz Wiesinger Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: oqgraph
Environment:

CentOS 6



 Description   

I have an empty backing table and an OQGraph table pointing to it. When trying to run a SELECT query on the empty table, the query gets killed:

MariaDB [(none)]> use mydb
Database changed
MariaDB [mydb]> CREATE TABLE oq_backing (
-> origid INT UNSIGNED NOT NULL,
-> destid INT UNSIGNED NOT NULL,
-> PRIMARY KEY (origid, destid),
-> KEY (destid)
-> );
Query OK, 0 rows affected (0.40 sec)

MariaDB [mydb]> CREATE TABLE oq_graph (
-> latch VARCHAR(32) NULL,
-> origid BIGINT UNSIGNED NULL,
-> destid BIGINT UNSIGNED NULL,
-> weight DOUBLE NULL,
-> seq BIGINT UNSIGNED NULL,
-> linkid BIGINT UNSIGNED NULL,
-> KEY (latch, origid, destid) USING HASH,
-> KEY (latch, destid, origid) USING HASH
-> )
-> ENGINE=OQGRAPH
-> data_table='oq_backing' origid='origid' destid='destid';
Query OK, 0 rows affected (0.14 sec)

MariaDB [mydb]> SELECT * FROM oq_graph;
Killed



 Comments   
Comment by Heinz Wiesinger [ 2014-03-31 ]

Testcase is close enough to the one provided in MDEV-5891, so probably the same bug.

Comment by Elena Stepanova [ 2014-03-31 ]

Duplicate of either MDEV-5988 as mentioned above, or of MDEV-5891 (on a debug build it fails with the same assertion), or both.

Generated at Thu Feb 08 07:08:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.