Re: MySQL UUID_SHORT() gives error Out of range value for column

2014-06-21 Thread Roberta Jaskolski
2014/06/20 11:31 +0100, Neil Tompkins I'm using MySQL 5.6.17 on Amazon Web Services RDS and when calling SELECT UUID_SHORT() I'm getting a number bigger than 9223372036854775807. For example the number I get is 12057145185130250250 help uuid_short Name: 'UUID_SHORT' Descriptio

MySQL UUID_SHORT() gives error Out of range value for column

2014-06-20 Thread Neil Tompkins
Hi, I'm using MySQL 5.6.17 on Amazon Web Services RDS and when calling SELECT UUID_SHORT() I'm getting a number bigger than 9223372036854775807. For example the number I get is 12057145185130250250 The problem is in my table I have a column as BIGINT(20) unsigned, but when storing a number 12057