René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Query result during transaction will be blank if there's already a query with a similar \"group\" defined.","articleBody":"### Describe the bug\n\nIn a pretty specific situation, a query result will return BLANK during a transaction. You can see it in the code below (and in the linked stackblitz).\n\nTo reproduce:\n- define a first query with a group keyword.\n- start a transaction\n- define another query (on the same table) with a group keyword (can be a different column!)\n- call `getResultTable` and see that it's blank\n- finish the transaction\n- call `getResultTable` and see that it does return a value\n\nSee the following code (and linked reproduction).\n\n```ts\nconst store = createMergeableStore().setSchema(\n\t{\n\t\trecords: {\n\t\t\taccount: { type: 'string' },\n\t\t\tamount: { type: 'number' },\n\t\t\tdecimals: { type: 'number' },\n\t\t},\n\t},\n\t{}\n);\nstore.setTables({\n\trecords: generateDummyData(),\n});\n\nconst queries = createQueries(store);\n\nqueries.setQueryDefinition('budgetTotal', 'records', (keywords) =\u003e {\n\tkeywords.select('account');\n\tkeywords.select('amount');\n\t// if you comment out the group line here, the second query will work correctly.\n\tkeywords.group('amount', 'avg');\n});\n\nif (enableTransaction) {\n\tstore.startTransaction();\n}\n\nconst queryId = `otherQuery`;\nqueries.setQueryDefinition(queryId, 'records', (keywords) =\u003e {\n\tkeywords.select('amount');\n\tkeywords.where('account', '1');\n\t// or if you remove group here, this query will work correctly.\n\t// also has issues if you group by a completely different column\n\tkeywords.group('amount', 'sum');\n});\n\nconsole.log('first', JSON.stringify(queries.getResultTable(queryId))); // BLANK!\nconsole.log('second', JSON.stringify(queries.getResultTable(queryId))); // BLANK!\n\nif (enableTransaction) {\n\tstore.finishTransaction();\n\tconsole.log(\n\t\t'after transaction',\n\t\tJSON.stringify(queries.getResultTable(queryId))\n\t);\n}\n```\n\n### Your Example Website or App\n\nhttps://stackblitz.com/edit/vitejs-vite-jec8c4bm?file=src%2Fcounter.ts\n\n### Expected behavior\n\nI would expect the query to return correct data, even mid-transaction.\n\n### Platform\n\n- OS: macOS\n- Browser: Brave\n- Version: 6.3","author":{"url":"https://github.com/willhoney7","@type":"Person","name":"willhoney7"},"datePublished":"2025-07-08T03:03:59.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/259/tinybase/issues/259"}