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: #153
• DataType: REAL
  • E011_02
  • pr: #268
• DataType: NUMERIC
  • E011_03
• DataType: CHAR/CHARACTER (VARING)
  • E021_01
  • E021_02
  • E021_10
  • pr: #174
• Function: CHARACTER_LENGTH()/CHAR_LENGTH()
  • E021_04
  • #235
• Function: OCTET_LENGTH()
  • E021_05
  • #264
• Function: SUBSTRING()
  • E021_06
  • pr: #134
• Function: LOWER()/UPPER()
  • E021_08
  • pr: #231
• Function: TRIM()
  • E021_09
  • pr: #211
• Function: POSITION()
  • E021_11
  • pr: #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: #132
• TODO: Support AS() on Select
  • E051_07
  • E051_08
  • pr: #131
• TODO: Support Aliases the result set
  • E051_08
  • pr: #131
• TODO: Rename columns in the FROM clause
  • E051_09
  • pr: #131
• TODO: Support BETWEEN on Where
  • E061_02
  • pr: #133
• TODO: Support ESCAPE on LIKE
  • E061_05
  • pr: #135
• ❌ TODO: Support subquery with ALL/ANY/SOME on WHERE
  • E061_07
  • E061_12
  • sqlparser-rs does not support
• TODO: Support EXISTS on WHERE
  • E061_08
  • E071_06
  • pr: #269
• TODO: Support Subquery on WHERE
  • E061_09
  • pr: #136
  • dep: #156
    • pr: #164
• TODO: Support Subquery on WHERE with IN/Not IN
  • E061_11
  • E061_13
  • pr: #147
• TODO: Support UNION\UNION DISTINCT
  • E071_01
  • pr: #139
• TODO: Support UNION ALL
  • E071_02
  • pr: #139
• TODO: Support EXCEPT DISTINCT
  • E071_03
  • pr: #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: #284
• TODO: Support SELECT INTO
  • E111
  • pr: #141
• ❌ TODO: Support Custom CONSTRAINT name
  • E141_01
  • KiteSQL does not plan to support constraints
• TODO: Multiple primary keys
  • E141_03
  • E141_08
  • pr: #239
• DataType: NAME
  • E141_07
• Keyword: CURRENT_DATE
  • E141_07
  • F051_06
  • pr: #181
• DataType: TIME
  • E141_07
  • pr_1: #181
  • TODO: #182
• DataType: TIMESTAMPE
  • E141_07
  • pr: #271
• Keyword: CURRENT_TIMESTAMP
  • E141_07
  • pr: #271
• Keyword: LOCALTIME
  • E141_07
  • F051_07
• Keyword: LOCALTIMESTAMP
  • E141_07
  • F051_08
• ❌ TODO: Support multiple transaction levels
  • E152_02
• TODO: Updatable queries with subqueries
  • E153
  • pr: #263
• TODO: Support VIEW & CREATE VIEW & DROP VIEW
  • F031_02
  • F032_16
  • pr: #236
• TODO: EXCEPT with VIEW
  • F081
  • pr: #236
• TODO: WHERE, GROUP BY, and HAVING clauses supported in queries with grouped views
  • F131_01
• pr: #236
• TODO: Multiple tables supported in queries with grouped views
  • F131_02
  • pr: #236
• TODO: Set functions supported in queries with grouped views
  • F131_03
  • pr: #236
• TODO: Subqueries with GROUP BY and HAVING clauses and grouped views
  • F131_04
  • pr: #236
• TODO: Support Using on Join
  • F041_01
  • F041_02
  • F041_03
  • F041_04
  • F041_07
  • pr: #146
• TypeString: TIME
  • F051_02
  • F051_04
  • F051_05
  • pr: #181
• TypeString: TIMESTAMPE
  • F051_03
  • F051_04
  • F051_05
  • pr: #271
• TODO: Explicit defaults
  • F221
  • pr: #146
• TODO: Support CASE
  • F261_01
  • pr: #143
• TODO: Searched CASE
  • F261_02
  • pr: #143
• Keyword: NULLIF
  • F261_03
  • pr: #143
• Function: COALESCE
  • F261_04
  • pr: #143
• TODO: Support Subquery on Select
  • F471
  • pr: #144