Tomer Shay
Tomer Shay
The SELECT clause can contain complex expressions, for example "(condition) OR (condition)", which actually returns a boolean. Sample query: `SELECT (CASE WHEN col IS NULL THEN False ELSE True END)...
Hi, I was trying to follow the instructions to get the sample js working and got the error below. Few details that might help - 1. I download the following...
When trying to import the latest Stackoverflow data files using SODDI v1.5, to MySQL 5.7, the Users table import fails with the error: `Unknown column AccountId in field list`
The following query parses ok: `SELECT JSON_OBJECTAGG( KEY foo VALUE bar) FROM dual` But this one doesn't (only change is adding prefixes to column names: `SELECT JSON_OBJECTAGG( KEY q.foo VALUE...
It seems that the parser supports single-level composite types but fails on nested multi-level composite types. Query to reproduce the parsing error: ``` SELECT (product_data::product_info_similarity).info.category AS category, COUNT(*) AS num_products...
Sample queries that lead to `NullPointerException`: `SELECT (((((((((((((((((((((((((((((((((((((((((((((((((((((((((1+1)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))); ` `SELECT abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(abs(1))))))))))))))))))))))))));`
https://www.postgresql.org/docs/18/dml-returning.html PostgreSQL 18 adds support for `OLD` and `NEW` references in a `RETURNING` statement. It could be beneficial to add support to this syntax in a more structured way, as...
**PostgreSQL official documentation:** https://www.postgresql.org/docs/current/functions-xml.html#FUNCTIONS-XML-PROCESSING-XMLTABLE **Error trying to parse:** **Steps to reproduce:** ```-- Table to store XML data CREATE TABLE xmldata ( id SERIAL PRIMARY KEY, -- optional, just for uniqueness...
`SEARCH BREADTH FIRST BY` is part of the SQL 99 extensions specification, and I believe it was implemented by PostgreSQL in v14. https://sql-99.readthedocs.io/en/latest/chapters/32.html#recursive-unions Sample query: ``` WITH RECURSIVE team_hierarchy AS...