TSQLQuery Postgresql UUID unable to retrieve after update from 3.0.4 to 3.2.0, fieldvalue is garbish
Original Reporter info from Mantis: ebizz
-
Reporter name: Jens
Original Reporter info from Mantis: ebizz
- Reporter name: Jens
Description:
Querying a UUID Datafield from a Postgresql database since upgrading from 3.0.4 to 3.2.0 the query result for that field is wrong. going back to 3.0.4 everything works fine again. problem exists at least under linux and windows, did install two empty new machines with lazarus 2.0.10 windows and ubuntu after my development system suddenly failed delivering the correct data.
Steps to reproduce:
Postgresql Database Query:
var
FOSDBConnection : TPQConnection;
SQLTransaction : TSQLTransaction;
SQLQuery : TSQLQuery;
SQLString : String;
BEGIN
SQLString := 'SELECT fieldwithonlynotnull_uuid::uuid FROM table;';
SQLQuery.SQL.Text := SQLString;
SQLQuery.Open();
while not SQLQuery.EOF do
begin
Writeln(SQLQuery.Fields[0].AsString);
......