TD-21984: CRASH SqlFetchNext Fetching Binary Data SP3

[EWetzel]

Hi,

with 6.2 SP3 comes a new (for me mystery) bug.

In dependency from some rules SqlFetchNext crashes on fetching Binary Data from SQLBase from a Long Varchar Column into a Variable from Datatype Binary.

The rules:
1. before SqlFetchNext is called the function "MImgLoadFromFileInfo" must be called
(this is a function from Michael Stoll (MImage / MTable), maybe he can also help)
2. The Bufferlength of the Binarydata must be > 0
3. The SELECT Statement must contain another Long Varchar Column with Text

I attached a Sample App.

Important: My Sample App works with every other Version of 6.2 (SP1, SP2 UPD2, ...)

binarytestcrash.jpg

best regards
Enrico

[EWetzel]

Hi,

can anyone from Gupta confirm this issue?

It is definitely new with SP3.
It cost me 3 days to analyze this problem.

Enrico

[VEspinal]

Hi:

It is working for me.

Please see attached video and let me know if I am missing anything on your reprocase.

Thanks,
Victor Espinal

[EWetzel]

Hi,

thank you for the test.

Which OS do you use.
I use Windows 7 Ultimate 64 bit.

Can you please make an exe file and test again.

Enrico

[VEspinal]

You are welcome Enrico.

I use Windows 7 Professional 64 bit.

Created the .exe and got same results.

Thanks
Victor

[EWetzel]

Hi,

Now with TD6.3 the situation is worse.

Please, can someone test my new sample (only Sal Code) with TD 6.3.

Step 2 ("MImgLoadFromFileInfo") is no longer necessary!

I tested on Windows 7 64 Bit and Windows 8.1 64 Bit.

Enrico

[Igor Ivanovic]

Enrico,

I've got the same crash on win 10 64bit.

[Jean-Marc Gemperle]

Hi

I get the crash win8 64bit TD 6.3 OK with 6.2
See video
Thanks for the testcase

Cheers
JM

TD-21984
SQLBASE SqlFetchNext Fetching Binary Data crash

[EWetzel]

Hi,

Thank you for the Investigation.

After my tests I know:
On TD 6.3 it happens permanent
On TD 6.2 It happens sporadically
(Until TD 6.2 SP2 UPD2 42744 there was no issue)

Maybe, after found out the Problem on TD 6.3 the developer has any idea what could be the Problem on TD 6.2.
(Memory leak?)

Enrico