Re: Problem with TSQL on 64 bits

Hi,

I saw this change. It only fixes problem with TMySQLStatement::ConvertToString() (used in GetString() call). But there are other places, where C-type "long" wrongly used in conjunction with MYSQL_TYPE_LONG.
I would like to fix them too.

Regards,
Sergey

Am 14.05.2010 23:31, schrieb Fechner Maximilien:
>
> Hi,
>
> this was found & fixed a while ago, in April 2009, somewhere
> between 5.22 and 5.24. So 5.22/00a does not have the fix.
> The latest 5.24 and 5.26 have it though.
>
> Best regards,
> -MF
>
> Maximilien Fechner, PhD
> CEA Saclay IRFU/SPP
> 91191 Gif-sur-Yvette Cedex
> France
>
>
>
>
> -----Original Message-----
> From: owner-roottalk_at_root.cern.ch on behalf of Brett Viren
> Sent: Fri 5/14/2010 6:40 PM
> To: roottalk_at_cern.ch
> Subject: [ROOT] Problem with TSQL on 64 bits
>
> Hi RootTalk,
>
> I've found a problem with TSQL that apparently has to do with running on
> 64 bit Linux. This is with ROOT 5.22/00a so maybe it has already been
> found and fixed. If so, please let me know which version has the fix.
>
> The problem manifests itself with a value 0 being returned as a large
> number with the MSB garbage and the LSB all 0. The column in question
> is defined as "int(11)", "NOT NULL" and is a primary key. The database
> is MySQL 5.0.45.
>
> I'm using a simple test like:
>
> TSQLServer *db =
> TSQLServer::Connect("mysql://dybdb1.ihep.ac.cn/testdb","dayabay",
> "secret");
> TSQLStatement *s = db->Statement("select * from CalibPmtSpec where
> SEQNO = 0 order by SEQNO");
> cerr << "Process: " << s->Process() << endl;
> cerr << "StoreResult: " << s->StoreResult() << endl;
> cerr << "GetNumFields: " << s->GetNumFields() << endl;
> cerr << "GetFieldName(0): " << s->GetFieldName(0) << endl;
> cerr << "NextResultRow: " << s->NextResultRow() << endl;
> cerr << "GetString(0): " << s->GetString(0) << endl;
>
> On 32 Bit Debian 5.0.4 the last line returns
>
> GetString(0): 0
>
> On 64 bit Sci. Linux 5.3 the last line returns:
>
> GetString(0): 47871705481216
>
> The correct value is 0 confirmed by doing a query through the mysql
> command line client.
>
> You'll note this large number is 0x2B8A00000000. So, the bottom 32 bits
> are correctly 0. Each time I run the test on 64 bits I get a different
> number but the bottom 4 bytes are always 0.
>
>
> Thanks,
> -Brett.
>
Received on Sat May 15 2010 - 08:39:38 CEST