--
-- Host: localhost    Database: test
-- ------------------------------------------------------


--
-- Current Database: `test`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `test`;

--
-- Table structure for table `t1`
--

CREATE TABLE `t1` (
  `f59` int(11) DEFAULT NULL,
  `f60` int(11) DEFAULT NULL,
  `f61` int(11) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1`
--


--
-- Table structure for table `tb2`
--

CREATE TABLE `tb2` (
  `f59` decimal(10,0) unsigned DEFAULT NULL,
  `f60` decimal(64,0) unsigned DEFAULT NULL,
  `f61` decimal(10,0) unsigned zerofill DEFAULT NULL,
  `f62` decimal(64,0) unsigned zerofill DEFAULT NULL,
  `f63` decimal(10,0) unsigned zerofill DEFAULT NULL,
  `f64` decimal(64,0) unsigned zerofill DEFAULT NULL,
  `f65` decimal(10,0) DEFAULT NULL,
  `f66` decimal(63,30) DEFAULT NULL,
  `f67` decimal(10,0) unsigned DEFAULT NULL,
  `f68` decimal(63,30) unsigned DEFAULT NULL,
  `f69` decimal(10,0) unsigned zerofill DEFAULT NULL,
  `f70` decimal(63,30) unsigned zerofill DEFAULT NULL,
  `f71` decimal(10,0) unsigned zerofill DEFAULT NULL,
  `f72` decimal(63,30) unsigned zerofill DEFAULT NULL,
  `f73` double DEFAULT NULL,
  `f74` double unsigned DEFAULT NULL,
  `f75` double unsigned zerofill DEFAULT NULL,
  `f76` double unsigned zerofill DEFAULT NULL,
  `f77` double DEFAULT '7.7',
  `f78` double unsigned DEFAULT '7.7',
  `f79` double unsigned zerofill DEFAULT '00000000000000000007.7',
  `f80` double unsigned zerofill DEFAULT '00000000000000000008.8',
  `f81` float NOT NULL DEFAULT '8.8',
  `f82` float unsigned NOT NULL DEFAULT '8.8',
  `f83` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f84` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f85` float NOT NULL DEFAULT '8.8',
  `f86` float NOT NULL DEFAULT '8.8',
  `f87` float unsigned NOT NULL DEFAULT '8.8',
  `f88` float unsigned NOT NULL DEFAULT '8.8',
  `f89` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f90` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f91` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f92` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f93` float NOT NULL DEFAULT '8.8',
  `f94` double NOT NULL DEFAULT '8.8',
  `f95` float unsigned NOT NULL DEFAULT '8.8',
  `f96` double unsigned NOT NULL DEFAULT '8.8',
  `f97` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f98` double unsigned zerofill NOT NULL DEFAULT '00000000000000000008.8',
  `f99` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f100` double unsigned zerofill NOT NULL DEFAULT '00000000000000000008.8',
  `f101` date NOT NULL DEFAULT '2000-01-01',
  `f102` time NOT NULL DEFAULT '00:00:20',
  `f103` datetime NOT NULL DEFAULT '0002-02-02 00:00:00',
  `f104` timestamp NOT NULL DEFAULT '2000-12-31 20:59:59',
  `f105` year(4) NOT NULL DEFAULT '2000',
  `f106` year(4) NOT NULL DEFAULT '2000',
  `f107` year(4) NOT NULL DEFAULT '2000',
  `f108` enum('1enum','2enum') NOT NULL DEFAULT '1enum',
  `f109` set('1set','2set') NOT NULL DEFAULT '1set'
) ENGINE=MEMORY DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tb2`
--

INSERT INTO `tb2` VALUES (1,1,0000000001,0000000000000000000000000000000000000000000000000000000000000001,0000000001,0000000000000000000000000000000000000000000000000000000000000001,-5,0.000000000000000000000000000000,1,0.000000000000000000000000000000,0000000001,000000000000000000000000000000000.000000000000000000000000000000,0000000001,000000000000000000000000000000000.000000000000000000000000000000,-1.17549435e-38,1.175494352e-38,00000001.175494352e-38,00000001.175494352e-38,-1.17549435e-38,1.175494352e-38,00000001.175494352e-38,00000001.175494352e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549435e-38,1.17549e-38,1.175494352e-38,01.17549e-38,00000001.175494352e-38,01.17549e-38,00000001.175494352e-38,'1000-01-01','838:59:58','1970-01-02 00:00:01','1970-01-01 21:00:01',1902,1902,1902,'2enum','2set'),(2,2,0000000002,0000000000000000000000000000000000000000000000000000000000000002,0000000002,0000000000000000000000000000000000000000000000000000000000000002,-4,1.100000000000000000000000000000,2,1.100000000000000000000000000000,0000000002,000000000000000000000000000000001.100000000000000000000000000000,0000000002,000000000000000000000000000000001.100000000000000000000000000000,-1.175494349e-38,1.175494353e-38,00000001.175494353e-38,00000001.175494353e-38,-1.175494349e-38,1.175494353e-38,00000001.175494353e-38,00000001.175494353e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494349e-38,1.17549e-38,1.175494353e-38,01.17549e-38,00000001.175494353e-38,01.17549e-38,00000001.175494353e-38,'1000-01-02','838:59:57','1970-01-03 00:00:02','1970-01-02 21:00:02',1903,1903,1903,'1enum','1set,2set'),(3,3,0000000003,0000000000000000000000000000000000000000000000000000000000000003,0000000003,0000000000000000000000000000000000000000000000000000000000000003,-3,2.200000000000000000000000000000,3,2.200000000000000000000000000000,0000000003,000000000000000000000000000000002.200000000000000000000000000000,0000000003,000000000000000000000000000000002.200000000000000000000000000000,-1.175494348e-38,1.175494354e-38,00000001.175494354e-38,00000001.175494354e-38,-1.175494348e-38,1.175494354e-38,00000001.175494354e-38,00000001.175494354e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494348e-38,1.17549e-38,1.175494354e-38,01.17549e-38,00000001.175494354e-38,01.17549e-38,00000001.175494354e-38,'1000-01-03','838:59:56','1970-01-04 00:00:03','1970-01-03 21:00:03',1904,1904,1904,'2enum','1set'),(100,4,0000000004,0000000000000000000000000000000000000000000000000000000000000004,0000000004,0000000000000000000000000000000000000000000000000000000000000004,-2,3.300000000000000000000000000000,4,3.300000000000000000000000000000,0000000004,000000000000000000000000000000003.300000000000000000000000000000,0000000004,000000000000000000000000000000003.300000000000000000000000000000,-1.175494347e-38,1.175494355e-38,00000001.175494355e-38,00000001.175494355e-38,-1.175494347e-38,1.175494355e-38,00000001.175494355e-38,00000001.175494355e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494347e-38,1.17549e-38,1.175494355e-38,01.17549e-38,00000001.175494355e-38,01.17549e-38,00000001.175494355e-38,'1000-01-04','838:59:55','1970-01-05 00:00:04','1970-01-04 21:00:04',1905,1905,1905,'1enum','2set'),(5,5,0000000005,0000000000000000000000000000000000000000000000000000000000000005,0000000005,0000000000000000000000000000000000000000000000000000000000000005,-1,4.400000000000000000000000000000,5,4.400000000000000000000000000000,0000000005,000000000000000000000000000000004.400000000000000000000000000000,0000000005,000000000000000000000000000000004.400000000000000000000000000000,-1.175494346e-38,1.175494356e-38,00000001.175494356e-38,00000001.175494356e-38,-1.175494346e-38,1.175494356e-38,00000001.175494356e-38,00000001.175494356e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494346e-38,1.17549e-38,1.175494356e-38,01.17549e-38,00000001.175494356e-38,01.17549e-38,00000001.175494356e-38,'1000-01-05','838:59:54','1970-01-06 00:00:05','1970-01-05 21:00:05',1906,1906,1906,'2enum','1set,2set'),(6,6,0000000006,0000000000000000000000000000000000000000000000000000000000000006,0000000006,0000000000000000000000000000000000000000000000000000000000000006,0,5.500000000000000000000000000000,6,5.500000000000000000000000000000,0000000006,000000000000000000000000000000005.500000000000000000000000000000,0000000006,000000000000000000000000000000005.500000000000000000000000000000,-1.175494345e-38,1.175494357e-38,00000001.175494357e-38,00000001.175494357e-38,-1.175494345e-38,1.175494357e-38,00000001.175494357e-38,00000001.175494357e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494345e-38,1.17549e-38,1.175494357e-38,01.17549e-38,00000001.175494357e-38,01.17549e-38,00000001.175494357e-38,'1000-01-06','838:59:53','1970-01-07 00:00:06','1970-01-06 21:00:06',1907,1907,1907,'1enum','1set'),(7,7,0000000007,0000000000000000000000000000000000000000000000000000000000000007,0000000007,0000000000000000000000000000000000000000000000000000000000000007,1,6.600000000000000000000000000000,7,6.600000000000000000000000000000,0000000007,000000000000000000000000000000006.600000000000000000000000000000,0000000007,000000000000000000000000000000006.600000000000000000000000000000,-1.175494344e-38,1.175494358e-38,00000001.175494358e-38,00000001.175494358e-38,-1.175494344e-38,1.175494358e-38,00000001.175494358e-38,00000001.175494358e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494344e-38,1.17549e-38,1.175494358e-38,01.17549e-38,00000001.175494358e-38,01.17549e-38,00000001.175494358e-38,'1000-01-07','838:59:52','1970-01-08 00:00:07','1970-01-07 21:00:07',1908,1908,1908,'2enum','2set'),(8,8,0000000008,0000000000000000000000000000000000000000000000000000000000000008,0000000008,0000000000000000000000000000000000000000000000000000000000000008,2,7.700000000000000000000000000000,8,7.700000000000000000000000000000,0000000008,000000000000000000000000000000007.700000000000000000000000000000,0000000008,000000000000000000000000000000007.700000000000000000000000000000,-1.175494343e-38,1.175494359e-38,00000001.175494359e-38,00000001.175494359e-38,-1.175494343e-38,1.175494359e-38,00000001.175494359e-38,00000001.175494359e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494343e-38,1.17549e-38,1.175494359e-38,01.17549e-38,00000001.175494359e-38,01.17549e-38,00000001.175494359e-38,'1000-01-08','838:59:51','1970-01-09 00:00:08','1970-01-08 21:00:08',1909,1909,1909,'1enum','1set,2set'),(9,9,0000000009,0000000000000000000000000000000000000000000000000000000000000009,0000000009,0000000000000000000000000000000000000000000000000000000000000009,3,8.800000000000000000000000000000,9,8.800000000000000000000000000000,0000000009,000000000000000000000000000000008.800000000000000000000000000000,0000000009,000000000000000000000000000000008.800000000000000000000000000000,-1.175494342e-38,1.17549436e-38,000000001.17549436e-38,000000001.17549436e-38,-1.175494342e-38,1.17549436e-38,000000001.17549436e-38,000000001.17549436e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494342e-38,1.17549e-38,1.17549436e-38,01.17549e-38,000000001.17549436e-38,01.17549e-38,000000001.17549436e-38,'1000-01-09','838:59:50','1970-01-10 00:00:09','1970-01-09 21:00:09',1910,1910,1910,'2enum','1set'),(10,10,0000000010,0000000000000000000000000000000000000000000000000000000000000010,0000000010,0000000000000000000000000000000000000000000000000000000000000010,4,9.900000000000000000000000000000,10,9.900000000000000000000000000000,0000000010,000000000000000000000000000000009.900000000000000000000000000000,0000000010,000000000000000000000000000000009.900000000000000000000000000000,-1.175494341e-38,1.175494361e-38,00000001.175494361e-38,00000001.175494361e-38,-1.175494341e-38,1.175494361e-38,00000001.175494361e-38,00000001.175494361e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494341e-38,1.17549e-38,1.175494361e-38,01.17549e-38,00000001.175494361e-38,01.17549e-38,00000001.175494361e-38,'1000-01-10','838:59:49','1970-01-11 00:00:10','1970-01-10 21:00:10',1911,1911,1911,'1enum','2set'),(76710,226546,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(2760,985654,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(569300,9114376,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(660,876546,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(250,87895654,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(340,9984376,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(3410,996546,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(2550,775654,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(3330,764376,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(441,16546,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(24,51654,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(323,14376,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(34,41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(100,74,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(15,87,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(22,93,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(394,41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(94,74,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(195,87,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(292,93,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(987,41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(7876,74,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(321,NULL,0000000765,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(9112,NULL,0000008771,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(500,NULL,0000000900,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(500,NULL,0000000900,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(500,NULL,0000000900,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(107,105,0000000106,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(109,108,0000000104,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(207,205,0000000206,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(209,208,0000000204,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(27,25,0000000026,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(29,28,0000000024,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(17,15,0000000016,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(19,18,0000000014,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(107,105,0000000106,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(109,108,0000000104,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(299,899,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(242,79,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set'),(424,89,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,7.7,7.7,00000000000000000007.7,00000000000000000008.8,8.8,8.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,0000000008.8,0000000008.8,0000000008.8,8.8,8.8,8.8,8.8,0000000008.8,00000000000000000008.8,0000000008.8,00000000000000000008.8,'2000-01-01','00:00:20','0002-02-02 00:00:00','2000-12-31 20:59:59',2000,2000,2000,'1enum','1set');

--
-- Current Database: `test1`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test1` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `test1`;

--
-- Table structure for table `t0`
--

CREATE TABLE `t0` (
  `f1` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t0`
--

INSERT INTO `t0` VALUES ('test1.t0');

--
-- Table structure for table `t1`
--

CREATE TABLE `t1` (
  `f1` bigint(20) DEFAULT NULL,
  `f2` char(50) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1`
--

INSERT INTO `t1` VALUES (NULL,'numeric column is NULL'),(0,NULL),(5,'five'),(1,'one'),(2,'two');

--
-- Temporary table structure for view `t2`
--

/*!50001 DROP VIEW IF EXISTS `t2`*/;
/*!50001 CREATE TABLE `t2` (
  `f1` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `t3`
--

/*!50001 DROP VIEW IF EXISTS `t3`*/;
/*!50001 CREATE TABLE `t3` (
  `f1` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Table structure for table `tb2`
--

CREATE TABLE `tb2` (
  `f59` decimal(10,0) unsigned DEFAULT NULL,
  `f60` decimal(64,0) unsigned DEFAULT NULL,
  `f61` decimal(10,0) unsigned zerofill DEFAULT NULL,
  `f62` decimal(64,0) unsigned zerofill DEFAULT NULL,
  `f63` decimal(10,0) unsigned zerofill DEFAULT NULL,
  `f64` decimal(64,0) unsigned zerofill DEFAULT NULL,
  `f65` decimal(10,0) DEFAULT NULL,
  `f66` decimal(63,30) DEFAULT NULL,
  `f67` decimal(10,0) unsigned DEFAULT NULL,
  `f68` decimal(63,30) unsigned DEFAULT NULL,
  `f69` decimal(10,0) unsigned zerofill DEFAULT NULL,
  `f70` decimal(63,30) unsigned zerofill DEFAULT NULL,
  `f71` decimal(10,0) unsigned zerofill DEFAULT NULL,
  `f72` decimal(63,30) unsigned zerofill DEFAULT NULL,
  `f73` double DEFAULT NULL,
  `f74` double unsigned DEFAULT NULL,
  `f75` double unsigned zerofill DEFAULT NULL,
  `f76` double unsigned zerofill DEFAULT NULL,
  `f77` double DEFAULT '7.7',
  `f78` double unsigned DEFAULT '7.7',
  `f79` double unsigned zerofill DEFAULT '00000000000000000007.7',
  `f80` double unsigned zerofill DEFAULT '00000000000000000008.8',
  `f81` float NOT NULL DEFAULT '8.8',
  `f82` float unsigned NOT NULL DEFAULT '8.8',
  `f83` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f84` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f85` float NOT NULL DEFAULT '8.8',
  `f86` float NOT NULL DEFAULT '8.8',
  `f87` float unsigned NOT NULL DEFAULT '8.8',
  `f88` float unsigned NOT NULL DEFAULT '8.8',
  `f89` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f90` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f91` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f92` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f93` float NOT NULL DEFAULT '8.8',
  `f94` double NOT NULL DEFAULT '8.8',
  `f95` float unsigned NOT NULL DEFAULT '8.8',
  `f96` double unsigned NOT NULL DEFAULT '8.8',
  `f97` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f98` double unsigned zerofill NOT NULL DEFAULT '00000000000000000008.8',
  `f99` float unsigned zerofill NOT NULL DEFAULT '0000000008.8',
  `f100` double unsigned zerofill NOT NULL DEFAULT '00000000000000000008.8',
  `f101` date NOT NULL DEFAULT '2000-01-01',
  `f102` time NOT NULL DEFAULT '00:00:20',
  `f103` datetime NOT NULL DEFAULT '0002-02-02 00:00:00',
  `f104` timestamp NOT NULL DEFAULT '2000-12-31 20:59:59',
  `f105` year(4) NOT NULL DEFAULT '2000',
  `f106` year(4) NOT NULL DEFAULT '2000',
  `f107` year(4) NOT NULL DEFAULT '2000',
  `f108` enum('1enum','2enum') NOT NULL DEFAULT '1enum',
  `f109` set('1set','2set') NOT NULL DEFAULT '1set'
) ENGINE=MEMORY DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tb2`
--

INSERT INTO `tb2` VALUES (1,1,0000000001,0000000000000000000000000000000000000000000000000000000000000001,0000000001,0000000000000000000000000000000000000000000000000000000000000001,-5,0.000000000000000000000000000000,1,0.000000000000000000000000000000,0000000001,000000000000000000000000000000000.000000000000000000000000000000,0000000001,000000000000000000000000000000000.000000000000000000000000000000,-1.17549435e-38,1.175494352e-38,00000001.175494352e-38,00000001.175494352e-38,-1.17549435e-38,1.175494352e-38,00000001.175494352e-38,00000001.175494352e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549435e-38,1.17549e-38,1.175494352e-38,01.17549e-38,00000001.175494352e-38,01.17549e-38,00000001.175494352e-38,'1000-01-01','838:59:58','1970-01-02 00:00:01','1970-01-01 21:00:01',1902,1902,1902,'2enum','2set'),(2,2,0000000002,0000000000000000000000000000000000000000000000000000000000000002,0000000002,0000000000000000000000000000000000000000000000000000000000000002,-4,1.100000000000000000000000000000,2,1.100000000000000000000000000000,0000000002,000000000000000000000000000000001.100000000000000000000000000000,0000000002,000000000000000000000000000000001.100000000000000000000000000000,-1.175494349e-38,1.175494353e-38,00000001.175494353e-38,00000001.175494353e-38,-1.175494349e-38,1.175494353e-38,00000001.175494353e-38,00000001.175494353e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494349e-38,1.17549e-38,1.175494353e-38,01.17549e-38,00000001.175494353e-38,01.17549e-38,00000001.175494353e-38,'1000-01-02','838:59:57','1970-01-03 00:00:02','1970-01-02 21:00:02',1903,1903,1903,'1enum','1set,2set'),(3,3,0000000003,0000000000000000000000000000000000000000000000000000000000000003,0000000003,0000000000000000000000000000000000000000000000000000000000000003,-3,2.200000000000000000000000000000,3,2.200000000000000000000000000000,0000000003,000000000000000000000000000000002.200000000000000000000000000000,0000000003,000000000000000000000000000000002.200000000000000000000000000000,-1.175494348e-38,1.175494354e-38,00000001.175494354e-38,00000001.175494354e-38,-1.175494348e-38,1.175494354e-38,00000001.175494354e-38,00000001.175494354e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494348e-38,1.17549e-38,1.175494354e-38,01.17549e-38,00000001.175494354e-38,01.17549e-38,00000001.175494354e-38,'1000-01-03','838:59:56','1970-01-04 00:00:03','1970-01-03 21:00:03',1904,1904,1904,'2enum','1set'),(4,4,0000000004,0000000000000000000000000000000000000000000000000000000000000004,0000000004,0000000000000000000000000000000000000000000000000000000000000004,-2,3.300000000000000000000000000000,4,3.300000000000000000000000000000,0000000004,000000000000000000000000000000003.300000000000000000000000000000,0000000004,000000000000000000000000000000003.300000000000000000000000000000,-1.175494347e-38,1.175494355e-38,00000001.175494355e-38,00000001.175494355e-38,-1.175494347e-38,1.175494355e-38,00000001.175494355e-38,00000001.175494355e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494347e-38,1.17549e-38,1.175494355e-38,01.17549e-38,00000001.175494355e-38,01.17549e-38,00000001.175494355e-38,'1000-01-04','838:59:55','1970-01-05 00:00:04','1970-01-04 21:00:04',1905,1905,1905,'1enum','2set'),(5,5,0000000005,0000000000000000000000000000000000000000000000000000000000000005,0000000005,0000000000000000000000000000000000000000000000000000000000000005,-1,4.400000000000000000000000000000,5,4.400000000000000000000000000000,0000000005,000000000000000000000000000000004.400000000000000000000000000000,0000000005,000000000000000000000000000000004.400000000000000000000000000000,-1.175494346e-38,1.175494356e-38,00000001.175494356e-38,00000001.175494356e-38,-1.175494346e-38,1.175494356e-38,00000001.175494356e-38,00000001.175494356e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494346e-38,1.17549e-38,1.175494356e-38,01.17549e-38,00000001.175494356e-38,01.17549e-38,00000001.175494356e-38,'1000-01-05','838:59:54','1970-01-06 00:00:05','1970-01-05 21:00:05',1906,1906,1906,'2enum','1set,2set'),(6,6,0000000006,0000000000000000000000000000000000000000000000000000000000000006,0000000006,0000000000000000000000000000000000000000000000000000000000000006,0,5.500000000000000000000000000000,6,5.500000000000000000000000000000,0000000006,000000000000000000000000000000005.500000000000000000000000000000,0000000006,000000000000000000000000000000005.500000000000000000000000000000,-1.175494345e-38,1.175494357e-38,00000001.175494357e-38,00000001.175494357e-38,-1.175494345e-38,1.175494357e-38,00000001.175494357e-38,00000001.175494357e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494345e-38,1.17549e-38,1.175494357e-38,01.17549e-38,00000001.175494357e-38,01.17549e-38,00000001.175494357e-38,'1000-01-06','838:59:53','1970-01-07 00:00:06','1970-01-06 21:00:06',1907,1907,1907,'1enum','1set'),(7,7,0000000007,0000000000000000000000000000000000000000000000000000000000000007,0000000007,0000000000000000000000000000000000000000000000000000000000000007,1,6.600000000000000000000000000000,7,6.600000000000000000000000000000,0000000007,000000000000000000000000000000006.600000000000000000000000000000,0000000007,000000000000000000000000000000006.600000000000000000000000000000,-1.175494344e-38,1.175494358e-38,00000001.175494358e-38,00000001.175494358e-38,-1.175494344e-38,1.175494358e-38,00000001.175494358e-38,00000001.175494358e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494344e-38,1.17549e-38,1.175494358e-38,01.17549e-38,00000001.175494358e-38,01.17549e-38,00000001.175494358e-38,'1000-01-07','838:59:52','1970-01-08 00:00:07','1970-01-07 21:00:07',1908,1908,1908,'2enum','2set'),(8,8,0000000008,0000000000000000000000000000000000000000000000000000000000000008,0000000008,0000000000000000000000000000000000000000000000000000000000000008,2,7.700000000000000000000000000000,8,7.700000000000000000000000000000,0000000008,000000000000000000000000000000007.700000000000000000000000000000,0000000008,000000000000000000000000000000007.700000000000000000000000000000,-1.175494343e-38,1.175494359e-38,00000001.175494359e-38,00000001.175494359e-38,-1.175494343e-38,1.175494359e-38,00000001.175494359e-38,00000001.175494359e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494343e-38,1.17549e-38,1.175494359e-38,01.17549e-38,00000001.175494359e-38,01.17549e-38,00000001.175494359e-38,'1000-01-08','838:59:51','1970-01-09 00:00:08','1970-01-08 21:00:08',1909,1909,1909,'1enum','1set,2set'),(9,9,0000000009,0000000000000000000000000000000000000000000000000000000000000009,0000000009,0000000000000000000000000000000000000000000000000000000000000009,3,8.800000000000000000000000000000,9,8.800000000000000000000000000000,0000000009,000000000000000000000000000000008.800000000000000000000000000000,0000000009,000000000000000000000000000000008.800000000000000000000000000000,-1.175494342e-38,1.17549436e-38,000000001.17549436e-38,000000001.17549436e-38,-1.175494342e-38,1.17549436e-38,000000001.17549436e-38,000000001.17549436e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494342e-38,1.17549e-38,1.17549436e-38,01.17549e-38,000000001.17549436e-38,01.17549e-38,000000001.17549436e-38,'1000-01-09','838:59:50','1970-01-10 00:00:09','1970-01-09 21:00:09',1910,1910,1910,'2enum','1set'),(10,10,0000000010,0000000000000000000000000000000000000000000000000000000000000010,0000000010,0000000000000000000000000000000000000000000000000000000000000010,4,9.900000000000000000000000000000,10,9.900000000000000000000000000000,0000000010,000000000000000000000000000000009.900000000000000000000000000000,0000000010,000000000000000000000000000000009.900000000000000000000000000000,-1.175494341e-38,1.175494361e-38,00000001.175494361e-38,00000001.175494361e-38,-1.175494341e-38,1.175494361e-38,00000001.175494361e-38,00000001.175494361e-38,-1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.17549e-38,1.17549e-38,1.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,01.17549e-38,-1.17549e-38,-1.175494341e-38,1.17549e-38,1.175494361e-38,01.17549e-38,00000001.175494361e-38,01.17549e-38,00000001.175494361e-38,'1000-01-10','838:59:49','1970-01-11 00:00:10','1970-01-10 21:00:10',1911,1911,1911,'1enum','2set');

--
-- Temporary table structure for view `v0`
--

/*!50001 DROP VIEW IF EXISTS `v0`*/;
/*!50001 CREATE TABLE `v0` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v1`
--

/*!50001 DROP VIEW IF EXISTS `v1`*/;
/*!50001 CREATE TABLE `v1` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v10`
--

/*!50001 DROP VIEW IF EXISTS `v10`*/;
/*!50001 CREATE TABLE `v10` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v11`
--

/*!50001 DROP VIEW IF EXISTS `v11`*/;
/*!50001 CREATE TABLE `v11` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v12`
--

/*!50001 DROP VIEW IF EXISTS `v12`*/;
/*!50001 CREATE TABLE `v12` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v13`
--

/*!50001 DROP VIEW IF EXISTS `v13`*/;
/*!50001 CREATE TABLE `v13` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v14`
--

/*!50001 DROP VIEW IF EXISTS `v14`*/;
/*!50001 CREATE TABLE `v14` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v15`
--

/*!50001 DROP VIEW IF EXISTS `v15`*/;
/*!50001 CREATE TABLE `v15` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v16`
--

/*!50001 DROP VIEW IF EXISTS `v16`*/;
/*!50001 CREATE TABLE `v16` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v17`
--

/*!50001 DROP VIEW IF EXISTS `v17`*/;
/*!50001 CREATE TABLE `v17` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v18`
--

/*!50001 DROP VIEW IF EXISTS `v18`*/;
/*!50001 CREATE TABLE `v18` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v19`
--

/*!50001 DROP VIEW IF EXISTS `v19`*/;
/*!50001 CREATE TABLE `v19` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v2`
--

/*!50001 DROP VIEW IF EXISTS `v2`*/;
/*!50001 CREATE TABLE `v2` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v20`
--

/*!50001 DROP VIEW IF EXISTS `v20`*/;
/*!50001 CREATE TABLE `v20` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v21`
--

/*!50001 DROP VIEW IF EXISTS `v21`*/;
/*!50001 CREATE TABLE `v21` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v22`
--

/*!50001 DROP VIEW IF EXISTS `v22`*/;
/*!50001 CREATE TABLE `v22` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v23`
--

/*!50001 DROP VIEW IF EXISTS `v23`*/;
/*!50001 CREATE TABLE `v23` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v24`
--

/*!50001 DROP VIEW IF EXISTS `v24`*/;
/*!50001 CREATE TABLE `v24` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v25`
--

/*!50001 DROP VIEW IF EXISTS `v25`*/;
/*!50001 CREATE TABLE `v25` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v26`
--

/*!50001 DROP VIEW IF EXISTS `v26`*/;
/*!50001 CREATE TABLE `v26` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v27`
--

/*!50001 DROP VIEW IF EXISTS `v27`*/;
/*!50001 CREATE TABLE `v27` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v3`
--

/*!50001 DROP VIEW IF EXISTS `v3`*/;
/*!50001 CREATE TABLE `v3` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v4`
--

/*!50001 DROP VIEW IF EXISTS `v4`*/;
/*!50001 CREATE TABLE `v4` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v5`
--

/*!50001 DROP VIEW IF EXISTS `v5`*/;
/*!50001 CREATE TABLE `v5` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v6`
--

/*!50001 DROP VIEW IF EXISTS `v6`*/;
/*!50001 CREATE TABLE `v6` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v7`
--

/*!50001 DROP VIEW IF EXISTS `v7`*/;
/*!50001 CREATE TABLE `v7` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v8`
--

/*!50001 DROP VIEW IF EXISTS `v8`*/;
/*!50001 CREATE TABLE `v8` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `v9`
--

/*!50001 DROP VIEW IF EXISTS `v9`*/;
/*!50001 CREATE TABLE `v9` (
  `f1` tinyint NOT NULL,
  `f2` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Current Database: `test2`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test2` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `test2`;

--
-- Table structure for table `t0`
--

CREATE TABLE `t0` (
  `f1` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t0`
--

INSERT INTO `t0` VALUES ('test2.t0');

--
-- Table structure for table `t1`
--

CREATE TABLE `t1` (
  `f1` decimal(64,30) DEFAULT NULL,
  `f2` varchar(50) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1`
--

INSERT INTO `t1` VALUES (NULL,'numeric column is NULL'),(0.000000000000000000000000000000,NULL),(5.000000000000000000000000000000,'five'),(1.000000000000000000000000000000,'one'),(3.000000000000000000000000000000,'three');

--
-- Temporary table structure for view `t2`
--

/*!50001 DROP VIEW IF EXISTS `t2`*/;
/*!50001 CREATE TABLE `t2` (
  `f1` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `t3`
--

/*!50001 DROP VIEW IF EXISTS `t3`*/;
/*!50001 CREATE TABLE `t3` (
  `f1` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Current Database: `test3`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test3` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `test3`;

--
-- Table structure for table `t1`
--

CREATE TABLE `t1` (
  `f1` double DEFAULT NULL,
  `f2` varbinary(50) DEFAULT NULL
) ENGINE=MEMORY DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t1`
--

INSERT INTO `t1` VALUES (NULL,'numeric column is NULL'),(0,NULL),(5,'five'),(2,'two'),(3,'three');

--
-- Current Database: `test`
--

USE `test`;

--
-- Current Database: `test1`
--

USE `test1`;

--
-- Final view structure for view `t2`
--

/*!50001 DROP TABLE IF EXISTS `t2`*/;
/*!50001 DROP VIEW IF EXISTS `t2`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `t2` AS select `t0`.`f1` AS `f1` from `t0` */;

--
-- Final view structure for view `t3`
--

/*!50001 DROP TABLE IF EXISTS `t3`*/;
/*!50001 DROP VIEW IF EXISTS `t3`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `t3` AS select `test2`.`t0`.`f1` AS `f1` from `test2`.`t0` */;

--
-- Final view structure for view `v0`
--

/*!50001 DROP TABLE IF EXISTS `v0`*/;
/*!50001 DROP VIEW IF EXISTS `v0`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v0` AS select `test2`.`t1`.`f1` AS `f1`,`test2`.`t1`.`f2` AS `f2` from `test2`.`t1` */;

--
-- Final view structure for view `v1`
--

/*!50001 DROP TABLE IF EXISTS `v1`*/;
/*!50001 DROP VIEW IF EXISTS `v1`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v1` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test2`.`t1` `tab1` join `test1`.`v0` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v10`
--

/*!50001 DROP TABLE IF EXISTS `v10`*/;
/*!50001 DROP VIEW IF EXISTS `v10`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v10` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test2`.`t1` `tab1` join `test1`.`v9` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v11`
--

/*!50001 DROP TABLE IF EXISTS `v11`*/;
/*!50001 DROP VIEW IF EXISTS `v11`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v11` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test3`.`t1` `tab1` join `test1`.`v10` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v12`
--

/*!50001 DROP TABLE IF EXISTS `v12`*/;
/*!50001 DROP VIEW IF EXISTS `v12`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v12` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test1`.`t1` `tab1` join `test1`.`v11` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v13`
--

/*!50001 DROP TABLE IF EXISTS `v13`*/;
/*!50001 DROP VIEW IF EXISTS `v13`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v13` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test2`.`t1` `tab1` join `test1`.`v12` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v14`
--

/*!50001 DROP TABLE IF EXISTS `v14`*/;
/*!50001 DROP VIEW IF EXISTS `v14`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v14` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test3`.`t1` `tab1` join `test1`.`v13` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v15`
--

/*!50001 DROP TABLE IF EXISTS `v15`*/;
/*!50001 DROP VIEW IF EXISTS `v15`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v15` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test1`.`t1` `tab1` join `test1`.`v14` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v16`
--

/*!50001 DROP TABLE IF EXISTS `v16`*/;
/*!50001 DROP VIEW IF EXISTS `v16`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v16` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test2`.`t1` `tab1` join `test1`.`v15` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v17`
--

/*!50001 DROP TABLE IF EXISTS `v17`*/;
/*!50001 DROP VIEW IF EXISTS `v17`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v17` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test3`.`t1` `tab1` join `test1`.`v16` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v18`
--

/*!50001 DROP TABLE IF EXISTS `v18`*/;
/*!50001 DROP VIEW IF EXISTS `v18`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v18` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test1`.`t1` `tab1` join `test1`.`v17` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v19`
--

/*!50001 DROP TABLE IF EXISTS `v19`*/;
/*!50001 DROP VIEW IF EXISTS `v19`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v19` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test2`.`t1` `tab1` join `test1`.`v18` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v2`
--

/*!50001 DROP TABLE IF EXISTS `v2`*/;
/*!50001 DROP VIEW IF EXISTS `v2`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v2` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test3`.`t1` `tab1` join `test1`.`v1` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v20`
--

/*!50001 DROP TABLE IF EXISTS `v20`*/;
/*!50001 DROP VIEW IF EXISTS `v20`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v20` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test3`.`t1` `tab1` join `test1`.`v19` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v21`
--

/*!50001 DROP TABLE IF EXISTS `v21`*/;
/*!50001 DROP VIEW IF EXISTS `v21`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v21` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test1`.`t1` `tab1` join `test1`.`v20` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v22`
--

/*!50001 DROP TABLE IF EXISTS `v22`*/;
/*!50001 DROP VIEW IF EXISTS `v22`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v22` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test2`.`t1` `tab1` join `test1`.`v21` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v23`
--

/*!50001 DROP TABLE IF EXISTS `v23`*/;
/*!50001 DROP VIEW IF EXISTS `v23`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v23` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test3`.`t1` `tab1` join `test1`.`v22` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v24`
--

/*!50001 DROP TABLE IF EXISTS `v24`*/;
/*!50001 DROP VIEW IF EXISTS `v24`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v24` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test1`.`t1` `tab1` join `test1`.`v23` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v25`
--

/*!50001 DROP TABLE IF EXISTS `v25`*/;
/*!50001 DROP VIEW IF EXISTS `v25`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v25` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test2`.`t1` `tab1` join `test1`.`v24` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v26`
--

/*!50001 DROP TABLE IF EXISTS `v26`*/;
/*!50001 DROP VIEW IF EXISTS `v26`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v26` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test3`.`t1` `tab1` join `test1`.`v25` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v27`
--

/*!50001 DROP TABLE IF EXISTS `v27`*/;
/*!50001 DROP VIEW IF EXISTS `v27`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v27` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test1`.`t1` `tab1` join `test1`.`v26` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v3`
--

/*!50001 DROP TABLE IF EXISTS `v3`*/;
/*!50001 DROP VIEW IF EXISTS `v3`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v3` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test1`.`t1` `tab1` join `test1`.`v2` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v4`
--

/*!50001 DROP TABLE IF EXISTS `v4`*/;
/*!50001 DROP VIEW IF EXISTS `v4`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v4` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test2`.`t1` `tab1` join `test1`.`v3` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v5`
--

/*!50001 DROP TABLE IF EXISTS `v5`*/;
/*!50001 DROP VIEW IF EXISTS `v5`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v5` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test3`.`t1` `tab1` join `test1`.`v4` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v6`
--

/*!50001 DROP TABLE IF EXISTS `v6`*/;
/*!50001 DROP VIEW IF EXISTS `v6`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v6` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test1`.`t1` `tab1` join `test1`.`v5` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v7`
--

/*!50001 DROP TABLE IF EXISTS `v7`*/;
/*!50001 DROP VIEW IF EXISTS `v7`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v7` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test2`.`t1` `tab1` join `test1`.`v6` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v8`
--

/*!50001 DROP TABLE IF EXISTS `v8`*/;
/*!50001 DROP VIEW IF EXISTS `v8`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v8` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test3`.`t1` `tab1` join `test1`.`v7` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Final view structure for view `v9`
--

/*!50001 DROP TABLE IF EXISTS `v9`*/;
/*!50001 DROP VIEW IF EXISTS `v9`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v9` AS select `tab1`.`f1` AS `f1`,`tab1`.`f2` AS `f2` from (`test1`.`t1` `tab1` join `test1`.`v8` `tab2` on(((`tab1`.`f1` = `tab2`.`f1`) and (`tab1`.`f2` = `tab2`.`f2`)))) */;

--
-- Current Database: `test2`
--

USE `test2`;

--
-- Final view structure for view `t2`
--

/*!50001 DROP TABLE IF EXISTS `t2`*/;
/*!50001 DROP VIEW IF EXISTS `t2`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `t2` AS select `t0`.`f1` AS `f1` from `t0` */;

--
-- Final view structure for view `t3`
--

/*!50001 DROP TABLE IF EXISTS `t3`*/;
/*!50001 DROP VIEW IF EXISTS `t3`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `t3` AS select `test1`.`t0`.`f1` AS `f1` from `test1`.`t0` */;

--
-- Current Database: `test3`
--

USE `test3`;


