[sqlite] Duplicate keys

[Michael Knigge]

Hi,
is the order, in which rows with duplicate keys are retrieved, specified?
For example: A table with two columns - the first is a Index. If I 
INSERT in the following order:

C1 C2
-----
3  1
1  1
1  2
1  1
1  3
2  1
If I now do a "SELECT * FROM Table ORDER BY C1;", is it guranteed that 
the rows with identical "C1" are retrieved in "FIFO" order, as

1  1
1  2
1  1
1  3
2  1
3  1
Or is it somehow undefined?!?!?
Thanks,
  Michael