[
https://issues.apache.org/jira/browse/IGNITE-25520?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-25520:
----------------------------------------
Fix Version/s: 2.19
(was: 2.18)
> When configuring the PARALLELISM parameter, the SQL query result is incorrect
> -----------------------------------------------------------------------------
>
> Key: IGNITE-25520
> URL: https://issues.apache.org/jira/browse/IGNITE-25520
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.17
> Reporter: YuJue Li
> Priority: Major
> Fix For: 2.19
>
>
> Execute the following script and you will see 2 records returned, but the
> correct result is only one record.
> {color:#739eca}CREATE{color} {color:#739eca}TABLE{color}
> {color:#b788d3}City{color} (
> {color:#00b8b8}ID{color} {color:#739eca}INT{color},
> {color:#00b8b8}Name{color} {color:#c1aa6c}VARCHAR{color},
> {color:#00b8b8}CountryCode{color}
> {color:#c1aa6c}CHAR{color}({color:#c0c0c0}3{color}),
> {color:#00b8b8}District{color} {color:#c1aa6c}VARCHAR{color},
> {color:#00b8b8}Population{color} {color:#739eca}INT{color},
> {color:#739eca}PRIMARY{color} {color:#739eca}KEY{color}
> ({color:#00b8b8}ID{color}, {color:#00b8b8}CountryCode{color})
> ) {color:#739eca}WITH{color} {color:#c1aa6c}"template=partitioned,
> affinity_Key=CountryCode,CACHE_NAME=City,PARALLELISM=8"{color}{color:#eecc64};{color}
>
> {color:#739eca}INSERT{color} {color:#739eca}INTO{color}
> {color:#b19b9b}City{color}({color:#9e9e9e}ID{color},
> {color:#9e9e9e}Name{color}, {color:#9e9e9e}CountryCode{color},
> {color:#9e9e9e}District{color}, {color:#9e9e9e}Population{color})
> {color:#739eca}VALUES{color}
> ({color:#c0c0c0}1{color},{color:#cac580}'Kabul'{color},{color:#cac580}'AFA'{color},{color:#cac580}'Kabol'{color},{color:#c0c0c0}1780000{color}){color:#eecc64};{color}
> {color:#739eca}INSERT{color} {color:#739eca}INTO{color}
> {color:#b19b9b}City{color}({color:#9e9e9e}ID{color},
> {color:#9e9e9e}Name{color}, {color:#9e9e9e}CountryCode{color},
> {color:#9e9e9e}District{color}, {color:#9e9e9e}Population{color})
> {color:#739eca}VALUES{color}
> ({color:#c0c0c0}1{color},{color:#cac580}'Kabul'{color},{color:#cac580}'AFG'{color},{color:#cac580}'Kabol'{color},{color:#c0c0c0}1780000{color}){color:#eecc64};{color}
> {color:#739eca}INSERT{color} {color:#739eca}INTO{color}
> {color:#b19b9b}City{color}({color:#9e9e9e}ID{color},
> {color:#9e9e9e}Name{color}, {color:#9e9e9e}CountryCode{color},
> {color:#9e9e9e}District{color}, {color:#9e9e9e}Population{color})
> {color:#739eca}VALUES{color}
> ({color:#c0c0c0}2{color},{color:#cac580}'Qandahar'{color},{color:#cac580}'AFG'{color},{color:#cac580}'Qandahar'{color},{color:#c0c0c0}237500{color}){color:#eecc64};{color}
> {color:#739eca}INSERT{color} {color:#739eca}INTO{color}
> {color:#b19b9b}City{color}({color:#9e9e9e}ID{color},
> {color:#9e9e9e}Name{color}, {color:#9e9e9e}CountryCode{color},
> {color:#9e9e9e}District{color}, {color:#9e9e9e}Population{color})
> {color:#739eca}VALUES{color}
> ({color:#c0c0c0}3{color},{color:#cac580}'Herat'{color},{color:#cac580}'AFG'{color},{color:#cac580}'Herat'{color},{color:#c0c0c0}186800{color}){color:#eecc64};{color}
> {color:#739eca}INSERT{color} {color:#739eca}INTO{color}
> {color:#b19b9b}City{color}({color:#9e9e9e}ID{color},
> {color:#9e9e9e}Name{color}, {color:#9e9e9e}CountryCode{color},
> {color:#9e9e9e}District{color}, {color:#9e9e9e}Population{color})
> {color:#739eca}VALUES{color}
> ({color:#c0c0c0}4{color},{color:#cac580}'Mazar-e-Sharif'{color},{color:#cac580}'AFG'{color},{color:#cac580}'Balkh'{color},{color:#c0c0c0}127800{color}){color:#eecc64};{color}
>
> {color:#cccccc}{color:#739eca}SELECT{color} * {color:#739eca}FROM{color}
> {color:#b19b9b}city{color} {color:#739eca}WHERE{color}
> {color:#9e9e9e}id{color} {color:#739eca}IN{color}
> ({color:#739eca}SELECT{color} {color:#9e9e9e}id{color}
> {color:#739eca}FROM{color} {color:#b19b9b}city{color}
> {color:#739eca}ORDER{color} {color:#739eca}BY{color} {color:#9e9e9e}id{color}
> {color:#739eca}DESC{color} {color:#739eca}LIMIT{color}
> {color:#c0c0c0}1{color}){color:#eecc64};{color}{color}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
