TODO: SQL 2016

[KKould]

Feature Request

If you want to contribute code to KiteSQL and find requirements, you can refer to the following list

The corresponding test files are attached under the requirements description. The specific location is in the test directory.
e.g. E011_02 => tests/slt/sql_2016/E011_02.slt

Tips: When you complete the requirement and submit the PR, please do not forget to delete the comment corresponding to the Case.

• DataType: DOUBLE PRECISION
  • E011_02
  • pr: feat(type): add support for double precision #153
• DataType: REAL
  • E011_02
  • pr: feat: implemented the alias real for float #268
• DataType: NUMERIC
  • E011_03
• DataType: CHAR/CHARACTER (VARING)
  • E021_01
  • E021_02
  • E021_10
  • pr: feat: add DataType::Char and add LEN to Describe #174
• Function: CHARACTER_LENGTH()/CHAR_LENGTH()
  • E021_04
  • feat: add function CharLength & CharacterLength #235
• Function: OCTET_LENGTH()
  • E021_05
  • feat: add funtion OctetLength and fix function CharLength  #264
• Function: SUBSTRING()
  • E021_06
  • pr: feat: support SUBSTRING() #134
• Function: LOWER()/UPPER()
  • E021_08
  • pr: feat: add function Lower & Upper #231
• Function: TRIM()
  • E021_09
  • pr: feat: add support for TRIM() #211
• Function: POSITION()
  • E021_11
  • pr: feat: add support for POSITION() #159
• Perf: Eliminate duplicate aggregations
  • E051_01: SELECT DISTINCT A, B FROM TABLE_E051_02_01_06 WHERE A = 1 GROUP BY A, B
  • pr: perf: Eliminate duplicate aggregations #132
• TODO: Support AS() on Select
  • E051_07
  • E051_08
  • pr: feat: support from 'table' as 'alias' ('column_1', 'column_2') #131
• TODO: Support Aliases the result set
  • E051_08
  • pr: feat: support from 'table' as 'alias' ('column_1', 'column_2') #131
• TODO: Rename columns in the FROM clause
  • E051_09
  • pr: feat: support from 'table' as 'alias' ('column_1', 'column_2') #131
• TODO: Support BETWEEN on Where
  • E061_02
  • pr: feat: support BETWEEN on Where #133
• TODO: Support ESCAPE on LIKE
  • E061_05
  • pr: feat: Support ESCAPE on LIKE #135
• TODO: Support subquery with ALL/ANY/SOME on WHERE
  • E061_07
  • E061_12
  • pr: feat: support quantified subqueries #339
  • sqlparser-rs does not support
• TODO: Support EXISTS on WHERE
  • E061_08
  • E071_06
  • pr: feat: Implement EXISTS/NOT EXISTS subquery support #269
• TODO: Support Subquery on WHERE
  • E061_09
  • pr: feat: Support Subquery on Where #136
  • dep: Feature: Support Nested Loop Join #156
    • pr: feat: add support for nested loop join #164
• TODO: Support Subquery on WHERE with IN/Not IN
  • E061_11
  • E061_13
  • pr: Support Subquery on WHERE with IN/Not IN #147
• TODO: Support UNION\UNION DISTINCT
  • E071_01
  • pr: feat: support Union #139
• TODO: Support UNION ALL
  • E071_02
  • pr: feat: support Union #139
• TODO: Support EXCEPT DISTINCT
  • E071_03
  • pr: feat: Support EXCEPT (DISTINCT / ALL) #280
• TODO: Columns combined via table operators need not have exactly the same data type
  • E071_05: SELECT A FROM TABLE_E071_05_01_011 UNION ALL SELECT B FROM TABLE_E071_05_01_012
  • pr: feat: Implicit transformation in set operation #284
• TODO: Support SELECT INTO
  • E111
  • pr: feat: support Select Into #141
• ❌ TODO: Support Custom CONSTRAINT name
  • E141_01
  • KiteSQL does not plan to support constraints
• TODO: Multiple primary keys
  • E141_03
  • E141_08
  • pr: Feat/multiple primary keys #239
• DataType: NAME
  • E141_07
• Keyword: CURRENT_DATE
  • E141_07
  • F051_06
  • pr: Feat: add Function: current_date & add Type: LogicalType::Time #181
• DataType: TIME
  • E141_07
  • pr_1: Feat: add Function: current_date & add Type: LogicalType::Time #181
  • TODO: Feat: TimeZone Info for LogicalType::Time #182
• DataType: TIMESTAMPE
  • E141_07
  • pr: feat: support type TimeStamp #271
• Keyword: CURRENT_TIMESTAMP
  • E141_07
  • pr: feat: support type TimeStamp #271
• Keyword: LOCALTIME
  • E141_07
  • F051_07
• Keyword: LOCALTIMESTAMP
  • E141_07
  • F051_08
• TODO: Support multiple transaction levels
  • E152_02
  • pr: feat: add rc and rr transaction isolation #319
• TODO: Updatable queries with subqueries
  • E153
  • pr: refactor: Refactor Tuple's id to make Update support complex queries #263
• TODO: Support VIEW & CREATE VIEW & DROP VIEW
  • F031_02
  • F032_16
  • pr: Feat/View #236
• TODO: EXCEPT with VIEW
  • F081
  • pr: Feat/View #236
• TODO: WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views
  • F131_01
• pr: Feat/View #236
• TODO: Multiple tables supported in queries with grouped views
  • F131_02
  • pr: Feat/View #236
• TODO: Set functions supported in queries with grouped views
  • F131_03
  • pr: Feat/View #236
• TODO: Subqueries with GROUP BY and HAVING clauses and grouped views
  • F131_04
  • pr: Feat/View #236
• TODO: Support Using on Join
  • F041_01
  • F041_02
  • F041_03
  • F041_04
  • F041_07
  • pr: Support: Explicit defaults & Using on Join & the inner table in a left or right outer join can also be used in an inner join #146
• TypeString: TIME
  • F051_02
  • F051_04
  • F051_05
  • pr: Feat: add Function: current_date & add Type: LogicalType::Time #181
• TypeString: TIMESTAMPE
  • F051_03
  • F051_04
  • F051_05
  • pr: feat: support type TimeStamp #271
• TODO: Explicit defaults
  • F221
  • pr: Support: Explicit defaults & Using on Join & the inner table in a left or right outer join can also be used in an inner join #146
• TODO: Support CASE
  • F261_01
  • pr: feat: support if()/ifnull()/nullif()/coalesce()/case ... when ... #143
• TODO: Searched CASE
  • F261_02
  • pr: feat: support if()/ifnull()/nullif()/coalesce()/case ... when ... #143
• Keyword: NULLIF
  • F261_03
  • pr: feat: support if()/ifnull()/nullif()/coalesce()/case ... when ... #143
• Function: COALESCE
  • F261_04
  • pr: feat: support if()/ifnull()/nullif()/coalesce()/case ... when ... #143
• TODO: Support Subquery on Select
  • F471
  • pr: test: pass F261_01.slt/F261_02.slt/F261_03.slt/F261_04.slt/F471.slt and add crdb/sqlite.slt #144