ArcadeData / arcadedb

ArcadeDB Multi-Model Database, one DBMS that supports SQL, Cypher, Gremlin, HTTP/JSON, MongoDB and Redis. ArcadeDB is a conceptual fork of OrientDB, the first Multi-Model DBMS. ArcadeDB supports Vector Embeddings.
https://arcadedb.com
Apache License 2.0
469 stars 57 forks source link

fix: create property default value assignment #1611

Closed gramian closed 1 month ago

gramian commented 1 month ago

What does this PR do?

This change syncs the the assignment of a default value in CREATE PROPERTY to the way it is done in ALTER PROPERTY (see https://github.com/ArcadeData/arcadedb/blob/main/engine/src/main/java/com/arcadedb/query/sql/parser/AlterPropertyStatement.java#L96 ).

Motivation

Using sysdate in a default value was evaluated at property creation time not at record creation time.

Related issues

https://github.com/ArcadeData/arcadedb/issues/1609

Checklist

lvca commented 1 month ago

Awesome, thanks @gramian !