Postgres driver: error on creating non-string properties

[docbacardi]

ArcadeDB Version: 22.12.1-SNAPSHOT

JDK Version: openjdk version "11.0.17" 2022-10-18

OS: Ubuntu 22.04.1 LTS

Expected behavior

I have a vertex type with several properties:

chicken@asteroid:~$ psql --host=localhost testdatabase root
Password for user root: 
psql (14.5 (Ubuntu 14.5-0ubuntu0.22.04.1), server 10.5)
Type "help" for help.

testdatabase=> CREATE VERTEX TYPE v;
     operation      | typeName 
--------------------+----------
 create vertex type | v
(1 row)

INSERT 0 1
testdatabase=> CREATE PROPERTY v.s STRING;
    operation    | typeName | propertyName 
-----------------+----------+--------------
 create property | v        | s
(1 row)

testdatabase=> CREATE PROPERTY v.i INTEGER;
    operation    | typeName | propertyName 
-----------------+----------+--------------
 create property | v        | i
(1 row)

testdatabase=> CREATE PROPERTY v.b BOOLEAN;
    operation    | typeName | propertyName 
-----------------+----------+--------------
 create property | v        | b
(1 row)

testdatabase=> CREATE PROPERTY v.sh SHORT;
    operation    | typeName | propertyName 
-----------------+----------+--------------
 create property | v        | sh
(1 row)

testdatabase=> CREATE PROPERTY v.d DOUBLE;
    operation    | typeName | propertyName 
-----------------+----------+--------------
 create property | v        | d
(1 row)

testdatabase=> CREATE PROPERTY v.da DATETIME;
    operation    | typeName | propertyName 
-----------------+----------+--------------
 create property | v        | da
(1 row)

A new vertex is created and selected:

testdatabase=> CREATE VERTEX v SET s="abc", i=1, b=true, sh=2, d=3.5, da="2022-12-20 18:00";
  s  | i |  b   | sh |   d   | da 
-----+---+------+----+-------+----
 abc |   | \x01 |    | @\x0C | 
(1 row)

INSERT 0 1
testdatabase=> {gremlin} g.V().hasLabel('v');
  s  | i |  b   | sh |   d   | da 
-----+---+------+----+-------+----
 abc |   | \x01 |    | @\x0C | 
(1 row)

Please note the strange response for both commands. The values for the properties i and sh are empty. The boolean b looks like binary data. The double d does not look very much like a number, and the date-time da is empty.
The studio shows the correct values for all fields, including "true" for the boolean.

[lvca]

Ok, if Studio works, it must be an issue with the console. I'm going to write a test case for this.

[lvca]

Just written a test case and the return from the command is:

ArcadeDB Console v.22.12.1-SNAPSHOT - Copyrights (c) 2021 Arcade Data Ltd (https://arcadedb.com)
Database already connected, to connect to a different database close the current one first
+---------+------------------+
|NAME     |VALUE             |
+---------+------------------+
|operation|create vertex type|
|typeName |v                 |
+---------+------------------+
Command executed in 197ms
+------------+---------------+
|NAME        |VALUE          |
+------------+---------------+
|operation   |create property|
|typeName    |v              |
|propertyName|s              |
+------------+---------------+
Command executed in 9ms
+------------+---------------+
|NAME        |VALUE          |
+------------+---------------+
|operation   |create property|
|typeName    |v              |
|propertyName|i              |
+------------+---------------+
Command executed in 2ms
+------------+---------------+
|NAME        |VALUE          |
+------------+---------------+
|operation   |create property|
|typeName    |v              |
|propertyName|b              |
+------------+---------------+
Command executed in 3ms
+------------+---------------+
|NAME        |VALUE          |
+------------+---------------+
|operation   |create property|
|typeName    |v              |
|propertyName|sh             |
+------------+---------------+
Command executed in 3ms
+------------+---------------+
|NAME        |VALUE          |
+------------+---------------+
|operation   |create property|
|typeName    |v              |
|propertyName|d              |
+------------+---------------+
Command executed in 3ms
+------------+---------------+
|NAME        |VALUE          |
+------------+---------------+
|operation   |create property|
|typeName    |v              |
|propertyName|da             |
+------------+---------------+
Command executed in 3ms
VERTEX @type:v @rid:#1:0
+----+-----------------------+
|NAME|VALUE                  |
+----+-----------------------+
|s   |abc                    |
|i   |1                      |
|b   |true                   |
|sh  |2                      |
|d   |3.5                    |
|da  |2022-12-20 00:00:00.000|
+----+-----------------------+
Command executed in 23ms

[docbacardi]

Indeed, looks like it only happens in postgresql.

[lvca]

I was able to reproduce the problem from postgres console. Working on it.

[lvca]

Ok, the commands are executed correctly, but the output is serialized wrongly. I tried with a small fix that serializes by using the stringify protocol and works (everything but the FLOAT number for some reason). I need to dig a little bit more into this. Unfortunately the documentation on how to serialize types in Postgres Wire protocol is scarce/non-existent :-(

[lvca]

Fixed. Changed serialization to text.

[docbacardi]

All results look good now, including floats. This is just perfect.