Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Order by non-vector column returns error #55011

Open
ZiheLiu opened this issue Jan 13, 2025 · 0 comments · May be fixed by #55123
Open

Order by non-vector column returns error #55011

ZiheLiu opened this issue Jan 13, 2025 · 0 comments · May be fixed by #55123
Labels
type/bug Something isn't working

Comments

@ZiheLiu
Copy link
Contributor

ZiheLiu commented Jan 13, 2025

Steps to reproduce the behavior (Required)

Create table and prepare data.

ADMIN SET FRONTEND CONFIG ("enable_experimental_vector" = "true");

CREATE TABLE t6 (
    id bigint(20) NOT NULL COMMENT "",
    vector ARRAY<FLOAT> NOT NULL COMMENT "",
    INDEX index_vector (vector) USING VECTOR (
        "index_type" = "hnsw", 
        "dim"="5", 
        "metric_type" = "cosine_similarity", 
        "is_vector_normed" = "false", 
        "M" = "16", 
        "efconstruction" = "40"
    )
) ENGINE=OLAP
DUPLICATE KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 1
PROPERTIES (
    "replication_num" = "1"
);

insert into t6 values 
    (1, [10,12,13,14,15]),
    (2, [1,2,3,4,5]),
    (3, [0.1,0.2,0.3,0.4,0.5]);

Query

select * from t6 order by id

Real behavior (Required)

> select * from t6 order by id
(1064, 'Cannot invoke "com.starrocks.sql.optimizer.operator.Projection.getColumnRefMap()" because the return value of "com.starrocks.sql.optimizer.operator.logical.LogicalOlapScanOperator.getProjection()" is null')

StarRocks version (Required)

main ada1be1

@ZiheLiu ZiheLiu added the type/bug Something isn't working label Jan 13, 2025
@ZiheLiu ZiheLiu linked a pull request Jan 16, 2025 that will close this issue
24 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant