Reformat SQL issue

roger-u's profile image roger-u posted 6 years ago in General Permalink

I had this as part of a longer SQL statement: LEFT JOIN ww_paynotes y ON p.semail = y.semail

but after using the Reformat SQL it becomes: LEFT JOIN ww_paynotes Y ON p.semail = y.semail

the alias letter y becomes uppercase - which can cause an error on Databasesdepending on their case sensitivity

it only seems to happen with the alias letter y e.g. LEFT JOIN ww_paynotes w ON p.semail = w.semail if not altered

HeidiSQL 8.0.0.4396

Please login to leave a reply, or register at first.