[sqlite] Very Strange and Interesting Problem

[王庆刚]

hi, every one.
     Here is a very strange and interesting problem.
     I used the following SQL to create the table teacher.
     CREATE TABLE techer(poiId INTEGER NOT NULL PRIMARY KEY,
                                            versionId INTEGER NOT NULL,
                                            regionId INTEGER ,
                                            postalCode TEXT ,
                                            phone TEXT ,
                                            attrBitMask INTEGER ,
                                            attributeBlob BLOB)

     and  then I used the following SQL,
     select rowid,*  from teacher.    So the strange and interesting problem 
happen.
     the name of the rowid column change to poiId, and the name of the poiId 
become poiId_1. But the two columns have the same values.

     Why the rowid change is column name?
     Is the problem reasonable ?  How do you think about this problem? why?
     I  am looking forward to hearing from you.

     Best regards.
         WQG