Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Load data set expression not supported #2352

Open
@CodingDooog

Description

@CodingDooog

Self Checks

  • I have read theContributing Guide.
  • This is only for bug report, if you would like to ask a question, please head toDiscussions.
  • I have searched for existing issuessearch for existing issues, including closed ones.
  • I confirm that I am using English to submit this report, otherwise it will be closed.
  • 【中文用户 & Non English User】请使用英语提交,否则会被关闭 :)
  • Please do not modify this template :) and fill in all the required fields.

OceanBase version

5.7.25-OceanBase_CE-v4.3.5.2

Self Hosted

Self Hosted (Source)

Environment

Version: 5.7.25-OceanBase_CE-v4.3.5.2

Steps to reproduce

load data local infile'/Users/zhangsan/Desktop/tb_version_data_info_202512161841.csv'into tablesys.tb_version_data_info fields terminated by ',' ENCLOSED BY '''' ESCAPED BY '' lines terminated by '
' IGNORE 0 LINES (type,version,update_time,des,must_update,size) settype=if(type='',NULL,type),version=if(version='',NULL,version),update_time=if(update_time='',NULL,update_time),
des=if(des='',NULL,des),must_update=if(must_update='',NULL,must_update),size=if(size='',NULL,size);

SQL 错误 [1235] [0A000]: set expression not supported

✔️ Expected Behavior

load data success.

❌ Actual Behavior

load data failed.

SQL 错误 [1235] [0A000]: set expression not supported

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions


      [8]ページ先頭

      ©2009-2026 Movatter.jp