Return type of stored procedures that use temporary tables
Nobody has claimed this yet.
Assessment
- Difficulty
- 5/5
- Estimated time
- Over a week
- Newbie friendliness
- 20/100
Research direction
The issue names no implementation files or tests. Start by reproducing the MSSQL procedure and inspecting Sql.GetDataContext().Procedures.Test.Invoke; done means the returned result sets are accessible, ideally with types or at least dynamically.
Written by the indexing model from the issue text.
Description
Description
Stored procedures such as the one below have a return type Unit when invoked.
Repro steps
- Create the stored procedure
CREATE PROCEDURE [Test]
AS
BEGIN
CREATE TABLE #_T (ID int NOT NULL, PRIMARY KEY (ID))
INSERT INTO #_T(ID)
VALUES (1)
SELECT 1
SELECT 2
SELECT 3
END
- Access the stored procedure using the type provider and inspect the result type
let value = Sql.GetDataContext().Procedures.Test.Invoke ()
// val value : Unit
Expected behavior
Ideally, I'd like to see each result set fully typed. In the worst case, I'd at least want to access the result sets in a dynamic fashion.
Actual behavior
The return type of the sproc is Unit and there is no way to access the returned data.
Known workarounds
None that I know of other than getting rid of temporary tables :)
Related information
- Used database
MSSQL - SQLProvider version
1.0.37
- Dominant language
- F#
- Stars
- 627
- Forks
- 147
- Avg merge
- 2h 2m
- Merged PRs (30d)
- 1
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from fsprojects/SQLProvider
-
enhancement
Difficulty 3/5 1-2 days Newbie friendliness 55/100
fsprojects/SQLProvider#872 · 2 comments ·
-
Repo Assist? Openenhancement
Difficulty 5/5 Over a week Newbie friendliness 10/100
fsprojects/SQLProvider#870 · 1 comment ·
-
postgresql
Difficulty 4/5 3-5 days Newbie friendliness 58/100
fsprojects/SQLProvider#869 · 2 comments ·
-
documentation
Difficulty 2/5 1-3 hours Newbie friendliness 42/100
fsprojects/SQLProvider#868 · 2 comments ·
-
sql server
Difficulty 4/5 3-5 days Newbie friendliness 45/100
fsprojects/SQLProvider#851 · 1 comment ·
All issues in fsprojects/SQLProvider
Similar issues
-
bug: AI Gateway client filter lists "Unknown" twice when NULL and literal Unknown clients coexist Openbug
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
-
[BUG] A column whose default is the empty string is drawn in the ER diagram as having no default Openbug database-provider good first issue hacktoberfest
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
libredb/libredb-studio#1030 · 6 comments ·
-
comp-datalake
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
ClickHouse/ClickHouse#121222 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
bug redshift
Difficulty 2/5 1-3 hours Newbie friendliness 88/100