List:General Discussion« Previous MessageNext Message »
From:(Roberta Jaskolski) hsv Date:June 21 2014 5:29am
Subject:Re: MySQL UUID_SHORT() gives error Out of range value for
column
View as plain text  
>>>> 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.

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