Return to 428-sql.html CVS log

Up to [parser3project] / parser3 / tests

more tests

@USE
388-sql.html

@main[]

^connect[$SQL.drivers.connect]{
	^prepare-data[]

	1.1 ^try-catch{ ^t[select pet from pets^;select food from pets] }

	1.2 ^h[select 0,* from pets^;select 1,* from pets; $.type[table] $.distinct(true) ]

	1.3 ^h[select 0,* from pets^;select 0,* from pets; $.type[table] $.distinct(true) ]

	1.4 ^h[select 0,* from pets^;select 0, 2+2; $.type[table] $.distinct(true) ]

	1.5 ^h[select 0,* from pets limit 2^;delete from pets where pet=''^;select 1,* from pets limit 1; $.type[table] $.distinct(true) ]

	1.6 ^h[select 0,* from pets^;delete from pets where pet=''^;select 1,* from pets; $.type[table] $.distinct(true) $.limit(1) ]

	1.7 ^h[select pet,food from pets^;select food,* from pets; $.type[table] $.distinct(true)]

	1.8 ^h[select pet,food from pets^;select food,* from pets;  $.distinct(true)]

	1.9 ^h[select 0,* from pets^;select 0, 2+2; $.type[hash] $.distinct(true) ]
	1.10 ^h[select 0, 2+2^;select 0,* from pets; $.type[hash] $.distinct(true) ]

}