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

SQLite - nested REPLACE statements cause freeze #737

Open
Odwerneh opened this issue Nov 26, 2020 · 0 comments
Open

SQLite - nested REPLACE statements cause freeze #737

Odwerneh opened this issue Nov 26, 2020 · 0 comments
Labels
sqlite SQLite driver triage

Comments

@Odwerneh
Copy link

Hello,

I am working with some SQLite plain SQL queries. All of them are working fine but when I use nested REPLACE statements to clean up some field in my table (I don't have an option to use REGEXP) the extension tries to call intellisense and then freezes.

Versions (tried several combinations on 3 PCs)
OS: Win 10 Pro 19042.630
VSCode: tried 1.48 - 1.51
SQLTools: Tried 0.22.9, 0.23.0
SQLTools SQLite: Tried 0.0.6, 0.2.0
Node: 12.18.0, 14.15.1

I cannot see any error anywhere. VSCode just does not execute the query. I cannot even run other SQLs.
When I restart it it works fine for all the other SQL files. When open the file with nested REPLACE statements, problem repeats.

The query as such runs without any issues. The problem is just when I want to add next column and intellisense starts to load the context.

[1606412937204] INFO  (ext): SQLTools is starting
[1606412937211] INFO  (ext): initializing language client...
[1606412937299] INFO  (ext): Registering client for languages [{"scheme":"sqltools"},{"language":"sql","scheme":"untitled"},{"language":"sql","scheme":"file"},{"language":"sql","scheme":"sqltools"}]
    ns: "lc"
[1606412937301] INFO  (ext): loading plugins...
[1606412937301] INFO  (ext): registering Formatter Plugin.
    plugin: {
      "name": "Formatter Plugin"
    }
[1606412937301] INFO  (ext): registering Connection Manager Plugin.
    plugin: {
      "name": "Connection Manager Plugin"
    }
[1606412937301] INFO  (ext): registering CodeLens Plugin.
    plugin: {
      "name": "CodeLens Plugin",
      "registeredLanguages": []
    }
[1606412937302] INFO  (ext): registering Dependency Manager Plugin.
    plugin: {
      "name": "Dependency Manager Plugin",
      "installingDrivers": []
    }
[1606412937303] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1606412937303] INFO  (ext): registering History Manager Plugin.
    plugin: {
      "name": "History Manager Plugin"
    }
[1606412937303] INFO  (ext): registering Bookmarks Manager Plugin.
    plugin: {
      "name": "Bookmarks Manager Plugin"
    }
[1606412937304] INFO  (ext): SQLTools activation completed. 99.497999 ms
[1606412937308] INFO  (ext): Formatter Plugin registered!
[1606412937308] INFO  (ext): CodeLens Plugin registered!
[1606412937308] INFO  (ext): Dependency Manager Plugin registered!
[1606412937308] INFO  (ext): Connection Manager Plugin registered!
[1606412937308] INFO  (ext): History Manager Plugin registered!
[1606412937308] INFO  (ext): Bookmarks Manager Plugin registered!
[1606412937359] INFO  (ext): registering SQLite Plugin (driver).
    plugin: {
      "extensionId": "mtxr.sqltools-driver-sqlite",
      "name": "SQLite Plugin",
      "type": "driver"
    }
[1606412937466] INFO  (ls): SQLTools Server started!
===============================
Using node runtime?: yes
ExecPath: C:\Program Files\nodejs\node.exe v14.15.1
===============================
[1606412937470] INFO  (ls): Telemetry enabled!
    ns: "telemetry"
[1606412937472] INFO  (ext): LanguageClient ready
    ns: "lc"
[1606412937474] INFO  (ls): REQUEST RECEIVED => ls/RegisterPlugin
[1606412937474] INFO  (ls): request to register plugin: "c:\Users\odwer\.vscode\extensions\mtxr.sqltools-driver-sqlite-0.2.0\out\ls\plugin.js"
[1606412937503] INFO  (ls): Driver sqlite registered!
    place: "driver-map"
    ns: "ls-context"
[1606412937504] INFO  (ext): SQLite Plugin (driver) registered!
[1606412938504] INFO  (ext): EXECUTING COMMAND => sqltools.refreshTree
[1606412938505] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1606412939313] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1606412957547] INFO  (ext): EXECUTING COMMAND => sqltools.executeQuery
[1606412957548] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1606412957548] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1606412957549] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1606412957549] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1606412959346] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1606412959347] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1606412959347] INFO  (ls): REQUEST RECEIVED => connection/ConnectRequest
[1606412959348] INFO  (ls): Connection instance created for test.
    ns: "conn-manager"
[1606412959425] INFO  (ext): Connection explorer changed. Will be updated.
    ns: "conn-man:explorer"
[1606412959935] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
[1606412959935] INFO  (ls): REQUEST RECEIVED => connection/GetConnectionsRequest
[1606412959936] INFO  (ls): REQUEST RECEIVED => connection/RunCommandRequest
[1606412968123] INFO  (ls): completion requested {"line":34,"character":1}
    ns: "intellisense"
[1606412982758] INFO  (ext): EXECUTING COMMAND => sqltools.executeQuery
[1606412982759] INFO  (ext): EXECUTING COMMAND => sqltools.getConnections
@gjsjohnmurray gjsjohnmurray added the sqlite SQLite driver label Jul 23, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
sqlite SQLite driver triage
Projects
None yet
Development

No branches or pull requests

2 participants