You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Bryan Pendleton (JIRA)" <ji...@apache.org> on 2018/10/24 13:36:00 UTC
[jira] [Comment Edited] (DERBY-7013) ROW_NUMBER() OVER () no me
funciona
[ https://issues.apache.org/jira/browse/DERBY-7013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16662294#comment-16662294 ]
Bryan Pendleton edited comment on DERBY-7013 at 10/24/18 1:35 PM:
------------------------------------------------------------------
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*.
was (Author: bryanpendleton):
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)