Incorrect FROM statement is produced when a table name contains periods

Open
#793 2 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
3/5
Estimated time
1-2 days
Newbie friendliness
35/100
Issue type
Bug
Clarity
Mostly clear
Activity status
Stale
Tech stack
fsharp, sql
Domain
databases

Research direction

No source file or test is named. Start by reproducing the SQL Server query for the table A.B.C using ctx.Dbo.ABC, then trace how the table name is split and quoted. Done means generating FROM [dbo].[A.B.C] instead of FROM [dbo.A.B].[C].

Written by the indexing model from the issue text.

Description

sql server

Describe the bug

Using SQLProvider 1.3.8

Given a SQL table named A.B.C

This f# code: for t in ctx.Dbo.ABC

Produces this FROM statement when querying SQL Server: FROM [dbo.A.B].[C] instead of FROM [dbo].[A.B.C]

To Reproduce
See above

Expected behavior
I expect the correct FROM statement to be generated.

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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from fsprojects/SQLProvider

All issues in fsprojects/SQLProvider

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.