MDEV-21445 update test results

followup for 57f5c319af8

1 files changed, 30 insertions, 2 deletions

diff --git a/mysql-test/suite/engines/iuds/r/insert_year.result b/mysql-test/suite/engines/iuds/r/insert_year.result
index c7a0dbcba86..8065f606aab 100644
--- a/mysql-test/suite/engines/iuds/r/insert_year.result
+++ b/mysql-test/suite/engines/iuds/r/insert_year.result
@@ -2224,6 +2224,7 @@ SELECT * FROM t3 WHERE c1 IN (69,'2020') ORDER BY c1,c2;
 c1	c2	c3	c4
 2020	2020	1998-12-16	1998-12-16 11:30:45
 2020	2040	1998-12-10	1998-12-10 11:30:45
+2069	2069	1998-12-13	1998-12-13 11:30:45
 SELECT * FROM t3 WHERE c1 IN (69,'2020') ORDER BY c1,c2 LIMIT 2;
 c1	c2	c3	c4
 2020	2020	1998-12-16	1998-12-16 11:30:45
@@ -2369,6 +2370,7 @@ SELECT * FROM t3 WHERE c1 IN (69,'2020') ORDER BY c1,c2 DESC;
 c1	c2	c3	c4
 2020	2040	1998-12-10	1998-12-10 11:30:45
 2020	2020	1998-12-16	1998-12-16 11:30:45
+2069	2069	1998-12-13	1998-12-13 11:30:45
 SELECT * FROM t3 WHERE c1 IN (69,'2020') ORDER BY c1,c2 DESC LIMIT 2;
 c1	c2	c3	c4
 2020	2040	1998-12-10	1998-12-10 11:30:45
@@ -4292,8 +4294,12 @@ SELECT * FROM t2 WHERE c2 BETWEEN '1970' AND 2155 ORDER BY c1,c2 LIMIT 2;
 c1	c2	c3	c4
 SELECT * FROM t2 WHERE c2 IN ('1970',2155) ORDER BY c1,c2;
 c1	c2	c3	c4
+70	70	1998-12-12	1998-12-12 11:30:45
+55	55	1998-12-26	1998-12-26 11:30:45
 SELECT * FROM t2 WHERE c2 IN ('1970',2155) ORDER BY c1,c2 LIMIT 2;
 c1	c2	c3	c4
+70	70	1998-12-12	1998-12-12 11:30:45
+55	55	1998-12-26	1998-12-26 11:30:45
 SELECT * FROM t2 WHERE c2 >= '1970' AND c2 < 2155 AND c1 = '1999' ORDER BY c1,c2;
 c1	c2	c3	c4
 SELECT * FROM t2 WHERE c2 >= '1970' AND c2 < 2155 AND c1 = '1999' ORDER BY c1,c2 LIMIT 2;
@@ -4429,8 +4435,12 @@ SELECT * FROM t2 WHERE c2 BETWEEN '1970' AND 2155 ORDER BY c1,c2 DESC LIMIT 2;
 c1	c2	c3	c4
 SELECT * FROM t2 WHERE c2 IN ('1970',2155) ORDER BY c1,c2 DESC;
 c1	c2	c3	c4
+70	70	1998-12-12	1998-12-12 11:30:45
+55	55	1998-12-26	1998-12-26 11:30:45
 SELECT * FROM t2 WHERE c2 IN ('1970',2155) ORDER BY c1,c2 DESC LIMIT 2;
 c1	c2	c3	c4
+70	70	1998-12-12	1998-12-12 11:30:45
+55	55	1998-12-26	1998-12-26 11:30:45
 SELECT * FROM t2 WHERE c2 >= '1970' AND c2 < 2155 AND c1 = '1999' ORDER BY c1,c2 DESC;
 c1	c2	c3	c4
 SELECT * FROM t2 WHERE c2 >= '1970' AND c2 < 2155 AND c1 = '1999' ORDER BY c1,c2 DESC LIMIT 2;
@@ -5212,10 +5222,13 @@ SELECT * FROM t3 WHERE c1 BETWEEN 69 AND '2020' ORDER BY c1,c2 LIMIT 2;
 c1	c2	c3	c4
 SELECT * FROM t3 WHERE c1 IN (69,'2020') ORDER BY c1,c2;
 c1	c2	c3	c4
