False positive syntax highligh errors
Please fix these false positive syntax errors in dbForge Studio 2025.1.186 with PostgreSQL 15:
-- false positive syntax error on alias "dec" for type "decimal"
create temp table tmp (id int, d dec(18,2));
-- false positive syntax error on "nulls not distinct"
create index tmp_1 on tmp (id) nulls not distinct;
-- false positive syntax error on "with ties"
select * from tmp order by id fetch first 10 rows only with ties;
-- false positive syntax error on "fetch first" with variable
do $plpgsql$
declare _rows int = 1; _result int;
begin
select id into _result from tmp order by id fetch first _rows rows only;
end;
$plpgsql$;
1
vote
