appletreeisyellow commented on issue #5471:
URL:
https://github.com/apache/arrow-datafusion/issues/5471#issuecomment-1680873644
Ah! I just ran `datafusion-cli` directly without cd into the
`datafusion-cli` dir and I didn't use `./target/debug/datafusion-cli`, so I was
using the old version of datafusion cli 🤦♀️
This is what I tired:
1. Pull the latest `arrow-datafusion` repo
2. Ran the following:
```shell
$ cd datafusion-cli
$ cargo build
$ ./target/debug/datafusion-cli
DataFusion CLI v29.0.0
❯ SELECT upper('foo');
+--------------------+
| upper(Utf8("foo")) |
+--------------------+
| FOO |
+--------------------+
1 row in set. Query took 0.035 seconds.
❯ select upper(arrow_cast('foo', 'Dictionary(Int32, Utf8)'));
+--------------------+
| upper(Utf8("foo")) |
+--------------------+
| FOO |
+--------------------+
1 row in set. Query took 0.002 seconds.
❯ create table foo(x varchar) as values ('foo'), ('bar');
0 rows in set. Query took 0.016 seconds.
❯ create table foo_dict as select arrow_cast(x, 'Dictionary(Int32, Utf8)')
as x from foo;
0 rows in set. Query took 0.017 seconds.
❯ select upper(x) from foo_dict;
+-------------------+
| upper(foo_dict.x) |
+-------------------+
| FOO |
| BAR |
+-------------------+
2 rows in set. Query took 0.004 seconds.
```
I cannot re-produce the error 🤔 Definitely `DataFusion CLI v29.0.0` doesn't
have the error, but some point in `v28.0.0` the error still exist. I tested
that the error exists in `v28.0.0` before [this
PR](https://github.com/apache/arrow-datafusion/commit/7a5354fe5908b8ac7db163d6c484dbf1d85a142e).
@alamb Can you verify for me?
--
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]
