BUG (incomaptibility) in sql fransformation of __TABLE(class=alias)__

[prev] [thread] [next] [Date index for 2004/07/06]

Hi Tony,

we are using CDBI for all our perl application running against a major  
oracle db and are
very pleased with the results. Great work.

Recently, I run across an problem (incompatibility) with Oracle (SQL ISO  
standard).

My environment:
=======
Class::DBI (0.95) (I know it's not the newest but can't upgrade right now,  
don't think its solved in 0.96)
Class::DBI::Oracle (0.51)
Ima::DBI (0.33)
DBI (1.42)
DBD::Oracle (1.14)

Problem:
========

.....
CLASS->table('t_my_table');

CLASS->set_sql(some_sql => qq{ select c.* from __TABLE(some_class=c)__ });
.....

transforms into

'select c.* from t_my_table AS c'

Oracle fails to execute this statement! (ORA-00933)

I'm not deeply familiar with SQL-ISO standard but according to Oracle
specifications (and Oracle stuff is ISO certified), expression 'AS' my only
be used to define column aliases but newer to define table aliases.
Expected transformation should be:

'select c.* from t_my_table AS c'

Please correct me if I am wrong...
Thank for your feedback and all the afford.

- adam


        -- 
        -----------------------------------------------------------------------
Adam Przygienda
Computer Science Engineer SEC
SWISSCOM Enterprise Solutions AG
IP-Plus Internet services  http://www.ip-plus.net
mailto:  adam@xxxxxxx.xxx
phone: +41 (0)1 274 65 62   mobile: +41 (0)79 777 41 17
-----------------------------------------------------------------------