Skip to content

LOAD DATA INFILE fails with error 1227 due to secure_file_priv restriction on Windows #663

@chyujing

Description

@chyujing

Description

Test case string_type.string_type_direct_load_inc fails when executing LOAD DATA INFILE. The operation returns error 1227 because the directory specified in the INFILE clause is not permitted by the secure_file_priv system variable.

Steps to Reproduce

  1. Execute the test case string_type.string_type_direct_load_inc.
  2. The test attempts to run a LOAD DATA INFILE command.
  3. The command fails with error 1227.

Environment

  • Operating System: Windows
  • Test Framework: mysqltest
  • Affected Test: string_type.string_type_direct_load_inc
  • Relevant Directory: /obdata/data/AndroidTest/ob_opensource_test/tools/deploy

Impact

The test case fails, indicating a potential issue with file path permissions or secure_file_priv configuration on Windows systems during data loading operations.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions