ElementsProject / ElementsProject/glightning

Cannot use SQL method with WHERE something > number

Open
#17 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Go
Stars
11
Forks
16
PR merge metrics
No merged PRs in 30d

Description

This query works using lighting-cli:
```
$ lightning-cli sql -k query="SELECT * FROM htlcs WHERE expiry > 1;"
{
"rows": [
[
2381,
```

It also works using JSON-RPC in shell:
```
$ echo '{"method": "sql", "params": {"query": "SELECT * FROM htlcs WHERE expiry > 1;"}, "id": 1, "jsonrpc": "2.0"}' | nc -U ${PWD}/.lightning/testnet/lightning-rpc
{"jsonrpc":"2.0","id":1,"result":{"rows":[[2456,"2821409x111x0",0,2821429,1000000,"in","c95ad151010e9cc14238bce909e6e8545258fc07d0e00c98a4b5ff90ac049e61","SENT_REMOVE_ACK_REVOCATION"],[2457,"2821
```

But it DOES NOT work with glightning:
```
type SQLRequest struct {
Query string `json:"query"`
}

func (r SQLRequest) Name() string {
return "sql"
}
....
// this fails with error
// -1:query failed with unrecognized token: "\"
err = lightning.Request(&SQLRequest{
Query: "SELECT * FROM htlcs WHERE expiry > 1;",
}, &response)
```

glightning is apparently escaping > with \\, but I cannot find where.

[here](https://github.com/Impa10r/test) is the test repo.

Output:
```
2024/09/05 16:44:11 Rows: 75
2024/09/05 16:44:11 Rows: 0
2024/09/05 16:44:11 SQLRequest: -1:query failed with unrecognized token: "\"
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.