First character not selected

[Jim Gust]

Now and again, I noticed that when statements run, the first character is not captured. This has probably happened to me 15 times in the last 6 months. I cannot recreate it, which leads me to believe it may be related to disconnection.

In the update statement below, notice how the first character is not selected, "U". This obviously results in an "ORA-00900: invalid SQL statement."

Closing and reopening the SQL window resolves the issue.

 

[Marco Kalter]

We'll investigate. I assume this is not reproducible?

 

[Jim Gust]

Correct, not reproducible.

 

[cassiusdrow]

I've had this issue intermittently since at least version 11, but I've never been able to reproduce it. Once it starts happening, it happens for every SQL statement in the SQL window. It's like the statement auto-selection parsing gets offset by one character. I also tend to put the semicolons between statements on a new line like the screenshot above, and the problem only happens when the last line in the SQL window is a semicolon possibly followed by a return character.

I correct the issue by selecting all text in the SQL Window, and then cut (ctrl+x) the text and paste the text back into the SQL window. The statement auto-selection works normally after that.

 

[WexSoft]

I also get this issue intermittently since at least version 11. I cannot reproduce it (and to be fair it has not happened recently), but it's caused by the generation of an odd special character which sometimes appears in my code as I am typing. I can type quite quickly and sometimes PSD does not have time to respond to what I have typed before the next piece is typed (e.g. I have the editor set to make keywords upper case, but if I type end if; really fast the end does not get converted to END). I have not figured out what key combination causes the funny special character to appear, but if you make special characters visible in the editor you can see the character - once that character is removed the auto select of SQL to be executed works fine.