[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