goccy/go-zetasqlite issues and pull requests

#226 - Implement CREATE SCHEMA

Pull Request - State: open - Opened by nightscape about 1 month ago

#225 - Fix return type for INT64 and FLOAT64 functions

Pull Request - State: open - Opened by earada about 2 months ago

#224 - Support DATE_TRUNC with HOUR granularity

Issue - State: open - Opened by anowinski-equinix 3 months ago

#223 - Fixing MERGE to use named paths in table names

Pull Request - State: open - Opened by bony2023 4 months ago - 8 comments

#222 - Making MERGE more robust in handling edge-cases

Pull Request - State: open - Opened by bony2023 4 months ago - 12 comments

#221 - Support table-valued functions.

Issue - State: open - Opened by thalissonfelipe 5 months ago

#220 - zetasqlite.TimeFromTimestampValue doesn't work well with Time Zones data in the incoming string

Issue - State: open - Opened by iolalla 6 months ago

#219 - [Timestamp] Fix TIMESTAMP_TRUNC for SECONDS and MILLISECONDS

Pull Request - State: closed - Opened by Zherdev 7 months ago - 2 comments

#218 - TIMESTAMP_TRUNC gives incorrect results for SECOND and MILLISECOND

Issue - State: closed - Opened by Zherdev 7 months ago - 1 comment

#217 - TRIM only trims spaces by default, not all whitespace

Issue - State: open - Opened by ethan-oro 7 months ago

#216 - Fix control flow execution of conditional functions `IF()`, `IFNULL()`

Pull Request - State: closed - Opened by ohaibbq 7 months ago

#215 - `IF()` statements are not rewritten to use proper control flow

Issue - State: closed - Opened by ohaibbq 7 months ago

#214 - Support create table as select with column list

Pull Request - State: closed - Opened by ohaibbq 8 months ago - 1 comment

#213 - Add mechanism to register query parameters with the analyzer

Pull Request - State: open - Opened by ohaibbq 8 months ago - 2 comments

#212 - [String Functions]: EDIT_DISTANCE

Issue - State: open - Opened by anonimitoraf 9 months ago

#211 - Support `CREATE TABLE` column `DEFAULT` value expressions

Pull Request - State: open - Opened by ohaibbq 9 months ago

#210 - Consider using materialized views for common table expressions

Issue - State: open - Opened by ohaibbq 10 months ago

#209 - Support `CONTAINS_SUBSTR` function

Pull Request - State: open - Opened by ohaibbq 10 months ago

#208 - Use `WITHOUT ROWID` table clustering for tables

Pull Request - State: open - Opened by ohaibbq 10 months ago

#208 - Use `WITHOUT ROWID` table clustering for tables

Pull Request - State: open - Opened by ohaibbq 10 months ago

#207 - Allow users of the driver to disable query formatting; support named parameters for `QueryStmt`, `DMLStmt`

Pull Request - State: open - Opened by ohaibbq 10 months ago

#206 - Implement unary minus operator

Pull Request - State: open - Opened by totem3 10 months ago

#206 - Implement unary minus operator

Pull Request - State: open - Opened by totem3 10 months ago

#205 - Fix `QueryStmtNode` output; wrap union statements in parentheses

Pull Request - State: closed - Opened by ohaibbq 10 months ago

#204 - [Date] [Datetime] [Timestamp] Handle `QUARTER`, `WEEK(DAY)`, `ISOWEEK`

Pull Request - State: closed - Opened by ohaibbq 10 months ago - 3 comments

#204 - [Date] [Datetime] [Timestamp] Handle `QUARTER`, `WEEK(DAY)`, `ISOWEEK`

Pull Request - State: closed - Opened by ohaibbq 10 months ago - 3 comments

#203 - Support `sql.Driver`'s `PrepareContext` interface

Pull Request - State: closed - Opened by ohaibbq 10 months ago - 2 comments

#202 - Full range of dates not supported

Issue - State: closed - Opened by ohaibbq 10 months ago

#202 - Full range of dates not supported

Issue - State: closed - Opened by ohaibbq 10 months ago

#201 - Enable `QUALIFY` without `GROUP BY` / `WHERE` / `HAVING`

Pull Request - State: closed - Opened by ohaibbq 10 months ago - 3 comments

#200 - Missing window function implementation for `LOGICAL_OR` and `LOGICAL_AND`

Issue - State: open - Opened by ohaibbq 10 months ago

#199 - Support `UNNEST WITH OFFSET`

Pull Request - State: closed - Opened by ohaibbq 10 months ago - 4 comments

#199 - Support `UNNEST WITH OFFSET`

Pull Request - State: closed - Opened by ohaibbq 10 months ago - 4 comments

#198 - Support `PIVOT` / `UNPIVOT`

Pull Request - State: closed - Opened by ohaibbq 10 months ago - 1 comment

#198 - Support `PIVOT` / `UNPIVOT`

Pull Request - State: closed - Opened by ohaibbq 10 months ago - 1 comment

