shinyaaa opened a new issue, #2045:
URL: https://github.com/apache/age/issues/2045
## Environment
- OS: Rocky Linux 9
- PostgreSQL: REL_16_STABLE (1b9dd6b05a27ad96a027a0b8ab1e5efd418605a2)
- AGE: master (e370db34afb255236a77012882d17e3f396e7f5b)
## Summary
`make installcheck` fails in the local environment.
GitHub Actions succeeds, so there seems to be something wrong with my
environment.
`SELECT create_vlabel('graph123',
'vlabel01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678');`
should result in an ERROR, but the command succeeds after the label name is
truncated to 63 characters.
```
postgres=# SELECT create_graph('graph123');
NOTICE: 00000: graph "graph123" has been created
LOCATION: create_graph, graph_commands.c:66
create_graph
--------------
(1 row)
postgres=# SELECT create_vlabel('graph123',
'vlabel01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678');
NOTICE: 00000: VLabel
"vlabel012345678901234567890123456789012345678901234567890123456" has been
created
LOCATION: create_vlabel, label_commands.c:205
create_vlabel
---------------
(1 row)
postgres=# SELECT create_vlabel('graph123',
'vlabel01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678');
ERROR: 3F000: label
"vlabel012345678901234567890123456789012345678901234567890123456" already exists
LOCATION: create_vlabel, label_commands.c:193
```
Does anyone know the cause of this?
## Log
### `pg_config`
```
$ pg_config
BINDIR = /home/shinya/pgsql/16-age/bin
DOCDIR = /home/shinya/pgsql/16-age/share/doc
HTMLDIR = /home/shinya/pgsql/16-age/share/doc
INCLUDEDIR = /home/shinya/pgsql/16-age/include
PKGINCLUDEDIR = /home/shinya/pgsql/16-age/include
INCLUDEDIR-SERVER = /home/shinya/pgsql/16-age/include/server
LIBDIR = /home/shinya/pgsql/16-age/lib
PKGLIBDIR = /home/shinya/pgsql/16-age/lib
LOCALEDIR = /home/shinya/pgsql/16-age/share/locale
MANDIR = /home/shinya/pgsql/16-age/share/man
SHAREDIR = /home/shinya/pgsql/16-age/share
SYSCONFDIR = /home/shinya/pgsql/16-age/etc
PGXS = /home/shinya/pgsql/16-age/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--enable-debug' '--enable-cassert' '--enable-tap-tests'
'--without-icu' '--with-pgport=5416' 'CFLAGS=-std=gnu99 -ggdb -O0'
'--prefix=/home/shinya/pgsql/16-age'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Werror=vla -Wendif-labels
-Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type
-Wshadow=compatible-local -Wformat-security -fno-strict-aliasing -fwrapv
-fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g
-std=gnu99 -ggdb -O0
CFLAGS_SL = -fPIC
LDFLAGS = -Wl,--as-needed
-Wl,-rpath,'/home/shinya/pgsql/16-age/lib',--enable-new-dtags
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lz -lreadline -lm
VERSION = PostgreSQL 16.4
```
### `regression.out`
```
# using temp instance on port 61958 with PID 3722157
ok 1 - scan 258 ms
ok 2 - graphid 11 ms
ok 3 - agtype 141 ms
ok 4 - agtype_hash_cmp 8 ms
ok 5 - catalog 132 ms
ok 6 - cypher 54 ms
ok 7 - expr 914 ms
ok 8 - cypher_create 176 ms
ok 9 - cypher_match 771 ms
ok 10 - cypher_unwind 62 ms
ok 11 - cypher_set 177 ms
ok 12 - cypher_remove 97 ms
ok 13 - cypher_delete 434 ms
ok 14 - cypher_with 89 ms
ok 15 - cypher_vle 1487 ms
ok 16 - cypher_union 32 ms
ok 17 - cypher_call 43 ms
ok 18 - cypher_merge 476 ms
ok 19 - cypher_subquery 99 ms
ok 20 - age_global_graph 191 ms
ok 21 - age_load 2481 ms
ok 22 - index 113 ms
ok 23 - analyze 29 ms
ok 24 - graph_generation 87 ms
not ok 25 - name_validation 204 ms
ok 26 - jsonb_operators 120 ms
ok 27 - list_comprehension 90 ms
ok 28 - map_projection 44 ms
ok 29 - drop 440 ms
1..29
# 1 of 29 tests failed.
# The differences that caused some tests to fail can be viewed in the file
"/home/shinya/pgsql/16-age/postgresql/contrib/age/regress/regression.diffs".
# A copy of the test summary that you see above is saved in the file
"/home/shinya/pgsql/16-age/postgresql/contrib/age/regress/regression.out".
```
### `regression.diffs`
```
diff -U3
/home/shinya/pgsql/16-age/postgresql/contrib/age/regress/expected/name_validation.out
/home/shinya/pgsql/16-age/postgresql/contrib/age/regress/results/name_validation.out
---
/home/shinya/pgsql/16-age/postgresql/contrib/age/regress/expected/name_validation.out
2024-08-15 12:11:32.974396664 +0900
+++
/home/shinya/pgsql/16-age/postgresql/contrib/age/regress/results/name_validation.out
2024-08-15 14:02:27.320278775 +0900
@@ -423,29 +423,27 @@
--
-- now check vlabel creation, should fail
SELECT create_vlabel('graph123',
'vlabel01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678');
-WARNING: label name length not in range (1 <= length <= 63) length = 95
-ERROR: label name is invalid
--- should be successful
-SELECT create_vlabel('graph123',
'vlabel012345678901234567890123456789012345678901234567890123456');
NOTICE: VLabel
"vlabel012345678901234567890123456789012345678901234567890123456" has been
created
create_vlabel
---------------
(1 row)
+-- should be successful
+SELECT create_vlabel('graph123',
'vlabel012345678901234567890123456789012345678901234567890123456');
+ERROR: label
"vlabel012345678901234567890123456789012345678901234567890123456" already exists
--
-- now check elabel creation, should fail
SELECT create_elabel('graph123',
'elabel0123456789012345678901234567890123456789012345678901234567');
-WARNING: label name length not in range (1 <= length <= 63) length = 64
-ERROR: label name is invalid
--- should be okay
-SELECT create_elabel('graph123',
'elabel012345678901234567890123456789012345678901234567890123456');
NOTICE: ELabel
"elabel012345678901234567890123456789012345678901234567890123456" has been
created
create_elabel
---------------
(1 row)
+-- should be okay
+SELECT create_elabel('graph123',
'elabel012345678901234567890123456789012345678901234567890123456');
+ERROR: label
"elabel012345678901234567890123456789012345678901234567890123456" already exists
-- clean up
SELECT drop_graph('graph123', true);
NOTICE: drop cascades to 20 other objects
```
--
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]
