 |
 |
Hello Daniel and Jacek, Indeed there is no Source table in the queries rewrited by Qserv, but this Source table was present in the original query submitted to mysql-proxy. The bug may be in the query rewriting ? I've build a web page : http://datasky.in2p3.fr/qserv/newparser/html/ with more detailed information than in my previous email. I've added here information for case01/0004_lightCurve.sql <http://datasky.in2p3.fr/qserv/newparser/html/#id4> which also fails. I'll add soon information about other failing queries in test datasets. Thanks, Fabrice On 09/30/2013 05:47 PM, Jacek Becla wrote: > There is no Source table in that query, yet it > references s.taiMidPpoint, s.ra, s.decl > > On 09/30/2013 08:38 AM, Fabrice Jammes wrote: >> Unable to execute query: > CREATE TABLE r_1e01fa2d9ea14d542987c2af43bb3645f_7478_0 > SELECT s.ra,s.decl,o.raRange,o.declRange > FROM LSST.Object_7478 AS o > WHERE o.objectId=390034570102582 > AND o.latestObsTime=s.taiMidPoint > > ######################################################################## 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