SQLBase Crash (reproducible)

Discussion forum about all things SqlBase.
m.burkhardt
Germany
Posts: 50
Joined: 19 Feb 2020, 10:13
Location: Duisburg, Germany

SQLBase Crash (reproducible)

Post by m.burkhardt » 24 Nov 2016, 14:05

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
Site Admin
Site Admin
Croatia
Posts: 1406
Joined: 05 Mar 2017, 12:37
Location: Zagreb, Croatia

Re: SQLBase Crash (reproducible)

Post by Igor Ivanovic » 24 Nov 2016, 16:29

Hi,

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

m.burkhardt
Germany
Posts: 50
Joined: 19 Feb 2020, 10:13
Location: Duisburg, Germany

Re: SQLBase Crash (reproducible)

Post by m.burkhardt » 30 Nov 2016, 14:16

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
Site Admin
Site Admin
Croatia
Posts: 1406
Joined: 05 Mar 2017, 12:37
Location: Zagreb, Croatia

Re: SQLBase Crash (reproducible)

Post by Igor Ivanovic » 07 Dec 2016, 17:14

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.
Igor Ivanovic
Image

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests