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

crash with extract from null as date [CORE357] #697

Closed
firebird-automations opened this issue Apr 2, 2002 · 3 comments
Closed

crash with extract from null as date [CORE357] #697

firebird-automations opened this issue Apr 2, 2002 · 3 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @ibaseru

SFID: 538201#⁠
Submitted By: kdv

Interbase 6.0.1.0, Firebird 1.0.0.796/808, Interbase 6.5.0.28
All Win32 versions (on W2K SP2)

Server crashes executing the following statement:

select extract(month from cast(null as date))
from RDB$Database

or

select count(*) from RDB$Database
where extract(month from cast(null as date))>3

seems that problem is in extract.

During server crash nothing is being reported in interbase.log.
Only AV message on screen.

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2002-04-02 16:46
Sender: danielrail
Logged In: YES
user_id=238419

Just to add my observations. If Firebird is running as a
service, there's no error that pops up, except from the
client application which has lost the connection. I also
have IB Guardian running and that service is even shutdown
when this error occurs, so Firebird is never automaically
restarted. At this point a person has to manually restart
Firebird.

The following error appears in the interbase.log file:
DEVCOMP1 (Client) Tue Apr 02 10:38:34 2002
C:\Program
Files\Borland\InterBase\bin\ibserver.exe: terminated
abnormally (-1)

Hope this information helps.

Daniel Rail

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10381 ] => Firebird [ 14637 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No 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

1 participant