Re: MySQL UUID_SHORT() gives error Out of range value for column
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' Description: Syntax: UUID_SHORT() Returns a "short" universal identifier as a 64-bit unsigned integer (rather than a string-form 128-bit identifier as returned by the UUID() function). That is one bit longer than you are aiming for. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
MySQL UUID_SHORT() gives error Out of range value for column
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 12057145185130250250 I get the error MySQL 22003 'MySQL 22003 Out of range value for column '' at row 1' If I run SELECT UUID_SHORT() on our test server which is MySQL 5.6.11 (running on Windows 2008 64x) the result is as follows; 23526798209843216 I changed the column I'm trying to save my number to, as BIGINT(20) unsigned, but still get this error. Any ideas why ? Cheers Neil