Example does not work on cockroachdb

[seaql]

Example does not work on cockroachdb

[RemiKalbe]

No problem, I'll open a PR.

[tyt2y3]

https://www.cockroachlabs.com/docs/stable/int.html

You have to change all 32 bit integers to 64 bit ones.

But strictly speaking, it should not be a problem, because CockroachDB 'should be' syntax compatible with Postgres. So the problems are only how we drive the queries.

Let us know if you succeeded.

[RemiKalbe]

I changed

struct CharacterStruct {
    id: i32,
    character: String,
    font_size: i32,
}

to

struct CharacterStruct {
    id: i64,
    character: String,
    font_size: i64,
}

and

let id: i32 = row.try_get(0).unwrap();

to

let id: i64 = row.try_get(0).unwrap();

But I'm still getting the same error, so I tried changing:

.integer()

to

.big_integer()

still the same error.
Did I forget something?

[billy1624]

Hi @RemiKalbe, so after all these changes. You still got the same error?

[tyt2y3]

I believe the literals have to be changed to 64 bit too, e.g. 12u64 24u64

[RemiKalbe]

Indeed, changing the literals make it work. I also tried the JSON example, and it also works. Thank you 😄

[tyt2y3]

Great. If you don't mind, perhaps you can publish your fork? May be we can add it to our examples!