Issue Details (XML | Word | Printable)

Key: CORE-357
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: kdv
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
Firebird Core

crash with extract from null as date

Created: 02/Apr/02 12:00 AM   Updated: 19/Jan/16 05:14 AM
Component/s: None
Affects Version/s: None
Fix Version/s: 1.0.3

SF_ID: 538201
QA Status: No test

 Description  « Hide
SFID: 538201#
Submitted By: kdv

Interbase, Firebird, Interbase
All Win32 versions (on W2K SP2)

Server crashes executing the following statement:

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


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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alice F. Bird added a comment - 14/Jun/06 09:38 AM
Date: 2002-04-02 16:46
Sender: danielrail
Logged In: YES

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

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

Hope this information helps.

Daniel Rail