Ideone.com

fork download

copy

CREATE TABLE Persons(
I INTEGER NOT NULL CHECK (I > 0)
);
 
INSERT INTO Persons
  (I)
VALUES
  (1),
  (-1);
 
SELECT *
FROM Persons;

Success #stdin #stdout #stderr 0s 3392KB

stdin

copy

Standard input is empty

stdout

copy

Standard output is empty

stderr

copy

Error: near line 5: CHECK constraint failed: Persons

https://ideone.com/fFtI5Z

language:

SQLite (sqlite 3.27.2)

created:

visibility:

public

Share or Embed source code

The brand new service which powers Ideone!

Widget for compiling and running the source code in a web browser!