goccy go-zetasqlite issues

goccy / go-zetasqlite

A database driver library that interprets ZetaSQL queries and runs them using SQLite3

MIT License

56 stars 29 forks source link

issues

Newest

Newest Most commented Recently updated Oldest Least commented Least recently updated

Support DATE_TRUNC with HOUR granularity

#224 anowinski-equinix opened 3 weeks ago
0
Fixing MERGE to use named paths in table names

#223 bony2023 opened 2 months ago
6
Making MERGE more robust in handling edge-cases

#222 bony2023 opened 2 months ago
11
Support table-valued functions.

#221 thalissonfelipe opened 2 months ago
0
zetasqlite.TimeFromTimestampValue doesn't work well with Time Zones data in the incoming string

#220 iolalla opened 3 months ago
0
[Timestamp] Fix TIMESTAMP_TRUNC for SECONDS and MILLISECONDS

#219 Zherdev closed 4 months ago
2
TIMESTAMP_TRUNC gives incorrect results for SECOND and MILLISECOND

#218 Zherdev closed 4 months ago
1
TRIM only trims spaces by default, not all whitespace

#217 ethan-oro opened 5 months ago
0
Fix control flow execution of conditional functions `IF()`, `IFNULL()`

#216 ohaibbq closed 4 months ago
0
`IF()` statements are not rewritten to use proper control flow

#215 ohaibbq closed 4 months ago
0
Support create table as select with column list

#214 ohaibbq closed 4 months ago
1
Add mechanism to register query parameters with the analyzer

#213 ohaibbq opened 6 months ago
2
[String Functions]: EDIT_DISTANCE

#212 anonimitoraf opened 6 months ago
0
Support `CREATE TABLE` column `DEFAULT` value expressions

#211 ohaibbq opened 7 months ago
0
Consider using materialized views for common table expressions

#210 ohaibbq opened 7 months ago
0
Support `CONTAINS_SUBSTR` function

#209 ohaibbq opened 7 months ago
0
Use `WITHOUT ROWID` table clustering for tables

#208 ohaibbq opened 7 months ago
0
Allow users of the driver to disable query formatting; support named parameters for `QueryStmt`, `DMLStmt`

#207 ohaibbq opened 7 months ago
0
Implement unary minus operator

#206 totem3 opened 7 months ago
0
Fix `QueryStmtNode` output; wrap union statements in parentheses

#205 ohaibbq closed 7 months ago
0
[Date] [Datetime] [Timestamp] Handle `QUARTER`, `WEEK(DAY)`, `ISOWEEK`

#204 ohaibbq closed 7 months ago
3
Support `sql.Driver`'s `PrepareContext` interface

#203 ohaibbq closed 7 months ago
2
Full range of dates not supported

#202 ohaibbq closed 7 months ago
0
Enable `QUALIFY` without `GROUP BY` / `WHERE` / `HAVING`

#201 ohaibbq closed 7 months ago
3
Missing window function implementation for `LOGICAL_OR` and `LOGICAL_AND`

#200 ohaibbq opened 8 months ago
0
Support `UNNEST WITH OFFSET`

#199 ohaibbq closed 7 months ago
4
Support `PIVOT` / `UNPIVOT`

#198 ohaibbq closed 7 months ago
1
Implement dayOfYearParser

#197 recidinick closed 7 months ago
2
Implement dayOfYearParser

#196 recidinick closed 7 months ago
0
Unable to use namespaced functions

#195 ohaibbq closed 8 months ago
1
`DATE_DIFF(..., ..., WEEK)` returns incorrect value for multi-year durations

#194 ohaibbq closed 7 months ago
0
`WEEK(<WEEKDAY>)` unsupported for `LAST_DAY()`, `EXTRACT()`, `DATE_DIFF()`, `DATE_TRUNC()`

#193 ohaibbq closed 7 months ago
0
`SELECT 1 AS x UNION ALL (WITH toks AS (...) SELECT toks.x)` raises syntax error

#192 ohaibbq closed 7 months ago
0
Incorrect column count used for aliased columns

#191 ohaibbq closed 7 months ago
0
`PIVOT` / `UNPIVOT` unsupported

#190 ohaibbq closed 7 months ago
0
Update linter

#189 goccy closed 8 months ago
1
`SELECT .. FROM UNNEST(...) WITH OFFSET offset` unsupported

#188 ohaibbq closed 7 months ago
0
Dont crash on nil in LOGICAL_OR and LOGICAL_AND

#187 ohaibbq closed 8 months ago
2
`LOGICAL_OR()` and `LOGICAL_AND()` crash on nil

#186 ohaibbq closed 8 months ago
0
`LIKE()`, and `BETWEEN()` return false instead of null when left-hand side is null

#185 ohaibbq opened 8 months ago
0
[String] Do not cast integer/float-like strings to datetime

#184 ohaibbq closed 8 months ago
4
[String] Use direct string value from ZetaSQL

#183 ohaibbq closed 8 months ago
2
Use value comparators for `LEAST`, `GREATEST`, `BETWEEN`

#182 ohaibbq closed 8 months ago
2
[Array] Handle null ARRAY fields

#181 ohaibbq closed 8 months ago
2
[Array] Support `LEFT OUTER` / `INNER` JOIN modes

#180 ohaibbq closed 8 months ago
1
Cannot `UNNEST` null array fields

#179 ohaibbq closed 8 months ago
0
Regular expressions are improperly parsed

#178 ohaibbq closed 8 months ago
0
`LEAST()`, `GREATEST()`, `BETWEEN()` do not work for string values

#177 ohaibbq closed 8 months ago
0
`ArrayScanNode` formatting does not support all join types

#176 ohaibbq closed 8 months ago
0
`CAST(string AS DATETIME)` incorrectly parses integer strings as date

#175 ohaibbq closed 8 months ago
1