mysql max integer value

Databases
41

[quote=388541:@Dave S]Ok… you think it is a bug, despite having multiple people explain exactly what is happening, then there is nothing more to say.

But I do suggest you study Boolean Arithmetic…

I’m done here, and removing this topic…[/quote]

hummm…

so the for uint16=1 downto 0 on your concept, it’s ok to loop forever?…

and i need to study boolean arithmetic?…

hummm…

please, try this and tell me if this sounds “logic” for you…
uint8 and uint16 have bugs and uint32 and uint64 runs just fine…

[code]dim ui8 as UInt8
for ui8=1 DownTo 0
if ui8>1 then
MsgBox “uint8 bug”
exit for ui8
end if
next

dim ui16 as UInt16
for ui16=1 DownTo 0
if ui16>1 then
MsgBox “uint16 bug”
exit for ui16
end if
next

dim ui32 as UInt32
for ui32=1 DownTo 0
if ui32>1 then
MsgBox “uint32 bug”
exit for ui32
end if
next

dim ui64 as UInt64
for ui64=1 DownTo 0
if ui64>1 then
MsgBox “uint64 bug”
exit for ui64
end if
next[/code]

42

[quote=388439:@Jason Parsley]You might be able to use CAST to convert to a larger unsigned something like:

select cast(max(id) as unsigned) as id from zendesk [/quote]

ok. i’ll try this too.

thank you!

43

How do i CAST…

session.g_db.GetInsertID ?

44

Something like:

select cast(max(LAST_INSERT_ID()) as unsigned)

should work.

45

ohh… of course! tks