Bug 123838 - Issue on CAST() (FirebirdSQL)
Summary: Issue on CAST() (FirebirdSQL)
Status: RESOLVED NOTABUG
Alias: None
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: https://www.nspgov.in/
Whiteboard:
Keywords: perf, regression
Depends on:
Blocks:
 
Reported: 2019-03-04 12:32 UTC by perie_gut
Modified: 2022-11-29 10:40 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

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
Thanks a lot for sharing this information. It is through this post I came to understand the importance of the cast(). I think the suggestion shared by other users on fixing the issue of the cast() is helpful. I haven't tried it yet. Hope it is helpful. https://privatetoursofdc.com/washington-dc-tour/unique-attractions-to-visit-when-on-washington-dc-bus-tours/
Comment 5 Jennifer Johns 2020-06-28 04:11:11 UTC
The site offers great options to get solutions to bugs encountered in LibreOffice. Online office application benefits are way greater compared to Microsoft Office and are free to use and also offer some limitations to the features available. https://mashtips.com/online-office-applications-benefits/
Comment 6 Alica Megan 2020-12-14 17:45:20 UTC
VMC is a multi-specialty hospital and the best IVF centre located in Kochi, which is focused on Infertility, Obstetrics & Gynaecology, Neonatology, Pediatrics, ENT surgery and Breast Onco-Surgery. We provide the best infertility treatment in Kerala and we have high quality facilities like high-risk pregnancy care and advanced infertility treatments. http://www.vmchospital.com/specialities/infertility-and-artificial-reproductive-techniques
Comment 7 Alex Paul 2021-06-07 17:00:14 UTC
Fertility is defined as the natural capacity to conceive a child. However, fertility does not come easily to everyone. https://www.akshayahospital.in/departments/laparoscopic-surgery-in-kochi About 11% of couples will face infertility—the inability to conceive naturally after one year of unprotected sexual intercourse. 1 Fertility is not only a female health issue.
Comment 8 priya singh 2022-09-09 16:00:29 UTC
escorts super-sexy Bangalore Call Girls, but they’re also really friendly, fun and easy to get along with – which makes them the perfect date for anyone who wants to spend some quality time with an exciting partner in their city. Whether you want a naughty night in or are looking to book an adventurous weekend away, we’ve got all kinds of hot female partners who can fulfill your fantasies and provide you with the adult entertainment that you crave!
Comment 9 riya singh 2022-09-09 20:02:22 UTC
Call girls chennai is a leading provider of premium call girls chennai We are known for our excellent service and quality. We offer services such as outcall call girl, incall call girl, call girl in chennai, call girl in chennai, Independent girl call girl Chennai.
Website: https://www.callgirlschennai.net/
Comment 10 priya singh 2022-09-09 20:04:30 UTC
> escorts super-sexy Bangalore Call Girls, but they’re also really friendly,
> fun and easy to get along with – which makes them the perfect date for
> anyone who wants to spend some quality time with an exciting partner in
> their city. Whether you want a naughty night in or are looking to book an
> adventurous weekend away, we’ve got all kinds of hot female partners who can
> fulfill your fantasies and provide you with the adult entertainment that you
> crave! https://www.bangalorecallgirls.net/
Comment 11 tinkus23 2022-09-26 15:05:31 UTC
"Welcome to the most sought after & trusted Spa Massage Web Portal in India.
Bored of the same old busy life? The most reliable body massage parlours and spa centers contact details can be found on the Massagespaindia.com website. 
Our website shows up in top search results when people search for online spas in Pune or massages in Mumbai, for example. Spas centers offering genuine massage services that will give you the thrill of living your dreams and relax your body & mind.
You need love and satisfaction, and we understand that. That's what we do best. Visit our website and browse by city to find your nearest spa and massage centers. Hurry up, Ganpati offers ongoing 1-hour full body massage spa services. "
website: https://massagespaindia.com/massage-spa-in-pune
Comment 12 Parul Singh 2022-09-28 05:53:34 UTC
There's no doubt that Call girls Kolkata are the best in India. These girls are known for their beauty, intelligence, wit, and charisma. You'll be blown away by their looks and style. They have a knack for dressing to impress! You'll feel like royalty when you go out on the town with one of these beauties by your side. There is no way that you will regret hiring one of these sexy girl as your escort for the night!
Website: https://callgirlkolkata.net/call-girls/ | https://callgirlkolkata.net/
Comment 13 massage 2022-11-04 11:07:33 UTC
Created attachment 183406 [details]
massage

Guys just sharing, I've found this interesting! Check it out!

https://www.eroticmassageworld.com/