Leonid Vorontsov wrote:

Have you done what the error description suggests? Mind you, if I was a
query optimiser, I think one look at your SQL, and I'd vomit as well. I'd
have to check the manual to see if some of that is legal SQL, but I'm sure
you've done that already.

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+

sending to informix-list

--0__=88BBE731DFC2607B8f9e8a93df938690918c88BBE731DF C2607B
Content-type: text/plain; charset=US-ASCII





Did you migrate/upgrade recently ??? I've seen this error when
upgrades/migrations happen. I would suggest dropping distributions and
re-running update statistics for the tables in the query.

HTH

Thanx much,

Rajib Sarkar
Advisory Software Engineer (RAS)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
T/L : 667-2100

As long as you derive inner help and comfort from anything, keep it --
Mahatma Gandhi



"Leonid
Vorontsov" To: informix-list (AT) iiug (DOT) org
<Leonids.Voroncov cc:
s (AT) dati (DOT) lv> Subject: -640 : QPlan sanity failure (2139.3).
Sent by:
owner-informix-li
st (AT) iiug (DOT) org


09/15/2003 12:36
AM
Please respond to
"Leonid
Vorontsov"





Hi All!
-------------------------
C:\INFORMIX>ver
Windows NT Version 4.0
C:\INFORMIX>onstat -
Informix Dynamic Server Version 7.31.TD6 -- On-Line -- Up 6 days
22:23:23 --
1706560 Kbytes
C:\INFORMIX>
-------------------------
Attached script gives subj error. Any comments?





#### repro.sql has been removed from this note on September 15, 2003 by
Rajib Sarkar

--0__=88BBE731DFC2607B8f9e8a93df938690918c88BBE731DF C2607B
Content-type: application/octet-stream;
name="repro.sql"
Content-Disposition: attachment; filename="repro.sql"
Content-transfer-encoding: base64

Q1JFQVRFIERBVEFCQVNFIGx2b194Ow0KQ1JFQVRFIFRBQkxFIG lhbl9wYXJza3MgKA0KCWlkX2lh
bnBhcnNrcyAgICAgIAlJTlQsDQoJaWRfdmlkZGFyYmluX2EgIC AgCUlOVCwNCglpZF9pYW5wYXJz
ayAgICAgICAJSU5ULA0KCWlkX3BpbHNwYWcgICAgICAgIAlJTl QsDQoJc3VtbWEgICAgICAgICAg
ICAgCURFQyggMTUsIDIgKSwNCglzdW1tYV92ICAgICAgICAgIC AJREVDKCAxNSwgMiApLA0KCXN1
bW1hX3AgICAgICAgICAgIAlERUMoIDE1LCAyICksDQoJYWtjZX B0X3AgICAgICAgICAgCUNIQVIs
DQoJbmVrb3Jla3RzICAgICAgICAgCUNIQVINCik7DQpDUkVBVE UgVEFCTEUgaWFuX3BhcnNrciAo
DQoJaWRfaWFucGFyc2tyICAgICAgCUlOVCwNCglpZF92aWRkYX JiaW5fYSAgICAJSU5ULA0KCWlk
X2lhbnBhcnNrICAgICAgIAlJTlQsDQoJaWRfaWFudmVpZHMgIC AgICAgCUlOVCwNCglpZF9waWxz
cGFnICAgICAgICAJSU5ULA0KCW51bXVycyAgICAgICAgICAgIA lWQVJDSEFSKCAxMCApLA0KCXN1
bW1hICAgICAgICAgICAgIAlERUMoIDE1LCAyICksDQoJc3VtbW FfdiAgICAgICAgICAgCURFQygg
MTUsIDIgKSwNCglzdW1tYV9wICAgICAgICAgICAJREVDKCAxNS wgMiApLA0KCWFrY2VwdF9wICAg
ICAgICAgIAlDSEFSLA0KCW51bV9wayAgICAgICAgICAgIAlTTU FMTElOVCwNCgljZXRfbWVuICAg
ICAgICAgICAJU01BTExJTlQsDQoJc3RhdHVzcyAgICAgICAgIC AgCUNIQVIsDQoJa29tZW50ICAg
ICAgICAgICAgCVZBUkNIQVIoIDEwMCApLA0KCWRpZW5hcyAgIC AgICAgICAgIAlTTUFMTElOVCwN
CgluZWtvcmVrdHMgICAgICAgICAJQ0hBUiwNCglsaWNlbmNlX2 51bSAgICAgICAJVkFSQ0hBUigg
MjAgKSwNCglsaWNlbmNlX2RhdCAgICAgICAJREFURQ0KKTsNCg 0KLS0gRFJPUCBQUk9DRURVUkUg
cmVwcm9kdWNlbA0KQ1JFQVRFIFBST0NFRFVSRSByZXByb2R1Y2 UoIGRpaWQgSU5UICkNCglERUZJ
TkUgZHRpZCBJTlQ7DQoJTEVUIGR0aWQgPSAxOw0KCVVQREFURQ lJQU5fUEFSU0tTDQoJU0VUCUlB
Tl9QQVJTS1MuTkVLT1JFS1RTID0NCgkJCShDQVNFIFdIRU4gKF NFTEVDVCBjb3VudCgqKSBmcm9t
IElBTl9QQVJTS1IgYg0KCQkJCVdIRVJFCWIuaWRfcGlsc3BhZy A9SUFOX1BBUlNLUy5pZF9waWxz
cGFnIGFuZA0KCQkJCQliLmlkX2lhbnBhcnNrID0gSUFOX1BBUl NLUy5pZF9pYW5wYXJzayAgDQoJ
CQkJZ3JvdXAgYnkgaWRfcGlsc3BhZw0KCQkJCWhhdmluZwkoY2 FzZSB3aGVuIGR0aWQgaW4gKCAx
ICkgdGhlbiANCgkJCQkJCWlhbl9wYXJza3Muc3VtbWEgZWxzZS BzdW0oYi5zdW1tYSkgIGVuZCAp
ID0gSUFOX1BBUlNLUy5zdW1tYSBhbmQgDQoJCQkJCXN1bShiLn N1bW1hX3YpID1JQU5fUEFSU0tT
LnN1bW1hX3YgYW5kDQoJCQkJCXN1bShiLnN1bW1hX3ApID0gSU FOX1BBUlNLUy5zdW1tYV9wICAp
ID4wDQoJCQlUSEVOIChDQVNFIFdIRU4gKFNVTU1BID0gU1VNTU FfUCArIFNVTU1BX1YpIFRIRU4g
MCBFTFNFIDEgRU5EKSBFTFNFIDEgRU5EKQ0KCVdIRVJFIElBTl 9QQVJTS1MuaWRfaWFucGFyc2sg
PSBkaWlkOw0KRU5EIFBST0NFRFVSRTsNCkVYRUNVVEUgUFJPQ0 VEVVJFIHJlcHJvZHVjZSggMSAp
Ow0K

--0__=88BBE731DFC2607B8f9e8a93df938690918c88BBE731DF C2607B--

sending to informix-list