Alexander Lapin created IGNITE-12311: ----------------------------------------
Summary: DELETE by PK doesn't work if PK is TINYINT or SMALLINT. Key: IGNITE-12311 URL: https://issues.apache.org/jira/browse/IGNITE-12311 Project: Ignite Issue Type: Bug Reporter: Alexander Lapin 1. Start bin\ignite.bat 2. Start bin\sqlline.bat -d org.apache.ignite.IgniteJdbcThinDriver -u jdbc:ignite:thin://127.0.0.1/distributedJoins=true 3. Execute operations: {color:#172b4d}{{{color:#0052cc}0{color}: jdbc:ignite:thin://{color:#0052cc}127.0{color}{color:#0052cc}.0{color}{color:#0052cc}.1{color}/> create table t1 (a tinyint {color:#0052cc}null{color} primary key, b VARCHAR);{color:#6554c0}No{color} rows affected ({color:#0052cc}0{color},{color:#0052cc}198{color} seconds){color:#0052cc}0{color}: jdbc:ignite:thin://{color:#0052cc}127.0{color}{color:#0052cc}.0{color}{color:#0052cc}.1{color}/> insert into t1 values ({color:#0052cc}1{color}, {color:#36b37e}'a'{color});{color:#0052cc}1{color} row affected ({color:#0052cc}0{color},{color:#0052cc}036{color} seconds){color:#0052cc}0{color}: jdbc:ignite:thin://{color:#0052cc}127.0{color}{color:#0052cc}.0{color}{color:#0052cc}.1{color}/> select * from t1;+--------------------------------+--------------------------------+| {color:#6554c0}A{color} | {color:#6554c0}B{color} |+--------------------------------+--------------------------------+| {color:#0052cc}1{color} | a |+--------------------------------+--------------------------------+{color:#0052cc}1{color} row selected ({color:#0052cc}0{color},{color:#0052cc}048{color} seconds){color:#0052cc}0{color}: jdbc:ignite:thin://{color:#0052cc}127.0{color}{color:#0052cc}.0{color}{color:#0052cc}.1{color}/> update t1 set b = {color:#36b37e}'b'{color} where a={color:#0052cc}1{color};{color:#0052cc}1{color} row affected ({color:#0052cc}0{color},{color:#0052cc}018{color} seconds){color:#0052cc}0{color}: jdbc:ignite:thin://{color:#0052cc}127.0{color}{color:#0052cc}.0{color}{color:#0052cc}.1{color}/> select * from t1;+--------------------------------+--------------------------------+| {color:#6554c0}A{color} | {color:#6554c0}B{color} |+--------------------------------+--------------------------------+| {color:#0052cc}1{color} | b |+--------------------------------+--------------------------------+{color:#0052cc}1{color} row selected ({color:#0052cc}0{color},{color:#0052cc}006{color} seconds){color:#0052cc}0{color}: jdbc:ignite:thin://{color:#0052cc}127.0{color}{color:#0052cc}.0{color}{color:#0052cc}.1{color}/> delete from t1 where a={color:#0052cc}1{color};{color:#6554c0}No{color} rows affected ({color:#0052cc}0{color},{color:#0052cc}003{color} seconds){color:#0052cc}0{color}: jdbc:ignite:thin://{color:#0052cc}127.0{color}{color:#0052cc}.0{color}{color:#0052cc}.1{color}/> select * from t1;+--------------------------------+--------------------------------+| {color:#6554c0}A{color} | {color:#6554c0}B{color} |+--------------------------------+--------------------------------+| {color:#0052cc}1{color} | b |+--------------------------------+--------------------------------+{color:#0052cc}1{color} row selected ({color:#0052cc}0{color},{color:#0052cc}006{color} seconds){color:#0052cc}0{color}: jdbc:ignite:thin://{color:#0052cc}127.0{color}{color:#0052cc}.0{color}{color:#0052cc}.1{color}/>}}{color} Same behavoir is for SMALLINT type -- This message was sent by Atlassian Jira (v8.3.4#803005)