Fw: Inconsistency in data selection. count*
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
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 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
developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list
On Mon, Jan 21, 2013 at 06:44:28PM +0100, Stefan Manegold wrote:
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
Tapomay,
My guess is that you created the data which now gives problems on a earlier version which had bugs. Now you recreated with a fresh db.
Could you try to, reload your data (from scratch) like you did on your new system, also on your old. Please let us know if the problems persists.
Niels
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 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
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) | _______________________________________________ developers-list mailing list developers-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list
participants (3)
-
Niels Nes
-
Stefan Manegold
-
Tapomay Dey