+20	20	1998-12-16	1998-12-16 11:30:45
+20	40	1998-12-10	1998-12-10 11:30:45
 69	69	1998-12-13	1998-12-13 11:30:45
 SELECT * FROM t3 WHERE c1 IN (69,'2020') ORDER BY c1,c2 LIMIT 2;
 c1	c2	c3	c4
-69	69	1998-12-13	1998-12-13 11:30:45
+20	20	1998-12-16	1998-12-16 11:30:45
+20	40	1998-12-10	1998-12-10 11:30:45
 SELECT * FROM t3 WHERE c1 >= 69 AND c1 < '2020' AND c2 = '2009' ORDER BY c1,c2;
 c1	c2	c3	c4
 SELECT * FROM t3 WHERE c1 >= 69 AND c1 < '2020' AND c2 = '2009' ORDER BY c1,c2 LIMIT 2;
@@ -5344,10 +5357,13 @@ SELECT * FROM t3 WHERE c1 BETWEEN 69 AND '2020' ORDER BY c1,c2 DESC LIMIT 2;
 c1	c2	c3	c4
 SELECT * FROM t3 WHERE c1 IN (69,'2020') ORDER BY c1,c2 DESC;
 c1	c2	c3	c4
+20	40	1998-12-10	1998-12-10 11:30:45
+20	20	1998-12-16	1998-12-16 11:30:45
 69	69	1998-12-13	1998-12-13 11:30:45
 SELECT * FROM t3 WHERE c1 IN (69,'2020') ORDER BY c1,c2 DESC LIMIT 2;
 c1	c2	c3	c4
-69	69	1998-12-13	1998-12-13 11:30:45
+20	40	1998-12-10	1998-12-10 11:30:45
+20	20	1998-12-16	1998-12-16 11:30:45
 SELECT * FROM t3 WHERE c1 >= 69 AND c1 < '2020' AND c2 = '2009' ORDER BY c1,c2 DESC;
 c1	c2	c3	c4
 SELECT * FROM t3 WHERE c1 >= 69 AND c1 < '2020' AND c2 = '2009' ORDER BY c1,c2 DESC LIMIT 2;
@@ -5595,8 +5611,14 @@ c1	c2	c3	c4
 01	01	1998-12-31	1998-12-31 11:30:45
 SELECT * FROM t3 WHERE c2 IN ('2000',2155) ORDER BY c1,c2;
 c1	c2	c3	c4
+00	00	2008-01-08	2008-01-09 00:00:00
+00	00	1998-12-29	1998-12-29 11:30:45
+00	00	1998-12-26	1998-12-26 11:30:45
+55	55	1998-12-26	1998-12-26 11:30:45
 SELECT * FROM t3 WHERE c2 IN ('2000',2155) ORDER BY c1,c2 LIMIT 2;
 c1	c2	c3	c4
+00	00	2008-01-08	2008-01-09 00:00:00
+00	00	1998-12-29	1998-12-29 11:30:45
 SELECT * FROM t3 WHERE c2 >= '2000' AND c2 < 2155 AND c1 = '1999' ORDER BY c1,c2;
 c1	c2	c3	c4
 SELECT * FROM t3 WHERE c2 >= '2000' AND c2 < 2155 AND c1 = '1999' ORDER BY c1,c2 LIMIT 2;
@@ -5745,8 +5767,14 @@ c1	c2	c3	c4
 01	01	1998-12-31	1998-12-31 11:30:45
 SELECT * FROM t3 WHERE c2 IN ('2000',2155) ORDER BY c1,c2 DESC;
 c1	c2	c3	c4
+00	00	2008-01-08	2008-01-09 00:00:00
+00	00	1998-12-29	1998-12-29 11:30:45
+00	00	1998-12-26	1998-12-26 11:30:45
+55	55	1998-12-26	1998-12-26 11:30:45
 SELECT * FROM t3 WHERE c2 IN ('2000',2155) ORDER BY c1,c2 DESC LIMIT 2;
 c1	c2	c3	c4
+00	00	2008-01-08	2008-01-09 00:00:00
+00	00	1998-12-29	1998-12-29 11:30:45
 SELECT * FROM t3 WHERE c2 >= '2000' AND c2 < 2155 AND c1 = '1999' ORDER BY c1,c2 DESC;
 c1	c2	c3	c4
 SELECT * FROM t3 WHERE c2 >= '2000' AND c2 < 2155 AND c1 = '1999' ORDER BY c1,c2 DESC LIMIT 2;