Bug #78283 null data return when select+join

• Submitted: 31 Aug 2015 8:32
• Modified: 30 Sep 2015 10:10
• Reporter: David Feng
• Status: No Feedback
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.6.25
• OS: MacOS
• CPU Architecture: Any

[31 Aug 2015 8:32] David Feng

Description:
I'd like to select fields from one table and join fields from another.
it returns rows as expected, but get all null columns from the right table.

It is ok when run same sql on other mysql server (5.1.73 on Centos).

OS: Mac OS X Yosemite
Client : phpMyAdmin

How to repeat:
run similar sql 

select ev.id,ev.title, ev.event_date,tbl.*
from registrants as tbl
left join eb_events AS ev ON tbl.event_id = ev.id
where 1
order by tbl.id

[31 Aug 2015 10:10] MySQL Verification Team

Please provide a test case (create table/insert data, query with real result and expected result). Thanks.

[1 Oct 2015 1:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".