Bug Summary:

Broken formatting when pasting SQL output from Microsoft SSMS to Confluence code block macro

Environment:

• Confluence 6.9.0 (Linux, 64bit)
• postgresql 9.5
  Client machine:
• Windows 10
• Browser: Internet explorer 11
• Microsoft SQL Server Management Studio 11.0.3128.0 or SQL Server Management Studio 14.0.1725.0

Steps to replicate

1. Open Server Management Studio, connect to any database and run SQL query editor.
2. Paste following sample SQL into the editor:

   CREATE TABLE emp (
   empno INT PRIMARY KEY,
   ename VARCHAR(10),
   job VARCHAR(9),
   mgr INT NULL,
   hiredate DATETIME,
   sal NUMERIC(7,2),
   comm NUMERIC(7,2) NULL,
   dept INT)
   begin
   insert into emp values
       (1,'JOHNSON','ADMIN',6,'12-17-1990',18000,NULL,4)
   insert into emp values
       (2,'HARDING','MANAGER',9,'02-02-1998',52000,300,3)
   insert into emp values
       (3,'TAFT','SALES I',2,'01-02-1996',25000,500,3)
   insert into emp values
       (4,'HOOVER','SALES I',2,'04-02-1990',27000,NULL,3)
   insert into emp values
       (5,'LINCOLN','TECH',6,'06-23-1994',22500,1400,4)
   insert into emp values
       (6,'GARFIELD','MANAGER',9,'05-01-1993',54000,NULL,4)
   insert into emp values
       (7,'POLK','TECH',6,'09-22-1997',25000,NULL,4)
   insert into emp values
       (8,'GRANT','ENGINEER',10,'03-30-1997',32000,NULL,2)
   insert into emp values
       (9,'JACKSON','CEO',NULL,'01-01-1990',75000,NULL,4)
   insert into emp values
       (10,'FILLMORE','MANAGER',9,'08-09-1994',56000,NULL,2)
   insert into emp values
       (11,'ADAMS','ENGINEER',10,'03-15-1996',34000,NULL,2)
   insert into emp values
       (12,'WASHINGTON','ADMIN',6,'04-16-1998',18000,NULL,4)
   insert into emp values
       (13,'MONROE','ENGINEER',10,'12-03-2000',30000,NULL,2)
   insert into emp values
       (14,'ROOSEVELT','CPA',9,'10-12-1995',35000,NULL,1)
   end
   CREATE TABLE dept (
   deptno INT NOT NULL,
   dname VARCHAR(14),
   loc VARCHAR(13))
   begin
   insert into dept values (1,'ACCOUNTING','ST LOUIS')
   insert into dept values (2,'RESEARCH','NEW YORK')
   insert into dept values (3,'SALES','ATLANTA')
   insert into dept values (4, 'OPERATIONS','SEATTLE')
   end
   

3. Open internet explorer browser, login to Confluence instance.
4. Copy SQL query from Microsoft SMSS to clipboard (by using ctrl+a and ctrl+c)
5. Create new page, add new code block macro, paste content from the clipboard to macro body

Expected results

• Upon saving SQL code included in code block macro will match the output from Microsoft SMSS:
  
  Sample expected result (google chrome)
  

Actual results

Workaround

• Add any text to code block macro first, and then paste SQL output

Notes:

Bug is only visible on Internet Explorer 11, other browsers are not affected