Fenoman · GitHub

После обновления на последнюю версию при синхронизации проекта и БД появляется данное окно с множеством ошибок, все они разделяются на несколько видов:

  1. jdbc:/ut/get_exceptions line 15:19 mismatched input ';' expecting '['
    если посмотреть на код функции:
DECLARE
	_B_Ret TEXT ARRAY;

а затем изменить так:

DECLARE
	_B_Ret TEXT[];

То ошибка уйдет. Исправить конечно можно, но их очень много.

  1. jdbc:/public/userid line 9:22 mismatched input 'FROM' expecting AT, OPERATOR, BETWEEN, ILIKE, IS, ISNULL, LIKE, NOTNULL, SIMILAR, AND, ... and 24 more
    если посмотреть код функции, то проблема тут:
BEGIN
RETURN usesysid::int FROM pg_user WHERE usename = CURRENT_USER;
END

Функция работает прекрасно, в чем тут ошибка не понятно.

  1. jdbc:/pe/app_subscr_pts_loading_cr line 589:2 extraneous input 'ANALYZE' expecting {ABORT, ABSOLUTE, ACCESS, ACTION, ADD, ADMIN, AFTER, AGGREGATE, ALSO, ALTER, ALWAYS, ASSERTION, ASSIGNMENT, AT, ATTACH, ATTRIBUTE, BACKWARD, BEFORE, BEGIN, BY, CACHE, CALL, CALLED, CASCADE, CASCADED, CATALOG, CHAIN, CHARACTERISTICS, CHECKPOINT, CLASS, CLOSE, CLUSTER, COLUMNS, COMMENT, COMMENTS, COMMIT, COMMITTED, CONFIGURATION, CONFLICT, CONNECTION, CONSTRAINTS, CONTENT, CONTINUE, CONVERSION, COPY, COST, CSV, CUBE, CURRENT, CURSOR, CYCLE, DATA, DATABASE, DAY, DEALLOCATE, DECLARE, DEFAULTS, DEFERRED, DEFINER, DELETE, DELIMITER, DELIMITERS, DEPENDS, DETACH, DICTIONARY, DISABLE, DISCARD, DOCUMENT, DOMAIN, DOUBLE, DROP, EACH, ENABLE, ENCODING, ENCRYPTED, ENUM, ESCAPE, EVENT, EXCLUDE, EXCLUDING, EXCLUSIVE, EXECUTE, EXPLAIN, EXTENSION, EXTERNAL, FAMILY, FILTER, FIRST, FOLLOWING, FORCE, FORWARD, FUNCTION, FUNCTIONS, GENERATED, GLOBAL, GRANTED, GROUPS, HANDLER, HEADER, HOLD, HOUR, IDENTITY, IF, IMMEDIATE, IMMUTABLE, IMPLICIT, IMPORT, INCLUDE, INCLUDING, INCREMENT, INDEX, INDEXES, INHERIT, INHERITS, INLINE, INPUT, INSENSITIVE, INSERT, INSTEAD, INVOKER, ISOLATION, KEY, LABEL, LANGUAGE, LARGE, LAST, LEAKPROOF, LEVEL, LISTEN, LOAD, LOCAL, LOCATION, LOCK, LOCKED, LOGGED, MAPPING, MATCH, MATERIALIZED, MAXVALUE, METHOD, MINUTE, MINVALUE, MODE, MONTH, MOVE, NAME, NAMES, NEW, NEXT, NO, NOTHING, NOTIFY, NOWAIT, NULLS, OBJECT, OF, OFF, OIDS, OLD, OPERATOR, OPTION, OPTIONS, ORDINALITY, OTHERS, OVER, OVERRIDING, OWNED, OWNER, PARALLEL, PARSER, PARTIAL, PARTITION, PASSING, PASSWORD, PLANS, POLICY, PRECEDING, PREPARE, PREPARED, PRESERVE, PRIOR, PRIVILEGES, PROCEDURAL, PROCEDURE, PROCEDURES, PROGRAM, PUBLICATION, QUOTE, RANGE, READ, REASSIGN, RECHECK, RECURSIVE, REF, REFERENCING, REFRESH, REINDEX, RELATIVE, RELEASE, RENAME, REPEATABLE, REPLACE, REPLICA, RESET, RESTART, RESTRICT, RETURNS, REVOKE, ROLE, ROLLBACK, ROLLUP, ROUTINE, ROUTINES, ROWS, RULE, SAVEPOINT, SCHEMA, SCHEMAS, SCROLL, SEARCH, SECOND, SECURITY, SEQUENCE, SEQUENCES, SERIALIZABLE, SERVER, SESSION, SET, SETS, SHARE, SHOW, SIMPLE, SKIP_, SNAPSHOT, SQL, STABLE, STANDALONE, START, STATEMENT, STATISTICS, STDIN, STDOUT, STORAGE, STORED, STRICT, STRIP, SUBSCRIPTION, SUPPORT, SYSID, SYSTEM, TABLES, TABLESPACE, TEMP, TEMPLATE, TEMPORARY, TEXT, TIES, TRANSACTION, TRANSFORM, TRIGGER, TRUNCATE, TRUSTED, TYPE, TYPES, UNBOUNDED, UNCOMMITTED, UNENCRYPTED, UNKNOWN, UNLISTEN, UNLOGGED, UNTIL, UPDATE, VACUUM, VALID, VALIDATE, VALIDATOR, VALUE, VARYING, VERSION, VIEW, VIEWS, VOLATILE, WHITESPACE, WITHIN, WITHOUT, WORK, WRAPPER, WRITE, XML, YEAR, YES, ZONE, BETWEEN, BIGINT, BIT, BOOLEAN, CHAR, CHARACTER, COALESCE, DEC, DECIMAL, EXISTS, EXTRACT, FLOAT, GREATEST, GROUPING, INOUT, INT, INTEGER, INTERVAL, LEAST, NATIONAL, NCHAR, NONE, NULLIF, NUMERIC, OUT, OVERLAY, POSITION, PRECISION, REAL, ROW, SETOF, SMALLINT, SUBSTRING, TIME, TIMESTAMP, TREAT, TRIM, VALUES, VARCHAR, XMLATTRIBUTES, XMLCONCAT, XMLELEMENT, XMLEXISTS, XMLFOREST, XMLNAMESPACES, XMLPARSE, XMLPI, XMLROOT, XMLSERIALIZE, XMLTABLE, CASE, CREATE, DO, END, FETCH, FOR, GRANT, NULL, SELECT, TABLE, WITH, ALIGNMENT, BASETYPE, BUFFERS, BYPASSRLS, CANONICAL, CATEGORY, COLLATABLE, COMBINEFUNC, COMMUTATOR, CONNECT, COSTS, CREATEDB, CREATEROLE, DESERIALFUNC, DISABLE_PAGE_SKIPPING, ELEMENT, EXTENDED, FINALFUNC, FINALFUNC_EXTRA, FINALFUNC_MODIFY, FORCE_NOT_NULL, FORCE_NULL, FORCE_QUOTE, FORMAT, GETTOKEN, HASH, HASHES, HEADLINE, HYPOTHETICAL, INIT, INITCOND, INTERNALLENGTH, JSON, LC_COLLATE, LC_CTYPE, LEFTARG, LEXIZE, LEXTYPES, LIST, LOCALE, LOGIN, MAIN, MERGES, MFINALFUNC, MFINALFUNC_EXTRA, MFINALFUNC_MODIFY, MINITCOND, MINVFUNC, MODULUS, MSFUNC, MSSPACE, MSTYPE, NEGATOR, NOBYPASSRLS, NOCREATEDB, NOCREATEROLE, NOINHERIT, NOLOGIN, NOREPLICATION, NOSUPERUSER, OUTPUT, PASSEDBYVALUE, PATH, PERMISSIVE, PLAIN, PREFERRED, PROVIDER, READ_ONLY, READ_WRITE, RECEIVE, REMAINDER, REPLICATION, RESTRICTED, RESTRICTIVE, RIGHTARG, SAFE, SEND, SERIALFUNC, SFUNC, SHAREABLE, SORTOP, SSPACE, STYPE, SUBTYPE_DIFF, SUBTYPE_OPCLASS, SUBTYPE, SUMMARY, SUPERUSER, TIMING, TYPMOD_IN, TYPMOD_OUT, UNSAFE, USAGE, VARIABLE, YAML, ALIAS, ASSERT, CONSTANT, DATATYPE, DEBUG, DETAIL, DIAGNOSTICS, ELSEIF, ELSIF, ERRCODE, EXIT, EXCEPTION, FOREACH, GET, HINT, INFO, LOG, LOOP, MESSAGE, NOTICE, OPEN, PERFORM, QUERY, RAISE, RECORD, RETURN, REVERSE, ROWTYPE, SLICE, SQLSTATE, STACKED, WARNING, WHILE, '(', '<<', DOLLAR_NUMBER, Identifier, QuotedIdentifier}
    Если посмотреть код функции то проблемы вызывает этот кусок:
ANALYZE Tmp.PE_ED_Pts;

Что тут не так, тоже не понятно.

  1. jdbc:/pe/app_subscr_pts_loading_cr line 589:23 mismatched input ';' expecting '=', '.', '[', ':='
    Эта же функция что в п.3 и даже этаже строка. Тут вообще не понятно на что ругается.

  2. /Users/fenoman/OmniX_DB/DB/SCHEMA/dbo/FUNCTION/trigger_sd_contract_squares.sql line 11:1 null
    Тут тоже вообще не понятно. Приведу начало функции:

CREATE FUNCTION trigger_sd_contract_squares
(
) RETURNS trigger
	SECURITY DEFINER
	LANGUAGE plpgsql
AS
$$
	-- @formatter:off
/*==============================================================================================================================================================
Author:      	e-pavlichenko
Create date: 	04.08.2019
Alter date:		02.08.2019 переписан весь код, данные обрабатываем массово
Description:	Синхрониация прощадей
Params:
==============================================================================================================================================================*/
-- @formatter:on
DECLARE
    _level int;
BEGIN
...

Read the original on github.com ↗