Skip to content
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

Problem with default value of SP parameter [CORE2797] #3187

Closed
firebird-automations opened this issue Jan 14, 2010 · 7 comments
Closed

Problem with default value of SP parameter [CORE2797] #3187

firebird-automations opened this issue Jan 14, 2010 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @ibprovider

Server Name :Firebird
Server Version :2.5.0.25856
Client Name :Firebird SQL Server
Client Version :2.5.0.25856
Database ODS :11.2
Database Dialect:3

---
CREATE PROCEDURE SP_TMP_007_298 (IN1 TIMESTAMP NOT NULL = CURRENT_TIMESTAMP)
AS
DECLARE VARIABLE X INTEGER;
BEGIN
X=0;
END

---
select f.rdb$default_source
from rdb$procedure_parameters pp
join rdb$fields f
on pp.rdb$field_source=f.rdb$field_name
where pp.rdb$procedure_name = 'SP_TMP_007_298'

--- Result
= CURRENT_TIMESTAMP)

I think, result should be
= CURRENT_TIMESTAMP

----
FB 2.1.3.18185 works correctly

Commits: 8d8a8b5 b31f3bc 15a9a2b

====== Test Details ======

Default values for fields that are defined NOT via domains (i.e. those which are shown as 'RDB$nnn' in the fileld rdb$procedure_parameters.rdb$default_source) are stored differently in 2.5 vs 3.0:
1) 2.5 -- in rdb$fields.rdb$default_source;
2) 3.0 -- in rdb$procedure_parameters.rdb$default_source
-- see expected out in the test.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

reporter: Pavel Cisar [ pcisar ] => Kovalenko Dmitry [ _dima_k_ ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 RC2 [ 10372 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @ibprovider

Please, return this issue to "open" state for "FB3 Initial"

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

I'm testing a fix for V3, which handle this in a completely different manner.

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Fixed in V3.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done with caveats

Test Details: Default values for fields that are defined NOT via domains (i.e. those which are shown as 'RDB$nnn' in the fileld rdb$procedure_parameters.rdb$default_source) are stored differently in 2.5 vs 3.0:
1) 2.5 -- in rdb$fields.rdb$default_source;
2) 3.0 -- in rdb$procedure_parameters.rdb$default_source
-- see expected out in the test.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants