Skip to content

[Bug]: SQL Tools Service component crashes when opening/writing huge WHERE statement into Query #19890

@kackburt

Description

@kackburt

Description

Expected to be able to execute SQL statement with multiple WHERE statements, but the extension crashes with the error "mssql: SQL Tools Service component could not start."

Sidenote: As workaround you can use a CTE to SELECT needed VALUES and then JOIN this CTE instead of using huge WHERE statement.

Steps to Reproduce

Open SQL query with huge amount of WHERE statements f.e.

SELECT TOP 10 column1, column2
FROM dbo.testtable 
WHERE column1 = 'Test'
    AND ( 
        column2 = 'Test1' OR
column2 = 'Test2' OR
column2 = 'Test3' OR
column2 = 'Test4' OR
column2 = 'Test5' OR
column2 = 'Test6' OR
column2 = 'Test7' OR
column2 = 'Test8' OR
column2 = 'Test9' OR
column2 = 'Test10' OR
column2 = 'Test11' OR
column2 = 'Test12' OR
column2 = 'Test13' OR
column2 = 'Test14' OR
column2 = 'Test15' OR
column2 = 'Test16' OR
column2 = 'Test17' OR
column2 = 'Test18' OR
column2 = 'Test19' OR
column2 = 'Test20' OR
column2 = 'Test21' OR
column2 = 'Test22' OR
column2 = 'Test23' OR
column2 = 'Test24' OR
column2 = 'Test25' OR
column2 = 'Test26' OR
column2 = 'Test27' OR
column2 = 'Test28' OR
column2 = 'Test29' OR
column2 = 'Test30' OR
column2 = 'Test31' OR
column2 = 'Test32' OR
column2 = 'Test33' OR
column2 = 'Test34' OR
column2 = 'Test35' OR
column2 = 'Test36' OR
column2 = 'Test37' OR
column2 = 'Test38' OR
column2 = 'Test39' OR
column2 = 'Test40' OR
column2 = 'Test41' OR
column2 = 'Test42' OR
column2 = 'Test43' OR
column2 = 'Test44' OR
column2 = 'Test45' OR
column2 = 'Test46' OR
column2 = 'Test47' OR
column2 = 'Test48' OR
column2 = 'Test49' OR
column2 = 'Test50' OR
column2 = 'Test51' OR
column2 = 'Test52' OR
column2 = 'Test53' OR
column2 = 'Test54' OR
column2 = 'Test55' OR
column2 = 'Test56' OR
column2 = 'Test57' OR
column2 = 'Test58' OR
column2 = 'Test59' OR
column2 = 'Test60' OR
column2 = 'Test61' OR
column2 = 'Test62' OR
column2 = 'Test63' OR
column2 = 'Test64' OR
column2 = 'Test65' OR
column2 = 'Test66' OR
column2 = 'Test67' OR
column2 = 'Test68' OR
column2 = 'Test69' OR
column2 = 'Test70' OR
column2 = 'Test71' OR
column2 = 'Test72' OR
column2 = 'Test73' OR
column2 = 'Test74' OR
column2 = 'Test75' OR
column2 = 'Test76' OR
column2 = 'Test77' OR
column2 = 'Test78' OR
column2 = 'Test79' OR
column2 = 'Test80' OR
column2 = 'Test81' OR
column2 = 'Test82' OR
column2 = 'Test83' OR
column2 = 'Test84' OR
column2 = 'Test85' OR
column2 = 'Test86' OR
column2 = 'Test87' OR
column2 = 'Test88' OR
column2 = 'Test89' OR
column2 = 'Test90' OR
column2 = 'Test91' OR
column2 = 'Test92' OR
column2 = 'Test93' OR
column2 = 'Test94' OR
column2 = 'Test95' OR
column2 = 'Test96' OR
column2 = 'Test97' OR
column2 = 'Test98' OR
column2 = 'Test99' OR
column2 = 'Test100' OR
... continue ... this field is limited so I had to cut some rows :-) ...
column2 = 'Test10000'
)

Affected Area

  • Connection dialog
  • Query results panel
  • Query editor
  • Object Explorer
  • Table Designer
  • Schema Compare
  • Schema Designer
  • Local container
  • GitHub Copilot integration
  • Query Plan Visualizer
  • Other (please describe below)

If you selected "Other", please describe the affected area

No response

Environment Information

  • OS: macOS Sequoia 15.5
  • VSCode version: 1.102.3
  • MSSQL extension version: 1.32.1 and 1.33.0

Confirmation

  • I have searched existing issues and couldn't find a match
  • I want to work on this issue

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions