Column name using "AS" not working

[David Štefka]

Hi,

if I select a column using "AS" operator, the resulting column name is
sometimes taken from the original column name (and not from the "AS").
The following code explains the problem.

I am not sure if it is a bug or not, so I better report it :)


-- db version 1.3.153 (2011-03-14), same result in 1.2.145

CREATE TABLE HT_EXAMPLE (
  foo VARCHAR(8)
);

-- returns FOO
SELECT
  foo
FROM HT_EXAMPLE
;

-- returns FOO ???
SELECT
  foo as bar
FROM HT_EXAMPLE
;

-- returns BAR - OK
SELECT
  '' || foo as bar
FROM HT_EXAMPLE
;

-- 
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to 
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/h2-database?hl=en.