[sqlite] 'Misuse of aggregate' reported in subquery which works as a query

[Simon Davies]

Hi All,

Is this expected behaviour (pre-compiled windows binary)?

SQLite version 3.4.2
Enter ".help" for instructions
create table monthNames( shortName TEXT, longName TEXT );
insert into monthNames values( 'Jan', 'January' );
insert into monthNames values( 'Feb', 'February' );
insert into monthNames values( 'Mar', 'March' );
insert into monthNames values( 'Apr', 'April' );
insert into monthNames values( 'May', 'May' );
insert into monthNames values( 'Jun', 'June' );
insert into monthNames values( 'Jul', 'July' );
insert into monthNames values( 'Aug', 'August' );
insert into monthNames values( 'Sep', 'September' );
insert into monthNames values( 'Oct', 'October' );
insert into monthNames values( 'Nov', 'November' );
insert into monthNames values( 'Dec', 'December' );

create table data( event integer, startDate real, endDate real );
insert into data values( 1, julianday( 'now' ), julianday( 'now' ) + 30 );
insert into data values( 1, julianday( 'now' )+10, julianday( 'now' ) + 40 );
insert into data values( 2, julianday( 'now' )+20, julianday( 'now' ) + 50 );
insert into data values( 2, julianday( 'now' )+30, julianday( 'now' ) + 60 );
insert into data values( 1, julianday( 'now' )+40, julianday( 'now' ) + 70 );
insert into data values( 3, julianday( 'now' )+50, julianday( 'now' ) + 80 );

--
--  This query works
--
select min( startDate ) as sDate, max( endDate ) as eDate from
                        data where event=2;
--
--  Misuse of aggregate reported here
--
select
        strftime( '%d-', sDate ) ||
        (select shortName from monthNames where
                rowid=cast( strftime( '%m', sdate ) as integer)) ||
        strftime( '-%Y', sDate ) from
                (select min( startDate ) as sDate,
                        max( endDate ) as eDate
                                from data where event=2);

Rgds,
Simon

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------