Adding a non-nullable TEXT field

[Ivan Smahin]

On Aug 13, 2014, at 15:56, jda <jda at his.com> wrote:

> Hi,
> 
> I’m using this code to add a TEXT field to an existing table
> 
>      ALTER TABLE table1 ADD newField text DEFAULT '' NOT NULL
> 
> However, the field that is edited is nullable. How do I add a non-nullable field?
> 


For now any Valentina's TEXT field is nullable. You can not make it not-null (your "not null" was ignored.).
We just thought it is no reason to have not-nullable text/blob/picture fields. Internally, empty data takes one blob-segment but null-data takes zero segments. On the other hand "not null" is sort of constraint which can be required by your business logic. Probably we have to allow not-nullable BLOBs...

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com



-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20140813/8f2c4599/attachment.html>