Why do values in the row I insert not match the values in the insert query?

Posted by user202411 on Stack Overflow See other posts from Stack Overflow or by user202411
Published on 2010-04-17T05:06:39Z Indexed on 2010/04/17 5:23 UTC
Read the original article Hit count: 209

Filed under:
|

I just can't understand why is my database (mysql) behaving like this! My console shows that the record is created properly (please, notice the "remote_id" value):

Tweet Create (0.3ms)

INSERT INTO `tweets` (`remote_id`, `text`, `user_id`, `twitter_account_id`)
              VALUES (12325438258, 'jamaica', 1, 1)

But when I check the record, it shows that the remote_id is 2147483647 intead of the provided value (12325438258 in the example above)...

This table has many entries, but this field is always written with 2147483647... It was supposed to fill this space with an unique id (which I guarantee you is being generated properly).

© Stack Overflow or respective owner

Related posts about mysql

Related posts about rails