mirror of
https://github.com/MariaDB/server.git
synced 2025-10-29 01:46:31 +01:00
68 lines
2.9 KiB
Text
68 lines
2.9 KiB
Text
DROP TABLE IF EXISTS graph_base;
|
|
DROP TABLE IF EXISTS graph;
|
|
CREATE TABLE graph_base (
|
|
from_id INT UNSIGNED NOT NULL,
|
|
to_id INT UNSIGNED NOT NULL,
|
|
PRIMARY KEY (from_id,to_id),
|
|
INDEX (to_id)
|
|
) ENGINE=MyISAM;
|
|
CREATE TABLE 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='graph_base' ORIGID='from_id', DESTID='to_id';
|
|
INSERT INTO graph_base(from_id, to_id) VALUES (1,2), (2,1);
|
|
SELECT * FROM graph WHERE latch = 'breadth_first' AND origid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = '2' AND origid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = 'dijkstras' AND origid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = '1' AND origid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = 'breadth_first' AND destid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = '2' AND destid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = 'dijkstras' AND destid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = '1' AND destid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = 'breadth_first' AND origid = 666 and weight = 1;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = '2' AND origid = 666 and weight = 1;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = 'dijkstras' AND origid = 666 and weight = 1;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = '1' AND origid = 666 and weight = 1;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = 'breadth_first' AND destid = 666 and weight = 1;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = '2' AND destid = 666 and weight = 1;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = 'dijkstras' AND destid = 666 and weight = 1;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = '1' AND destid = 666 and weight = 1;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = '' AND origid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = '0' AND origid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch is NULL AND origid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = '' AND destid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch = '0' AND destid = 666;
|
|
latch origid destid weight seq linkid
|
|
SELECT * FROM graph WHERE latch is NULL AND destid = 666;
|
|
latch origid destid weight seq linkid
|
|
DELETE FROM graph_base;
|
|
FLUSH TABLES;
|
|
TRUNCATE TABLE graph_base;
|
|
DROP TABLE graph_base;
|
|
DROP TABLE graph;
|