oshliaer / alasqlgs Goto Github PK

The sample select:

SELECT \
data1.[0], data1.[1], data1.[2], data1.[3], data1.[4], data1.[5], data1.[6], data1.[7], data1.[8], data1.[9], data1.[10],\
data2.[0], data2.[1], data2.[2], data2.[3], data2.[4], data2.[5], data2.[6], data2.[7], data2.[8], data2.[9] \
FROM ? AS data1 JOIN ? AS data2 ON data1.[0] = data2.[0]", [data1, data2]);

This gives me the wrong results. Anonimous tables can't have the same alias. Here's another similar test in Sheets: select a.Col2, b.Col2 does not work.

I used this fix:

SELECT data1.[0] col000, data1.[1] col001, data1.[2] col002, data1.[3] col003, data1.[4] col004, data1.[5] col005, data1.[6] col006, data1.[7] col007, data1.[8] col008, data1.[9] col009, data1.[10] col010, data2.[0], data2.[1], data2.[2], data2.[3], data2.[4], data2.[5], data2.[6], data2.[7], data2.[8], data2.[9] FROM ? AS data1 JOIN ? AS data2 ON data1.[0] = data2.[0]
created artificial alias to the same column indexes from select.

It has to be an issue related to AlaSql, not this library, but since it has a simple fix, I thought it worth to post this issue here.

https://docs.google.com/spreadsheets/d/1DVviAUj5FbEEOMDgPg0GSY8FGdDeynF22rilsumRIHo/edit?usp=sharing

var alasql = AlaSQLGS.load();
alasql.options.modifier = 'MATRIX';
alasql.aggr.GROUP_CONCAT = function(v,s){
  if(typeof v == "undefined") return s;
  if(typeof s == "undefined") return v; else return [s,v].join(', ');
};

function ALASQL(query, data) {
  var res = alasql(query, [data]);
  return res;
}

When using debugger mode in the developer window, the debugger jumps into lines within the alasql.gs file. It seems like these functions are running on every function execution, regardless of whether the library is used at all.