Tabs in SQL queries...
mcn4 at leicester.ac.uk
Mon Jul 23 12:49:04 CEST 2012
On Mon, Jul 23, 2012 at 11:40:30AM +0100, Phil Mayers wrote:
> On 23/07/12 10:10, alan buxey wrote:
> >>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
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>
More information about the Freeradius-Devel