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