SQLBase Crash (reproducible)

[m.burkhardt]

Hello, we have found a reproducible error (Crash) on an SqlBase 11.6 and SqlBase 12 Engine. On an faulty SQL Statement, the Engine crashes!
If you take the function SUM and erroneously take a CHAR (>=80) column the Engine Crashes. If the Column is Char(10) you get an error Message!!

Created Table test997:
CINT (integer) CTXT (char(10)
=========== ==========
1 Text1
2 Text2
3 Text3

(1)
select sum(CINT) from test997;
SUM(CINT)
===========
6

(2)
select sum(CTXT) from test997;
SUM(CTXT)
==========
Sb._\dde


Created Table test998:
CINT (integer) CTXT (char(100)
=========== ==========
1 Text1
2 Text2
3 Text3

(1)
select sum(CINT) from test998;
SUM(CINT)
===========
6

(2)
select sum(CTXT) from test998;
!!!!! C R A S H !!!!!



Greetings From Germany

Michael Burkhardt

[Igor Ivanovic]

Hi,

Tried both on SQLBase 11.7.3 and SQLBase 12.0.1 and didn't get the crash.

[m.burkhardt]

I tried it many times on 12.0.1 and every Time I do It I'll get the CRASH!

I tried it Now an I also get the crash! 12.0.1

Windows 2012 (64Bit) Patch version actual (English)!

Greetings from Germany!
Michael

[Igor Ivanovic]

Michael,

Are You using the 32bit or the 64bit SQLBase server?
I tried with 32bit versions only on windows 10, as I don't have the server 2012.
Just tried it on win server 2008R2 SP1, SQLBase 11.7.3 32bit - no crash.