From the admin doc, it says one of the characteristics of default automatic projections is that "If created as a result of a CREATE TABLE AS SELECT statement, uses the encoding specified in the query table."
However, in practice, this does not seem to be the case.
Code: Select all
dbadmin=> create table public.test (c1 int encoding rle);
CREATE TABLE
dbadmin=> create table public.test1 as select * from public.test;
CREATE TABLE
dbadmin=> select export_objects('','public.test');
export_objects
-------------------------------------------------------
CREATE TABLE public.test
(
c1 int
);
CREATE PROJECTION public.test /*+createtype(P)*/
(
c1 ENCODING RLE
)
AS
SELECT test.c1
FROM public.test
ORDER BY test.c1
SEGMENTED BY hash(test.c1) ALL NODES KSAFE 1;
SELECT MARK_DESIGN_KSAFE(1);
(1 row)
dbadmin=> select export_objects('','public.test1');
export_objects
-------------------------------------------------------
CREATE TABLE public.test1
(
c1 int
);
CREATE PROJECTION public.test1 /*+createtype(A)*/
(
c1
)
AS
SELECT test1.c1
FROM public.test1
ORDER BY test1.c1
SEGMENTED BY hash(test1.c1) ALL NODES KSAFE 1;
SELECT MARK_DESIGN_KSAFE(1);
(1 row)
Am I misunderstanding the doc?