EVOLUTION-MANAGER

Edit File: regression_mdev5996.result

call mtr.add_suppression("99999999 is open on delete"); Performing OQGraph regression test mdev5996 - using db=``, table=`999999999` use test; drop table if exists `999999999` ; drop table if exists vvvvvvv_hhhhhhh; CREATE TABLE `999999999` ( `version` varchar(10) NOT NULL, `updateJSON` mediumtext, `prevVersion` varchar(10) NOT NULL, `nodeID` bigint(20) unsigned NOT NULL DEFAULT '0', `prevNodeID` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`prevNodeID`,`nodeID`), KEY `prevVersion` (`prevVersion`) USING BTREE, KEY `version` (`version`) USING BTREE, KEY `nodeID` (`nodeID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; insert into `999999999` values ( 'x', 'y', 'z', 0, 0); select * from `999999999`; version updateJSON prevVersion nodeID prevNodeID x y z 0 0 CREATE TABLE IF NOT EXISTS vvvvvvv_hhhhhhh ( 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='999999999' origid='prevNodeID' destid='nodeID'; select * from vvvvvvv_hhhhhhh; latch origid destid weight seq linkid NULL 0 0 1 NULL NULL drop table if exists `999999999`; drop table if exists vvvvvvv_hhhhhhh; Performing OQGraph regression test mdev5996 - using db=`1`, table=`999999999` use test; drop database if exists `1` ; create database `1` ; use `1` ; drop table if exists `999999999` ; drop table if exists vvvvvvv_hhhhhhh; CREATE TABLE `999999999` ( `version` varchar(10) NOT NULL, `updateJSON` mediumtext, `prevVersion` varchar(10) NOT NULL, `nodeID` bigint(20) unsigned NOT NULL DEFAULT '0', `prevNodeID` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`prevNodeID`,`nodeID`), KEY `prevVersion` (`prevVersion`) USING BTREE, KEY `version` (`version`) USING BTREE, KEY `nodeID` (`nodeID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; insert into `999999999` values ( 'x', 'y', 'z', 0, 0); select * from `999999999`; version updateJSON prevVersion nodeID prevNodeID x y z 0 0 CREATE TABLE IF NOT EXISTS vvvvvvv_hhhhhhh ( 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='999999999' origid='prevNodeID' destid='nodeID'; select * from vvvvvvv_hhhhhhh; latch origid destid weight seq linkid NULL 0 0 1 NULL NULL drop table if exists `999999999`; drop table if exists vvvvvvv_hhhhhhh; drop database if exists `1`; Performing OQGraph regression test mdev5996 - using db=`1112222233_4444444`, table=`999999999` use test; drop database if exists `1112222233_4444444` ; create database `1112222233_4444444` ; use `1112222233_4444444` ; drop table if exists `999999999` ; drop table if exists vvvvvvv_hhhhhhh; CREATE TABLE `999999999` ( `version` varchar(10) NOT NULL, `updateJSON` mediumtext, `prevVersion` varchar(10) NOT NULL, `nodeID` bigint(20) unsigned NOT NULL DEFAULT '0', `prevNodeID` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`prevNodeID`,`nodeID`), KEY `prevVersion` (`prevVersion`) USING BTREE, KEY `version` (`version`) USING BTREE, KEY `nodeID` (`nodeID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; insert into `999999999` values ( 'x', 'y', 'z', 0, 0); select * from `999999999`; version updateJSON prevVersion nodeID prevNodeID x y z 0 0 CREATE TABLE IF NOT EXISTS vvvvvvv_hhhhhhh ( 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='999999999' origid='prevNodeID' destid='nodeID'; select * from vvvvvvv_hhhhhhh; latch origid destid weight seq linkid NULL 0 0 1 NULL NULL drop table if exists `999999999`; drop table if exists vvvvvvv_hhhhhhh; drop database if exists `1112222233_4444444`; Performing OQGraph regression test mdev5996 - using db=`1112222233_44444444`, table=`999999999` use test; drop database if exists `1112222233_44444444` ; create database `1112222233_44444444` ; use `1112222233_44444444` ; drop table if exists `999999999` ; drop table if exists vvvvvvv_hhhhhhh; CREATE TABLE `999999999` ( `version` varchar(10) NOT NULL, `updateJSON` mediumtext, `prevVersion` varchar(10) NOT NULL, `nodeID` bigint(20) unsigned NOT NULL DEFAULT '0', `prevNodeID` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`prevNodeID`,`nodeID`), KEY `prevVersion` (`prevVersion`) USING BTREE, KEY `version` (`version`) USING BTREE, KEY `nodeID` (`nodeID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; insert into `999999999` values ( 'x', 'y', 'z', 0, 0); select * from `999999999`; version updateJSON prevVersion nodeID prevNodeID x y z 0 0 CREATE TABLE IF NOT EXISTS vvvvvvv_hhhhhhh ( 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='999999999' origid='prevNodeID' destid='nodeID'; select * from vvvvvvv_hhhhhhh; latch origid destid weight seq linkid NULL 0 0 1 NULL NULL drop table if exists `999999999`; drop table if exists vvvvvvv_hhhhhhh; drop database if exists `1112222233_44444444`; Performing OQGraph regression test mdev5996 - using db=`1112222233_444444444`, table=`999999999` use test; drop database if exists `1112222233_444444444` ; create database `1112222233_444444444` ; use `1112222233_444444444` ; drop table if exists `999999999` ; drop table if exists vvvvvvv_hhhhhhh; CREATE TABLE `999999999` ( `version` varchar(10) NOT NULL, `updateJSON` mediumtext, `prevVersion` varchar(10) NOT NULL, `nodeID` bigint(20) unsigned NOT NULL DEFAULT '0', `prevNodeID` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`prevNodeID`,`nodeID`), KEY `prevVersion` (`prevVersion`) USING BTREE, KEY `version` (`version`) USING BTREE, KEY `nodeID` (`nodeID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; insert into `999999999` values ( 'x', 'y', 'z', 0, 0); select * from `999999999`; version updateJSON prevVersion nodeID prevNodeID x y z 0 0 CREATE TABLE IF NOT EXISTS vvvvvvv_hhhhhhh ( 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='999999999' origid='prevNodeID' destid='nodeID'; select * from vvvvvvv_hhhhhhh; latch origid destid weight seq linkid NULL 0 0 1 NULL NULL drop table if exists `999999999`; drop table if exists vvvvvvv_hhhhhhh; drop database if exists `1112222233_444444444`; Performing OQGraph regression test mdev5996 - using db=`1112222233_444444444`, table=`99999999` use test; drop database if exists `1112222233_444444444` ; create database `1112222233_444444444` ; use `1112222233_444444444` ; drop table if exists `99999999` ; drop table if exists vvvvvvv_hhhhhhh; CREATE TABLE `99999999` ( `version` varchar(10) NOT NULL, `updateJSON` mediumtext, `prevVersion` varchar(10) NOT NULL, `nodeID` bigint(20) unsigned NOT NULL DEFAULT '0', `prevNodeID` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`prevNodeID`,`nodeID`), KEY `prevVersion` (`prevVersion`) USING BTREE, KEY `version` (`version`) USING BTREE, KEY `nodeID` (`nodeID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; insert into `99999999` values ( 'x', 'y', 'z', 0, 0); select * from `99999999`; version updateJSON prevVersion nodeID prevNodeID x y z 0 0 CREATE TABLE IF NOT EXISTS vvvvvvv_hhhhhhh ( 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='99999999' origid='prevNodeID' destid='nodeID'; select * from vvvvvvv_hhhhhhh; latch origid destid weight seq linkid NULL 0 0 1 NULL NULL drop table if exists `99999999`; drop table if exists vvvvvvv_hhhhhhh; drop database if exists `1112222233_444444444`; Performing OQGraph regression test mdev5996 - using db=`1112222233_444444444`, table=`9999999999` use test; drop database if exists `1112222233_444444444` ; create database `1112222233_444444444` ; use `1112222233_444444444` ; drop table if exists `9999999999` ; drop table if exists vvvvvvv_hhhhhhh; CREATE TABLE `9999999999` ( `version` varchar(10) NOT NULL, `updateJSON` mediumtext, `prevVersion` varchar(10) NOT NULL, `nodeID` bigint(20) unsigned NOT NULL DEFAULT '0', `prevNodeID` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`prevNodeID`,`nodeID`), KEY `prevVersion` (`prevVersion`) USING BTREE, KEY `version` (`version`) USING BTREE, KEY `nodeID` (`nodeID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; insert into `9999999999` values ( 'x', 'y', 'z', 0, 0); select * from `9999999999`; version updateJSON prevVersion nodeID prevNodeID x y z 0 0 CREATE TABLE IF NOT EXISTS vvvvvvv_hhhhhhh ( 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='9999999999' origid='prevNodeID' destid='nodeID'; select * from vvvvvvv_hhhhhhh; latch origid destid weight seq linkid NULL 0 0 1 NULL NULL drop table if exists `9999999999`; drop table if exists vvvvvvv_hhhhhhh; drop database if exists `1112222233_444444444`;