Commits · 3f66bb398e3af5f5ba5ce276e51fd20dc5f97bfc · core / picodata

Sep 13, 2024
- feature(plugin): add plugin SQL · 2859cbdb
  godzie44 authored 8 months ago
  
  2859cbdb
Sep 10, 2024
- query.ebnf: proofread and edit · 8513f146
  Artur Sabirov authored 7 months ago and Artur Sabirov committed 6 months ago
  
  8513f146
Sep 06, 2024
- query.ebnf: mark DISTRIBUTED BY as optional · be595c53
  Alexander Tolstoy authored 7 months ago and Alexander Tolstoy committed 6 months ago
  
  be595c53
Aug 26, 2024

feat: support ALTER SYSTEM. It allows to change whitelisted properties from... · 05d67976

Feodor Alexandrov authored 11 months ago

feat: support ALTER SYSTEM. It allows to change whitelisted properties from _pico_property table. Currently, changes affect all tiers. Specifying tier will result in an error.

Co-Authored-by: Dmitry Rodionov <d.rodionov@picodata.io>

Co-Authored-by: Emir Vildanov <e.vildanov@picodata.io>

05d67976

Aug 22, 2024
- feat: support LIMIT clause · dc274be9
  Maksim Kaitmazian authored 8 months ago and Maksim Kaitmazian committed 7 months ago
  
  dc274be9
Aug 20, 2024
- feat: support substr function · 753b482e
  Maksim Kaitmazian authored 8 months ago
  
  753b482e
Aug 09, 2024
- feat: support postgres cast notation · c64b2895
  Maksim Kaitmazian authored 9 months ago
  
  c64b2895
Aug 08, 2024
- query.ebnf: proofread · a741a9d7
  Artur Sabirov authored 8 months ago
  
  a741a9d7
- query.ebnf(expression): sync with query.pest · 2ad6ab06
  Artur Sabirov authored 8 months ago
  
  Affected diagrams: — expression — literal — call — type Extracted diagrams: — case — to_char — to_date — trim
  2ad6ab06
Aug 07, 2024

query.ebnf: replace with "query" where needed · 3c9ff0a5
Artur Sabirov authored 8 months ago

3c9ff0a5

query.ebnf(update): sync with query.pest · cc3440ce

Artur Sabirov authored 8 months ago

Definition:
https://git.picodata.io/picodata/picodata/sbroad/-/blob/b1b021bff1ea23aa8d0fb74a0ed0fd409043a6bb/sbroad-core/src/frontend/sql/query.pest#L205-208

cc3440ce

query.ebnf(select): sync with query.pest · 29ffce7d

Artur Sabirov authored 8 months ago

Definition:
https://git.picodata.io/picodata/picodata/sbroad/-/blob/b1b021bff1ea23aa8d0fb74a0ed0fd409043a6bb/sbroad-core/src/frontend/sql/query.pest#L173-179

29ffce7d

query.ebnf: add `scan` diagram · b3a98360

Artur Sabirov authored 8 months ago

Definition:
https://git.picodata.io/picodata/picodata/sbroad/-/blob/b1b021bff1ea23aa8d0fb74a0ed0fd409043a6bb/sbroad-core/src/frontend/sql/query.pest#L186

b3a98360

Aug 05, 2024
- feat: infer shard key from primary key · a1ed8926
  Arseniy Volynets authored 7 months ago
  
  a1ed8926
Jul 12, 2024
- fix: rename [on tier] clause of create table · 6ec6d883
  Kurdakov Alexander authored 8 months ago
  
  6ec6d883
Jun 28, 2024
- query.ebnf: fix PRIMARY KEY definition · f6f824dd
  Artur Sabirov authored 9 months ago
  
  f6f824dd
Jun 07, 2024
- doc: add distinct for aggregate functions · 1ef2a264
  Denis Smirnov authored 9 months ago
  
  1ef2a264
Jun 04, 2024
- feat: support PRIMARY KEY declaration right next to column definition · 10b9e740
  EmirVildanov authored 10 months ago
  
  10b9e740
- feat: tier support in sql · 92d74263
  Kurdakov Alexander authored 10 months ago and Alexander Kurdakov committed 9 months ago
  
  92d74263
- chore: remove redundant space from query.pest · 1d2deb40
  Kurdakov Alexander authored 10 months ago and Alexander Kurdakov committed 9 months ago
  
  1d2deb40
May 14, 2024
- feat: fix comments · 097c74c0
  EmirVildanov authored 10 months ago and Denis Smirnov committed 10 months ago
  
  097c74c0
- feat: support CASE expression · 0a56d83c
  EmirVildanov authored 10 months ago and Denis Smirnov committed 10 months ago
  
  0a56d83c
May 06, 2024
- feat(sql): implement CTEs · 01b70948
  Denis Smirnov authored 11 months ago
  
  01b70948
May 03, 2024
- feat: support union · b44ff0cd
  Arseniy Volynets authored 10 months ago
  
  b44ff0cd
- feat: support CURRENT_DATE special func · 73cb224b
  Arseniy Volynets authored 11 months ago and Denis Smirnov committed 10 months ago
  
  73cb224b
Apr 19, 2024
- feat: support ORDER BY · 0c57585a
  Emir Vildanov authored 11 months ago
  
  0c57585a
Apr 17, 2024

feat: support to_char function · 84446ce6

Arseniy Volynets authored 11 months ago

- to_char(datetime, format), format is specified
as in `strftime` function:
https://man.freebsd.org/cgi/man.cgi?query=strftime&sektion=3

84446ce6

Apr 16, 2024
- chore: delete feature_taxonomy.md · 37d12450
  Artur Sabirov authored 11 months ago and Denis Smirnov committed 11 months ago
  
  37d12450
Apr 15, 2024
- feat: implement datetime type and to_date function · 511a8ce6
  Arseniy Volynets authored 11 months ago
  
  511a8ce6
Apr 10, 2024
- feat: implement drop index · 3623bab5
  Denis Smirnov authored 11 months ago
  
  3623bab5
- feat(grammar): support create index · 46559946
  Denis Smirnov authored 1 year ago
  
  46559946
Apr 09, 2024
- feat: support trim function · 3f7bda5c
  Maksim Kaitmazian authored 11 months ago and Denis Smirnov committed 11 months ago
  
  3f7bda5c
Mar 26, 2024
- feat: support table.* syntax · e82dc348
  EmirVildanov authored 1 year ago
  
  e82dc348
- fix(ebnf): support of the left outer join · 1443ca01
  Denis Smirnov authored 1 year ago
  
  1443ca01
- feat: support multiple joins without subqueries · 5f8fde62
  Denis Smirnov authored 1 year ago
  
  5f8fde62
Mar 19, 2024
- feat: actualize EBNF · 5dc3c04e
  Denis Smirnov authored 1 year ago
  
  Co-authored-by: EmirVildanov <reddog201030@gmail.com>
  5dc3c04e
Mar 15, 2024
- feat: add support of user renaming · 6296134e
  EmirVildanov authored 1 year ago
  
  6296134e
Mar 12, 2024
- query.ebnf: add left join · 5e5a592e
  Alexander Tolstoy authored 1 year ago and Denis Smirnov committed 1 year ago
  
  5e5a592e
Mar 11, 2024
- feat: add uuid datatype support · 1acf1659
  Роман Хаит authored 1 year ago
  
  1acf1659
Mar 07, 2024
- feat: implement SQL support for grant procedure · c8035788
  Maksim Kaitmazian authored 1 year ago
  
  c8035788