Skip to content

Conversation

@BARNZ
Copy link

@BARNZ BARNZ commented Mar 13, 2024

A recent MR #10273 included some unnecessary changes that made SQLite PRAGMA queries be executed using connection.run instead of connection.query.

This causes the bug reported in #10687

This MR simply reverts a small part of #10273 to go back to the previous working behavior.

… back to .run() instead of .query() for all PRAGMA calls.
Copy link
Collaborator

@gioboa gioboa left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Thanks @BARNZ
May I ask you to add a test for this?

@BARNZ BARNZ mentioned this pull request May 12, 2025
5 tasks
@alumni
Copy link
Collaborator

alumni commented May 13, 2025

@gioboa we don't have tests for capacitor.

Shall we merge this or #11467?

@gioboa gioboa requested a review from alumni May 14, 2025 10:15
Copy link
Collaborator

@gioboa gioboa left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

@gioboa we don't have tests for capacitor.

Shall we merge this or #11467?

🤔 I found this statement in the capacitor API docs
SQLite Special commands (PRAGMA) should be executed using the execute plugin method.

@alumni
Copy link
Collaborator

alumni commented May 14, 2025

@gioboa see the other pr

@gioboa
Copy link
Collaborator

gioboa commented May 14, 2025

@gioboa see the other pr

Yep, the other PR seems aligned with the capacitor docs

@alumni
Copy link
Collaborator

alumni commented May 14, 2025

Ok, I already approved both PRs recently, so we can merge one of them

@alumni
Copy link
Collaborator

alumni commented May 14, 2025

Thanks @BARNZ, we merged PR #11467 which is similar :)

@alumni alumni closed this May 14, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants