error: global name 's' is not defined

PAscal
2011-04-08
2013-04-15
  • PAscal

    PAscal - 2011-04-08

    select ROW_NUMBER() OVER (PARTITION BY D1.c6, D1.c7, D1.c8, D1.c9, D1.c10, D1.c11, D1.c1, D1.c3, D1.c4, D1.c13 ORDER BY D1.c6 DESC, D1.c7 DESC, D1.c8 DESC, D1.c9 DESC, D1.c10 DESC, D1.c11 DESC, D1.c1 DESC, D1.c3 DESC, D1.c4 DESC, D1.c13 DESC) as c14
    from D1

    Low priority … can always by removed manually

    PAscal

     
  • alxtoth

    alxtoth - 2011-04-13

    If OVER and PARTITION BY would be parsed properly, there would be a column with content bellow .

    ROW_NUMBER() OVER (PARTITION BY … ) as c14

    Is this what you're looking for ?

     
  • PAscal

    PAscal - 2011-04-13

    My first concern was that the message didn't show were the error was …
    The exception from revj.py is more readable
    __main__.MallformedSQLException: Too may dots in identifier: …
    but not transmitted to the web interface.

    After, It could even return
    ROW_NUMBER() as c14 ,
    or
    … as c14,
    or
    ROW_NUM … as c14
    This is quite a rare function, spend the minimum time with it.

    Regards
    PAscal

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks