Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error Retrieving values of FLOAT types columns #64

Open
akhtar-a opened this issue May 30, 2024 · 7 comments
Open

Error Retrieving values of FLOAT types columns #64

akhtar-a opened this issue May 30, 2024 · 7 comments

Comments

@akhtar-a
Copy link

Screenshot 2024-05-30 at 10 18 54 AM Screenshot 2024-05-30 at 10 15 50 AM Screenshot 2024-05-30 at 10 14 32 AM

response.getLong() , .getString , getBytes nothing works, I am not able to retrieve the value, It also Shows unknown in the debugger

@akhtar-a
Copy link
Author

@ostafen Any Idea how do we actually get FLOAT values ?

@akhtar-a
Copy link
Author

Screenshot 2024-05-30 at 4 08 34 PM

@ostafen
Copy link
Contributor

ostafen commented May 30, 2024

Thank you for opening the issue, I will check

@akhtar-a
Copy link
Author

akhtar-a commented Dec 5, 2024

@ostafen Any Updates on this ?

@ostafen
Copy link
Contributor

ostafen commented Dec 5, 2024

@akhtar-a, we are working on it and it will be released shortly.
As a temporary solution, you can CAST FLOAT to VARCHAR when returning the column and then parse it from string directly in the code.

@akhtar-a
Copy link
Author

akhtar-a commented Dec 5, 2024

@ostafen Yes we have done that only for now, I wanted to increment and avoid multiple reads which is not possible as of now with VARCHAR type of values

UPDATE table
value = value + float(SOME FLOAT NUMNER)
where id=1
So would be great to have this. 🥇

@ostafen
Copy link
Contributor

ostafen commented Dec 5, 2024

You don't have to store the column as VARCHAR.
You cast store it as FLOAT and cast it to VARCHAR while specifying target expressions on the select statement.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants