Lines Matching refs:execsql2

349   set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
354   set v [catch {execsql2 {SELECT f1 FROM test1 ORDER BY f2}} msg]
358   set v [catch {execsql2 {SELECT f1 as 'f1' FROM test1 ORDER BY f2}} msg]
362   set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
366   set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
371   set v [catch {execsql2 {SELECT * FROM test1 WHERE f1==11}} msg]
375   set v [catch {execsql2 {SELECT DISTINCT * FROM test1 WHERE f1==11}} msg]
379   set v [catch {execsql2 {SELECT f1 as xyzzy FROM test1 ORDER BY f2}} msg]
383   set v [catch {execsql2 {SELECT f1 as "xyzzy" FROM test1 ORDER BY f2}} msg]
387   set v [catch {execsql2 {SELECT f1 as 'xyzzy ' FROM test1 ORDER BY f2}} msg]
391   set v [catch {execsql2 {SELECT f1+F2 as xyzzy FROM test1 ORDER BY f2}} msg]
395   set v [catch {execsql2 {SELECT f1+F2 FROM test1 ORDER BY f2}} msg]
399   set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
403   execsql2 {PRAGMA full_column_names=on}
404   set v [catch {execsql2 {SELECT test1.f1+F2 FROM test1 ORDER BY f2}} msg]
405   execsql2 {PRAGMA full_column_names=off}
409   set v [catch {execsql2 {SELECT test1.f1+F2, t1 FROM test1, test2
414   set v [catch {execsql2 {SELECT A.f1, t1 FROM test1 as A, test2
419   set v [catch {execsql2 {SELECT A.f1, f1 FROM test1 as A, test1 as B
424   set v [catch {execsql2 {SELECT A.f1, B.f1 FROM test1 as A, test1 as B
429   set v [catch {execsql2 {SELECT A.f1, f1 FROM test1 as A, test1 as A
434   set v [catch {execsql2 {SELECT A.f1, B.f1 FROM test1 as A, test1 as B
439   set v [catch {execsql2 {
446   set v [catch {execsql2 {
607   execsql2 {
612   execsql2 {
627   execsql2 {
632   execsql2 {
642   execsql2 {
647   execsql2 {
662   execsql2 {
667   execsql2 {
672   execsql2 {
677   execsql2 {
682   execsql2 {
690   execsql2 {
695   execsql2 {
700   execsql2 {
727   execsql2 {
734   execsql2 {