MDEV-5996 - regression test result

1 files changed, 283 insertions, 0 deletions

diff --git a/storage/oqgraph/mysql-test/oqgraph/regression_mdev5996.result b/storage/oqgraph/mysql-test/oqgraph/regression_mdev5996.result
new file mode 100644
index 00000000000..a639a185ec2
--- /dev/null
+++ b/storage/oqgraph/mysql-test/oqgraph/regression_mdev5996.result
@@ -0,0 +1,283 @@
+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`;