Neil Tompkins MySQL UUID_SHORT() gives error Out of range value for column
Jun 20, 2014; 11:31
Neil Tompkins
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
Jun 21
Roberta Jaskolski Re: MySQL UUID_SHORT() gives error Out of range value for column
Jun 21, 2014; 01:29
Roberta Jaskolski
Re: MySQL UUID_SHORT() gives error Out of range value for column
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!