lss602726449 commented on issue #1466:
URL: https://github.com/apache/cloudberry/issues/1466#issuecomment-3771291390
I tested using -O3 and -ftree-vectorize as configure options, and it seems
the problem doesn't occur with these settings. Furthermore, theoretically,
this type of error shouldn't be related to the optimization level. Could you
please provide the SQL statement that caused the error and the steps to
reproduce the issue.
```
[gpadmin@hashdata cloudberrydb]$ psql postgres -p 7000
psql (14.4, server 14.4)
Type "help" for help.
postgres=# select version();
version
-----------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------
PostgreSQL 14.4 (Apache Cloudberry 3.0.0-devel+dev.2219.gc80e93d4d57 build
dev) on x86_64-pc-linux-gnu, compiled by gc
c (GCC) 10.2.1 20210130 (Red Hat 10.2.1-11), 64-bit compiled on Jan 20 2026
14:29:00 (with assert checking)
(1 row)
postgres=# quit
[gpadmin@hashdata cloudberrydb]$ pg_config
BINDIR = /home/gpadmin/cbdb_2/bin
DOCDIR = /home/gpadmin/cbdb_2/share/doc/postgresql
HTMLDIR = /home/gpadmin/cbdb_2/share/doc/postgresql
INCLUDEDIR = /home/gpadmin/cbdb_2/include
PKGINCLUDEDIR = /home/gpadmin/cbdb_2/include/postgresql
INCLUDEDIR-SERVER = /home/gpadmin/cbdb_2/include/postgresql/server
LIBDIR = /home/gpadmin/cbdb_2/lib
PKGLIBDIR = /home/gpadmin/cbdb_2/lib/postgresql
LOCALEDIR = /home/gpadmin/cbdb_2/share/locale
MANDIR = /home/gpadmin/cbdb_2/share/man
SHAREDIR = /home/gpadmin/cbdb_2/share/postgresql
SYSCONFDIR = /home/gpadmin/cbdb_2/etc/postgresql
PGXS = /home/gpadmin/cbdb_2/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/home/gpadmin/cbdb_2' '--with-openssl'
'--enable-cassert' '--enable-debug' '-with-libxml' '-with-python' 'CFLAGS=-O3
-ftree-vectorize' 'CXXFLAGS=-O3 -ftree-vectorize'
'PKG_CONFIG_PATH=/opt/rh/rh-ruby27/root/usr/local/lib64/pkgconfig:/opt/rh/rh-ruby27/root/usr/lib64/pkgconfig:/opt/rh/llvm-toolset-7.0/root/usr/lib64/pkgconfig:/opt/rh/devtoolset-10/root/usr/lib64/pkgconfig:/opt/rh/rh-ruby27/root/usr/local/lib64/pkgconfig:/opt/rh/rh-ruby27/root/usr/lib64/pkgconfig:/opt/rh/llvm-toolset-7.0/root/usr/lib64/pkgconfig:/opt/rh/devtoolset-10/root/usr/lib64/pkgconfig:/opt/rh/rh-ruby27/root/usr/local/lib64/pkgconfig:/opt/rh/rh-ruby27/root/usr/lib64/pkgconfig:/opt/rh/llvm-toolset-7.0/root/usr/lib64/pkgconfig:/opt/rh/devtoolset-10/root/usr/lib64/pkgconfig'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Werror=vla
-Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3
-Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv
-fexcess-precision=standard -Wno-unused-but-set-variable
-Werror=implicit-fallthrough=3 -Wno-format-truncation -Wno-stringop-truncation
-g -O3 -ftree-vectorize -fPIC -DUSE_INTERNAL_FTS=1 -Werror=uninitialized
-Werror=implicit-function-declaration -Werror
CFLAGS_SL = -fPIC
LDFLAGS = -Wl,--as-needed
-Wl,-rpath,'/home/gpadmin/cbdb_2/lib',--enable-new-dtags -Werror
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lxerces-c -lbz2 -lxml2 -lrt -lssl -lcrypto -lz
-lreadline -lpthread -lrt -ldl -lm -lcurl -lzstd
VERSION = PostgreSQL 14.4
[gpadmin@hashdata cloudberrydb]$ psql postgres -p 7000
psql (14.4, server 14.4)
Type "help" for help.
postgres=# create table test(a int);
NOTICE: Table doesn't have 'DISTRIBUTED BY' clause -- Using column named
'a' as the Apache Cloudberry data distribution key for this table.
HINT: The 'DISTRIBUTED BY' clause determines the distribution of data. Make
sure column(s) chosen are the optimal data distribution key to minimize skew.
CREATE TABLE
postgres=# insert into test values(1);
INSERT 0 1
postgres=# select * from test;
a
---
1
(1 row)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
