matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard

[Bug]: create table ERROR when use primary key, column not exists in table

Open goodMan-code opened this issue 3 years ago • 0 comments

Is there an existing issue for the same bug?

  • [X] I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

The problematic SQL stmt is : CREATE TABLE t( d INT, d1 BIGINT, d2 FLOAT, d3 DOUBLE, PRIMARY KEY (id) );

It's result : Query OK, 0 rows affected (0.01 sec)

But it should be ERROR : Key column 'id' doesn't exist in table.

Expected Behavior

No response

Steps to Reproduce

No response

Additional information

No response

goodMan-code avatar Oct 10 '22 09:10 goodMan-code