That did the trick, thanks. On 04/27/15 14:16, Salnikov, Andrei A. wrote: > Hi John, > > it's easy to do, we have special "pragma comment" in sql for > integration test. "pragma noheader" will result in data being > dumped without headers, I guess this is what you need. For an > example check: > > datasets/case01/queries/1002_coneMagColor_noalias.sql > > Alternative is to define aliases for columns so that they are > named identically, but it does not work for select *. > > Cheers, > Andy > > John Gates wrote on 2015-04-27: >> Hi, >> >> I've got a simple integration test and I'm looking for a method to skip >> the first line of output when doing the diff. The 2 files are identical >> except for the first line with the column names >> >> qserv output: scienceCcdExposureId QS1_PASS >> mysql output: scienceCcdExposureId hex(poly) >> >> Is there a fairly simple way to do this? >> >> -John >> >> ######################################################################## >> 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