Parser LEFT something error

Eliarh's profile image Eliarh posted 8 years ago in General Permalink

before autoformat

SELECT CONCAT(LEFT(u.fio, LOCATE(" ", SUBSTRING_INDEX(u.fio," ",2))+1)) fio

after autoformat

SELECT CONCAT(
LEFT(u.fio, LOCATE(" ", SUBSTRING_INDEX(u.fio," ",2))+1)) fio
Eliarh's profile image Eliarh posted 5 years ago Permalink

up?

ansgar's profile image ansgar posted 5 years ago Permalink

What?

You should describe your problem more exactly. Noone wants to guess about the issue here.

Eliarh's profile image Eliarh posted 5 years ago Permalink

Why is the string wrapped? "LEFT "is a function, not"LEFT JOIN". In my opinion, the transfer should not be carried out.

ansgar's profile image ansgar posted 5 years ago Permalink

Yes, that's an issue in the quite simple pretty-print parser - it expects LEFT to be part of a JOIN.

It's probably worth to look for some external pretty-print library, which I can make use of in HeidiSQL's Delphi code. Do you know of some?

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