zhouqingqing / qpmodel

A Relational Optimizer and Executor
MIT License
64 stars 18 forks source link

Adding some of the NIST tests to excercise GROUP BY, HAVING, AGGREGATES #225

Closed pkommoju closed 3 years ago

pkommoju commented 3 years ago

Adding some of the NIST tests to exercise GROUP BY, HAVING, AGGREGATES and some subqueries. There are many more relevant tests but some features are not supported in the current code base. String comparison will be enhanced and then some more tests will be added. Fixed Minor typos in error/comment.

Character data comparison with character data is now supported but no implicit conversions to and from character data are supported.