Test groupby_having_orderby_count.Bug-6624.sql (id 9f8602e8c51d) (err)
groupby_having_orderby_count.Bug-6624.stable.out.FILTERED 2018-10-17 23:49:31.842620400 -0700groupby_having_orderby_count.Bug-6624.test.out.FILTERED 2018-10-17 23:49:31.842620400 -0700
..................
# type, L16 # name
38 % 9, 3 # length 38 36 % 9, 3 # length 36
39 [ "int", 244 ] 39 ! 37 [ "int", 211 ] 37
40 [ "varchar", 154 ] 40 ! 38 [ "varchar", 137 ] 38
41 [ "clob", 68 ] 41 ! 39 [ "smallint", 52 ] 39
42 [ "smallint", 55 ] 42 ! 40 [ "bigint", 50 ] 40
43 [ "bigint", 53 ] 43 ! 41 [ "clob", 40 ] 41
44 [ "boolean", 28 ] 44 ! 42 [ "boolean", 27 ] 42
45 [ "timestamp", 12 ] 45 ! 43 [ "timestamp", 11 ] 43
46 #SELECT type,COUNT(id) FROM sys.columns GROUP BY type HAVING COUNT(id)>10 ORDER BY 2 DESC; 46 44 #SELECT type,COUNT(id) FROM sys.columns GROUP BY type HAVING COUNT(id)>10 ORDER BY 2 DESC; 44
..................
# type, L16 # name
52 % 9, 3 # length 52 50 % 9, 3 # length 50
53 [ "int", 244 ] 53 ! 51 [ "int", 211 ] 51
54 [ "varchar", 154 ] 54 ! 52 [ "varchar", 137 ] 52
55 [ "clob", 68 ] 55 ! 53 [ "smallint", 52 ] 53
56 [ "smallint", 55 ] 56 ! 54 [ "bigint", 50 ] 54
57 [ "bigint", 53 ] 57 ! 55 [ "clob", 40 ] 55
58 [ "boolean", 28 ] 58 ! 56 [ "boolean", 27 ] 56
59 [ "timestamp", 12 ] 59 ! 57 [ "timestamp", 11 ] 57
60 #SELECT type,COUNT(id) as cnt FROM sys.columns GROUP BY type HAVING COUNT(id)>10 ORDER BY cnt DESC; 60 58 #SELECT type,COUNT(id) as cnt FROM sys.columns GROUP BY type HAVING COUNT(id)>10 ORDER BY cnt DESC; 58
..................
# .columns, .L17 # table_name
65 % 9, 3 # length 65 63 % 9, 3 # length 63
66 [ "int", 244 ] 66 ! 64 [ "int", 211 ] 64
67 [ "varchar", 154 ] 67 ! 65 [ "varchar", 137 ] 65
68 [ "clob", 68 ] 68 ! 66 [ "smallint", 52 ] 66
69 [ "smallint", 55 ] 69 ! 67 [ "bigint", 50 ] 67
70 [ "bigint", 53 ] 70 ! 68 [ "clob", 40 ] 68
71 [ "boolean", 28 ] 71 ! 69 [ "boolean", 27 ] 69
72 [ "timestamp", 12 ] 72 ! 70 [ "timestamp", 11 ] 70
73 73 71 71