Issue Details (XML | Word | Printable)

Key: CORE-4507
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Imam Chalimi
Votes: 0
Watchers: 5
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Unable delete procedure source on Firebird 3.0 Alpha 2.0

Created: 02/Aug/14 11:42 AM   Updated: 28/May/15 03:11 PM
Component/s: Engine
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 2

Environment: Firebird 3.0 Alpha 2 snapshot build (all version) on Windows 32 bit

QA Status: Done successfully


 Description  « Hide
When using Interbase, Firebird 2.5 or Firebird 3.0 Alpha 1, to improve the security I can successfully remove the body of the procedure source.

UPDATE
      RDB$PROCEDURES P
SET
   P.RDB$PROCEDURE_SOURCE = NULL
WHERE
     P.RDB$SYSTEM_FLAG = 0;

But I failed to do it in Firebird 3.0 Alpha 2 with an error message :

"Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements.
UPDATE operation is not allowed for system table RDB$PROCEDURES."

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov made changes - 09/Nov/14 11:11 AM
Field Original Value New Value
Regression 3.0 Alpha 2 [ 10560 ]
Dmitry Yemanov made changes - 09/Nov/14 04:40 PM
Assignee Dmitry Yemanov [ dimitr ]
Dmitry Yemanov made changes - 09/Nov/14 04:43 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 2 [ 10586 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 28/May/15 03:11 PM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status Done successfully