use `(col >= 'val') and (col < 'val'+maxChar4StartsWith)` for startsWith (!183) · Merge requests · unitybase / ub-server

Pavlo Mashliakovskiy requested to merge feat/startsWithAsBetween into master Dec 20, 2023

new database configuration parameter maxChar4StartsWith (default is 'џ' a Cyrillic Small Letter Dzhe. U+045F). If parameter is not empty (by default), UBQL with .where('col', 'startsWith', 'val') condition will be transformed into (col >= 'val') and (col < 'val'+maxChar4StartsWith) instead of col like 'val%'

use `(col >= 'val') and (col < 'val'+maxChar4StartsWith)` for startsWith

Merge request reports