Discrepancy between Object View filter and SQL Commander : DbVis Software

a

anonymous

started a topic almost 12 years ago

[This topic is migrated from our old forums. The original author name has been removed]

Version 8.0.12

In the object view of table1 if a use a filter of
where col1 > '2012-01-01' and col2 = 'abc'
results in xxx rows

and in SQL Commander I use
select * from table1 where col1 > '2012-01-01' and col2 = 'abc'
results in yyy rows.

The object view has Max Rows set to -1. 

The SQL Commander result is about 25 more rows than the object view.

Why would the results be different?

Thanks

Dennis

Roger Bjärevall

said almost 12 years ago

[This reply is migrated from our old forums.]

Re: Discrepancy between Object View filter and SQL Commander

Dennis,

There should be no difference.

What database and driver are you using?

Regards

Roger

a

anonymous

said almost 12 years ago

[This reply is migrated from our old forums. The original author name has been removed]

Re: Discrepancy between Object View filter and SQL Commander

Hi Roger, 

The database is Ingres 9.2 and am using the generic driver with iijdbc. 

I think the issue was that there was some activity going on with the table in question, but I couldn't find definite evidence of that :-( 

Thanks 

Dennis

Roger Bjärevall

said almost 12 years ago

[This reply is migrated from our old forums.]

Re: Discrepancy between Object View filter and SQL Commander

Dennis,

Showing the data in the Data tab and running a select in the SQL Commander use the very same logic in DbVisualizer to obtain and present the result. Based on this, your idea of another sessions modifying the actual table seem most likely.

To verify what SQLs are running, enable debug of DbVisualizer in Tools->Debug Window.

Regards

Roger

How can we help you today?

Discrepancy between Object View filter and SQL Commander

anonymous

Roger Bjärevall

anonymous

Roger Bjärevall