[comp.databases] UNIFY SQL problems

campbell@Thalatta.COM (Bill Campbell) (02/23/90)

I have a strange problem with SQL under UNIFY 4.0.  A SQL script of the
form:

	select
		voucher.Number,
		voucher.Date,
		voucher.Balance_due,
		vendor.Vendor_number
		vendor.Name
	from voucher, vendor
	where
		voucher.Balance_due ^= 0 and vendor.Balance_due ^= 0
		and vendor.Vendor_number = voucher.Vendor_number
	/

produces a cartesion join of the voucher and vendor files instead of
joining on the Vendor_number columns even though they have an explicit
links on these columns!

This is part of a production accounting system and has been working for
several years and works properly on all my customer systems except one.  This
same data file has shown some quirky behaviour in SQL queries in the past.

I have run REKEY and REPOINT on the data base, but this didn't correct
the problem.

I have tried different versions of SQL with the same result.

I suspect some corruption in the file, but all functions except SQL work
properly.  The data base is almost 70 Meg and has been reconfigured recently
to increase table sizes.

Does anyone have any suggestions?

....microsoft--\					Bill Campbell; Celestial Software
...uw-beaver-----!thebes!camco!bill	6641 East Mercer Way
....fluke------/					Mercer Island, Wa 98040
....hplsla----/						(206) 232-4164 (206) 947-5591
-- 
....microsoft--\					Bill Campbell; Celestial Software
...uw-beaver-----!thebes!camco!bill	6641 East Mercer Way
....fluke------/					Mercer Island, Wa 98040
....hplsla----/						(206) 232-4164