Unity editor rounds down floats to integers when retrieved from realtime database when locale is not en_US.utf8

[Havard-SL]

Please fill in the following fields:

Unity editor version: 2019.2.6f1, 2019.2.10f1, 2019.3.0b10, 2020.1.0a12
Firebase Unity SDK version: 6.6.0
Firebase plugins in use: Only Database
Additional SDKs you are using: None
Platform you are using the Unity editor on: Linux, ubuntu 19.10 on two different machines
Platform you are targeting (iOS, Android, and/or desktop): Android
Scripting Runtime (Mono, and/or IL2CPP): Mono (I believe)

Please describe the issue here:

(Please list the full steps to reproduce the issue. Include device logs, Unity logs, and stack traces if available.)

1. Create a new firebase realtime database.
2. Create a new floating point value
3. Try to retrieve that value - it will be rounded down.

Here is an example script that you can just attach to any object that gets loaded and test the issue:

using System.Collections;
using System.Collections.Generic;
using UnityEngine;

using Firebase;
using Firebase.Unity.Editor;
using Firebase.Database;

public class test: MonoBehaviour {
  void Start() {
    // Set this before calling into the realtime database.
    FirebaseApp.DefaultInstance.SetEditorDatabaseUrl("https://unity-test-9f7cc.firebaseio.com/");
    
    DatabaseReference reference = FirebaseDatabase.DefaultInstance.RootReference;
    Debug.Log("Aigt imma head in");
        FirebaseDatabase.DefaultInstance
      .GetReference("test")
      .GetValueAsync().ContinueWith(task => {
        if (task.IsFaulted) {
          // Handle the error...
          Debug.Log("Error");
        }
        else if (task.IsCompleted) {
          DataSnapshot snapshot = task.Result;
          // Do something with snapshot...
          Debug.Log(snapshot);
        }
      });
  }
}

Expected output: "Aight imma head in" and "key:"test",value:2.69"
Tested output: "Aight imma head in" and "key:"test",value:2"

Could this be linked to the fact that i have (quite disgustingly) downloaded the libssl.1.0.2 and install it in order to circumvent this issue:

https://forum.unity.com/threads/empty-log-errors-in-2019-1-0f2.669961/
https://issuetracker.unity3d.com/issues/linux-roslyn-fails-if-there-is-a-newer-libssl-than-1-dot-0

Because ubuntu 19.04 and newer come with libssl-1.1.0, and there is no libssl-1.0.0 in the repositories.

Please answer the following, if applicable:

Have you been able to reproduce this issue with just the Firebase Unity quickstarts (this GitHub project)?
Sorry, I have not tried.

What's the issue repro rate? (eg 100%, 1/5 etc)
100%

[muflub]

Hi @Havard-SL,

I tested this using C++ library on desktop, Unity library on desktop and Unity library on Android and got the same output each time for my test: DataSnapshot { key = test, value = 3.14156 }.

Are you able to provide a screen shot of your firebase database console showing the data you have?
Are you able to use GetRawJsonValue and dump the correct value in json?

Edit: One thing to note is I was using the latest release 6.7.0 and not 6.6.0.
Edit 2: Can you please turn on verbose logging and check to see what value is sent on the wire.

Add this to the start of the start function:

        FirebaseApp.LogLevel = LogLevel.Verbose;
        FirebaseDatabase.DefaultInstance.LogLevel = LogLevel.Verbose;

Should see this log line:

[pc_0] handleServerMessage d {"d":2.69,"p":"test"}

[Havard-SL]

Thank you for your quick response, and sorry for my slow response!

First of all, I updated my firebase SDK to version 6.7.0, but the issue still persisted.

I am not sure if I implemented it correctly but GetRawJsonValue just gave me "2" in the debug log,

And lastly, weirdly enough, the log line I got was reading:

[pc_4] handleServerMessage d {"d":2,"p":"test"}

Thank you for trying to help me, I really appreciate it!

[muflub]

That message you replied with is the raw response Firebase gets over the wire. Thus it looks like the data stored in Firebase real time database is an integer not a double and thus not a problem with the SDK. Please check the logic you use to save the values and ensure types are correct for storing floating point numbers (should be using double).

[Havard-SL]

I have attached a picture of my firebase realtime database and unity side by side:

Here you can see that I have stored the variable as a float, and my only database rules are:

{
  "rules": {
    ".read": true,
    ".write": false
  }
}

I have no clue why this happens, any help would be appreciated!

[alexames]

Can you show us the code that you're using to set the value? Edit: Ignore that, I misread the situation. I suspected that there might be some issue with setting the value in the database, but that doesn't appear to be the case. I'm puzzled again now.

[chkuang-g]

Hi @Havard-SL

Could you provide more logs? Yo can find your Editor log here
https://docs.unity3d.com/Manual/LogFiles.html

Also, the snippet of code about how you call into database API would be very helpful.

Here is what I read from your screenshot.
There is a mysterious request 1 sent before the listen request.
Then there is a listen request 2
And the response for mysterious request 1 is received with value 2 at "test". This seems to trigger the listener with value 2 and removed the listen id.
When response for request 2 is received, it cannot do anything. And I cannot see what the actual response message is from your screenshot.

I suspect you might have done something like but I cannot confirm with your screenshot.

ref.SetValueAsync(2);
ref.GetValueAsync().ContinueWith(task => {
  Debug.Log(task.Result);
});

So, please provide more information. Thank you!

[google-oss-bot]

Hey @Havard-SL. We need more information to resolve this issue but there hasn't been an update in 7 days. I'm marking the issue as stale and if there are no new updates in the next 3 days I will close it automatically.

If you have more information that will help us get to the bottom of this, just add a comment!

[Havard-SL]

I am extremely sorry for the late response, but thank you all for trying to help!

I've been busy studying for a final, so I had to focus on some other things, but I would be happy to answer any questions now!!

@chkuang-g Ive made a gist of my Editor.log placed in my ~/.config/unity3d/ folder:
https://gist.github.com/Havard-SL/c7fa8d760ec403c4373c6315af63815f

The current code I'm using to access the realtime database right now is almost the same as the one in my original issue description:

using System.Collections;
using System.Collections.Generic;
using UnityEngine;

using Firebase;
using Firebase.Unity.Editor;
using Firebase.Database;


public class test: MonoBehaviour {
  void Start() {
    FirebaseApp.LogLevel = LogLevel.Verbose;
    FirebaseDatabase.DefaultInstance.LogLevel = LogLevel.Verbose;

    // Set thistask before calling into the realtime database.
    FirebaseApp.DefaultInstance.SetEditorDatabaseUrl("https://unity-test-9f7cc.firebaseio.com/");
    
    DatabaseReference reference = FirebaseDatabase.DefaultInstance.RootReference;
    Debug.Log("Aigt imma head in");
      FirebaseDatabase.DefaultInstance
      .GetReference("test")
      .GetValueAsync().ContinueWith(task => {
        if (task.IsFaulted) {
          // Handle the error...
          Debug.Log("Error");
        }
        else if (task.IsCompleted) {
          DataSnapshot snapshot = task.Result;
          // Do something with snapshot...
          Debug.Log(snapshot.GetRawJsonValue());
        }
      });
  }
}

This is almost directly copied from the Unity firebase starter guide, but including all changes people have suggested here.

If you want more screenshots I would be happy to share, but I dont know what part of the console output contains the relevant information!

I am very grateful for your help!
-Håvard

[google-oss-bot]

Since there haven't been any recent updates here, I am going to close this issue.

@Havard-SL if you're still experiencing this problem and want to continue the discussion just leave a comment here and we are happy to re-open this.