Re: defaut value '1' in smallint column is a string value '1' in pgsql >= 9.5

I see you have posted three bug reports related to PDO but the Postgres
community has no idea how your report relates to a bug in Postgres.

---------------------------------------------------------------------------

On Fri, Dec 1, 2017 at 12:36:48PM +0300, Bogdan Stepanenko wrote:
> related
> https://github.com/yiisoft/yii2/issues/15247
> https://github.com/yiisoft/yii2/issues/15254
>
> 1. create table with
>
> CREATE TABLE "type" (
> int_col integer NOT NULL,
> int_col2 integer DEFAULT '1',
> smallint_col smallint DEFAULT '1',
> char_col char(100) NOT NULL,
> char_col2 varchar(100) DEFAULT 'something',
> char_col3 text,
> float_col double precision NOT NULL,
> float_col2 double precision DEFAULT '1.23',
> blob_col bytea,
> numeric_col decimal(5,2) DEFAULT '33.22',
> time timestamp NOT NULL DEFAULT '2002-01-01 00:00:00',
> bool_col boolean NOT NULL,
> bool_col2 boolean DEFAULT TRUE,
> ts_default TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
> bit_col BIT(8) NOT NULL DEFAULT B'10000010',
> bigint_col BIGINT
> );
>
> 2. Get declaration of `types` from the information schema throw PDO
> 3. Get data about `smallint_col`
> Result: Default value of `smalint_col` is a raw string '1', not convert to int
> 1
>
> I try with this versions (official docker images like `image: postgres:9.4`):
> 9.4 is convert string to int.
> 9.5 and 10.1 is not convert string to int.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +