Comments (5)
kitaisreal
commented on June 26, 2024
It is expected, we derive types of columns for recursive CTE table from non-recursive term.
from clickhouse.
l1t1
commented on June 26, 2024
I see. but it is different from most of other DBMS
from clickhouse.
kitaisreal
commented on June 26, 2024
I see. but it is different from most of other DBMS
Could you please provide example ? As I understand for example in PostgreSQL logic is the same, but how types are derived is different.
from clickhouse.
l1t1
commented on June 26, 2024
yes, they treat 1 as int32 type number.
from clickhouse.
kitaisreal
commented on June 26, 2024
yes, they treat 1 as int32 type number.
Yes, but in our case we cannot change type deduction logic, so for recursive CTE it is possible to have issues with integer types overflow, and client need to manually add cast.
That problem can also appear in simple SQL queries when you translate them from other DBMS to ClickHouse.
from clickhouse.
Related Issues (20)
- Cache dictionary + short circuit evaluation: Expected the argument №3 ('' of type String) to have 256 rows, but it has 240
- Load job "system.part_log" failed JSON exception: error: 1 unexpected end of data HOT 3
- `02572_query_views_log_background_thread` is flaky
- Add ENUM support to WITH FILL
- 23.11 segfault HOT 1
- FINAL on table with is_deleted works 10-30 times slower than expected HOT 3
- 24.4+ SSL config disableProtocols is overridden by requireTLSv1_2
- The data retrieved with the same query conditions fluctuates up and down, sometimes more and sometimes less! HOT 8
- [RFC] Checking backups checksums during RESTORE
- ALTER TABLE xxx MATERIALIZE COLUMNS/INDEXES/PROJECTIONS
- Low uniqMerge performance issue in Materialized aggregatingMergetree HOT 3
- file table function: an option to rename failed processing files
- Temporary stopping automatic dictionary updates HOT 3
- Direct dictionary + short_circuit_function_evaluation: Logical error / stack-buffer-overflow
- Logical error: Queries with distributed_group_by_no_merge=1 should be processed to Complete stage
- MergeTree: more efficient read operations for small data volumes HOT 4
- isIPv4String Function validating strings that are not proper IPv4 strings HOT 3
- error install clickhouse-server deb repo HOT 6
- LOGICAL_ERROR: 'Unexpected node type for table expression. Expected table, table function, query, union, join or array join. Actual IDENTIFIER'
- Code: 47. DB::Exception: Unknown expression or function identifier in scope WITH
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from clickhouse.