phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject Re: sqlline reporting 1 row affected when it isn't
Date Wed, 02 Sep 2015 13:57:37 GMT
Is not the output the number of lines of the delete command, which is one
line (the command itself) and not the number of deleted lines?

Can you try to put some rows into the table and do the delete again? Or try
without the where close too?

2015-09-02 9:54 GMT-04:00 James Heather <james.heather@mendeley.com>:

> Any idea why sqlline would report 1 row affected when I delete no rows?
>
> 0: jdbc:phoenix:172.xx.xx.xxx> create table names (id bigint(20) primary
> key, name varchar(20));
> No rows affected (1.158 seconds)
> 0: jdbc:phoenix:172.xx.xx.xxx> delete from names where id=1;
> 1 row affected (0.204 seconds)
> 0: jdbc:phoenix:172.xx.xx.xxx>
>
> James
>

Mime
View raw message