github-starred/ollama
2
0
Fork 0
mirror of https://github.com/ollama/ollama.git synced 2026-07-16 13:19:40 -05:00
Code Issues 16.9k Packages Projects Releases 122 Wiki Activity

[GH-ISSUE #1820] Pulled SQLCoder2 even though it's not listed in the library #47548

New Issue
Closed
opened 2026-04-28 04:08:45 -05:00 by GiteaMirror · 2 comments
GiteaMirror commented 2026-04-28 04:08:45 -05:00
Owner
Copy Link

Originally created by @lestan on GitHub (Jan 6, 2024).
Original GitHub issue: https://github.com/ollama/ollama/issues/1820

I wanted to test out sqlcoder2, but only saw sqlcoder on the model library page

I still tried to see what would happen if I ran Ollama pull sqlcoder2...and it worked

It pulled down the model named sqlcoder2:latest

Is this an issue with the model library not being up to date or is it downloading sqlcoder (assuming v1) even though I'm asking for sqlcoder2.

Here's the output of the modelfile

lestan@Lestans-MacBook-Pro learn-text-to-sql % ollama show sqlcoder2 --modelfile 
# Modelfile generated by "ollama show"
# To build a new Modelfile based on this one, replace the FROM line with:
# FROM sqlcoder2:latest

FROM /Users/lestan/.ollama/models/blobs/sha256:4018b30faaf8b1e4cedad4dff4871f74e369950ddd25a0a4e8b0657a18710517
TEMPLATE """{{ .Prompt }}"""
PARAMETER stop "<|endoftext|>"
Originally created by @lestan on GitHub (Jan 6, 2024). Original GitHub issue: https://github.com/ollama/ollama/issues/1820 I wanted to test out sqlcoder2, but only saw sqlcoder on the [model library page](https://ollama.ai/library?sort=newest&q=llama) I still tried to see what would happen if I ran Ollama pull sqlcoder2...and it worked It pulled down the model named sqlcoder2:latest Is this an issue with the model library not being up to date or is it downloading sqlcoder (assuming v1) even though I'm asking for sqlcoder2. Here's the output of the modelfile ``` lestan@Lestans-MacBook-Pro learn-text-to-sql % ollama show sqlcoder2 --modelfile # Modelfile generated by "ollama show" # To build a new Modelfile based on this one, replace the FROM line with: # FROM sqlcoder2:latest FROM /Users/lestan/.ollama/models/blobs/sha256:4018b30faaf8b1e4cedad4dff4871f74e369950ddd25a0a4e8b0657a18710517 TEMPLATE """{{ .Prompt }}""" PARAMETER stop "<|endoftext|>" ```
GiteaMirror commented 2026-04-28 04:08:47 -05:00
Author
Owner
Copy Link

@igorschlum commented on GitHub (Jan 8, 2024):

Hi @lestan

SQLcoder2 seams to be a valid model. It's bigger than SQLCoder (9 GB instead of 4.1).

It could be a copy of sqlcoder:15b what has the same size.

Ollama pull sqlcoder2
pulling manifest
pulling 4018b30faaf8... 100% ▕████████████████▏ 9.0 GB
pulling a67353d85e36... 100% ▕████████████████▏ 21 KB
pulling 1576480a555b... 100% ▕████████████████▏ 36 B
pulling 1cc25ac1ef96... 100% ▕████████████████▏ 386 B
verifying sha256 digest
writing manifest
removing any unused layers
success
(base) igor@Mac-Studio-192 ~ % ollama show sqlcoder2 --modelfile
Modelfile generated by "ollama show"
To build a new Modelfile based on this one, replace the FROM line with:
FROM sqlcoder2:latest

FROM /Users/igor/.ollama/models/blobs/sha256:4018b30faaf8b1e4cedad4dff4871f74e369950ddd25a0a4e8b0657a18710517
TEMPLATE """{{ .Prompt }}"""
PARAMETER stop "<|endoftext|>"
(base) igor@Mac-Studio-192 ~ % ollama run sqlcoder2

  • give me the sql to delete a database

drop database ;

  • Send a message (/? for help)
<!-- gh-comment-id:1881708020 --> @igorschlum commented on GitHub (Jan 8, 2024): Hi @lestan SQLcoder2 seams to be a valid model. It's bigger than SQLCoder (9 GB instead of 4.1). It could be a copy of sqlcoder:15b what has the same size. Ollama pull sqlcoder2 pulling manifest pulling 4018b30faaf8... 100% ▕████████████████▏ 9.0 GB pulling a67353d85e36... 100% ▕████████████████▏ 21 KB pulling 1576480a555b... 100% ▕████████████████▏ 36 B pulling 1cc25ac1ef96... 100% ▕████████████████▏ 386 B verifying sha256 digest writing manifest removing any unused layers success (base) igor@Mac-Studio-192 ~ % ollama show sqlcoder2 --modelfile Modelfile generated by "ollama show" To build a new Modelfile based on this one, replace the FROM line with: FROM sqlcoder2:latest FROM /Users/igor/.ollama/models/blobs/sha256:4018b30faaf8b1e4cedad4dff4871f74e369950ddd25a0a4e8b0657a18710517 TEMPLATE """{{ .Prompt }}""" PARAMETER stop "<|endoftext|>" (base) igor@Mac-Studio-192 ~ % ollama run sqlcoder2 - give me the sql to delete a database drop database <database-name>; - Send a message (/? for help)
GiteaMirror commented 2026-04-28 04:08:47 -05:00
Author
Owner
Copy Link

@pdevine commented on GitHub (Mar 11, 2024):

We had set sqlcoder2 to be hidden while we were testing it, and then forgot to delete it. You should just use the sqlcoder model as it should be the most up-to-date. I've gone ahead and removed sqlcoder2 from the registry so you won't be able to pull it any more.

Thanks for the issue!

<!-- gh-comment-id:1989539499 --> @pdevine commented on GitHub (Mar 11, 2024): We had set `sqlcoder2` to be hidden while we were testing it, and then forgot to delete it. You should just use the `sqlcoder` model as it should be the most up-to-date. I've gone ahead and removed `sqlcoder2` from the registry so you won't be able to pull it any more. Thanks for the issue!
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
amd
api
app
bug
build
cli
cloud
compatibility
context-length
create
docker
documentation
embeddings
feature request
feedback wanted
good first issue
gpt-oss
gpu
harmony
help wanted
image
install
intel
js
launch
linux
macos
memory
mlx
model
needs more info
networking
nvidia
ollama.com
performance
pull-request
Mirrored from GitHub Pull Request
 python
question
registry
rendering
thinking
tools
top
vulkan
windows
wsl
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/ollama#47548
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?