Devart Forums

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;

Memory leak when using 'julianday' in SQL statement

Please provide the DDL script for creating iplist table

DDL:

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

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

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