yurifari opened a new issue, #1124:
URL: https://github.com/apache/age/issues/1124

   **Describe the bug**
   When querying a table which is using a [PostgreSQL System Information 
Functions and 
Operators](https://www.postgresql.org/docs/current/functions-info.html) name, 
the server hits a segmentation fault and crashes.
   
   For example, querying a table called `user`, will result in a segmentation 
fault. This because `user` is a system function.
   The same behaviour will be triggered using any other system function name, 
e.g.: `current_user`.
   
   **Workaround**: Surrounding the table name with quotes will prevent the 
issue from happening.
   
   **How are you accessing AGE (Command line, driver, etc.)?**
   - Command line / psql
   
   **What data setup do we need to do?**
   1. Run the server
   `docker run --rm --name age -e POSTGRES_USER=postgresUser -e 
POSTGRES_PASSWORD=postgresPW -e POSTGRES_DB=postgresDB apache/age`
   2. Run the client
   `docker exec -ti age psql 
postgresql://postgresUser:ddpostgresPW@localhost/postgresDB`
   
   **What is the command that caused the error?**
   ```pgsql
   SELECT * FROM user;
   ```
   ```
   server closed the connection unexpectedly
           This probably means the server terminated abnormally
           before or while processing the request.
   The connection to the server was lost. Attempting reset: Failed.
   !?> 
   ```
   
   **Expected behavior**
   PostgreSQL using the Age extension should behave in the same way it does 
without it. It should perform the query on the `user` table.
   In this case in particular, since the database is empty, it should notify 
that the relation `user` does not exist.
   
   **Environment (please complete the following information):**
   - Current master (PostgreSQL 14.8 (Debian 14.8-1.pgdg120+1) on 
x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit)


-- 
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: dev-unsubscr...@age.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to