ArgumentError when using ">=" select

[pablohirafuji]

Hi, thanks for open sourcing this package, it has been really useful!

I am having problem when using ">=" in a select statement:

Article.ByGeoHash
  |> select(:all)
  |> where(geohash: [">=": cursor])
  |> limit(10)
  |> Article.ByGeoHash.all()

It gives me this error:

** (exit) an exception was raised:
    ** (ArgumentError) cannot convert the given list to a string.

To be converted to a string, a list must contain only:

  * strings
  * integers representing Unicode codepoints
  * or a list containing one of these three elements

Please check the given list or call inspect/1 to get the list representation, got:

[>=: "6vjynkwp9wv"]

        (elixir) lib/list.ex:821: List.to_string/1
        (triton) lib/triton/validate.ex:41: Triton.Validate.coerce_fragment/2
        (elixir) lib/enum.ex:1294: Enum."-map/2-lists^map/1-0-"/2
        (elixir) lib/enum.ex:1294: Enum."-map/2-lists^map/1-0-"/2
        (triton) lib/triton/validate.ex:37: Triton.Validate.coerce/2
        (elixir) lib/enum.ex:1294: Enum."-map/2-lists^map/1-0-"/2
        (elixir) lib/enum.ex:1294: Enum."-map/2-lists^map/1-0-"/2
        (triton) lib/triton/validate.ex:5: Triton.Validate.coerce/1
        ...

I'm using Elixir v 1.6.4 on Windows 10.

[jonzlin95]

Try “>= “<> cursor

[pablohirafuji]

Yes, this works! Thank you! 😄

[pablohirafuji]

Hey, your solution does compiles, but it's not working properly. I tried adding some single quotes to the comparison([">=" <> "'0'"]) and gives me this error:

(MatchError) no match of right hand side value: {:error, "line 1:89 mismatched input '0' expecting EOF (... 1 AND geohash = '>='[0]...)"}

I think it is making a query like this: geohash = '>=0'.

[jonzlin95]

What is the exact query you're trying to make? It likely is a formatting issue somewhere.

[pablohirafuji]

The exact query is this:

Article.ByGeoHash
  |> select(:all)
  |> where(geohash: [">=" <> cursor])
  |> limit(10)
  |> Article.ByGeoHash.all()

cursor being a geohash string. It does compiles but always returns an empty list []. There is many entries in this materialized view and I tried changing ">=" to "<=". I tried this query:

Article.ByGeoHash
  |> select(:all)
  |> where(geohash: ["6vjyn" <> "kwp9wv"])
  |> limit(10)
  |> Article.ByGeoHash.all()

and it does return one result, wich has a geohash equal to "6vjynkwp9wv". So my feeling is that using <> in geohash: [">=" <> cursor] is constructing a query like geohash = '>=6vjynkwp9wv'.

[jonzlin95]

Ohh may be a tweak we need to make to Triton then. Don’t think either @weixiyen or I use “> and <“ in our queries

[pablohirafuji]

That is ok. I can take a look too and make a pull request, if you guys dont mind, but I am pretty new to Elixir.

[weixiyen]

I'll put a fix in tonight with a version update, have to wrap up some other stuff first.

[pablohirafuji]

Nice, thanks!

[weixiyen]

This issue is fixed in Version 0.2.0 @pablohirafuji

[pablohirafuji]

Thank you!