duckdb / duckdb/duckdb-node

Second argument to statement.each is never called..

Open
#146 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
91
Forks
36
PR merge metrics
No merged PRs in 30d

Description

### Problem Statement
`statement.each` takes 2 callbacks, first one gets called for each row, whereas 2nd one once all rows are over. This is also reflected by the underlying C code. But, on using it, it seems 2nd callback never gets called.

### Test code:

```javascript
import duckdb from 'duckdb';

// Create a new database instance and connect to it
const db = new duckdb.Database('./duckdb_file.duckdb', duckdb.OPEN_READWRITE);

db.serialize(() => {
const stmt = db.prepare('SELECT * FROM table_1 limit ?');

let count = 0;
stmt.each(10000, (err, row) => {
if (err) {
console.error('Error:', err);
return;
}
//console.log(row);
count++;
}, () => {
console.log(`Query completed. count: ${count}`);
// Finalize the statement when done
stmt.finalize();
});
});

// Close the database
db.close((err) => {
if (err) {
console.error('Error closing the database:', err);
} else {
console.log('Database closed.');
}
});
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.