sqlitebrowser / sqlitebrowser/sqlitebrowser
[Bug]: Error On Export Database To SQL file
Nobody has claimed this yet.
- Dominant language
- C++
- Stars
- 24.6k
- Forks
- 2.4k
- Avg merge
- 3d 49m
- Merged PRs (30d)
- 3
Description
What did you do?
I have database while an software use sqlite to save the data.
I open the database with DB4S, and want to export the database to SQL file.
In SQL file, the statement as follows
CREATE TABLE IF NOT EXISTSAL TABLE FullTextTbl USING FTS3 (ItemId INTEGER PRIMARY KEY, FullText TEXT);
I think it was error, may be the right way like this
CREATE VIRTUAL TABLE IF NOT EXISTS FullTextTbl USING FTS3 (ItemId INTEGER PRIMARY KEY, FullText TEXT);
Can be repair the export error?
Many Thanks
What did you expect to see?
To see the right statement
What did you see instead?
nil
DB4S Version
3.13.1
What OS are you seeing the problem on?
Windows
OS version
Window 10
Relevant log output
Prevention against duplicate issues
- I have searched for similar issues
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No source file or test is named. Reproduce the export with an SQLite database containing the reported FTS3 table, then trace the database-to-SQL export entry point and compare the generated statement with the expected CREATE VIRTUAL TABLE form; done means the exported SQL is valid and preserves the virtual table definition.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, sqlite
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100