ST4 4175 and SQL Code Highlighting

[ivanionut]

In version ST4 4175, SQL code is no longer highlighted correctly:

In the ST4 DEV changelog, I found two builds (4174 and 4175) with the note "Various syntax highlighting improvements."

[jcberquist]

I have tested this, and it looks like the SQL highlighting scopes are still being applied (e.g. source.sql keyword.other.DML.sql for the SELECT). If you are not seeing distinctive highlighting for those scopes it might be because of how your color scheme is highlighting those scopes.

You can verify the scopes applied to the SQL yourself by placing your cursor in the SQL statement and running the show_scope_name command. On Windows that is bound by default like so:

{ "keys": ["ctrl+alt+shift+p"], "command": "show_scope_name" }

[ivanionut]

Hi @jcberquist , I tried the Ctrl+Shift+P command (on macOS) and this is the result:

[jcberquist]

So it looks like the SQL scopes are still being applied. Have you tried a different color scheme?

[ivanionut]

hi, yes, I also tried with the default ST color theme but the same problem occurs...

[jcberquist]

Hm, with the default SQL syntax installed this should still be working. Have you installed a package that has a SQL syntax in it, that overrides the default one that ships with Sublime Text? That could change what scopes are applied to the SQL string.

[ivanionut]

Hello, Sorry for the delay.

I conducted the following test:

• I launched ST4 in safe mode: subl --safe-mode
• I installed Package Control
• I installed the CFML package

now the SQL syntax highlights correctly!

Now I've gone back to the normal version of ST4 (not safe mode) and I'm trying to deactivate the plugins one by one, but I haven't been able to find the problem yet.

This is strange. Could it be a settings issue?

[ivanionut]

If it can be helpful, here is the console output during startup:

startup, version: 4177 osx arm64 channel: dev
executable: /Applications/Sublime Text.app/Contents/MacOS/sublime_text
application: /Applications/Sublime Text.app
working dir: /
packages path: /Users/ivanionut/Library/Application Support/Sublime Text/Packages
state path: /Users/ivanionut/Library/Application Support/Sublime Text/Local
zip path: /Applications/Sublime Text.app/Contents/MacOS/Packages
zip path: /Users/ivanionut/Library/Application Support/Sublime Text/Installed Packages
ignored_packages: ["SublimeLinter-contrib-CFLint", "Vintage"]
pre session restore time: 0.301005
OpenGL Context Information:
  GL API Version: 4.1 Metal - 88.1
  GLSL Version: 4.10
  Vendor: Apple
  Renderer: Apple M3 Pro
