Sort on Editor|Data grid disabled

Toad for Oracle - Beta
1

Unable to sort the data grid if SELECT statement contains analitical function which has an ORDER BY tag.

See the following sample:

SELECT owner,
object_name,
object_id,
count (1) OVER (PARTITION BY owner ORDER BY 1) AS sorrend
FROM all_objects

2

Can someone reproduce the error?

3

Yes, I can. I can look at it for next release.

On 09/29/2015 01:53 PM, drbubo20 wrote:

RE: Sort on Editor|Data grid disabled

Reply by drbubo20
Can someone reproduce the error?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

4

Fixed for first 12.9 beta.

On 09/22/2015 03:02 PM, drbubo20 wrote:

Sort on Editor|Data grid disabled

Thread created by drbubo20
Unable to sort the data grid if SELECT statement contains analitical function which has an ORDER BY tag.

See the following sample:

SELECT owner,

   object_name,

   object_id,

   count (1) OVER (PARTITION BY owner ORDER BY 1) AS sorrend

FROM all_objects

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.