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
GPRE does not recognize COALESCE [CORE490] #840
Comments
Commented by: @pcisar ESQL program file that demostrates the problems with COALESCE. |
Modified by: @pcisarAttachment: coalesce_bug.e [ 10061 ] |
Commented by: @dyemanov Contributed by Stephen Boyd (mailto:sboyd@users.sf.net). |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 Alpha 1 [ 10224 ] |
Modified by: @dyemanovTarget: 2.5.0 [ 10221 ] |
Modified by: @pcisarWorkflow: jira [ 10514 ] => Firebird [ 14822 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: No test => Cannot be tested |
Submitted by: jthaddeus (jthaddeus)
Attachments:
coalesce_bug.e
SFID: 1012895#
Submitted By: jthaddeus
GPRE does not recognize the COALESCE function. Upon
reaching the COALESCE line in any code I've tried, an
error is thrown. For example:
$ /opt/firebird/bin/gpre -c -n -m o_process.e
(E) o_process.e:234: expected FROM, encountered "("
(E) o_process.e:302: expected FROM, encountered "("
2 errors, no warnings
Platform: SuSE Linux 9.0
Firebird installed with:
FirebirdSS-1.5.1.4481-0.i686.tar.gz
For the error above, line 234, looks like
232 ...
232 EXEC SQL
233 SELECT
234 procid, COALESCE(procname,' '), wfmcstate,
235 ...
I have also tried
234 procid, COALESCE(procname,' ') as procname,
wfmcstate,
with similar results.
COALESCE works in ISQL.
The attached file demonstrates the error in a program
written against the employee.fdb. Instructions are in
the file's comments.
NOTE: I have not tired NULLIF or any other function in
ESQL (I've been using my own UDF for NULLIF and
NVL/COALESCE with Firebird 1.0.x).
The text was updated successfully, but these errors were encountered: