DB Query

[Rochet2]

Possible bug comparing 2 bigint columns in DB and then trying to compare them and fetch the result to lua.

Prints 1 for all on my machine and 0 for all on someone else's computer.
In both cases / any case getting a string, int64 or uint64 will be correct.
I may have bad MySQL version distorting the result. (Higher than TC supported)

local Q = CharDBQuery("select (a >= b) from table;")
if (Q) then
    print(Q:GetColumnCount())
    print(Q:GetRowCount())
    print()
    print(Q:GetBool(0))
    print(Q:GetUInt8(0))
    print(Q:GetUInt16(0))
    print(Q:GetUInt32(0))
    print(Q:GetUInt64(0))
    print(Q:GetInt8(0))
    print(Q:GetInt16(0))
    print(Q:GetInt32(0))
    print(Q:GetInt64(0))
    print(Q:GetFloat(0))
    print(Q:GetDouble(0))
    print(Q:GetString(0))
    print(Q:GetCString(0))
    print(Q:IsNull(0))
else
    print("Q_Q")
end

[Rochet2]

This is not Eluna related.

[Rochet2]

It seems that all non defined types like COUNT(*) SELECT 1; and boolean return values like in example above and are BIGINT.
What this means that any non column or set type is a BIGINT or DECIMAL

For proper return value type refer to mysql documentation of function return value and use appropriate data type in lua.
http://dev.mysql.com/doc/refman/5.5/en/arithmetic-functions.html
http://dev.mysql.com/doc/refman/5.5/en/mathematical-functions.html
.. and similar docs

This is an important notice when coding and ignoring data types of DB. One should not as it can distort the results completely, even if the value you fetch is within given range.
We should possibly implement uint64 as a proper object instead of string to be able to do math with it.