Home » DbVisualizer Forums » DbVisualizer » DbVisualizer - Support

Thread: Bug: SQL formatting and variable values


Permlink Replies: 2 - Pages: 1 - Last Post: Nov 28, 2012 1:08 AM Last Post By: Hans Bergsten
Michael Br

Posts: 1
Registered: 12/02/11
Bug: SQL formatting and variable values
Posted: Dec 2, 2011 2:26 PM
   thread.click_reply Reply
I am using variables in a sql statement. The default value contains spaces and sql keywords like "with" and "and". If I format the sql, the "keywords" in my text are changed an the line break is wrong.

Statment before formatting:
INSERT INTO MYSCHEMA.MYTABLE (ID, TEXT)
VALUES ($$ID||1001||BigDecimal||pk ds=22 dt=NUMERIC$$, $$ART||My text with spaces and sql keywords.|| String|| nullable ds=255 dt=VARCHAR$$)

Statement after formatting: (line width:90)
INSERT
INTO MYSCHEMA.MYTABLE
(
ID, TEXT
)
VALUES
(
$$ID||1001||BigDecimal||pk ds=22 dt=NUMERIC$$, $$ART||My text WITH spaces
AND SQL keywords.|| String|| nullable ds=255 dt=VARCHAR$$
)

The "sql keywords" were changed and a line break and spaces were added:
'My text WITH spaces
AND SQL keywords.'
Hans Bergsten


Posts: 1,558
Registered: 10/11/06
Re: Bug: SQL formatting and variable values
Posted: Dec 2, 2011 7:14 PM    global.in_response_to.tooltip in response to: Michael Br
   thread.click_reply Reply
Hi Michael,

Thanks for reporting this. It is clearly a bug and I will open a ticket for it.

Best Regards,
Hans
Hans Bergsten


Posts: 1,558
Registered: 10/11/06
Re: Bug: SQL formatting and variable values
Posted: Nov 28, 2012 1:08 AM    global.in_response_to.tooltip in response to: Hans Bergsten
   thread.click_reply Reply
Hi Michael,

Just wanted to let you know that this is now fixed in the just released DbVisualizer 8.0.12.

Best Regards,
Hans


Point your RSS reader here for a feed of the latest messages in all forums