---

This section details on the original issue you should resolve

<issue_title>primary key not working. Adds duplicate values.</issue_title>
<issue_description>I have the following code but it is not working:

alasql("create INDEXEDDB DATABASE if not exists localdb_db");alasql("ATTACH INDEXEDDB DATABASE localdb_db; \ CREATE TABLE if not exists localdb_db.db_Settings(**setting varchar(50) Primary Key**, `value` varchar(300), storeInSession varchar(1) DEFAULT 'N')", function(res) {             console.log(res + " :indexedDB"); }); alasql("ATTACH INDEXEDDB DATABASE localdb_db; \ INSERT INTO localdb_db.db_Settings (setting,`value` ) values(?,?)", ["domain", "http"], function(res) {             console.log(res); });         alasql("ATTACH INDEXEDDB DATABASE localdb_db; \ INSERT INTO localkics_db.db_Settings (setting, `value` ) values(?,?)", ["domain", "https"], function(res) {             //console.log(res); }); alasql("ATTACH INDEXEDDB DATABASE localdb_db; \ SELECT * FROM localdb_db.db_Settings", [], function(res) {             console.log(res);         });

It does not create the primary key [setting] therefore it allows me to insert duplicates. For some reason it is automatically creating its own key. I even tried by using string instead of varchar.

'#' |Key | Value
0 | 1 | {setting: “domain”, value: ”http”}
1 | 2 | {setting: “domain”, value: ”https”}

Could you please advise me what to do here?

Thank You.

</issue_description>

<agent_instructions>Please start by making a new test file named test/test1292.js and make sure we replicate the issue and the expected behavour.

Then fix the problem in the implemented code. Useyarn test to confirm.

If you need to update the grammar then please make as few changes to alasqlparser.jison as possible and runyarn jison && yarn test to confirm.

Always runyarn format before committing. </agent_instructions>

Comments on the Issue (you are@copilot in this section)