Skip to content

Version 42.2.15/16 returns different base type on a sql.Array column #1876

New issue
New issue
Open
Open
Version 42.2.15/16 returns different base type on a sql.Array column#1876
@martijnblankestijn

Description

@martijnblankestijn
martijnblankestijn
opened on Aug 28, 2020

Describe the issue
The base type of an 'array of enum' column changed from one patch version to the other.

A table has a column with the datatype 'array of an enum'

CREATE TYPE messageFlag AS ENUM('duplicate','spike');
...
   ADD COLUMN IF NOT EXISTS flags messageFlag[] NULL,

The log below is what happened when diving into the issue and finding out that the base type changed from String to PGObject.

42.2.14 
column name: [id type: [ 2003, typeName: [_flag]
Array: base type name: flag, base type: 12
Element: Value=duplicate, Type: class java.lang.String

42.2.16 
column name: [id type: [ 2003, typeName: [_flag]
Array: base type name: flag, base type: 12
Element: Value=duplicate, Type: class org.postgresql.util.PGobject


org.opentest4j.AssertionFailedError: 
Expected :class java.lang.String
Actual   :class org.postgresql.util.PGobject

Driver Version?
42.2.15/16

Java Version?
Oracle Corporation Java 1.8.0_261

OS Version?
Darwin Kernel Version 18.7.0

PostgreSQL Version?
11

To Reproduce
Steps to reproduce the behaviour:
Checkout https://github.com/martijnblankestijn/postgresql-jdbc-driver-issue-array-type
Run test case for success, change postgresql jdbc driver version from 42.2.14 to 15.

Expected behaviour
Expected is that the array column kept the same base type.

Logs
Aug 28, 2020 1:14:23 PM org.postgresql.Driver connect
FINE: Connecting with URL: jdbc:postgresql://localhost:5432/?user=postgres&password=postgres&loggerLevel=TRACE&loggerFile=pgjdbc-trace.log
Aug 28, 2020 1:14:23 PM org.postgresql.jdbc.PgConnection
FINE: PostgreSQL JDBC Driver 42.2.14
Aug 28, 2020 1:14:23 PM org.postgresql.jdbc.PgConnection setDefaultFetchSize
FINE: setDefaultFetchSize = 0
Aug 28, 2020 1:14:23 PM org.postgresql.jdbc.PgConnection setPrepareThreshold
FINE: setPrepareThreshold = 5
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.ConnectionFactoryImpl openConnectionImpl
FINE: Trying to establish a protocol version 3 connection to localhost:5432
Aug 28, 2020 1:14:23 PM org.postgresql.core.Encoding
FINEST: Creating new Encoding UTF-8 with fastASCIINumbers true
Aug 28, 2020 1:14:23 PM org.postgresql.core.Encoding
FINEST: Creating new Encoding UTF-8 with fastASCIINumbers true
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.ConnectionFactoryImpl tryConnect
FINE: Receive Buffer Size is 408.300
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.ConnectionFactoryImpl tryConnect
FINE: Send Buffer Size is 146.988
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.ConnectionFactoryImpl enableSSL
FINEST: FE=> SSLRequest
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.ConnectionFactoryImpl enableSSL
FINEST: <=BE SSLRefused
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.ConnectionFactoryImpl sendStartupPacket
FINEST: FE=> StartupPacket(user=postgres, database=, client_encoding=UTF8, DateStyle=ISO, TimeZone=Europe/Amsterdam, extra_float_digits=2)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.ConnectionFactoryImpl doAuthentication
FINEST: <=BE AuthenticationOk
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveParameterStatus
FINEST: <=BE ParameterStatus(application_name = )
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveParameterStatus
FINEST: <=BE ParameterStatus(client_encoding = UTF8)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveParameterStatus
FINEST: <=BE ParameterStatus(DateStyle = ISO, MDY)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveParameterStatus
FINEST: <=BE ParameterStatus(integer_datetimes = on)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveParameterStatus
FINEST: <=BE ParameterStatus(IntervalStyle = postgres)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveParameterStatus
FINEST: <=BE ParameterStatus(is_superuser = on)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveParameterStatus
FINEST: <=BE ParameterStatus(server_encoding = UTF8)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveParameterStatus
FINEST: <=BE ParameterStatus(server_version = 11.2 (Debian 11.2-1.pgdg90+1))
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveParameterStatus
FINEST: <=BE ParameterStatus(session_authorization = postgres)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveParameterStatus
FINEST: <=BE ParameterStatus(standard_conforming_strings = on)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveParameterStatus
FINEST: <=BE ParameterStatus(TimeZone = Europe/Amsterdam)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl readStartupMessages
FINEST: <=BE BackendKeyData(pid=25.143,ckey=41.080.490)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.core.SetupQueryRunner$SimpleResultHandler@4c9f8c13, maxRows=0, fetchSize=0, flags=1.047
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="SET extra_float_digits = 3",oids={})
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=1)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(SET)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.core.SetupQueryRunner$SimpleResultHandler@3d680b5a, maxRows=0, fetchSize=0, flags=1.047
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="SET application_name = 'PostgreSQL JDBC Driver'",oids={})
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=1)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveParameterStatus
FINEST: <=BE ParameterStatus(application_name = PostgreSQL JDBC Driver)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(SET)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:23 PM org.postgresql.jdbc.PgConnection
FINEST: types using binary send = TIMESTAMPTZ,UUID,INT2_ARRAY,INT4_ARRAY,BYTEA,TEXT_ARRAY,TIMETZ,INT8,INT2,INT4,VARCHAR_ARRAY,INT8_ARRAY,POINT,TIMESTAMP,TIME,BOX,FLOAT4,FLOAT8,FLOAT4_ARRAY,FLOAT8_ARRAY
Aug 28, 2020 1:14:23 PM org.postgresql.jdbc.PgConnection
FINEST: types using binary receive = TIMESTAMPTZ,UUID,INT2_ARRAY,INT4_ARRAY,BYTEA,TEXT_ARRAY,TIMETZ,INT8,INT2,INT4,VARCHAR_ARRAY,INT8_ARRAY,POINT,DATE,TIMESTAMP,TIME,BOX,FLOAT4,FLOAT8,FLOAT4_ARRAY,FLOAT8_ARRAY
Aug 28, 2020 1:14:23 PM org.postgresql.jdbc.PgConnection
FINEST: integer date/time = true
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@4facf68f, maxRows=0, fetchSize=0, flags=21
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="DROP TABLE IF EXISTS X",oids={})
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendDescribePortal
FINEST: FE=> Describe(portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=1)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE NoData
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(DROP TABLE)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@41e36e46, maxRows=0, fetchSize=0, flags=21
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="DROP TYPE IF EXISTS flag ",oids={})
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendDescribePortal
FINEST: FE=> Describe(portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=1)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE NoData
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(DROP TYPE)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@15c43bd9, maxRows=0, fetchSize=0, flags=21
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="CREATE TYPE flag AS ENUM('duplicate','spike')",oids={})
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendDescribePortal
FINEST: FE=> Describe(portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=1)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE NoData
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(CREATE TYPE)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@3d74bf60, maxRows=0, fetchSize=0, flags=21
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="CREATE table X(id INT primary key , flags flag[] NULL)",oids={})
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendDescribePortal
FINEST: FE=> Describe(portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=1)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE NoData
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(CREATE TABLE)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@4f209819, maxRows=0, fetchSize=0, flags=21
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="insert into X values (1, '{duplicate}')",oids={})
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendDescribePortal
FINEST: FE=> Describe(portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=1)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE NoData
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(INSERT 0 1)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@15eb5ee5, maxRows=0, fetchSize=0, flags=17
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="select * from X",oids={})
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendDescribePortal
FINEST: FE=> Describe(portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=0)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: <=BE RowDescription(2)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(id,INT4,4,T)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(flags,unknown:255621,65535,T)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE DataRow(len=12)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(SELECT 1)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@5119fb47, maxRows=0, fetchSize=0, flags=17
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="SELECT n.nspname = ANY(current_schemas(true)), n.nspname, t.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1",oids={23})
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null,$1=<255621>,type=INT4)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendDescribePortal
FINEST: FE=> Describe(portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=0)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: <=BE RowDescription(3)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(?column?,BOOL,1,T)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(nspname,NAME,64,T)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(typname,NAME,64,T)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE DataRow(len=12)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(SELECT 1)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:23 PM org.postgresql.jdbc.PgResultSet getBoolean
FINEST: getBoolean columnIndex: 1
Aug 28, 2020 1:14:23 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 2
Aug 28, 2020 1:14:23 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 3
Aug 28, 2020 1:14:23 PM org.postgresql.jdbc.TypeInfoCache getSQLType
FINEST: querying SQL typecode for pg type {0}
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@1dde4cb2, maxRows=0, fetchSize=0, flags=17
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="SELECT typinput='array_in'::regproc as is_array, typtype, typname FROM pg_catalog.pg_type LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname ) ) as sp ON sp.nspoid = typnamespace WHERE typname = $1 ORDER BY sp.r, pg_type.oid DESC",oids={1043})
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null,$1=<'_flag'>,type=VARCHAR)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendDescribePortal
FINEST: FE=> Describe(portal=null)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=0)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: <=BE RowDescription(3)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(is_array,BOOL,1,T)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(typtype,CHAR,1,T)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(typname,NAME,64,T)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE DataRow(len=7)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(SELECT 1)
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:23 PM org.postgresql.jdbc.PgResultSet getBoolean
FINEST: getBoolean columnIndex: 1
Aug 28, 2020 1:14:23 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 2
Aug 28, 2020 1:14:23 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@6973b51b, maxRows=0, fetchSize=0, flags=17
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="SELECT c.oid, a.attnum, a.attname, c.relname, n.nspname, a.attnotnull OR (t.typtype = 'd' AND t.typnotnull), a.attidentity != '' OR pg_catalog.pg_get_expr(d.adbin, d.adrelid) LIKE '%nextval(%' FROM pg_catalog.pg_class c JOIN pg_catalog.pg_namespace n ON (c.relnamespace = n.oid) JOIN pg_catalog.pg_attribute a ON (c.oid = a.attrelid) JOIN pg_catalog.pg_type t ON (a.atttypid = t.oid) LEFT JOIN pg_catalog.pg_attrdef d ON (d.adrelid = a.attrelid AND d.adnum = a.attnum) JOIN (SELECT 255627 AS oid , 1 AS attnum UNION ALL SELECT 255627, 2) vals ON (c.oid = vals.oid AND a.attnum = vals.attnum) ",oids={})
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendDescribePortal
FINEST: FE=> Describe(portal=null)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=0)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: <=BE RowDescription(7)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(oid,OID,4,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(attnum,INT2,2,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(attname,NAME,64,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(relname,NAME,64,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(nspname,NAME,64,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(?column?,BOOL,1,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(?column?,BOOL,1,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE DataRow(len=17)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE DataRow(len=20)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(SELECT 2)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getLong
FINEST: getLong columnIndex: 1
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getLong
FINEST: getLong columnIndex: 2
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 3
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 4
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 5
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getBoolean
FINEST: getBoolean columnIndex: 6
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getBoolean
FINEST: getBoolean columnIndex: 7
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getLong
FINEST: getLong columnIndex: 1
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getLong
FINEST: getLong columnIndex: 2
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 3
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 4
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 5
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getBoolean
FINEST: getBoolean columnIndex: 6
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getBoolean
FINEST: getBoolean columnIndex: 7
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 2
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@6c80d78a, maxRows=0, fetchSize=0, flags=17
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="SELECT e.typdelim FROM pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid",oids={23})
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null,$1=<255621>,type=INT4)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendDescribePortal
FINEST: FE=> Describe(portal=null)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=0)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: <=BE RowDescription(1)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(typdelim,CHAR,1,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE DataRow(len=1)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(SELECT 1)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 1
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@62150f9e, maxRows=0, fetchSize=0, flags=17
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="SELECT e.oid, n.nspname = ANY(current_schemas(true)), n.nspname, e.typname FROM pg_catalog.pg_type t JOIN pg_catalog.pg_type e ON t.typelem = e.oid JOIN pg_catalog.pg_namespace n ON t.typnamespace = n.oid WHERE t.oid = $1",oids={23})
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null,$1=<255621>,type=INT4)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendDescribePortal
FINEST: FE=> Describe(portal=null)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=0)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: <=BE RowDescription(4)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(oid,OID,4,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(?column?,BOOL,1,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(nspname,NAME,64,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(typname,NAME,64,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE DataRow(len=17)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(SELECT 1)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getLong
FINEST: getLong columnIndex: 1
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getBoolean
FINEST: getBoolean columnIndex: 2
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 3
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 4
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.TypeInfoCache getSQLType
FINEST: querying SQL typecode for pg type {0}
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl execute
FINEST: simple execute, handler=org.postgresql.jdbc.PgStatement$StatementResultHandler@1a451d4d, maxRows=0, fetchSize=0, flags=17
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendParse
FINEST: FE=> Parse(stmt=null,query="SELECT typinput='array_in'::regproc as is_array, typtype, typname FROM pg_catalog.pg_type LEFT JOIN (select ns.oid as nspoid, ns.nspname, r.r from pg_namespace as ns join ( select s.r, (current_schemas(false))[s.r] as nspname from generate_series(1, array_upper(current_schemas(false), 1)) as s(r) ) as r using ( nspname ) ) as sp ON sp.nspoid = typnamespace WHERE typname = $1 ORDER BY sp.r, pg_type.oid DESC",oids={1043})
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendBind
FINEST: FE=> Bind(stmt=null,portal=null,$1=<'flag'>,type=VARCHAR)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendDescribePortal
FINEST: FE=> Describe(portal=null)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendExecute
FINEST: FE=> Execute(portal=null,limit=0)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl sendSync
FINEST: FE=> Sync
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE ParseComplete [null]
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE BindComplete [unnamed]
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: <=BE RowDescription(3)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(is_array,BOOL,1,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(typtype,CHAR,1,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveFields
FINEST: Field(typname,NAME,64,T)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl processResults
FINEST: <=BE DataRow(len=6)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveCommandStatus
FINEST: <=BE CommandStatus(SELECT 1)
Aug 28, 2020 1:14:24 PM org.postgresql.core.v3.QueryExecutorImpl receiveRFQ
FINEST: <=BE ReadyForQuery(I)
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getBoolean
FINEST: getBoolean columnIndex: 1
Aug 28, 2020 1:14:24 PM org.postgresql.jdbc.PgResultSet getString
FINEST: getString columnIndex: 2
Aug 28, 2020 1:14:24 PM org.postgresql.core.QueryExecutorBase close
FINEST: FE=> Terminate

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions