[Zope] Odd MySQL exception

[Patrick Lewis]

This is one of those requests where I hope I don't find the answer two
seconds after I send it, but I am stumped, so here it goes:

I have a Z SQL method named get_bs that I am trying to get to
work. After playing around with it, I think I have narrowed down the
problem.  With the query template:

select cash from bal_sheet

I get:

---
Error, exceptions.KeyError: unhandled 

SQL used:

select cash from bal_sheet
---

Here is the relevant traceback:

<!--
Traceback (innermost last):
  File /usr/local/zope/Zope-2.0.0a4-src/lib/python/ZPublisher/Publish.py,
line 256, in publish_module
  File /usr/local/zope/Zope-2.0.0a4-src/lib/python/ZPublisher/Publish.py,
line 161, in publish
  File /usr/local/zope/Zope-2.0.0a4-src/lib/python/ZPublisher/mapply.py,
line 154, in mapply
    (Object: manage_test)
  File /usr/local/zope/Zope-2.0.0a4-src/lib/python/ZPublisher/Publish.py,
line 98, in call_object
    (Object: manage_test)
  File /usr/local/zope/Zope-2.0.0a4-src/lib/python/Shared/DC/ZRDB/DA.py,
line 310, in manage_test
    (Object: get_bs)
  File /usr/local/zope/Zope-2.0.0a4-src/lib/python/Shared/DC/ZRDB/DA.py,
line 291, in manage_test
    (Object: get_bs)
  File /usr/local/zope/Zope-2.0.0a4-src/lib/python/Shared/DC/ZRDB/DA.py,
line 395, in __call__
    (Object: get_bs)
  File
/usr/local/zope/Zope-2.0.0a4-src/lib/python/Products/ZMySQLDA/db.py, line
191, in query
KeyError: (see above)

-->

I believe the problem is with the bal_sheet table, because
"select * from bal_sheet" or any other multi-column select gives me
the same exception.

I haven't seen this issue on other tables in my database.  The query
works as expected at the mysql console prompt. 

Any ideas for a workaround or suggestions as to what I could be doing
wrong?

Patrick Lewis <pl@teleport.com>