Unidac 9.01 SQLite Direct mode exist memory leaks

[jianlei]

Unidac 9.01 SQLite Direct mode exist memory leaks

direct=true
There is a memory leak when executing some statements,
direct=false
There is no memory leak for the following operations


There is a memory leak for the following operations:

UniConnection1.Database := ExtractFilePath(ParamStr(0)) + 'cardhouse.db';
try
UniConnection1.SpecificOptions.Values['Direct'] := 'True';
UniConnection1.Open;
UniQuery1.SQL.Text :=
'delete from iplist where round(julianday(datetime(CURRENT_TIMESTAMP,''localtime''))*24*60*60-julianday(datetime(dialtime))*24*60*60)>:sec';
UniQuery1.ParamByName('sec').AsInteger := 24 * 60 * 60;
UniQuery1.Execute;
finally
UniConnection1.Close;
end;



There is no memory leak for the following operations:

UniConnection1.Database := ExtractFilePath(ParamStr(0)) + 'cardhouse.db';
try
UniConnection1.SpecificOptions.Values['Direct'] := 'True';
UniConnection1.Open;
UniQuery1.SQL.Text := 'delete from iplist where id=1';
UniQuery1.Execute;
finally
UniConnection1.Close;
end;

[jianlei]

Memory leak when using 'julianday' in SQL statement

[MaximG]

Please provide the DDL script for creating iplist table

[jianlei]

DDL:

Create iplist(
id integer PRIMARY KEY AUTOINCREMENT
,ip varchar(15)
,dialtime datetime
) ;

[MaximG]

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the
results shortly.

[MaximG]

We've reproduced the issue and fixed it. The fix will be included in the next build of our product. As a workaround, we can send you a night UniDAC build including the required changes.
For this provide us with your license number and IDE version you are interested in For your convenience, please use the e-support form https://www.devart.com/company/contactform.html