Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-21915

Sql. Add test coverage for SQL-standard features. Phase 1

Agile BoardAttach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Epic
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • sql
    • SQL Features tests. Phase 1
    • Docs Required, Release Notes Required

    Description

      We have a set of SQL features that are not covered by tests at all.
      Let’s improve that.
      List of features that need to be covered:

      Feature type Feature id Feature Name sub feature id sub feature name
      Mandatory E021 Character string types 1 CHARACTER data type
      Mandatory E031 Identifiers 3 Trailing underscore
      Mandatory E051 Basic query specification 4 GROUP BY can contain columns not in <select list>
      Mandatory E051 Basic query specification 9 Rename columns in the FROM clause
      Mandatory E071 Basic query expressions 1 UNION DISTINCT table operator
      Mandatory E141 Basic integrity constraints 1 NOT NULL constraints
      Mandatory E153 Updatable queries with subqueries    
      Mandatory E161 SQL comments using leading double minus    
      Mandatory F041 Basic joined table 5 Outer joins can be nested
      Mandatory F041 Basic joined table 7 The inner table in a left or right outer join can also be used in an inner join
      Optional F302 INTERSECT table operator 2 INTERSECT ALL table operator
      Optional F304 EXCEPT ALL table operator    
      Optional F391 Long identifiers    
      Optional F393 Unicode escapes in literals    
      Optional F561 Full value expressions    
      Optional F851 <order by clause> in subqueries    
      Optional F855 Nested <order by clause> in <query expression>    
      Optional F863 Nested <result offset clause> in <query expression>    
      Optional T121 WITH (excluding RECURSIVE) in query expression    
      Optional T122 WITH (excluding RECURSIVE) in subquery    
      Optional T351 Bracketed SQL comments (/.../ comments)    
      Optional T434 GROUP BY DISTINCT    
      Optional T501 Enhanced EXISTS predicate    
      Optional T551 Optional key words for default syntax    
      Mandatory T631 IN predicate with one list element    
      Optional T828 JSON_QUERY    

       

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            jooger Iurii Gerzhedovich

            Dates

              Created:
              Updated:

              Slack

                Issue deployment