SELECT field on joined tables gives unexpected undefined

[radegran]

Repro steps

const users =  [{UserId: '1', UserName: 'User'}]
const orders = [{UserId: '1', Text: 'Order text'}]

const expected = alasql(`
  SELECT *
  FROM ? u 
  JOIN ? o 
  ON u.UserId = o.UserId`, 
  [users, orders])

const unexpected = alasql(`
  SELECT UserName,Text 
  FROM ? u 
  JOIN ? o 
  ON u.UserId = o.UserId`, 
  [users, orders])
  
console.log({expected, unexpected}); 
// {
//   expected: [{
//     Text: "Order text",                       <- "Text" field is there ...
//     UserId: "1",
//     UserName: "User"
// }],
//   unexpected: [{
//     Text: undefined,                          <- ... but it is undefined when selected
//     UserName: "User"
//   }]
// }

JSFiddle

https://jsfiddle.net/0nhuqp9f/

[mathiasrw]

Great bug. nice find.

[psy-duck1]

Hey there, i'm interested in this issue will you please assign this to me.

[psy-duck1]

const users =  [{UserId: '1', UserName: 'User'}]
const orders = [{UserId: '1', Text: 'Order text'}]

const expected = alasql(`
	SELECT *
  FROM ? u 
  JOIN ? o 
  ON u.UserId = o.UserId`, 
  [users, orders])

const unexpected = alasql(`
	SELECT u.UserName, o.Text 
  FROM ? u 
  JOIN ? o 
  ON u.UserId = o.UserId`, 
  [users, orders])
  
console.log({expected, unexpected}); 
// {
//  expected: [{
//  Text: "Order text",
//  UserId: "1",
//  UserName: "User"
// }],
// unexpected: [{
//  Text: "Order text",
//  UserName: "User"
// }]
// }

this will resolve the issue as AlasQL doesn't automatically include other columns from the joined tables. Only the explicitly selected columns are returned so if we specify the table it will not give error