search

microsoft / vscode-postgresql

PostgreSQL extension for VSCODE
Other
392 stars 50 forks source link

Column auto suggestions don't work if a previous select column has an alias #87

Open sivaraam opened 3 years ago

sivaraam commented 3 years ago

Steps to Reproduce:

  1. Connect to a Postgres instance using the extension.

  2. Open a new editor and switch language mode to SQL. Use the following query:

    SELECT tablename,
       schemaname,

FROM pg_catalog.pg_tables;
  3. Try to trigger auto-suggestions the third select column in the select query and observe that the suggestions are show as expected.

  4. Open a new editor and switch language mode to SQL. Use the following query:

    SELECT tablename,
       schemaname AS "schema",

FROM pg_catalog.pg_tables;
  5. Try to trigger auto-suggestions the third select column in the select query and observe that the suggestions are not show as expected. In fact, only the snippet suggestions are shown. Not even the keyword suggestions.