[sqlite] Full column names in join command: table name is used in a result set instead of alias (libversion 3.4.2)

[Petr Fejfar]

Hi all,

I am upgrading an application from version 2.8.x to 3.4.2
and I have troubles with full column names.

I've preset pragmas
  short_column_names=OFF
  full_column_names=ON

Then various forms of the same SQL command:

1. SELECT frg.*, ses.saCOMIName,ses.saXXX,... FROM TxOTG_Fragments frg,  
TxOTG_Sessions ses
     WHERE (frg.pkFragmentGUID='...') and  
(frg.fkSessionGUID=ses.pkSessionGUID)

2. SELECT frg.*, ses.saCOMIName,ses.saXXX,... FROM TxOTG_Fragments frg
     INNER JOIN TxOTG_Sessions ses ON (frg.fkSessionGUID=ses.pkSessionGUID)
       WHERE (frg.pkFragmentGUID='...')

3. SELECT frg.*, ses.saCOMIName,ses.saXXX,... FROM TxOTG_Fragments AS frg
     INNER JOIN TxOTG_Sessions AS ses ON  
(frg.fkSessionGUID=ses.pkSessionGUID)
       WHERE (frg.pkFragmentGUID='...')


produce result set having correct frg.xxxx column names, but columns from
TxOTG_sessions table have are prefixed by the table name
i.e. TxOTG_Sessions.xxxx instead of alias.


Please, does anybody knows what I'm missing?


Thanks, pf

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------