On Mon, Dec 14, 2015 at 11:47 AM, Stephan Beal <sgbeal at googlemail.com> wrote:
> On Mon, Dec 14, 2015 at 11:21 AM, ??? <2004wqg2008 at 163.com> wrote: > >> 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,... > > > 1) if you do not alias column names using "AS" then the name you get from >> the db driver is UNDEFINED. It might call all of them "foo" and still be >> legal. The ONLY way to guaranty the names is to use "AS" to give them an >> explicit name. >> > > > 2) i'm guessing that you are using an abstraction layer which is changing > the returned name of your rowid. > i overlooked that you explicitly declared a rowid replacement. That is the reason for what you are seeing. The link from Quan explains it in more detail. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf