[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] No check for invalid constraints
From:       Hick Gunter <hick () scigames ! at>
Date:       2017-05-29 6:55:30
Message-ID: f9730e42dda5b0706ba58b52eea003b075a9552d () localhost
[Download RAW message or body]

There is no "underscore notation" for multiword constraints. "NOT_NULL" is not "NOT \
NULL" and "PRIMARY KEY" is not "PRIMARY_KEY". As long as whatever you provide can be \
split up into tokens in a way that matches the grammar there will be no syntax error. \
It will just not be matching what you think you specified, but didn't.

-----Ursprüngliche Nachricht-----
Von: sqlite-users [mailto:sqlite-users-bounces@mailinglists.sqlite.org] Im Auftrag \
                von Aflah Bhari
Gesendet: Samstag, 27. Mai 2017 15:48
An: sqlite-users@mailinglists.sqlite.org
Betreff: [sqlite] No check for invalid constraints

Hi there,

I'm using SQLITE version 3.16.0 on macOS Sierra 10.12.4. I'm experiencing a unique \
bug where if I put in an primary key constraint with underscores then the primary key \
does not auto increment when I insert values.

*For example:*

CREATE TABLE sensor_status(status_id INTEGER *PRIMARY_KEY*, status text NOT_NULL \
UNIQUE); insert into sensor_status(status) VALUES("ONLINE"); select * from \
sensor_status;

status_id   status

----------  ----------

            ONLINE


*Versus:*

CREATE TABLE sensor_status(status_id INTEGER *PRIMARY KEY*, status text NOT_NULL \
UNIQUE); insert into sensor_status(status) VALUES("ONLINE"); select * from \
sensor_status;

status_id   status

----------  ----------

1           ONLINE

I'm not sure what the implications of this are on other constraints such as NOT_NULL \
which also does not seem to work with the underscore notation.

EDIT: I've just realised that there is no check in place for whether the constraint \
is typed correctly.

I'm not sure now if this is necessarily a bug or a feature that hasn't been \
implemented (intentionally or unintentionally). I'm new to sqlite so I apologise if \
I'm wasting anyone's time by reporting this :(

Thanks,
Aflah
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


___________________________________________
 Gunter Hick
Software Engineer
Scientific Games International GmbH
FN 157284 a, HG Wien
Klitschgasse 2-4, A-1130 Vienna, Austria
Tel: +43 1 80100 0
E-Mail: hick@scigames.at

This communication (including any attachments) is intended for the use of the \
intended recipient(s) only and may contain information that is confidential, \
privileged or legally protected. Any unauthorized use or dissemination of this \
communication is strictly prohibited. If you have received this communication in \
error, please immediately notify the sender by return e-mail message and delete all \
copies of the original communication. Thank you for your cooperation.


_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[prev in list] [next in list] [prev in thread] [next in thread]