db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-7013) ROW_NUMBER() OVER () no me funciona
Date Wed, 24 Oct 2018 13:35:00 GMT

    [ https://issues.apache.org/jira/browse/DERBY-7013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16662294#comment-16662294
] 

Bryan Pendleton commented on DERBY-7013:
----------------------------------------

10.1.1.0 is extremely old indeed! 

Have you tried contacting the people or organization which gave you this application?

If the Derby engine is embedded into the application itself, the application's author is the
best-suited to upgrade the Derby engine for you.

If you are just trying to *read *the data (not to update it), then one possibility is to make
a copy of the database (e.g., by making a backup and then restoring that backup to another
computer), and then upgrade the *copy* of the database and use a current version of Derby
against the *copy*.

> ROW_NUMBER() OVER () no me funciona
> -----------------------------------
>
>                 Key: DERBY-7013
>                 URL: https://issues.apache.org/jira/browse/DERBY-7013
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.4.1.3
>         Environment: Squirrel 3.8.1 y DerbyDriver 10.4.1.3
>            Reporter: Aitor T T
>            Priority: Blocker
>
> Mi consulta es muy clara, soy totalmente incapaz de ejecutar esto en mi SQUIRREL ver.
3.8.1 con driver para Derby ver. 10.4.1.3, tengo entendido que a partir de esta versión ya
se podía ejecutar sin problemas.
> Mi query es esta:
> _SELECT * FROM (_
>    _SELECT_ 
>      _ROW_NUMBER() OVER () AS R,_ 
>      _T.*_ 
>    _FROM "MOSQL"."SSAA_CAIDAS_MAQUINAS" AS T_
> _) AS TR_ 
>    _WHERE R <= 10;_
> Y el error devuelto es este:
> {color:#FF0000}Error: Error de sintaxis: Encountered "(" at line 3, column 24.{color}
> {color:#FF0000}SQLState:  42X01{color}
> {color:#FF0000}ErrorCode: -1{color}
> Estoy desesperado con esto, alguien que le haya pasado y me pueda ayudar....??? Necesito
en mi proyecto devolver las "N" primeras filas de una query y no veo manera de hacerlo en
Derby.
>  
> Gracias.
> Saludos.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message