[fpc-pascal] Database problem on Solaris SPARC

Mark Morgan Lloyd markMLl.fpc-pascal at telemetry.co.uk
Thu Jul 12 21:22:39 CEST 2012

Ludo Brands wrote:
>>> We only support 32 bit SPARC, and there we split a 64 bit load into 
>>> two
>>> 32 bit loads. dbl, assuming it points to a double, should 
>> point to a 64 
>>> bit-aligned memory location though (depending on the cpu, 32 bit 
>>> alignment may be sufficient, but better be safe than sorry).
>> I'll try to test against 2.7.1 later in the day, although as 
>> I've said 
>> Linux is OK. Is the  if FIntegerDatetimes then  something 
>> Solaris-specific Ludo?)?
> No, the value is read from the server and depends on how the server was
> compiled. Run 'show integer_datetimes;' in psql or whatever client you are
> using to see the value. 
> Pqconnection has detected that it is 'on' on your server. You can check with
> above command to see if the server agrees with that.

Agreed, returns 'on'.

> With integer_datetimes on the datetime is returned as an int64 with the
> number of microseconds since 2000-01-01 00:00:00 UTC, hence the 
> dbl^ := pint64(buffer)^/1000000;
> Dbl is a Pdouble, so the alignment problem could indeed come from there. The
> buffer returned by the driver is correct because just before you have
> pint64(buffer)^ := BEtoN(pint64(CurrBuff)^); CurrBuff being the pointer
> returned. 
> Now, you are getting a SIGSEGV, not a SIGBUS which is what you would get for
> an alignment problem. 

[Nod], understood. Hit a slight snag here with trunk FPC + trunk Lazarus:

Target OS: Solaris for SPARC
Compiling sqldblaz.pas
Compiling registersqldb.pas
registersqldb.pas(58,3) Fatal: Can't find unit ibconnection used by 
Fatal: Compilation aborted
make[2]: *** [sqldblaz.ppu] Error 1
make[2]: Leaving directory 
make[1]: *** [bigide] Error 2
make[1]: Leaving directory 
make: *** [bigidecomponents] Error 2
-bash-3.00$ svn up
At revision 37922.

Anybody got any quick suggestions? "all" builds OK but I presume I need 
"bigide" because I've used the TQuery etc. on the form.

Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

More information about the fpc-pascal mailing list