Re: sqlline reporting 1 row affected when it isn't

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

Re: sqlline reporting 1 row affected when it isn't

https://issues.apache.org/jira/browse/PHOENIX-2223 James On 02/09/15 15:09, Jean-Marc Spaggiari wrote: Yep, now I can only totally agree with you. I think you should open a JIRA. 2015-09-02 10:05 GMT-04:00 James Heather >:

Re: sqlline reporting 1 row affected when it isn't

I think this is enough to demonstrate that there's an issue. Deleting without the 'where' clause returns (correctly) no rows affected when there's nothing there. Using a '<=' operator in the 'where' clause seems to report the right values (2 when it deletes 2 rows, 0 when it deletes 0 rows).