Github user zellerh commented on a diff in the pull request: https://github.com/apache/incubator-trafodion/pull/1334#discussion_r156550499 --- Diff: core/sql/regress/compGeneral/TEST045 --- @@ -498,8 +512,36 @@ update statistics for table date_dim on every column; update statistics for table date_dim on (d_qoy, d_year); update statistics for table store_sales on every column; + + +-------------------------------------------------------------------- +?section common_subexpr --- End diff -- Yes, I often found it pretty difficult to find a good place to put new tests. Maybe compGeneralTEST015 might work? If you don't find a better place you can also leave the test in TEST045 and we can rename the section to something else, like insert_with_limit_clause.
---