CommandHelper

CommandHelper

46.5k Downloads

After first row MYSQL values are returned incorrectly as null

LadyCailinBot opened this issue ยท 1 comments

commented

CMDHELPER-2946 - Reported by opoq

SELECT * FROM user;

MySQL returns:
||iduser||name||uuid||firstTime||lastTime||
|3|opoq|(NULL)|0|0|
|5|jimbo|(NULL)|0|0|

Meanwhile CH returns:

{{firstTime: null, iduser: 3, lastTime: null, name: opoq, uuid: }, {firstTime: null, iduser: null, lastTime: null, name: null, uuid: null}}

mscript:  msg(query(mysql, 'SELECT * FROM `user`;'))
commented

Comment by opoq

Appears to be related to uuid having a default value of null.