-- MySQL dump 10.14 Distrib 10.0.3-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: test -- ------------------------------------------------------ -- Server version 10.0.15-MariaDB-debug-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `test` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `test`; -- -- Table structure for table `t1` -- DROP TABLE IF EXISTS `t1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t1` ( `f59` int(11) DEFAULT NULL, `f60` int(11) DEFAULT NULL, `f61` int(11) DEFAULT NULL ) ENGINE=MEMORY DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t1` -- LOCK TABLES `t1` WRITE; /*!40000 ALTER TABLE `t1` DISABLE KEYS */; /*!40000 ALTER TABLE `t1` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tb2` -- DROP TABLE IF EXISTS `tb2`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tb2` -- LOCK TABLES `tb2` WRITE; /*!40000 ALTER TABLE `tb2` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `tb2` ENABLE KEYS */; UNLOCK TABLES; -- -- Current Database: `test1` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test1` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `test1`; -- -- Table structure for table `t0` -- DROP TABLE IF EXISTS `t0`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0` ( `f1` varchar(20) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t0` -- LOCK TABLES `t0` WRITE; /*!40000 ALTER TABLE `t0` DISABLE KEYS */; INSERT INTO `t0` VALUES ('test1.t0'); /*!40000 ALTER TABLE `t0` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `t1` -- DROP TABLE IF EXISTS `t1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t1` ( `f1` bigint(20) DEFAULT NULL, `f2` char(50) DEFAULT NULL ) ENGINE=MEMORY DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t1` -- LOCK TABLES `t1` WRITE; /*!40000 ALTER TABLE `t1` DISABLE KEYS */; INSERT INTO `t1` VALUES (NULL,'numeric column is NULL'),(0,NULL),(5,'five'),(1,'one'),(2,'two'); /*!40000 ALTER TABLE `t1` ENABLE KEYS */; UNLOCK TABLES; -- -- Temporary table structure for view `t2` -- DROP TABLE IF EXISTS `t2`; /*!50001 DROP VIEW IF EXISTS `t2`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `t2` ( `f1` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `t3` -- DROP TABLE IF EXISTS `t3`; /*!50001 DROP VIEW IF EXISTS `t3`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `t3` ( `f1` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Table structure for table `tb2` -- DROP TABLE IF EXISTS `tb2`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tb2` -- LOCK TABLES `tb2` WRITE; /*!40000 ALTER TABLE `tb2` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `tb2` ENABLE KEYS */; UNLOCK TABLES; -- -- Temporary table structure for view `v0` -- DROP TABLE IF EXISTS `v0`; /*!50001 DROP VIEW IF EXISTS `v0`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v0` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v1` -- DROP TABLE IF EXISTS `v1`; /*!50001 DROP VIEW IF EXISTS `v1`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v1` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v10` -- DROP TABLE IF EXISTS `v10`; /*!50001 DROP VIEW IF EXISTS `v10`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v10` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v11` -- DROP TABLE IF EXISTS `v11`; /*!50001 DROP VIEW IF EXISTS `v11`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v11` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v12` -- DROP TABLE IF EXISTS `v12`; /*!50001 DROP VIEW IF EXISTS `v12`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v12` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v13` -- DROP TABLE IF EXISTS `v13`; /*!50001 DROP VIEW IF EXISTS `v13`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v13` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v14` -- DROP TABLE IF EXISTS `v14`; /*!50001 DROP VIEW IF EXISTS `v14`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v14` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v15` -- DROP TABLE IF EXISTS `v15`; /*!50001 DROP VIEW IF EXISTS `v15`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v15` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v16` -- DROP TABLE IF EXISTS `v16`; /*!50001 DROP VIEW IF EXISTS `v16`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v16` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v17` -- DROP TABLE IF EXISTS `v17`; /*!50001 DROP VIEW IF EXISTS `v17`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v17` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v18` -- DROP TABLE IF EXISTS `v18`; /*!50001 DROP VIEW IF EXISTS `v18`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v18` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v19` -- DROP TABLE IF EXISTS `v19`; /*!50001 DROP VIEW IF EXISTS `v19`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v19` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v2` -- DROP TABLE IF EXISTS `v2`; /*!50001 DROP VIEW IF EXISTS `v2`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v2` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v20` -- DROP TABLE IF EXISTS `v20`; /*!50001 DROP VIEW IF EXISTS `v20`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v20` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v21` -- DROP TABLE IF EXISTS `v21`; /*!50001 DROP VIEW IF EXISTS `v21`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v21` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v22` -- DROP TABLE IF EXISTS `v22`; /*!50001 DROP VIEW IF EXISTS `v22`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v22` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v23` -- DROP TABLE IF EXISTS `v23`; /*!50001 DROP VIEW IF EXISTS `v23`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v23` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v24` -- DROP TABLE IF EXISTS `v24`; /*!50001 DROP VIEW IF EXISTS `v24`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v24` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v25` -- DROP TABLE IF EXISTS `v25`; /*!50001 DROP VIEW IF EXISTS `v25`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v25` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v26` -- DROP TABLE IF EXISTS `v26`; /*!50001 DROP VIEW IF EXISTS `v26`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v26` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v27` -- DROP TABLE IF EXISTS `v27`; /*!50001 DROP VIEW IF EXISTS `v27`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v27` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v3` -- DROP TABLE IF EXISTS `v3`; /*!50001 DROP VIEW IF EXISTS `v3`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v3` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v4` -- DROP TABLE IF EXISTS `v4`; /*!50001 DROP VIEW IF EXISTS `v4`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v4` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v5` -- DROP TABLE IF EXISTS `v5`; /*!50001 DROP VIEW IF EXISTS `v5`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v5` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v6` -- DROP TABLE IF EXISTS `v6`; /*!50001 DROP VIEW IF EXISTS `v6`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v6` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v7` -- DROP TABLE IF EXISTS `v7`; /*!50001 DROP VIEW IF EXISTS `v7`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v7` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v8` -- DROP TABLE IF EXISTS `v8`; /*!50001 DROP VIEW IF EXISTS `v8`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v8` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v9` -- DROP TABLE IF EXISTS `v9`; /*!50001 DROP VIEW IF EXISTS `v9`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `v9` ( `f1` tinyint NOT NULL, `f2` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Current Database: `test2` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test2` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `test2`; -- -- Table structure for table `t0` -- DROP TABLE IF EXISTS `t0`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t0` ( `f1` varchar(20) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t0` -- LOCK TABLES `t0` WRITE; /*!40000 ALTER TABLE `t0` DISABLE KEYS */; INSERT INTO `t0` VALUES ('test2.t0'); /*!40000 ALTER TABLE `t0` ENABLE KEYS */; UNLOCK TABLES; create table t0_for_t2 like t0; insert into t0_for_t2 select * from t0; create table t0_for_t3 like t0; insert into t0_for_t3 select * from t0; -- -- Table structure for table `t1` -- DROP TABLE IF EXISTS `t1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t1` ( `f1` decimal(64,30) DEFAULT NULL, `f2` varchar(50) DEFAULT NULL ) ENGINE=MEMORY DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t1` -- LOCK TABLES `t1` WRITE; /*!40000 ALTER TABLE `t1` DISABLE KEYS */; INSERT INTO `t1` VALUES (NULL,'numeric column is NULL'),(0.000000000000000000000000000000,NULL),(5.000000000000000000000000000000,'five'),(1.000000000000000000000000000000,'one'),(3.000000000000000000000000000000,'three'); /*!40000 ALTER TABLE `t1` ENABLE KEYS */; UNLOCK TABLES; -- -- Temporary table structure for view `t2` -- DROP TABLE IF EXISTS `t2`; /*!50001 DROP VIEW IF EXISTS `t2`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `t2` ( `f1` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `t3` -- DROP TABLE IF EXISTS `t3`; /*!50001 DROP VIEW IF EXISTS `t3`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8; /*!50001 CREATE TABLE `t3` ( `f1` tinyint NOT NULL ) ENGINE=MyISAM */; SET character_set_client = @saved_cs_client; -- -- Current Database: `test3` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `test3` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `test3`; -- -- Table structure for table `t1` -- DROP TABLE IF EXISTS `t1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `t1` ( `f1` double DEFAULT NULL, `f2` varbinary(50) DEFAULT NULL ) ENGINE=MEMORY DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t1` -- LOCK TABLES `t1` WRITE; /*!40000 ALTER TABLE `t1` DISABLE KEYS */; INSERT INTO `t1` VALUES (NULL,'numeric column is NULL'),(0,NULL),(5,'five'),(2,'two'),(3,'three'); /*!40000 ALTER TABLE `t1` ENABLE KEYS */; UNLOCK TABLES; -- -- Current Database: `test` -- USE `test`; -- -- Current Database: `test1` -- USE `test1`; drop table if exists t0_for_t2; drop table if exists t0_for_t3; create table t0_for_t2 like t0; insert into t0_for_t2 select * from t0; create table t0_for_t3 like t0; insert into t0_for_t3 select * from t0; create table t1_for_v10 like t1; insert into t1_for_v10 select * from t1; create table t1_for_v11 like t1; insert into t1_for_v11 select * from t1; create table t1_for_v12 like t1; insert into t1_for_v12 select * from t1; create table t1_for_v13 like t1; insert into t1_for_v13 select * from t1; create table t1_for_v14 like t1; insert into t1_for_v14 select * from t1; create table t1_for_v15 like t1; insert into t1_for_v15 select * from t1; create table t1_for_v16 like t1; insert into t1_for_v16 select * from t1; create table t1_for_v17 like t1; insert into t1_for_v17 select * from t1; create table t1_for_v18 like t1; insert into t1_for_v18 select * from t1; create table t1_for_v19 like t1; insert into t1_for_v19 select * from t1; create table t1_for_v20 like t1; insert into t1_for_v20 select * from t1; create table t1_for_v21 like t1; insert into t1_for_v21 select * from t1; create table t1_for_v22 like t1; insert into t1_for_v22 select * from t1; create table t1_for_v23 like t1; insert into t1_for_v23 select * from t1; create table t1_for_v24 like t1; insert into t1_for_v24 select * from t1; create table t1_for_v25 like t1; insert into t1_for_v25 select * from t1; create table t1_for_v26 like t1; insert into t1_for_v26 select * from t1; create table t1_for_v27 like t1; insert into t1_for_v27 select * from t1; create table t1_for_v0 like t1; insert into t1_for_v0 select * from t1; create table t1_for_v1 like t1; insert into t1_for_v1 select * from t1; create table t1_for_v2 like t1; insert into t1_for_v2 select * from t1; create table t1_for_v3 like t1; insert into t1_for_v3 select * from t1; create table t1_for_v4 like t1; insert into t1_for_v4 select * from t1; create table t1_for_v5 like t1; insert into t1_for_v5 select * from t1; create table t1_for_v6 like t1; insert into t1_for_v6 select * from t1; create table t1_for_v7 like t1; insert into t1_for_v7 select * from t1; create table t1_for_v8 like t1; insert into t1_for_v8 select * from t1; create table t1_for_v9 like t1; insert into t1_for_v9 select * from t1; USE `test2`; drop table if exists t0_for_t2; drop table if exists t0_for_t3; create table t0_for_t2 like t0; insert into t0_for_t2 select * from t0; create table t0_for_t3 like t0; insert into t0_for_t3 select * from t0; create table t1_for_v10 like t1; insert into t1_for_v10 select * from t1; create table t1_for_v11 like t1; insert into t1_for_v11 select * from t1; create table t1_for_v12 like t1; insert into t1_for_v12 select * from t1; create table t1_for_v13 like t1; insert into t1_for_v13 select * from t1; create table t1_for_v14 like t1; insert into t1_for_v14 select * from t1; create table t1_for_v15 like t1; insert into t1_for_v15 select * from t1; create table t1_for_v16 like t1; insert into t1_for_v16 select * from t1; create table t1_for_v17 like t1; insert into t1_for_v17 select * from t1; create table t1_for_v18 like t1; insert into t1_for_v18 select * from t1; create table t1_for_v19 like t1; insert into t1_for_v19 select * from t1; create table t1_for_v20 like t1; insert into t1_for_v20 select * from t1; create table t1_for_v21 like t1; insert into t1_for_v21 select * from t1; create table t1_for_v22 like t1; insert into t1_for_v22 select * from t1; create table t1_for_v23 like t1; insert into t1_for_v23 select * from t1; create table t1_for_v24 like t1; insert into t1_for_v24 select * from t1; create table t1_for_v25 like t1; insert into t1_for_v25 select * from t1; create table t1_for_v26 like t1; insert into t1_for_v26 select * from t1; create table t1_for_v27 like t1; insert into t1_for_v27 select * from t1; create table t1_for_v0 like t1; insert into t1_for_v0 select * from t1; create table t1_for_v1 like t1; insert into t1_for_v1 select * from t1; create table t1_for_v2 like t1; insert into t1_for_v2 select * from t1; create table t1_for_v3 like t1; insert into t1_for_v3 select * from t1; create table t1_for_v4 like t1; insert into t1_for_v4 select * from t1; create table t1_for_v5 like t1; insert into t1_for_v5 select * from t1; create table t1_for_v6 like t1; insert into t1_for_v6 select * from t1; create table t1_for_v7 like t1; insert into t1_for_v7 select * from t1; create table t1_for_v8 like t1; insert into t1_for_v8 select * from t1; create table t1_for_v9 like t1; insert into t1_for_v9 select * from t1; USE `test3`; drop table if exists t0_for_t2; drop table if exists t0_for_t3; create table t0_for_t2 like t0; insert into t0_for_t2 select * from t0; create table t0_for_t3 like t0; insert into t0_for_t3 select * from t0; create table t1_for_v10 like t1; insert into t1_for_v10 select * from t1; create table t1_for_v11 like t1; insert into t1_for_v11 select * from t1; create table t1_for_v12 like t1; insert into t1_for_v12 select * from t1; create table t1_for_v13 like t1; insert into t1_for_v13 select * from t1; create table t1_for_v14 like t1; insert into t1_for_v14 select * from t1; create table t1_for_v15 like t1; insert into t1_for_v15 select * from t1; create table t1_for_v16 like t1; insert into t1_for_v16 select * from t1; create table t1_for_v17 like t1; insert into t1_for_v17 select * from t1; create table t1_for_v18 like t1; insert into t1_for_v18 select * from t1; create table t1_for_v19 like t1; insert into t1_for_v19 select * from t1; create table t1_for_v20 like t1; insert into t1_for_v20 select * from t1; create table t1_for_v21 like t1; insert into t1_for_v21 select * from t1; create table t1_for_v22 like t1; insert into t1_for_v22 select * from t1; create table t1_for_v23 like t1; insert into t1_for_v23 select * from t1; create table t1_for_v24 like t1; insert into t1_for_v24 select * from t1; create table t1_for_v25 like t1; insert into t1_for_v25 select * from t1; create table t1_for_v26 like t1; insert into t1_for_v26 select * from t1; create table t1_for_v27 like t1; insert into t1_for_v27 select * from t1; create table t1_for_v0 like t1; insert into t1_for_v0 select * from t1; create table t1_for_v1 like t1; insert into t1_for_v1 select * from t1; create table t1_for_v2 like t1; insert into t1_for_v2 select * from t1; create table t1_for_v3 like t1; insert into t1_for_v3 select * from t1; create table t1_for_v4 like t1; insert into t1_for_v4 select * from t1; create table t1_for_v5 like t1; insert into t1_for_v5 select * from t1; create table t1_for_v6 like t1; insert into t1_for_v6 select * from t1; create table t1_for_v7 like t1; insert into t1_for_v7 select * from t1; create table t1_for_v8 like t1; insert into t1_for_v8 select * from t1; create table t1_for_v9 like t1; insert into t1_for_v9 select * from t1; USE `test1`; -- -- Final view structure for view `t2` -- /*!50001 DROP TABLE IF EXISTS `t2`*/; /*!50001 DROP VIEW IF EXISTS `t2`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `t2` AS select `t0_for_t2`.`f1` AS `f1` from `t0_for_t2` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `t3` -- /*!50001 DROP TABLE IF EXISTS `t3`*/; /*!50001 DROP VIEW IF EXISTS `t3`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `t3` AS select `test2`.`t0_for_t3`.`f1` AS `f1` from `test2`.`t0_for_t3` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v0` -- /*!50001 DROP TABLE IF EXISTS `v0`*/; /*!50001 DROP VIEW IF EXISTS `v0`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v0` AS select `test2`.`t1_for_v0`.`f1` AS `f1`,`test2`.`t1_for_v0`.`f2` AS `f2` from `test2`.`t1_for_v0` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v1` -- /*!50001 DROP TABLE IF EXISTS `v1`*/; /*!50001 DROP VIEW IF EXISTS `v1`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v1` AS select `tab1_v1`.`f1` AS `f1`,`tab1_v1`.`f2` AS `f2` from (`test2`.`t1_for_v1` `tab1_v1` join `test1`.`v0` `tab2` on(((`tab1_v1`.`f1` = `tab2`.`f1`) and (`tab1_v1`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v10` -- /*!50001 DROP TABLE IF EXISTS `v10`*/; /*!50001 DROP VIEW IF EXISTS `v10`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v10` AS select `tab1_v10`.`f1` AS `f1`,`tab1_v10`.`f2` AS `f2` from (`test2`.`t1_for_v10` `tab1_v10` join `test1`.`v9` `tab2` on(((`tab1_v10`.`f1` = `tab2`.`f1`) and (`tab1_v10`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v11` -- /*!50001 DROP TABLE IF EXISTS `v11`*/; /*!50001 DROP VIEW IF EXISTS `v11`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v11` AS select `tab1_v11`.`f1` AS `f1`,`tab1_v11`.`f2` AS `f2` from (`test3`.`t1_for_v11` `tab1_v11` join `test1`.`v10` `tab2` on(((`tab1_v11`.`f1` = `tab2`.`f1`) and (`tab1_v11`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v12` -- /*!50001 DROP TABLE IF EXISTS `v12`*/; /*!50001 DROP VIEW IF EXISTS `v12`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v12` AS select `tab1_v12`.`f1` AS `f1`,`tab1_v12`.`f2` AS `f2` from (`test1`.`t1_for_v12` `tab1_v12` join `test1`.`v11` `tab2` on(((`tab1_v12`.`f1` = `tab2`.`f1`) and (`tab1_v12`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v13` -- /*!50001 DROP TABLE IF EXISTS `v13`*/; /*!50001 DROP VIEW IF EXISTS `v13`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v13` AS select `tab1_v13`.`f1` AS `f1`,`tab1_v13`.`f2` AS `f2` from (`test2`.`t1_for_v13` `tab1_v13` join `test1`.`v12` `tab2` on(((`tab1_v13`.`f1` = `tab2`.`f1`) and (`tab1_v13`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v14` -- /*!50001 DROP TABLE IF EXISTS `v14`*/; /*!50001 DROP VIEW IF EXISTS `v14`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v14` AS select `tab1_v14`.`f1` AS `f1`,`tab1_v14`.`f2` AS `f2` from (`test3`.`t1_for_v14` `tab1_v14` join `test1`.`v13` `tab2` on(((`tab1_v14`.`f1` = `tab2`.`f1`) and (`tab1_v14`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v15` -- /*!50001 DROP TABLE IF EXISTS `v15`*/; /*!50001 DROP VIEW IF EXISTS `v15`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v15` AS select `tab1_v15`.`f1` AS `f1`,`tab1_v15`.`f2` AS `f2` from (`test1`.`t1_for_v15` `tab1_v15` join `test1`.`v14` `tab2` on(((`tab1_v15`.`f1` = `tab2`.`f1`) and (`tab1_v15`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v16` -- /*!50001 DROP TABLE IF EXISTS `v16`*/; /*!50001 DROP VIEW IF EXISTS `v16`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v16` AS select `tab1_v16`.`f1` AS `f1`,`tab1_v16`.`f2` AS `f2` from (`test2`.`t1_for_v16` `tab1_v16` join `test1`.`v15` `tab2` on(((`tab1_v16`.`f1` = `tab2`.`f1`) and (`tab1_v16`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v17` -- /*!50001 DROP TABLE IF EXISTS `v17`*/; /*!50001 DROP VIEW IF EXISTS `v17`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v17` AS select `tab1_v17`.`f1` AS `f1`,`tab1_v17`.`f2` AS `f2` from (`test3`.`t1_for_v17` `tab1_v17` join `test1`.`v16` `tab2` on(((`tab1_v17`.`f1` = `tab2`.`f1`) and (`tab1_v17`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v18` -- /*!50001 DROP TABLE IF EXISTS `v18`*/; /*!50001 DROP VIEW IF EXISTS `v18`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v18` AS select `tab1_v18`.`f1` AS `f1`,`tab1_v18`.`f2` AS `f2` from (`test1`.`t1_for_v18` `tab1_v18` join `test1`.`v17` `tab2` on(((`tab1_v18`.`f1` = `tab2`.`f1`) and (`tab1_v18`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v19` -- /*!50001 DROP TABLE IF EXISTS `v19`*/; /*!50001 DROP VIEW IF EXISTS `v19`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v19` AS select `tab1_v19`.`f1` AS `f1`,`tab1_v19`.`f2` AS `f2` from (`test2`.`t1_for_v19` `tab1_v19` join `test1`.`v18` `tab2` on(((`tab1_v19`.`f1` = `tab2`.`f1`) and (`tab1_v19`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v2` -- /*!50001 DROP TABLE IF EXISTS `v2`*/; /*!50001 DROP VIEW IF EXISTS `v2`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v2` AS select `tab1_v2`.`f1` AS `f1`,`tab1_v2`.`f2` AS `f2` from (`test3`.`t1_for_v2` `tab1_v2` join `test1`.`v1` `tab2` on(((`tab1_v2`.`f1` = `tab2`.`f1`) and (`tab1_v2`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v20` -- /*!50001 DROP TABLE IF EXISTS `v20`*/; /*!50001 DROP VIEW IF EXISTS `v20`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v20` AS select `tab1_v20`.`f1` AS `f1`,`tab1_v20`.`f2` AS `f2` from (`test3`.`t1_for_v20` `tab1_v20` join `test1`.`v19` `tab2` on(((`tab1_v20`.`f1` = `tab2`.`f1`) and (`tab1_v20`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v21` -- /*!50001 DROP TABLE IF EXISTS `v21`*/; /*!50001 DROP VIEW IF EXISTS `v21`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v21` AS select `tab1_v21`.`f1` AS `f1`,`tab1_v21`.`f2` AS `f2` from (`test1`.`t1_for_v21` `tab1_v21` join `test1`.`v20` `tab2` on(((`tab1_v21`.`f1` = `tab2`.`f1`) and (`tab1_v21`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v22` -- /*!50001 DROP TABLE IF EXISTS `v22`*/; /*!50001 DROP VIEW IF EXISTS `v22`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v22` AS select `tab1_v22`.`f1` AS `f1`,`tab1_v22`.`f2` AS `f2` from (`test2`.`t1_for_v22` `tab1_v22` join `test1`.`v21` `tab2` on(((`tab1_v22`.`f1` = `tab2`.`f1`) and (`tab1_v22`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v23` -- /*!50001 DROP TABLE IF EXISTS `v23`*/; /*!50001 DROP VIEW IF EXISTS `v23`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v23` AS select `tab1_v23`.`f1` AS `f1`,`tab1_v23`.`f2` AS `f2` from (`test3`.`t1_for_v23` `tab1_v23` join `test1`.`v22` `tab2` on(((`tab1_v23`.`f1` = `tab2`.`f1`) and (`tab1_v23`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v24` -- /*!50001 DROP TABLE IF EXISTS `v24`*/; /*!50001 DROP VIEW IF EXISTS `v24`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v24` AS select `tab1_v24`.`f1` AS `f1`,`tab1_v24`.`f2` AS `f2` from (`test1`.`t1_for_v24` `tab1_v24` join `test1`.`v23` `tab2` on(((`tab1_v24`.`f1` = `tab2`.`f1`) and (`tab1_v24`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v25` -- /*!50001 DROP TABLE IF EXISTS `v25`*/; /*!50001 DROP VIEW IF EXISTS `v25`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v25` AS select `tab1_v25`.`f1` AS `f1`,`tab1_v25`.`f2` AS `f2` from (`test2`.`t1_for_v25` `tab1_v25` join `test1`.`v24` `tab2` on(((`tab1_v25`.`f1` = `tab2`.`f1`) and (`tab1_v25`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v26` -- /*!50001 DROP TABLE IF EXISTS `v26`*/; /*!50001 DROP VIEW IF EXISTS `v26`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v26` AS select `tab1_v26`.`f1` AS `f1`,`tab1_v26`.`f2` AS `f2` from (`test3`.`t1_for_v26` `tab1_v26` join `test1`.`v25` `tab2` on(((`tab1_v26`.`f1` = `tab2`.`f1`) and (`tab1_v26`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v27` -- /*!50001 DROP TABLE IF EXISTS `v27`*/; /*!50001 DROP VIEW IF EXISTS `v27`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v27` AS select `tab1_v27`.`f1` AS `f1`,`tab1_v27`.`f2` AS `f2` from (`test1`.`t1_for_v27` `tab1_v27` join `test1`.`v26` `tab2` on(((`tab1_v27`.`f1` = `tab2`.`f1`) and (`tab1_v27`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v3` -- /*!50001 DROP TABLE IF EXISTS `v3`*/; /*!50001 DROP VIEW IF EXISTS `v3`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v3` AS select `tab1_v3`.`f1` AS `f1`,`tab1_v3`.`f2` AS `f2` from (`test1`.`t1_for_v3` `tab1_v3` join `test1`.`v2` `tab2` on(((`tab1_v3`.`f1` = `tab2`.`f1`) and (`tab1_v3`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v4` -- /*!50001 DROP TABLE IF EXISTS `v4`*/; /*!50001 DROP VIEW IF EXISTS `v4`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v4` AS select `tab1_v4`.`f1` AS `f1`,`tab1_v4`.`f2` AS `f2` from (`test2`.`t1_for_v4` `tab1_v4` join `test1`.`v3` `tab2` on(((`tab1_v4`.`f1` = `tab2`.`f1`) and (`tab1_v4`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v5` -- /*!50001 DROP TABLE IF EXISTS `v5`*/; /*!50001 DROP VIEW IF EXISTS `v5`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v5` AS select `tab1_v5`.`f1` AS `f1`,`tab1_v5`.`f2` AS `f2` from (`test3`.`t1_for_v5` `tab1_v5` join `test1`.`v4` `tab2` on(((`tab1_v5`.`f1` = `tab2`.`f1`) and (`tab1_v5`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v6` -- /*!50001 DROP TABLE IF EXISTS `v6`*/; /*!50001 DROP VIEW IF EXISTS `v6`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v6` AS select `tab1_v6`.`f1` AS `f1`,`tab1_v6`.`f2` AS `f2` from (`test1`.`t1_for_v6` `tab1_v6` join `test1`.`v5` `tab2` on(((`tab1_v6`.`f1` = `tab2`.`f1`) and (`tab1_v6`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v7` -- /*!50001 DROP TABLE IF EXISTS `v7`*/; /*!50001 DROP VIEW IF EXISTS `v7`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v7` AS select `tab1_v7`.`f1` AS `f1`,`tab1_v7`.`f2` AS `f2` from (`test2`.`t1_for_v7` `tab1_v7` join `test1`.`v6` `tab2` on(((`tab1_v7`.`f1` = `tab2`.`f1`) and (`tab1_v7`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v8` -- /*!50001 DROP TABLE IF EXISTS `v8`*/; /*!50001 DROP VIEW IF EXISTS `v8`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v8` AS select `tab1_v8`.`f1` AS `f1`,`tab1_v8`.`f2` AS `f2` from (`test3`.`t1_for_v8` `tab1_v8` join `test1`.`v7` `tab2` on(((`tab1_v8`.`f1` = `tab2`.`f1`) and (`tab1_v8`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v9` -- /*!50001 DROP TABLE IF EXISTS `v9`*/; /*!50001 DROP VIEW IF EXISTS `v9`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v9` AS select `tab1_v9`.`f1` AS `f1`,`tab1_v9`.`f2` AS `f2` from (`test1`.`t1_for_v9` `tab1_v9` join `test1`.`v8` `tab2` on(((`tab1_v9`.`f1` = `tab2`.`f1`) and (`tab1_v9`.`f2` = `tab2`.`f2`)))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Current Database: `test2` -- USE `test2`; drop table if exists t0_for_t2; drop table if exists t0_for_t3; create table t0_for_t2 like t0; insert into t0_for_t2 select * from t0; create table t0_for_t3 like t0; insert into t0_for_t3 select * from t0; -- -- Final view structure for view `t2` -- /*!50001 DROP TABLE IF EXISTS `t2`*/; /*!50001 DROP VIEW IF EXISTS `t2`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `t2` AS select `t0_for_t2`.`f1` AS `f1` from `t0_for_t2` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `t3` -- /*!50001 DROP TABLE IF EXISTS `t3`*/; /*!50001 DROP VIEW IF EXISTS `t3`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = latin1 */; /*!50001 SET character_set_results = latin1 */; /*!50001 SET collation_connection = latin1_swedish_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `t3` AS select `test1`.`t0_for_t3`.`f1` AS `f1` from `test1`.`t0_for_t3` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Current Database: `test3` -- USE `test3`; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2014-10-21 14:14:14