Skip to content
This repository was archived by the owner on Dec 15, 2022. It is now read-only.
This repository was archived by the owner on Dec 15, 2022. It is now read-only.

broken syntax highlighting with strange combination of SQL code inside of mult-line string #143

Open

Description

@jdavidheiser

As seen in the below code snippit - the extra assignment lines are interpreted as being part of the triple quote.

Getting rid of the parens or the SELECT statement (so it's not not trying to format as if it were SQL) seems to stop this behavior.

text = """ ('SELECT columns FROM table') """
int = 1
float = 2.0

screen shot

Activity

  1. ulidtko commented on May 12, 2016

    @ulidtko

    Two levels of quoting seem to trigger bad markup as well.

    E.g. with single level of quoting:
    screenshot from 2016-05-12 15-30-04

    and with nested quoting:
    screenshot from 2016-05-12 15-30-27

    What's especially vexing with this bug — the rest of the file gets mishighlighted as well, and no simple way around that.

  2. thomir commented on Jul 17, 2016

    @thomir

    Is there a workaround for this? Personally I'm fine without the syntax highlighting for SQL statements.

  3. PostalBlab commented on Aug 6, 2016

    @PostalBlab

    @thomir you can disable language-sql. This works for me.

  4. erichurkman commented on Aug 15, 2016

    @erichurkman

    This also seems to slow down the entire editor. I have a rather large file full of multi-line strings with embedded quotes in SQL, and editing any line after the first instance of this formatting issue causes is 2-3 seconds per keystroke. Disabling language-sql does work, thanks @PostalBlab

  5. matt-baker commented on Oct 12, 2016

    @matt-baker

    @PostalBlab - thanks for the workaround on disabling language-sql. That worked for me as well.

    For anyone else looking for where to disable language-sql - it's under Preferences\Packages.

  6. agrrh commented on Jan 6, 2018

    @agrrh

    +1, really annoying bug, especially with 'DELETE' part.

  7. ulidtko commented on Jan 10, 2018

    @ulidtko

    Looks like language-python is heading to the trash can; MagicPython to replace it, see atom/atom/#13877.

  8. sunnyakaxd commented on Jul 9, 2018

    @sunnyakaxd
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions