Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.4.3
-
None
-
None
-
2021-1, 2021-2
Description
I run this script with intent to copy the datatype of the column t1.c1 to t2.c2, but without copying the data:
DROP TABLE IF EXISTS t1,t2; |
CREATE TABLE t1 (c1 INT) ENGINE=ColumnStore; |
INSERT INTO t1 VALUES (1),(2); |
CREATE TABLE t2 AS SELECT c1 FROM t1 LIMIT 0; |
SELECT * FROM t2; |
+------+
|
| c1 |
|
+------+
|
| 1 |
|
+------+
|
Notice, t2 erroneously has one record, while the statement asked to write 0 rows to the destination table t2.
Attachments
Issue Links
- relates to
-
MCOL-4455 "SELECT DISTINCT col FROM table LIMIT O,N" ignores offset
- Closed