Skip to content

No duplicate column error for a view #4545

@pgulutzan

Description

@pgulutzan

I have Ubuntu 18.04. I have Tarantool 2.3, pulled from source today.

I execute these requests:

tarantool> box.execute([[CREATE TABLE t (a INTEGER PRIMARY KEY, a INTEGER);]])

  • null
  • Space field 'A' is duplicate
    ...

tarantool> box.execute([[CREATE VIEW v AS SELECT 1 AS a, 1 AS a;]])

  • row_count: 1
    ...

This is not consistent. In the first case, the duplicate column
name causes an error. In the second case, the duplicate column
name does not cause an error. Instead, Tarantool "fixes"
the problem and creates a column named A_1.

Metadata

Metadata

Assignees

Labels

3.2Target is 3.2 and all newer release/master branchesbugSomething isn't workingsql

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions