delimiter in sql tab not working since version 12.12.0.7124

doctorcw's profile image doctorcw posted 10 months ago in General Permalink

command delimiter in sql tab not working since version 12.12.0.7124

sql script like

delimiter $$ select 1$$ delimiter ; select 1;

is not working in last release

ansgar's profile image ansgar posted 10 months ago Permalink

Yeah, the $$ is reserved for quotes now. Was not aware people use it as a delimiter.

Such queries now work better since v12.13 (normally only used in PostgreSQL):

SELECT $$ this; is not the end $$ AS dollarquoted;

Please use a different delimiter, e.g. !! or some rarely used character.

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