[sqlite] Strange behaviour on Update

[Luís Santos]

Hi, Ppl

We have found a strange behaviour on SQLite 3.4.1 (We have also tested 
against versions 3.0.8, 3.2.5 and 3.4.0)

When we create a field with a name composed exclusively of numeric 
algarisms, we cannot perform an update.

We have only noticed this odd behaviour because of a NOT NULL field. See 
the code example:

   sqlite> CREATE TABLE test (
      ...>       id INT NOT NULL,
      ...>       FieldOne TEXT NOT NULL,
      ...>       FieldTwo TEXT,
      ...>       "1" TEXT
      ...> );
   sqlite> insert into test (id, FieldOne ) values (1, "4");

   sqlite> update test set FieldOne ="1";
   SQL error: test.FieldOne may not be NULL

Has anybody stumbled upon something like this?

Thnx
Luís Santos