View Issue Details

IDProjectCategoryView StatusLast Update
0037350FPCDatabasepublic2020-07-15 12:56
ReporterJens Assigned ToMichael Van Canneyt  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version3.2.0 
Fixed in Version3.3.1 
Summary0037350: TSQLQuery Postgresql UUID unable to retrieve after update from 3.0.4 to 3.2.0, fieldvalue is garbish
DescriptionQuerying 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 ReproducePostgresql 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);

 ......
TagsNo tags attached.
Fixed in Revision45791
FPCOldBugId
FPCTarget3.2.2
Attached Files

Activities

Jens

2020-07-15 12:28

reporter   ~0124036

Example Output/Value for a dynmic uuid created with such a statement: SELECT uuid_generate_v4();

{PZ

Michael Van Canneyt

2020-07-15 12:56

administrator   ~0124038

Fixed, thanks for reporting !

Issue History

Date Modified Username Field Change
2020-07-14 19:35 Jens New Issue
2020-07-15 12:13 Michael Van Canneyt Assigned To => Michael Van Canneyt
2020-07-15 12:13 Michael Van Canneyt Status new => assigned
2020-07-15 12:28 Jens Note Added: 0124036
2020-07-15 12:56 Michael Van Canneyt Status assigned => resolved
2020-07-15 12:56 Michael Van Canneyt Resolution open => fixed
2020-07-15 12:56 Michael Van Canneyt Fixed in Version => 3.3.1
2020-07-15 12:56 Michael Van Canneyt Fixed in Revision => 45791
2020-07-15 12:56 Michael Van Canneyt FPCTarget => 3.2.2
2020-07-15 12:56 Michael Van Canneyt Note Added: 0124038