4paradigm / 4paradigm/OpenMLDB
Add SQL syntax support for passing tuple to 'where in' statement
- Langage dominant
- C++
- Étoiles
- 1.7k
- Forks
- 331
- Merge moyen
- 12 j 12 h
- PR mergées (30 j)
- 1
Description
**Describe the feature you'd like**
Now we can execute the sql like this.
```
select * from t1 where (gender) in (("male"));
```
But fail for this sql.
```
select * from t1 where (name, gender) in (("tobe", "male"));
```
Here is the error message.
```
W0104 11:03:18.722047 1311167296 sql_cluster_router.cc:2651] Status: [101] create logic plan tree failed--Unsupport ASTExpression StructConstructorWithParens
Error: [101] create logic plan tree failed--Unsupport ASTExpression StructConstructorWithParens
```
Guide de contribution
Ouvrir le guide de contribution
Piste de recherche
The error points to sql_cluster_router.cc and an unsupported ASTExpression StructConstructorWithParens. Look for the logic plan tree creation code and the AST handling for WHERE IN clauses. Understand how single-column tuples are parsed versus multi-column tuples. Testing involves writing SQL with tuple syntax against the database.
Rédigé par le modèle d'indexation à partir du texte de l'issue.
Évaluation
- Stack technique
- sql
- Domaine
- databases
- Type d'issue
- Fonctionnalité
- Difficulté
- 4/5
- Temps estimé
- 3-5 jours
- Activité
- À l'abandon
- Clarté
- Clairement spécifiée
- Accessibilité débutants
- 40/100