Dec 15, 2025 · Dec 15, 2025 · Dec 15, 2025 · Dec 17, 2025 · Dec 17, 2025 · Dec 17, 2025
diff --git a/src/424select.js b/src/424select.js
 var tbid = col.tableid;
 //console.log(query.sources);
 var dbid = col.databaseid || query.sources[0].databaseid || query.database.databaseid;

 // Check if tableid is actually a column name (property access pattern like name.length)
 // This handles cases where the parser sees "columnname.property" and interprets it as "table.column"
 var isPropertyAccess = false;
 if (tbid && query.defcols && query.defcols[tbid] && query.defcols[tbid] !== '-') {
 // tbid is actually a column name, so this is property access
 isPropertyAccess = true;
 var actualTableid = query.defcols[tbid];
 }

 if (!tbid) tbid = query.defcols[col.columnid];
 if (!tbid) tbid = query.defaultTableid;
 if (col.columnid !== '_') {
 .join(' ?? ');

 ss.push("'" + escapeq(col.as || col.columnid) + "':(" + searchExpr + ')');
 } else if (isPropertyAccess) {
 // Property access pattern: columnname.property (e.g., name.length)
 // Generate code to access the property on the column value
 ss.push(
 "'" +
 escapeq(col.as || col.columnid) +
 "':((p['" +
 actualTableid +
 "']['" +
 col.tableid +
 "'] || {})['" +
 col.columnid +
 "'])"
 );
 } else {
 ss.push(
 "'" +
diff --git a/src/50expression.js b/src/50expression.js
 }

 if (this.tableid) {
 // Check if tableid is actually a column name (property access pattern like name.length)
 // This handles cases where the parser sees "columnname.property" and interprets it as "table.column"
 if (defcols && defcols[this.tableid] && defcols[this.tableid] !== '-') {
 // tableid is actually a column name, so this is property access
 // Generate code to access the property on the column value
 const actualTable = defcols[this.tableid];
 if (this.columnid !== '_') {
 return `((${context}['${actualTable}']['${this.tableid}'] || {})['${this.columnid}'])`;
 }
 }
 // Otherwise, tableid is a table name (normal table.column access)
 return this.columnid !== '_'
 ? `${context}['${this.tableid}']['${this.columnid}']`
 : context === 'g'
diff --git a/test/test341.js b/test/test341.js
 done();
 });

 it.skip('4. JavaScript way', function (done) {
 it('4. JavaScript way', function (done) {
 var res = alasql('SET @a = "who".length');
 assert.deepEqual(res, [6, 6, 7]);
 assert.deepEqual(res, 1);
 assert.deepEqual(alasql.vars.a, 3);
 done();
 });

 it.skip('5. JavaScript way', function (done) {
 it('5. JavaScript way', function (done) {
 var res = alasql('SELECT COLUMN name.length FROM persons');
 assert.deepEqual(res, [6, 6, 7]);
 done();
Original file line number	Diff line number	Diff line change
Expand Up		@@ -198,6 +198,16 @@ yy.Select.prototype.compileSelect1 = function (query, params) {
		var tbid = col.tableid;
		//console.log(query.sources);
		var dbid = col.databaseid \|\| query.sources[0].databaseid \|\| query.database.databaseid;

		// Check if tableid is actually a column name (property access pattern like name.length)
		// This handles cases where the parser sees "columnname.property" and interprets it as "table.column"
		var isPropertyAccess = false;
		if (tbid && query.defcols && query.defcols[tbid] && query.defcols[tbid] !== '-') {
		// tbid is actually a column name, so this is property access
		isPropertyAccess = true;
		var actualTableid = query.defcols[tbid];
		}

		if (!tbid) tbid = query.defcols[col.columnid];
		if (!tbid) tbid = query.defaultTableid;
		if (col.columnid !== '_') {
Expand DownExpand Up		@@ -260,6 +270,20 @@ yy.Select.prototype.compileSelect1 = function (query, params) {
		.join(' ?? ');

		ss.push("'" + escapeq(col.as \|\| col.columnid) + "':(" + searchExpr + ')');
		} else if (isPropertyAccess) {
		// Property access pattern: columnname.property (e.g., name.length)
		// Generate code to access the property on the column value
		ss.push(
		"'" +
		escapeq(col.as \|\| col.columnid) +
		"':((p['" +
		actualTableid +
		"']['" +
		col.tableid +
		"'] \|\| {})['" +
		col.columnid +
		"'])"
		);
		} else {
		ss.push(
		"'" +
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -782,6 +782,17 @@
		}

		if (this.tableid) {
		// Check if tableid is actually a column name (property access pattern like name.length)
		// This handles cases where the parser sees "columnname.property" and interprets it as "table.column"
		if (defcols && defcols[this.tableid] && defcols[this.tableid] !== '-') {
		// tableid is actually a column name, so this is property access
		// Generate code to access the property on the column value
		const actualTable = defcols[this.tableid];
		if (this.columnid !== '_') {
		return `((${context}['${actualTable}']['${this.tableid}'] \|\| {})['${this.columnid}'])`;
		}
		}
		// Otherwise, tableid is a table name (normal table.column access)
		return this.columnid !== '_'
		? `${context}['${this.tableid}']['${this.columnid}']`
		: context === 'g'
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -35,13 +35,14 @@ describe('Test 341 Intellectual DOT operator', function () {
		done();
		});

		it.skip('4. JavaScript way', function (done) {
		it('4. JavaScript way', function (done) {
		var res = alasql('SET @a = "who".length');
		assert.deepEqual(res, [6, 6, 7]);
		assert.deepEqual(res, 1);
		assert.deepEqual(alasql.vars.a, 3);
		done();
		});

		it.skip('5. JavaScript way', function (done) {
		it('5. JavaScript way', function (done) {
		var res = alasql('SELECT COLUMN name.length FROM persons');
		assert.deepEqual(res, [6, 6, 7]);
		done();
Comment on lines -44 to 47 Copy link Member mathiasrwDec 17, 2025 Choose a reason for hiding this comment The reason will be displayed to describe this comment to others.Learn more. Can we adda a test if I can name a table.col.length ? Copy link ContributorAuthor CopilotAIDec 17, 2025 Choose a reason for hiding this comment The reason will be displayed to describe this comment to others.Learn more. Added test for`table.column.length` syntax! ✅ The three-level dot notation already works correctly with the current implementation. Added test "6. JavaScript way with table.column.length" that verifies: `SELECT COLUMN persons.name.length FROM persons` → [6, 6, 7] Also works with aliases:`SELECT COLUMN p.name.length FROM persons AS p` All 2086 tests passing. Commit:`ddb0088` Copy link Member mathiasrwDec 17, 2025 Choose a reason for hiding this comment The reason will be displayed to describe this comment to others.Learn more. @copilot
Expand Down