Devart Forums

Posted: **Fri 02 Oct 2015 09:57**

Hi,

after we switched to the actual version v6.6.9.0. we have the following issue with our
customers who still use Oracle v8.0.1.7:
every query with select <OPERATION> from TABLE AS <ALIAS_NAME>
ends up with an ORA-00904 error

sample query
select max(RECORD_ID) as ANZAHL from PROTOKOLL where AKTION_ID=2

the query thats causes the error - from dbmonitor

Code: Select all

SELECT 
  NULL, 
  I.TABLE_OWNER, 
  I.TABLE_NAME, 
  I.INDEX_NAME, 
  C.CONSTRAINT_NAME, 
  CASE 
    WHEN C.CONSTRAINT_TYPE = 'P' THEN 1 
    ELSE 0 
  END, 
  CASE 
    WHEN I.UNIQUENESS = 'UNIQUE' THEN 1 
    ELSE 0 
  END, 
  1 
FROM ALL_INDEXES I, ALL_CONSTRAINTS C 
WHERE
  I.TABLE_OWNER=C.OWNER(+) AND I.INDEX_NAME=C.INDEX_NAME(+) AND I.TABLE_NAME=C.TABLE_NAME(+) AND
  (
    1=1 OR
    (1=2)
  ) AND
  (
    LOWER(I.TABLE_OWNER) = LOWER(:1) OR
    (1=2)
  ) AND
  (
    I.TABLE_NAME = :2 OR
    (1=2)
  ) 
ORDER BY 
  I.TABLE_OWNER, 
  I.TABLE_NAME, 
  I.INDEX_NAME;

Thomas

---------------------------------------------------------------------------------------------------------------------
Delphi XE5

Parameters:
DriverName=DevartOracle
GetDriverFunc=getSQLDriverORA
LibraryName=dbexpoda40.dll
VendorLib=OCI.DLL
BlobSize=-1
DataBase=XE
ErrorResourceFile=
LocaleCode=0000
Password=****
Oracle TransIsolation=ReadCommited
RoleName=Normal
User_Name=TEST
LongStrings=True
InternalName=
UseQuoteChar=False
UseUnicode=False
UnicodeEnvironment=False
FetchAll=False
CharLength=0
Charset=WE8ISO8859P1
BCDPrecision=0
FloatPrecision=38
IntegerPrecision=10

Posted: **Mon 05 Oct 2015 05:14**

Hello,

Thank you for the sample, we have reproduced the described case, and we will fix this behavior in the next version.

Posted: **Mon 19 Oct 2015 07:40**

Hi,

there are about 70 customers who are waiting for that fix.
Can you give me an approximate date when the fix will be available.

Thomas

Posted: **Mon 19 Oct 2015 10:29**

We have already fixed the problem, and we can send you a night build in order for you to check this case on your sample. For this, please send your license number to alexp*devart*com.

Posted: **Wed 21 Oct 2015 12:08**

Thx for the night build.
But the fix doesen't work. We still have the same error.

Thomas

Posted: **Fri 23 Oct 2015 10:22**

The version sent to you contains another bug. We have already fixed it and will send the fixed version on Monday.

Posted: **Mon 26 Oct 2015 09:14**

I have sent you the new driver version

Devart Forums

select .... AS ..... fails with unknown column

select .... AS ..... fails with unknown column

Re: select .... AS ..... fails with unknown column

Re: select .... AS ..... fails with unknown column

Re: select .... AS ..... fails with unknown column

Re: select .... AS ..... fails with unknown column

Re: select .... AS ..... fails with unknown column

Re: select .... AS ..... fails with unknown column