CREATE DATABASE IF NOT EXISTS test;
USE test;
DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (
  `id_col` int NOT NULL AUTO_INCREMENT,
  `datetime_col` datetime(6) DEFAULT NULL,
  `char_col` char(4) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `varchar_col` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `text_col` text CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id_col`),
  KEY `ndx_id_bigint_col` (`id_col`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `t1` VALUES (1,'1000-01-01 00:00:00.000000','aaaa','bbbbbbbbbaa','jjjjjjjjjj1'),(2,'1000-01-01 00:00:00.000000','aaaa','bbbbbbbbbaa','jjjjjjjjjj1'),(3,'1000-01-01 00:00:00.000000','aaaa','bbbbbbbbbaa','jjjjjjjjjj1'),(4,'1000-01-01 00:00:00.000000','aaaa','bbbbbbbbbaa','jjjjjjjjjj1'),(5,'1000-01-01 00:00:00.000000','aaaa','bbbbbbbbbaa','jjjjjjjjjj1'),(6,'2001-01-01 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(7,'2001-01-01 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(8,'2001-01-01 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(9,'2001-01-01 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(10,'2001-01-01 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(11,'2001-02-01 00:00:00.000000','aacd','bbbbbbbbcd','jjjjjjjjjj1'),(12,'2001-02-01 00:00:00.000000','aacd','bbbbbbbbcd','jjjjjjjjjj1'),(13,'2001-02-01 00:00:00.000000','aacd','bbbbbbbbcd','jjjjjjjjjj1'),(14,'2001-02-01 00:00:00.000000','aacd','bbbbbbbbcd','jjjjjjjjjj1'),(15,'2001-02-01 00:00:00.000000','aacd','bbbbbbbbcd','jjjjjjjjjj1'),(16,'2001-03-02 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(17,'2001-03-02 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(18,'2001-03-02 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(19,'2001-03-02 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(20,'2001-03-02 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(21,'2001-04-06 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(22,'2001-04-06 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(23,'2001-04-06 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(24,'2001-04-06 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(25,'2001-04-06 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(26,'2001-05-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(27,'2001-05-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(28,'2001-05-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(29,'2001-05-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(30,'2001-05-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(31,'2018-10-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(32,'2018-10-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(33,'2018-10-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(34,'2018-10-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(35,'2018-10-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(36,'2015-05-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(37,'2015-05-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(38,'2015-05-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(39,'2015-05-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(40,'2015-05-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(41,'2014-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(42,'2014-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(43,'2014-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(44,'2014-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(45,'2014-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(46,'2011-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(47,'2011-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(48,'2011-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(49,'2011-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(50,'2011-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(51,'2012-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(52,'2012-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(53,'2012-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(54,'2012-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(55,'2012-11-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(56,'2022-12-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(57,'2022-12-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(58,'2022-12-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(59,'2022-12-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(60,'2022-12-09 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(61,'2018-12-31 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(62,'2018-12-31 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(63,'2018-12-31 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(64,'2018-12-31 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(65,'2018-12-31 00:00:00.000000','aabb','bbbbbbbbbb','jjjjjjjjjj1'),(66,'9999-12-31 23:59:59.000000','aaa2','bbba2','jjj2'),(67,'9999-12-31 23:59:59.000000','aaa2','bbba2','jjj2'),(68,'9999-12-31 23:59:59.000000','aaa2','bbba2','jjj2'),(70,'9999-12-31 23:59:59.000000','aaa2','bbba2','jjj2'),(71,'2020-01-01 00:00:01.000000','ab','ab','j'),(72,'2020-01-01 00:00:01.000000','ab','ab','j'),(73,'2020-01-01 00:00:01.000000','ab','ab','j'),(74,'2020-01-01 00:00:01.000000','ab','ab','j'),(75,'2020-01-01 00:00:01.000000','ab','ab','j'),(76,'2020-01-01 00:00:01.000000','ab','ab','a'),(77,'2020-01-01 00:00:01.000000','ab','ab','a'),(78,'2020-01-01 00:00:01.000000','ab','ab','a'),(79,'2020-01-01 00:00:01.000000','ab','ab','a'),(80,'2020-01-01 00:00:01.000000','ab','ab','a'),(81,'2020-01-01 00:00:01.000000','ab','ab','j'),(82,'2020-01-01 00:00:01.000000','ab','ab','j'),(83,'2020-01-01 00:00:01.000000','ab','ab','j'),(84,'1992-03-04 12:20:00.000000',NULL,NULL,NULL),(85,'1992-03-04 12:20:00.000000',NULL,NULL,NULL),(86,'1992-03-04 12:20:00.000000',NULL,NULL,NULL),(87,'1992-03-04 12:20:00.000000',NULL,NULL,NULL),(88,'1992-03-04 12:20:00.000000',NULL,NULL,NULL),(89,'1995-09-02 13:20:00.000000',NULL,NULL,NULL),(90,'1995-09-02 13:20:00.000000',NULL,NULL,NULL),(91,'1995-09-02 13:20:00.000000',NULL,NULL,NULL),(92,'1995-09-02 13:20:00.000000',NULL,NULL,NULL),(93,'1995-09-02 13:20:00.000000',NULL,NULL,NULL),(94,'1999-09-02 13:20:00.000000',NULL,NULL,NULL),(95,'1999-09-02 13:20:00.000000',NULL,NULL,NULL),(96,'1999-09-02 13:20:00.000000',NULL,NULL,NULL),(97,'1999-09-02 13:20:00.000000',NULL,NULL,NULL),(98,'1999-09-02 13:20:00.000000',NULL,NULL,NULL),(99,'1997-09-02 13:20:00.000000',NULL,NULL,NULL),(100,'1997-09-02 13:20:00.000000',NULL,NULL,NULL),(101,'1997-09-02 13:20:00.000000',NULL,NULL,NULL),(102,'1997-09-02 13:20:00.000000',NULL,NULL,NULL),(103,'1997-09-02 13:20:00.000000',NULL,NULL,NULL),(104,'2008-10-02 13:20:00.000000',NULL,NULL,NULL),(105,'2008-10-02 13:20:00.000000',NULL,NULL,NULL),(106,'2008-10-02 13:20:00.000000',NULL,NULL,NULL),(107,'2008-10-02 13:20:00.000000',NULL,NULL,NULL),(108,'2008-10-02 13:20:00.000000',NULL,NULL,NULL);