Discrepancy between Object View filter and SQL Commander
a
anonymous
started a topic
over 11 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
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
a
anonymous
said
over 11 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
over 11 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
anonymous