1
votes

I can try to insert into users class ( aka like a table) via shell a structure like this:

email: '[email protected]'
display_name: 'name surname test'
tags: {id: 1, name: 'first', type:'something'}

so some fields when one of them is a document.

I try this query:

insert into users (email, display_name, tags) values 
('[email protected]',
 'name surname test',
 {'id': 1, 'name': 'first', 'type' : 'something'}
)

but obtain this error: Error: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #52: Set of values is missed. Example: ('Bill', 'Stuart', 300) Command: insert into users (email, display_name, tags) values ('[email protected]', 'name surname test', {'id': 1, 'name': 'first', 'type' : 'something'}, ) ------------------------------------------------------------^

How can I insert this data into users class?

1

1 Answers

0
votes

it's a problem of carriage return. This has been fixed works with 1.0-SNAPSHOT. To avoid to update your OrientDB distribution just remove \n.