weird tabs in sql console
Hi I paste a query formatted like so:
>>>>>>>>>>>>>>>>>>>>>>
create or replace view mart.trip as
SELECT trip.*,
linetext, polyline
FROM dw.trip as trip
join (
select trip_id, st_astext(pp) as linetext, pp as polyline from
(select trip_id, st_makeline(geom) as pp from
(select trip_id, geom from dw.visit as visit
join dw.schedule_item as sched on visit.id = sched.visit_id
join dw.site as site on sched.start_location = site.id order by trip_id, start) as visits
group by trip_id
) as tripsrc ) as linecalc on trip.id = linecalc.trip_id;
>>>>>>>>>>>>>..
Into the sql console and it does this:
>>>>>>>>>>>>>>>>
create or replace view mart.trip as
SELECT trip.*,
linetext, polyline
FROM dw.trip as trip
join (
select trip_id, st_astext(pp) as linetext, pp as polyline from
(select trip_id, st_makeline(geom) as pp from
(select trip_id, geom from dw.visit as visit
join dw.schedule_item as sched on visit.id = sched.visit_id
join dw.site as site on sched.start_location = site.id order by trip_id, start) as visits
group by trip_id
) as tripsrc ) as linecalc on trip.id = linecalc.trip_id;
>>>>>>>>>>>>>>>>>>
Which means my sql has disappeared off the right hand side of the console windows.
But I can see no way to change this behaviour in settings.
Is there anything I can do - it makes the console complete useless for anything with nesting?
Please sign in to leave a comment.
Looks like http://youtrack.jetbrains.com/issue/IDEA-112681 . Please vote/watch.
Please see http://youtrack.jetbrains.com/issue/IDEA-114095