[Gambas-user] Allocations not freed when using SQLite
Cedron Dawg
cedron at exede.net
Wed May 1 21:12:44 CEST 2019
Hi Benoit,
Thanks for looking at this.
Ced
The project source archive is attached. With no database file present, the code will run properly with the SQL below entered and then exit with:
gbx3: warning: 4 allocation(s) non freed.
I've also attached my full script. Some of you may recognize it as automatically generated code from the diagram in
https://forum.gambas.one/viewtopic.php?f=4&t=699
=======================================================
CREATE TABLE text_lines(
text_line_id INTEGER PRIMARY KEY,
name TEXT NOT NULL
);
CREATE TABLE keywords(
keyword_id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
description TEXT
);
CREATE TABLE keyword_usage(
keyword_usage_id INTEGER PRIMARY KEY,
text_lines_fk INTEGER NOT NULL,
keywords_fk INTEGER NOT NULL,
FOREIGN KEY(text_lines_fk) REFERENCES text_lines(text_line_id)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY(keywords_fk) REFERENCES keywords(keyword_id)
ON UPDATE CASCADE
ON DELETE CASCADE
);
CREATE INDEX keyword_usage__text_lines ON keyword_usage(text_lines_fk);
CREATE INDEX keyword_usage__keywords ON keyword_usage(keywords_fk);
----- Original Message -----
From: "Benoît Minisini" <g4mba5 at gmail.com>
It's usually a bug. Please post a project that reproduces it.
ReEgards,
--
Benoît Minisini
----[ Gambas mailing-list is hosted by https://www.hostsharing.net ]----
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SQLiteTesting-0.0.1.tar.gz
Type: application/x-compressed-tar
Size: 18848 bytes
Desc: not available
URL: <https://lists.gambas-basic.org/pipermail/user/attachments/20190501/22b078e6/attachment-0001.bin>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: TestSql.txt
URL: <https://lists.gambas-basic.org/pipermail/user/attachments/20190501/22b078e6/attachment-0001.txt>
More information about the User
mailing list