Tabs in SQL queries...

[Matthew Newton]

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 at 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 at le.ac.uk>