Skip to content

issues Search Results · repo:tobymao/sqlglot language:Python

Filter by

2k results
 (80 ms)

2k results

intobymao/sqlglot (press backspace or delete to remove)

Thanks for all the work on this awesome project! I ran into something today when performing an ANTI where some CTEs were unnecessarily getting dropped in certain situations: from sqlglot import parse_one ...
  • themattmorris
  • 1
  • Opened 
    8 hours ago
  • #5481

Dialect: mysql Confirmed issue on latest (27.3.1) anonymous UNIQUE parses ✅ sql = CREATE TABLE `abc_def` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(100) ...
  • nathanchapman
  • Opened 
    12 hours ago
  • #5479

- Dialects: mysql and postgres at a minimum - Confirmed issue on 26.2.1 and persists after upgrading to latest 27.3.1 sql = -- Create abc_def table CREATE TABLE `abc_def` ( `id` bigint NOT ...
  • nathanchapman
  • 1
  • Opened 
    12 hours ago
  • #5478

Fully reproducible code snippet Please include a fully reproducible code snippet or the input sql, dialect, and expected output. from sqlglot import parse_one from sqlglot.optimizer.optimize_joins import ...
  • themattmorris
  • 2
  • Opened 
    yesterday
  • #5470

Issue Summary When parsing SQL with a fully qualified table in the FROM clause and no alias, the returned AST includes exp.Column nodes where .table is None, even though the table source is known. from ...
  • VatsAmanJha
  • 1
  • Opened 
    yesterday
  • #5463

snippert : import sqlglot schema = { your_data_table : { report_day : string , department : string } } raw_query = SELECT * FROM [your_data_table] ...
  • ragunandhant
  • Opened 
    2 days ago
  • #5461

the issue that optimizer changing the logic at where condition import sqlglot schema = { your_data_table : { columns : { report_day : string , department : string ...
  • ragunandhant
  • 2
  • Opened 
    2 days ago
  • #5460

Using sqlglot 26.3.8 Can not parse this operation in SQLite ATTACH DATABASE /srv/db/foo.db AS foo; Docs here: https://www.sqlite.org/lang_attach.html Reproduced like this: import sqlglot sql = ...
  • mariofox
  • 1
  • Opened 
    2 days ago
  • #5459

From the Hive DDL, add partition commands should be in the format ALTER TABLE table_name ADD [IF NOT EXISTS] PARTITION partition_spec [LOCATION location ] [, PARTITION partition_spec [LOCATION ...
  • tsamaras
  • Opened 
    2 days ago
  • #5457

#5415 changed the Postgres dialect so it generates placeholders with %s instead of ?s. However, libraries like the JDBC Postgres library expect ?s as a placeholder. I m not sure whether you d want to ...
  • jkillian
  • 1
  • Opened 
    3 days ago
  • #5453
Issue origami icon

Learn how you can use GitHub Issues to plan and track your work.

Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub Issues
ProTip! 
Press the
/
key to activate the search input again and adjust your query.
Issue origami icon

Learn how you can use GitHub Issues to plan and track your work.

Save views for sprints, backlogs, teams, or releases. Rank, sort, and filter issues to suit the occasion. The possibilities are endless.Learn more about GitHub Issues
ProTip! 
Restrict your search to the title by using the in:title qualifier.
Issue search results · GitHub