[MDEV-11145] [Draft] Wrong result 10.0 Created: 2016-10-26  Updated: 2016-10-26  Resolved: 2016-10-26

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/win-rqg-se/builds/2794/steps/rqg_opt_comparison/logs/stdio

########### Mismatches in E:\buildbot\bbwin1\win-rqg-se\build\..\..\..\vardirs\10.0-2794\optim-comparison\trial1.log ###
 
#------------------------------
E:\buildbot\bbwin1\win-rqg-se\build\..\..\..\vardirs\10.0-2794\optim-comparison\trial1.log, line 162, found length mismatch between servers:
SELECT alias1.`col_year_not_null` AS field1 FROM table20_innodb_utf8 AS alias1 LEFT JOIN table0_innodb_latin1 AS alias2 ON alias1.`col_varchar_1_not_null` = alias2.`col_varchar_64_null` LEFT JOIN table20_innodb_latin1 AS alias3 ON alias1.`col_int_null` = alias3.`col_int_unsigned_null` WHERE alias1.`col_smallint_null` <> 9 ORDER BY field1 ASC  /* QUERY_NO 837 CON_ID 11 */ 
 
# 2016-10-25T20:34:46 [-1248] --- C:\Users\ostc\AppData\Local\Temp\/randgen1248-1477427685-server0.dump	2016-10-25 20:34:45.985803900 +0000
# 2016-10-25T20:34:46 [-1248] +++ C:\Users\ostc\AppData\Local\Temp\/randgen1248-1477427685-server1.dump	2016-10-25 20:34:45.985803900 +0000
# 2016-10-25T20:34:46 [-1248] @@ -4,15 +4,87 @@
# 2016-10-25T20:34:46 [-1248]  0000
# 2016-10-25T20:34:46 [-1248]  0000
# 2016-10-25T20:34:46 [-1248]  0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +0000
# 2016-10-25T20:34:46 [-1248] +1997
# 2016-10-25T20:34:46 [-1248] +1997
# 2016-10-25T20:34:46 [-1248] +1997
# 2016-10-25T20:34:46 [-1248]  1997
# 2016-10-25T20:34:46 [-1248] +1997
# 2016-10-25T20:34:46 [-1248] +2001
# 2016-10-25T20:34:46 [-1248] +2001
# 2016-10-25T20:34:46 [-1248] +2001
# 2016-10-25T20:34:46 [-1248] +2001
# 2016-10-25T20:34:46 [-1248] +2001
# 2016-10-25T20:34:46 [-1248] +2001
# 2016-10-25T20:34:46 [-1248] +2001
# 2016-10-25T20:34:46 [-1248] +2001
# 2016-10-25T20:34:46 [-1248]  2001
# 2016-10-25T20:34:46 [-1248]  2001
# 2016-10-25T20:34:46 [-1248]  2002
# 2016-10-25T20:34:46 [-1248] +2002
# 2016-10-25T20:34:46 [-1248] +2002
# 2016-10-25T20:34:46 [-1248] +2002
# 2016-10-25T20:34:46 [-1248] +2002
# 2016-10-25T20:34:46 [-1248] +2003
# 2016-10-25T20:34:46 [-1248] +2003
# 2016-10-25T20:34:46 [-1248] +2003
# 2016-10-25T20:34:46 [-1248] +2003
# 2016-10-25T20:34:46 [-1248] +2003
# 2016-10-25T20:34:46 [-1248]  2003
# 2016-10-25T20:34:46 [-1248]  2003
# 2016-10-25T20:34:46 [-1248] +2003
# 2016-10-25T20:34:46 [-1248] +2003
# 2016-10-25T20:34:46 [-1248] +2003
# 2016-10-25T20:34:46 [-1248] +2004
# 2016-10-25T20:34:46 [-1248] +2004
# 2016-10-25T20:34:46 [-1248] +2004
# 2016-10-25T20:34:46 [-1248] +2004
# 2016-10-25T20:34:46 [-1248] +2004
# 2016-10-25T20:34:46 [-1248] +2004
# 2016-10-25T20:34:46 [-1248]  2004
# 2016-10-25T20:34:46 [-1248]  2004
# 2016-10-25T20:34:46 [-1248]  2004
# 2016-10-25T20:34:46 [-1248] +2004
# 2016-10-25T20:34:46 [-1248] +2004
# 2016-10-25T20:34:46 [-1248] +2004
# 2016-10-25T20:34:46 [-1248] +2004
# 2016-10-25T20:34:46 [-1248] +2004
# 2016-10-25T20:34:46 [-1248] +2004
# 2016-10-25T20:34:46 [-1248] +2006
# 2016-10-25T20:34:46 [-1248] +2006
# 2016-10-25T20:34:46 [-1248] +2006
# 2016-10-25T20:34:46 [-1248]  2006
# 2016-10-25T20:34:46 [-1248]  2006
# 2016-10-25T20:34:46 [-1248] +2006
# 2016-10-25T20:34:46 [-1248] +2006
# 2016-10-25T20:34:46 [-1248] +2006
# 2016-10-25T20:34:46 [-1248] +2006
# 2016-10-25T20:34:46 [-1248] +2006
# 2016-10-25T20:34:46 [-1248] +2008
# 2016-10-25T20:34:46 [-1248] +2008
# 2016-10-25T20:34:46 [-1248] +2008
# 2016-10-25T20:34:46 [-1248] +2008
# 2016-10-25T20:34:46 [-1248]  2008



 Comments   
Comment by Elena Stepanova [ 2016-10-26 ]

False positive, the test does updates it shouldn't be doing.

Generated at Thu Feb 08 07:47:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.