#197 - Implement dayOfYearParser

Pull Request - State: closed - Opened by recidinick 10 months ago - 2 comments

#197 - Implement dayOfYearParser

Pull Request - State: closed - Opened by recidinick 10 months ago - 2 comments

#196 - Implement dayOfYearParser

Issue - State: closed - Opened by recidinick 10 months ago

#196 - Implement dayOfYearParser

Issue - State: closed - Opened by recidinick 10 months ago

#195 - Unable to use namespaced functions

Issue - State: closed - Opened by ohaibbq 10 months ago - 1 comment

#194 - `DATE_DIFF(..., ..., WEEK)` returns incorrect value for multi-year durations

Issue - State: closed - Opened by ohaibbq 10 months ago

#193 - `WEEK(<WEEKDAY>)` unsupported for `LAST_DAY()`, `EXTRACT()`, `DATE_DIFF()`, `DATE_TRUNC()`

Issue - State: closed - Opened by ohaibbq 10 months ago

#193 - `WEEK(<WEEKDAY>)` unsupported for `LAST_DAY()`, `EXTRACT()`, `DATE_DIFF()`, `DATE_TRUNC()`

Issue - State: closed - Opened by ohaibbq 10 months ago

#192 - `SELECT 1 AS x UNION ALL (WITH toks AS (...) SELECT toks.x)` raises syntax error

Issue - State: closed - Opened by ohaibbq 10 months ago

#192 - `SELECT 1 AS x UNION ALL (WITH toks AS (...) SELECT toks.x)` raises syntax error

Issue - State: closed - Opened by ohaibbq 10 months ago

#191 - Incorrect column count used for aliased columns

Issue - State: closed - Opened by ohaibbq 10 months ago

#190 - `PIVOT` / `UNPIVOT` unsupported

Issue - State: closed - Opened by ohaibbq 10 months ago

#190 - `PIVOT` / `UNPIVOT` unsupported

Issue - State: closed - Opened by ohaibbq 10 months ago

#189 - Update linter

Pull Request - State: closed - Opened by goccy 10 months ago - 1 comment

#188 - `SELECT .. FROM UNNEST(...) WITH OFFSET offset` unsupported

Issue - State: closed - Opened by ohaibbq 10 months ago

#188 - `SELECT .. FROM UNNEST(...) WITH OFFSET offset` unsupported

Issue - State: closed - Opened by ohaibbq 10 months ago

#187 - Dont crash on nil in LOGICAL_OR and LOGICAL_AND

Pull Request - State: closed - Opened by ohaibbq 11 months ago - 2 comments

#186 - `LOGICAL_OR()` and `LOGICAL_AND()` crash on nil

Issue - State: closed - Opened by ohaibbq 11 months ago

#185 - `LIKE()`, and `BETWEEN()` return false instead of null when left-hand side is null

Issue - State: open - Opened by ohaibbq 11 months ago

#184 - [String] Do not cast integer/float-like strings to datetime

Pull Request - State: closed - Opened by ohaibbq 11 months ago - 4 comments

#183 - [String] Use direct string value from ZetaSQL

Pull Request - State: closed - Opened by ohaibbq 11 months ago - 2 comments

#182 - Use value comparators for `LEAST`, `GREATEST`, `BETWEEN`

Pull Request - State: closed - Opened by ohaibbq 11 months ago - 2 comments

#181 - [Array] Handle null ARRAY fields

Pull Request - State: closed - Opened by ohaibbq 11 months ago - 2 comments

#180 - [Array] Support `LEFT OUTER` / `INNER` JOIN modes

Pull Request - State: closed - Opened by ohaibbq 11 months ago - 1 comment

#179 - Cannot `UNNEST` null array fields

Issue - State: closed - Opened by ohaibbq 11 months ago

#178 - Regular expressions are improperly parsed

Issue - State: closed - Opened by ohaibbq 11 months ago

#177 - `LEAST()`, `GREATEST()`, `BETWEEN()` do not work for string values

Issue - State: closed - Opened by ohaibbq 11 months ago

#177 - `LEAST()`, `GREATEST()`, `BETWEEN()` do not work for string values

Issue - State: closed - Opened by ohaibbq 11 months ago

#176 - `ArrayScanNode` formatting does not support all join types

Issue - State: closed - Opened by ohaibbq 11 months ago

#175 - `CAST(string AS DATETIME)` incorrectly parses integer strings as date

Issue - State: closed - Opened by ohaibbq 11 months ago - 1 comment

#174 - [Aggregate] Correctly handle ordering multiple fields; don't crash on nil

Pull Request - State: closed - Opened by ohaibbq 11 months ago - 2 comments
Labels: reviewed

#173 - Fix `IN()` operator return when left-hand side is null

Pull Request - State: closed - Opened by ohaibbq 11 months ago - 1 comment

#172 - `IN()` operator returns false when left-hand value is null

Issue - State: closed - Opened by ohaibbq 11 months ago

