search

redis-field-engineering / redis-sql-trino

Real-time Indexed SQL Queries for Redis
MIT License
34 stars 4 forks source link

Index with capital letters in the name can not be used without redisearch.case-insensitive-names #10

Closed antonum closed 1 year ago

antonum commented 1 year ago

Indices like MixedCaseNames can not be used with RedisSQL, unless redisearch.case-insensitive-names is on.

To reproduce:

FT.CREATE MixedCaseBeers ON HASH PREFIX 1 beerJSON: SCHEMA id TAG brewery_id TAG  name TEXT SORTABLE abv NUMERIC SORTABLE descript TEXT style_name TAG  cat_name TAG

In Trino with default redisearch.case-insensitive-names=false try:

trino:default> show tables;
     Table      
----------------
 beers          
 beersjson      
 idxsdm         
 mixedcasebeers 
(4 rows)

Now try to select from MixedCaseBeers:

select * from mixedcasebeers;
select * from MixedCaseBeers;
select * from MIXEDCASEBEERS;

all will fail with the same error: Table 'redisearch.default.mixedcasebeers' does not exist

jruaux commented 1 year ago

🎉 This issue has been resolved in v0.3.2 (Release Notes)