[MDEV-11640] gcol.gcol_select_myisam fails in buildbot on Power - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL)
Fix Version/s: 10.2.4
Component/s: Platform Power, Tests, Virtual Columns
Labels:
None

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

@@ -680,9 +677,27 @@

-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

@@ -772,9 +784,27 @@

-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

Attachments

Issue Links

causes

MDEV-12580 Wrong query result in join when using an index (Version > "10.2.3")

Closed

relates to

MDEV-7069 Fix buildbot failures in main server trees

Closed

MDEV-11525 Assertion `cp + len <= buff + buff_size' failed in JOIN_CACHE::write_record_data

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2016-12-22 23:22

Elena Stepanova made changes - 2016-12-22 23:22

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-7069~~ [ ~~MDEV-7069~~ ]

Sergei Golubchik made changes - 2017-02-07 09:01

Status

Open [ 1 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2017-02-07 09:01

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Sergei Golubchik added a comment - 2017-02-07 09:38

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.

Sergei Golubchik added a comment - 2017-02-07 09:38 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.

Sergei Golubchik made changes - 2017-02-07 09:38

Assignee	Sergei Golubchik [ serg ]	Sergei Petrunia [ psergey ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Sergei Golubchik made changes - 2017-02-08 19:15

Link

This issue relates to ~~MDEV-11525~~ [ ~~MDEV-11525~~ ]

Daniel Black added a comment - 2017-02-13 03:08

Thanks serg

Daniel Black added a comment - 2017-02-13 03:08 Thanks serg

Sergei Golubchik made changes - 2017-02-13 16:31

Fix Version/s		10.2.4 [ 22116 ]
Fix Version/s	10.2 [ 14601 ]
Resolution		Fixed [ 1 ]
Status	In Review [ 10002 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2017-05-06 11:54

Link

This issue causes ~~MDEV-12580~~ [ ~~MDEV-12580~~ ]

Sergei Golubchik made changes - 2021-12-06 21:44

Workflow

MariaDB v3 [ 78873 ]

MariaDB v4 [ 151428 ]

People

Assignee:: Sergei Petrunia

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2016-12-22 23:22

Updated:: 2017-05-06 11:54

Resolved:: 2017-02-13 16:31

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server