Feature Request

If you want to contribute code to FnckSQL 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
• DataType: NUMERIC
  • E011_03
• DataType: CHAR/CHARACTER (VARING)
  • E021_01
  • E021_02
  • E021_10
  • pr:feat: addDataType::Char and addLEN toDescribe #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: supportSUBSTRING() #134
• Function: LOWER()/UPPER()
  • E021_08
  • pr:feat: add function Lower & Upper #231
• Function: TRIM()
  • E021_09
  • pr:feat: add support forTRIM() #211
• Function: POSITION()
  • E021_11
  • pr:feat: add support forPOSITION() #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() onSelect
  • E051_07
  • E051_08
  • pr:feat: supportfrom 'table' as 'alias' ('column_1', 'column_2') #131
• TODO: Support Aliases the result set
  • E051_08
  • pr:feat: supportfrom 'table' as 'alias' ('column_1', 'column_2') #131
• TODO: Rename columns in the FROM clause
  • E051_09
  • pr:feat: supportfrom 'table' as 'alias' ('column_1', 'column_2') #131
• TODO: SupportBETWEEN onWhere
  • E061_02
  • pr:feat: supportBETWEEN onWhere #133
• TODO: SupportESCAPE onLIKE
  • E061_05
  • pr:feat: SupportESCAPE onLIKE #135
• TODO: Support subquery withALL/ANY/SOME onWHERE
  • E061_07
  • E061_12
• TODO: SupportEXISTS onWHERE
  • E061_08
  • E071_06
• TODO: Support Subquery onWHERE
  • E061_09
  • pr:feat: SupportSubquery onWhere #136
  • dep:Feature: Support Nested Loop Join #156
    • pr:feat: add support for nested loop join #164
• TODO: Support Subquery onWHERE withIN/Not IN
  • E061_11
  • E061_13
  • pr:SupportSubquery onWHERE withIN/Not IN #147
• TODO: SupportUNION\UNION DISTINCT
  • E071_01
  • pr:feat: supportUnion #139
• TODO: SupportUNION ALL
  • E071_02
  • pr:feat: supportUnion #139
• TODO: SupportEXCEPT DISTINCT
  • E071_03
• 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
• TODO: SupportSELECT INTO
  • E111
  • pr:feat: supportSelect Into #141
• TODO: Support CustomCONSTRAINT name
  • E141_01
• 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 forLogicalType::Time #182
• DataType: TIMESTAMPE
  • E141_07
• Keyword: CURRENT_TIMESTAMP
  • E141_07
• 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
• TODO: SupportVIEW &CREATE VIEW &DROP VIEW
  • F031_02
  • F032_16
  • pr:Feat/View #236
• TODO:EXCEPT withVIEW
  • F081
  • pr:Feat/View #236
• TODO:WHERE,GROUP BY, andHAVING 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: SupportUsing onJoin
  • F041_01
  • F041_02
  • F041_03
  • F041_04
  • F041_07
  • pr:Support:Explicit defaults &Using onJoin & 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
• TypeString: TIMESTAMPE
  • F051_03
  • F051_04
  • F051_05
• TODO: Explicit defaults
  • F221
  • pr:Support:Explicit defaults &Using onJoin & the inner table in a left or right outer join can also be used in an inner join #146
• TODO: SupportCASE
  • F261_01
  • pr:feat: supportif()/ifnull()/nullif()/coalesce()/case ... when ... #143
• TODO: Searched CASE
  • F261_02
  • pr:feat: supportif()/ifnull()/nullif()/coalesce()/case ... when ... #143
• Keyword: NULLIF
  • F261_03
  • pr:feat: supportif()/ifnull()/nullif()/coalesce()/case ... when ... #143
• Function: COALESCE
  • F261_04
  • pr:feat: supportif()/ifnull()/nullif()/coalesce()/case ... when ... #143
• TODO: Support Subquery on Select
  • F471
  • pr:test: passF261_01.slt/F261_02.slt/F261_03.slt/F261_04.slt/F471.slt and addcrdb/sqlite.slt #144