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

Stored procedure reporting multiple result-sets are not displayed in mssql-cli results #129

Closed
sethusrinivasan opened this issue Dec 27, 2017 · 4 comments
Assignees
Labels

Comments

@sethusrinivasan
Copy link
Contributor

  1. Create a database test1

  2. Create following stored proc
    CREATE OR ALTER PROC sp_test_multiple_results
    AS
    BEGIN
    SELECT TOP 10 name,object_id from sys.objects
    SELECT TOP 10 name,object_id from sys.columns
    END

  3. run mssql-cli and execute this proc

Outcome:
Only first result set is displayed
mssql-cli
image

Expected:
All resultsets to be displayed to user and should be consistent with other tools like SSMS / sqlcmd

SSMS:
image

sqlcmd:
image

@abhisheksinha89
Copy link
Contributor

Will look into this

@abhisheksinha89
Copy link
Contributor

Found the root cause of this issue, working on a fix

@abhisheksinha89
Copy link
Contributor

@pensivebrian @sethusrinivasan : Above PR to fix this issue

@abhisheksinha89
Copy link
Contributor

This should be fixed in 0.9.0 and later

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

3 participants