2010YOUY01 opened a new issue, #12149:
URL: https://github.com/apache/datafusion/issues/12149

   ### Describe the bug
   
   Native StringView support for `octet_length()` has been added 
https://github.com/apache/datafusion/issues/11858
   However it's not working for StringView column inside table
   
   See reproducer in datafusion-cli
   (Compiled from latest main using `cargo run`, commit a58416c2e)
   The last query should work since this function should already have 
StringView support
   ```
   DataFusion CLI v41.0.0
   > create table t1(v1 text);
   0 row(s) fetched.
   Elapsed 0.058 seconds.
   
   > insert into t1 values ('DataFusion'), ('datafusion');
   +-------+
   | count |
   +-------+
   | 2     |
   +-------+
   1 row(s) fetched.
   Elapsed 0.047 seconds.
   
   > create table t1_stringview as
   select arrow_cast(v1, 'Utf8View') as v1
   from t1;
   0 row(s) fetched.
   Elapsed 0.011 seconds.
   
   # Now we have two equivalent tables `t1` and `t1_stringview`
   # The difference is physical representation for string column (StringArray 
and StringViewArray)
   
   > select octet_length(v1) from t1;
   +---------------------+
   | octet_length(t1.v1) |
   +---------------------+
   | 10                  |
   | 10                  |
   +---------------------+
   2 row(s) fetched.
   Elapsed 0.006 seconds.
   
   > select octet_length(v1) from t1_stringview;
   Arrow error: Compute error: length not supported for Utf8View
   
   ```
   
   ### To Reproduce
   
   _No response_
   
   ### Expected behavior
   
   _No response_
   
   ### Additional context
   
   Found by SQLancer https://github.com/apache/datafusion/issues/11030


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to