Comments (2)
Reduced:
CREATE TABLE table_4 (col4_4 INTERVAL NOT NULL);
INSERT INTO table_4 (col4_4) VALUES ('-25 years -5 mons -603 days -13:24:30.320188'::INTERVAL);
SET testing_optimizer_random_seed = 7752040155325291373;
SET testing_optimizer_disable_rule_probability = 0.500000;
SELECT ('1'::JSONB::DECIMAL * (col4_4 * 378072678156544910::INT8))::INTERVAL FROM table_4;
RESET testing_optimizer_random_seed;
RESET testing_optimizer_disable_rule_probability;
SELECT ('1'::JSONB::DECIMAL * (col4_4 * 378072678156544910::INT8))::INTERVAL FROM table_4;
Present on 23.2.5 and 24.1.0, so not a regression. Postgres returns interval out of range
during the multiplication.
from cockroach.
Fundamentally, this is a dup of #26932. The difference between two executions occurs because in one plan we keep the cast from JSON to DECIMAL which makes us use Duration.MulFloat
for multiplication, and in another plan we use integer multiplication. I'll send a small patch to special case Duration.MulFloat
when multiplying by 1 to prevent this failure for hitting again.
from cockroach.
Related Issues (20)
- pkg/sql/schemachanger/scbuild/scbuild_test: TestBuildDataDriven failed
- roachtest: failover/chaos/read-only failed HOT 1
- kv/kvserver: TestFlowControlRaftMembership failed
- ccl/changefeedccl: TestChangefeedSchemaChangeBackfillCheckpoint failed
- sql: TestShowRangesMultipleStores failed
- pkg/ccl/testccl/sqlccl/sqlccl_test: TestCancelMultipleSessions failed
- pkg/ccl/testccl/sqlccl/sqlccl_test: TestCancelMultipleSessions failed HOT 1
- ccl/sqlproxyccl: TestFailedConnection failed
- : failed HOT 1
- kv/kvnemesis: TestKVNemesisMultiNode failed
- : failed
- roachtest: schemachange/mixed-versions failed HOT 1
- roachtest: backup/2TB/n10cpu4 failed HOT 1
- roachtest: sql-stats/mixed-version failed
- ccl/backupccl: TestDataDriven_user_defined_functions_in_defaults failed HOT 1
- pkg/ccl/testccl/workload/schemachange/schemachange_test: TestWorkload failed [duplicate key value violates unique constraint] HOT 4
- roachtest: c2c/tpcc/warehouses=500/duration=10/cutover=0 failed [azure failure] HOT 1
- util/log: TestHTTPSinkContentTypePlainText failed
- ccl/schemachangerccl: TestBackupSuccess_base_drop_column_basic failed
- ccl/multiregionccl: TestMultiRegionDataDriven failed
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.
from cockroach.