Forwarding to dev forum. Not appropriate for user list.
----- Forwarded Message ----- From: Tapomay Dey tapomay@yahoo.com To: Communication channel for Monet DB users users-list@monetdb.org Sent: Monday, January 21, 2013 2:39 PM Subject: Inconsistency in data selection. count*
select count(*) from table;
Results: 168466 rows select count(*) from table where column=0;
Results: 168466 rows select count(*) from table where column<>0;
Results: 168466 rows
When I do a "select column from table where client_id=0 limit 5;" I see correct non-zero values in the result although the selection condition is that the column value must be 0. I put the data on another instance/machine - I don't see this issue.
Plz find a screenshot@ https://picasaweb.google.com/115470548136322675830/January212013?authuser=0&...
Another case: sql>select count(*) from table2 where column2=0; | 391326 |
sql>select count(*) from table2 where column2<>0;
| 141108 | sql>select count(*) from table2;
| 399326 |
sql>select column2 from table2 where column2=0 limit 5; +-----------+ | column2 | +===========+ | 53 | | 53 | | 53 | | 53 | | 53 | +-----------+ 5 tuples (156.631ms)
Regards, Tapomay _______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list