1、my table is:
CREATE TABLE marshal (marshalKey TEXT PRIMARY KEY,dataSize INTEGER,marshalData BLOB);
2、 /etc/actordb/app.conf is default.
3、now , i test in mysql profile and i can't get data correctly when the data is bigger than 8M bytes.
1)、the below is the error of my progam.the query is correctly,but when i uesd "mysql_real_query" to get result,it incorrectly.
[ptswitch@localhost linux]$ ./actordb-0.0.0
conn is ok!
excute ok
Error: Malformed packet
[ptswitch@localhost linux]$
4、i used the "Navicat Premium" to query ,when the data is bigger ,it can't get result also.
1)、first，get all marshalKey and dataSize column.
sql: actor scd(54379f348dc39d6897dd9fbf6b3414d1) create;select marshalKey,dataSize FROM marshal;
result:
marshalKey dataSize
IED_TABLE 50507
LD_TABLE 199719
GSE_TABLE 4763188
SMV_TABLE 746309
RPT_TABLE 23165572
EXT_TABLE 1912700
GSE_LIST 4641664
SMV_LIST 727174
RPT_LIST 22633420
EXT_LIST 2610017
2)、query marshalData column.when marshalKey is GSE_TABLE,the result is correct.
sql: actor scd(54379f348dc39d6897dd9fbf6b3414d1) create;select marshalKey,dataSize,marshalData FROM marshal where marshalKey='GSE_TABLE';
result:
marshalKey dataSize marshalData
GSE_TABLE 4763188
3)、query marshalData column.when marshalKey is RPT_TABLE,the result is error.
sql: actor scd(54379f348dc39d6897dd9fbf6b3414d1) create;select marshalKey,dataSize,marshalData FROM marshal where marshalKey='RPT_TABLE';
result:
[SQL]actor scd(54379f348dc39d6897dd9fbf6b3414d1) create;
受影响的行: 0
时间: 0.001s
[SQL]select marshalKey,dataSize,marshalData FROM marshal where marshalKey='RPT_TABLE';
[Err] 2000 - Unknown MySQL error
56
1、my table is: CREATE TABLE marshal (marshalKey TEXT PRIMARY KEY,dataSize INTEGER,marshalData BLOB); 2、 /etc/actordb/app.conf is default.
3、now , i test in mysql profile and i can't get data correctly when the data is bigger than 8M bytes. 1)、the below is the error of my progam.the query is correctly,but when i uesd "mysql_real_query" to get result,it incorrectly. [ptswitch@localhost linux]$ ./actordb-0.0.0 conn is ok! excute ok Error: Malformed packet [ptswitch@localhost linux]$
4、i used the "Navicat Premium" to query ,when the data is bigger ,it can't get result also. 1)、first，get all marshalKey and dataSize column. sql: actor scd(54379f348dc39d6897dd9fbf6b3414d1) create;select marshalKey,dataSize FROM marshal; result: marshalKey dataSize IED_TABLE 50507 LD_TABLE 199719 GSE_TABLE 4763188 SMV_TABLE 746309 RPT_TABLE 23165572 EXT_TABLE 1912700 GSE_LIST 4641664 SMV_LIST 727174 RPT_LIST 22633420 EXT_LIST 2610017 2)、query marshalData column.when marshalKey is GSE_TABLE,the result is correct. sql: actor scd(54379f348dc39d6897dd9fbf6b3414d1) create;select marshalKey,dataSize,marshalData FROM marshal where marshalKey='GSE_TABLE'; result: marshalKey dataSize marshalData GSE_TABLE 4763188 3)、query marshalData column.when marshalKey is RPT_TABLE,the result is error. sql: actor scd(54379f348dc39d6897dd9fbf6b3414d1) create;select marshalKey,dataSize,marshalData FROM marshal where marshalKey='RPT_TABLE'; result: [SQL]actor scd(54379f348dc39d6897dd9fbf6b3414d1) create; 受影响的行: 0 时间: 0.001s
[SQL]select marshalKey,dataSize,marshalData FROM marshal where marshalKey='RPT_TABLE'; [Err] 2000 - Unknown MySQL error