EVOLUTION-MANAGER

Edit File: boundary_conditions.result

DROP TABLE IF EXISTS graph_base; DROP TABLE IF EXISTS graph; DROP TABLE IF EXISTS graph2; call mtr.add_suppression("graph_base is open on delete"); CREATE TABLE graph2 ( 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'; SELECT * FROM graph2 WHERE latch='dijkstras' AND origid=1 AND destid=6; ERROR 42S02: Table 'test.graph_base' doesn't exist DROP TABLE graph2; 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); INSERT INTO graph_base(from_id, to_id) VALUES (1,3), (3,1); INSERT INTO graph_base(from_id, to_id) VALUES (3,4), (4,3); INSERT INTO graph_base(from_id, to_id) VALUES (5,6), (6,5); # Expect no result, because of autocast SELECT * FROM graph WHERE latch=0 ; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch=0 and destid=2 and origid=1; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch=0 and origid=1; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch=0 and destid=1; 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=0 and origid is NULL; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch=1 ; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch=1 and destid=2 and origid=1; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch=1 and origid=1; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch=1 and destid=1; 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=1 and origid is NULL; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch=2 ; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch=2 and destid=2 and origid=1; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch=2 and origid=1; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch=2 and destid=1; 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=2 and origid is NULL; latch origid destid weight seq linkid # Should this return an error? it seems we treat it as just another bogus latch SELECT * FROM graph WHERE latch='ThisExceeds32Characters456789012'; latch origid destid weight seq linkid # Expect no result, because of invalid latch SELECT * FROM graph WHERE latch='bogus'; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch='bogus' and destid=2 and origid=1; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='bogus' and origid=1; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='bogus' and destid=1; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='bogus' and origid=666; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='bogus' and origid is NULL; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='666'; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch='666' and destid=2 and origid=1; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='666' and origid=1; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='666' and destid=1; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='666' and origid=666; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='666' and origid is NULL; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='-1'; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch='-1' and destid=2 and origid=1; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='-1' and origid=1; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='-1' and destid=1; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='-1' and origid=666; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='-1' and origid is NULL; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch # Make sure we dont crash if someone passed in a UTF string SELECT * FROM graph WHERE latch='Ω Ohms Tennis Ball 〄'; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch='Ω Ohms Tennis Ball 〄' and destid=2 and origid=1; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='Ω Ohms Tennis Ball 〄' and origid=1; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='Ω Ohms Tennis Ball 〄' and destid=1; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='Ω Ohms Tennis Ball 〄' and origid=666; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch SELECT * FROM graph WHERE latch='Ω Ohms Tennis Ball 〄' and origid is NULL; latch origid destid weight seq linkid Warnings: Warning 1210 Incorrect arguments to OQGRAPH latch # Return all edges when latch is NULL SELECT * FROM graph WHERE latch is NULL; latch origid destid weight seq linkid NULL 1 2 1 NULL NULL NULL 2 1 1 NULL NULL NULL 1 3 1 NULL NULL NULL 3 1 1 NULL NULL NULL 3 4 1 NULL NULL NULL 4 3 1 NULL NULL NULL 5 6 1 NULL NULL NULL 6 5 1 NULL NULL SELECT * FROM graph WHERE latch is NULL and destid=2 and origid=1; latch origid destid weight seq linkid NULL 1 2 1 3 1 NULL 1 2 1 2 3 NULL 1 2 1 1 2 SELECT * FROM graph WHERE latch is NULL and origid=1; latch origid destid weight seq linkid NULL 1 NULL 1 2 3 NULL 1 NULL 1 1 2 SELECT * FROM graph WHERE latch is NULL and destid=1; latch origid destid weight seq linkid NULL NULL 1 1 2 3 NULL NULL 1 1 1 2 SELECT * FROM graph WHERE latch is NULL and origid=666; latch origid destid weight seq linkid SELECT * FROM graph WHERE latch is NULL and origid is NULL; latch origid destid weight seq linkid NULL NULL NULL NULL NULL 1 NULL NULL NULL NULL NULL 2 NULL NULL NULL NULL NULL 3 NULL NULL NULL NULL NULL 4 NULL NULL NULL NULL NULL 5 NULL NULL NULL NULL NULL 6 INSERT INTO graph_base(from_id, to_id) VALUES (1,2); ERROR 23000: Duplicate entry '1-2' for key 'PRIMARY' DELETE FROM graph_base; SELECT * FROM graph; latch origid destid weight seq linkid FLUSH TABLES; TRUNCATE TABLE graph_base; SELECT * FROM graph; latch origid destid weight seq linkid DROP TABLE graph_base; FLUSH TABLES; SELECT * FROM graph WHERE latch='dijkstras' AND origid=1 AND destid=6; ERROR 42S02: Table 'test.graph_base' doesn't exist DROP TABLE graph;