How to run a "raw" SQL query using Ecto.Adapters.SQL.query
- Dominant language
- No language data
- Stars
- 664
- Forks
- 41
- PR merge metrics
- No merged PRs in 30d
Description
On page 119 of Programming Phoenix there's an _example_ for how to write a "direct" SQL query:
```
Ecto.Adapters.SQL.query(Rumbl.Repo, "SELECT, power($1, $2)", [2, 10])
```
This does not `SELECT` any data from the database it (_is meant to_) merely calculate `2^10` which `should return 1024` ... _instead_ we see:
It's not a DB/connection error because other queries _work_! e.g:
So... I'm left scratching my head as to _how_ to run an SQL query using Ecto ...
has anyone `else` attempted to do this?
Contributor guide
Assessment
This issue has not been assessed yet.