Panic when ordering by number that refers to rowid or a view

[LeMikaelF]

turso> create table t(a);
turso> select rowid from t order by 1;
turso> create view v as select * from t;
turso> select rowid from v order by 1;

thread 'main' panicked at core/vdbe/builder.rs:813:32:
Cursor not found: CursorKey { table_reference_id: TableInternalId(2), index: None }

[Pavan-Nambi]

Hmm so we should jsut throw a parse err?

[LeMikaelF]

@Pavan-Nambi I think that would be good, to match with SQLite behaviour.

[Pavan-Nambi]

Oh also i found this while looking at this

i got some work so just logging it here (didnt checked if theres an existing issue but well )

turso> CREATE TABLE a(x TEXT);
CREATE TABLE b(rowid TEXT);
INSERT INTO a VALUES('sku1');
INSERT INTO b VALUES('sku1');
SELECT rowid FROM a JOIN b ON a.x = b.rowid;

  x Parse error: ROWID is ambiguous

turso>