Feature request 20230322

[writinwaters]

CREATE TABLE mytable (
   id INTEGER PRIMARY KEY,
   name VARCHAR(50),
   age INTEGER
 );
 INSERT INTO mytable (id, name, age) VALUES (1, 'John', 30);
 INSERT INTO mytable (id, name, age) VALUES (2, 'Jane', 25);

[writinwaters]

DELETE is not supported

DELETE FROM mytable WHERE age<26

Inserting select isn't supported @src/planner/logical_planner.cpp:218

CREATE TABLE a (
       id INTEGER PRIMARY KEY
      name VARCHAR(50),
      age INTEGER
);
INSERT INTO a (id, name, age) VALUES (1, 'tom', 32);
 INSERT INTO mytable SELECT * FROM a;

[writinwaters]

Sorting command creates unnecessary project name

SELECT * FROM mytable ORDER by age ASC;

 project4.mytable.id | project4.mytable.name | project4.mytable.age
---------------------+-----------------------+----------------------
                   2 | Jane                  |                   25
                   1 | John                  |                   30
(2 rows)

[writinwaters]

Inserting into a specific column is not supported

INSERT INTO mytable(name) VALUES ('Johnson'), ('Johnston');

Error message
Parser Error: syntax error, unexpected ',', expecting end of file, 44 @src/main/query_context.cpp:79

[JinHai-CN]

Sorting command creates unnecessary project name

SELECT * FROM mytable ORDER by age ASC;

 project4.mytable.id | project4.mytable.name | project4.mytable.age
---------------------+-----------------------+----------------------
                   2 | Jane                  |                   25
                   1 | John                  |                   30
(2 rows)

Fixed in https://github.com/infiniflow/infinity/commit/4631dd329ae52f11a6b55604cb119de6f9177bb5

[JinHai-CN]

Inserting into a specific column is not supported

INSERT INTO mytable(name) VALUES ('Johnson'), ('Johnston');

Error message Parser Error: syntax error, unexpected ',', expecting end of file, 44 @src/main/query_context.cpp:79

Multiple values in value list isn't supported.