<div class="gmail_quote">On Sat, Jun 30, 2012 at 11:44 PM, Andras Timar <<a href="mailto:timar74@gmail.com" target="_blank">timar74@gmail.com</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> Hi, 2012/6/30 Phil Hart <<a href="mailto:html.wallah@gmail.com">html.wallah@gmail.com</a>>: <div class="im">> Hello LibreOffice, > > Please find attached a patch for bug 51497. > </div>When I add an ORDER BY clause to a query, the value of the column that I order by is added to the output row. Why? Best regards, Andras </blockquote></div> Hello Andras, I have reproduced the behaviour here. The simple answer is that it is because the underlying database engine returns it as part of the row. My patch is extremely dumb: it displays *everything* that it finds in the row in the order returned to it by the DB engine. The patch is dumb by design: I wanted to see the data that the DB engine returns in as raw a form as possible. I hope this helps. Best regards, philhart