Profiling: OBJECT_SCHEMA is empty for CREATE TABLE AS and SELECT INTO statements

Detail name	Value
Changelog Number	11510
Type	Bug
Status	Open
Affected Versions	Exasol 6.2.0, Exasol 7.0.0, Exasol 7.1.0, Exasol 8.0.0, Exasol 8.29.0, Exasol 2025.1.0, Exasol 2025.2.0

Description

The name of the schema is missing in the column OBJECT_SCHEMA in profiling if one of the conditions is met:

• A table is created with CREATE TABLE AS 
• Data is inserted into a table with SELECT INTO TABLE 

 

Preparation:

CREATE SCHEMA test;
CREATE TABLE TEST.T1 (C1 INT);
ALTER SESSION SET PROFILE='on';

 

Example 1 with CREATE TABLE AS:

CREATE TABLE y AS SELECT * FROM values 1,2,3,4,5 as T(x);

 

Example 2 with SELECT INTO TABLE

select * into table TEST.T1 from ( values 1,2,3,4,5 as T(x));

 

In profiling, the name of the schema is missing in column OBJECT_SCHEMA

flush statistics;
SELECT * FROM EXA_DBA_PROFILE_LAST_DAY ORDER BY STMT_ID, PART_ID;

Workaround

There is no workaround.

Fix

The OBJECT_SCHEMA column contains the schema name.