Subject SELECT COUNT(*) causes Invalid Column Reference
Author Martijn Tonies
Hello Jason,

I'm trying the latest IBO if Database Workbench, and when running
an interactive query (that is: request live and so on) I'm getting
an error on a select count:

This query:
select
count(*)
from
ASSETS


is send to the server like this:

select
count(*)
, ASSETS.RDB$DB_KEY
from
ASSETS


Causing:
Dynamic SQL Error SQL error code = -104 invalid column reference

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com