View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0001625Interbase/FirebirdGeneralpublic2020-05-31 05:592021-04-13 15:58
Reporterbarry Assigned Tobarry  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version7.1.0.1691 
Fixed in Version8.0.0.2400 
Summary0001625: COMMENT ON FUNCTION (FB3)
DescriptionDb Comparer 2.12.2019 v.7.1.0.1691 for FB 3 functions (not udf ) generates script for changing comment
COMMENT ON PROCEDURE FUNCTION_NAME
must be
COMMENT ON FUNCTION FUNCTION_NAME
---
by Андрей Кипчарский
TagsNo tags attached.

Activities

barry

2021-04-13 15:58

administrator   ~0004499

Testet on FB 3/4
-----
/* Server version: WI-V6.3.0.2011 Firebird 4.0 Release Candidate 1
   SQLDialect: 3. ODS: 13.0. Forced writes: Off. Sweep inteval: 20000.
   Page size: 4096. Cache pages: 2048 (8192 Kb). Read-only: False. */
SET NAMES UTF8;

SET SQL DIALECT 3;

CONNECT 'c:\database\GALLERY4.FDB' USER 'SYSDBA' PASSWORD 'masterkey';

SET AUTODDL ON;

ALTER TABLE ARTICLES DROP CONSTRAINT ARTICLES_MUSEUM;

/* WARNING:
Cannot perform safe conversion of ARTICLES.MUSEUM datatype from VARCHAR(32) to VARCHAR(10) */
/* WARNING:
Cannot perform safe conversion of Z_ARTICLES.MUSEUM datatype from VARCHAR(32) to VARCHAR(10) */
/* WARNING:
Cannot perform safe conversion of Z_MUSEUMS.ABBR datatype from VARCHAR(32) to VARCHAR(10) */
/* Create Procedure... */
SET TERM ^ ;

CREATE FUNCTION F(X INTEGER)
 RETURNS INTEGER
 AS
 BEGIN RETURN NULL; END
^

SET TERM ; ^

COMMENT ON FUNCTION F IS
'Function @F@';


/* Create Foreign Key... */
RECONNECT;

ALTER TABLE ARTICLES ADD CONSTRAINT ARTICLES_MUSEUM FOREIGN KEY (MUSEUM) REFERENCES MUSEUMS (ABBR) ON UPDATE CASCADE;

COMMENT ON FUNCTION CASTFLOAT IS
'Sample function';

/* Alter Procedure... */
/* Restore proc. body: F */
SET TERM ^ ;

ALTER FUNCTION F(X INTEGER)
 RETURNS INTEGER
 AS
BEGIN
  RETURN X+1;
END
^

SET TERM ; ^

COMMENT ON FUNCTION CASTFLOAT IS
'Sample function';

/* Alter Procedure... */
/* DROP: -- GRANT RDB$ADMIN TO SYSDBA */
REVOKE RDB$ADMIN FROM SYSDBA;

Issue History

Date Modified Username Field Change
2020-05-31 05:59 barry New Issue
2020-05-31 05:59 barry Status new => assigned
2020-05-31 05:59 barry Assigned To => barry
2021-04-13 15:58 barry Status assigned => resolved
2021-04-13 15:58 barry Resolution open => fixed
2021-04-13 15:58 barry Fixed in Version => 8.0.0.2400
2021-04-13 15:58 barry Note Added: 0004499