#171 - [Driver] Fix prepared insert statements raising `not enough query arguments`

Pull Request - State: closed - Opened by ohaibbq 11 months ago

#170 - `INSERT` statements cannot be prepared with `sql.DB.Prepare()`

Issue - State: closed - Opened by ohaibbq 11 months ago

#169 - [Windowing] Rewrite window function implementation to use real SQLite windows

Pull Request - State: open - Opened by ohaibbq 11 months ago - 4 comments
Labels: reviewed

#168 - [Aggregates] [Windowing] `COVAR_POP` uses `COVAR_SAMP` implementation

Issue - State: open - Opened by ohaibbq 11 months ago

#167 - [Dates] Improve time parser's handling of whitespace

Issue - State: closed - Opened by ohaibbq 12 months ago

#166 - [Date] Implement `%p`, improve token composition, fix leading-space parsers/formatters, improve error messages, slurp whitespace

Pull Request - State: closed - Opened by ohaibbq 12 months ago - 2 comments
Labels: reviewed

#165 - [Date] Dates with single digit preceded by space cannot be parsed

Issue - State: closed - Opened by ohaibbq 12 months ago

#164 - [Functions] Fix NULLIF panic on null

Pull Request - State: closed - Opened by ohaibbq 12 months ago - 1 comment

#163 - `NULLIF` panics when `expr` is null

Issue - State: closed - Opened by ohaibbq 12 months ago

#162 - [Windowing] [Formatter] Reset format context in-between analytic function groups

Pull Request - State: closed - Opened by ohaibbq 12 months ago - 1 comment
Labels: reviewed

#161 - [Windowing] Complex queries utilizing window functions become too slow to reasonably execute

Issue - State: open - Opened by ohaibbq 12 months ago - 1 comment

#160 - [Windowing] [Formatter] Analytic function groups cross-contaminate

Issue - State: closed - Opened by ohaibbq 12 months ago

#159 - [String] Cast to INT64 should use base-10 parsing

Pull Request - State: closed - Opened by ohaibbq 12 months ago - 1 comment

#159 - [String] Cast to INT64 should use base-10 parsing

Pull Request - State: closed - Opened by ohaibbq 12 months ago - 1 comment

#158 - [Int64] Cannot cast strings with leading zeros to INT64

Issue - State: closed - Opened by ohaibbq 12 months ago

#158 - [Int64] Cannot cast strings with leading zeros to INT64

Issue - State: closed - Opened by ohaibbq 12 months ago

#157 - [Filter] Fix syntax error that occurred for some queries using subselects or QUALIFY

Pull Request - State: closed - Opened by ohaibbq 12 months ago - 2 comments
Labels: reviewed

#156 - [String] `LIKE` properly escapes regexp-characters

Pull Request - State: closed - Opened by ohaibbq 12 months ago - 1 comment

#155 - [Array] Fix ordinal boundary indexing

Pull Request - State: closed - Opened by ohaibbq 12 months ago

#155 - [Array] Fix ordinal boundary indexing

Pull Request - State: closed - Opened by ohaibbq 12 months ago

#154 - [Aggregate] Properly return `nil` for `STRING_AGG` when called with `null` or 0-length array

Pull Request - State: closed - Opened by ohaibbq 12 months ago

#154 - [Aggregate] Properly return `nil` for `STRING_AGG` when called with `null` or 0-length array

Pull Request - State: closed - Opened by ohaibbq 12 months ago

#153 - [sqlite] `Parse error: parser stack overflow`

Issue - State: open - Opened by ohaibbq 12 months ago - 1 comment

#152 - [Windowing] `ORDER BY .. NULLS FIRST / LAST` not implemented

Issue - State: open - Opened by ohaibbq 12 months ago - 1 comment

#151 - [Date] `%p` token not implemented

Issue - State: closed - Opened by ohaibbq 12 months ago

#150 - [Filter] `QUALIFY` clause on a `SELECT ... GROUP BY` raises syntax error

Issue - State: closed - Opened by ohaibbq 12 months ago

#149 - [Strings] `LIKE` raises an error when using an asterisk in the query text

Issue - State: closed - Opened by ohaibbq 12 months ago

#148 - [Arrays] Ordinal indexing does not properly handle last-element ordinal

Issue - State: closed - Opened by ohaibbq 12 months ago

#147 - [Formatter] Filtering sub-selects causes syntax error

Issue - State: closed - Opened by ohaibbq 12 months ago

#146 - [Aggregate] `STRING_AGG` returns `""` when aggregating `null`

Issue - State: closed - Opened by ohaibbq 12 months ago

#145 - [Aggregate] `null` `ORDER BY` elements cause crash

Issue - State: closed - Opened by ohaibbq 12 months ago

#144 - [Aggregate] `ORDER BY` gives priority to proceeding clauses

Issue - State: closed - Opened by ohaibbq 12 months ago

GitHub / goccy/go-zetasqlite issues and pull requests