YuJue Li created IGNITE-25520:
---------------------------------
Summary: 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
Fix For: 2.18
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)
