[CLOSED] (Bugged) Query.select = 500 general unknown error

[raven hull]

When I use Query.select (Appwrite 1.3.7) I get general unknown error on Flutter.

Those are the queries I'm performing:

[
Query.equal("Attribute1", "attribute"),
Query.startsWith("\$createdAt", "date"),
Query.select(["\$createdAt"]),
]```

If I remove Query.select everything works fine

[amber stirrup]

Does order of the Query's important?

[raven hull]

I tried changing order and same error, so I think in such case is not important?

I get in sentry this error:
Can not select attributes: $createdAt

And this one too:
SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'value' at row 1

Tied with other attributes and same error

[wide spire]

Same on my side, error 500.

(With appwrite 1.3.8 self-hosted)

[light moat]

did you create an index for createdAt 😅

[raven hull]

Is it needed an index for that? 👀

[light moat]

maybe, I'm not sure lol

give it a try i guess

[raven hull]

Yes, will try

[half cedar]

Take a look here
https://github.com/appwrite/appwrite/issues/5376
It seems like it will be added in the next version
https://github.com/utopia-php/database/pull/299/files

[raven hull]

Not using relationships

[half cedar]

Yes
I think that part is not in relationships only

[raven hull]

I'm trying to perform this in a standard document and throws the mentioned error

[half cedar]

You can see here https://github.com/utopia-php/database/pull/299/files that the $createdAt was always added
Till the change on the right in which it checks each field

Giving you the ability to select them

[raven hull]

Then why I get such error?

Oh, so you mean it's bugged for now until this pr is merged (new Appwrite version released)?

[half cedar]

Yep

[raven hull]

https://github.com/appwrite/appwrite/milestone/16

56% completed... I'm anxious to see that 100%

Edit: now 58, some good progress
Edit 2: 70% this is fassst

[BUGGED] Query.select = 500 general unknown error

Uh, maybe closed is better or what?

[half cedar]

I went over the code again,

[raven hull]

[CLOSED] (Bugged) Query.select = 500 general unknown error