History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: HSCALE-22
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Peter Romianowski
Reporter: Peter Romianowski
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
HSCALE

Full partition scan does not work when functions are used

Created: 16/Apr/08 10:39 PM   Updated: 20/Apr/08 08:02 PM
Component/s: Query Analyzer
Affects Version/s: None
Fix Version/s: 0.2


 Description  « Hide
This does not work:

SELECT COUNT( * ) FROM table;

We don't want to handle queries like this.

 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
Peter Romianowski - 20/Apr/08 08:02 PM
Absolutely no function may be used if full partition scan. So these queries are not allowed:
{code}
SELECT COUNT(*) FROM table;

SELECT * FROM table WHERE somcolumn = ABS(someothercolumn);
{code}