[MDEV-12818] Inner join output is incorrect (extra row is returned) - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Incomplete
Affects Version/s: 10.2.4
Fix Version/s: N/A
Component/s: Data Manipulation - Subquery
Labels:
- need_feedback
Environment:
Windows 10

Description

1. ddl/dml is attached.
2. using server - MariaDB 10.2.4 RC
using client - version 1.5.9 (mariadb-java-client-1.5.9.jar)
3. incorrect results (extra row) for the below sql.

SELECT

    `T2`.`PNO`,

    `T1`.`SNO`,

    `T1`.`PNO`,

    `T1`.`QTY`

FROM

    `TPARTS` `T2`,

    `TPARTS` `T3`,

    SELECT

        `SNO`,

        `PNO`,

        `QTY`

    FROM

        `TSUPPLY`

    WHERE

        `SNO` = 'S1' AND

        `PNO` = 'P1'

    ) T1

WHERE

    `T2`.`PNO` = `T1`.`PNO` AND

    `T2`.`PNO` = `T3`.`PNO`

Expected results
PNO SNO PNO QTY
P1 S1 P1 200
P1 S1 P1 700

MariaDB results
PNO SNO PNO QTY
P1 S1 P1 200
P1 S1 P1 700
P1 S5 P1 100

Attachments

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

mariadb_ddl_dml.txt
2 kB
2017-05-16 17:48

Activity

People

Assignee:: Unassigned

Reporter:: Seong Yoon

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2017-05-16 17:49

Updated:: 2017-06-24 20:08

Resolved:: 2017-06-24 20:08

Git Integration

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