startup time: 0.365509
first paint time: 0.419727
environment variables loaded using: /bin/zsh -l
git: located Sublime Merge installed at /Applications/Sublime Merge.app
git: using configuration from system git install
git: tracking working dir /Users/ivanionut/Documents/WORKS/wip1
git: tracking working dir /Users/ivanionut/Documents/WORKS/wip2
reloading plugin Default.arithmetic
reloading plugin Default.auto_indent_tag
reloading plugin Default.block
reloading plugin Default.colors
reloading plugin Default.comment
reloading python 3.3 plugin AlignTab.aligner
reloading plugin Default.convert_color_scheme
reloading python 3.3 plugin AlignTab.aligntab
reloading python 3.3 plugin AlignTab.hist
reloading python 3.3 plugin AlignTab.parser
reloading python 3.3 plugin AlignTab.table
reloading python 3.3 plugin AlignTab.utils
reloading python 3.3 plugin AlignTab.wclen
reloading python 3.3 plugin AttrFold.attr_fold
reloading plugin Default.convert_syntax
reloading python 3.3 plugin BracketHighlighter.bh_core
reloading plugin Default.copy_path
reloading plugin Default.echo
reloading plugin Default.exec
reloading plugin Default.fold
reloading plugin Default.font
reloading plugin Default.goto_line
reloading plugin Default.history_list
reloading plugin Default.html_print
reloading plugin Default.indentation
reloading plugin Default.install_package_control
reloading plugin Default.keymap
reloading plugin Default.kill_ring
reloading plugin Default.mark
reloading plugin Default.new_templates
reloading plugin Default.open_context_url
reloading plugin Default.open_in_browser
reloading plugin Default.pane
reloading plugin Default.paragraph
reloading plugin Default.paste_from_history
reloading plugin Default.profile
reloading plugin Default.quick_panel
reloading plugin Default.rename
reloading plugin Default.run_syntax_tests
reloading plugin Default.save_on_focus_lost
reloading plugin Default.scroll
reloading plugin Default.set_unsaved_view_name
reloading plugin Default.settings
reloading plugin Default.show_scope_name
reloading plugin Default.side_bar
reloading plugin Default.sort
reloading plugin Default.switch_file
reloading plugin Default.symbol
reloading plugin Default.transform
reloading plugin Default.transpose
reloading plugin Default.ui
reloading plugin CSS.css_completions
reloading plugin Diff.diff
reloading plugin HTML.encode_html_entities
reloading plugin HTML.html_completions
reloading plugin A File Icon.plugin
reloading plugin CFML.cfml_plugin
reloading plugin Compass Navigator.plugin
reloading plugin Compass Navigator.utils
reloading plugin EditorConfig.EditorConfig
reloading plugin Less.plugin
reloading plugin LSP-css.data_types
reloading python 3.3 plugin BracketHighlighter.bh_logging
reloading python 3.3 plugin BracketHighlighter.bh_plugin
reloading python 3.3 plugin BracketHighlighter.bh_popup
reloading python 3.3 plugin BracketHighlighter.bh_regions
reloading python 3.3 plugin BracketHighlighter.bh_remove
reloading python 3.3 plugin BracketHighlighter.bh_rules
reloading python 3.3 plugin BracketHighlighter.bh_search
reloading python 3.3 plugin BracketHighlighter.bh_swapping
reloading python 3.3 plugin BracketHighlighter.bh_wrapping
reloading python 3.3 plugin BracketHighlighter.support
reloading python 3.3 plugin CFDocs.cfdocs
reloading python 3.3 plugin ChangeQuotes.change_quotes
reloading python 3.3 plugin Close All without Confirmation.close_all_without_confirm
reloading python 3.3 plugin FileDiffs.file_diffs
reloading python 3.3 plugin Indent XML.indentxml
reloading python 3.3 plugin Indent XML.setup
reloading python 3.3 plugin LastModifiedIndicator.LastModifiedIndicator
reloading plugin LSP-css.plugin
reloading python 3.3 plugin OpenHere.openhere
reloading python 3.3 plugin SideBarEnhancements.SideBar
reloading python 3.3 plugin SideBarEnhancements.SideBarAPI
reloading python 3.3 plugin Strip Whitespace Lines.sublime-strip-whitespace-lines
reloading python 3.3 plugin TabsExtra.support
reloading python 3.3 plugin TabsExtra.tab_menu
reloading plugin LSP-eslint.plugin
reloading plugin LSP-html.data_types
reloading plugin LSP-html.plugin
reloading python 3.3 plugin TabsExtra.tab_sort_helper
reloading python 3.3 plugin TabsExtra.tabs_extra
reloading plugin LSP-typescript.commands
reloading plugin LSP-typescript.plugin
reloading plugin LSP-typescript.plugin_types
reloading plugin LSP.boot
reloading python 3.3 plugin Terminus.main
reloading plugin MarkdownEditing.plugin
reloading python 3.3 plugin Theme - Monokai Pro.Monokai Pro
reloading plugin Package Control.plugin
reloading python 3.3 plugin TrailingSpaces.trailing_spaces
reloading python 3.3 plugin CloseFolder.CloseFolder
reloading python 3.3 plugin JsPrettier.__init__
reloading python 3.3 plugin JsPrettier.JsPrettier
reloading python 3.3 plugin StringUtilities.stringutilities
reloading plugin RainbowBrackets.main
reloading plugin Sass.plugin
reloading plugin SublimeLinter-json.linter
reloading plugin SublimeLinter-tslint.linter
reloading plugin SublimeLinter.__allo__
reloading plugin SublimeLinter.__init__
reloading plugin SublimeLinter._init
reloading plugin SublimeLinter.active_linters_view
reloading plugin SublimeLinter.busy_indicator_view
reloading plugin SublimeLinter.goto_commands
reloading plugin SublimeLinter.highlight_view
reloading plugin SublimeLinter.log_handler
reloading plugin SublimeLinter.panel_view
reloading plugin SublimeLinter.quick_actions
reloading plugin SublimeLinter.status_bar_view
reloading plugin SublimeLinter.sublime_linter
reloading plugin SFTP.SFTP
plugins loaded
Package Control: Skipping automatic upgrade, last run at 2024-07-24 08:43:10, next run at 2024-07-24 16:43:10 or after

[ivanionut]

You know what, I uninstalled all the plugins and started from scratch. I didn't really need all those plugins.

Now everything works and I've also done a bit of cleanup :)