 |
 |
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