How can we help you today? How can we help you today?

Alias duplicates on select statement

If i do a select statement from a table with the alias, then later try to add columns to the select, the alias will duplicate.

If i type the first few characters of the field it will work fine, if i prefix it with the alias, it will get added twice.


Starting with: 
SELECT 
FROM cus_Customer C

If i type first[space], last[space] i get: 
SELECT C.FirstName, C.Lastname
FROM cus_Customer C

If i type C.first[space], C.last[space] i get: 
SELECT C.C.FirstName, C.C.Lastname
FROM cus_Customer C
lysp
0

Comments

1 comment

Sort by
  • Bart Read
    Hi there,


    Thanks for this. Unfortunately I appear to have committed a bit of a schoolboy error with the alias generation that leads to duplicate aliases being created. Fortunately it's fairly easy to fix, but very annoying nonetheless.

    The c.c.FirstName issue actually affects a variety of identifiers, including those prefixed with schemas, table/view names, aliases etc, which we'll be fixing for the final release.


    Thanks,
    Bart
    Bart Read
    0

Add comment

Please sign in to leave a comment.