Re: [sqlite] Shell tool allows creation of column name ""

2017-10-04 Thread David Raymond
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

Re: [sqlite] Shell tool allows creation of column name ""

2017-10-04 Thread Darren Duncan
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

[sqlite] Shell tool allows creation of column name ""

2017-10-04 Thread Simon Slavin
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