This repository has been archived by the owner on Sep 27, 2019. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 624
Features for Self Driving Benchmark
Lin Ma edited this page Jan 8, 2018
·
3 revisions
List the features that we need to support to run the self-driving benchmarks:
- DROP SCHEMA IF EXISTS
- DEFAULT null, DEFAULT NOW(), DEFAULT nextval()
- ENUM
- UDF
- TRIGGERS
- CREATE SEQUENCE
- DATATYPE - SERIAL
- What-If API of the optimizer
List of SQL functions that are better to have:
More important:
- NOW()
- EXTRACT() (siva and priyatham)
LIKE (done)- LOWER
DATE_TRUNC (done)TRIM (done)- CONCAT
- CAST( AS CHAR), :: in Postgres (who knows what's the status on this?)
- CURRENT_DATE
Less important:
- ABS (pervaze)
CEILING (done)LENGTH (done)- NULLIF
- GROUP_CONCAT
ROUND (done)FLOOR (done)- BETWEEN
- COALESCE
- UPPER