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