You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Alexander Lapin (Jira)" <ji...@apache.org> on 2019/10/21 16:01:00 UTC
[jira] [Created] (IGNITE-12311) DELETE by PK doesn't work if PK is
TINYINT or SMALLINT.
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)