Bug 123838 (Mahajan, Priti) - Issue on CAST() (FirebirdSQL)
Summary: Issue on CAST() (FirebirdSQL)
Status: CLOSED NOTABUG
Alias: Mahajan, Priti
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.2.1.1 rc
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-03-04 12:32 UTC by perie_gut
Modified: 2023-11-04 12:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
massage (1.06 MB, text/html)
2022-11-04 11:07 UTC, massage 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description perie_gut 2019-03-04 12:32:10 UTC 
error on the CAST 

1. create a table 
2. create a query in SQL View. 

CAST(SUM(fieldname)) as numeric(10,2)
Comment 1 Robert Großkopf 2019-03-05 06:43:45 UTC 
(In reply to perie_gut from comment #0)
> error on the CAST 
> 
> 1. create a table 
> 2. create a query in SQL View. 
> 
> CAST(SUM(fieldname)) as numeric(10,2)

This is the wrong code. numeric(10,2) isn't a part of the CAST-function in the code. Try
CAST(SUM("fieldname") as numeric(10,2))

Works here as expected with LO 6.1.5.2 on OpenSUSE 15 64bit rpm Linux.
Comment 2 Alex Thurgood 2019-03-05 07:21:01 UTC 
Indeed, CAST works for me in the following example :

select CAST(("Zip") as NUMERIC(10,2)) from "Employee Table"

Version: 6.1.5.2
Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805
Threads CPU : 8; OS : Mac OS X 10.14.2; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group threaded
Comment 3 Alex Thurgood 2019-03-05 09:45:20 UTC 
Also works in
Version: 6.2.0.3
Build ID: 98c6a8a1c6c7b144ce3cc729e34964b47ce25d62
Threads CPU : 8; OS : Mac OS X 10.14.2; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded
Comment 4 Kaitlyn 2020-02-24 07:30:51 UTC Comment hidden (spam)
Comment 5 Jennifer Johns 2020-06-28 04:11:11 UTC Comment hidden (spam)
Comment 6 Alica Megan 2020-12-14 17:45:20 UTC Comment hidden (spam)
Comment 7 Alex Paul 2021-06-07 17:00:14 UTC Comment hidden (spam)
Comment 8 priya singh 2022-09-09 16:00:29 UTC Comment hidden (spam)
Comment 9 riya singh 2022-09-09 20:02:22 UTC Comment hidden (spam)
Comment 10 priya singh 2022-09-09 20:04:30 UTC Comment hidden (spam)
Comment 11 tinkus23 2022-09-26 15:05:31 UTC Comment hidden (spam)
Comment 12 Parul Singh 2022-09-28 05:53:34 UTC Comment hidden (spam)
Comment 13 massage 2022-11-04 11:07:33 UTC Comment hidden (spam)
Comment 15 David Marcus 2023-10-31 10:13:18 UTC Comment hidden (spam)
Comment 16 David Marcus 2023-10-31 10:14:30 UTC Comment hidden (spam)
Comment 17 David Marcus 2023-10-31 10:16:51 UTC Comment hidden (spam)
Comment 19 Priti Mahajan 2023-11-04 08:25:40 UTC Comment hidden (spam)
Comment 20 Priti Mahajan 2023-11-04 08:26:00 UTC Comment hidden (spam)
Comment 21 Priti Mahajan 2023-11-04 08:26:21 UTC Comment hidden (spam)
Comment 22 Priti Mahajan 2023-11-04 08:27:29 UTC Comment hidden (spam)