canonical / canonical/sqlair

Using generic types as query arguments is not possible

Open
#162 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
19
Forks
10
PR merge metrics
No merged PRs in 30d

Description

Using a generic struct in queries is not possible

Consider preparing this query:
```sql
INSERT INTO unit_state_relation(*) VALUES ($unitStateKeyVal.*)
```
And passing a materialised `unitStateKeyVal[int]` to the call. This results:
```
preparing relation state insert query: preparing:: cannot prepare statement: input expression: parameter with type "unitStateKeyVal" missing (have "unitStateKeyVal[int]"): (*) VALUES ($unitStateKeyVal.*)
```
Trying to include the type parameter does not help. Preparing this:
```sql
INSERT INTO unit_state_relation(*) VALUES ($unitStateKeyVal[int].*)
```
Results in:
```
preparing relation state insert query: preparing:: cannot parse expression: column 44: unqualified type, expected unitStateKeyVal.* or unitStateKeyVal. or unitStateKeyVal[:]
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.