indexed nullable DATE_TIME must be specified on .insert - is this a bug?

32 views
Skip to first unread message

Ferenc Collins

unread,
Mar 15, 2021, 6:30:57 AM3/15/21
to lovefield-users
Hi,

I am starting to use DATE_TIME fields, but I discover that if they are indexed they must be specified - even if made .addNullable, as they are not otherwise assigned a default value and an error occurs. However if the column is not indexed, the error does not occur.

Please see this codepen: https://codepen.io/fezzzza/pen/GypLxZ

As you can see, treating a STRING in the same way results in different behaviour.
Is this behaviour by design or a bug?

I note that public Codepens don't seem to allow lovefield permission to work - you would have to copy/paste to your own codepen to observe the behaviour.

Ferenc Collins

unread,
Mar 16, 2021, 5:05:12 AM3/16/21
to lovefield-users
Forget the Codepen link - I moved the repro to plunker for instant access

Ferenc Collins

unread,
Mar 17, 2021, 9:22:49 AM3/17/21
to lovefield-users
48 hours after my OP and this group appears to be dead, so after doing more testing I've filed issue #273
Reply all
Reply to author
Forward
0 new messages