SQLite Forum

Two space separated fields in SELECT field list
Login
Hi,

Just by mistake typed a space instead of the comma when entering a field list for a Select statement, but noticed that Sqlite accepted it, just ignored the first one of two, so

  SELECT Field1, Field2 Field3, Field4 

finished showing 

  Field1, Field3, Field4 

result

Other observations:
  *  No third or any following participant in this space separated exception is  possible, Sqlite gives an error.
  *  No arbitrary name possible for the first field, only a valid field name
  *  Absolutely equivalent behavior noticed for MySql. 

Does it have some semantic meaning in the SQL world? 

Thanks

Max