提交 · 30649cada4426e8453a7f1dfa5f3e4c8a84fbd25 · Administrator / h2database

20 9月, 2018 5 次提交
- Merge pull request #1460 from h2database/issue_1427 · 30649cad
  由 Andrei Tokar 提交于 9月 20, 2018
```
Issue 1427: performance of MVSpatialIndex construction
```
  30649cad
- Merge pull request #1461 from katzyn/window · 47e0deb3
  由 Evgenij Ryazanov 提交于 9月 20, 2018
```
Add WINDOW clause support
```
  47e0deb3
- Add WINDOW clause support · 8863b2db
  由 Evgenij Ryazanov 提交于 9月 20, 2018
  
  8863b2db
- additional optimizations for MVRTreeMap · 9e7a31c4
  由 Andrei Tokar 提交于 9月 20, 2018
  
  9e7a31c4
- Issue_1427 · 6d79ef93
  由 Andrei Tokar 提交于 9月 20, 2018
  
  6d79ef93
19 9月, 2018 12 次提交
- Merge pull request #1459 from katzyn/window · 3b4620a2
  由 Evgenij Ryazanov 提交于 9月 19, 2018
```
Improve window clause correctness checks
```
  3b4620a2
- Require ORDER BY for window functions where required by standard · 5bedf88f
  由 Evgenij Ryazanov 提交于 9月 19, 2018
  
  5bedf88f
- Reject invalid usages of window frames in optimize() · ccacc3b8
  由 Evgenij Ryazanov 提交于 9月 19, 2018
  
  ccacc3b8
- Do not sort window data if ORDER BY is not specified · 0ef8cba8
  由 Evgenij Ryazanov 提交于 9月 19, 2018
  
  0ef8cba8
- Do not create default window frame if it was not set · a6c409c9
  由 Evgenij Ryazanov 提交于 9月 19, 2018
  
  a6c409c9
- Merge pull request #1457 from katzyn/window · b0105180
  由 Evgenij Ryazanov 提交于 9月 19, 2018
```
Add NTILE(), LEAD() and LAG() window functions
```
  b0105180
- Add NTILE window function · 8fd4b83d
  由 Evgenij Ryazanov 提交于 9月 19, 2018
  
  8fd4b83d
- Add LEAD() and LAG() window functions · d129b3c9
  由 Evgenij Ryazanov 提交于 9月 19, 2018
  
  d129b3c9
- Merge pull request #1456 from katzyn/window · 4f23bb18
  由 Evgenij Ryazanov 提交于 9月 19, 2018
```
Add experimental implementation of remaining types of window frames
```
  4f23bb18
- Check validity of window frame in Parser · 1b33a3de
  由 Evgenij Ryazanov 提交于 9月 19, 2018
  
  1b33a3de
- Fix RANGE BETWEEN with same direction · 3e61ab53
  由 Evgenij Ryazanov 提交于 9月 19, 2018
  
  3e61ab53
- Fix GROUPS BETWEEN with same direction · fca685a7
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  fca685a7
18 9月, 2018 14 次提交
- Add support for both preceding or both following bounds · e5d78948
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  e5d78948
- Implement remaming types of window frames · 2170322c
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  2170322c
- Parse remaining types of window frames · 88807617
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  88807617
- Merge pull request #1454 from katzyn/window · a1314402
  由 Evgenij Ryazanov 提交于 9月 18, 2018
```
Add FIRST_VALUE(), LAST_VALUE(), and NTH_VALUE()
```
  a1314402
- Add window frame exclusion clause implementation · 0c17e600
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  0c17e600
- Add WindowFrame class and move some logic into it · 32d3ca3f
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  32d3ca3f
- Fix minor issues with BNF in help.csv · 249129a2
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  249129a2
- Update changelog · 30cab90a
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  30cab90a
- Update documentation · 0887e5e3
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  0887e5e3
- Add limited support for window frame clause · e797e868
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  e797e868
- Fix function name in help.csv · 64100847
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  64100847
- Fix NPE in window functions with unknown columns · 6a604a0e
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  6a604a0e
- Add new functions to help.csv · fb889f29
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  fb889f29
- Add flags to FIRST / LAST / NTH value functions · 9941a0d6
  由 Evgenij Ryazanov 提交于 9月 18, 2018
  
  9941a0d6
17 9月, 2018 9 次提交
- Add initial implementation of FIRST_VALUE(), LAST_VALUE(), and NTH_VALUE() · 35b50ffc
  由 Evgenij Ryazanov 提交于 9月 17, 2018
  
  35b50ffc
- Use FETCH FIRST in SELECT examples · bd2fb602
  由 Evgenij Ryazanov 提交于 9月 17, 2018
  
  bd2fb602
- Remove implemented features from roadmap · 3b5301e2
  由 Evgenij Ryazanov 提交于 9月 17, 2018
  
  3b5301e2
- Merge pull request #1453 from katzyn/window · b6cde128
  由 Evgenij Ryazanov 提交于 9月 17, 2018
```
Add ROW_NUMBER(), RANK(), DENSE_RANK(), PERCENT_RANK(), and CUME_DIST() window functions
```
  b6cde128
- Merge pull request #1442 from little-pan/master-fixbug-dbclose · e6b7b9aa
  由 Evgenij Ryazanov 提交于 9月 17, 2018
```
Bugfix - Release MVStore lock and file resources rightly even if errors when compacting database
```
  e6b7b9aa
- Add PERCENT_RANK() and CUME_DIST() window functions · 4b92a2cd
  由 Evgenij Ryazanov 提交于 9月 17, 2018
  
  4b92a2cd
- Fix an unstable test · d988f628
  由 Evgenij Ryazanov 提交于 9月 17, 2018
  
  d988f628
- Fix window specification grammar in help.csv · aeb6c49d
  由 Evgenij Ryazanov 提交于 9月 17, 2018
  
  aeb6c49d
- Add a test · bcb1057b
  由 Evgenij Ryazanov 提交于 9月 17, 2018
  
  bcb1057b