Issue with table-or-alias-name in Select Expression?

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Issue with table-or-alias-name in Select Expression?

Michael Lynch

I noticed that I cannot use a fully qualified table name in a select-item.   For example,

* the field alone name works: select TRANSACTION_NUMBER as "Invoice.TRANSACTION_NUMBER" from DATA_WAREHOUSE_SCHEMA.X_INVOICE_PREJOIN

* field name.table name works: select X_INVOICE_PREJOIN.TRANSACTION_NUMBER as "Invoice.TRANSACTION_NUMBER" from DATA_WAREHOUSE_SCHEMA.X_INVOICE_PREJOIN

* fully qualified table name does not work: select DATA_WAREHOUSE_SCHEMA.X_INVOICE_PREJOIN.TRANSACTION_NUMBER as "Invoice.TRANSACTION_NUMBER" from DATA_WAREHOUSE_SCHEMA.X_INVOICE_PREJOIN

Is this the expected behavior?  The BI tool we are using generates this style of field reference, and it works in other databases.   

This is not a bit issue as I can introduce an alias that the tool will use.

Michael Lynch
Software Architect
Integrated Services, Inc.

------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:

Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issue with table-or-alias-name in Select Expression?

John Sichi
Administrator
This is a known limitation:

http://issues.eigenbase.org/browse/FRG-140

Fully qualified column names were introduced in the SQL:2003 standard
(before that they were illegal), but LucidDB's validator has not
caught up yet.

JVS

On Thu, Sep 9, 2010 at 2:02 PM, Michael Lynch <[hidden email]> wrote:

>
> I noticed that I cannot use a fully qualified table name in a select-item.
> For example,
> * the field alone name works: select TRANSACTION_NUMBER as
> "Invoice.TRANSACTION_NUMBER" from DATA_WAREHOUSE_SCHEMA.X_INVOICE_PREJOIN
> * field name.table name works: select X_INVOICE_PREJOIN.TRANSACTION_NUMBER
> as "Invoice.TRANSACTION_NUMBER" from DATA_WAREHOUSE_SCHEMA.X_INVOICE_PREJOIN
> * fully qualified table name does not work: select
> DATA_WAREHOUSE_SCHEMA.X_INVOICE_PREJOIN.TRANSACTION_NUMBER as
> "Invoice.TRANSACTION_NUMBER" from DATA_WAREHOUSE_SCHEMA.X_INVOICE_PREJOIN
> Is this the expected behavior?  The BI tool we are using generates this
> style of field reference, and it works in other databases.
> This is not a bit issue as I can introduce an alias that the tool will use.
> Michael Lynch
> Software Architect
> Integrated Services, Inc.
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> luciddb-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/luciddb-users
>
>

------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:

Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issue with table-or-alias-name in Select Expression?

Michael Lynch

Thank you.


On Thu, Sep 9, 2010 at 2:06 PM, John Sichi <[hidden email]> wrote:
This is a known limitation:

http://issues.eigenbase.org/browse/FRG-140

Fully qualified column names were introduced in the SQL:2003 standard
(before that they were illegal), but LucidDB's validator has not
caught up yet.

JVS

On Thu, Sep 9, 2010 at 2:02 PM, Michael Lynch <[hidden email]> wrote:
>
> I noticed that I cannot use a fully qualified table name in a select-item.
> For example,
> * the field alone name works: select TRANSACTION_NUMBER as
> "Invoice.TRANSACTION_NUMBER" from DATA_WAREHOUSE_SCHEMA.X_INVOICE_PREJOIN
> * field name.table name works: select X_INVOICE_PREJOIN.TRANSACTION_NUMBER
> as "Invoice.TRANSACTION_NUMBER" from DATA_WAREHOUSE_SCHEMA.X_INVOICE_PREJOIN
> * fully qualified table name does not work: select
> DATA_WAREHOUSE_SCHEMA.X_INVOICE_PREJOIN.TRANSACTION_NUMBER as
> "Invoice.TRANSACTION_NUMBER" from DATA_WAREHOUSE_SCHEMA.X_INVOICE_PREJOIN
> Is this the expected behavior?  The BI tool we are using generates this
> style of field reference, and it works in other databases.
> This is not a bit issue as I can introduce an alias that the tool will use.
> Michael Lynch
> Software Architect
> Integrated Services, Inc.
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> luciddb-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/luciddb-users
>
>

------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:

Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users


------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:

Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
luciddb-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/luciddb-users
Loading...