format difference.... why? : DbVis Software

a

anonymous

started a topic almost 11 years ago

[This topic is migrated from our old forums. The original author name has been removed]

Same SQL, only difference is the comment:
WITH
    even_numbers AS
    (
        SELECT
            2
        FROM
            dual
        UNION ALL
        SELECT
            4
        FROM
            dual
    )
    ,
    odd_numbers AS
    (
        SELECT
            1
        FROM
            dual
        UNION ALL
        SELECT
            3
        FROM
            dual
    )
SELECT
    *
FROM
    even_numbers
UNION
SELECT
    *
FROM
    odd_numbers;

WITH even_numbers AS
-- comment
(
    SELECT
        2
    FROM
        dual
    UNION ALL
    SELECT
        4
    FROM
        dual ) , odd_numbers AS
(
    SELECT
        1
    FROM
        dual
    UNION ALL
    SELECT
        3
    FROM
        dual )
SELECT
    *
FROM
    even_numbers
UNION
SELECT
    *
FROM
    odd_numbers;

When the comment is in the SQL, the name odd_numbers is no longer at the start of the line.
Could this be fixed?

Hans Bergsten

said almost 11 years ago

[This reply is migrated from our old forums.]

Re: format difference.... why?

Hi Ronald,

Yes, that looks odd. We will have a look at it.

Best Regards,
Hans

Roger Bjärevall

said almost 11 years ago

[This reply is migrated from our old forums.]

Re: format difference.... why?

Ronald,

This is now fixed in the 9.1.3 version.

http://www.dbvis.com/download/

Regards

Roger

How can we help you today?

format difference.... why?

anonymous

Hans Bergsten

Roger Bjärevall