-- MySQL dump 10.13 Distrib 8.0.27, for Linux (x86_64) -- -- Host: 127.0.0.1 Database: testdb -- ------------------------------------------------------ -- Server version 5.7.25-TiDB-v5.4.0-alpha-311-g28446605c /*!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 */; /*!50503 SET NAMES utf8mb4 */; /*!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 */; -- -- Temporary view structure for view `t_897eid` -- DROP TABLE IF EXISTS `t_897eid`; /*!50001 DROP VIEW IF EXISTS `t_897eid`*/; SET @saved_cs_client = @@character_set_client; /*!50503 SET character_set_client = utf8mb4 */; /*!50001 CREATE VIEW `t_897eid` AS SELECT 1 AS `c0`, 1 AS `c1`, 1 AS `c2`, 1 AS `c3`, 1 AS `c4`, 1 AS `c5`, 1 AS `c6`, 1 AS `c7`, 1 AS `c8`, 1 AS `c9`*/; SET character_set_client = @saved_cs_client; -- -- Temporary view structure for view `t__l_jcb` -- DROP TABLE IF EXISTS `t__l_jcb`; /*!50001 DROP VIEW IF EXISTS `t__l_jcb`*/; SET @saved_cs_client = @@character_set_client; /*!50503 SET character_set_client = utf8mb4 */; /*!50001 CREATE VIEW `t__l_jcb` AS SELECT 1 AS `c0`, 1 AS `c1`, 1 AS `c2`, 1 AS `c3`, 1 AS `c4`, 1 AS `c5`, 1 AS `c6`, 1 AS `c7`*/; SET character_set_client = @saved_cs_client; -- -- Temporary view structure for view `t_ai_sq` -- DROP TABLE IF EXISTS `t_ai_sq`; /*!50001 DROP VIEW IF EXISTS `t_ai_sq`*/; SET @saved_cs_client = @@character_set_client; /*!50503 SET character_set_client = utf8mb4 */; /*!50001 CREATE VIEW `t_ai_sq` AS SELECT 1 AS `c0`, 1 AS `c1`, 1 AS `c2`, 1 AS `c3`, 1 AS `c4`, 1 AS `c5`, 1 AS `c6`, 1 AS `c7`*/; SET character_set_client = @saved_cs_client; -- -- Table structure for table `t_fhw96d` -- DROP TABLE IF EXISTS `t_fhw96d`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `t_fhw96d` ( `c_gsj0eb` int(11) DEFAULT NULL, `c_wh8ptc` double DEFAULT NULL, `c_bnoakb` int(11) DEFAULT NULL, `c_ny8gr` double DEFAULT NULL, `c_rxsigd` double DEFAULT NULL, `c_cqgvo` double DEFAULT NULL, `c_ncaqz` int(11) NOT NULL, `c_qm1ixc` int(11) DEFAULT NULL, `c_u2_5wc` text DEFAULT NULL, PRIMARY KEY (`c_ncaqz`) /*T![clustered_index] CLUSTERED */ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_fhw96d` -- LOCK TABLES `t_fhw96d` WRITE; /*!40000 ALTER TABLE `t_fhw96d` DISABLE KEYS */; INSERT INTO `t_fhw96d` VALUES (48,69.7,37,11.16,2147483648.1,38.6,-96,41,'__achb'),(12,87.2,53,82.55,89.96,59.78,2,63,'0f77i'),(19,NULL,1,37.35,52.93,16.87,13,28,'kxsnnc'),(52,39.26,671088640,5.91,2147483648.1,13.26,14,8,'3mjyfb'),(64,40.17,70,58.43,72.21,55.98,20,45,NULL),(37,98.72,22,6.2,51.61,17.12,45,86,'svkpkc'),(1,78.59,20,NULL,91.83,81.98,54,13,'713136717063'),(81,81.56,2,NULL,70.84,NULL,58,22,'icwdjc'),(21,88.86,4,88.15,93.7,48.44,63,19,'tvys0'),(54,72.6,0,NULL,47.41,95.23,73,15,'vh3xvc'),(3920,26.16,46,91.74,9.2,49.29,83,10,'ggjvfc'),(28,62.31,75,79.53,3.57,45.58,97,17,'wxtadc'); /*!40000 ALTER TABLE `t_fhw96d` ENABLE KEYS */; UNLOCK TABLES; -- -- Temporary view structure for view `t_gppivc` -- DROP TABLE IF EXISTS `t_gppivc`; /*!50001 DROP VIEW IF EXISTS `t_gppivc`*/; SET @saved_cs_client = @@character_set_client; /*!50503 SET character_set_client = utf8mb4 */; /*!50001 CREATE VIEW `t_gppivc` AS SELECT 1 AS `c0`, 1 AS `c1`, 1 AS `c3`, 1 AS `c4`, 1 AS `c5`, 1 AS `c6`, 1 AS `c7`*/; SET character_set_client = @saved_cs_client; -- -- Table structure for table `t_x0zovd` -- DROP TABLE IF EXISTS `t_x0zovd`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `t_x0zovd` ( `c_s_x8wd` int(11) DEFAULT NULL, `c_xru7m` text DEFAULT NULL, `c_3nbzub` double NOT NULL, `c_xlxih` int(11) DEFAULT NULL, `c_to6g3c` text DEFAULT NULL, `c_hndnw` text DEFAULT NULL, PRIMARY KEY (`c_3nbzub`) /*T![clustered_index] NONCLUSTERED */ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `t_x0zovd` -- LOCK TABLES `t_x0zovd` WRITE; /*!40000 ALTER TABLE `t_x0zovd` DISABLE KEYS */; INSERT INTO `t_x0zovd` VALUES (16,NULL,22.14,80,NULL,NULL); /*!40000 ALTER TABLE `t_x0zovd` ENABLE KEYS */; UNLOCK TABLES; -- -- Final view structure for view `t_897eid` -- /*!50001 DROP VIEW IF EXISTS `t_897eid`*/; /*!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 = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_0900_ai_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `t_897eid` (`c0`, `c1`, `c2`, `c3`, `c4`, `c5`, `c6`, `c7`, `c8`, `c9`) AS SELECT `ref_0`.`c_bnoakb` AS `c0`,HEX(_UTF8MB4'z5wamb') AS `c1`,`ref_1`.`c_hndnw` AS `c2`,`ref_1`.`c_hndnw` AS `c3`,CASE WHEN (`ref_1`.`c_to6g3c` NOT LIKE _UTF8MB4'nez_xd') AND (`ref_0`.`c_u2_5wc` LIKE _UTF8MB4'belz%') THEN `ref_0`.`c_bnoakb` ELSE `ref_1`.`c_xlxih` END AS `c4`,`ref_1`.`c_xru7m` AS `c5`,`ref_1`.`c_s_x8wd` AS `c6`,`ref_0`.`c_bnoakb` AS `c7`,21 AS `c8`,`ref_0`.`c_u2_5wc` AS `c9` FROM `testdb`.`t_fhw96d` AS `ref_0` JOIN `testdb`.`t_x0zovd` AS `ref_1` WHERE `ref_1`.`c_hndnw` IS NULL */; /*!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 `t__l_jcb` -- /*!50001 DROP VIEW IF EXISTS `t__l_jcb`*/; /*!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 = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_0900_ai_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `t__l_jcb` (`c0`, `c1`, `c2`, `c3`, `c4`, `c5`, `c6`, `c7`) AS SELECT `ref_0`.`c6` AS `c0`,`ref_0`.`c3` AS `c1`,`ref_0`.`c3` AS `c2`,`ref_0`.`c0` AS `c3`,HEX(SUBSTR((`ref_0`.`c3` OR `ref_0`.`c3`), `ref_0`.`c5`, `ref_0`.`c7`)) AS `c4`,`ref_0`.`c2` AS `c5`,NTILE(26) OVER (PARTITION BY `ref_0`.`c6`, `ref_0`.`c7` ORDER BY `ref_0`.`c1`) AS `c6`,`ref_0`.`c1` AS `c7` FROM `testdb`.`t_ai_sq` AS `ref_0` WHERE `ref_0`.`c4` IS NULL */; /*!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 `t_ai_sq` -- /*!50001 DROP VIEW IF EXISTS `t_ai_sq`*/; /*!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 = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_0900_ai_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `t_ai_sq` (`c0`, `c1`, `c2`, `c3`, `c4`, `c5`, `c6`, `c7`) AS SELECT `ref_0`.`c5` AS `c0`,`ref_0`.`c1` AS `c1`,58 AS `c2`,`ref_0`.`c2` AS `c3`,`ref_0`.`c1` AS `c4`,`ref_0`.`c6` AS `c5`,((`ref_0`.`c0`+`ref_0`.`c6`)|`ref_0`.`c7`) AS `c6`,`ref_0`.`c4` AS `c7` FROM `testdb`.`t_897eid` AS `ref_0` WHERE (`ref_0`.`c7` BETWEEN `ref_0`.`c4` AND `ref_0`.`c0`) OR (`ref_0`.`c4` NOT IN (SELECT 88 AS `c0` FROM `testdb`.`t_897eid` AS `ref_1` WHERE `ref_1`.`c5` LIKE _UTF8MB4't%_cid' ORDER BY -`c0`)) */; /*!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 `t_gppivc` -- /*!50001 DROP VIEW IF EXISTS `t_gppivc`*/; /*!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 = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_0900_ai_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`%` SQL SECURITY DEFINER VIEW `t_gppivc` (`c0`, `c1`, `c3`, `c4`, `c5`, `c6`, `c7`) AS SELECT `ref_0`.`c_s_x8wd` AS `c0`,NULLIF(`ref_0`.`c_hndnw`, `ref_0`.`c_to6g3c`) AS `c1`,(`ref_0`.`c_xlxih`-(`ref_0`.`c_xlxih`<<`ref_0`.`c_xlxih`)) AS `c3`,`ref_0`.`c_hndnw` AS `c4`,`ref_0`.`c_to6g3c` AS `c5`,`ref_0`.`c_xru7m` AS `c6`,`ref_0`.`c_xru7m` AS `c7` FROM `testdb`.`t_x0zovd` AS `ref_0` WHERE `ref_0`.`c_to6g3c` NOT IN (SELECT `ref_1`.`c_u2_5wc` AS `c0` FROM `testdb`.`t_fhw96d` AS `ref_1` WHERE `ref_1`.`c_bnoakb`!=`ref_1`.`c_bnoakb` AND (`ref_1`.`c_qm1ixc`>>`ref_1`.`c_gsj0eb`) IS NOT NULL) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!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 2021-12-06 17:28:52