Dec 15, 2025 · Dec 15, 2025 · Dec 15, 2025 · Dec 17, 2025 · Dec 17, 2025 · Dec 17, 2025
diff --git a/src/50expression.js b/src/50expression.js
 return '(' + declareRefs + ', ' + expr + ')';
 }

 return `(${declareRefs}, y.some(e => e == null) ? void 0 : ${expr})`;
 return `(${declareRefs}, y.some(e => e == null || (typeof e === 'number' && isNaN(e))) ? void 0 : ${expr})`;
 }
 }

diff --git a/src/60createtable.js b/src/60createtable.js
 if (col.check) {
 table.checks.push({
 id: col.check.constrantid,
 fn: new Function('r', 'var y;return ' + col.check.expression.toJS('r', '')),
 fn: new Function('r,params,alasql', 'var y;return ' + col.check.expression.toJS('r', '')),
 });
 }

 }
 var fkfn = function (r) {
 var rr = {};
 if (typeof r[col.columnid] === 'undefined') {
 // Allow NULL values in foreign keys (check for undefined, null, and NaN)
 var val = r[col.columnid];
 if (
 typeof val === 'undefined' ||
 val === null ||
 (typeof val === 'number' && isNaN(val))
 ) {
 return true;
 }
 rr[fk.columnid] =r[col.columnid];
 rr[fk.columnid] =val;
 var addr = fktable.pk.onrightfn(rr);
 if (!fktable.uniqs[fktable.pk.hh][addr]) {
 throw new Error(
 'Foreign key "' + r[col.columnid] + '" not found in table "' + fk.tableid + '"'
 );
 throw new Error('Foreign key "' + val + '" not found in table "' + fk.tableid + '"');
 }
 return true;
 };
 table.checks.push({fn: fkfn});
 table.checks.push({fn: fkfn, fk: true});
 }

 if (col.onupdate) {
 pk.hh = hash(pk.onrightfns);
 table.uniqs[pk.hh] = {};
 } else if (con.type === 'CHECK') {
 checkfn = new Function('r', 'var y;return ' + con.expression.toJS('r', ''));
 checkfn = new Function('r,params,alasql', 'var y;return ' + con.expression.toJS('r', ''));
 } else if (con.type === 'UNIQUE') {
 var uk = {};
 table.uk = table.uk || [];

 if (table.checks && table.checks.length > 0) {
 table.checks.forEach(function (check) {
 if (!check.fn(r)) {
 // In SQL, CHECK constraints treat NULL (undefined) as passing
 // Only fail if the check explicitly returns false
 if (check.fn(r, {}, alasql) === false) {
 //if(orreplace) toreplace=true; else
 throw new Error('Violation of CHECK constraint ' + (check.id || ''));
 }
 // PART 2 - POST CHECK
 if (table.checks && table.checks.length > 0) {
 table.checks.forEach(function (check) {
 if (!check.fn(r)) {
 // In SQL, CHECK constraints treat NULL (undefined) as passing
 // Only fail if the check explicitly returns false
 if (check.fn(r, params, alasql) === false) {
 throw new Error('Violation of CHECK constraint ' + (check.id || ''));
 }
 });
diff --git a/test/test324.js b/test/test324.js
 }

 describe('Test 324 Roads samples', function () {
 it.skip('1. CREATE DATABASE', function (done) {
 it('1. CREATE DATABASE', function (done) {
 alasql('CREATE DATABASE test324a; USE test324a');
 done();
 });

 it.skip('2. OBJECT_ID()', function (done) {
 it('2. OBJECT_ID()', function (done) {
 alasql('CREATE TABLE dbo.Employees(id INT, name STRING)');
 alasql('INSERT INTO dbo.Employees VALUES (1,"Tomas"),(2,"Lisa")');
 assert.deepEqual(alasql('SELECT * FROM dbo.Employees'), [
 done();
 });

 it.skip('3. DROP DATABASE', function (done) {
 it('3. DROP DATABASE', function (done) {
 alasql('DROP DATABASE test324a');
 done();
 });

 it.skip('2. CREATE DATABASE', function (done) {
 it('2. CREATE DATABASE', function (done) {
 alasql('CREATE DATABASE test324b; USE test324b');
 done();
 });

 it.skip('3. CREATE TABLE with constraints', function (done) {
 it('3. CREATE TABLE with constraints', function (done) {
 var res = alasql(function () {
 /*
      CREATE TABLE dbo.Employees
 done();
 });

 it.skip('4. INSERT INTO table with constraints', function (done) {
 it('4. INSERT INTO table with constraints', function (done) {
 var res = alasql(function () {
 /*
  INSERT INTO dbo.Employees(empid, mgrid, empname, salary) VALUES
 done();
 });

 it.skip('5. INSERT INTO table with same primary key', function (done) {
 it('5. INSERT INTO table with same primary key', function (done) {
 assert.throws(function () {
 var res = alasql(function () {
 /*
 done();
 });

 it.skip('6. INSERT INTO wrong NULL in NOT NULL column', function (done) {
 it('6. INSERT INTO wrong NULL in NOT NULL column', function (done) {
 assert.throws(function () {
 var res = alasql(function () {
 /*
 done();
 });

 it.skip('7. UPDATE wrong NULL in NOT NULL column', function (done) {
 it('7. UPDATE wrong NULL in NOT NULL column', function (done) {
 assert.throws(function () {
 var res = alasql('UPDATE dbo.Employees SET empid = NULL WHERE empid = 1');
 }, Error);
 done();
 });

 it.skip('8. UPDATE wrong NULL in NOT NULL column', function (done) {
 it('8. UPDATE wrong NULL in NOT NULL column', function (done) {
 var res = alasql('UPDATE dbo.Employees SET mgrid = NULL WHERE empid = 2');
 assert(res == 1);
 done();
 });

 it.skip('9. UPDATE wrong NULL in NOT NULL column', function (done) {
 it('9. UPDATE wrong NULL in NOT NULL column', function (done) {
 assert.throws(function () {
 var res = alasql('UPDATE dbo.Employees SET mgrid = 3 WHERE empid = 2');
 }, Error);
 done();
 });

 it.skip('10. INSERT INTO table with constraints violation', function (done) {
 it('10. INSERT INTO table with constraints violation', function (done) {
 //    console.log(alasql.databases.dbo.tables.Employees);
 assert.throws(function () {
 var res = alasql(
 done();
 });

 it.skip('11. INSERT INTO table with constraints violation', function (done) {
 it('11. INSERT INTO table with constraints violation', function (done) {
 //    console.log(alasql.databases.dbo.tables.Employees);
 var res = alasql(
 "INSERT INTO dbo.Employees(empid, mgrid, empname, salary) \
 done();
 });

 it.skip('12. UPDATE wrong NULL in NOT NULL column', function (done) {
 it('12. UPDATE wrong NULL in NOT NULL column', function (done) {
 var res = alasql('UPDATE dbo.Employees SET mgrid = 3 WHERE empid = 2');
 assert(res == 1);
 done();
 });

 it.skip('13. UPDATE table with constraints violation', function (done) {
 it('13. UPDATE table with constraints violation', function (done) {
 //    console.log(alasql.databases.dbo.tables.Employees);
 assert.throws(function () {
 var res = alasql('UPDATE dbo.Employees SET mgrid = 1 WHERE empid = 1');
 done();
 });

 it.skip('14. CURRENT_TIMESTAMP', function (done) {
 it('14. CURRENT_TIMESTAMP', function (done) {
 var res = alasql('SELECT VALUE CURRENT_TIMESTAMP');
 assert(res.length == '2015.05.11 07:58:20.078'.length);
 assert(res.substr(0, 2) == '20');
 done();
 });
 it.skip('19. DROP DATABASE', function (done) {
 it('19. DROP DATABASE', function (done) {
 alasql('DROP DATABASE test324b');
 done();
 });

 it.skip('20. Full example', function (done) {
 it('20. Full example', function (done) {
 alasql('SOURCE "test324.sql"');
 // Check NO COUNT
 alasql.options.nocount = false;
diff --git a/test/test325.js b/test/test325.js
 }

 describe('Test 325 IDENTITY', function () {
 it.skip('1. CREATE DATABASE', function (done) {
 it('1. CREATE DATABASE', function (done) {
 alasql('CREATE DATABASE test325; USE test325');
 done();
 });

 it.skip('2. CREATE TABLE with multiple constraints', function (done) {
 it('2. CREATE TABLE with multiple constraints', function (done) {
 alasql(function () {
 /*
    IF OBJECT_ID('dbo.Messages') IS NOT NULL DROP TABLE dbo.Messages;
      status VARCHAR(20)  NOT NULL DEFAULT('new')
        CHECK(status IN('new', 'open')),
      CONSTRAINT PK_Messages
        PRIMARY KEY NONCLUSTERED(msgid),
        PRIMARY KEY(msgid),
      CONSTRAINT UNQ_Messages_status_msgid
        UNIQUE CLUSTERED(status, msg),
        UNIQUE(status, msg),
      CONSTRAINT CHK_Messages_status
        CHECK (status IN('new', 'open', 'done'))
      CONSTRAINT FakeDomainCheck
        CHECK (VALUE->msg != 'Virtue? I spit on virtue!')
    );
  */
 });
 done();
 });

 it.skip('3. INSERT INTO', function (done) {
 it('3. INSERT INTO', function (done) {
 var res = alasql(
 'INSERT INTO dbo.Messages (msgts, msg, status) \
      VALUES("2015.01.01","I love you!","new")'
 done();
 });

 it.skip('4. INSERT INTO with NOT NULL violation', function (done) {
 it('4. INSERT INTO with NOT NULL violation', function (done) {
 assert.throws(function () {
 var res = alasql(
 'INSERT INTO dbo.Messages (msgts, msg, status) \
 done();
 });

 it.skip('5. INSERT INTO with CHECK violation', function (done) {
 it('5. INSERT INTO with CHECK violation', function (done) {
 assert.throws(function () {
 var res = alasql(
 'INSERT INTO dbo.Messages (msgts, msg, status) \
 done();
 });

 it.skip('6. INSERT INTO with UNIQUE violation', function (done) {
 it('6. INSERT INTO with UNIQUE violation', function (done) {
 assert.throws(function () {
 var res = alasql(
 'INSERT INTO dbo.Messages (msgts, msg, status) \
 done();
 });

 it.skip('7. INSERT INTO with IDENTITY', function (done) {
 it('7. INSERT INTO with IDENTITY', function (done) {
 // console.log(69,alasql.tables.Messages.identities);
 // console.log(69,alasql.tables.Messages.uniqs);
 // console.log(69,alasql.tables.Messages.pk);
 done();
 });

 it.skip('8. INSERT INTO with IDENTITY', function (done) {
 it('8. INSERT INTO with IDENTITY', function (done) {
 var res = alasql(
 'INSERT INTO dbo.Messages (msg, status) \
      VALUES("I hate you!","new")'
 done();
 });

 it.skip('9. INSERT INTO with IDENTITY', function (done) {
 it('9. INSERT INTO with IDENTITY', function (done) {
 var res = alasql(
 'INSERT INTO dbo.Messages (msg, status) \
      VALUES("I hate you to much!","new")'
 done();
 });

 it.skip('10. INSERT INTO with IDENTITY', function (done) {
 it('10. INSERT INTO with IDENTITY', function (done) {
 var res = alasql('SELECT COLUMN msgid FROM dbo.Messages');
 assert.deepEqual(res, [1, 2, 3]);
 //    console.log(res);
 done();
 });

 it.skip('11. CHECK CONSTRAINT on column', function (done) {
 it('11. CHECK CONSTRAINT on column', function (done) {
 assert.throws(function () {
 var res = alasql(
 'INSERT INTO dbo.Messages (msg, status) \
 done();
 });

 it.skip('12. DEFAULT()', function (done) {
 it('12. DEFAULT()', function (done) {
 var res = alasql(
 'INSERT INTO dbo.Messages (msg) \
        VALUES("It lucky rainbow!")'
 done();
 });

 it.skip('13. SELECT with REMOVE COLUMNS', function (done) {
 it('13. SELECT with REMOVE COLUMNS', function (done) {
 var res = alasql('SELECT COLUMN msgid FROM dbo.Messages');
 assert.deepEqual(res, [1, 2, 3, 4]);
 var res = alasql('SELECT * REMOVE COLUMN msgts FROM dbo.Messages WHERE msgid = 4');
 done();
 });

 it.skip('99. DROP DATABASE', function (done) {
 it('99. DROP DATABASE', function (done) {
 alasql('DROP DATABASE test325');
 done();
 });
Original file line number	Diff line number	Diff line change
Expand Up		@@ -507,7 +507,7 @@
		return '(' + declareRefs + ', ' + expr + ')';
		}

		return `(${declareRefs}, y.some(e => e == null) ? void 0 : ${expr})`;
		return `(${declareRefs}, y.some(e => e == null \|\| (typeof e === 'number' && isNaN(e))) ? void 0 : ${expr})`;
		}
		}

Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -125,7 +125,7 @@ yy.CreateTable.prototype.execute = function (databaseid, params, cb) {
		if (col.check) {
		table.checks.push({
		id: col.check.constrantid,
		fn: new Function('r', 'var y;return ' + col.check.expression.toJS('r', '')),
		fn: new Function('r,params,alasql', 'var y;return ' + col.check.expression.toJS('r', '')),
		});
		}

Expand DownExpand Up		@@ -168,19 +168,23 @@ yy.CreateTable.prototype.execute = function (databaseid, params, cb) {
		}
		var fkfn = function (r) {
		var rr = {};
		if (typeof r[col.columnid] === 'undefined') {
		// Allow NULL values in foreign keys (check for undefined, null, and NaN)
		var val = r[col.columnid];
		if (
		typeof val === 'undefined' \|\|
		val === null \|\|
		(typeof val === 'number' && isNaN(val))
		) {
		return true;
		}
		rr[fk.columnid] =r[col.columnid];
		rr[fk.columnid] =val;
		var addr = fktable.pk.onrightfn(rr);
		if (!fktable.uniqs[fktable.pk.hh][addr]) {
		throw new Error(
		'Foreign key "' + r[col.columnid] + '" not found in table "' + fk.tableid + '"'
		);
		throw new Error('Foreign key "' + val + '" not found in table "' + fk.tableid + '"');
		}
		return true;
		};
		table.checks.push({fn: fkfn});
		table.checks.push({fn: fkfn, fk: true});
		}

		if (col.onupdate) {
Expand DownExpand Up		@@ -212,7 +216,7 @@ yy.CreateTable.prototype.execute = function (databaseid, params, cb) {
		pk.hh = hash(pk.onrightfns);
		table.uniqs[pk.hh] = {};
		} else if (con.type === 'CHECK') {
		checkfn = new Function('r', 'var y;return ' + con.expression.toJS('r', ''));
		checkfn = new Function('r,params,alasql', 'var y;return ' + con.expression.toJS('r', ''));
		} else if (con.type === 'UNIQUE') {
		var uk = {};
		table.uk = table.uk \|\| [];
Expand DownExpand Up		@@ -371,7 +375,9 @@ yy.CreateTable.prototype.execute = function (databaseid, params, cb) {

		if (table.checks && table.checks.length > 0) {
		table.checks.forEach(function (check) {
		if (!check.fn(r)) {
		// In SQL, CHECK constraints treat NULL (undefined) as passing
		// Only fail if the check explicitly returns false
		if (check.fn(r, {}, alasql) === false) {
		//if(orreplace) toreplace=true; else
		throw new Error('Violation of CHECK constraint ' + (check.id \|\| ''));
		}
Expand DownExpand Up		@@ -640,7 +646,9 @@ yy.CreateTable.prototype.execute = function (databaseid, params, cb) {
		// PART 2 - POST CHECK
		if (table.checks && table.checks.length > 0) {
		table.checks.forEach(function (check) {
		if (!check.fn(r)) {
		// In SQL, CHECK constraints treat NULL (undefined) as passing
		// Only fail if the check explicitly returns false
		if (check.fn(r, params, alasql) === false) {
		throw new Error('Violation of CHECK constraint ' + (check.id \|\| ''));
		}
		});
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -6,12 +6,12 @@ if (typeof exports === 'object') {
		}

		describe('Test 324 Roads samples', function () {
		it.skip('1. CREATE DATABASE', function (done) {
		it('1. CREATE DATABASE', function (done) {
		alasql('CREATE DATABASE test324a; USE test324a');
		done();
		});

		it.skip('2. OBJECT_ID()', function (done) {
		it('2. OBJECT_ID()', function (done) {
		alasql('CREATE TABLE dbo.Employees(id INT, name STRING)');
		alasql('INSERT INTO dbo.Employees VALUES (1,"Tomas"),(2,"Lisa")');
		assert.deepEqual(alasql('SELECT * FROM dbo.Employees'), [
Expand All		@@ -28,17 +28,17 @@ describe('Test 324 Roads samples', function () {
		done();
		});

		it.skip('3. DROP DATABASE', function (done) {
		it('3. DROP DATABASE', function (done) {
		alasql('DROP DATABASE test324a');
		done();
		});

		it.skip('2. CREATE DATABASE', function (done) {
		it('2. CREATE DATABASE', function (done) {
		alasql('CREATE DATABASE test324b; USE test324b');
		done();
		});

		it.skip('3. CREATE TABLE with constraints', function (done) {
		it('3. CREATE TABLE with constraints', function (done) {
		var res = alasql(function () {
		/*
		CREATE TABLE dbo.Employees
Expand All		@@ -56,7 +56,7 @@ describe('Test 324 Roads samples', function () {
		done();
		});

		it.skip('4. INSERT INTO table with constraints', function (done) {
		it('4. INSERT INTO table with constraints', function (done) {
		var res = alasql(function () {
		/*
		INSERT INTO dbo.Employees(empid, mgrid, empname, salary) VALUES
Expand All		@@ -72,7 +72,7 @@ describe('Test 324 Roads samples', function () {
		done();
		});

		it.skip('5. INSERT INTO table with same primary key', function (done) {
		it('5. INSERT INTO table with same primary key', function (done) {
		assert.throws(function () {
		var res = alasql(function () {
		/*
Expand All		@@ -85,7 +85,7 @@ describe('Test 324 Roads samples', function () {
		done();
		});

		it.skip('6. INSERT INTO wrong NULL in NOT NULL column', function (done) {
		it('6. INSERT INTO wrong NULL in NOT NULL column', function (done) {
		assert.throws(function () {
		var res = alasql(function () {
		/*
Expand All		@@ -97,27 +97,27 @@ describe('Test 324 Roads samples', function () {
		done();
		});

		it.skip('7. UPDATE wrong NULL in NOT NULL column', function (done) {
		it('7. UPDATE wrong NULL in NOT NULL column', function (done) {
		assert.throws(function () {
		var res = alasql('UPDATE dbo.Employees SET empid = NULL WHERE empid = 1');
		}, Error);
		done();
		});

		it.skip('8. UPDATE wrong NULL in NOT NULL column', function (done) {
		it('8. UPDATE wrong NULL in NOT NULL column', function (done) {
		var res = alasql('UPDATE dbo.Employees SET mgrid = NULL WHERE empid = 2');
		assert(res == 1);
		done();
		});

		it.skip('9. UPDATE wrong NULL in NOT NULL column', function (done) {
		it('9. UPDATE wrong NULL in NOT NULL column', function (done) {
		assert.throws(function () {
		var res = alasql('UPDATE dbo.Employees SET mgrid = 3 WHERE empid = 2');
		}, Error);
		done();
		});

		it.skip('10. INSERT INTO table with constraints violation', function (done) {
		it('10. INSERT INTO table with constraints violation', function (done) {
		// console.log(alasql.databases.dbo.tables.Employees);
		assert.throws(function () {
		var res = alasql(
Expand All		@@ -129,7 +129,7 @@ describe('Test 324 Roads samples', function () {
		done();
		});

		it.skip('11. INSERT INTO table with constraints violation', function (done) {
		it('11. INSERT INTO table with constraints violation', function (done) {
		// console.log(alasql.databases.dbo.tables.Employees);
		var res = alasql(
		"INSERT INTO dbo.Employees(empid, mgrid, empname, salary) \
Expand All		@@ -140,13 +140,13 @@ describe('Test 324 Roads samples', function () {
		done();
		});

		it.skip('12. UPDATE wrong NULL in NOT NULL column', function (done) {
		it('12. UPDATE wrong NULL in NOT NULL column', function (done) {
		var res = alasql('UPDATE dbo.Employees SET mgrid = 3 WHERE empid = 2');
		assert(res == 1);
		done();
		});

		it.skip('13. UPDATE table with constraints violation', function (done) {
		it('13. UPDATE table with constraints violation', function (done) {
		// console.log(alasql.databases.dbo.tables.Employees);
		assert.throws(function () {
		var res = alasql('UPDATE dbo.Employees SET mgrid = 1 WHERE empid = 1');
Expand All		@@ -155,18 +155,18 @@ describe('Test 324 Roads samples', function () {
		done();
		});

		it.skip('14. CURRENT_TIMESTAMP', function (done) {
		it('14. CURRENT_TIMESTAMP', function (done) {
		var res = alasql('SELECT VALUE CURRENT_TIMESTAMP');
		assert(res.length == '2015.05.11 07:58:20.078'.length);
		assert(res.substr(0, 2) == '20');
		done();
		});
		it.skip('19. DROP DATABASE', function (done) {
		it('19. DROP DATABASE', function (done) {
		alasql('DROP DATABASE test324b');
		done();
		});

		it.skip('20. Full example', function (done) {
		it('20. Full example', function (done) {
		alasql('SOURCE "test324.sql"');
		// Check NO COUNT
		alasql.options.nocount = false;
Expand Down
Original file line number	Diff line number	Diff line change
Expand Up		@@ -6,12 +6,12 @@ if (typeof exports === 'object') {
		}

		describe('Test 325 IDENTITY', function () {
		it.skip('1. CREATE DATABASE', function (done) {
		it('1. CREATE DATABASE', function (done) {
		alasql('CREATE DATABASE test325; USE test325');
		done();
		});

		it.skip('2. CREATE TABLE with multiple constraints', function (done) {
		it('2. CREATE TABLE with multiple constraints', function (done) {
		alasql(function () {
		/*
		IF OBJECT_ID('dbo.Messages') IS NOT NULL DROP TABLE dbo.Messages;
Expand All		@@ -23,20 +23,18 @@ describe('Test 325 IDENTITY', function () {
		status VARCHAR(20) NOT NULL DEFAULT('new')
		CHECK(status IN('new', 'open')),
		CONSTRAINT PK_Messages
		PRIMARY KEY NONCLUSTERED(msgid),
		PRIMARY KEY(msgid),
		CONSTRAINT UNQ_Messages_status_msgid
		UNIQUE CLUSTERED(status, msg),
mathiasrw marked this conversation as resolved. Show resolvedHide resolved
		UNIQUE(status, msg),
		CONSTRAINT CHK_Messages_status
		CHECK (status IN('new', 'open', 'done'))
		CONSTRAINT FakeDomainCheck
		CHECK (VALUE->msg != 'Virtue? I spit on virtue!')
		);
		*/
		});
		done();
		});

		it.skip('3. INSERT INTO', function (done) {
		it('3. INSERT INTO', function (done) {
		var res = alasql(
		'INSERT INTO dbo.Messages (msgts, msg, status) \
		VALUES("2015.01.01","I love you!","new")'
Expand All		@@ -46,7 +44,7 @@ describe('Test 325 IDENTITY', function () {
		done();
		});

		it.skip('4. INSERT INTO with NOT NULL violation', function (done) {
		it('4. INSERT INTO with NOT NULL violation', function (done) {
		assert.throws(function () {
		var res = alasql(
		'INSERT INTO dbo.Messages (msgts, msg, status) \
Expand All		@@ -57,7 +55,7 @@ describe('Test 325 IDENTITY', function () {
		done();
		});

		it.skip('5. INSERT INTO with CHECK violation', function (done) {
		it('5. INSERT INTO with CHECK violation', function (done) {
		assert.throws(function () {
		var res = alasql(
		'INSERT INTO dbo.Messages (msgts, msg, status) \
Expand All		@@ -68,7 +66,7 @@ describe('Test 325 IDENTITY', function () {
		done();
		});

		it.skip('6. INSERT INTO with UNIQUE violation', function (done) {
		it('6. INSERT INTO with UNIQUE violation', function (done) {
		assert.throws(function () {
		var res = alasql(
		'INSERT INTO dbo.Messages (msgts, msg, status) \
Expand All		@@ -79,7 +77,7 @@ describe('Test 325 IDENTITY', function () {
		done();
		});

		it.skip('7. INSERT INTO with IDENTITY', function (done) {
		it('7. INSERT INTO with IDENTITY', function (done) {
		// console.log(69,alasql.tables.Messages.identities);
		// console.log(69,alasql.tables.Messages.uniqs);
		// console.log(69,alasql.tables.Messages.pk);
Expand All		@@ -89,7 +87,7 @@ describe('Test 325 IDENTITY', function () {
		done();
		});

		it.skip('8. INSERT INTO with IDENTITY', function (done) {
		it('8. INSERT INTO with IDENTITY', function (done) {
		var res = alasql(
		'INSERT INTO dbo.Messages (msg, status) \
		VALUES("I hate you!","new")'
Expand All		@@ -98,7 +96,7 @@ describe('Test 325 IDENTITY', function () {
		done();
		});

		it.skip('9. INSERT INTO with IDENTITY', function (done) {
		it('9. INSERT INTO with IDENTITY', function (done) {
		var res = alasql(
		'INSERT INTO dbo.Messages (msg, status) \
		VALUES("I hate you to much!","new")'
Expand All		@@ -107,14 +105,14 @@ describe('Test 325 IDENTITY', function () {
		done();
		});

		it.skip('10. INSERT INTO with IDENTITY', function (done) {
		it('10. INSERT INTO with IDENTITY', function (done) {
		var res = alasql('SELECT COLUMN msgid FROM dbo.Messages');
		assert.deepEqual(res, [1, 2, 3]);
		// console.log(res);
		done();
		});

		it.skip('11. CHECK CONSTRAINT on column', function (done) {
		it('11. CHECK CONSTRAINT on column', function (done) {
		assert.throws(function () {
		var res = alasql(
		'INSERT INTO dbo.Messages (msg, status) \
Expand All		@@ -124,7 +122,7 @@ describe('Test 325 IDENTITY', function () {
		done();
		});

		it.skip('12. DEFAULT()', function (done) {
		it('12. DEFAULT()', function (done) {
		var res = alasql(
		'INSERT INTO dbo.Messages (msg) \
		VALUES("It lucky rainbow!")'
Expand All		@@ -133,7 +131,7 @@ describe('Test 325 IDENTITY', function () {
		done();
		});

		it.skip('13. SELECT with REMOVE COLUMNS', function (done) {
		it('13. SELECT with REMOVE COLUMNS', function (done) {
		var res = alasql('SELECT COLUMN msgid FROM dbo.Messages');
		assert.deepEqual(res, [1, 2, 3, 4]);
		var res = alasql('SELECT * REMOVE COLUMN msgts FROM dbo.Messages WHERE msgid = 4');
Expand All		@@ -142,7 +140,7 @@ describe('Test 325 IDENTITY', function () {
		done();
		});

		it.skip('99. DROP DATABASE', function (done) {
		it('99. DROP DATABASE', function (done) {
		alasql('DROP DATABASE test325');
		done();
		});
Expand Down