fsprojects / fsprojects/Rezoom.SQL
Equivalent of GO;
Nobody has claimed this yet.
- Dominant language
- F#
- Stars
- 680
- Forks
- 23
- PR merge metrics
- No merged PRs in 30d
Description
The following fails at runtime with System.Data.SqlClient.SqlException: 'Invalid column name 'code'.'
alter table Users add column code int default 0;
update Users set code = id + 1000;
This is a consistent behaviour with SSMS. This is solved using by separating the statement with GO. I do recall your explanation on how GO is used to virtually separate scripts so they are run individually. There is however no such equivalent statement. The current workaround is having the statements in different files.
Is it possible to have a statement that is equivalent to GO? Also, I'm not really sure if it is possible but if such codes can give an error at compile time, it will be very helpful since it will help with the statement that if it compiles, it works :)
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.
Research direction
Start by examining how the SQL compiler and typechecker handle multi-statement scripts and how statements are translated to the supported RDBMS backends. The issue is done when an equivalent batch-separation mechanism is defined and implemented, or the limitation receives a clear compile-time diagnostic or documented resolution.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- fsharp, sql
- Domain
- compilers, databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100