.NET Data Provider 11.5 SP4 long varchar bug

Report SqlBase bugs and possible workarounds.
ynijsen

.NET Data Provider 11.5 SP4 long varchar bug

Post by ynijsen » 05 Apr 2011, 09:08

Hi all,
we are trying to upgrade from the 11.0 Gupta driver to the 11.5 SP4 but hit a number of bugs, mostly due to long varchars.
This one got us puzzled for a while, but we are able to reproduce if you follow the steps from the attachments.

The issue is that the .NET Dataprovider reads a record value as DBNULL while it has a value.
This occurs when the length equals 256 chars. ( or is a multiply of 256 like 512, 768 or 1024 )

In our case the long varchar string contains this value
"CDGRBREKENING;BOEKJAAR;CDSUBADMIN;CDVERBYZ;CDVERBYZDOS;OMSCHR;ZOEKNAAM;SOORT;ACTIVATYPE;CDBLOKKADE;CDBOEKEN;CDBUDGET;BTWCODE;
CODERUBRIEK1;CODERUBRIEK2;CODERUBRIEK3;SUBADMIN1;SUBADMIN2;SUBADMIN3;CDKOSTENPLAATS;CDDOSSIER;CDAUDITION;BTWSCENARIO;AUDITIONOMSCHR"
change the record to hold any longer or shorter value and the provider returns the correct value. But this value always equals DBNULL.

Create a console visual studio app and reference the Unify.SQLBase.Data assembly and replace the code of the Main method with the attached code.
Also create a test database by executing this script:

Code: Select all

set server mvserv/sysadm;
create database u4test;
set server off;

connect u4test;
CREATE TABLE SCHERMOPTIES (CDTYPE CHAR(3) NOT NULL,  VELDEN LONG VARCHAR, PRIMARY KEY (CDTYPE) ) IN u4test;
CREATE UNIQUE INDEX PRIMKEY on SCHERMOPTIES (CDTYPE) ;
commit;

disconnect all;
You do not have the required permissions to view the files attached to this post.

Mike Vandine

Re: .NET Data Provider 11.5 SP4 long varchar bug

Post by Mike Vandine » 07 Apr 2011, 12:00

Hmmmm. This one sounds VERY familiar!

Let me have a look around to see what I can see that is fixed and I will also test this out as well.

Is it possible for you to test this with the SQLBase 11.6 .NET provider?

ynijsen

Re: .NET Data Provider 11.5 SP4 long varchar bug

Post by ynijsen » 12 Apr 2011, 10:26

Hi Mike,
we also tested this with the latest 11.6 provider and this problem also exists with that version.

Regards,
Yuri Nijsen
UNIT4 Software

Mike Vandine

Re: .NET Data Provider 11.5 SP4 long varchar bug

Post by Mike Vandine » 13 Apr 2011, 03:03

Thanks for the confirmation, Yuri!

Mike Vandine

Re: .NET Data Provider 11.5 SP4 long varchar bug

Post by Mike Vandine » 10 May 2011, 09:39

Hi Yuri,

Our .NET guru has checked this out with the latest and greatest drivers from 11.6 SP1 and can't get it to fail. He thinks that this has probably already been fixed with this release.

Is it possible for you to test again with those drivers?

Best regards,

Mike

Return to “SqlBase Bug Reports”

Who is online

Users browsing this forum: [Ccbot] and 0 guests