You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE TABLE array_field (
id BIGINT NOT NULL AUTO_INCREMENT,
a ARRAY<VARCHAR(10)> COMMENT 'An array field of VARCHAR(10) elements'
);
INSERT INTO array_field (a) VALUES (["1234567890"]);
-- Query OK, as expected
INSERT INTO array_field (a) VALUES (["12345678901234"]);
-- Query OK, not expected because the string length is 14
INSERT INTO array_field (a) VALUES (["123456789012345"]);
-- ERROR 1064 (HY000): starrocks.svc.cluster.local: string length(15) > limit(14), string: 123456789012345
Expected behavior (Required)
I expect the elements of the array to be of type VARCHAR(10). An error is expected when elements of length >10 are attempted to be inserted.
Real behavior (Required)
Elements with lengths up to 14 can be inserted. The error message where strings of length >14 also seem to imply that the element limit is 14.
StarRocks version (Required)
3.2.3-a40e2f8
The text was updated successfully, but these errors were encountered:
Steps to reproduce the behavior (Required)
Expected behavior (Required)
I expect the elements of the array to be of type VARCHAR(10). An error is expected when elements of length >10 are attempted to be inserted.
Real behavior (Required)
Elements with lengths up to 14 can be inserted. The error message where strings of length >14 also seem to imply that the element limit is 14.
StarRocks version (Required)
3.2.3-a40e2f8
The text was updated successfully, but these errors were encountered: