Strange behavior in SQL Window

[Roeland]

1) Open a SQL window
2) Copy, Paste and Execute this code

select just_a_column,
       LPAD('a',100,'x') || ' ' ||
       LPAD('a',100,'x') || ' ' ||
       LPAD('a',100,'x') || ' ' ||
       LPAD('a',100,'x') || ' ' ||
       LPAD('a',100,'x') || ' ' ||
       LPAD('a',100,'x') || ' ' ||
       LPAD('a',100,'x') || ' ' ||
       LPAD('a',100,'x') || ' ' ||
       LPAD('a',100,'x') || ' ' ||
       LPAD('a',91,'x') Text
from (SELECT LEVEL just_a_column
    FROM   dual
    CONNECT BY LEVEL <= 100)

A) Notice that you see "Multiline" records. If you change the "91" to "90" these multilines disappear. Go back to "91" or more for the next issue.

3) In "Multiline" mode, scroll down until the visible top record is no longer the first record.
4) Drag and drop the columns so they switch place.
5) Execute the query again.

B) Notice that the visible top record is no longer the first record.
C) If you scroll up, you see that the first record is selected.

I don't really mind for issue A, but issue B is annoying because I thought that the query was ordered and that I was viewing the first record. I didn't understand the problem until I saw that I was seeing some outdated data...

Notice that issue C is only an issue when B is considered a feature...

Regards,

Roeland

PL/SQL Developer 9.0.0.1610

 

[Stew Stryker]

Roeland,

I see everything you're saying except C. In my instance, the first record is not selected. But I agree it's odd that the first row isn't visible any longer.

I'm running 9.0.1 on Windows 7.

Good luck,

Stew

 

[Marco Kalter]

We'll try to fix it.

 

[Roeland]

This is still an issue in Version 10.0.0.1685 Beta 5.