Created attachment 163355 [details]
A video of the sql statements executing and providing faulty results.

I am learning to use SQLite through this website:
http://www.sqlitetutorial.net/
although I am using the netbeans database system instead of the standalone command line program they use.


According to the website, http://www.sqlitetutorial.net/sqlite-foreign-key/:
----

INSERT INTO suppliers (supplier_name, group_id)
VALUES
 ('HP', 2);

This statement works perfectly fine.

Third, try to insert a new supplier into the suppliers table with the supplier group that does not exist in the supplier_groups table.

INSERT INTO suppliers (supplier_name, group_id)
VALUES
 ('ABC Inc.', 4);

SQLite checked the foreign key constraint, rejected the action, and issued an error message: “constraint failed”.

----

Instead of throwing an error message, the statement executed without throwing an error, and entered the bad information into the "suppliers" database.

I made a video of what happens, and attached it. The sql statements used to make the video are attached as well.

I am using an SQLite jdbc driver, and I assigned it the URL "jdbc:sqlite:" in order to have the database run in memory. I am not sure whether the driver is the problem, or Netbeans, but I thought I would start here.