New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
since version 3. external UDF function named TRIM cannot be removed [CORE5513] #5782
Comments
Commented by: @AlexPeshkoff Not reproduced: # ./isql -z employee |
Commented by: Konstantin Streletsky (streletsky) on employee.fdb it works fine, but on my database something not good. C:\B52Soft\db\test2>isql.exe -z -user sysdba -password 7921 EMPLOYEE.FDB C:\B52Soft\db\test2>isql.exe -z -user sysdba -password 7921 B52.GDB |
Commented by: Konstantin Streletsky (streletsky) I sort out this issue only by creating full sql dump of database and removing UDF declaration. |
Commented by: @asfernandes Database was in dialect 1 or 2? |
Commented by: Konstantin Streletsky (streletsky) database with probem has dialect 1 |
Commented by: @hvlad Konstantin, so, could you change db dialect to 3, drop the function, and revert db dialect back to 1 ? |
Commented by: Konstantin Streletsky (streletsky) Vlad Khorsun, C:\Program Files\Firebird\Firebird_3_0>gfix -sql_dialect 3 -user sysdba -password masterkey c:\db\test.gdb C:\Program Files\Firebird\Firebird_3_0>sql -user sysdba -password mastery c:\db\test.gdb Database: c:\db\test.gdb, User: SYSDBA C:\Program Files\Firebird\Firebird_3_0>gfix -sql_dialect 1 -user sysdba -password masterkey c:\db\test.gdb C:\Program Files\Firebird\Firebird_3_0>isql -user sysdba -password masterkey c:\db\test.gdb Function Name Invalid Dependency, Type |
Submitted by: Konstantin Streletsky (streletsky)
I have updated my database from 2.5 to 3.0.1 and catch a problem when trying to remove TRIM function from UDFs.
I'm trying DROP EXTERNAL FUNCTION "TRIM" and get error
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 1, column 24.
"TRIM".
In firebird 2.5 I can remove it directly from rdb$functions, but in FB3 does not allow doing this.
It three any chance to remove this function using FB3, because in FB3 external functions must be granted and I can't have granted trim as well.
The text was updated successfully, but these errors were encountered: