Re: Different Query results in Sql *Plus and Oracle ODBC 32Bit Test

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 21 Mar 2002 17:26:49 +0100
Message-ID: <8a2k9uococtsanrfuomt9kdqlgonmfpjis@4ax.com>

On 21 Mar 2002 07:31:03 -0800, mahua_at_saisoft.com (Mahua) wrote:

>1. I am simply using a test sql for testing purpose...the final query
>will have variables.
>
>2. Oracle version :8.0.3.0.0 for windows NT. Sql *Plus(version
>8.1.6.0.0) .Oracle ODBC 32Bit Test (version 2.5.3.1.0)
>
>3. I tried with a simple query without any where conditions and joins:
>"Select value from vcg.T_EMPLOYMENT_TYPE"
>and it gave 4 rows in ODBC 32Bit Test and 5 rows in Sql *Plus.
>Results:
>ODBC Test Sql *Plus
>1.Contract Hourly 1.ContractHourly
>2.Perm 2.Perm
>3.Contract Salary 3.Contract Salary
>4. Reference Contact 4.Contract
> 5.Reference Contact
>
>Thanks
>Mahua.

ODBC is known to rearrange/split queries in several queries even if you are only joining 3 tables.
Enable logging in the ODBC administrator applet will soon demonstrate this.
If you try to set all appropiate parentheses, in order to avoid ODBC applying a different priority scheme than sql*plus, are you still getting different results? I would try to check that out if I were you!

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Mar 21 2002 - 10:26:49 CST