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
RDB$GET_CONTEXT and between in view [CORE3310] #3677
Comments
Modified by: @dyemanovassignee: Adriano dos Santos Fernandes [ asfernandes ] security: Developers [ 10012 ] => |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 1 [ 10331 ] |
Commented by: Tamás Sándor (santa_hostware) This happens without rdb$get_context as well. |
Commented by: @asfernandes Please send complete and reproducible test case. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Done successfully Test Details: Test uses data from standard 'employee' database from examples folder. |
Commented by: @pcisar Test created. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Alexander Krepky (alxkrp)
Is related to QA558
On employee.fdb I create such view:
CREATE VIEW V_TEST
AS
select S.*
from SALES S
where cast(coalesce(RDB$GET_CONTEXT('USER_SESSION', 'SELECTED_DATE'), '12.12.1993') as timestamp) between S.ORDER_DATE and S.DATE_NEEDED
and on select * from V_TEST I receive:
convertion error from string ""
But request, which is specified in view, works in itself.
And, if in view I don't use "between" (replace on >= <=) - it works too.
Commits: bf77761
====== Test Details ======
Test uses data from standard 'employee' database from examples folder.
The text was updated successfully, but these errors were encountered: