row with all null values is collapsed

[Former user]

Originally reported on Google Code with ID 223

What steps will reproduce the problem?
1. execute this statment

    SELECT 'aaa', 'bbb'
    UNION ALL
    SELECT null, null


What is the expected output? 
  two rows

What do you see instead?
  one normal row and other collapsed row (practicaly not visible)

What version of the product are you using? 
v1.9.4.1

On what operating system/browser?
linux - windows / firefox 22.0 - IE 8

Thanks for your great software !!!!

Reported by [e-mail] on 2013-08-08 21:44:15

[Christopher Kramer]

Thanks for your report. I could reproduce it. I guess in fact we have two problems here:
1. a row should always have at least the height of a character
2. the cells should not be empty, but they should display NULL (in italics) to indicate
this cell is NULL and not empty or something

Because at the moment if you do this:
SELECT NULL, ''
You cannot make a difference between the value of the first and second column.
Note that this works correctly if you browse a table. Seems to be another problem with
redundant code here :-(

Reported by crazy4chrissi on 2013-08-09 10:22:26 - Status changed: Accepted

[Christopher Kramer]

This issue was closed by revision r426.

Reported by crazy4chrissi on 2013-12-24 12:47:06 - Status changed: Fixed

[Christopher Kramer]

I just fixed this issue in svn. Now empty strings echo   to make sure the row height
is not zero. And NULL gets displayed as NULL (in italics) now also in the sql tab.
We have more or less the same code 3 times here:
- action=table_sql
- view=sql
- action=row_view
share a big bunch of code. This issue was only done in case of action=row_view, I now
also did it in the other two cases. We should really reduce redundant code here. I
will open another issue for this particular case.

Reported by crazy4chrissi on 2013-12-24 12:51:07 - Labels added: Target-1.9.5