Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Table does not exist [ rowid, * ~ DB.Table ] #3659

Open
DingBEN opened this issue Feb 2, 2020 · 0 comments
Open

Table does not exist [ rowid, * ~ DB.Table ] #3659

DingBEN opened this issue Feb 2, 2020 · 0 comments

Comments

@DingBEN
Copy link

@DingBEN DingBEN commented Feb 2, 2020

Details

This issue makes the #3654 GO-AROUND more complex, as some queries will need to be paired with a 2nd query to go around this issue and in the case of multiple DBs in a query... oops! can't use rowid!?
- figure this out, I give no explanation, the examples are the clue
something is skewed in the engine [ parser maybe!? ]

  • Error while executing SQL query on database 'DB': no such table: DB.Table

  • code FAILS with above error
    (1) SELECT rowid, * FROM DB.Table where thiscol="SQLiteStudio issues" [ DB selector matters not ]

  • code works, on this very query and other queries which use 'rowid, *' syntax
    (2) SELECT * FROM DB.Table where thiscol="SQLiteStudio issues" [ DB selector matters not ]

    (3) SELECT rowid, * FROM Table where thiscol="SQLiteStudio issues" [ DB selector must be on correct DB ]

Note: in all above examples, WHERE clause matters not

Steps to reproduce - self evident

Operating system - WIN7 Pro

SQLiteStudio version - 3 .2.1

@DingBEN DingBEN changed the title SQL Table does not exist [ rowid, * ~ DB.Table ] Table does not exist [ rowid, * ~ DB.Table ] Feb 2, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant
You can’t perform that action at this time.