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

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
Thomas.Schweikert
Posts: 30
Joined: Tue 27 Jun 2006 15:46

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

Post by Thomas.Schweikert » 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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

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

Post by AlexP » 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.

Thomas.Schweikert
Posts: 30
Joined: Tue 27 Jun 2006 15:46

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

Post by Thomas.Schweikert » 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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

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

Post by AlexP » 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.

Thomas.Schweikert
Posts: 30
Joined: Tue 27 Jun 2006 15:46

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

Post by Thomas.Schweikert » Wed 21 Oct 2015 12:08

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

Thomas

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

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

Post by AlexP » 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.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

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

Post by AlexP » Mon 26 Oct 2015 09:14

I have sent you the new driver version

Post Reply