[MDEV-11640] gcol.gcol_select_myisam fails in buildbot on Power Created: 2016-12-22  Updated: 2017-05-06  Resolved: 2017-02-13

Status: Closed
Project: MariaDB Server
Component/s: Platform Power, Tests, Virtual Columns
Affects Version/s: 10.2
Fix Version/s: 10.2.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
causes MDEV-12580 Wrong query result in join when using... Closed
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled
relates to MDEV-11525 Assertion `cp + len <= buff + buff_si... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/p8-xenial-bintar/builds/469/steps/test/logs/stdio

gcol.gcol_select_myisam                  w4 [ fail ]
 
        Test ended at 2016-12-22 08:48:16
 
 
 
CURRENT_TEST: gcol.gcol_select_myisam
 
--- /var/lib/buildbot/maria-slave/p8-xenial-bintar/build/mysql-test/suite/gcol/r/gcol_select_myisam.result	2016-12-22 04:38:05.794627327 -0500
 
+++ /var/lib/buildbot/maria-slave/p8-xenial-bintar/build/mysql-test/suite/gcol/r/gcol_select_myisam.reject	2016-12-22 08:48:16.771497594 -0500
 
@@ -598,11 +598,8 @@
 
 (subquery2_t3.col_varchar_key = subquery2_t2.col_varchar_key))
 
 ORDER BY subquery2_field1;
 
 subquery2_field1
 
-1
 
-1
 
-1
 
-1
 
-1
 
+0
 
+0
 
 1
 
 1
 
 1
 
@@ -680,9 +677,27 @@
 
 8
 
 8
 
 8
 
-9
 
-9
 
-24
 
+42
 
+42
 
+43
 
+10956
 
+11020
 
+11020
 
+16383
 
+65537
 
+65537
 
+65537
 
+65537
 
+65537
 
+4194120
 
+4194120
 
+4194158
 
+4194158
 
+4194158
 
+15597837
 
+1124007936
 
+1124007936
 
+1667433215
 
 SELECT subquery2_t2.col_int_key AS subquery2_field1
 
 FROM (c AS subquery2_t1 RIGHT JOIN
 
 (c AS subquery2_t2 LEFT JOIN cc AS subquery2_t3 ON
 
@@ -690,11 +705,8 @@
 
 (subquery2_t3.col_varchar_key = subquery2_t2.col_varchar_key))
 
 ORDER BY subquery2_field1;
 
 subquery2_field1
 
-1
 
-1
 
-1
 
-1
 
-1
 
+0
 
+0
 
 1
 
 1
 
 1
 
@@ -772,9 +784,27 @@
 
 8
 
 8
 
 8
 
-9
 
-9
 
-24
 
+42
 
+42
 
+43
 
+10956
 
+11020
 
+11020
 
+16383
 
+65537
 
+65537
 
+65537
 
+65537
 
+65537
 
+4194120
 
+4194120
 
+4194158
 
+4194158
 
+4194158
 
+15597837
 
+1124007936
 
+1124007936
 
+1667433215
 
 DROP TABLE c,cc;
 
 #
 
 # Bug#2081065: WL8149:RESULT DIFF SEEN FOR SIMPLE
 
 
 
mysqltest: Result length mismatch



 Comments   
Comment by Sergei Golubchik [ 2017-02-07 ]

It's in bb-10.2-serg branch.

The whole work is 14 commits:

8884b88a131 MDEV-11640 gcol.gcol_select_myisam fails in buildbot on Power
 
c2af490a5a2 support keyread in READ_RECORD
 
9e5f32b2596 bugfix: disable ICP in InnoDB for indexes on virtual columns
 
93a79cb992d cleanup: make a couple of tests more robust
 
861c321c683 cleanup: handler::key_read
 
a4d8cea6c71 find_all_keys: add an assert, remove current_thd
 
daa7f067e23 cleanup: TABLE::mark_columns_used_by_index()
 
3843d2a6cb4 bugfix: don't calculate vcols if doing keyread
 
79aae4959c5 cleanup: remove TABLE::add_read_columns_used_by_index
 
913ee351fa8 bugfix: TABLE::mark_columns_used_by_index_no_reset
 
42758c859d9 cleanup: mark_columns_used_by_index_no_reset in handler::get_auto_increment
 
9d908a7feee cleanup: mark_columns_used_by_index_no_reset in opt_range.cc
 
ac5f247dd9f bugfix: TABLE::mark_columns_used_by_index
 
22b9c311ecf cleanup: style fixes, sql_join_cache.cc

The last one (with MDEV-11640 in the comment) is the actual fix, others introduce necessary code changes and fix bugs that show themselves after the main fix.

Comment by Daniel Black [ 2017-02-13 ]

Thanks serg

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