Skip to content

Incorrect result returned when using "RECORDSET OF" to retrieve columns #2070

@Ztengchao

Description

@Ztengchao

When adding other computer column after t.*, the columns in t.* cannot be obtained correctly
Example

var data = [{a:1,b:10}, {a:2,b:20}, {a:1,b:30}];
var res = alasql('RECORDSET OF SELECT t.*, 1 as rn FROM ? t',[data]);   

Result

{
  "columns": [
    {
      "columnid": "rn"
    }
  ],
  "data": [
    {
      "rn": 1,
      "a": 1,
      "b": 10
    },
    {
      "rn": 1,
      "a": 2,
      "b": 20
    },
    {
      "rn": 1,
      "a": 1,
      "b": 30
    }
  ]
}

columns only contains "rn" and "a, b" is missing

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions