You can add it to the shared scan ticket. It's the aggregation handling code that I played with on Friday. It's probably a trivial amount of code, once you understand how that code is supposed to work in order to do the right thing when your select list has a mix of aggregate and non aggregate. You have to tweak it to not do the alias when there is no aggregation without breaking the other parts.

-Daniel

-------- Original message --------
From: Jacek Becla <[log in to unmask]>
Date: 09/19/2013 9:25 PM (GMT-06:00)
To: qserv-l <[log in to unmask]>
Subject: [QSERV-L] "SELECT * AS name"

Daniel

When I run a query like:

select * from Object where iRadius_SG between 0.02702 AND 0.029

your latest shared scans code is generating:

SELECT * AS QS1_PASS
FROM LSST.Object_6797 AS QST_1_
WHERE iRadius_SG BETWEEN 0.02702 AND 0.029

This is an invalid query, we can't do
"SELECT * AS someName"

Do you want me to open a ticket for that or it is trivial
to fix and you'll do it under the existing ticket?

thanks
Jacek

P.S. I can get around it, not urgent, enjoy your vacations...

########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1

Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1