Details
Description
In the Query Editor make a three statement sequence as follows:
CREATE FUNCTION lame_distance_func(lon,lat)
|
{ abs(-96.7970 - lon) + abs(32.7767 - lat) }; |
SELECT airportname, geo, lame_distance_func (geo.lon, geo.lat)
|
as lame_dist from
|
`travel-sample` WHERE type="airport" LIMIT 3; |
DROP FUNCTION lame_distance_func ;
|
With the above statements make sure the TABLE is selected and then hit the EXECUTE button
The TABLE VIEW is not correct it only shows the first executed statement
(see: image_1)
Toggle between JSON and TABLE and the TABLE VIEW will show all three statements
(see: image_2)
In addition the layouts are not quite right (bad row heights) even after toggling
(see: image_2 on right)