goccy/go-zetasqlite

Issues

• Support DATE_TRUNC with HOUR granularity

  #224 opened 2 months ago by anowinski-equinix
  0

• Support table-valued functions.

  #221 opened 3 months ago by thalissonfelipe
  0

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

  #220 opened 4 months ago by iolalla
  0

• `IF()` statements are not rewritten to use proper control flow

  #215 opened 6 months ago by ohaibbq
  0

• TIMESTAMP_TRUNC gives incorrect results for SECOND and MILLISECOND

  #218 opened 6 months ago by Zherdev
  1

• TRIM only trims spaces by default, not all whitespace

  #217 opened 6 months ago by ethan-oro
  0

• [String Functions]: EDIT_DISTANCE

  #212 opened 8 months ago by anonimitoraf
  0

• [Date] Values that overflow date boundaries are allowed

  #138 opened a year ago by ohaibbq
  1

• Consider using materialized views for common table expressions

  #210 opened 8 months ago by ohaibbq
  0

• `WEEK(<WEEKDAY>)` unsupported for `LAST_DAY()`, `EXTRACT()`, `DATE_DIFF()`, `DATE_TRUNC()`

  #193 opened 8 months ago by ohaibbq
  0

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

  #194 opened 8 months ago by ohaibbq
  0

• Full range of dates not supported

  #202 opened 8 months ago by ohaibbq
  0

• `SELECT .. FROM UNNEST(...) WITH OFFSET offset` unsupported

  #188 opened 8 months ago by ohaibbq
  0

• Incorrect column count used for aliased columns

  #191 opened 8 months ago by ohaibbq
  0

• `SELECT 1 AS x UNION ALL (WITH toks AS (...) SELECT toks.x)` raises syntax error

  #192 opened 8 months ago by ohaibbq
  0

• `PIVOT` / `UNPIVOT` unsupported

  #190 opened 8 months ago by ohaibbq
  0

• Implement dayOfYearParser

  #196 opened 8 months ago by recidinick
  0

• Missing window function implementation for `LOGICAL_OR` and `LOGICAL_AND`

  #200 opened 9 months ago by ohaibbq
  0

• Unable to use namespaced functions

  #195 opened 9 months ago by ohaibbq
  1

• `CAST(string AS DATETIME)` incorrectly parses integer strings as date

  #175 opened 9 months ago by ohaibbq
  1

• [Dates] Improve time parser's handling of whitespace

  #167 opened 9 months ago by ohaibbq
  0

• [Date] Dates with single digit preceded by space cannot be parsed

  #165 opened 9 months ago by ohaibbq
  0

• [Date] `%p` token not implemented

  #151 opened 9 months ago by ohaibbq
  0

• [Aggregate] `ORDER BY` gives priority to proceeding clauses

  #144 opened 9 months ago by ohaibbq
  0

• [Aggregate] `null` `ORDER BY` elements cause crash

  #145 opened 9 months ago by ohaibbq
  0

• [Windowing] [Formatter] Analytic function groups cross-contaminate

  #160 opened 9 months ago by ohaibbq
  0

• [Filter] `QUALIFY` clause on a `SELECT ... GROUP BY` raises syntax error

  #150 opened 9 months ago by ohaibbq
  0

• [Formatter] Filtering sub-selects causes syntax error

  #147 opened 9 months ago by ohaibbq
  0

• [Int64] Cannot cast strings with leading zeros to INT64

  #158 opened 9 months ago by ohaibbq
  0

• `INSERT` statements cannot be prepared with `sql.DB.Prepare()`

  #170 opened 9 months ago by ohaibbq
  0

• [Strings] `LIKE` raises an error when using an asterisk in the query text

  #149 opened 9 months ago by ohaibbq
  0

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

  #148 opened 9 months ago by ohaibbq
  0

• [Aggregate] `STRING_AGG` returns `""` when aggregating `null`

  #146 opened 9 months ago by ohaibbq
  0

• `NULLIF` panics when `expr` is null

  #163 opened 9 months ago by ohaibbq
  0

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

  #172 opened 9 months ago by ohaibbq
  0

• `ArrayScanNode` formatting does not support all join types

  #176 opened 9 months ago by ohaibbq
  0

• Cannot `UNNEST` null array fields

  #179 opened 9 months ago by ohaibbq
  0

• Regular expressions are improperly parsed

  #178 opened 9 months ago by ohaibbq
  0

• `LEAST()`, `GREATEST()`, `BETWEEN()` do not work for string values

  #177 opened 9 months ago by ohaibbq
  0

• `LOGICAL_OR()` and `LOGICAL_AND()` crash on nil

  #186 opened 9 months ago by ohaibbq
  0

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

  #185 opened 10 months ago by ohaibbq
  0

• [Aggregates] [Windowing] `COVAR_POP` uses `COVAR_SAMP` implementation

  #168 opened 10 months ago by ohaibbq
  0

• [Windowing] Complex queries utilizing window functions become too slow to reasonably execute

  #161 opened 10 months ago by ohaibbq
  1

• [sqlite] `Parse error: parser stack overflow`

  #153 opened a year ago by ohaibbq
  1

• [Windowing] `ORDER BY .. NULLS FIRST / LAST` not implemented

  #152 opened a year ago by ohaibbq
  1

• Date element `%y` uses century parser `%C` instead of actual implementation

  #134 opened a year ago by ohaibbq
  0

• [Date] Elements do not parse strings that do not meet the minimum format string length

  #137 opened a year ago by ohaibbq
  1

• [Windowing] `ORDER BY` gives priority to proceeding clauses

  #140 opened a year ago by ohaibbq
  0

• [Date] Incorrect initial date used for parsing dates

  #136 opened a year ago by ohaibbq
  0

• [Windowing] Crash when a window partition has null-value

  #139 opened a year ago by ohaibbq
  0