Sitelet https://github.com/ArcadeData/arcadedb/issues/691
Skip to content

Postgres driver: error on creating non-string properties #691

Description

@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.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions