Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

subquery without alias

PAscal
2011-03-31
2013-04-15
  • PAscal
    PAscal
    2011-03-31


    select * from
    (select A.id from A)

    fails without error … could an error be raised ?

    Regards
    PAscal

     
  • PAscal
    PAscal
    2011-04-04

    select A.id,count(*) from (select A.id from A)
    group by  A.id

    Fails with error "identifier a refers to unknown table or alias"
    Same origin … and as difficult to treat

    Regards
    Pascal

     
  • alxtoth
    alxtoth
    2011-04-05

    this fails:

    select A.id,count(*) from (select A.id from A)

    this is manual workaround, add alias for the subselect

    select A.id,count(*) from (select A.id from A) a

    -Alex

     
  • PAscal
    PAscal
    2011-04-08

    for

    select A.id,count(*) from (select A.id from A)
    group by A.id

    It doesn't work with revj, because RDBMS refuses this syntax …

    The only syntax supported in SQL is

    select id,count(*) from (select A.id from A)
    group by id

    without alias for subselect nor projection cols:
    Here is the Bug.

    Sorry for the time spent
    Regards
    PAscal

     
  • alxtoth
    alxtoth
    2011-04-13

    fixed in v0.44