Re: Informix BUG?

}From: Apostolos Dedes <uunet!rmy!emory!gatech!uunet.UU.NET!ge!dedes!dedes }Subject: Informix BUG? }Date: Thu, 17 Jun 93 12:56:02 EDT }X-Informix-List-Id: <list.2401 }Is the following a BUG or a "feature" of Informix 5.0? }I have 3 tables (not NULL terminated) : Order, Leg and Market. What does 'not NULL terminated' mean? }I have also 3 typedef defining a structure corresponding exactly to the }record structure of each table (ORDER, LEG and MARKET). }An instance of those 3 structures have been declared to ESQL (order, leg }and market). }If I code the following select statement : } $select O.* L.* M.* } into $order, $leg, $market } from Order O, Leg L, Market M } where O.order_number = "00010001" } AND L.order_number = O.order_number } AND M.market_code = L.market_code; }normally, the record from order must be in $order and the same for the leg }record and market record. }But, I saw that the order record is 'splitted' into $order, $leg and }$market, the leg record is splitted in $order and $market,... Can you show us the .c file generated from the .ec file, or rather, the part of it which contains the structure definitions and the part which contains the select statement. We'd also need to see the schema for the three tables. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h