How can we help you today? How can we help you today?

"test snippet" can cause sqlprompt to hang

excellent tool! :lol:

one problem though. :cry:

i entered a snippet that looked like this: " INNER JOIN" (i.e., a tab character followed by the text 'INNER JOIN' and without trailing spaces or tabs).

When i hit "Test Snippet" the program hung (while showing some flickery animated text in the test snippet text box).
:shock:
I've recorded this happening and you can view an animation of it here:

http://secretgeek.net/image/sqlprompt_hangs.gif
secretGeek
0

Comments

3 comments

Sort by
  • Neil Davidson
    Thanks for this.

    We'll take a look at it.
    Neil Davidson
    0
  • Bart Read
    Hi secretGeek,


    Yeah... that's definitely not right. Thanks for reporting it. We're starting work on SQL Prompt 3 and will make sure this is fixed in the new version.


    Many thanks,
    Bart Read
    0
  • Marsha Wilson

    Hi Community,

    It sounds like SQL Prompt is struggling with how it processes whitespace before INNER JOIN. A tab character without trailing spaces might be causing a parsing issue, leading to a hang. Have you tried adjusting formatting or checking for hidden characters? It reminds me of how an animated app might freeze if it encounters unexpected input—like a missing frame in an animation disrupting smooth playback. Could be worth testing with a space instead of a tab to see if that resolves it!

    Thanks!

    Marsha Wilson
    0

Add comment

Please sign in to leave a comment.