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

GPRE does not recognize COALESCE [CORE490] #840

Closed
firebird-automations opened this issue Aug 20, 2004 · 9 comments
Closed

GPRE does not recognize COALESCE [CORE490] #840

firebird-automations opened this issue Aug 20, 2004 · 9 comments

Comments

@firebird-automations
Copy link
Collaborator

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).

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

ESQL program file that demostrates the problems with COALESCE.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Attachment: coalesce_bug.e [ 10061 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Contributed by Stephen Boyd (mailto:sboyd@users.sf.net).

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 Alpha 1 [ 10224 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Target: 2.5.0 [ 10221 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10514 ] => Firebird [ 14822 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Cannot be tested

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

1 participant