[sqlite] 答复: Very Strange and Interesting Problem

[王庆刚]

https://www.sqlite.org/lang_createtable.html#rowid
The above link websit is very valuable.
Thanks for Quan Yong Zhai.







At 2015-12-14 19:08:59, "Quan Yong Zhai"  wrote:
>https://www.sqlite.org/lang_createtable.html#rowid
>
>???: ???
>: ?2015/?12/?14 18:21
>???: sqlite-users at mailinglists.sqlite.orgmailinglists.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
>___
>sqlite-users mailing list
>sqlite-users at mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] 答复: Very Strange and Interesting Problem

[Quan Yong Zhai]

https://www.sqlite.org/lang_createtable.html#rowid

???: ???
: ?2015/?12/?14 18:21
???: 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