Issue Details (XML | Word | Printable)

Key: CORE-3157
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Daniel Bauten
Votes: 0
Watchers: 4

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

COMMENT ON PARAMETER - Statement leads in a consumption of 1.7 GB RAM and a runtime of more than 1 Minute

Created: 05/Oct/10 07:51 AM   Updated: 23/Jan/16 11:46 AM
Component/s: Engine
Affects Version/s: 3.0 Initial, 2.5.0
Fix Version/s: 2.5.1, 3.0 Alpha 1

File Attachments: 1. File CommentOnParameter.7z (2.65 MB)

Firebird x64, Windows 7 Professional 64-Bit (German), 4 GB RAM

QA Status: Not enough information
Test Details:
> Extract CommentOnParameter.7z (please note: file is password protected
No password - no test :)

 Description  « Hide
Adding a parameter description to a stored procedure leads (e.g. in attached database) in a memory consumption of 1.7 GB an a runtime of about 1 minute 15 seconds.

To reprocude, please do the following.

1. Extract CommentOnParameter.7z (please note: file is password protected; please mail to Daniel.Bauten(a) to obtain the password).

2. Use the following statement (runtime on my system: 1 minute 15 seconds).


3. Use the following syntax (runtime on my system: 62 ms).


Feel free to contact me if you have further questions about this issue.

Thanks in advance for fixing this. ;-)


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes added a comment - 24/Oct/10 12:06 AM
I've asked the reported for the database password, but didn't got it.

Daniel Bauten added a comment - 25/Oct/10 05:42 AM - edited
I haven't received any password request - probably "lost in spam". Sorry, Adriano.

I sent an email to you some minutes ago containing the needed password (Subject: "FB-Tracker CORE-3157 - password"). Please let me known if this email won't arrive.