GitHub / sqlfluff/sqlfluff issues and pull requests
#7015 - Oracle: Add `RELIES_ON` and `POLYMORPHIC` keywords
Pull Request -
State: closed - Opened by keraion 11 days ago
- 1 comment
#7013 - Add a conventional rule that enforces using IF (NOT) EXISTS
Pull Request -
State: open - Opened by danilax86 12 days ago
#7003 - Oracle - Internal Error with RESULT_CACHE
Issue -
State: closed - Opened by netsgnut 15 days ago
Labels: bug, oracle
#6983 - Add support for table option in ALTER TABLE statements for MySQL/MariaDB
Issue -
State: open - Opened by pprkut 26 days ago
Labels: bug, mysql, mariadb
#6982 - ST05: Support dialects that use WITH, INSERT, SELECT order
Pull Request -
State: closed - Opened by keraion 26 days ago
- 1 comment
#6981 - CV12 and AL05: Prevent AL05 from deleting rewritten CV12 references
Pull Request -
State: closed - Opened by keraion 26 days ago
- 1 comment
#6980 - MariaDB GENERATED unparsable
Issue -
State: open - Opened by alexhicks 27 days ago
- 1 comment
Labels: bug, mariadb
#6979 - Add Apache Doris SQL dialect support to SQLFluff
Pull Request -
State: open - Opened by morningman 28 days ago
- 2 comments
#6978 - Apache Doris Dialect Support
Issue -
State: open - Opened by morningman 28 days ago
Labels: enhancement, new dialect
#6977 - DuckDB: add support for additional star expressions
Pull Request -
State: closed - Opened by keraion 29 days ago
- 1 comment
#6976 - CLI: Add support for the `NO_COLOR` environment variable
Pull Request -
State: closed - Opened by keraion 29 days ago
- 1 comment
#6975 - Databricks dialect does not properly support `CLUSTER BY` syntax
Issue -
State: open - Opened by krajewf about 1 month ago
Labels: bug, databricks
#6974 - Snowflake "on_error" parameter not supported
Issue -
State: open - Opened by AM-I-Human about 1 month ago
Labels: bug, snowflake
#6973 - Adds support for `json_object` syntax in Oracle.
Pull Request -
State: closed - Opened by joaostorrer about 1 month ago
- 1 comment
#6972 - ANSI: Support CTEs in Merge
Pull Request -
State: closed - Opened by NormallyGaussian about 1 month ago
- 1 comment
#6971 - Duckdb: Support new star expressions
Issue -
State: closed - Opened by keraion about 1 month ago
Labels: bug, duckdb
#6970 - SQLite: Make `ACTION` a non-reserved keyword
Pull Request -
State: closed - Opened by keraion about 1 month ago
- 1 comment
#6969 - Using --check in `sqlfluff fix` throws an OSError
Issue -
State: closed - Opened by tiffanygwilson about 1 month ago
- 5 comments
Labels: bug
#6968 - Documentation: show all possible values for configuration and examples
Issue -
State: open - Opened by tiffanygwilson about 1 month ago
Labels: documentation
#6967 - Snowflake: fix collate grammar with aliases
Pull Request -
State: closed - Opened by keraion about 1 month ago
- 1 comment
#6966 - Oracle unable to parse JSON_OBJECT using colon separator
Issue -
State: closed - Opened by skykasko about 1 month ago
Labels: bug, oracle
#6965 - SQLite parse error for triggers with INSERTs
Issue -
State: closed - Opened by Hendrikto about 1 month ago
- 3 comments
Labels: bug, sqlite
#6964 - Upgrade OverlapsClauseSegment
Pull Request -
State: closed - Opened by kkozhakin about 1 month ago
- 1 comment
#6963 - Upgrade OverlapsClauseSegment
Issue -
State: closed - Opened by kkozhakin about 1 month ago
Labels: bug
#6962 - Difference between `line_position` and `keyword_line_position`
Issue -
State: open - Opened by mudravrik about 1 month ago
Labels: documentation
#6961 - Cast is not null expression
Issue -
State: open - Opened by kkozhakin about 1 month ago
Labels: bug
#6960 - New rule to enforce explicit use of schema #3222
Pull Request -
State: open - Opened by nomq1 about 1 month ago
- 2 comments
#6959 - Different LT01 fixes for MAC vs WSL (Ubuntu)
Issue -
State: closed - Opened by cooper-grill about 1 month ago
- 1 comment
Labels: bug
#6958 - Fix ST09 rule not detecting violations in Jinja templated SQL
Pull Request -
State: closed - Opened by kang8 about 1 month ago
- 1 comment
#6957 - Tsql add alter constraint if exists
Pull Request -
State: closed - Opened by IngerMathilde about 1 month ago
- 1 comment
#6956 - Extend tsql `ALTER TABLE` WITH `DROP CONSTRAINT IF EXISTS` option
Issue -
State: closed - Opened by IngerMathilde about 1 month ago
Labels: enhancement, t-sql
#6955 - MariaDB: Allow CTEs in `INSERT` statements
Pull Request -
State: closed - Opened by keraion about 1 month ago
- 1 comment
#6954 - AliasInfo: handle quotes and special aliases in rules
Pull Request -
State: closed - Opened by keraion about 1 month ago
- 1 comment
#6953 - TSQL: Rework the execute statement block to latest specs
Pull Request -
State: open - Opened by peterbud about 1 month ago
- 1 comment
#6952 - TSQL: add support for extended Unicode characters in identifiers
Pull Request -
State: closed - Opened by peterbud about 1 month ago
- 1 comment
#6951 - API: prioritize configuration file's dialect
Pull Request -
State: closed - Opened by keraion about 1 month ago
- 1 comment
#6950 - Fixes for ST05 not applied, as it would result in an unparsable file. Please report this as a bug with a minimal query which demonstrates this warning.
Issue -
State: closed - Opened by cooper-grill about 1 month ago
Labels: bug
#6949 - Adds support for <=> operator in MySQL using Python API
Issue -
State: closed - Opened by lujie19930803 about 1 month ago
- 1 comment
Labels: bug, mysql
#6948 - TSQL: Add support for CREATE TABLE GRAPH statements
Pull Request -
State: closed - Opened by peterbud about 1 month ago
- 1 comment
#6947 - Redshift: doesn't parse encoding in add column statement
Issue -
State: open - Opened by ivan-ishchanka-c about 1 month ago
Labels: bug, redshift
#6946 - Rule CV12 deletes alias from table where columns are absent from the select statement
Issue -
State: closed - Opened by AndyBrownEJ about 1 month ago
- 1 comment
Labels: bug, fix corrupts sql
#6945 - False positives from References checks with JSON_TABLE statements
Issue -
State: open - Opened by pprkut about 1 month ago
Labels: bug
#6944 - SQLite unparsable FTS5 `content` option
Issue -
State: open - Opened by rvnkcode about 1 month ago
Labels: bug, sqlite
#6943 - False positive lint errors for rule RF02 in ORDER BY clause - Snowflake and PostgreSQL dialects
Issue -
State: open - Opened by anthian about 1 month ago
- 2 comments
Labels: bug, postgres, snowflake
#6942 - Support for monorepo with multiple dbt projects
Issue -
State: open - Opened by devidb00 about 2 months ago
Labels: enhancement
#6941 - Adds support for `RETURNING INTO` clause in `INSERT`, `UPDATE`, `DELETE` and `MERGE` statements in Oracle.
Pull Request -
State: closed - Opened by joaostorrer about 2 months ago
- 1 comment
#6940 - Prep version 3.4.1
Pull Request -
State: closed - Opened by github-actions[bot] about 2 months ago
- 1 comment
Labels: release, skip-changelog
#6939 - dbt Cloud IDE SQLFluff linting fails on generic tests with "Unable to find compile node in results" TMP error
Issue -
State: open - Opened by Tonayya about 2 months ago
Labels: bug
#6938 - CI: update coverage paths for C:\ directory
Pull Request -
State: closed - Opened by keraion about 2 months ago
- 1 comment
#6937 - TSQL: add support for `SECURITY POLICY` (`CREATE, ALTER, DROP`)
Pull Request -
State: closed - Opened by keen85 about 2 months ago
- 5 comments
#6936 - feat(redshift): add support for ALTER TABLE SET LOCATION syntax
Pull Request -
State: closed - Opened by studansp about 2 months ago
- 1 comment
#6935 - TSQL: fix `USER` (bare function) unparsable
Pull Request -
State: closed - Opened by keen85 about 2 months ago
- 1 comment
#6934 - TSQL: `CREATE SECURITY POLICY` unparsable
Issue -
State: closed - Opened by keen85 about 2 months ago
Labels: bug, t-sql
#6933 - TSQL: `SELECT USER;` (security function) unparsable
Issue -
State: closed - Opened by keen85 about 2 months ago
Labels: bug, t-sql
#6932 - PL/SQL-ORACLE: RETURNING ... INTO statement causes "Found unparsable section" error in package body
Issue -
State: closed - Opened by Manchov about 2 months ago
Labels: bug, oracle
#6931 - Support for Snowflake NETWORK RULE DDL parsing
Issue -
State: open - Opened by rmundy about 2 months ago
Labels: enhancement, snowflake
#6930 - Adds support for trigger predicates in `IF` statements and `:NEW.` variables in assignment statements in Oracle.
Pull Request -
State: closed - Opened by joaostorrer about 2 months ago
- 2 comments
#6929 - Adds support for `<=>` operator in MySQL.
Pull Request -
State: closed - Opened by joaostorrer about 2 months ago
- 2 comments
#6928 - Trino: Support for INSERT, COMMIT, ROLLBACK and SET SESSION statements
Pull Request -
State: closed - Opened by ykicisk about 2 months ago
- 7 comments
#6927 - Trino RuntimeError error on a simple INSERT INTO
Issue -
State: closed - Opened by skonop about 2 months ago
Labels: bug, trino
#6926 - Cache state of sql files to avoid re-linting and re-formatting
Issue -
State: open - Opened by reteps about 2 months ago
Labels: enhancement
#6925 - Bracketed: Check Gap matching.
Issue -
State: open - Opened by alanmcruickshank about 2 months ago
#6924 - Duckdb: Support double equals comparison
Pull Request -
State: closed - Opened by keraion about 2 months ago
- 1 comment
#6923 - RF01: Fix quoted object references with dots
Pull Request -
State: closed - Opened by keraion about 2 months ago
- 1 comment
#6922 - Improves support for `SET` statements in MySQL.
Pull Request -
State: closed - Opened by joaostorrer about 2 months ago
- 1 comment
#6921 - AL09 considers "COUNTRY" and "Country" as the same in Snowflake
Issue -
State: closed - Opened by abrahamzetz about 2 months ago
- 1 comment
Labels: bug, snowflake
#6920 - Fix mypy 1.16 issues
Pull Request -
State: closed - Opened by keraion about 2 months ago
- 1 comment
#6919 - Databricks - STRUCT function alias is identified as column reference
Issue -
State: open - Opened by PhilippLange about 2 months ago
Labels: bug, databricks
#6918 - AL09 misses some redundant aliases
Issue -
State: open - Opened by dr-1 about 2 months ago
Labels: bug
#6917 - Snowflake - COLLATE infix notation results in parser error
Issue -
State: closed - Opened by lester-swo about 2 months ago
- 2 comments
Labels: bug, snowflake
#6916 - Oracle - Unparsable Trigger with Conditionals and Assignments
Issue -
State: closed - Opened by netsgnut about 2 months ago
Labels: bug, oracle
#6915 - Can lint trigger with wrong name
Issue -
State: open - Opened by WingDust 2 months ago
Labels: enhancement
#6914 - MySQL: ALTER TABLE T ALTER C DROP DEFAULT causes parsing error
Issue -
State: open - Opened by mwrynn-ias 2 months ago
- 1 comment
Labels: bug, mysql
#6913 - SQLFluff does not support Spark SQL struct field access
Issue -
State: open - Opened by maoxingda 2 months ago
Labels: bug
#6912 - Clickhouse dialect: Select modifier "APPLY" not supported
Issue -
State: open - Opened by AntoineSebert 2 months ago
Labels: bug, clickhouse
#6911 - Redshift DataShares
Issue -
State: open - Opened by manmartgarc 2 months ago
- 1 comment
Labels: enhancement, redshift
#6910 - Databricks: Prevent parsing error when reading from a streaming file
Pull Request -
State: closed - Opened by cpwithers 2 months ago
- 1 comment
#6909 - LT14: Add exclusion configuration option
Pull Request -
State: closed - Opened by keraion 2 months ago
- 2 comments
#6908 - clickhouse: add support for dictionaries
Pull Request -
State: open - Opened by LSturtew 2 months ago
- 1 comment
#6907 - mysql: not support <=>
Issue -
State: closed - Opened by lujie19930803 2 months ago
Labels: bug, mysql
#6906 - mysql SET global and session not supported
Issue -
State: closed - Opened by willm 2 months ago
Labels: bug, mysql
#6905 - Duckdb double equals: unparsable section: "CASE | WHEN
Issue -
State: closed - Opened by ChristianRothQC 2 months ago
Labels: bug, duckdb
#6904 - SQLFluff L028 incorrectly adds table qualification to PostgreSQL JSON operators (->>)
Issue -
State: open - Opened by tyson-buzza-raptor 2 months ago
Labels: bug, postgres
#6903 - Postgres: Add support for session authorization
Pull Request -
State: closed - Opened by pierrand 2 months ago
- 1 comment
#6902 - Misleading output from `sqlfluff parse` in Postgresql dialect when using a reserved word as a table name
Issue -
State: closed - Opened by gregglind 2 months ago
Labels: bug, postgres
#6901 - Redshift: Fix documentation link
Pull Request -
State: closed - Opened by joaonunesk 2 months ago
- 1 comment
#6900 - CLI: Read inline configurations when using `--stdin-filename`
Pull Request -
State: closed - Opened by keraion 2 months ago
- 1 comment
#6899 - Redshift: Add support for Kafka external schema
Pull Request -
State: closed - Opened by pierrand 2 months ago
- 1 comment
#6898 - CV12: fix assertion on bracketed join
Pull Request -
State: closed - Opened by keraion 2 months ago
- 1 comment
#6897 - Spark: CTE in Merge Into
Issue -
State: closed - Opened by NormallyGaussian 2 months ago
Labels: bug
#6896 - Adds support for column list after table name in COLLECT STATISTICS
Pull Request -
State: closed - Opened by thomascjohnson 2 months ago
- 2 comments
#6895 - Adds support for Teradata CREATE TABLE with MAP option
Pull Request -
State: closed - Opened by thomascjohnson 2 months ago
- 1 comment
#6894 - Snowflake: support for structured object type
Issue -
State: open - Opened by sophieml 2 months ago
Labels: bug, snowflake
#6893 - Unparsable doesnt show proper unparseable location
Issue -
State: open - Opened by jpmorris 2 months ago
Labels: bug
#6892 - Pin to Click < 8.3.0
Pull Request -
State: closed - Opened by wyardley 2 months ago
- 4 comments
#6891 - Databricks SQL specifics should be moved out of SparkSQL parsing
Issue -
State: open - Opened by TheCleric 2 months ago
Labels: enhancement, sparksql, databricks
#6890 - Fix RawFileSlice idx and tags in lexer_test
Pull Request -
State: closed - Opened by keraion 2 months ago
- 1 comment
#6889 - cross-project aware `ref` macro
Pull Request -
State: open - Opened by neozenith 3 months ago
- 1 comment
#6888 - 'sqlfluff.cli.commands' is not installed error when using diff_quality
Issue -
State: open - Opened by KaneMorgan 3 months ago
- 1 comment
Labels: bug
#6887 - Adds support for variadic declarations in Postgres.
Pull Request -
State: closed - Opened by joaostorrer 3 months ago
- 1 comment