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.heat...@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 >
