[Bug]: ERROR 20101 (HY000): internal error: Data too long for blob

[yangj1211]

Is there an existing issue for the same bug?

• I have checked the existing issues.

Branch Name

main

Commit ID

newest

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

使用load_file()查看496k的二进制文件报错"data too long for blob"

Expected Behavior

No response

Steps to Reproduce

1、下载二进制文件：https://github.com/matrixorigin/matrixone/blob/main/test/distributed/resources/blob_file/blob2.mp3

2、执行查询语句：
 SELECT LOAD_FILE('/Users/admin/Downloads/fruit01/blob2.mp3');

Additional information

No response

[ouyuanning]

目前配置上支持的大小是 65536 。目前的返回看来是预期行为。

估计要跟产品一起对一下处理方式

[yangj1211]

mysql中 BLOB 类型有四种，根据存储数据的最大大小不同：
https://dev.mysql.com/doc/refman/8.0/en/storage-requirements.html

根据mo官网文档，mo只有blob一种类型，大小为1gb：

@allengaoo ,需要明确产品行为：
1、和mysql对齐，支持四种类型的blob
2、保持之前设计，支持blob一种类型，最大支持1gb
3、其他

[fengttt]

I think we should make text and blob back to some bigger value. 64KB is probably too small. On the other hand, 1GB is stretching our limit -- we will not be able to allocate and will not be able to do any useful things.

A more reasonable number is something like 8 - 64MB. I don't think we should go for 1GB -- user should use S3 object and datalink for that kind of stuff.

[yangj1211]

bug 转 feature: #20677

[qingxinhome]

This issue has been fixed, please verify and test it @yangj1211 @aressu1985

[heni02]

#20677 测试后没有这个问题，closed