Skip to content

[VL][1.2][Result mismatch] Cast string to integral type does not ignore ISO control characters #7749

@wForget

Description

@wForget

Backend

VL (Velox)

Bug description

  1. create test dataset

    create table t1 as select url_decode('111111%00') as c1;
    
  2. cast to integral type
    check sqls:

    select cast(c1 as int) from t1;
    select cast(c1 as bigint) from t1;
    

    gluten 1.2 + spark 3.5:

    NULL
    NULL
    

    vanilla spark:

    111111
    111111
    
  3. cast to fractional type
    check sqls:

    select cast(c1 as float) from t1;
    select cast(c1 as double) from t1;
    

    gluten 1.2 + spark 3.5:

    111111.0
    111111.0
    

    vanilla spark:

    111111.0
    111111.0
    

Related PRs: apache/spark#41535

Spark version

None

Spark configurations

No response

System information

No response

Relevant logs

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingtriage

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions