Login Register Actian.com  

Actian Community Forum


Go Back   Actian Community Forums > Vectorwise > Vectorwise Discussion
 

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
Old 2012-07-19   #1 (permalink)
Junior Member
 
Join Date: Jun 2012
Posts: 5
Default Avg on count - rewriter error

Code:
drop table if exists simple_test;
create table simple_test (
val integer
) with structure = vectorwise;

insert into simple_test values (1);

select avg(cnt)
from (
select count(val) cnt from simple_test
) a;
\g
This sql produces "rewrite error"
mzak is offline   Reply With Quote
Old 2012-07-20   #2 (permalink)
Ingres Community
 
Join Date: Mar 2007
Posts: 55
Default

Hi,

I have recreated the problem and will make sure that this is sent to the development team.

Cheers,
Dean
verde02 is offline   Reply With Quote

Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


© 2011 Actian Corporation. All Rights Reserved