BUG #2501: JOIN and capitial letters in Table Row

Поиск
Список
Период
Сортировка
Искать
От
ALL
Тема
BUG #2501: JOIN and capitial letters in Table Row
Дата
Msg-id
200606280313.k5S3DSWY080672@wwwmaster.postgresql.org
Список
Дерево обсуждения
BUG #2501: JOIN and capitial letters in Table Row "ALL" <thegreatall@gmail.com>
Re: BUG #2501: JOIN and capitial letters in Table Row "Jim C. Nasby" <jnasby@pervasive.com>
The following bug has been logged online:

Bug reference:      2501
Logged by:          ALL
Email address:      thegreatall@gmail.com
PostgreSQL version: 8.1
Operating system:   Windows
Description:        JOIN and capitial letters in Table Row
Details: 

I had a table as like the following named products:

id	ClientID	ProductID	is_multiqty	is_active
1	12345	1000001	1	1
2	12345	1000002	0	1

and another table named productoptions with the following:

id	ProductID	Sku	Description	OptionID	minpayments	maxpayments	maxqty	is_acti
ve
1	1000001	somedesc1	1	1	1	0	1
1	1000002	CX7535	somedesc2	1	1	3	0	1

when I ran the following sql I got: ""ERROR:  column product.ProductID does
not exist":

SELECT *
FROM products
JOIN productoptions
ON products.ProductID = productoptions.ProductID

However, if i changed the name of the fields in the database to:

"productid"

It would work fine.
В списке pgsql-bugs по дате отправления
От:
Дата:
От: William ZHANG
Дата:
FAQ