odbtools/odbctest/mql/test/mpartition/1.create.mql

create class if not exists /test() with namespace="test"
;

create class if not exists /test/mpartition (
		
		mv_varchar		varchar,
		v_text			text,
		v_int			int,
		v_bigint		bigint,
		v_smalldouble	double,
		v_double		double,
		v_float			float,
		v_bool			bool,
		
		indexes(mv_varchar, v_text, v_int, v_bigint, v_double, v_float, v_smalldouble, v_bool),
		keys(mv_varchar, v_text, v_int)
	) with partition=(mv_varchar,v_int), onconflict=(v_bigint incr)
;

delete from /test/mpartition with version
;