Обсуждение: OpenOffice and PostgreSQL: query with inner join
Hello,
my name is Ocke Janssen. I'm a developer of the database component in
OpenOffice and I encounter a problem (BUG) we have when executing a
query which contains two tables with a primary key. The statement looks
like this:
SELECT "test1"."name", "test1_1"."name" FROM "test1" "test1", "test1"
"test1_1" WHERE ( "test1"."id" = "test1_1"."id" )
When setting the statement attributes to KeysetDriven, I get the error
message that CTID is ambiguous. As far as I could see in the moment the
problem is in the fucntion inner_process_tokens in file convert.c where
CTID is added to the statemement. Is this problem known?
Best regards,
Ocke
--
dba.OpenOffice.org
Example isn't another way to teach,
it is the only way to teach.
Albert Einstein
Ocke Janssen wrote: > > Hello, > > my name is Ocke Janssen. I'm a developer of the database component in > OpenOffice and I encounter a problem (BUG) we have when executing a > query which contains two tables with a primary key. The statement looks > like this: > > SELECT "test1"."name", "test1_1"."name" FROM "test1" "test1", "test1" > "test1_1" WHERE ( "test1"."id" = "test1_1"."id" ) > > When setting the statement attributes to KeysetDriven, I get the error > message that CTID is ambiguous. As far as I could see in the moment the > problem is in the fucntion inner_process_tokens in file convert.c where > CTID is added to the statemement. Is this problem known? Maybe I found the cause. Please try the snapshot dll at http://www.geocities.jp/inocchichichi/psqlodbc/ . Thanks. Hiroshi Inoue http://www.geocities.jp/inocchichichi/psqlodbc/
Yes, it works. Thx. Best regards, Ocke Hiroshi Inoue wrote: >Ocke Janssen wrote: > > >Maybe I found the cause. >Please try the snapshot dll at > http://www.geocities.jp/inocchichichi/psqlodbc/ . > >Thanks. >Hiroshi Inoue > http://www.geocities.jp/inocchichichi/psqlodbc/ > > -- Example isn't another way to teach, it is the only way to teach. Albert Einstein