SqlDbx Forum

NorthWind

Member

bug using Speed Typing

Hi,

When i use some sql with sqldbx speed typing feature, it brokes the sql code.

Example (postgresql sql code):

WITH localization AS (
       SELECT tt.id_,
          substr(tt.field, 1, tt.position-1)::INTEGER AS id_field,
          substring(tt.field,tt.position+1,tt.size - tt.position+1)::INTEGER AS id_user
    FROM (SELECT sl.id_,
                  regexp_replace(regexp_split_to_table (sl.expressao,E','),'[^0-9^&:]', '', 'gi') AS field,
                  length(regexp_replace(regexp_split_to_table (sl.expressao,E','),'[^0-9^&:]', '', 'gi')) AS size,
                  strpos(regexp_replace(regexp_split_to_table (sl.expressao,E','),'[^0-9^&:]', '', 'gi'),':') AS position
             FROM (SELECT id_, pooledactorsexpression_ AS expressao
                     FROM public.jbpm_swimlane WHERE id_ IN (1500)) sl)tt
)

(SELECT DISTINCT * FROM localization);

If you call this sql using Speed Typing, it hides the first ^ character simbol, breaking SQL.

I am using version 6.16 Professional.

Last edited by NorthWind (2021-03-27 15:48:31)

sqldbxhelp

Administrator

Re: bug using Speed Typing

Character '^ is used in Speed typing as indicator where to put cursor after expanding.
And it is deleted before copying the code
This is definitely will break your code