diff options
| author | jepett0 <111313089+jepett0@users.noreply.github.com> | 2024-01-19 18:38:54 +0530 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-01-19 18:38:54 +0530 |
| commit | 8e0390cff087db1a4f2f9f6646032b3db4ace131 (patch) | |
| tree | 4964c340504ecec222a91604cbff293628c38c61 /library/python/strings/strings.py | |
| parent | 11cf2d8b8ef164200c3e8adf08b1c90b68ca90fc (diff) | |
| download | ydb-8e0390cff087db1a4f2f9f6646032b3db4ace131.tar.gz | |
Enable SELECT from views (#795)
* Enable SELECT from views
Selecting from a view currently works for the following queries written in the view:
- SELECT 1
- SELECT * FROM SomeTable
- SELECT a, b FROM SomeTable (you can specify which columns you need)
- SELECT * FROM FirstTable JOIN SecondTable ON ...
- SELECT * FROM FirstTable UNION SELECT * FROM SecondTable
- SELECT * FROM SomeOtherView
- SELECT * FROM FirstView JOIN SecondView ON ...
The idea of the implementation is the following: whenever we encounter TExprNode corresponding to a Right! read from a view, we change this node to a TExprNode, which corresponds to the compiled query, stored in the view. This is done on RewriteIO stage of the pipeline. The biggest challenge was to meet all the expectations of the CheckTx function applied to the rewritten query.
Diffstat (limited to 'library/python/strings/strings.py')
0 files changed, 0 insertions, 0 deletions