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)
