Content-Type: text/html
Content-Length: 4538


		

	

	

	1.1 
	
	Exception type: sql.execute,
	Source: select pet from pets;select food from pets,
	Comment: result must contain exactly one table


	1.2 	
	{
	"0":[
		{"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
		{"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
		{"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
		{"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
	],
	"1":[
		{"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
		{"1":"1","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
		{"1":"1","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
		{"1":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
	]
}

	1.3 	
	{
	"0":[
		{"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
		{"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
		{"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
		{"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"},
		{"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
		{"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
		{"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
		{"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
	]
}

	1.4 	
	{
	"0":[
		{"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
		{"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
		{"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
		{"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"},
		{"0":"0","pet":"4"}
	]
}

	1.5 	
	{
	"0":[
		{"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
		{"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
	],
	"1":[
		{"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
	]
}

	1.6 	
	{
	"0":[
		{"0":"0","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
		{"0":"0","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
		{"0":"0","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
		{"0":"0","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
	],
	"1":[
		{"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
	]
} - minor bug: limit for last query only

	1.7 	
	{
	"cat":[
		{"pet":"cat","food":"milk"}
	],
	"dog":[
		{"pet":"dog","food":"bone"}
	],
	"hamster":[
		{"pet":"hamster","food":"grain"}
	],
	"parrot":[
		{"pet":"parrot","food":"grain"}
	],
	"milk":[
		{"food":"milk","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"}
	],
	"bone":[
		{"food":"bone","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"}
	],
	"grain":[
		{"food":"grain","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
		{"food":"grain","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
	]
}

	1.8 	
	{
	"cat":{
		"food":"milk"
	},
	"dog":{
		"food":"bone"
	},
	"hamster":{
		"food":"grain"
	},
	"parrot":{
		"food":"grain"
	},
	"milk":{
		"pet":"cat",
		"food":"milk",
		"aggressive":"'very'",
		"weigth":"5"
	},
	"bone":{
		"pet":"dog",
		"food":"bone",
		"aggressive":"\"never\"",
		"weigth":"10"
	},
	"grain":{
		"pet":"hamster",
		"food":"grain",
		"aggressive":"",
		"weigth":"1"
	}
}

	1.9 	
	{
	"0":{
		"pet":"cat",
		"food":"milk",
		"aggressive":"'very'",
		"weigth":"5"
	}
}
	1.10 	
	{
	"0":{
		"2+2":"4"
	}
}

	1.11 	
	{
	"0":[
		{"0":"0","food":"milk"},
		{"0":"0","food":"bone"},
		{"0":"0","food":"grain"},
		{"0":"0","food":"grain"}
	],
	"1":[
		{"1":"1","pet":"cat","food":"milk","aggressive":"'very'","weigth":"5"},
		{"1":"1","pet":"dog","food":"bone","aggressive":"\"never\"","weigth":"10"},
		{"1":"1","pet":"hamster","food":"grain","aggressive":"","weigth":"1"},
		{"1":"1","pet":"parrot","food":"grain","aggressive":"alwayws","weigth":"1"}
	]
} - different structure for each query as key differs
	1.12 	
	{
	"0":[
		{"0":"0","food":"milk"},
		{"0":"0","food":"bone"},
		{"0":"0","food":"grain"},
		{"0":"0","food":"grain"},
		{"0":"0","food":"cat","2":"milk","3":"'very'","4":"5"},
		{"0":"0","food":"dog","2":"bone","3":"\"never\"","4":"10"},
		{"0":"0","food":"hamster","2":"grain","3":"","4":"1"},
		{"0":"0","food":"parrot","2":"grain","3":"alwayws","4":"1"}
	]
} - note: there are missed and numeric columns in second query, but it better then exception