Details
-
Improvement
-
Status: Resolved
-
Low
-
Resolution: Later
-
None
-
None
-
None
Description
Empty strings are allowed in composite primary keys, but not single-column primary keys.
Example:
create table bla (
pk text primary key,
val text
);
insert into bla (pk, val) values ('', '');
throws: Key may not be empty.
create table bla2 ( pk text, pk2 text, val text, primary key ((pk, pk2)) ); insert into bla2 (pk, pk2, val) values ('', '', '');
succeeds