[MDEV-17747] engines/iuds.update_delete_number and engines/iuds.insert_number fail in buildbot with wrong result Created: 2018-11-16  Updated: 2018-11-16  Resolved: 2018-11-16

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.3
Fix Version/s: 10.3.11, 10.4.1, 10.1.38, 5.5.63, 10.0.38, 10.2.20

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-17724 Wrong result for BETWEEN 0 AND 184467... Closed

 Description   

engines/iuds.update_delete_number 'innodb' w1 [ fail ]
        Test ended at 2018-11-15 21:37:34
 
CURRENT_TEST: engines/iuds.update_delete_number
--- /mnt/buildbot/build/mariadb-10.3.11/mysql-test/suite/engines/iuds/r/update_delete_number.result	2018-11-15 20:08:37.000000000 +0300
+++ /mnt/buildbot/build/mariadb-10.3.11/mysql-test/suite/engines/iuds/r/update_delete_number.reject	2018-11-16 05:37:33.741603173 +0300
@@ -3767,8 +3767,25 @@
 -12	18446744073709551615	12
 SELECT * FROM t2 WHERE c2 BETWEEN 0 AND 18446744073709551615 ORDER BY c2,c1;
 c1	c2	c3
+-4	4	4
+-9	9	9
+0	255	13
+-9223372036854775808	18446744073709551615	12
+-12	18446744073709551615	12
+-11	18446744073709551615	11
+-8	18446744073709551615	8
+-7	18446744073709551615	7
+-6	18446744073709551615	6
+-5	18446744073709551615	5
+-3	18446744073709551615	3
+-2	18446744073709551615	2
+-1	18446744073709551615	1
+50	18446744073709551615	10
+9223372036854775807	18446744073709551615	14
 SELECT * FROM t2 WHERE c2 BETWEEN 0 AND 18446744073709551615 ORDER BY c2,c1 DESC LIMIT 2;
 c1	c2	c3
+-4	4	4
+-9	9	9
 SELECT * FROM t2 WHERE c2 IN(0,18446744073709551615) ORDER BY c2,c1 DESC;
 c1	c2	c3
 9223372036854775807	18446744073709551615	14

I suppose it's related to MDEV-17724 bugfix and result files need to be updated, although I didn't look deep into the failures.



 Comments   
Comment by Alexander Barkov [ 2018-11-16 ]

A fix for this problem was pushed into 5.5:

commit 1956695c69467375fc634ad709f1b32a2daf29b1
Author: Alexander Barkov <bar@mariadb.com>
Date:   Thu Nov 15 16:45:43 2018 +0400
 
    MDEV-17724 Wrong result for BETWEEN 0 AND 18446744073709551615
    
    The fix for "MDEV-17698 MEMORY engine performance regression"
    previously fixed this problem.
    
    - Adding the test for MDEV-17724
    - Re-recording wrong results for tests:
      * engines/iuds/r/insert_number
      * engines/iuds/r/update_delete_number
      which started to fail since MDEV-17698

Generated at Thu Feb 08 08:38:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.