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

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 IssuesProTip!
Press the /
key to activate the search input again and adjust your query.
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 IssuesProTip!
Restrict your search to the title by using the in:title qualifier.