Test case-sqrt.Bug-3627.sql (id 0f951a98884e) (err)
case-sqrt.Bug-3627.stable.out.FILTERED 2018-07-11 23:25:11.984713300 +0200case-sqrt.Bug-3627.test.out.FILTERED 2018-07-11 23:25:11.984713300 +0200
1 Statistics about stdout of test 'case-sqrt.Bug-3627` in directory 'sql/test/BugTracker-2014`: 1 1 Statistics about stdout of test 'case-sqrt.Bug-3627` in directory 'sql/test/BugTracker-2014`: 1
2 21 lines, 110 words, 462 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 12 lines, 61 words, 272 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 21 lines, 110 words, 462 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 12 lines, 61 words, 272 chars in lines not matching '^$|^(\| |)#` 3
4 # 111 lines, 502 words, 3265 chars in all lines 4 ! 4 # 57 lines, 241 words, 1605 chars in all lines 4
5 5 5 5
..................
# id, colint, L10 # name
88 [ 5, 2, 1.414213562 ] 88 56 [ 5, 2, 1.414213562 ] 56
89 89 -
90 #SELECT t0.id 90 -
91 # ,t0.colint 91 -
92 # ,SQRT(t0.colint_sq) 92 -
93 # FROM (SELECT id 93 -
94 # ,colint 94 -
95 # ,CASE WHEN colint < 0 95 -
96 # THEN -1 * colint 96 -
97 # ELSE colint 97 -
98 # END AS colint_sq 98 -
99 # FROM t1 99 -
100 # ) t0 100 -
101 #; 101 -
102 % sys.t0, sys.t0, sys.t0 # table_name 102 -
103 % id, colint, sqrt_colint # name 103 -
104 % int, int, double # type 104 -
105 % 1, 2, 24 # length 105 -
106 [ 1, -2, 1.414213562 ] 106 -
107 [ 2, -1, 1 ] 107 -
108 [ 3, 0, 0 ] 108 -
109 [ 4, 1, 1 ] 109 -
110 [ 5, 2, 1.414213562 ] 110 -
111 #ROLLBACK; 111 57 #ROLLBACK; 57