dwb@pti.UUCP (Don W. Bacon) (04/12/91)
There is a problem with an SQL inquiry on single-character fields that may be related to btrees. I am wondering if anyone else has encountered this problem and has a work-around. I FAX'd details on this bug to Unify in January, but they have not been particularly helpfull. Here's the bug: I have a single character field in a table that is also part of a multi-field btree on that table. The following simple SQL statements both fail: > select * from Tablename where Fieldname = 'Y'/ > select * from Tablename where Fieldname = 'Y*'/ Result is no records selected (there are in fact many). However, the following SQL statement DOES display the correct records: > select * from Tablename where Fieldname = '*Y'/ All statements work fine on 1-char fields that are not part of btrees. This occurs in Unify 5.0, but works fine in 4.0 and is preventing us from upgrading to the next rev. Our Unify support contract has helped not one iota in getting a resolution to this. Any assistance from net readers would be greatly appreciated (please email or phone). Thank you. Donald W. Bacon (dwb) Phoenix Telecom Rochester, NY 716-224-2210