search

apavlo / h-store

H-Store Distributed Main Memory OLTP Database System
https://hstore.cs.brown.edu
GNU General Public License v3.0
569 stars 174 forks source link

Implement SQL-92 Functions #83

Open apavlo opened 12 years ago

apavlo commented 12 years ago

Although the complexity of OLTP queries is limited (compared to OLAP-style applications), there are several basic SQL features that are commonly used in transaction processing applications. For this project, students will add support for new SQL features in the H-Store query planner and run-time execution engine. This project will introduce students to H-Store's iterator-based execution engine.

Add support for SQL-92 functions. Students are free to select which functions that wish to implement, but it will be easier to only implement the ones supported by HSQLDB's query planner. To execute these functions, students will implement a new utility class in the execution engine that can invoke by the AbstractExpressionTree to process these functions in the query plan.

Students should write extensive test cases to check whether their implementations are correct.

xinjiacs commented 12 years ago

I added some sql functions to voltdb like concat, char_length, position, repet, left, right... But I do not know whether it can be used in H-Store or not.