View Issue Details

IDProjectCategoryView StatusLast Update
0008516VALENTINA STUDIOTool - SQL Editorpublic2019-05-09 19:40
Reporterneil@neilcollc.com Assigned ToSergey Pashkov  
PriorityurgentSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
PlatformINTELOSWindowsOS Version10
Product Version8.2.x 
Target Version9.1.xFixed in Version9.1.x 
Summary0008516: SQL-Server Query returns inconsistent results instead of error.
DescriptionA query that causes a divide by zero error returns an inconsistent result set instead of displaying an error.
Steps To ReproduceCreate the following table:

create table test (item varchar(256), cost decimal(18,4), price decimal(18,4));
insert into test(item, cost, price) values ('item1', 50.50, 60.99);
insert into test(item, cost, price) values ('item2', 60.50, 61.99);
insert into test(item, cost, price) values ('item3', 70.50, 65.99);
insert into test(item, cost, price) values ('item4', 10, 10);
insert into test(item, cost, price) values ('item5', 10, 0);

This query should return an error but instead returns an empty result set.

select item, cost, price, (price-cost)/price as margin from test order by price;
TagsNo tags attached.
Working with DB:SQL Server
Version of your DBSQL Server 2016

Activities

Sergey Pashkov

Sergey Pashkov

2019-05-09 19:40

developer   ~0010800

Fix will be available in version 9.1.5

Issue History

Date Modified Username Field Change
2019-05-01 03:57 neil@neilcollc.com New Issue
2019-05-01 10:46 Sergey Pashkov Assigned To => Sergey Pashkov
2019-05-01 10:46 Sergey Pashkov Status new => confirmed
2019-05-09 19:40 Sergey Pashkov Status confirmed => resolved
2019-05-09 19:40 Sergey Pashkov Resolution open => fixed
2019-05-09 19:40 Sergey Pashkov Fixed in Version => 9.1.x
2019-05-09 19:40 Sergey Pashkov Target Version => 9.1.x
2019-05-09 19:40 Sergey Pashkov Note Added: 0010800