List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:June 20 2014 10:31am
Subject:MySQL UUID_SHORT() gives error Out of range value for column
View as plain text  
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

Thread
MySQL UUID_SHORT() gives error Out of range value for columnNeil Tompkins20 Jun 2014
  • Re: MySQL UUID_SHORT() gives error Out of range value forcolumn(Roberta Jaskolski)21 Jun 2014