Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!uwm.edu!cs.utexas.edu!execu!sequoia!natinst!kenm
From: kenm@natinst.com (Ken McKinney)
Newsgroups: comp.databases
Subject: Apparent Informix SQL bug
Keywords: Informix,SQL,bug
Message-ID: <10578@natinst.natinst.com>
Date: 25 May 90 21:46:27 GMT
Organization: National Instruments, Austin, TX
Lines: 32


    We've just upgraded to a new version of Informix SQL (the old one was
crashing our new 3B2-1000).  All of a sudden I'm encountering really strange
problems when running ACE reports.  The reports compile correctly, then error
out with message # -217, column(column_name) is not found in any table in the
query, or something like that.  But the column is in one of the tables which
my select clause references.

Here's the wierd part which convinces me I've got a real bug.

by altering the order of the columns in my select statement I can change the
column which is reported as not found.  For example

    select compnme,shpzip,customer_id,partdesc,quantity......
 
wrongly says that column customer_id is not in any of the (3) referenced tables.
          
    select customer_id,compnme,shpzip,partdesc,quantity.......

says that shpzip is not in any of the tables.

Nothing is changed save the ordering of the columns in the select statement.

Has anyone encountered a similar problem?  Does Informix acknowledge this as
a bug?

Any help would be greatly appreciated.

Ken McKinney
(kenm@natinst.com)
National Instruments
Austin,Texas