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
Operations

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

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

Pavel Cisar made changes - 28/Jan/08 01:19 PM
Field Original Value New Value
Workflow jira [ 10381 ] Firebird [ 14637 ]
Pavel Zotov made changes - 19/Jan/16 05:14 AM
QA Status No test