Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement Built-in Functions for String Operations #329

Closed
Tracked by #325
aannleax opened this issue Jul 26, 2023 · 1 comment
Closed
Tracked by #325

Implement Built-in Functions for String Operations #329

aannleax opened this issue Jul 26, 2023 · 1 comment
Assignees
Labels
enhancement New feature or request
Milestone

Comments

@aannleax
Copy link
Member

aannleax commented Jul 26, 2023

We currently do not support any kind of operations on string values.

It would be desirable to have:

  • Filter conditions on existing strings like string-length, contains, starts-with, ends-with, matches
  • Creating new string with functions such as concatenate, substring, upper-case, lower-case, replace

A slightly more complete list can be found here: https://www.w3.org/TR/rif-dtb/#Functions_and_Predicates_on_Strings

Implementing functions on string is difficult in the current architecture, since we store them as integers that represent a key into a dictionary. While having a ColumnScan that has read-access to the dictionary seem plausible, having write access into the dictionary for implementing the second kind of operations could be problematic. This is (a) because Rust makes it difficult to work with mutable references and (b) because the new values that were entered into the new dictionary could be discarded later in the computation, thereby wasting space. Here, one could use (and tidy up) the approach for handling nulls, where a snapshot of the current state is fixed before executing the plan. One would then need a method to "commit" changes after finishing the computation.

@aannleax aannleax added this to the Release 0.5.0 milestone Jul 26, 2023
@aannleax aannleax self-assigned this Jul 26, 2023
@aannleax aannleax added the enhancement New feature or request label Jul 26, 2023
@aannleax aannleax added this to nemo Jul 26, 2023
@github-project-automation github-project-automation bot moved this to Todo in nemo Jul 26, 2023
@mmarx mmarx changed the title Implement Build-in Functions for String Operations Implement Built-in Functions for String Operations Jul 26, 2023
@aannleax
Copy link
Member Author

Has now been implemented

@github-project-automation github-project-automation bot moved this from Todo to Done in nemo Mar 27, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
Archived in project
Development

No branches or pull requests

1 participant