--disable_abort_on_error CREATE TABLE DD ( pk INTEGER AUTO_INCREMENT, col_int_nokey INTEGER /*! NULL */, col_int_key INTEGER, col_date_key DATE, col_date_nokey DATE /*! NULL */, col_time_key TIME, col_time_nokey TIME /*! NULL */, col_datetime_key DATETIME, col_datetime_nokey DATETIME /*! NULL */, col_varchar_key VARCHAR(1), col_varchar_nokey VARCHAR(1) /*! NULL */, PRIMARY KEY (pk), KEY (col_varchar_key, col_int_key) ) AUTO_INCREMENT=10 /* QNO 25 CON_ID 9 */; INSERT /*! IGNORE */ INTO DD ( col_int_key, col_int_nokey, col_date_key, col_date_nokey, col_time_key, col_time_nokey, col_datetime_key, col_datetime_nokey, col_varchar_key, col_varchar_nokey ) VALUES (8, 0, '1900-01-01', '1900-01-01', '07:55:54.051037', '07:55:54.051037', '1974-11-09 06:28:05.052151', '1974-11-09 06:28:05.052151', 'z', 'z'),(6, 3, NULL, NULL, '14:18:47.011111', '14:18:47.011111', '2010-02-11 10:59:50.050473', '2010-02-11 10:59:50.050473', 'j', 'j'),(2, 8, '2035-09-06', '2035-09-06', '00:00:00', '00:00:00', '2021-02-23 00:39:41.005498', '2021-02-23 00:39:41.005498', NULL, NULL),(3, 8, '2014-08-23', '2014-08-23', '01:57:54.037299', '01:57:54.037299', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'p', 'p'),(1, 6, '2030-03-24', '2030-03-24', '21:24:27.027297', '21:24:27.027297', '2015-07-03 13:47:15.010810', '2015-07-03 13:47:15.010810', 'w', 'w'),(NULL, 0, '1980-11-15', '1980-11-15', NULL, NULL, '2032-04-11 12:39:06.038205', '2032-04-11 12:39:06.038205', 'c', 'c'),(1, NULL, '1982-12-23', '1982-12-23', '21:34:24.023001', '21:34:24.023001', '1993-01-26 15:51:38.027592', '1993-01-26 15:51:38.027592', 'j', 'j'),(10, 158, '1978-02-11', '1978-02-11', '18:11:35.006542', '18:11:35.006542', '2034-04-27 19:48:50.025877', '2034-04-27 19:48:50.025877', 'f', 'f'),(2, 5, '2021-04-16', '2021-04-16', '09:21:51.027414', '09:21:51.027414', '2002-11-15 10:51:46.055784', '2002-11-15 10:51:46.055784', 'v', 'v'),(103, 163, '2018-05-12', '2018-05-12', '09:02:21.047274', '09:02:21.047274', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'f', 'f'),(3, 2, '2031-07-20', '2031-07-20', '22:40:03.005755', '22:40:03.005755', '1981-10-20 17:09:41.008405', '1981-10-20 17:09:41.008405', 'q', 'q'),(6, 8, '2014-08-14', '2014-08-14', '19:29:48.025140', '19:29:48.025140', '2006-10-03 00:00:00', '2006-10-03 00:00:00', 'y', 'y'),(2, 0, '2005-08-04', '2005-08-04', NULL, NULL, '1994-03-06 19:40:18.015845', '1994-03-06 19:40:18.015845', 'a', 'a'),(7, 9, '2003-06-25', '2003-06-25', '01:39:40.022975', '01:39:40.022975', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'w', 'w'),(2, 3, '2005-04-08', '2005-04-08', '18:14:11.006811', '18:14:11.006811', '1980-03-03 15:06:11.026757', '1980-03-03 15:06:11.026757', 'e', 'e'),(2, 1, '2005-12-20', '2005-12-20', '03:28:55.038579', '03:28:55.038579', '2025-06-03 03:14:33.011355', '2025-06-03 03:14:33.011355', NULL, NULL),(4, 9, '1975-07-09', '1975-07-09', '15:00:03.027372', '15:00:03.027372', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'r', 'r'),(6, NULL, '1900-01-01', '1900-01-01', '17:10:27.024761', '17:10:27.024761', '2014-04-18 18:00:26.055211', '2014-04-18 18:00:26.055211', 'k', 'k'),(6, 5, '1900-01-01', '1900-01-01', '09:50:22.010984', '09:50:22.010984', '2026-10-20 00:00:00', '2026-10-20 00:00:00', 'c', 'c'),(8, 3, '1988-09-24', '1988-09-24', '00:00:00', '00:00:00', '2010-07-24 13:01:33.046163', '2010-07-24 13:01:33.046163', 'k', 'k'),(4, 9, '1986-05-07', '1986-05-07', '09:51:13.046778', '09:51:13.046778', '2006-04-14 03:38:00.008685', '2006-04-14 03:38:00.008685', NULL, NULL),(2, 8, '2013-07-15', '2013-07-15', '11:25:28.044423', '11:25:28.044423', NULL, NULL, 'j', 'j'),(8, 1, '1996-09-09', '1996-09-09', NULL, NULL, '1973-07-16 03:25:43.049611', '1973-07-16 03:25:43.049611', 't', 't'),(1, 8, '1997-05-08', '1997-05-08', '11:14:24.017155', '11:14:24.017155', '1981-12-12 08:27:15.009824', '1981-12-12 08:27:15.009824', 'n', 'n'),(NULL, NULL, '1985-02-05', '1985-02-05', '04:00:47.034077', '04:00:47.034077', '2022-11-25 18:24:30.022778', '2022-11-25 18:24:30.022778', 'z', 'z'),(3, 0, '1991-02-21', '1991-02-21', '21:22:12.046674', '21:22:12.046674', '1991-07-28 18:41:31.045474', '1991-07-28 18:41:31.045474', 'u', 'u'),(2, 3, '1972-05-10', '1972-05-10', '14:29:11.045056', '14:29:11.045056', '2034-09-25 22:51:04.037264', '2034-09-25 22:51:04.037264', 'a', 'a'),(NULL, 3, '2018-10-28', '2018-10-28', '16:23:38.048946', '16:23:38.048946', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'g', 'g'),(4, 1, '2023-05-01', '2023-05-01', '20:06:35.055965', '20:06:35.055965', '2011-01-11 07:21:24.021466', '2011-01-11 07:21:24.021466', 'f', 'f'),(60, 64, '2020-02-26', '2020-02-26', '19:33:10.017526', '19:33:10.017526', '1979-09-15 17:25:04.015905', '1979-09-15 17:25:04.015905', 'p', 'p'),(0, 6, '1900-01-01', '1900-01-01', '08:51:41.001482', '08:51:41.001482', '2008-01-07 21:23:06.047700', '2008-01-07 21:23:06.047700', 'm', 'm'),(8, 6, '1993-12-11', '1993-12-11', '22:40:20.000951', '22:40:20.000951', '1974-11-12 05:56:02.042994', '1974-11-12 05:56:02.042994', 't', 't'),(5, 7, '1978-02-05', '1978-02-05', '13:00:50.057511', '13:00:50.057511', '2000-08-27 08:22:13.010392', '2000-08-27 08:22:13.010392', 'i', 'i'),(4, 4, '2029-08-23', '2029-08-23', NULL, NULL, '2015-02-27 00:00:00', '2015-02-27 00:00:00', 'h', 'h'),(207, 38, NULL, NULL, '12:54:06.045953', '12:54:06.045953', '1996-09-27 12:06:03.048560', '1996-09-27 12:06:03.048560', 'd', 'd'),(183, 206, '2000-07-25', '2000-07-25', '22:47:40.000268', '22:47:40.000268', '2029-07-13 16:52:43.054178', '2029-07-13 16:52:43.054178', 'b', 'b'),(7, NULL, '1996-05-25', '1996-05-25', '03:01:56.013760', '03:01:56.013760', '1973-10-13 00:00:00', '1973-10-13 00:00:00', 'o', 'o'),(1, 2, '2019-03-16', '2019-03-16', '12:35:21.015952', '12:35:21.015952', '2025-12-02 00:57:31.056351', '2025-12-02 00:57:31.056351', 'j', 'j'),(17, 36, '2029-12-19', '2029-12-19', '00:00:00', '00:00:00', '1978-03-12 09:48:05.033853', '1978-03-12 09:48:05.033853', 's', 's'),(4, 5, '2006-10-23', '2006-10-23', '20:46:34.003982', '20:46:34.003982', '1988-06-07 08:16:24.030171', '1988-06-07 08:16:24.030171', 'q', 'q'),(0, 6, '1984-03-04', '1984-03-04', '10:48:51.018074', '10:48:51.018074', '2032-08-20 11:54:04.031499', '2032-08-20 11:54:04.031499', 'l', 'l'),(1, 9, NULL, NULL, '07:06:12.019155', '07:06:12.019155', '2008-05-22 00:00:00', '2008-05-22 00:00:00', 'j', 'j'),(5, 6, '1980-05-19', '1980-05-19', '08:11:01.049319', '08:11:01.049319', '1990-02-28 11:00:47.051802', '1990-02-28 11:00:47.051802', 'y', 'y'),(NULL, 0, '1990-01-21', '1990-01-21', NULL, NULL, NULL, NULL, 'i', 'i'),(7, 7, '2005-07-16', '2005-07-16', '00:00:00', '00:00:00', '2012-04-09 11:38:17.004697', '2012-04-09 11:38:17.004697', 'x', 'x'),(5, 2, '1900-01-01', '1900-01-01', '09:05:46.049259', '09:05:46.049259', '1986-10-08 08:08:42.010058', '1986-10-08 08:08:42.010058', 'u', 'u'),(160, 146, NULL, NULL, '10:49:42.003572', '10:49:42.003572', '2004-03-15 00:00:00', '2004-03-15 00:00:00', 't', 't'),(215, 43, '1980-03-28', '1980-03-28', '20:48:06.021170', '20:48:06.021170', '2033-08-11 15:19:38.006113', '2033-08-11 15:19:38.006113', NULL, NULL),(7, 5, '1995-11-12', '1995-11-12', '16:39:08.052868', '16:39:08.052868', '1973-06-20 09:48:09.057405', '1973-06-20 09:48:09.057405', 'm', 'm'),(1, 4, '2014-12-03', '2014-12-03', '18:51:52.020034', '18:51:52.020034', NULL, NULL, 'x', 'x'),(8, 8, '1900-01-01', '1900-01-01', '13:52:22.063256', '13:52:22.063256', '1976-06-28 02:54:54.033897', '1976-06-28 02:54:54.033897', 'x', 'x'),(4, 6, '2006-09-20', '2006-09-20', '21:48:36.057283', '21:48:36.057283', '2028-08-17 00:57:41.045824', '2028-08-17 00:57:41.045824', 'v', 'v'),(1, 8, '1995-07-10', '1995-07-10', '10:59:28.034806', '10:59:28.034806', '2009-12-05 13:07:15.052162', '2009-12-05 13:07:15.052162', 'm', 'm'),(2, 4, NULL, NULL, NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'j', 'j'),(7, 8, '1995-08-17', '1995-08-17', '15:05:06.062377', '15:05:06.062377', '2007-02-03 05:31:15.058452', '2007-02-03 05:31:15.058452', 'z', 'z'),(2, 2, '2032-11-03', '2032-11-03', '15:42:01.052867', '15:42:01.052867', '1972-03-10 17:29:05.006607', '1972-03-10 17:29:05.006607', 'a', 'a'),(0, 9, '2020-06-11', '2020-06-11', NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'i', 'i'),(2, 4, '1988-09-27', '1988-09-27', '21:27:57.033453', '21:27:57.033453', '2013-01-12 11:18:49.002045', '2013-01-12 11:18:49.002045', 'g', 'g'),(4, 8, '1976-05-13', '1976-05-13', '00:00:00', '00:00:00', '2025-11-17 00:00:00', '2025-11-17 00:00:00', 'h', 'h'),(NULL, 1, '1900-01-01', '1900-01-01', '06:21:08.052509', '06:21:08.052509', '2022-11-05 15:19:40.050500', '2022-11-05 15:19:40.050500', 'p', 'p'),(6, 8, '2033-03-02', '2033-03-02', '10:17:54.019864', '10:17:54.019864', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'a', 'a'),(4, 0, '1986-06-14', '1986-06-14', '17:57:58.002639', '17:57:58.002639', NULL, NULL, 'x', 'x'),(3, 2, '2033-08-08', '2033-08-08', '06:58:38.000194', '06:58:38.000194', '1973-10-22 17:24:41.065056', '1973-10-22 17:24:41.065056', 's', 's'),(9, 6, '1989-10-02', '1989-10-02', '04:02:57.011013', '04:02:57.011013', '2033-02-11 22:03:47.002844', '2033-02-11 22:03:47.002844', 'k', 'k'),(7, 0, '2013-07-02', '2013-07-02', NULL, NULL, '2012-02-26 10:28:06.024465', '2012-02-26 10:28:06.024465', 'm', 'm'),(3, 6, '1994-01-25', '1994-01-25', NULL, NULL, '1996-08-07 15:19:01.063043', '1996-08-07 15:19:01.063043', NULL, NULL),(9, NULL, '2007-03-21', '2007-03-21', '18:27:23.060158', '18:27:23.060158', '2008-12-04 06:10:53.027755', '2008-12-04 06:10:53.027755', 'y', 'y'),(8, 7, '1979-04-15', '1979-04-15', '06:40:58.037841', '06:40:58.037841', '2014-08-03 00:00:00', '2014-08-03 00:00:00', 'd', 'd'),(4, 7, '2002-04-22', '2002-04-22', '16:21:50.042962', '16:21:50.042962', NULL, NULL, 'w', 'w'),(4, NULL, NULL, NULL, '00:00:00', '00:00:00', NULL, NULL, 'y', 'y'),(9, 9, '2011-08-20', '2011-08-20', '01:36:47.020532', '01:36:47.020532', '1998-01-05 14:23:21.063280', '1998-01-05 14:23:21.063280', 's', 's'),(8, 9, '2018-11-23', '2018-11-23', '00:00:00', '00:00:00', '1985-01-02 22:56:27.051360', '1985-01-02 22:56:27.051360', 'x', 'x'),(2, 6, '1900-01-01', '1900-01-01', '04:52:42.061600', '04:52:42.061600', '2012-12-13 19:09:03.035577', '2012-12-13 19:09:03.035577', 'l', 'l'),(8, 9, '1900-01-01', '1900-01-01', '10:52:49.017566', '10:52:49.017566', '1985-08-13 00:00:00', '1985-08-13 00:00:00', 'f', 'f'),(0, 8, '1991-11-23', '1991-11-23', '11:28:42.039525', '11:28:42.039525', '2017-09-22 08:32:34.025439', '2017-09-22 08:32:34.025439', 'x', 'x'),(1, 1, '1972-03-20', '1972-03-20', '19:34:47.010488', '19:34:47.010488', NULL, NULL, 'p', 'p'),(5, 7, '2009-05-11', '2009-05-11', '22:21:46.031300', '22:21:46.031300', '1978-08-06 08:47:23.055878', '1978-08-06 08:47:23.055878', 'y', 'y'),(4, 6, NULL, NULL, '00:00:00', '00:00:00', '2013-01-21 07:22:54.064410', '2013-01-21 07:22:54.064410', 'p', 'p'),(1, 1, '1978-08-17', '1978-08-17', '22:29:16.064947', '22:29:16.064947', '2016-09-08 00:00:00', '2016-09-08 00:00:00', 'g', 'g'),(0, 3, '2017-06-15', '2017-06-15', '22:49:28.048532', '22:49:28.048532', '2017-11-27 14:59:24.028725', '2017-11-27 14:59:24.028725', 'c', 'c'),(NULL, 5, '1900-01-01', '1900-01-01', '21:49:00.032147', '21:49:00.032147', '2027-04-19 09:35:37.027780', '2027-04-19 09:35:37.027780', 'h', 'h'),(7, 3, '2024-11-19', '2024-11-19', '18:30:23.004396', '18:30:23.004396', '2014-12-17 11:53:23.019811', '2014-12-17 11:53:23.019811', 'p', 'p'),(3, 2, '1985-04-23', '1985-04-23', '20:10:01.023785', '20:10:01.023785', NULL, NULL, 'b', 'b'),(9, NULL, NULL, NULL, '13:05:12.047909', '13:05:12.047909', '1999-09-06 14:21:25.041589', '1999-09-06 14:21:25.041589', NULL, NULL),(225, 121, '2023-03-02', '2023-03-02', NULL, NULL, NULL, NULL, NULL, NULL),(2, NULL, '1900-01-01', '1900-01-01', '11:58:30.020245', '11:58:30.020245', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'y', 'y'),(8, 7, '2020-09-12', '2020-09-12', '07:31:37.045737', '07:31:37.045737', '2001-08-02 00:50:41.045017', '2001-08-02 00:50:41.045017', 's', 's'),(9, 7, '2027-07-17', '2027-07-17', '10:52:59.018506', '10:52:59.018506', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'x', 'x'),(2, 6, '1991-07-07', '1991-07-07', '08:54:56.062434', '08:54:56.062434', NULL, NULL, 'i', 'i'),(4, 9, '2008-02-04', '2008-02-04', NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 't', 't'),(4, 5, NULL, NULL, '06:15:12.059342', '06:15:12.059342', '1979-11-05 09:01:58.046682', '1979-11-05 09:01:58.046682', 'j', 'j'),(6, 0, NULL, NULL, NULL, NULL, '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'u', 'u'),(7, 7, '1976-02-01', '1976-02-01', '08:12:54.047455', '08:12:54.047455', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'r', 'r'),(2, 2, '2009-10-16', '2009-10-16', '00:00:00', '00:00:00', '1989-01-08 06:50:59.023013', '1989-01-08 06:50:59.023013', 'x', 'x'),(2, 8, '2005-09-09', '2005-09-09', '16:21:16.061650', '16:21:16.061650', NULL, NULL, 'e', 'e'),(9, 8, '1900-01-01', '1900-01-01', '22:29:31.058874', '22:29:31.058874', '2029-07-01 19:38:23.047425', '2029-07-01 19:38:23.047425', 'i', 'i'),(198, NULL, '2031-08-08', '2031-08-08', '00:49:30.064187', '00:49:30.064187', NULL, NULL, 'q', 'q'),(9, 8, '2002-05-09', '2002-05-09', '20:22:47.037406', '20:22:47.037406', '2009-04-07 03:25:51.058231', '2009-04-07 03:25:51.058231', 'z', 'z'),(7, 3, '1900-01-01', '1900-01-01', '08:48:30.044928', '08:48:30.044928', '1900-01-01 00:00:00', '1900-01-01 00:00:00', 'k', 'k'),(99, 65, NULL, NULL, '00:00:00', '00:00:00', '1900-01-01 00:00:00', '1900-01-01 00:00:00', NULL, NULL) /* QNO 26 CON_ID 9 */; ( SELECT DISTINCT FOUND_ROWS() AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` ) ) /* QNO 6261 CON_ID 16 */ ) UNION ALL ( SELECT DISTINCT FOUND_ROWS() AS field1 FROM `dd` WHERE `col_datetime_key` HAVING BINARY -4642648265865560064 ORDER BY DES_ENCRYPT( 0, `col_varchar_nokey` ), BENCHMARK( 5, VAR_SAMP( `col_date_key` ) ) LIMIT 0 );