delimiter in sql tab not working since version 12.12.0.7124

doctorcw's profile image doctorcw posted 4 weeks 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 3 weeks 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.