[Logic Bug] A Sepcial SQL Brings Errors ( SELECT * FROM <table> WHERE <column> BETWEEN <column> AND (CAST(<decimal> AS MONEY)) ) about pg-strom HOT 1 OPEN qwebug commented on August 22, 2024 [Logic Bug] A Sepcial SQL Brings Errors ( SELECT * FROM WHERE BETWEEN AND (CAST( AS MONEY)) )from pg-strom. Comments (1) kaigai commented on August 22, 2024 This query also uses numeric --> money cast, so 1f9fad1749fe22bce33d7a3a30b85ec550081b41 should fix it. I could not reproduce the problem at the latest commit.from pg-strom. Related Issues (20) [Error Bug] SELECT MIN(<column>) FROM table GROUP BY <column> HAVING CAST((MIN('1')) AS BOOLEAN) Brings Errors HOT 2 [Error Bug] SELECT MAX(<column>) FROM table GROUP BY <column> HAVING <column> < MIN(<column>) Brings Errors HOT 4 [GPU Error Bug] SELECT <column> FROM table GROUP BY <column> HAVING NOT (MIN(integer > 65535 ))::BOOLEAN Brings GPU Errors HOT 2 [GPU Logic Bug] SELECT MIN(1) FROM table GROUP BY <column> HAVING NOT (MIN(1))::BOOLEAN Brings Errors HOT 2 [GPU Logic Bug] A Sepcial SQL Brings Errors ( SELECT MIN(<column>) FROM table LEFT OUTER JOIN (SELECT <column> FROM table) AS sub0 ON (<column> > 0) GROUP BY (<column>) HAVING TRUE; ) HOT 2 (VTJ-JP)Server terminated by gorup by on geo column HOT 3 (VTJ-JP)Error occured at checking null in geom column HOT 4 [GPU ERROR Bug] A Sepcial SQL Brings GPU Errors ( SELECT (length(<column>) IN (<decimal>, <decimal>))::INT FROM <table> CROSS JOIN <table> WHERE length(<column>) IN (<column>) ) HOT 1 [ERROR Bug] A Sepcial SQL Brings Errors ( SELECT * FROM <table> LEFT OUTER JOIN <table> ON FALSE CROSS JOIN (SELECT * FROM <table> WHERE TRUE ORDER BY <column> ASC, <column> DESC) AS sub ) HOT 1 [ERROR Bug] A Sepcial SQL Brings Errors ( SELECT * FROM <table> RIGHT OUTER JOIN <table> ON (<column>::INT) IS NULL ) HOT 1 [ERROR Bug] A Sepcial SQL Brings Errors ( SELECT ((<column> BETWEEN SYMMETRIC <integer> AND <integer>)OR((<decimal>::MONEY) IN (CAST(<decimal> AS MONEY), CAST(<decimal> AS MONEY)))) FROM <table> WHERE (<column>) BETWEEN SYMMETRIC (<integer>) AND (<column>) ) HOT 2 [GPU ERROR Bug] A Sepcial SQL Brings Errors ( SELECT ('<interval>'::int4range), <column>::INT FROM <table> WHERE (<column>!=<column>) ) HOT 2 [GPU Logic Bug] A Sepcial SQL Brings Errors ( SELECT * FROM <table> WHERE (<column> IS NOT DISTINCT FROM <column>) IS TRUE ) HOT 2 [GPU Logic Bug] A Sepcial SQL Brings Errors ( SELECT <column> FROM <table> WHERE <column> BETWEEN SYMMETRIC <column> AND (<decimal>::MONEY) ) HOT 4 [Logic Bug] A Sepcial SQL Brings Errors ( SELECT * FROM <table> WHERE ( (<column> is null )::INT IS NOT DISTINCT FROM <column>) OR <column> ) HOT 1 Compile ERROR HOT 7 (VTJ-JP) heterodb-extra 5.xで旧製品のライセンスが無効化されてGDSが利用できなくなる HOT 6 (VTJ-JP) PG-Strom 5.x + PostgreSQL 16 Not working (VTJ-JP)Crash on select count, max, min, sum HOT 15 Recommend Projects React A declarative, efficient, and flexible JavaScript library for building user interfaces. Vue.js 🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web. Typescript TypeScript is a superset of JavaScript that compiles to clean JavaScript output. TensorFlow An Open Source Machine Learning Framework for Everyone Django The Web framework for perfectionists with deadlines. Laravel A PHP framework for web artisans D3 Bring data to life with SVG, Canvas and HTML. 📊📈🎉 Recommend Topics javascript JavaScript (JS) is a lightweight interpreted programming language with first-class functions. web Some thing interesting about web. New door for the world. server A server is a program made to process requests and deliver data to clients. Machine learning Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently. Visualization Some thing interesting about visualization, use data art Game Some thing interesting about game, make everyone happy. Recommend Org Facebook We are working to build community through open source technology. NB: members must have two-factor auth. Microsoft Open source projects and samples from Microsoft. Google Google ❤️ Open Source for everyone. Alibaba Alibaba Open Source for everyone D3 Data-Driven Documents codes. Tencent China tencent open source team.
Comments (1) kaigai commented on August 22, 2024 This query also uses numeric --> money cast, so 1f9fad1749fe22bce33d7a3a30b85ec550081b41 should fix it. I could not reproduce the problem at the latest commit.from pg-strom.
Vue.js 🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
javascript JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Machine learning Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Facebook We are working to build community through open source technology. NB: members must have two-factor auth.
from pg-strom.
Comments (1)
This query also uses numeric --> money cast, so
1f9fad1749fe22bce33d7a3a30b85ec550081b41
should fix it.I could not reproduce the problem at the latest commit.
from pg-strom.
Related Issues (20)
Recommend Projects
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
Recommend Topics
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web
Some thing interesting about web. New door for the world.
server
A server is a program made to process requests and deliver data to clients.
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization
Some thing interesting about visualization, use data art
Game
Some thing interesting about game, make everyone happy.
Recommend Org
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.