[sqlite] can anyone reproduce ticket# 1540 (failure to create a primary key)?

[Bogdan Ureche]

Hi,

I recently posted ticket# 1540 (failure to create a primary key) which was
closed with the comment 'unable to reproduce'. I then realized I forgot to
mention that I noticed the problem on Windows XP (not sure if it works or
not on Linux, I didn't try it).

Here is the description of the problem:

The following script does NOT create a primary key: 

CREATE TABLE TestTable (TestField1 INTEGER PRIMARY KEY, TestField2 VARCHAR) 

However, the next one does create a primary key:

CREATE TABLE TestTable (TestField1 INTEGER PRIMARY KEY, TestField2 VARCHAR
UNIQUE)

Can anybody reproduce this problem on Windows32?

Thanks in advance.

Bogdan