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;
Unidac 9.01 SQLite Direct mode exist memory leaks
Re: Unidac 9.01 SQLite Direct mode exist memory leaks
Memory leak when using 'julianday' in SQL statement
Re: Unidac 9.01 SQLite Direct mode exist memory leaks
Please provide the DDL script for creating iplist table
Re: Unidac 9.01 SQLite Direct mode exist memory leaks
DDL:
Create iplist(
id integer PRIMARY KEY AUTOINCREMENT
,ip varchar(15)
,dialtime datetime
) ;
Create iplist(
id integer PRIMARY KEY AUTOINCREMENT
,ip varchar(15)
,dialtime datetime
) ;
Re: Unidac 9.01 SQLite Direct mode exist memory leaks
Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the
results shortly.
results shortly.
Re: Unidac 9.01 SQLite Direct mode exist memory leaks
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
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