[Zope-DB] Bug: ZopeRDB does not handle empty column names

[Dieter Maurer]

Thomas_Janke@prisma-edv.de writes:
 > ....
 > SELECT topic_name, count(topic_name)
 > ....
 > When executing
 > the same code within an ZSQL-Method, I get the error
 > 
 > Error: ... : Empty column name,
Zope wants to allow you to access column values by name.
Therefore, it requires, there is a name and that the name is unique.

I do not think this will be considered a bug.

Use

	"SELECT topic_name, count(topic_name) AS topic_name_count"

and both Zope and you will be happy.


Dieter