[sqlite] 答复: Very Strange and Interesting Problem

[Quan Yong Zhai]

https://www.sqlite.org/lang_createtable.html#rowid
________________________________
???: ???<mailto:2004wqg2008 at 163.com>
????: ?2015/?12/?14 18:21
???: sqlite-users at mailinglists.sqlite.org<mailto:sqlite-users at 
mailinglists.sqlite.org>
??: [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








_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users