SQL Prompt Suggestions do not appear in Row_Number clause

naumad

When writing a row_number() clause, sometimes there are no column suggestions or automatic alias prefixing for the partition or order phrases:

row_number() over (partition by col1, col2, col3 order by col0 desc) as x

Michael Clark

Hi Naumad,

Sorry to hear that our column suggestions aren't always appearing.

Would it be possible to try updating to the latest version of SQL Prompt?

Have you managed to identify a pattern when the suggestions appear? Does it only affect col1 in your example or all columns?

row_number() over (partition by col1, col2, col3 order by col0 desc) as x

Best,

Michael Clark
Technical Lead, SQL Prompt

naumad

This is now working in v8.0.5.1758.