SqlDbx Forum

SqlDbx

You are not logged in.

#1 2021-03-27 15:48:08

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)

Offline

#2 2021-03-28 22:48:19

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

Offline

Board footer

Powered by FluxBB