BugGood first issue
仓库指标
- 星标
- (13,403 个星标)
- PR 合并指标
- (平均合并 5天 13小时) (30 天内合并 108 个 PR)
描述
To reproduce
CREATE AS SELECT has a special syntax of casting. This is a valid syntax: create table t as (select * from long_sequence(5)), cast(x as long); (note the comma before cast)
However, it does not allow all supported casting. This works fine:
create table t as (select cast (x as varchar) as x from long_sequence(5));
but this does not:
create table t as (select x from long_sequence(5)), cast(x as varchar);
-> unsupported cast [column=x, from=LONG, to=VARCHAR]
As a user I would expect that the special casting syntax in CREATE AS SELECT would support all casting combinations allowed in regular casting expressions.
QuestDB version:
9.2.3
OS, in case of Docker specify Docker and the Host OS:
NA
File System, in case of Docker specify Host File System:
NA
Full Name:
Jaromir Hamala
Affiliation:
QuestDB
Have you followed Linux, MacOs kernel configuration steps to increase Maximum open files and Maximum virtual memory areas limit?
- Yes, I have
Additional context
No response