[MDEV-10461] Multiple left join, group by query returns wrong result type - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.0.26, 5.5(EOL), 10.0(EOL), 10.1(EOL)
Fix Version/s: 5.5.51, 10.1.17, 10.0.27, 10.2.2
Component/s: Optimizer
Labels:
None
Environment:
ubuntu

Description

The attached query run on the attached data file produces the following results:

*************************** 1. row ***************************

                     id: NULL

                      a: 0.0000

                      b: NULL

                      c: NULL

                      d: 0.00000

                      e: NULL

this_should_be_a_bigint: 2.3456

      what_it_should_be: 1

                      f: NULL

*************************** 2. row ***************************

                     id: NULL

                      a: 0.0000

                      b: NULL

                      c: NULL

                      d: 0.00000

                      e: NULL

this_should_be_a_bigint: 2.3456

      what_it_should_be: 1

                      f: NULL

*************************** 3. row ***************************

                     id: NULL

                      a: 0.0000

                      b: NULL

                      c: NULL

                      d: 0.00000

                      e: NULL

this_should_be_a_bigint: 2.3456

      what_it_should_be: 1

                      f: NULL

3 rows in set (0.00 sec)

Notice that the result column this_should_be_a_bigint returns a floating point number. This is wrong. The 2.3456 value suspiciously appears in an earlier column calculation in the query.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

data.sql
84 kB
2016-07-28 22:28
min-query.sql
1 kB
2016-07-28 22:28

Issue Links

duplicates

MDEV-10500 CASE/IF Statement returns multiple values and shifts further result values to the next column

Closed

Activity

People

Assignee:: Alexander Barkov

Reporter:: Crystal Lemire

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2016-07-28 22:30

Updated:: 2016-08-29 09:19

Resolved:: 2016-08-24 02:30

Git Integration

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