sql: Alias Type Information is not propagated to pgwire or pg_attribute

[m-schneider]

We currently have a 1:1 mapping from datum type to what we send to the wire.

Example:

root@:26257/test> CREATE TABLE types(a int8, b int2);
CREATE TABLE
root@:26257/test> SELECT attname, atttypid, typname FROM pg_attribute a JOIN pg_type t ON a.atttypid=t.oid WHERE attrelid = 'types'::REGCLASS;
+---------+----------+---------+
| attname | atttypid | typname |
+---------+----------+---------+
| a       |       20 | int8    |
| b       |       20 | int8    |
+---------+----------+---------+

We need to update our pgwire code to send the actual types, and update pg_attribute to display the proper types as well.

[knz]

As discussed with Bob today, this is an area which I plainly forgot to address during my type cleanups last summer.

[jordanlewis]

This is no longer a problem:

[email protected]:65166/defaultdb> CREATE TABLE types(a int8, b int2);
CREATE TABLE

Time: 2.888ms

[email protected]:65166/defaultdb> SELECT attname, atttypid, typname FROM pg_attribute a JOIN pg_type t ON a.atttypid=t.oid WHERE attrelid = 'types'::REGCLASS;
  attname | atttypid | typname
+---------+----------+---------+
  b       |       21 | int2
  a       |       20 | int8
  rowid   |       20 | int8