Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Tables not showing when non tables are present #1379

Open
1 task done
ninjaguardian opened this issue Sep 14, 2024 · 3 comments
Open
1 task done

Tables not showing when non tables are present #1379

ninjaguardian opened this issue Sep 14, 2024 · 3 comments
Labels

Comments

@ninjaguardian
Copy link

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Make a .sql file and run this code:

SET @s=1;
SELECT @s;

Expected behavior
vscode should output a table with the value 1 for s.

Screenshots
image

Desktop (please complete the following information):

  • SQLTools Version 0.28.3
  • VS Code Version: 1.93.1
  • OS: Windows 11
  • Driver:
    • MySQL/MariaDB
  • Database version: MySQL 9.0
@ninjaguardian
Copy link
Author

This only occurs when there are multiple tabs. E.G. SET @s=1 and SELECT @s but if you go to the select and rerun, causing it to open by itself, it works.

@ninjaguardian
Copy link
Author

This seems to occur with multiple things.

SET @lolz = 1;
SELECT 1;

Even this does not work. It seems this bug happens when one tab is not a table, but another is.

@ninjaguardian ninjaguardian changed the title Variables broken in vscode mysql Tables not showing when non tables are present Sep 14, 2024
@catsmanac
Copy link

Same here (on mariadb with same tool version), need to run block by block to get the select output

-- @block
SET @lolz = 1;
-- @block
SELECT @lolz;

or where I hit it with missing select table output:

-- @block
set @periodstart = unix_timestamp('2023-02-18 16:00');
select 
      from_unixtime(start_ts)
from 
	  statistics 
where 
      metadata_id in (58)
      and start_ts < @periodstart 
order by
      metadata_id
      ,start_ts DESC
;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants