Varchar Last Char Gets Corrupted about loopback-connector-mysql HOT 10 CLOSED

How does your table/column definition look like? I suspect that fbId is a serial type.

from loopback-connector-mysql.

I am not sure what you mean by serial type...
Now it is:

fbId varchar(64) utf8mb4_unicode_ci

... before I used bigInt.

from loopback-connector-mysql.

Here are the mysql logs:

    26699 Query SELECT `fbId`, `firstName`, `lastName`, `gender`, `id` FROM `person` WHERE `fbId` = 10152350030328372 ORDER BY `id`
    26699 Query INSERT INTO `person` SET `fbId` = 10152350030328372,`firstName` = 'Ben',`lastName` = 'Marten',`gender` = 'male',`id` = NULL

but the request body is that:

request.body={"fbId":"10152350030328371","gender":"male","firstName":"Ben","id":null,"lastName":"Marten"}

from loopback-connector-mysql.

You can print out the SQL mapping using:

$ DEBUG=loopback:connector:mysql node .

from loopback-connector-mysql.

In your sql log, the fbId seems to be a number. Did you change your LoopBack model definition for the 'fbId' properties in addition to the DB column?

from loopback-connector-mysql.

See this:
$ node

Number('10152350030328371')
10152350030328372

Maybe the number is out of range of JS number.

from loopback-connector-mysql.

Raymond, that was it :) I forgot to change the loopback model definition to string... I only changed mysl... to varchar. THX

Querying for a string/varchar, I also had to add the single quotes ( ' -> %27 ):
/api/persons?filter[where][fbId][like]=%2710152350030328371%27

from loopback-connector-mysql.

Actually adding the single quotes does not work...

http://localhost:3000/api/persons?filter[where][fbId][like]=10152350030328371

{"error":{"name":"Error","status":400,"message":"The fbId property has invalid clause {"like":10152350030328372}","statusCode":400}}

Adding a literal in front of the number (so its recognized as string) works though...
http://localhost:3000/api/persons?filter[where][fbId][like]=a10152350030328371

loopback:connector:mysql SQL: SELECT fbId, firstName, lastName, gender, pictureExcluded, pictureExcludedDate, location, rating, id FROM person WHERE fbId LIKE 'a10152350030328371' ORDER BY id +166ms

How can I force it to be recognized as string? Adding ' or " works, but then the query will be build like this:

loopback:connector:mysql SQL: SELECT fbId, firstName, lastName, gender, pictureExcluded, pictureExcludedDate, location, rating, id FROM person WHERE fbId LIKE '"10152350030328371"' ORDER BY id +1m

from loopback-connector-mysql.

The query string value is coerced into a number.

I suggest that you use:

http://localhost:3000/api/persons?filter={"where":{"fbId": {"like": "10152350030328371"}}}

BTW, you don't have to use 'like'. It can be a simple equal, such as:

http://localhost:3000/api/persons?filter[where][fbId]=10152350030328371

from loopback-connector-mysql.

Works, thanks!

from loopback-connector-mysql.