Hi, On Mon, Jul 23, 2012 at 11:40:30AM +0100, Phil Mayers wrote:
On 23/07/12 10:10, alan buxey wrote:
Hi,
What do people think to stripping out tabs in xlated SQL queries so that the debug output is actually readable?
why play with the queries? Why not just strip the space in the debug output - that way, you get
This is a safer approach IMO.
It's safer... until you find some (really unusual) SQL server that *does* for some unknown reason depend on tabs. At which point, your debugging output becomes rather useless :) At least if they're stripped while in use, if it breaks the debug output might have a hint at showing why. Alternative is to have a 'tidy_debug_sql_output' option, I guess. But should you selectively munge the debug output? Maybe better is a (default enabled) option 'tidy_sql_queries' option to selectively enable the tidy, so it can be disabled with the unknown wierd SQL server. At least that way the debug output is consistent. Cheers, Matthew -- Matthew Newton, Ph.D. <mcn4@le.ac.uk> Systems Architect (UNIX and Networks), Network Services, I.T. Services, University of Leicester, Leicester LE1 7RH, United Kingdom For IT help contact helpdesk extn. 2253, <ithelp@le.ac.uk>