Hi Fabrice, Thanks for posting the query! mysql> SELECT s.ra, s.decl, o.raRange, o.declRange FROM Object o JOIN Source s USING (objectId) WHERE o.objectId = 390034570102582 AND o.latestObsTime = s.taiMidPoint; I note that there is no code for supporting the FROM ... JOIN ... USING ( ...) syntax. I started playing with it last month, but don't have anything I can merge--it's just not on the road map, even though I think that you all want it (there seem to be other things more pressing). I think SELECT s.ra, s.decl, o.raRange, o.declRange FROM Object o, Source s, where o.objectId = WHERE o.objectId = 390034570102582 AND o.objectId = s.objectId AND o.latestObsTime = s.taiMidPoint; should work, though I haven't tested it. If you'd like to have a look at the code I was playing with, it's on branch u/danielw/joinSyntax1 but it's now behind the shared scan code (which I hope to clean up to Serge's quality and merge soon) by a fair bit. -Daniel On 09/30/2013 08:38 AM, Fabrice Jammes wrote: > Hello Daniel, > > As told on Thursday, i've met several error on SQL queries wich works on > previous version (without qms and new parser). > I'm not sure if error come from the test procedure or from qserv new > version. > I propose to send it to you one by one with detailed log, instead of > sending the whole list (bugs may be fixed once and solve many queries). > > Here's one example for test case 01 : > > While connected to qserv : > > mysql> SELECT s.ra, s.decl, o.raRange, o.declRange FROM Object o > JOIN Source s USING (objectId) WHERE o.objectId = 390034570102582 > AND o.latestObsTime = s.taiMidPoint; > ERROR 4120 (Proxy): Error during execution: 'open failed for chunk(s): > 6801 6630 6800 7138 7308 6970 6971 6968 6631 7140read failed for > chunk(s): 7478 7648 7310' > > xrootd and qserv-master logs are attached and it seems the errors are > reported in xrootd.log with SQL sentence like this one : > > >>Unknown column 's.ra' in 'field list' 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; > <<---Error with piece 0 complete (size=1). > > Indeed it seems table Source should be in FROM clause, aliased with 's' ? > > I can of course give you more information if needed. > > Thanks, > > Fabrice ######################################################################## 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