Re: Fw: Inconsistency in data selection. count*

Tapomay, what exactly is / are all the differences between the two versions / instances? Hardware, OS, compiler, MonetDB version, way the data is loaded/modified, etc. Stefan On Mon, Jan 21, 2013 at 06:28:14AM -0800, Tapomay Dey wrote:

Forwarding to dev forum. Not appropriate for user list.

----- Forwarded Message ----- From: Tapomay Dey To: Communication channel for Monet DB users 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&authkey=Gv1sRgCIDllbOOmqDqOQ&feat=directlink

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

_______________________________________________ developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |