Data

Tools

Indexes

Applications

Experiments

Issues

An open API service for providing issue and pull request metadata for open source projects.

GitHub / sql-formatter-org/sql-formatter issues and pull requests

Labelled with: bug

#906 - [FORMATTING] sql-formatter-disable not respected

Issue - State: closed - Opened by randomizedthinking 2 months ago - 2 comments
Labels: bug

#905 - [FORMATTING] TSQL with COLLATE is inconsistent

Issue - State: closed - Opened by svantek-admin 3 months ago - 2 comments
Labels: bug, transactsql

#904 - [FORMATTING] [PL/SQL] Formatting IF/END IF

Issue - State: open - Opened by Jimex 3 months ago
Labels: bug

#903 - [FORMATTING] GO ALTER in same line...

Issue - State: closed - Opened by EuSouVoce 3 months ago - 1 comment
Labels: bug

#901 - Avoid newlines for SET statements

Issue - State: open - Opened by chiawendt 3 months ago - 3 comments
Labels: bug, postgresql

#899 - Preserve comment lines and leading commas in SQL formatting

Issue - State: closed - Opened by satt-hri 3 months ago - 9 comments
Labels: bug

#897 - Username with @ in a DEFINER attribute throws parsing Error

Issue - State: open - Opened by jannisbaudisch 3 months ago
Labels: bug

#894 - Formatting select top 100 ....

Issue - State: closed - Opened by kadriizer 4 months ago - 5 comments
Labels: bug

#890 - Don't write a formatted file if the formatting didn't change the file

Issue - State: closed - Opened by wucke13 4 months ago - 4 comments
Labels: bug

#888 - [FORMATTING] Line break and OUTPUT for SQL server

Issue - State: open - Opened by jaredromano 4 months ago
Labels: bug

#883 - [FORMATTING] Support IDENTIFIER() syntax in snowflake sql

Issue - State: closed - Opened by willfle 5 months ago - 1 comment
Labels: bug, snowflake

#882 - [FORMATTING] Issue Title Here

Issue - State: open - Opened by gazi786 5 months ago
Labels: bug

#881 - [FORMATTING] Spark SQL table aliase includes "set" will be depart

Issue - State: closed - Opened by Dongchuan12 5 months ago - 1 comment
Labels: bug

#879 - [FORMATTING] PostgreSQL mis-detects column names as data types

Issue - State: closed - Opened by jGleitz 6 months ago - 1 comment
Labels: bug

#877 - SQLServer errors

Issue - State: open - Opened by archonic 6 months ago
Labels: bug

#872 - [FORMATTING] DuckDB - Missing keyword `IS` & `NULL` not detected as keyword

Issue - State: closed - Opened by saschat 6 months ago - 4 comments
Labels: bug

#871 - [FORMATTING] JSON operator `->>` missing for DuckDB

Issue - State: closed - Opened by saschat 6 months ago
Labels: bug, duckdb

#870 - [FORMATTING] Unusual formatting of RETURNING clause, part 2

Issue - State: closed - Opened by bconway 6 months ago - 1 comment
Labels: bug

#867 - [FORMATTING] Issue Title Here

Issue - State: open - Opened by LuciaCam 7 months ago
Labels: bug

#866 - [FORMATTING] QUALIFY for AWS Redshift

Issue - State: closed - Opened by KlingonDragon 7 months ago
Labels: bug

#865 - CREATE FUNCTION formatting issue with Transact-SQL (SQL Server 2022)

Issue - State: closed - Opened by ISILOG-ALAM 7 months ago - 2 comments
Labels: bug, transactsql

#859 - [FORMATTING] Issue Title Here

Issue - State: open - Opened by duwanqiebi 8 months ago
Labels: bug

#858 - [FORMATTING] Support `\i 'path/file.sql'`

Issue - State: closed - Opened by tordans 8 months ago - 4 comments
Labels: bug

#854 - this undefined in RollUp

Issue - State: closed - Opened by cintaccs 8 months ago - 10 comments
Labels: bug

#848 - Unexpected EOF token

Issue - State: closed - Opened by punkpeye 9 months ago - 1 comment
Labels: bug

#847 - [FORMATTING] linesBetweenQueries not working when queries not separated by semi-colon

Issue - State: closed - Opened by fakedestinyck 9 months ago - 1 comment
Labels: bug

#845 - dist/cjs/index.cjs not found in the dist package

Issue - State: closed - Opened by hakatashi 9 months ago - 6 comments
Labels: bug

#841 - [FORMATTING] Window functions and expressionWidth

Issue - State: closed - Opened by Brandon-Schur 9 months ago - 1 comment
Labels: bug

#840 - Memory issue with large queries

Issue - State: open - Opened by alex-statsig 9 months ago - 1 comment
Labels: bug

#839 - [FORMATTING] PL/SQL END LOOP; put on newline

Issue - State: closed - Opened by ivandimitrov8080 9 months ago - 1 comment
Labels: bug, pl/sql

#838 - Unable to format SQL: Error: Parse error at token: BETWEEN

Issue - State: closed - Opened by ot-roman-molchanov 9 months ago - 1 comment
Labels: bug

#835 - [FORMATTING] Formatter15.4.11 inserts space in between # operator in mysql dialect

Issue - State: closed - Opened by laoli1968 9 months ago - 2 comments
Labels: bug

#834 - supportsConstraints test function does not correctly test referential actions

Issue - State: closed - Opened by LunaPresent 9 months ago - 1 comment
Labels: bug

#830 - SQL with $ inside the column name are not parsed and formatted.

Issue - State: closed - Opened by traycho 10 months ago - 1 comment
Labels: bug

#826 - [FORMATTING] cross join

Issue - State: closed - Opened by yinhui198456 10 months ago - 2 comments
Labels: bug

#825 - [FORMATTING] MINUS operator not handled in PLSQL dialect

Issue - State: closed - Opened by srtucker 11 months ago - 1 comment
Labels: bug

#824 - [FORMATTING] Formatting Issue in SQL Query Output with select keyword

Issue - State: closed - Opened by ankitgupta8888 11 months ago - 1 comment
Labels: bug

#822 - [PARSING] plsql varaibles with $ and #

Issue - State: closed - Opened by sosoba 11 months ago - 5 comments
Labels: bug

#819 - [FORMATTING] tsql: odbc keywords and datatypes as column identifiers are incorrectly formatted

Issue - State: closed - Opened by rmja 11 months ago - 2 comments
Labels: bug

#818 - [FORMATTING] plsql - keyword "rows"

Issue - State: open - Opened by sosoba 11 months ago
Labels: bug

#815 - [FORMATTING] Tabulate Alias breaks quoted aliases

Issue - State: closed - Opened by theking2 12 months ago - 1 comment
Labels: bug

#814 - [FORMATTING] tsql: GO should always be on a separate line

Issue - State: closed - Opened by rmja 12 months ago
Labels: bug

#813 - [FORMATTING] `REPLACE` Not Properly Uppercased in PostgreSQL Dialect

Issue - State: closed - Opened by etzelc 12 months ago - 2 comments
Labels: bug

#812 - [FORMATTING] tsql: Some schema or column names follow keywordCase

Issue - State: closed - Opened by rmja 12 months ago - 2 comments
Labels: bug

#811 - [FORMATTING] tsql: char datatype is emitted in uppercase when functionCase is specified as upper

Issue - State: closed - Opened by rmja 12 months ago - 1 comment
Labels: bug

#810 - Using $action in tsql merge causes crash

Issue - State: closed - Opened by rmja 12 months ago - 3 comments
Labels: bug

#809 - [FORMATTING] a few cases of unexpected identifierCase "lower" behavior

Issue - State: closed - Opened by gajus 12 months ago - 3 comments
Labels: bug

#807 - [FORMATTING] Spaceship operator (`<=>`) adding unwanted whitespace

Issue - State: open - Opened by nerixim 12 months ago
Labels: bug

#805 - formatting issue fo sql server

Issue - State: closed - Opened by mahdiyar021 about 1 year ago - 2 comments
Labels: bug

#801 - [FORMATTING] Reserved words can't be used as aliases

Issue - State: open - Opened by pgiraud about 1 year ago
Labels: bug

#797 - Formatter doesn't recognize Hive CREATE TABLE modifiers

Issue - State: open - Opened by melin about 1 year ago - 3 comments
Labels: bug, hive

#793 - [FORMATTING] Formatter inserts space in between @ operator in mariadb dialect

Issue - State: open - Opened by mariadb-ThienLy about 1 year ago - 1 comment
Labels: bug, mysql/mariadb

#789 - [FORMATTING] Missing support for Snowflake lambda operator

Issue - State: open - Opened by datarttu about 1 year ago
Labels: bug

#787 - `.sql-formatter.json` being ignored by CLI

Issue - State: closed - Opened by musjj about 1 year ago
Labels: bug

#786 - [FORMATTING] Formatter adding space for sqlc macros

Issue - State: closed - Opened by B4Dmonkey about 1 year ago - 1 comment
Labels: bug

#783 - [FORMATTING] sqlite UPSERT formatting

Issue - State: closed - Opened by ulikunitz about 1 year ago - 1 comment
Labels: bug

#778 - Snowflake Colon (:) Prefix Causes Error

Issue - State: closed - Opened by chiefupstart about 1 year ago - 1 comment
Labels: bug

#777 - [FORMATTING] Issue Title Here

Issue - State: open - Opened by Mooli88 over 1 year ago
Labels: bug

#773 - db2i formatting does not work with JSON* functions

Issue - State: open - Opened by cmh716 over 1 year ago
Labels: bug

#771 - [FORMATTING] Column called "type" in Snowflake

Issue - State: closed - Opened by greg-finley over 1 year ago - 1 comment
Labels: bug

#770 - [FORMATTING] Full text search distance formats `<->` incorrectly

Issue - State: closed - Opened by huypham50 over 1 year ago - 1 comment
Labels: bug

#769 - [FORMATTING] Quotation marks incomplete, formatting error

Issue - State: closed - Opened by dorahappy over 1 year ago - 1 comment
Labels: bug

#767 - [FORMATTING] problem with line like 'ORDER BY t1.DATE DESC, t1.[%title%] ASC'

Issue - State: closed - Opened by Aliaksandr3by over 1 year ago - 8 comments
Labels: bug

#762 - [FORMATTING] BigQuery: Doesn't handle escaped quotes

Issue - State: open - Opened by akshetpandey over 1 year ago
Labels: bug

#761 - [FORMATTING] Missing space after colon in `JSON_OBJECT(key: value)`

Issue - State: open - Opened by felixfbecker over 1 year ago
Labels: bug

#757 - [FORMATTING] MariaDB function call parenthesis spacing results in invalid MariaDB SQL

Issue - State: closed - Opened by theking2 over 1 year ago - 4 comments
Labels: bug

#756 - "Prettier-SQL.tabulateAlias": true ignores back ticks

Issue - State: closed - Opened by theking2 over 1 year ago - 1 comment
Labels: bug

#754 - Supplying empty regex crashes browser

Issue - State: closed - Opened by JulianVGit over 1 year ago - 2 comments
Labels: bug

#752 - [FORMATTING] Error when formatting Clickhouse SQL with Array column type

Issue - State: closed - Opened by eryx over 1 year ago - 1 comment
Labels: bug

#746 - Unable to format SQL

Issue - State: open - Opened by liyuanhao6 over 1 year ago
Labels: bug

#745 - [FORMATTING] Will not format #Temp Tables

Issue - State: open - Opened by bharris6avera over 1 year ago
Labels: bug

#744 - [FORMATTING] Formatter doesn't like the ~ in SQL statement

Issue - State: closed - Opened by zjpersc over 1 year ago - 1 comment
Labels: bug

#743 - [FORMATTING] Issue Title Here

Issue - State: closed - Opened by Altonymous over 1 year ago - 1 comment
Labels: bug

#742 - [FORMATTING] array type

Issue - State: closed - Opened by leelhn2345 over 1 year ago - 1 comment
Labels: bug

#741 - [FORMATTING] Oracle pl/sql, assignment in case block

Issue - State: open - Opened by hmmftg over 1 year ago
Labels: bug

#740 - [FORMATTING] column name "match" is converted to uppercase.

Issue - State: open - Opened by krishnagogada over 1 year ago
Labels: bug

#739 - Formatting Error with Temporary Functions

Issue - State: closed - Opened by dmill166 over 1 year ago - 2 comments
Labels: bug

#736 - Canot format document when '#' character is Found

Issue - State: closed - Opened by pgmlloyd over 1 year ago - 1 comment
Labels: bug

#733 - [FORMATTING] psycopg2 params broken up by formatter

Issue - State: closed - Opened by ibrokemypie over 1 year ago - 1 comment
Labels: bug

#732 - Table name or alias "call" misinterpreted by formatter

Issue - State: open - Opened by ipus1 over 1 year ago
Labels: bug

#729 - mysql: create procedure LOOP bug

Issue - State: open - Opened by zundaren over 1 year ago
Labels: bug

#726 - [FORMATTING] Column named `text` is converted to upper case

Issue - State: closed - Opened by jgeurts over 1 year ago - 1 comment
Labels: bug

#718 - [FORMATTING] `DEFAULT VALUES` not properly supported in INSERT statement

Issue - State: closed - Opened by jonatanschroeder almost 2 years ago - 3 comments
Labels: bug

#717 - Unable to use "#" in table names

Issue - State: closed - Opened by progton1 almost 2 years ago - 2 comments
Labels: bug

#715 - Cannot read properties of undefined (reading 'nestedBlockComments')

Issue - State: closed - Opened by MrSwitch almost 2 years ago - 3 comments
Labels: bug

#712 - Unable to configure to use the configuration setting for placeholders

Issue - State: closed - Opened by mellasmpa almost 2 years ago - 3 comments
Labels: bug