ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Lapin (Jira)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-12311) DELETE by PK doesn't work if PK is TINYINT or SMALLINT.
Date Mon, 21 Oct 2019 16:01:00 GMT
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)

Mime
View raw message