Forum Stats

  • 3,709,138 Users
  • 2,241,221 Discussions
  • 7,840,887 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Advanced editor duplicates a character

mNemmNem Posts: 1,380 Gold Trophy

The advanced editor seems to auto replace on 1=1 to on 11=1 .

The simplified code is something like ... (in one format)

with t1 (a) as

(

select 'some xml stuff' from dual

)

, t2 (b) as

(

select 'something from node 01' from dual union all

select 'something from node 02' from dual

)

select t1.*, t2.*

from t1 left join t2

on 1=1

;

The faulty formatting ( >> / Syntax Highlighting / xml)

with t1 (a) as (select 'something' from dual), t2 (b) as(select 'something 01' from dual union allselect 'something 02' from dual)select t1.*, t2.* from t1 left join t2on 1=1;

Yes, I did change it to 0=0 and it also gets modified to 00=0

with t1 (a) as (select 'something' from dual), t2 (b) as(select 'something 01' from dual union allselect 'something 02' from dual)select t1.*, t2.* from t1 left join t2on 0=0;

If I use another format (>> / Syntax Highlighting / SQL)

with t1 (a) as (select 'something' from dual), t2 (b) as(select 'something 01' from dual union allselect 'something 02' from dual)select t1.*, t2.* from t1 left join t2on 0=0;

Answers

  • mNemmNem Posts: 1,380 Gold Trophy
    edited December 2019

    Thanks. In this particular instance, I wanted to use the XML formatting as it was a post for xmlquery (which I only realized the issue after about 10 hours of posting it).

Sign In or Register to comment.