ite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Simon Slavin
Sent: Wednesday, October 04, 2017 12:51 PM
To: SQLite mailing list
Subject: [sqlite] Shell tool allows creation of column name ""
Given a .csv file which starts like this:
ID,code,name,sortOr
I believe that as long as quoted identifiers are allowed, every value allowed as
a regular character string should also be allowed as an identifier, including
the empty string. (Length limits notwithstanding.)
Some best practices may be against empty string names, but the system should
allow
Given a .csv file which starts like this:
ID,code,name,sortOrder,,AlternativeName
1,RAH,Robert A. Heinlein,"Heinlein, Robert A.",Real Name,
2,IA,Isaac Asimov,"Asimov, Isaac",Real Name,
3,HH,Harry Harrison,"Harrison, Harry",,
Shell tool of this version
SQLite version 3.19.3 2017-06-27 16:48:08
3 matches
Mail list logo