Firebird 3.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version()
Dynamic SQL Error SQL error code = -104 Unexpected end of command - line 1, column 16 

CREATE TABLE invoice 
(
  inv_id INTEGER generated by default as identity PRIMARY KEY,
  inv_amount INTEGER NOT NULL,
  inv_cust INTEGER NOT NULL,
  CONSTRAINT "too_many_invoices_ct" 
  CHECK ((SELECT COUNT(*) FROM invoice WHERE invoice.inv_cust = inv_cust) < 5),
  CONSTRAINT "sum_invoices_excessive_ct"
  CHECK ((SELECT SUM(inv_amount) FROM invoice WHERE invoice.inv_cust = inv_cust) < 1000)
);


INSERT INTO invoice (inv_amount, inv_cust) VALUES (100, 2); 
1 rows affected

INSERT INTO invoice (inv_amount, inv_cust) VALUES (100, 2); 
1 rows affected

INSERT INTO invoice (inv_amount, inv_cust) VALUES (100, 2); 
1 rows affected

INSERT INTO invoice (inv_amount, inv_cust) VALUES (100, 2); 
1 rows affected

INSERT INTO invoice (inv_amount, inv_cust) VALUES (100, 2); 
1 rows affected

INSERT INTO invoice (inv_amount, inv_cust) VALUES (100, 2); 
Operation violates CHECK constraint too_many_invoices_ct on view or table INVOICE At trigger 'CHECK_1' 

SELECT * FROM invoice;  -- inv_cust) < 5) - it's obviously a very confusing
                        -- zero based count? WTF? Only fails on invoice 6!


INV_ID
INV_AMOUNT
INV_CUST


1
100
2

2
100
2

3
100
2

4
100
2

5
100
2