Filtering in Result Sets

Toad Data Point & Toad Intelligence Central
1

Version 5.0.4.45 (32 bit)

Ran a small query, then filtered the results by clicking on the filter icon for the desired column. The data type of the TIME_BOX_SHIPPED column is NUMBER(6). I set the filter to be greater than 230000, but now one of the results does not meet this criteria. How can a record with a value of 82606 be included in the results?

The attached image shows the result set after applying the filter, the table being accessed, and the column data type that was filtered.

It's like the filter is being applied as if the data was text, i.e., text beginning with an '8' would be greater than '230000'?

FilterBug
FilterBug.JPG913×457 115 KB

2

I am able to reproduce as well. This appears to be a bug. Dev Team, please take note and log.

3

Thanks for verifying the issue Gary. I entered QAT-14948 for this. In our next release we have upgraded the grid control so maybe we will get a fix for free...I don't have time to check right now. Sorry

4

Good day,

Checking to see if this bug has been addressed. I'm running Toad Data Point 5.1.6.206 (64 bit) and am still encountering this issue.

Thanks