===> bench rm -f bench.out bench.out.perquery ===> demo rm -f demo.out ===> regress rm -f stud_emp.data onek.data regress.out ===> video rm -f video.out running demo... PATH=/u/biouser2/aoki/postgres/bin:$PATH sh /a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/demo/wholedemo.sh 2>&1 | tee demo.out =============== destroying old demo database... ================= WARN:Oct 2 18:09:57:destroydb: database demo does not exist. destroydb: database destroy failed on demo. =============== creating new demo database... ================= =============== running demo queries... ================= Welcome to the POSTGRES terminal monitor Go * Query sent to backend is " create person (name = char16, age = int4, location = point) " CREATE Go * Query sent to backend is "create emp (salary = int4, manager = char16) inherits (person) " CREATE Go * Query sent to backend is "create student (gpa = float8) inherits (person) " CREATE Go * Query sent to backend is "create stud_emp (percent = int4) inherits (emp, student) " CREATE Go * Query sent to backend is "define type city_budget ( internallength = 16, input = int44in, output = int44out, element = int4) " DEFINE Go * Query sent to backend is "create city (name = char16, location = box, budget = city_budget) " CREATE Go * Query sent to backend is "define function circle_in ( language = "c", returntype = circle ) arg is (any) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/demo/obj/circle.so" " NOTICE:Oct 2 18:10:04:ProcedureDefine: type 'circle' is not yet defined NOTICE:Oct 2 18:10:04:ProcedureDefine: creating a shell for type 'circle' DEFINE Go * Query sent to backend is "define function circle_out ( language = "c", returntype = any ) arg is (any) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/demo/obj/circle.so" " DEFINE Go * Query sent to backend is "define type circle (internallength = 24, input = circle_in, output = circle_out) " DEFINE Go * Query sent to backend is "define function pt_in_circle ( language = "c", returntype = bool) arg is (point, circle) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/demo/obj/circle.so" " DEFINE Go * Query sent to backend is "define function overpaid ( language = "c", returntype = bool) arg is (emp) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/demo/obj/overpaid.so" " DEFINE Go * Query sent to backend is "define function boxarea ( language = "c", returntype = int4) arg is (box) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/demo/obj/boxarea.so" " DEFINE Go * Query sent to backend is "load "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/demo/obj/boxarea.so" " LOAD Go * Query sent to backend is "load "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/demo/obj/circle.so" " LOAD Go * Query sent to backend is "load "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/demo/obj/overpaid.so" " LOAD Go * Query sent to backend is "append person (name = "mike", age = 40, location = "(3.1,6.2)") " APPEND 21459 Go * Query sent to backend is "append person (name = "joe", age = 20, location = "(5.5,2.5)") " APPEND 21460 Go * Query sent to backend is "append person (name = "greg", age = 50, location = "(5.0,2.0)") " APPEND 21461 Go * Query sent to backend is "append person (name = "bob", age = 18, location = "(0.0,0.0)") " APPEND 21462 Go * Query sent to backend is "append emp (name = "bill", age = 20, location = "(11.0,10.0)", salary = 1000, manager = "sharon") " APPEND 21463 Go * Query sent to backend is "append emp (name = "sharon", age = 25, location = "(15.0,12.0)", salary = 500, manager = "sam") " APPEND 21464 Go * Query sent to backend is "append emp (name = "sam", age = 30, location = "(10.0,5.0)", salary = 300, manager = "bill") " APPEND 21465 Go * Query sent to backend is "append student (name = "fred", age = 28, location = "(3.1,-1.5)", gpa = 3.7) " APPEND 21466 Go * Query sent to backend is "append student (name = "larry", age = 60, location = "(21.8,4.9)", gpa = 3.1) " APPEND 21467 Go * Query sent to backend is "append stud_emp (name = "jeff", age = 23, location = "(8.0,7.7)", salary = 600, manager = "sharon", gpa = 3.5) " APPEND 21468 Go * Query sent to backend is "append stud_emp (name = "cim", age = 30, location = "(10.5,4.7)", salary = 400, gpa = 3.4) " APPEND 21469 Go * Query sent to backend is "append stud_emp (name = "linda", age = 19, location = "(0.9,6.1)", salary = 100, gpa = 2.9) " APPEND 21470 Go * Query sent to backend is "append city (name = "berkeley", location = "(0.0,0.0,10.0,10.0)", budget = "250, 300, 325, 275") " APPEND 21471 Go * Query sent to backend is "append city (name = "oakland", location = "(-10.0,-10.0,0.0,5.0)", budget = "600, 400, 350, 500") " APPEND 21472 Go * Query sent to backend is "append city (name = "elcerrito", location = "(10.0,0.0, 20.0,10.0)", budget = "100, 100, 100, 100") " APPEND 21473 Go * Query sent to backend is "append city (name = "richmond", location = "(20.0,5.0, 35.0,15.0)", budget = "300, 320, 340, 360") " APPEND 21474 Go * Query sent to backend is "append city (name = "sanpablo", location = "(35.0,20.0,40.0,30.0)", budget = "50, 60, 65, 70") " APPEND 21475 Go * Query sent to backend is "retrieve (emp.all) " ----------------------------------------------------------------------- | location | age | name | salary | manager | ----------------------------------------------------------------------- | (11,10) | 20 | bill | 1000 | sharon | ----------------------------------------------------------------------- | (15,12) | 25 | sharon | 500 | sam | ----------------------------------------------------------------------- | (10,5) | 30 | sam | 300 | bill | ----------------------------------------------------------------------- Go * Query sent to backend is "retrieve (city.all) " ------------------------------------------- | name | location | budget | ------------------------------------------- | berkeley | (10,10,0,0) | 250 300 325 275| ------------------------------------------- | oakland | (0,5,-10,-10)| 600 400 350 500| ------------------------------------------- | elcerrito | (20,10,10,0)| 100 100 100 100| ------------------------------------------- | richmond | (35,15,20,5)| 300 320 340 360| ------------------------------------------- | sanpablo | (40,30,35,20)| 50 60 65 70 | ------------------------------------------- Go * Query sent to backend is "retrieve (e.name) from e in emp, m in emp where e.manager = m.name and e.salary > m.salary " --------------- | name | --------------- | bill | --------------- | sharon | --------------- Go * Query sent to backend is "retrieve (city.name) where boxarea(city.location) > 100 " --------------- | name | --------------- | oakland | --------------- | richmond | --------------- Go * Query sent to backend is "retrieve (emp.name) where overpaid(emp) " --------------- | name | --------------- | bill | --------------- Go * Query sent to backend is "retrieve (city.name) where city.budget[1] > city.budget[2] " --------------- | name | --------------- | oakland | --------------- Go * Query sent to backend is "retrieve (emp.name) from s in city where s.name = "berkeley" and emp.location ---> s.location " --------------- | name | --------------- | sam | --------------- Go * Query sent to backend is "define operator <% ( arg1 = point, arg2 = circle, procedure = pt_in_circle, associativity = left, commutator = >=%, restrict = eqsel) " DEFINE Go * Query sent to backend is "retrieve (emp.name, emp.location) where emp.location <% "(5.0,5.0,10.0)"::circle " ----------------------------- | name | location | ----------------------------- | bill | (11,10) | ----------------------------- | sam | (10,5) | ----------------------------- Go * Query sent to backend is "retrieve (emp.salary) where emp.name = "sam" " --------------- | salary | --------------- | 300 | --------------- Go * Query sent to backend is "replace emp (salary = 700) where emp.name = "sam" " REPLACE Go * Query sent to backend is "retrieve (e.salary, e.tmin, e.tmax) from e in emp[ , ] where e.name = "sam" " ------------------------------------------- | salary | tmin | tmax | ------------------------------------------- | 300 | Sat Oct 2 18:10:07 1993 PDT| Sat Oct 2 18:10:12 1993 PDT| ------------------------------------------- | 700 | Sat Oct 2 18:10:12 1993 PDT| current | ------------------------------------------- Go * Query sent to backend is "retrieve (e.name) from e in emp, s in student where e.age < s.age and s.name = "fred" " --------------- | name | --------------- | bill | --------------- | sharon | --------------- Go * Query sent to backend is "retrieve (e.name) from e in emp*, s in student* where e.age < s.age and s.name = "fred" " --------------- | name | --------------- | bill | --------------- | sharon | --------------- | jeff | --------------- | linda | --------------- Go * Query sent to backend is "retrieve (emp.all) where emp.name = "sharon" or emp.name = "bill" or emp.name = "sam" " ----------------------------------------------------------------------- | location | age | name | salary | manager | ----------------------------------------------------------------------- | (11,10) | 20 | bill | 1000 | sharon | ----------------------------------------------------------------------- | (15,12) | 25 | sharon | 500 | sam | ----------------------------------------------------------------------- | (10,5) | 30 | sam | 700 | bill | ----------------------------------------------------------------------- Go * Query sent to backend is "define rule example_1 is on replace to emp.salary where current.name = "sharon" do replace emp (salary = new.salary) where emp.name = "bill" " DEFINE Go * Query sent to backend is "define rule example_2 is on replace to emp.salary where current.name = "bill" do replace emp (salary = 2 * new.salary) where emp.name = "sam" " DEFINE Go * Query sent to backend is "replace emp (salary=1000) where emp.name = "sharon" " REPLACE Go * Query sent to backend is "retrieve (emp.all) where emp.name = "sharon" or emp.name = "bill" or emp.name = "sam" " ----------------------------------------------------------------------- | location | age | name | salary | manager | ----------------------------------------------------------------------- | (10,5) | 30 | sam | 2000 | bill | ----------------------------------------------------------------------- | (11,10) | 20 | bill | 1000 | sharon | ----------------------------------------------------------------------- | (15,12) | 25 | sharon | 1000 | sam | ----------------------------------------------------------------------- Go * Query sent to backend is "remove rule example_1 " REMOVE Go * Query sent to backend is "remove rule example_2 " REMOVE Go * Query sent to backend is "define rule example_1 is on retrieve to emp.salary where current.name = "sam" do instead retrieve (salary = 2 * emp.salary) where emp.name = "bill" " DEFINE Go * Query sent to backend is "define rule example_2 is on retrieve to emp.salary where current.name = "bill" do instead retrieve (salary = 3 * emp.salary) where emp.name = "sharon" " DEFINE Go * Query sent to backend is "retrieve (emp.all) where emp.name = "sharon" or emp.name = "bill" or emp.name = "sam" " ----------------------------------------------------------------------- | location | age | name | salary | manager | ----------------------------------------------------------------------- | (15,12) | 25 | sharon | 1000 | sam | ----------------------------------------------------------------------- | (10,5) | 30 | sam | 6000 | bill | ----------------------------------------------------------------------- | (11,10) | 20 | bill | 3000 | sharon | ----------------------------------------------------------------------- Go * Query sent to backend is "retrieve (avgsal = int4ave{ emp.salary where emp.salary > 2000 } ) " --------------- | avgsal | --------------- | 4500 | --------------- Go * Query sent to backend is "retrieve (avgsal = int4ave{ emp.salary } ) " --------------- | avgsal | --------------- | 3333 | --------------- Go * Query sent to backend is "define aggregate bletch (sfunc1 = int4mul, basetype = int4, stype1 = int4, sfunc2 = int4inc, stype2 = int4, finalfunc = int4div, initcond1 = "1", initcond2 = "0") " DEFINE Go * Query sent to backend is "retrieve (randomnum = bletch{emp.salary where emp.salary <= 3000}) " --------------- | randomnum | --------------- | 1500000 | --------------- Go * Query sent to backend is "remove aggregate bletch " REMOVE Go * =============== destroying demo database... ================= RESULTS OF DEMO ARE SAVED IN obj/demo.out running regress... PATH=/u/biouser2/aoki/postgres/bin:$PATH sh /a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/regress.sh 2>&1 | tee regress.out =============== destroying old regression database... ================= WARN:Oct 2 18:10:18:destroydb: database regression does not exist. destroydb: database destroy failed on regression. =============== creating new regression database... ================= Welcome to the POSTGRES terminal monitor Go * Query sent to backend is " define function circle_in ( language = "c", returntype = circle ) arg is (any) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/regress.so" " NOTICE:Oct 2 18:10:20:ProcedureDefine: type 'circle' is not yet defined NOTICE:Oct 2 18:10:20:ProcedureDefine: creating a shell for type 'circle' DEFINE Go * Query sent to backend is "define function circle_out ( language = "c", returntype = any ) arg is (any) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/regress.so" " DEFINE Go * Query sent to backend is "define type circle ( internallength = 24, input = circle_in, output = circle_out ) " DEFINE Go * Query sent to backend is "define type city_budget ( internallength = 16, input = int44in, output = int44out, element = int4 ) " DEFINE Go * Query sent to backend is " create hobbies_r (name = text, person = text) " CREATE Go * Query sent to backend is "create equipment_r (name = text, hobby = text) " CREATE Go * Query sent to backend is "create onek(unique1=int4, unique2=int4, two=int4, four=int4, ten=int4, twenty=int4, hundred=int4, thousand=int4, twothousand=int4, fivethous=int4, tenthous=int4, odd=int4, even=int4, stringu1=char16, stringu2=char16, string4=char16) " CREATE Go * Query sent to backend is "create tenk1 (unique1=int4, unique2=int4, two=int4, four=int4, ten=int4, twenty=int4, hundred=int4, thousand=int4, twothousand=int4, fivethous=int4, tenthous=int4, odd=int4, even=int4, stringu1=char16, stringu2=char16, string4=char16) " CREATE Go * Query sent to backend is "create tenk2 (unique1 = int4, unique2 = int4, two = int4, four = int4, ten=int4, twenty = int4, hundred = int4, thousand = int4, twothousand = int4, fivethous = int4, tenthous=int4, odd=int4, even=int4, stringu1=char16, stringu2=char16, string4=char16) " CREATE Go * Query sent to backend is "create person (name = text, age = int4, location = point) " CREATE Go * Query sent to backend is "create emp (salary = int4, manager = char16) inherits (person) " CREATE Go * Query sent to backend is "create student (gpa = float8) inherits (person) " CREATE Go * Query sent to backend is "create stud_emp (percent = int4) inherits (emp, student) " CREATE Go * Query sent to backend is "create city (name = char16, location = box, budget = city_budget) " CREATE Go * Query sent to backend is "create dept (dname = char16, mgrname = text) " CREATE Go * Query sent to backend is "create slow_emp4000 (home_base = box) " CREATE Go * Query sent to backend is "create fast_emp4000 (home_base = box) " CREATE Go * Query sent to backend is "create road (name = text, thepath = path) " CREATE Go * Query sent to backend is "create ihighway () inherits (road) " CREATE Go * Query sent to backend is "create shighway (surface = text) inherits (road) " CREATE Go * Query sent to backend is "create real_city (pop = int4, cname = text, outline = path) " CREATE Go * Query sent to backend is "create aggtest (a = int2, b = float4) " CREATE Go * Query sent to backend is "create arrtest (a = int2[], b = int4[][][], c = char16[], d = text[][], e = float8[]) " CREATE Go * Query sent to backend is " define function hobbies ( language = "postquel", returntype = setof hobbies_r ) arg is (person) as "retrieve (hobbies_r.all) where hobbies_r.person = $1.name" " DEFINE Go * Query sent to backend is "define function hobby_construct ( language = "postquel", returntype = hobbies_r ) arg is (text, text) as "retrieve (name = $1, hobby = $2)" " DEFINE Go * Query sent to backend is "define function equipment ( language = "postquel", returntype = setof equipment_r ) arg is (hobbies_r) as "retrieve (equipment_r.all) where equipment_r.hobby = $1.name" " DEFINE Go * Query sent to backend is "define function user_relns ( language = "postquel", returntype = setof char16 ) as "retrieve (pg_class.relname) where pg_class.relname !~ \"pg_.*\" and pg_class.relkind != 'i' " " DEFINE Go * Query sent to backend is "define function pt_in_circle ( language = "c", returntype = int4 ) arg is (point, circle) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/regress.so" " DEFINE Go * Query sent to backend is "define function overpaid ( language = "c", returntype = bool ) arg is (emp) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/regress.so" " DEFINE Go * Query sent to backend is "define function boxarea ( language = "c", returntype = int4 ) arg is (box) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/regress.so" " DEFINE Go * Query sent to backend is "define function interpt_pp ( language = "c", returntype = point ) arg is (path, path) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/regress.so" " DEFINE Go * Query sent to backend is "define function reverse_c16 ( language = "c", returntype = char16 ) arg is (char16) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/regress.so" " DEFINE Go * Query sent to backend is " define function ufp0 ( language = "c", returntype = int4 ) arg is ( ) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/ufp1.so" " DEFINE Go * Query sent to backend is "replace pg_proc ( proistrusted = "f"::bool, pronargs = 0 ) where pg_proc.proname = "ufp0" " REPLACE Go * Query sent to backend is "define function ufp1 ( language = "c", returntype = int4 ) arg is (int4) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/ufp1.so" " DEFINE Go * Query sent to backend is "replace pg_proc ( proistrusted = "f"::bool ) where pg_proc.proname = "ufp1" " REPLACE Go * Query sent to backend is "define function ufp2 ( language = "c", returntype = char16 ) arg is (char16, char16) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/ufp2.so" " DEFINE Go * Query sent to backend is "replace pg_proc ( proistrusted = "f"::bool ) where pg_proc.proname = "ufp2" " REPLACE Go * Query sent to backend is "define function ufp3 ( language = "c", returntype = text ) arg is (text, char) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/ufp3.so" " DEFINE Go * Query sent to backend is "replace pg_proc ( proistrusted = "f"::bool ) where pg_proc.proname = "ufp3" " REPLACE Go * Query sent to backend is " load "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/regress.so" " LOAD Go * Query sent to backend is " copy onek from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/../data/onek.data" " COPY Go * Query sent to backend is "copy tenk1 from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/../data/tenk.data" " COPY Go * Query sent to backend is "append tenk2 (tenk1.all) " APPEND 0 Go * Query sent to backend is "retrieve into onek2 (onek.all) " RETRIEVE Go * Query sent to backend is "copy slow_emp4000 from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/../data/rect.data" " COPY Go * Query sent to backend is "append fast_emp4000 (slow_emp4000.all) " APPEND 0 Go * Query sent to backend is "copy person from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/../data/person.data" " COPY Go * Query sent to backend is "copy emp from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/../data/emp.data" " COPY Go * Query sent to backend is "copy student from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/../data/student.data" " COPY Go * Query sent to backend is "copy stud_emp from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/../data/stud_emp.data" " COPY Go * Query sent to backend is "retrieve into Bprime (t.all) from t in tenk1 where t.unique2 < 1000 " RETRIEVE Go * Query sent to backend is "append hobbies_r (name = "posthacking", person = p.name) from p in person* where p.name = "mike" or p.name = "jeff" " APPEND 0 Go * Query sent to backend is "append hobbies_r (name = "basketball", person = person.name) where person.name = "joe" or person.name = "sally" " APPEND 0 Go * Query sent to backend is "append hobbies_r (name = "skywalking") " APPEND 52546 Go * Query sent to backend is "append equipment_r (name = "advil", hobby = "posthacking") " APPEND 52547 Go * Query sent to backend is "append equipment_r (name = "peet's coffee", hobby = "posthacking") " APPEND 52548 Go * Query sent to backend is "append equipment_r (name = "hightops", hobby = "basketball") " APPEND 52549 Go * Query sent to backend is "append equipment_r (name = "guts", hobby = "skywalking") " APPEND 52550 Go * Query sent to backend is "copy road from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/../data/streets.data" " COPY Go * Query sent to backend is "copy real_city from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/../data/real_city.data" " COPY Go * Query sent to backend is "retrieve into ramp (road.all) where road.name ~ ".*Ramp" " RETRIEVE Go * Query sent to backend is "append ihighway (road.all) where road.name ~ "I- .*" " APPEND 0 Go * Query sent to backend is "append shighway (road.all) where road.name ~ "State Hwy.*" " APPEND 0 Go * Query sent to backend is "replace shighway (surface = "asphalt") " REPLACE Go * Query sent to backend is "create hasham_heap (seqno = int4, random = int4) " CREATE Go * Query sent to backend is "copy hasham_heap from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/../data/hash.data" " COPY Go * Query sent to backend is " append arrtest (a[5] = "{1,2,3,4,5}", b[2][1][2] = "{{{},{1,2}}}", c = "{}", d = "{}", e[0:4] = "/floatarr") " APPEND 68793 Go * Query sent to backend is "replace arrtest (e[0] = "1.1") " REPLACE Go * Query sent to backend is "replace arrtest (e[1] = "2.2") " REPLACE Go * Query sent to backend is "append arrtest (a = "{11,12,23}", b[2][2][1] = "{{3,4},{4,5}}", c = "{"foobar"}", d = "{{"elt1", "elt2"}}", e = "{"3.4", "6.7"}") " APPEND 68794 Go * Query sent to backend is "append arrtest (a = "{}", b[1][2][2] = "{3,4}", c = "{foo,bar}", d[2][1] = "{bar,foo}") " APPEND 68795 Go * Query sent to backend is "create iportaltest (i = int4, d = float4, p = polygon) " CREATE Go * Query sent to backend is "append iportaltest (i = 1, d = 3.567, p = "(3.0,4.0,1.0,2.0)"::polygon) " APPEND 68862 Go * Query sent to backend is "append iportaltest (i = 2, d = 89.05, p = "(4.0,3.0,2.0,1.0)"::polygon) " APPEND 68863 Go * Query sent to backend is " define index onek_unique1 on onek using btree(unique1 int4_ops) " DEFINE Go * Query sent to backend is "define index onek_unique2 on onek using btree(unique2 int4_ops) " DEFINE Go * Query sent to backend is "define index onek_hundred on onek using btree(hundred int4_ops) " DEFINE Go * Query sent to backend is "define index onek_stringu1 on onek using btree(stringu1 char16_ops) " DEFINE Go * Query sent to backend is "define index tenk1_unique1 on tenk1 using btree(unique1 int4_ops) " DEFINE Go * Query sent to backend is "define index tenk1_unique2 on tenk1 using btree(unique2 int4_ops) " DEFINE Go * Query sent to backend is "define index tenk1_hundred on tenk1 using btree(hundred int4_ops) " DEFINE Go * Query sent to backend is "define index tenk2_unique1 on tenk2 using btree(unique1 int4_ops) " DEFINE Go * Query sent to backend is "define index tenk2_unique2 on tenk2 using btree(unique2 int4_ops) " DEFINE Go * Query sent to backend is "define index tenk2_hundred on tenk2 using btree(hundred int4_ops) " DEFINE Go * Query sent to backend is "define index onek2_u1_prtl on onek2 using btree(unique1 int4_ops) where onek2.unique1 < 20 or onek2.unique1 > 980 " DEFINE Go * Query sent to backend is "define index onek2_u2_prtl on onek2 using btree(unique2 int4_ops) where onek2.stringu1 < "B" " DEFINE Go * Query sent to backend is "extend index onek2_u2_prtl where onek2.stringu1 < "C" " EXTEND Go * Query sent to backend is "extend index onek2_u2_prtl " EXTEND Go * Query sent to backend is "define index onek2_stu1_prtl on onek2 using btree(stringu1 char16_ops) where onek2.stringu1 >= "J" and onek2.stringu1 < "K" " DEFINE Go * Query sent to backend is "define index rect2ind on fast_emp4000 using rtree (home_base bigbox_ops) " DEFINE Go * Query sent to backend is "define index rix on road using btree (name text_ops) " DEFINE Go * Query sent to backend is "define index iix on ihighway using btree (name text_ops) " DEFINE Go * Query sent to backend is "define index six on shighway using btree (name text_ops) " DEFINE Go * Query sent to backend is "define index hasham_index on hasham_heap using hash (random int4_ops) " DEFINE Go * Query sent to backend is " define operator ## ( arg1 = path, arg2 = path, procedure = path_inter, commutator = ## ) " DEFINE Go * Query sent to backend is "define operator <% ( arg1 = point, arg2 = circle, procedure = pt_in_circle, associativity = left, commutator = >=% ) " DEFINE Go * Query sent to backend is " define view street ( road.name, road.thepath, cname = real_city.cname ) where real_city.outline ## road.thepath " APPEND 150222DEFINE Go * Query sent to backend is "define view iexit ( ihighway.name, ihighway.thepath, exit = interpt_pp(ihighway.thepath, ramp.thepath) ) where ihighway.thepath ## ramp.thepath " APPEND 150291DEFINE Go * Query sent to backend is "define view toyemp ( emp.name, emp.age, emp.location, annualsal = 12*emp.salary ) " APPEND 150364DEFINE Go * Query sent to backend is " define aggregate newavg (sfunc1 = int4pl, basetype = int4, stype1 = int4, sfunc2 = int4inc, stype2 = int4, finalfunc = int4div, initcond1 = "0", initcond2 = "0") " DEFINE Go * Query sent to backend is " define aggregate newsum (sfunc1 = int4pl, basetype = int4, stype1 = int4, initcond1 = "0") " DEFINE Go * Query sent to backend is " define aggregate newcnt (sfunc2 = int4inc, stype2 = int4, initcond2 = "0") " DEFINE Go * Query sent to backend is "vacuum " VACUUM Go * Query sent to backend is " retrieve ( pg_class.relname, pg_class.relhasindex ) where pg_class.relhasindex " ----------------------------- | relname | relhasindex | ----------------------------- | pg_type | t | ----------------------------- | pg_proc | t | ----------------------------- | pg_attribute| t | ----------------------------- | pg_class | t | ----------------------------- | onek | t | ----------------------------- | tenk1 | t | ----------------------------- | tenk2 | t | ----------------------------- | onek2 | t | ----------------------------- | fast_emp4000| t | ----------------------------- | road | t | ----------------------------- | ihighway | t | ----------------------------- | shighway | t | ----------------------------- | hasham_heap | t | ----------------------------- Go * =============== running regression queries ... ================= Welcome to the POSTGRES terminal monitor Go * Query sent to backend is " retrieve (one = 1) " --------------- | one | --------------- | 1 | --------------- Go * Query sent to backend is " retrieve (true="t"::bool) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false="f"::bool) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (true="t"::bool or "f"::bool) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false="t"::bool and "f"::bool) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (true = not "f"::bool) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false = "t"::bool = "f"::bool) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (true = "t"::bool != "f"::bool) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is " retrieve (true = "2"::int2 = "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false = "1"::int2 = "2"::int4) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (false = "2"::int2 != "2"::int4) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (true = "1"::int2 != "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int2 <= "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "1"::int2 <= "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false = "2"::int2 < "2"::int4) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (false = "2"::int2 > "2"::int4) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (true = "1"::int2 < "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "3"::int2 > "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int2 >= "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "3"::int2 >= "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int2 <= "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "1"::int2 <= "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is " retrieve (true = "2"::int4 = "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false = "1"::int4 = "2"::int2) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (false = "2"::int4 != "2"::int2) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (true = "1"::int4 != "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int4 <= "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "1"::int4 <= "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false = "2"::int4 < "2"::int2) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (false = "2"::int4 > "2"::int2) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (true = "1"::int4 < "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "3"::int4 > "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int4 >= "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "3"::int4 >= "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int4 <= "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "1"::int4 <= "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is " retrieve (true = "2"::int4 = "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false = "1"::int4 = "2"::int4) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (false = "2"::int4 != "2"::int4) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (true = "1"::int4 != "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int4 <= "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "1"::int4 <= "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false = "2"::int4 < "2"::int4) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (false = "2"::int4 > "2"::int4) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (true = "1"::int4 < "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "3"::int4 > "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int4 >= "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "3"::int4 >= "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int4 <= "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "1"::int4 <= "2"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is " retrieve (true = "2"::int2 = "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false = "1"::int2 = "2"::int2) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (false = "2"::int2 != "2"::int2) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (true = "1"::int2 != "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false = "2"::int2 < "2"::int2) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (false = "2"::int2 > "2"::int2) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (true = "1"::int2 < "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "3"::int2 > "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int2 >= "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "3"::int2 >= "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int2 <= "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "1"::int2 <= "2"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is " retrieve (three = "1"::int4 + "2"::int2) " --------------- | three | --------------- | 3 | --------------- Go * Query sent to backend is "retrieve (neg_one = "1"::int4 - "2"::int2) " --------------- | neg_one | --------------- | -1 | --------------- Go * Query sent to backend is "retrieve (two = "1"::int4 * "2"::int2) " --------------- | two | --------------- | 2 | --------------- Go * Query sent to backend is "retrieve (one = "2"::int4 / "2"::int2) " --------------- | one | --------------- | 1 | --------------- Go * Query sent to backend is "retrieve (zero = "27"::int4 % "3"::int2) " --------------- | zero | --------------- | 0 | --------------- Go * Query sent to backend is " retrieve (three = "1"::int2 + "2"::int4) " --------------- | three | --------------- | 3 | --------------- Go * Query sent to backend is "retrieve (neg_one = "1"::int2 - "2"::int4) " --------------- | neg_one | --------------- | -1 | --------------- Go * Query sent to backend is "retrieve (two = "1"::int2 * "2"::int4) " --------------- | two | --------------- | 2 | --------------- Go * Query sent to backend is "retrieve (one = "2"::int2 / "2"::int4) " --------------- | one | --------------- | 1 | --------------- Go * Query sent to backend is "retrieve (zero = "27"::int2 % "3"::int4) " --------------- | zero | --------------- | 0 | --------------- Go * Query sent to backend is " retrieve (three = "1"::int2 + "2"::int2) " --------------- | three | --------------- | 3 | --------------- Go * Query sent to backend is "retrieve (neg_one = "1"::int2 - "2"::int2) " --------------- | neg_one | --------------- | -1 | --------------- Go * Query sent to backend is "retrieve (two = "1"::int2 * "2"::int2) " --------------- | two | --------------- | 2 | --------------- Go * Query sent to backend is "retrieve (one = "2"::int2 / "2"::int2) " --------------- | one | --------------- | 1 | --------------- Go * Query sent to backend is "retrieve (zero = "27"::int2 % "3"::int2) " --------------- | zero | --------------- | 0 | --------------- Go * Query sent to backend is "retrieve (neg_seven = - "7"::int2) " --------------- | neg_seven | --------------- | -7 | --------------- Go * Query sent to backend is " retrieve (three = "1"::int4 + "2"::int4) " --------------- | three | --------------- | 3 | --------------- Go * Query sent to backend is "retrieve (neg_one = "1"::int4 - "2"::int4) " --------------- | neg_one | --------------- | -1 | --------------- Go * Query sent to backend is "retrieve (two = "1"::int4 * "2"::int4) " --------------- | two | --------------- | 2 | --------------- Go * Query sent to backend is "retrieve (one = "2"::int4 / "2"::int4) " --------------- | one | --------------- | 1 | --------------- Go * Query sent to backend is "retrieve (zero = "27"::int4 % "3"::int4) " --------------- | zero | --------------- | 0 | --------------- Go * Query sent to backend is "retrieve (neg_seven = - "7"::int4) " --------------- | neg_seven | --------------- | -7 | --------------- Go * Query sent to backend is " retrieve (three = "1"::float8 + "2"::float8) " --------------- | three | --------------- | 3 | --------------- Go * Query sent to backend is "retrieve (neg_one = "1"::float8 - "2"::float8) " --------------- | neg_one | --------------- | -1 | --------------- Go * Query sent to backend is "retrieve (two = "1"::float8 * "2"::float8) " --------------- | two | --------------- | 2 | --------------- Go * Query sent to backend is "retrieve (one = "2"::float8 / "2"::float8) " --------------- | one | --------------- | 1 | --------------- Go * Query sent to backend is "retrieve (neg_seven = - "7"::float8) " --------------- | neg_seven | --------------- | -7 | --------------- Go * Query sent to backend is " retrieve (one = % "1.1"::float8) " --------------- | one | --------------- | 1 | --------------- Go * Query sent to backend is "retrieve (neg_one = % "-1.1"::float8) " --------------- | neg_one | --------------- | -1 | --------------- Go * Query sent to backend is "retrieve (one = "0.9"::float8 % ) " --------------- | one | --------------- | 1 | --------------- Go * Query sent to backend is "retrieve (neg_one = "-0.9"::float8 % ) " --------------- | neg_one | --------------- | -1 | --------------- Go * Query sent to backend is "retrieve (pos_3 = @ "-3"::float8) " --------------- | pos_3 | --------------- | 3 | --------------- Go * Query sent to backend is "retrieve (pos_3 = @ "3"::float8) " --------------- | pos_3 | --------------- | 3 | --------------- Go * Query sent to backend is "retrieve (onek = "2.0"::float8 ^ "10.0"::float8) " --------------- | onek | --------------- | 1024 | --------------- Go * Query sent to backend is "retrieve (e = : "1.0"::float8) " --------------- | e | --------------- | 2.71828182845905| --------------- Go * Query sent to backend is "retrieve (zero = ; "1.0"::float8) " --------------- | zero | --------------- | 0 | --------------- Go * Query sent to backend is "retrieve (one = : (; "1.0"::float8)) " --------------- | one | --------------- | 1 | --------------- Go * Query sent to backend is "retrieve (one = : ; "1.0"::float8) " --------------- | one | --------------- | 1 | --------------- Go * Query sent to backend is " retrieve (three = "1"::float4 + "2"::float4) " --------------- | three | --------------- | 3 | --------------- Go * Query sent to backend is "retrieve (neg_one = "1"::float4 - "2"::float4) " --------------- | neg_one | --------------- | -1 | --------------- Go * Query sent to backend is "retrieve (two = "1"::float4 * "2"::float4) " --------------- | two | --------------- | 2 | --------------- Go * Query sent to backend is "retrieve (one = "2"::float4 / "2"::float4) " --------------- | one | --------------- | 1 | --------------- Go * Query sent to backend is "retrieve (neg_seven = - "7"::float4) " --------------- | neg_seven | --------------- | -7 | --------------- Go * Query sent to backend is "retrieve (pos_3 = @ "-3"::float4) " --------------- | pos_3 | --------------- | 3 | --------------- Go * Query sent to backend is "retrieve (pos_3 = @ "3"::float4) " --------------- | pos_3 | --------------- | 3 | --------------- Go * Query sent to backend is " retrieve (true = "2"::int2 * "2"::int2 = "16"::int2 / "4"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int4 * "2"::int2 = "16"::int2 / "4"::int4) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (true = "2"::int2 * "2"::int4 = "16"::int4 / "4"::int2) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false = "1000"::int4 < "999"::int4) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is "retrieve (twenty_four = 4!) " --------------- | twenty_four | --------------- | 24 | --------------- Go * Query sent to backend is "retrieve (six = !!3) " --------------- | six | --------------- | 6 | --------------- Go * Query sent to backend is "retrieve (ten = 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1) " --------------- | ten | --------------- | 10 | --------------- Go * Query sent to backend is "retrieve (three = 2 + 2 / 2) " --------------- | three | --------------- | 3 | --------------- Go * Query sent to backend is "retrieve (two = (2 + 2) / 2) " --------------- | two | --------------- | 2 | --------------- Go * Query sent to backend is "retrieve (eight = dsqrt("64"::float8)) " --------------- | eight | --------------- | 8 | --------------- Go * Query sent to backend is "retrieve (eight = |/"64"::float8) " --------------- | eight | --------------- | 8 | --------------- Go * Query sent to backend is "retrieve (three = ||/"27"::float8) " --------------- | three | --------------- | 3 | --------------- Go * Query sent to backend is " retrieve (false = "char 16 string"::char16 = "char 16 string "::char16) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is " retrieve (true = "c"::char = "c"::char) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is " retrieve (true = "this is a text string"::text = "this is a text string"::text) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is "retrieve (false = "this is a text string"::text = "this is a text strin"::text) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is " retrieve (false = "(2.0,2.0,0.0,0.0)"::box << "(3.0,3.0,1.0,1.0)"::box) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is " retrieve (true = "(2.0,2.0,0.0,0.0)"::box &< "(3.0,3.0,1.0,1.0)"::box) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is " retrieve (true = "(2.0,2.0,0.0,0.0)"::box &> "(3.0,3.0,1.0,1.0)"::box) " --------------- | true | --------------- | f | --------------- Go * Query sent to backend is " retrieve (false = "(2.0,2.0,0.0,0.0)"::box >> "(3.0,3.0,1.0,1.0)"::box) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is " retrieve (false = "(2.0,2.0,0.0,0.0)"::box @ "(3.0,3.0,1.0,1.0)"::box) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is " retrieve (false = "(2.0,2.0,0.0,0.0)"::box ~ "(3.0,3.0,1.0,1.0)"::box) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is " retrieve (false = "(2.0,2.0,0.0,0.0)"::box ~= "(3.0,3.0,1.0,1.0)"::box) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is " retrieve (true = "(2.0,2.0,0.0,0.0)"::box && "(3.0,3.0,1.0,1.0)"::box) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is " retrieve (false = "(2.0,2.0,0.0,0.0,4.0,0.0)"::polygon << "(3.0,3.0,1.0,1.0,3.0,0.0)"::polygon) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is " retrieve (true = "(2.0,2.0,0.0,0.0,4.0,0.0)"::polygon &< "(3.0,3.0,1.0,1.0,3.0,0.0)"::polygon) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is " retrieve (true = "(2.0,2.0,0.0,0.0,4.0,0.0)"::polygon &> "(3.0,3.0,1.0,1.0,3.0,0.0)"::polygon) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is " retrieve (false = "(2.0,2.0,0.0,0.0,4.0,0.0)"::polygon >> "(3.0,3.0,1.0,1.0,3.0,0.0)"::polygon) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is " retrieve (false = "(2.0,2.0,0.0,0.0,4.0,0.0)"::polygon @ "(3.0,3.0,1.0,1.0,3.0,0.0)"::polygon) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is " retrieve (false = "(2.0,2.0,0.0,0.0,4.0,0.0)"::polygon ~ "(3.0,3.0,1.0,1.0,3.0,0.0)"::polygon) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is " retrieve (false = "(2.0,2.0,0.0,0.0,4.0,0.0)"::polygon ~= "(3.0,3.0,1.0,1.0,3.0,0.0)"::polygon) " --------------- | false | --------------- | f | --------------- Go * Query sent to backend is " retrieve (true = "(2.0,2.0,0.0,0.0,4.0,0.0)"::polygon && "(3.0,3.0,1.0,1.0,3.0,0.0)"::polygon) " --------------- | true | --------------- | t | --------------- Go * Query sent to backend is " retrieve (onek.all) where onek.unique1 < 10 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 0 | 998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | AAAAAA | KMBAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1 | 214 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 3 | BAAAAA | GIAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 2 | 326 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 5 | CAAAAA | OMAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3 | 431 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 6 | 7 | DAAAAA | PQAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4 | 833 | 0 | 0 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 8 | 9 | EAAAAA | BGBAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5 | 541 | 1 | 1 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 10 | 11 | FAAAAA | VUAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6 | 978 | 0 | 2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 12 | 13 | GAAAAA | QLBAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7 | 647 | 1 | 3 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 14 | 15 | HAAAAA | XYAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8 | 653 | 0 | 0 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 16 | 17 | IAAAAA | DZAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9 | 49 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 18 | 19 | JAAAAA | XBAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is " retrieve (onek.unique1, onek.stringu1) where onek.unique1 < 20 sort by unique1 using > " ----------------------------- | unique1 | stringu1 | ----------------------------- | 19 | TAAAAA | ----------------------------- | 18 | SAAAAA | ----------------------------- | 17 | RAAAAA | ----------------------------- | 16 | QAAAAA | ----------------------------- | 15 | PAAAAA | ----------------------------- | 14 | OAAAAA | ----------------------------- | 13 | NAAAAA | ----------------------------- | 12 | MAAAAA | ----------------------------- | 11 | LAAAAA | ----------------------------- | 10 | KAAAAA | ----------------------------- | 9 | JAAAAA | ----------------------------- | 8 | IAAAAA | ----------------------------- | 7 | HAAAAA | ----------------------------- | 6 | GAAAAA | ----------------------------- | 5 | FAAAAA | ----------------------------- | 4 | EAAAAA | ----------------------------- | 3 | DAAAAA | ----------------------------- | 2 | CAAAAA | ----------------------------- | 1 | BAAAAA | ----------------------------- | 0 | AAAAAA | ----------------------------- Go * Query sent to backend is " retrieve (onek.unique1, onek.stringu1) where onek.unique1 > 980 sort by stringu1 using < " ----------------------------- | unique1 | stringu1 | ----------------------------- | 988 | AMAAAA | ----------------------------- | 989 | BMAAAA | ----------------------------- | 990 | CMAAAA | ----------------------------- | 991 | DMAAAA | ----------------------------- | 992 | EMAAAA | ----------------------------- | 993 | FMAAAA | ----------------------------- | 994 | GMAAAA | ----------------------------- | 995 | HMAAAA | ----------------------------- | 996 | IMAAAA | ----------------------------- | 997 | JMAAAA | ----------------------------- | 998 | KMAAAA | ----------------------------- | 999 | LMAAAA | ----------------------------- | 981 | TLAAAA | ----------------------------- | 982 | ULAAAA | ----------------------------- | 983 | VLAAAA | ----------------------------- | 984 | WLAAAA | ----------------------------- | 985 | XLAAAA | ----------------------------- | 986 | YLAAAA | ----------------------------- | 987 | ZLAAAA | ----------------------------- Go * Query sent to backend is " retrieve (onek.unique1, onek.string4) where onek.unique1 > 980 sort by string4 using <, unique1 using > " ----------------------------- | unique1 | string4 | ----------------------------- | 999 | AAAAxx | ----------------------------- | 995 | AAAAxx | ----------------------------- | 983 | AAAAxx | ----------------------------- | 982 | AAAAxx | ----------------------------- | 981 | AAAAxx | ----------------------------- | 998 | HHHHxx | ----------------------------- | 997 | HHHHxx | ----------------------------- | 993 | HHHHxx | ----------------------------- | 990 | HHHHxx | ----------------------------- | 986 | HHHHxx | ----------------------------- | 996 | OOOOxx | ----------------------------- | 991 | OOOOxx | ----------------------------- | 988 | OOOOxx | ----------------------------- | 987 | OOOOxx | ----------------------------- | 985 | OOOOxx | ----------------------------- | 994 | VVVVxx | ----------------------------- | 992 | VVVVxx | ----------------------------- | 989 | VVVVxx | ----------------------------- | 984 | VVVVxx | ----------------------------- Go * Query sent to backend is " retrieve (onek.unique1, onek.string4) where onek.unique1 > 980 sort by string4 using >, unique1 using < " ----------------------------- | unique1 | string4 | ----------------------------- | 984 | VVVVxx | ----------------------------- | 989 | VVVVxx | ----------------------------- | 992 | VVVVxx | ----------------------------- | 994 | VVVVxx | ----------------------------- | 985 | OOOOxx | ----------------------------- | 987 | OOOOxx | ----------------------------- | 988 | OOOOxx | ----------------------------- | 991 | OOOOxx | ----------------------------- | 996 | OOOOxx | ----------------------------- | 986 | HHHHxx | ----------------------------- | 990 | HHHHxx | ----------------------------- | 993 | HHHHxx | ----------------------------- | 997 | HHHHxx | ----------------------------- | 998 | HHHHxx | ----------------------------- | 981 | AAAAxx | ----------------------------- | 982 | AAAAxx | ----------------------------- | 983 | AAAAxx | ----------------------------- | 995 | AAAAxx | ----------------------------- | 999 | AAAAxx | ----------------------------- Go * Query sent to backend is " retrieve (onek.unique1, onek.string4) where onek.unique1 < 20 sort by unique1 using >, string4 using < " ----------------------------- | unique1 | string4 | ----------------------------- | 19 | OOOOxx | ----------------------------- | 18 | VVVVxx | ----------------------------- | 17 | HHHHxx | ----------------------------- | 16 | OOOOxx | ----------------------------- | 15 | VVVVxx | ----------------------------- | 14 | AAAAxx | ----------------------------- | 13 | OOOOxx | ----------------------------- | 12 | AAAAxx | ----------------------------- | 11 | OOOOxx | ----------------------------- | 10 | AAAAxx | ----------------------------- | 9 | HHHHxx | ----------------------------- | 8 | HHHHxx | ----------------------------- | 7 | VVVVxx | ----------------------------- | 6 | OOOOxx | ----------------------------- | 5 | HHHHxx | ----------------------------- | 4 | HHHHxx | ----------------------------- | 3 | VVVVxx | ----------------------------- | 2 | OOOOxx | ----------------------------- | 1 | OOOOxx | ----------------------------- | 0 | OOOOxx | ----------------------------- Go * Query sent to backend is " retrieve (onek.unique1, onek.string4) where onek.unique1 < 20 sort by unique1 using <, string4 using > " ----------------------------- | unique1 | string4 | ----------------------------- | 0 | OOOOxx | ----------------------------- | 1 | OOOOxx | ----------------------------- | 2 | OOOOxx | ----------------------------- | 3 | VVVVxx | ----------------------------- | 4 | HHHHxx | ----------------------------- | 5 | HHHHxx | ----------------------------- | 6 | OOOOxx | ----------------------------- | 7 | VVVVxx | ----------------------------- | 8 | HHHHxx | ----------------------------- | 9 | HHHHxx | ----------------------------- | 10 | AAAAxx | ----------------------------- | 11 | OOOOxx | ----------------------------- | 12 | AAAAxx | ----------------------------- | 13 | OOOOxx | ----------------------------- | 14 | AAAAxx | ----------------------------- | 15 | VVVVxx | ----------------------------- | 16 | OOOOxx | ----------------------------- | 17 | HHHHxx | ----------------------------- | 18 | VVVVxx | ----------------------------- | 19 | OOOOxx | ----------------------------- Go * Query sent to backend is " retrieve (onek2.all) where onek2.unique1 < 10 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 0 | 998 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | AAAAAA | KMBAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1 | 214 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 3 | BAAAAA | GIAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 2 | 326 | 0 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 4 | 5 | CAAAAA | OMAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3 | 431 | 1 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 6 | 7 | DAAAAA | PQAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4 | 833 | 0 | 0 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 8 | 9 | EAAAAA | BGBAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5 | 541 | 1 | 1 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 10 | 11 | FAAAAA | VUAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6 | 978 | 0 | 2 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 12 | 13 | GAAAAA | QLBAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7 | 647 | 1 | 3 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 14 | 15 | HAAAAA | XYAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8 | 653 | 0 | 0 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 16 | 17 | IAAAAA | DZAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9 | 49 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 18 | 19 | JAAAAA | XBAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is " retrieve (onek2.unique1, onek2.stringu1) where onek2.unique1 < 20 sort by unique1 using > " ----------------------------- | unique1 | stringu1 | ----------------------------- | 19 | TAAAAA | ----------------------------- | 18 | SAAAAA | ----------------------------- | 17 | RAAAAA | ----------------------------- | 16 | QAAAAA | ----------------------------- | 15 | PAAAAA | ----------------------------- | 14 | OAAAAA | ----------------------------- | 13 | NAAAAA | ----------------------------- | 12 | MAAAAA | ----------------------------- | 11 | LAAAAA | ----------------------------- | 10 | KAAAAA | ----------------------------- | 9 | JAAAAA | ----------------------------- | 8 | IAAAAA | ----------------------------- | 7 | HAAAAA | ----------------------------- | 6 | GAAAAA | ----------------------------- | 5 | FAAAAA | ----------------------------- | 4 | EAAAAA | ----------------------------- | 3 | DAAAAA | ----------------------------- | 2 | CAAAAA | ----------------------------- | 1 | BAAAAA | ----------------------------- | 0 | AAAAAA | ----------------------------- Go * Query sent to backend is " retrieve (onek2.unique1, onek2.stringu1) where onek2.unique1 > 980 sort by stringu1 using < " ----------------------------- | unique1 | stringu1 | ----------------------------- | 988 | AMAAAA | ----------------------------- | 989 | BMAAAA | ----------------------------- | 990 | CMAAAA | ----------------------------- | 991 | DMAAAA | ----------------------------- | 992 | EMAAAA | ----------------------------- | 993 | FMAAAA | ----------------------------- | 994 | GMAAAA | ----------------------------- | 995 | HMAAAA | ----------------------------- | 996 | IMAAAA | ----------------------------- | 997 | JMAAAA | ----------------------------- | 998 | KMAAAA | ----------------------------- | 999 | LMAAAA | ----------------------------- | 981 | TLAAAA | ----------------------------- | 982 | ULAAAA | ----------------------------- | 983 | VLAAAA | ----------------------------- | 984 | WLAAAA | ----------------------------- | 985 | XLAAAA | ----------------------------- | 986 | YLAAAA | ----------------------------- | 987 | ZLAAAA | ----------------------------- Go * Query sent to backend is "retrieve into temp (onek.two, onek.stringu1, onek.ten, onek.string4) " RETRIEVE Go * Query sent to backend is " retrieve unique (temp.two) " --------------- | two | --------------- | 0 | --------------- | 1 | --------------- Go * Query sent to backend is " retrieve unique (temp.ten) " --------------- | ten | --------------- | 0 | --------------- | 1 | --------------- | 2 | --------------- | 3 | --------------- | 4 | --------------- | 5 | --------------- | 6 | --------------- | 7 | --------------- | 8 | --------------- | 9 | --------------- Go * Query sent to backend is " retrieve unique (temp.string4) " --------------- | string4 | --------------- | AAAAxx | --------------- | HHHHxx | --------------- | OOOOxx | --------------- | VVVVxx | --------------- Go * Query sent to backend is " retrieve unique (temp.two, temp.string4, temp.ten) sort by two using <, string4 using <, ten using < " ------------------------------------------- | two | string4 | ten | ------------------------------------------- | 0 | AAAAxx | 0 | ------------------------------------------- | 0 | AAAAxx | 2 | ------------------------------------------- | 0 | AAAAxx | 4 | ------------------------------------------- | 0 | AAAAxx | 6 | ------------------------------------------- | 0 | AAAAxx | 8 | ------------------------------------------- | 0 | HHHHxx | 0 | ------------------------------------------- | 0 | HHHHxx | 2 | ------------------------------------------- | 0 | HHHHxx | 4 | ------------------------------------------- | 0 | HHHHxx | 6 | ------------------------------------------- | 0 | HHHHxx | 8 | ------------------------------------------- | 0 | OOOOxx | 0 | ------------------------------------------- | 0 | OOOOxx | 2 | ------------------------------------------- | 0 | OOOOxx | 4 | ------------------------------------------- | 0 | OOOOxx | 6 | ------------------------------------------- | 0 | OOOOxx | 8 | ------------------------------------------- | 0 | VVVVxx | 0 | ------------------------------------------- | 0 | VVVVxx | 2 | ------------------------------------------- | 0 | VVVVxx | 4 | ------------------------------------------- | 0 | VVVVxx | 6 | ------------------------------------------- | 0 | VVVVxx | 8 | ------------------------------------------- | 1 | AAAAxx | 1 | ------------------------------------------- | 1 | AAAAxx | 3 | ------------------------------------------- | 1 | AAAAxx | 5 | ------------------------------------------- | 1 | AAAAxx | 7 | ------------------------------------------- | 1 | AAAAxx | 9 | ------------------------------------------- | 1 | HHHHxx | 1 | ------------------------------------------- | 1 | HHHHxx | 3 | ------------------------------------------- | 1 | HHHHxx | 5 | ------------------------------------------- | 1 | HHHHxx | 7 | ------------------------------------------- | 1 | HHHHxx | 9 | ------------------------------------------- | 1 | OOOOxx | 1 | ------------------------------------------- | 1 | OOOOxx | 3 | ------------------------------------------- | 1 | OOOOxx | 5 | ------------------------------------------- | 1 | OOOOxx | 7 | ------------------------------------------- | 1 | OOOOxx | 9 | ------------------------------------------- | 1 | VVVVxx | 1 | ------------------------------------------- | 1 | VVVVxx | 3 | ------------------------------------------- | 1 | VVVVxx | 5 | ------------------------------------------- | 1 | VVVVxx | 7 | ------------------------------------------- | 1 | VVVVxx | 9 | ------------------------------------------- Go * Query sent to backend is "retrieve into temp1 (temp.all) where onek.unique1 < 2 " RETRIEVE Go * Query sent to backend is "destroy temp1 " DESTROY Go * Query sent to backend is "retrieve into temp1 (temp.all) where onek2.unique1 < 2 " RETRIEVE Go * Query sent to backend is "destroy temp1 " DESTROY Go * Query sent to backend is " retrieve (p.name, p.age) from p in person* " ----------------------------- | name | age | ----------------------------- | mike | 40 | ----------------------------- | joe | 20 | ----------------------------- | sally | 34 | ----------------------------- | sandra | 19 | ----------------------------- | alex | 30 | ----------------------------- | sue | 50 | ----------------------------- | denise | 24 | ----------------------------- | sarah | 88 | ----------------------------- | teresa | 38 | ----------------------------- | nan | 28 | ----------------------------- | leah | 68 | ----------------------------- | wendy | 78 | ----------------------------- | melissa | 28 | ----------------------------- | joan | 18 | ----------------------------- | mary | 8 | ----------------------------- | jane | 58 | ----------------------------- | liza | 38 | ----------------------------- | jean | 28 | ----------------------------- | jenifer | 38 | ----------------------------- | juanita | 58 | ----------------------------- | susan | 78 | ----------------------------- | zena | 98 | ----------------------------- | martie | 88 | ----------------------------- | chris | 78 | ----------------------------- | pat | 18 | ----------------------------- | zola | 58 | ----------------------------- | louise | 98 | ----------------------------- | edna | 18 | ----------------------------- | bertha | 88 | ----------------------------- | sumi | 38 | ----------------------------- | koko | 88 | ----------------------------- | gina | 18 | ----------------------------- | rean | 48 | ----------------------------- | sharon | 78 | ----------------------------- | paula | 68 | ----------------------------- | julie | 68 | ----------------------------- | belinda | 38 | ----------------------------- | karen | 48 | ----------------------------- | carina | 58 | ----------------------------- | diane | 18 | ----------------------------- | esther | 98 | ----------------------------- | trudy | 88 | ----------------------------- | fanny | 8 | ----------------------------- | carmen | 78 | ----------------------------- | lita | 25 | ----------------------------- | pamela | 48 | ----------------------------- | sandy | 38 | ----------------------------- | trisha | 88 | ----------------------------- | vera | 78 | ----------------------------- | velma | 68 | ----------------------------- | sharon | 25 | ----------------------------- | sam | 30 | ----------------------------- | bill | 20 | ----------------------------- | fred | 28 | ----------------------------- | larry | 60 | ----------------------------- | jeff | 23 | ----------------------------- | cim | 30 | ----------------------------- | linda | 19 | ----------------------------- Go * Query sent to backend is " retrieve (p.name, p.age) from p in person* sort by age using > " ----------------------------- | name | age | ----------------------------- | esther | 98 | ----------------------------- | louise | 98 | ----------------------------- | zena | 98 | ----------------------------- | martie | 88 | ----------------------------- | bertha | 88 | ----------------------------- | trisha | 88 | ----------------------------- | koko | 88 | ----------------------------- | sarah | 88 | ----------------------------- | trudy | 88 | ----------------------------- | vera | 78 | ----------------------------- | carmen | 78 | ----------------------------- | chris | 78 | ----------------------------- | sharon | 78 | ----------------------------- | susan | 78 | ----------------------------- | wendy | 78 | ----------------------------- | velma | 68 | ----------------------------- | leah | 68 | ----------------------------- | julie | 68 | ----------------------------- | paula | 68 | ----------------------------- | larry | 60 | ----------------------------- | carina | 58 | ----------------------------- | juanita | 58 | ----------------------------- | jane | 58 | ----------------------------- | zola | 58 | ----------------------------- | sue | 50 | ----------------------------- | karen | 48 | ----------------------------- | rean | 48 | ----------------------------- | pamela | 48 | ----------------------------- | mike | 40 | ----------------------------- | jenifer | 38 | ----------------------------- | sandy | 38 | ----------------------------- | teresa | 38 | ----------------------------- | liza | 38 | ----------------------------- | belinda | 38 | ----------------------------- | sumi | 38 | ----------------------------- | sally | 34 | ----------------------------- | alex | 30 | ----------------------------- | cim | 30 | ----------------------------- | sam | 30 | ----------------------------- | fred | 28 | ----------------------------- | nan | 28 | ----------------------------- | jean | 28 | ----------------------------- | melissa | 28 | ----------------------------- | sharon | 25 | ----------------------------- | lita | 25 | ----------------------------- | denise | 24 | ----------------------------- | jeff | 23 | ----------------------------- | joe | 20 | ----------------------------- | bill | 20 | ----------------------------- | linda | 19 | ----------------------------- | sandra | 19 | ----------------------------- | diane | 18 | ----------------------------- | edna | 18 | ----------------------------- | gina | 18 | ----------------------------- | joan | 18 | ----------------------------- | pat | 18 | ----------------------------- | fanny | 8 | ----------------------------- | mary | 8 | ----------------------------- Go * Query sent to backend is " retrieve unique (p.age) from p in person* sort by age using > " --------------- | age | --------------- | 98 | --------------- | 88 | --------------- | 78 | --------------- | 68 | --------------- | 60 | --------------- | 58 | --------------- | 50 | --------------- | 48 | --------------- | 40 | --------------- | 38 | --------------- | 34 | --------------- | 30 | --------------- | 28 | --------------- | 25 | --------------- | 24 | --------------- | 23 | --------------- | 20 | --------------- | 19 | --------------- | 18 | --------------- | 8 | --------------- Go * Query sent to backend is " retrieve (hasham_heap.all) where hasham_heap.random = 843938989 " ----------------------------- | seqno | random | ----------------------------- | 15 | 843938989 | ----------------------------- Go * Query sent to backend is " retrieve (hasham_heap.all) where hasham_heap.random = 66766766 " ----------------------------- | seqno | random | ----------------------------- Go * Query sent to backend is " replace onek (unique1 = onek.unique1 + 1) " REPLACE Go * Query sent to backend is "replace onek (unique1 = onek.unique1 - 1) " REPLACE Go * Query sent to backend is "replace onek2 (unique1 = onek2.unique1 + 1) " REPLACE Go * Query sent to backend is "replace onek2 (unique1 = onek2.unique1 - 1) " REPLACE Go * Query sent to backend is "replace temp (stringu1 = reverse_c16(o.stringu1)) from o in onek where o.stringu1 = "JBAAAA" and o.stringu1 = temp.stringu1 " NOTICE:Oct 2 18:19:54:Non-functional update, only first update is performed NOTICE:Oct 2 18:19:54:Non-functional update, only first update is performed REPLACE Go * Query sent to backend is "replace temp (stringu1 = reverse_c16(o.stringu1)) from o in onek2 where o.stringu1 = "JCAAAA" and o.stringu1 = temp.stringu1 " NOTICE:Oct 2 18:20:03:Non-functional update, only first update is performed NOTICE:Oct 2 18:20:07:Non-functional update, only first update is performed REPLACE Go * Query sent to backend is "destroy temp " DESTROY Go * Query sent to backend is "replace p (age = p.age + 1) from p in person* " REPLACE Go * Query sent to backend is "replace p (age = p.age + 3) from p in person* where p.name = "linda" " REPLACE Go * Query sent to backend is "replace hasham_heap (random = 1) where hasham_heap.seqno = 1492 " REPLACE Go * Query sent to backend is "retrieve (hasham_heap.all) where hasham_heap.random = 1 " ----------------------------- | seqno | random | ----------------------------- | 1492 | 1 | ----------------------------- Go * Query sent to backend is "replace hasham_heap (seqno = 20000) where hasham_heap.random = 1492795354 " REPLACE Go * Query sent to backend is "retrieve (hasham_heap.all) where hasham_heap.random = 1492795354 " ----------------------------- | seqno | random | ----------------------------- | 20000 | 1492795354 | ----------------------------- Go * Query sent to backend is " copy onek to "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/onek.data" " COPY Go * Query sent to backend is "delete onek " DELETE Go * Query sent to backend is "copy onek from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/onek.data" " COPY Go * Query sent to backend is "retrieve (onek.unique1) where onek.unique1 < 2 " --------------- | unique1 | --------------- | 0 | --------------- | 1 | --------------- Go * Query sent to backend is "delete onek2 " DELETE Go * Query sent to backend is "copy onek2 from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/onek.data" " COPY Go * Query sent to backend is "retrieve (onek2.unique1) where onek2.unique1 < 2 " --------------- | unique1 | --------------- | 0 | --------------- | 1 | --------------- Go * Query sent to backend is "copy binary stud_emp to "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/stud_emp.data" " COPY Go * Query sent to backend is "delete stud_emp " DELETE Go * Query sent to backend is "copy binary stud_emp from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj/stud_emp.data" " COPY Go * Query sent to backend is "retrieve (stud_emp.all) " --------------------------------------------------------------------------------------------------- | gpa | manager | salary | name | age | location | percent | --------------------------------------------------------------------------------------------------- | 3.5 | sharon | 600 | jeff | 24 | (8,7.7) | | --------------------------------------------------------------------------------------------------- | 3.4 | | 400 | cim | 31 | (10.5,4.7) | | --------------------------------------------------------------------------------------------------- | 2.9 | | 100 | linda | 23 | (0.9,6.1) | | --------------------------------------------------------------------------------------------------- Go * Query sent to backend is "copy aggtest from stdin " Enter info followed by a newline End with a dot on a line by itself. >> >> >> >> >> Go * Query sent to backend is "copy aggtest to stdout " Copy command returns... 56 7.8 100 99.097 0 0.09561 42 324.78 Go * Query sent to backend is " begin " BEGIN Go * Query sent to backend is "retrieve into xacttest (aggtest.all) " RETRIEVE Go * Query sent to backend is "append xacttest (a = 777, b = 777.777) " APPEND 177282 Go * Query sent to backend is "end " END Go * Query sent to backend is " retrieve (xacttest.a) where xacttest.a > 100 " --------------- | a | --------------- | 777 | --------------- Go * Query sent to backend is "begin " BEGIN Go * Query sent to backend is "create disappear (a = int4) " CREATE Go * Query sent to backend is "delete aggtest " DELETE Go * Query sent to backend is " retrieve (aggtest.all) " ----------------------------- | a | b | ----------------------------- Go * Query sent to backend is "abort " ABORT Go * Query sent to backend is " retrieve (pg_class.oid) where pg_class.relname = "disappear" " --------------- | oid | --------------- Go * Query sent to backend is " retrieve (aggtest.all) " ----------------------------- | a | b | ----------------------------- | 56 | 7.8 | ----------------------------- | 100 | 99.097 | ----------------------------- | 0 | 0.09561 | ----------------------------- | 42 | 324.78 | ----------------------------- Go * Query sent to backend is " begin " BEGIN Go * Query sent to backend is "retrieve portal foo1 (tenk1.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo2 (tenk2.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo3 (tenk1.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo4 (tenk2.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo5 (tenk1.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo6 (tenk2.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo7 (tenk1.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo8 (tenk2.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo9 (tenk1.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo10 (tenk2.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo11 (tenk1.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo12 (tenk2.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo13 (tenk1.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo14 (tenk2.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo15 (tenk1.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo16 (tenk2.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo17 (tenk1.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo18 (tenk2.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo19 (tenk1.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo20 (tenk2.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo21 (tenk1.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo22 (tenk2.all) " RETRIEVE Go * Query sent to backend is "retrieve portal foo23 (tenk1.all) " RETRIEVE Go * Query sent to backend is "fetch 1 in foo1 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 2 in foo2 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 3 in foo3 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 4 in foo4 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 5 in foo5 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 6 in foo6 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 7 in foo7 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 8 in foo8 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 9 in foo9 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 10 in foo10 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 11 in foo11 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 12 in foo12 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 13 in foo13 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 14 in foo14 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 15 in foo15 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 16 in foo16 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13 | OKAAAA | PAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 17 in foo17 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13 | OKAAAA | PAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175 | FZAAAA | QAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 18 in foo18 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13 | OKAAAA | PAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175 | FZAAAA | QAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171 | NOAAAA | RAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 19 in foo19 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13 | OKAAAA | PAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175 | FZAAAA | QAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171 | NOAAAA | RAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43 | RUAAAA | SAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 20 in foo20 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13 | OKAAAA | PAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175 | FZAAAA | QAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171 | NOAAAA | RAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43 | RUAAAA | SAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6969 | 19 | 1 | 1 | 9 | 9 | 69 | 969 | 969 | 1969 | 6969 | 138 | 139 | BIAAAA | TAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 21 in foo21 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13 | OKAAAA | PAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175 | FZAAAA | QAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171 | NOAAAA | RAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43 | RUAAAA | SAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6969 | 19 | 1 | 1 | 9 | 9 | 69 | 969 | 969 | 1969 | 6969 | 138 | 139 | BIAAAA | TAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9460 | 20 | 0 | 0 | 0 | 0 | 60 | 460 | 1460 | 4460 | 9460 | 120 | 121 | WZAAAA | UAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 22 in foo22 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13 | OKAAAA | PAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175 | FZAAAA | QAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171 | NOAAAA | RAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43 | RUAAAA | SAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6969 | 19 | 1 | 1 | 9 | 9 | 69 | 969 | 969 | 1969 | 6969 | 138 | 139 | BIAAAA | TAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9460 | 20 | 0 | 0 | 0 | 0 | 60 | 460 | 1460 | 4460 | 9460 | 120 | 121 | WZAAAA | UAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 59 | 21 | 1 | 3 | 9 | 19 | 59 | 59 | 59 | 59 | 59 | 118 | 119 | HCAAAA | VAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch 23 in foo23 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13 | OKAAAA | PAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175 | FZAAAA | QAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171 | NOAAAA | RAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43 | RUAAAA | SAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6969 | 19 | 1 | 1 | 9 | 9 | 69 | 969 | 969 | 1969 | 6969 | 138 | 139 | BIAAAA | TAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9460 | 20 | 0 | 0 | 0 | 0 | 60 | 460 | 1460 | 4460 | 9460 | 120 | 121 | WZAAAA | UAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 59 | 21 | 1 | 3 | 9 | 19 | 59 | 59 | 59 | 59 | 59 | 118 | 119 | HCAAAA | VAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8020 | 22 | 0 | 0 | 0 | 0 | 20 | 20 | 20 | 3020 | 8020 | 40 | 41 | MWAAAA | WAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 1 in foo23 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 59 | 21 | 1 | 3 | 9 | 19 | 59 | 59 | 59 | 59 | 59 | 118 | 119 | HCAAAA | VAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 2 in foo22 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9460 | 20 | 0 | 0 | 0 | 0 | 60 | 460 | 1460 | 4460 | 9460 | 120 | 121 | WZAAAA | UAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6969 | 19 | 1 | 1 | 9 | 9 | 69 | 969 | 969 | 1969 | 6969 | 138 | 139 | BIAAAA | TAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 3 in foo21 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6969 | 19 | 1 | 1 | 9 | 9 | 69 | 969 | 969 | 1969 | 6969 | 138 | 139 | BIAAAA | TAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43 | RUAAAA | SAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171 | NOAAAA | RAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 4 in foo20 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6621 | 18 | 1 | 1 | 1 | 1 | 21 | 621 | 621 | 1621 | 6621 | 42 | 43 | RUAAAA | SAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171 | NOAAAA | RAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175 | FZAAAA | QAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13 | OKAAAA | PAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 5 in foo19 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5785 | 17 | 1 | 1 | 5 | 5 | 85 | 785 | 1785 | 785 | 5785 | 170 | 171 | NOAAAA | RAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175 | FZAAAA | QAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13 | OKAAAA | PAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 6 in foo18 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5387 | 16 | 1 | 3 | 7 | 7 | 87 | 387 | 1387 | 387 | 5387 | 174 | 175 | FZAAAA | QAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13 | OKAAAA | PAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 7 in foo17 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5006 | 15 | 0 | 2 | 6 | 6 | 6 | 6 | 1006 | 6 | 5006 | 12 | 13 | OKAAAA | PAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 8 in foo16 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5471 | 14 | 1 | 3 | 1 | 11 | 71 | 471 | 1471 | 471 | 5471 | 142 | 143 | LCAAAA | OAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 9 in foo15 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6243 | 13 | 1 | 3 | 3 | 3 | 43 | 243 | 243 | 1243 | 6243 | 86 | 87 | DGAAAA | NAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 10 in foo14 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5222 | 12 | 0 | 2 | 2 | 2 | 22 | 222 | 1222 | 222 | 5222 | 44 | 45 | WSAAAA | MAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 11 in foo13 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1504 | 11 | 0 | 0 | 4 | 4 | 4 | 504 | 1504 | 1504 | 1504 | 8 | 9 | WFAAAA | LAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 12 in foo12 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1314 | 10 | 0 | 2 | 4 | 14 | 14 | 314 | 1314 | 1314 | 1314 | 28 | 29 | OYAAAA | KAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 13 in foo11 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3043 | 9 | 1 | 3 | 3 | 3 | 43 | 43 | 1043 | 3043 | 3043 | 86 | 87 | BNAAAA | JAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 14 in foo10 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 4321 | 8 | 1 | 1 | 1 | 1 | 21 | 321 | 321 | 4321 | 4321 | 42 | 43 | FKAAAA | IAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 15 in foo9 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 6701 | 7 | 1 | 1 | 1 | 1 | 1 | 701 | 701 | 1701 | 6701 | 2 | 3 | TXAAAA | HAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 16 in foo8 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 5057 | 6 | 1 | 1 | 7 | 17 | 57 | 57 | 1057 | 57 | 5057 | 114 | 115 | NMAAAA | GAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 17 in foo7 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8009 | 5 | 1 | 1 | 9 | 9 | 9 | 9 | 9 | 3009 | 8009 | 18 | 19 | BWAAAA | FAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 18 in foo6 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 7164 | 4 | 0 | 0 | 4 | 4 | 64 | 164 | 1164 | 2164 | 7164 | 128 | 129 | OPAAAA | EAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 19 in foo5 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 9850 | 3 | 0 | 2 | 0 | 10 | 50 | 850 | 1850 | 4850 | 9850 | 100 | 101 | WOAAAA | DAAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 20 in foo4 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 3420 | 2 | 0 | 0 | 0 | 0 | 20 | 420 | 1420 | 3420 | 3420 | 40 | 41 | OBAAAA | CAAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 21 in foo3 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 | 1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 22 in foo2 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 | 800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch backward 23 in foo1 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "close foo1 " CLOSE Go * Query sent to backend is "close foo2 " CLOSE Go * Query sent to backend is "close foo3 " CLOSE Go * Query sent to backend is "close foo4 " CLOSE Go * Query sent to backend is "close foo5 " CLOSE Go * Query sent to backend is "close foo6 " CLOSE Go * Query sent to backend is "close foo7 " CLOSE Go * Query sent to backend is "close foo8 " CLOSE Go * Query sent to backend is "close foo9 " CLOSE Go * Query sent to backend is "close foo10 " CLOSE Go * Query sent to backend is "close foo11 " CLOSE Go * Query sent to backend is "close foo12 " CLOSE Go * Query sent to backend is "end " END Go * Query sent to backend is "extend index onek2_u1_prtl where onek2.unique1 <= 60 " EXTEND Go * Query sent to backend is "begin " BEGIN Go * Query sent to backend is "retrieve portal foo13 (onek.all) where onek.unique1 = 50 " RETRIEVE Go * Query sent to backend is "retrieve portal foo14 (onek.all) where onek.unique1 = 51 " RETRIEVE Go * Query sent to backend is "retrieve portal foo15 (onek.all) where onek.unique1 = 52 " RETRIEVE Go * Query sent to backend is "retrieve portal foo16 (onek.all) where onek.unique1 = 53 " RETRIEVE Go * Query sent to backend is "retrieve portal foo17 (onek.all) where onek.unique1 = 54 " RETRIEVE Go * Query sent to backend is "retrieve portal foo18 (onek.all) where onek.unique1 = 55 " RETRIEVE Go * Query sent to backend is "retrieve portal foo19 (onek.all) where onek.unique1 = 56 " RETRIEVE Go * Query sent to backend is "retrieve portal foo20 (onek.all) where onek.unique1 = 57 " RETRIEVE Go * Query sent to backend is "retrieve portal foo21 (onek.all) where onek.unique1 = 58 " RETRIEVE Go * Query sent to backend is "retrieve portal foo22 (onek.all) where onek.unique1 = 59 " RETRIEVE Go * Query sent to backend is "retrieve portal foo23 (onek.all) where onek.unique1 = 60 " RETRIEVE Go * Query sent to backend is "retrieve portal foo24 (onek2.all) where onek2.unique1 = 50 " RETRIEVE Go * Query sent to backend is "retrieve portal foo25 (onek2.all) where onek2.unique1 = 60 " RETRIEVE Go * Query sent to backend is "fetch all in foo13 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 50 | 253 | 0 | 2 | 0 | 10 | 0 | 50 | 50 | 50 | 50 | 0 | 1 | YBAAAA | TJAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch all in foo14 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 51 | 76 | 1 | 3 | 1 | 11 | 1 | 51 | 51 | 51 | 51 | 2 | 3 | ZBAAAA | YCAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch all in foo15 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 52 | 985 | 0 | 0 | 2 | 12 | 2 | 52 | 52 | 52 | 52 | 4 | 5 | ACAAAA | XLBAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch all in foo16 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 53 | 196 | 1 | 1 | 3 | 13 | 3 | 53 | 53 | 53 | 53 | 6 | 7 | BCAAAA | OHAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch all in foo17 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 54 | 356 | 0 | 2 | 4 | 14 | 4 | 54 | 54 | 54 | 54 | 8 | 9 | CCAAAA | SNAAAA | AAAAxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch all in foo18 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 55 | 627 | 1 | 3 | 5 | 15 | 5 | 55 | 55 | 55 | 55 | 10 | 11 | DCAAAA | DYAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch all in foo19 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 56 | 54 | 0 | 0 | 6 | 16 | 6 | 56 | 56 | 56 | 56 | 12 | 13 | ECAAAA | CCAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch all in foo20 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 57 | 942 | 1 | 1 | 7 | 17 | 7 | 57 | 57 | 57 | 57 | 14 | 15 | FCAAAA | GKBAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch all in foo21 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 58 | 114 | 0 | 2 | 8 | 18 | 8 | 58 | 58 | 58 | 58 | 16 | 17 | GCAAAA | KEAAAA | OOOOxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch all in foo22 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 59 | 593 | 1 | 3 | 9 | 19 | 9 | 59 | 59 | 59 | 59 | 18 | 19 | HCAAAA | VWAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch all in foo23 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 60 | 483 | 0 | 0 | 0 | 0 | 0 | 60 | 60 | 60 | 60 | 0 | 1 | ICAAAA | PSAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch all in foo24 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 50 | 253 | 0 | 2 | 0 | 10 | 0 | 50 | 50 | 50 | 50 | 0 | 1 | YBAAAA | TJAAAA | HHHHxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "fetch all in foo25 " --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4 | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 60 | 483 | 0 | 0 | 0 | 0 | 0 | 60 | 60 | 60 | 60 | 0 | 1 | ICAAAA | PSAAAA | VVVVxx | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "close foo13 " CLOSE Go * Query sent to backend is "close foo14 " CLOSE Go * Query sent to backend is "close foo15 " CLOSE Go * Query sent to backend is "close foo16 " CLOSE Go * Query sent to backend is "close foo17 " CLOSE Go * Query sent to backend is "close foo18 " CLOSE Go * Query sent to backend is "close foo19 " CLOSE Go * Query sent to backend is "close foo20 " CLOSE Go * Query sent to backend is "close foo21 " CLOSE Go * Query sent to backend is "close foo22 " CLOSE Go * Query sent to backend is "close foo23 " CLOSE Go * Query sent to backend is "close foo24 " CLOSE Go * Query sent to backend is "close foo25 " CLOSE Go * Query sent to backend is "end " END Go * Query sent to backend is " create temp (initial = int4) " CREATE Go * Query sent to backend is "addattr (a = int4) to temp " ADD Go * Query sent to backend is "addattr (b = char16, c = text, d = float8, e = float4, f = int2, g = polygon, h = abstime, i = char, j = abstime[], k = dt, l = tid, m = xid, n = oid8, o = lock, p = smgr, q = point, r = lseg, s = path, t = box, u = tinterval, v = oidint4, w = oidchar16, x = float8[], y = float4[], z = int2[]) to temp " ADD Go * Query sent to backend is "append temp (a=4, b="char16", c="text", d=4.1, e=4.1, f=2, g="(4.1,4.1,3.1,3.1)", h="now", i='c', j="{now, Monday Aug 24 14:43:07 1992 PDT, epoch}", k=314159, l="(1,0,1)", m=512, n="1 2 3 4 5 6 7 8", p="magnetic disk", q="(1.1,1.1)", r="(4.1,4.1,3.1,3.1)", s="(0,2,4.1,4.1,3.1,3.1)", t="(4.1,4.1,3.1,3.1)", u="['current' 'infinity']", v="1/3", w="1,char16", x="{1.0,2.0,3.0,4.0}", y="{1.0,2.0,3.0,4.0}", z="{1,2,3,4}") " WARN:Oct 2 18:21:04:parser: syntax error at or near "char16" Go * Query sent to backend is "retrieve (temp.all) " ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | initial | a | b | c | d | e | f | g | h | i | j | k | l | m | n | o | p | q | r | s | t | u | v | w | x | y | z | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Go * Query sent to backend is "destroy temp " DESTROY Go * Query sent to backend is " rename tenk1 to ten_k " RENAME Go * Query sent to backend is " retrieve (ten_k.unique1) where ten_k.unique1 < 20 " --------------- | unique1 | --------------- | 0 | --------------- | 1 | --------------- | 2 | --------------- | 3 | --------------- | 4 | --------------- | 5 | --------------- | 6 | --------------- | 7 | --------------- | 8 | --------------- | 9 | --------------- | 10 | --------------- | 11 | --------------- | 12 | --------------- | 13 | --------------- | 14 | --------------- | 15 | --------------- | 16 | --------------- | 17 | --------------- | 18 | --------------- | 19 | --------------- Go * Query sent to backend is " retrieve (ten_k.unique2) where ten_k.unique2 < 20 " --------------- | unique2 | --------------- | 0 | --------------- | 1 | --------------- | 2 | --------------- | 3 | --------------- | 4 | --------------- | 5 | --------------- | 6 | --------------- | 7 | --------------- | 8 | --------------- | 9 | --------------- | 10 | --------------- | 11 | --------------- | 12 | --------------- | 13 | --------------- | 14 | --------------- | 15 | --------------- | 16 | --------------- | 17 | --------------- | 18 | --------------- | 19 | --------------- Go * Query sent to backend is " retrieve (ten_k.hundred) where ten_k.hundred = 50 " --------------- | hundred | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- | 50 | --------------- Go * Query sent to backend is "rename ten_k to tenk1 " RENAME Go * Query sent to backend is " retrieve (tenk1.unique1) where tenk1.unique1 < 5 " --------------- | unique1 | --------------- | 0 | --------------- | 1 | --------------- | 2 | --------------- | 3 | --------------- | 4 | --------------- Go * Query sent to backend is " retrieve (avg_1 = int4ave{onek.four}) " --------------- | avg_1 | --------------- | 1 | --------------- Go * Query sent to backend is "retrieve (avg_32 = int2ave{aggtest.a where aggtest.a < 100}) " --------------- | avg_32 | --------------- | 32 | --------------- Go * Query sent to backend is "retrieve (avg_107_943 = float4ave{aggtest.b}) " --------------- | avg_107_943 | --------------- | 107.943 | --------------- Go * Query sent to backend is "retrieve (avg_3_4 = float8ave{student.gpa}) " --------------- | avg_3_4 | --------------- | 3.4 | --------------- Go * Query sent to backend is "retrieve (sum_1500 = int4sum{onek.four}) " --------------- | sum_1500 | --------------- | 1500 | --------------- Go * Query sent to backend is "retrieve (sum_198 = int2sum{aggtest.a}) " --------------- | sum_198 | --------------- | 198 | --------------- Go * Query sent to backend is "retrieve (avg_431_773 = float4sum{aggtest.b}) " --------------- | avg_431_773 | --------------- | 431.773 | --------------- Go * Query sent to backend is "retrieve (avg_6_8 = float8sum{student.gpa}) " --------------- | avg_6_8 | --------------- | 6.8 | --------------- Go * Query sent to backend is "retrieve (max_3 = int4max{onek.four}) " --------------- | max_3 | --------------- | 3 | --------------- Go * Query sent to backend is "retrieve (max_100 = int2max{aggtest.a}) " --------------- | max_100 | --------------- | 100 | --------------- Go * Query sent to backend is "retrieve (max_324_78 = float4max{aggtest.b}) " --------------- | max_324_78 | --------------- | 324.78 | --------------- Go * Query sent to backend is "retrieve (max_3_7 = float8max{student.gpa}) " --------------- | max_3_7 | --------------- | 3.7 | --------------- Go * Query sent to backend is "retrieve (cnt_1000 = count{onek.four}) " --------------- | cnt_1000 | --------------- | 1000 | --------------- Go * Query sent to backend is "retrieve (avg_1 = newavg{onek.four}) " --------------- | avg_1 | --------------- | 1 | --------------- Go * Query sent to backend is "retrieve (sum_1500 = newsum{onek.four}) " --------------- | sum_1500 | --------------- | 1500 | --------------- Go * Query sent to backend is "retrieve (cnt_1000 = newcnt{onek.four}) " --------------- | cnt_1000 | --------------- | 1000 | --------------- Go * Query sent to backend is " retrieve (p.name, p.hobbies.name) from p in person " ----------------------------- | name | name | ----------------------------- | mike | posthacking | ----------------------------- | joe | basketball | ----------------------------- | sally | basketball | ----------------------------- | sandra | | ----------------------------- | alex | | ----------------------------- | sue | | ----------------------------- | denise | | ----------------------------- | sarah | | ----------------------------- | teresa | | ----------------------------- | nan | | ----------------------------- | leah | | ----------------------------- | wendy | | ----------------------------- | melissa | | ----------------------------- | joan | | ----------------------------- | mary | | ----------------------------- | jane | | ----------------------------- | liza | | ----------------------------- | jean | | ----------------------------- | jenifer | | ----------------------------- | juanita | | ----------------------------- | susan | | ----------------------------- | zena | | ----------------------------- | martie | | ----------------------------- | chris | | ----------------------------- | pat | | ----------------------------- | zola | | ----------------------------- | louise | | ----------------------------- | edna | | ----------------------------- | bertha | | ----------------------------- | sumi | | ----------------------------- | koko | | ----------------------------- | gina | | ----------------------------- | rean | | ----------------------------- | sharon | | ----------------------------- | paula | | ----------------------------- | julie | | ----------------------------- | belinda | | ----------------------------- | karen | | ----------------------------- | carina | | ----------------------------- | diane | | ----------------------------- | esther | | ----------------------------- | trudy | | ----------------------------- | fanny | | ----------------------------- | carmen | | ----------------------------- | lita | | ----------------------------- | pamela | | ----------------------------- | sandy | | ----------------------------- | trisha | | ----------------------------- | vera | | ----------------------------- | velma | | ----------------------------- Go * Query sent to backend is " retrieve (p.name, p.hobbies.name) from p in person* " ----------------------------- | name | name | ----------------------------- | mike | posthacking | ----------------------------- | joe | basketball | ----------------------------- | sally | basketball | ----------------------------- | sandra | | ----------------------------- | alex | | ----------------------------- | sue | | ----------------------------- | denise | | ----------------------------- | sarah | | ----------------------------- | teresa | | ----------------------------- | nan | | ----------------------------- | leah | | ----------------------------- | wendy | | ----------------------------- | melissa | | ----------------------------- | joan | | ----------------------------- | mary | | ----------------------------- | jane | | ----------------------------- | liza | | ----------------------------- | jean | | ----------------------------- | jenifer | | ----------------------------- | juanita | | ----------------------------- | susan | | ----------------------------- | zena | | ----------------------------- | martie | | ----------------------------- | chris | | ----------------------------- | pat | | ----------------------------- | zola | | ----------------------------- | louise | | ----------------------------- | edna | | ----------------------------- | bertha | | ----------------------------- | sumi | | ----------------------------- | koko | | ----------------------------- | gina | | ----------------------------- | rean | | ----------------------------- | sharon | | ----------------------------- | paula | | ----------------------------- | julie | | ----------------------------- | belinda | | ----------------------------- | karen | | ----------------------------- | carina | | ----------------------------- | diane | | ----------------------------- | esther | | ----------------------------- | trudy | | ----------------------------- | fanny | | ----------------------------- | carmen | | ----------------------------- | lita | | ----------------------------- | pamela | | ----------------------------- | sandy | | ----------------------------- | trisha | | ----------------------------- | vera | | ----------------------------- | velma | | ----------------------------- | sharon | | ----------------------------- | sam | | ----------------------------- | bill | | ----------------------------- | fred | | ----------------------------- | larry | | ----------------------------- | jeff | posthacking | ----------------------------- | cim | | ----------------------------- | linda | | ----------------------------- Go * Query sent to backend is " retrieve unique (hobbies_r.name, hobbies_r.equipment.name) " ----------------------------- | name | name | ----------------------------- | basketball | hightops | ----------------------------- | posthacking | advil | ----------------------------- | posthacking | peet's coffee| ----------------------------- | skywalking | guts | ----------------------------- Go * Query sent to backend is "retrieve (hobbies_r.name, hobbies_r.equipment.name) " ----------------------------- | name | name | ----------------------------- | posthacking | advil | ----------------------------- | posthacking | peet's coffee| ----------------------------- | posthacking | advil | ----------------------------- | posthacking | peet's coffee| ----------------------------- | basketball | hightops | ----------------------------- | basketball | hightops | ----------------------------- | skywalking | guts | ----------------------------- Go * Query sent to backend is " retrieve (p.name, p.hobbies.name, p.hobbies.equipment.name) from p in person " ------------------------------------------- | name | name | name | ------------------------------------------- | mike | posthacking | advil | ------------------------------------------- | mike | posthacking | peet's coffee| ------------------------------------------- | joe | basketball | hightops | ------------------------------------------- | sally | basketball | hightops | ------------------------------------------- | sandra | | | ------------------------------------------- | alex | | | ------------------------------------------- | sue | | | ------------------------------------------- | denise | | | ------------------------------------------- | sarah | | | ------------------------------------------- | teresa | | | ------------------------------------------- | nan | | | ------------------------------------------- | leah | | | ------------------------------------------- | wendy | | | ------------------------------------------- | melissa | | | ------------------------------------------- | joan | | | ------------------------------------------- | mary | | | ------------------------------------------- | jane | | | ------------------------------------------- | liza | | | ------------------------------------------- | jean | | | ------------------------------------------- | jenifer | | | ------------------------------------------- | juanita | | | ------------------------------------------- | susan | | | ------------------------------------------- | zena | | | ------------------------------------------- | martie | | | ------------------------------------------- | chris | | | ------------------------------------------- | pat | | | ------------------------------------------- | zola | | | ------------------------------------------- | louise | | | ------------------------------------------- | edna | | | ------------------------------------------- | bertha | | | ------------------------------------------- | sumi | | | ------------------------------------------- | koko | | | ------------------------------------------- | gina | | | ------------------------------------------- | rean | | | ------------------------------------------- | sharon | | | ------------------------------------------- | paula | | | ------------------------------------------- | julie | | | ------------------------------------------- | belinda | | | ------------------------------------------- | karen | | | ------------------------------------------- | carina | | | ------------------------------------------- | diane | | | ------------------------------------------- | esther | | | ------------------------------------------- | trudy | | | ------------------------------------------- | fanny | | | ------------------------------------------- | carmen | | | ------------------------------------------- | lita | | | ------------------------------------------- | pamela | | | ------------------------------------------- | sandy | | | ------------------------------------------- | trisha | | | ------------------------------------------- | vera | | | ------------------------------------------- | velma | | | ------------------------------------------- Go * Query sent to backend is " retrieve (p.name, p.hobbies.name, p.hobbies.equipment.name) from p in person* " ------------------------------------------- | name | name | name | ------------------------------------------- | mike | posthacking | advil | ------------------------------------------- | mike | posthacking | peet's coffee| ------------------------------------------- | joe | basketball | hightops | ------------------------------------------- | sally | basketball | hightops | ------------------------------------------- | sandra | | | ------------------------------------------- | alex | | | ------------------------------------------- | sue | | | ------------------------------------------- | denise | | | ------------------------------------------- | sarah | | | ------------------------------------------- | teresa | | | ------------------------------------------- | nan | | | ------------------------------------------- | leah | | | ------------------------------------------- | wendy | | | ------------------------------------------- | melissa | | | ------------------------------------------- | joan | | | ------------------------------------------- | mary | | | ------------------------------------------- | jane | | | ------------------------------------------- | liza | | | ------------------------------------------- | jean | | | ------------------------------------------- | jenifer | | | ------------------------------------------- | juanita | | | ------------------------------------------- | susan | | | ------------------------------------------- | zena | | | ------------------------------------------- | martie | | | ------------------------------------------- | chris | | | ------------------------------------------- | pat | | | ------------------------------------------- | zola | | | ------------------------------------------- | louise | | | ------------------------------------------- | edna | | | ------------------------------------------- | bertha | | | ------------------------------------------- | sumi | | | ------------------------------------------- | koko | | | ------------------------------------------- | gina | | | ------------------------------------------- | rean | | | ------------------------------------------- | sharon | | | ------------------------------------------- | paula | | | ------------------------------------------- | julie | | | ------------------------------------------- | belinda | | | ------------------------------------------- | karen | | | ------------------------------------------- | carina | | | ------------------------------------------- | diane | | | ------------------------------------------- | esther | | | ------------------------------------------- | trudy | | | ------------------------------------------- | fanny | | | ------------------------------------------- | carmen | | | ------------------------------------------- | lita | | | ------------------------------------------- | pamela | | | ------------------------------------------- | sandy | | | ------------------------------------------- | trisha | | | ------------------------------------------- | vera | | | ------------------------------------------- | velma | | | ------------------------------------------- | sharon | | | ------------------------------------------- | sam | | | ------------------------------------------- | bill | | | ------------------------------------------- | fred | | | ------------------------------------------- | larry | | | ------------------------------------------- | jeff | posthacking | advil | ------------------------------------------- | jeff | posthacking | peet's coffee| ------------------------------------------- | cim | | | ------------------------------------------- | linda | | | ------------------------------------------- Go * Query sent to backend is " retrieve (p.hobbies.equipment.name, p.name, p.hobbies.name) from p in person " ------------------------------------------- | name | name | name | ------------------------------------------- | advil | mike | posthacking | ------------------------------------------- | peet's coffee| mike | posthacking | ------------------------------------------- | hightops | joe | basketball | ------------------------------------------- | hightops | sally | basketball | ------------------------------------------- | | sandra | | ------------------------------------------- | | alex | | ------------------------------------------- | | sue | | ------------------------------------------- | | denise | | ------------------------------------------- | | sarah | | ------------------------------------------- | | teresa | | ------------------------------------------- | | nan | | ------------------------------------------- | | leah | | ------------------------------------------- | | wendy | | ------------------------------------------- | | melissa | | ------------------------------------------- | | joan | | ------------------------------------------- | | mary | | ------------------------------------------- | | jane | | ------------------------------------------- | | liza | | ------------------------------------------- | | jean | | ------------------------------------------- | | jenifer | | ------------------------------------------- | | juanita | | ------------------------------------------- | | susan | | ------------------------------------------- | | zena | | ------------------------------------------- | | martie | | ------------------------------------------- | | chris | | ------------------------------------------- | | pat | | ------------------------------------------- | | zola | | ------------------------------------------- | | louise | | ------------------------------------------- | | edna | | ------------------------------------------- | | bertha | | ------------------------------------------- | | sumi | | ------------------------------------------- | | koko | | ------------------------------------------- | | gina | | ------------------------------------------- | | rean | | ------------------------------------------- | | sharon | | ------------------------------------------- | | paula | | ------------------------------------------- | | julie | | ------------------------------------------- | | belinda | | ------------------------------------------- | | karen | | ------------------------------------------- | | carina | | ------------------------------------------- | | diane | | ------------------------------------------- | | esther | | ------------------------------------------- | | trudy | | ------------------------------------------- | | fanny | | ------------------------------------------- | | carmen | | ------------------------------------------- | | lita | | ------------------------------------------- | | pamela | | ------------------------------------------- | | sandy | | ------------------------------------------- | | trisha | | ------------------------------------------- | | vera | | ------------------------------------------- | | velma | | ------------------------------------------- Go * Query sent to backend is "retrieve (p.hobbies.equipment.name, p.name, p.hobbies.name) from p in person* " ------------------------------------------- | name | name | name | ------------------------------------------- | advil | mike | posthacking | ------------------------------------------- | peet's coffee| mike | posthacking | ------------------------------------------- | hightops | joe | basketball | ------------------------------------------- | hightops | sally | basketball | ------------------------------------------- | | sandra | | ------------------------------------------- | | alex | | ------------------------------------------- | | sue | | ------------------------------------------- | | denise | | ------------------------------------------- | | sarah | | ------------------------------------------- | | teresa | | ------------------------------------------- | | nan | | ------------------------------------------- | | leah | | ------------------------------------------- | | wendy | | ------------------------------------------- | | melissa | | ------------------------------------------- | | joan | | ------------------------------------------- | | mary | | ------------------------------------------- | | jane | | ------------------------------------------- | | liza | | ------------------------------------------- | | jean | | ------------------------------------------- | | jenifer | | ------------------------------------------- | | juanita | | ------------------------------------------- | | susan | | ------------------------------------------- | | zena | | ------------------------------------------- | | martie | | ------------------------------------------- | | chris | | ------------------------------------------- | | pat | | ------------------------------------------- | | zola | | ------------------------------------------- | | louise | | ------------------------------------------- | | edna | | ------------------------------------------- | | bertha | | ------------------------------------------- | | sumi | | ------------------------------------------- | | koko | | ------------------------------------------- | | gina | | ------------------------------------------- | | rean | | ------------------------------------------- | | sharon | | ------------------------------------------- | | paula | | ------------------------------------------- | | julie | | ------------------------------------------- | | belinda | | ------------------------------------------- | | karen | | ------------------------------------------- | | carina | | ------------------------------------------- | | diane | | ------------------------------------------- | | esther | | ------------------------------------------- | | trudy | | ------------------------------------------- | | fanny | | ------------------------------------------- | | carmen | | ------------------------------------------- | | lita | | ------------------------------------------- | | pamela | | ------------------------------------------- | | sandy | | ------------------------------------------- | | trisha | | ------------------------------------------- | | vera | | ------------------------------------------- | | velma | | ------------------------------------------- | | sharon | | ------------------------------------------- | | sam | | ------------------------------------------- | | bill | | ------------------------------------------- | | fred | | ------------------------------------------- | | larry | | ------------------------------------------- | advil | jeff | posthacking | ------------------------------------------- | peet's coffee| jeff | posthacking | ------------------------------------------- | | cim | | ------------------------------------------- | | linda | | ------------------------------------------- Go * Query sent to backend is "retrieve (p.hobbies.equipment.name, p.hobbies.name, p.name) from p in person " ------------------------------------------- | name | name | name | ------------------------------------------- | advil | posthacking | mike | ------------------------------------------- | peet's coffee| posthacking | mike | ------------------------------------------- | hightops | basketball | joe | ------------------------------------------- | hightops | basketball | sally | ------------------------------------------- | | | sandra | ------------------------------------------- | | | alex | ------------------------------------------- | | | sue | ------------------------------------------- | | | denise | ------------------------------------------- | | | sarah | ------------------------------------------- | | | teresa | ------------------------------------------- | | | nan | ------------------------------------------- | | | leah | ------------------------------------------- | | | wendy | ------------------------------------------- | | | melissa | ------------------------------------------- | | | joan | ------------------------------------------- | | | mary | ------------------------------------------- | | | jane | ------------------------------------------- | | | liza | ------------------------------------------- | | | jean | ------------------------------------------- | | | jenifer | ------------------------------------------- | | | juanita | ------------------------------------------- | | | susan | ------------------------------------------- | | | zena | ------------------------------------------- | | | martie | ------------------------------------------- | | | chris | ------------------------------------------- | | | pat | ------------------------------------------- | | | zola | ------------------------------------------- | | | louise | ------------------------------------------- | | | edna | ------------------------------------------- | | | bertha | ------------------------------------------- | | | sumi | ------------------------------------------- | | | koko | ------------------------------------------- | | | gina | ------------------------------------------- | | | rean | ------------------------------------------- | | | sharon | ------------------------------------------- | | | paula | ------------------------------------------- | | | julie | ------------------------------------------- | | | belinda | ------------------------------------------- | | | karen | ------------------------------------------- | | | carina | ------------------------------------------- | | | diane | ------------------------------------------- | | | esther | ------------------------------------------- | | | trudy | ------------------------------------------- | | | fanny | ------------------------------------------- | | | carmen | ------------------------------------------- | | | lita | ------------------------------------------- | | | pamela | ------------------------------------------- | | | sandy | ------------------------------------------- | | | trisha | ------------------------------------------- | | | vera | ------------------------------------------- | | | velma | ------------------------------------------- Go * Query sent to backend is "retrieve (p.hobbies.equipment.name, p.hobbies.name, p.name) from p in person* " ------------------------------------------- | name | name | name | ------------------------------------------- | advil | posthacking | mike | ------------------------------------------- | peet's coffee| posthacking | mike | ------------------------------------------- | hightops | basketball | joe | ------------------------------------------- | hightops | basketball | sally | ------------------------------------------- | | | sandra | ------------------------------------------- | | | alex | ------------------------------------------- | | | sue | ------------------------------------------- | | | denise | ------------------------------------------- | | | sarah | ------------------------------------------- | | | teresa | ------------------------------------------- | | | nan | ------------------------------------------- | | | leah | ------------------------------------------- | | | wendy | ------------------------------------------- | | | melissa | ------------------------------------------- | | | joan | ------------------------------------------- | | | mary | ------------------------------------------- | | | jane | ------------------------------------------- | | | liza | ------------------------------------------- | | | jean | ------------------------------------------- | | | jenifer | ------------------------------------------- | | | juanita | ------------------------------------------- | | | susan | ------------------------------------------- | | | zena | ------------------------------------------- | | | martie | ------------------------------------------- | | | chris | ------------------------------------------- | | | pat | ------------------------------------------- | | | zola | ------------------------------------------- | | | louise | ------------------------------------------- | | | edna | ------------------------------------------- | | | bertha | ------------------------------------------- | | | sumi | ------------------------------------------- | | | koko | ------------------------------------------- | | | gina | ------------------------------------------- | | | rean | ------------------------------------------- | | | sharon | ------------------------------------------- | | | paula | ------------------------------------------- | | | julie | ------------------------------------------- | | | belinda | ------------------------------------------- | | | karen | ------------------------------------------- | | | carina | ------------------------------------------- | | | diane | ------------------------------------------- | | | esther | ------------------------------------------- | | | trudy | ------------------------------------------- | | | fanny | ------------------------------------------- | | | carmen | ------------------------------------------- | | | lita | ------------------------------------------- | | | pamela | ------------------------------------------- | | | sandy | ------------------------------------------- | | | trisha | ------------------------------------------- | | | vera | ------------------------------------------- | | | velma | ------------------------------------------- | | | sharon | ------------------------------------------- | | | sam | ------------------------------------------- | | | bill | ------------------------------------------- | | | fred | ------------------------------------------- | | | larry | ------------------------------------------- | advil | posthacking | jeff | ------------------------------------------- | peet's coffee| posthacking | jeff | ------------------------------------------- | | | cim | ------------------------------------------- | | | linda | ------------------------------------------- Go * Query sent to backend is "retrieve (user_relns = user_relns()) " --------------- | user_relns | --------------- | hobbies_r | --------------- | equipment_r | --------------- | tenk1 | --------------- | person | --------------- | emp | --------------- | student | --------------- | stud_emp | --------------- | city | --------------- | dept | --------------- | slow_emp4000| --------------- | real_city | --------------- | aggtest | --------------- | arrtest | --------------- | Bprime | --------------- | ramp | --------------- | iportaltest | --------------- | onek | --------------- | tenk2 | --------------- | xacttest | --------------- | onek2 | --------------- | fast_emp4000| --------------- | road | --------------- | ihighway | --------------- | shighway | --------------- | hasham_heap | --------------- | street | --------------- | iexit | --------------- | toyemp | --------------- Go * Query sent to backend is "retrieve (equip_name = name(equipment(hobby_construct("skywalking"::text, "mer"::text)))) " --------------- | equip_name | --------------- | guts | --------------- Go * Query sent to backend is " retrieve (arrtest.all) " ----------------------------------------------------------------------- | a | b | c | d | e | ----------------------------------------------------------------------- | {1,2,3,4,5} | {{{0,0}},{{1,2}}}| {} | {} | [0:4]=/floatarr| ----------------------------------------------------------------------- | {11,12,23} | {{{3},{4}},{{4},{5}}}| {"foobar"} | {{"elt1","elt2"}}| {"3.4","6.7"}| ----------------------------------------------------------------------- | {} | {{{3,4},{0,0}}}| {"foo","bar"}| {{"bar"},{"foo"}}| | ----------------------------------------------------------------------- Go * Query sent to backend is "retrieve (arrtest.a[1], arrtest.b[1][1][1], arrtest.c[1], arrtest.d[1][1], arrtest.e[0]) " ----------------------------------------------------------------------- | a | b | c | d | e | ----------------------------------------------------------------------- | 1 | 0 | | | 1.1 | ----------------------------------------------------------------------- | 11 | 3 | foobar | elt1 | | ----------------------------------------------------------------------- | | 3 | foo | bar | | ----------------------------------------------------------------------- Go * Query sent to backend is "retrieve (arrtest.a[1:3], arrtest.b[1:1][1:2][1:2], arrtest.c[1:2], arrtest.d[1:1][1:2]) " --------------------------------------------------------- | a | b | c | d | --------------------------------------------------------- | {1,2,3} | | | | --------------------------------------------------------- | {11,12,23} | | | {{"elt1","elt2"}}| --------------------------------------------------------- | | {{{3,4},{0,0}}}| {"foo","bar"}| | --------------------------------------------------------- Go * Query sent to backend is " retrieve (x = array_dims(arrtest.b)) " --------------- | x | --------------- | [1:2][1:1][1:2]| --------------- | [1:2][1:2][1:1]| --------------- | [1:1][1:2][1:2]| --------------- Go * Query sent to backend is " retrieve (arrtest.all) where arrtest.a[1] < 5 and arrtest.c = "{"foobar"}"::_char16 " ----------------------------------------------------------------------- | a | b | c | d | e | ----------------------------------------------------------------------- Go * Query sent to backend is "replace arrtest (a[1:2] = "{16,25}", b[1:1][1:1][1:2] = "{113, 117}", c[1:1] = "{"new_word"}") " REPLACE Go * Query sent to backend is "retrieve (arrtest.a[1:3], arrtest.b[1:1][1:2][1:2], arrtest.c[1:2], arrtest.d[1:1][1:2]) " --------------------------------------------------------- | a | b | c | d | --------------------------------------------------------- | {16,25,3} | | | | --------------------------------------------------------- | {16,25,23} | | | {{"elt1","elt2"}}| --------------------------------------------------------- | | {{{113,117},{0,0}}}| {"new_word","bar"}| | --------------------------------------------------------- Go * Query sent to backend is " retrieve (forty_two = ufp0()) " NOTICE:Oct 2 18:21:33:ufp_start: forked UFP[18746] --------------- | forty_two | --------------- | 42 | --------------- Go * Query sent to backend is " retrieve (sixteen = ufp1(15)) " --------------- | sixteen | --------------- | 16 | --------------- Go * Query sent to backend is " retrieve (postgres = ufp2("post"::char16,"gres"::char16)) " --------------- | postgres | --------------- | postgres | --------------- Go * Query sent to backend is " retrieve (postgres = ufp3("postgres rules ok"::text, " "::char)) " --------------- | postgres | --------------- | postgres | --------------- Go * Query sent to backend is " replace pg_class (relacl="{}") where pg_class.relname !~ "pg_*"::char16 " REPLACE Go * Query sent to backend is "replace pg_user (usesuper="f"::bool) where pg_user.usename = "aoki" " REPLACE Go * Query sent to backend is "create myclass0 (a=int4) " CREATE Go * Query sent to backend is " append myclass0 (a=5) " APPEND 177714 Go * Query sent to backend is "retrieve (myclass0.a) " --------------- | a | --------------- | 5 | --------------- Go * Query sent to backend is "replace myclass0 (a=6) " REPLACE Go * Query sent to backend is "append myclass0 (a=10) " APPEND 177715 Go * Query sent to backend is "append myclass0 (a=20) " APPEND 177716 Go * Query sent to backend is "replace myclass0 (a=10) where myclass0.a < 10 " REPLACE Go * Query sent to backend is "replace myclass0 (a=myclass0.a+1) " REPLACE Go * Query sent to backend is "delete myclass0 where myclass0.a > 15 " DELETE Go * Query sent to backend is "define rule foo is on retrieve to myclass0 do instead nothing " DEFINE Go * Query sent to backend is "remove rule foo " REMOVE Go * Query sent to backend is "change acl aoki-arR myclass0 " CHANGE Go * Query sent to backend is " replace myclass0 (a=1) " REPLACE Go * Query sent to backend is " append myclass0 (a=100) " APPEND 177725 Go * tuple 0: got i=(4 bytes) 1, d=(4 bytes) 3.567000, p=(68 bytes) 2 points, boundbox=(hi=3.000000,4.000000 / lo=1.000000,2.000000) tuple 1: got i=(4 bytes) 2, d=(4 bytes) 89.050003, p=(68 bytes) 2 points, boundbox=(hi=4.000000,3.000000 / lo=2.000000,1.000000) #!/bin/sh # # $Header: /home2/aoki/master/src/regress/regress/RCS/fstest.source,v 1.4 1993/08/13 19:58:13 aoki Exp $ # [ -z "$DATABASE" ] && DATABASE=regression export DATABASE [ -z "$PGHOST" ] && PGHOST=localhost export PGHOST # SMGR=d HERE=/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress THERE=/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/obj # # # initial cleanup # prm -rf / \ || exit 1 pls -dl / \ || exit 1 drwx------ 1 aoki system 0 Dec 31 1969 / # # - simple icopy "in" # icopy in -d $DATABASE -s $SMGR -v $HERE/../data/dept.data /dept.data1 \ || exit 1 /a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/../data/dept.data -> /dept.data1 # # - recursive icopy "in" # icopy in -d $DATABASE -s $SMGR -R $HERE/../data /data1 \ || exit 1 # # - recursive icopy "in" with dotfiles # rm -f $THERE/.dept.data cp $HERE/../data/dept.data $THERE/.dept.data \ || exit 1 icopy in -d $DATABASE -s $SMGR -R -a $THERE /data2 \ || exit 1 icopy in -d $DATABASE -s $SMGR -v $HERE/../data/dept.data /data2/dept.data \ || exit 1 /a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/regress/../data/dept.data -> /data2/dept.data # # - absolute pls # pls -aR / \ || exit 1 data1 data2 dept.data1 /data1: dept.data emp.data hash.data onek.data person.data real_city.data rect.data streets.data stud_emp.data student.data tenk.data # # - absolute pmkdir # pmkdir /data2/absolute_dir \ || exit 1 # # - absolute prmdir # prmdir /data2/absolute_dir \ || exit 1 # # - absolute pcat # pcat /data2/dept.data \ || exit 1 toy sharon shoe bob # # - pcd/ppwd # PFCWD=`pcd /data2 | sed -e 's/setenv PFCWD //'`; export PFCWD ppwd \ || exit 1 /data2 # # - relative pls # pls \ || exit 1 create.pq dept.data destroy.pq errors.pq fstest.sh iportal iportal.o onek.data queries.pq regress.exp regress.o regress.out regress.so stud_emp.data ufp1.exp ufp1.o ufp1.so ufp2.exp ufp2.o ufp2.so ufp3.exp ufp3.o ufp3.so # # - relative pmkdir # pmkdir relative_dir \ || exit 1 # # - relative prmdir # prmdir relative_dir \ || exit 1 # # - relative pcat # pcat dept.data \ || exit 1 toy sharon shoe bob # # - relative prm # prm dept.data \ || exit 1 pls \ || exit 1 create.pq destroy.pq errors.pq fstest.sh iportal iportal.o onek.data queries.pq regress.exp regress.o regress.out regress.so stud_emp.data ufp1.exp ufp1.o ufp1.so ufp2.exp ufp2.o ufp2.so ufp3.exp ufp3.o ufp3.so # # - more complex pcat # echo "foo" | pcat -H $PGHOST -D $DATABASE .dept.data - /data2/.dept.data toy sharon shoe bob foo toy sharon shoe bob # # final cleanup # prm -rf / \ || exit 1 rm -f $THERE/.dept.data exit 0 =============== running error queries ... ================= Welcome to the POSTGRES terminal monitor Go * Query sent to backend is " retrieve (1) " WARN:Oct 2 18:22:46:parser: syntax error at or near "1" Go * Query sent to backend is " attachas nonesuch " WARN:Oct 2 18:22:46:parser: syntax error at or near "nonesuch" Go * Query sent to backend is " notify pg_class " WARN:Oct 2 18:22:46:notify is turned off for 4.0.1 - see the release notes Go * Query sent to backend is " retrieve " WARN:Oct 2 18:22:46:parser: syntax error at or near "" Go * Query sent to backend is " retrieve (nonesuch.all) " WARN:Oct 2 18:22:46:nonesuch: no such class Go * Query sent to backend is " delete " WARN:Oct 2 18:22:46:parser: syntax error at or near "" Go * Query sent to backend is " delete nonesuch " WARN:Oct 2 18:22:46:nonesuch: no such class Go * Query sent to backend is " destroy " WARN:Oct 2 18:22:46:parser: syntax error at or near "" Go * Query sent to backend is " destroy nonesuch " WARN:Oct 2 18:22:46:pg_ownercheck: class "nonesuch" not found Go * Query sent to backend is " rename " WARN:Oct 2 18:22:46:parser: syntax error at or near "" Go * Query sent to backend is " rename nonesuch to newnonesuch " WARN:Oct 2 18:22:46:pg_ownercheck: class "nonesuch" not found Go * Query sent to backend is " rename nonesuch to stud_emp " WARN:Oct 2 18:22:46:pg_ownercheck: class "nonesuch" not found Go * Query sent to backend is " rename stud_emp to pg_stud_emp " WARN:Oct 2 18:22:46:renamerel: Illegal class name: "pg_stud_emp" -- pg_ is reserved for system catalogs Go * Query sent to backend is " rename stud_emp to aggtest " WARN:Oct 2 18:22:46:renamerel: relation "aggtest" exists Go * Query sent to backend is " rename stud_emp to stud_emp " WARN:Oct 2 18:22:46:renamerel: relation "stud_emp" exists Go * Query sent to backend is " rename nonesuchatt in nonesuchrel to newnonesuchatt " WARN:Oct 2 18:22:46:pg_ownercheck: class "nonesuchrel" not found Go * Query sent to backend is " rename nonesuchatt in emp to newnonesuchatt " WARN:Oct 2 18:22:46:renameatt: attribute "nonesuchatt" nonexistent Go * Query sent to backend is " rename salary in emp to manager " WARN:Oct 2 18:22:46:renameatt: attribute "manager" exists Go * Query sent to backend is " rename salary in emp to oid " WARN:Oct 2 18:22:46:renameatt: attribute "oid" exists Go * Query sent to backend is " abort " NOTICE:Oct 2 18:22:46:UserAbortTransactionBlock and not inprogress state ABORT Go * Query sent to backend is " end " NOTICE:Oct 2 18:22:46:EndTransactionBlock and not inprogress/abort state END Go * Query sent to backend is " define aggregate newavg1 (sfunc1 = int4pl, basetype = int4, stype1 = int4, sfunc2 = int4inc, stype2 = int4, initcond1 = "0", initcond2 = "0") " WARN:Oct 2 18:22:47:AggregateDefine: Aggregate must have final function with both transition functions Go * Query sent to backend is " define aggregate newavg2 (sfunc1 = int4pl, basetype = int4, stype1 = int4, sfunc2 = int2inc, stype2 = int2, finalfunc = int4div, initcond1 = "0", initcond2 = "0") " WARN:Oct 2 18:22:47:AggregateDefine: "int4div"("int4", "int2") does not exist Go * Query sent to backend is " define aggregate newavg3 (sfunc1 = int4pl, basetype = int4, stype1 = int4, sfunc2 = int4inc, stype2 = int4, finalfunc = int2div, initcond1 = "0", initcond2 = "0") " WARN:Oct 2 18:22:47:AggregateDefine: "int2div"("int4", "int4") does not exist Go * Query sent to backend is " define aggregate newcnt1 (sfunc2 = int4inc, stype2 = int4) " WARN:Oct 2 18:22:47:AggregateDefine: transition function 2 MUST have an initial value Go * Query sent to backend is " remove index " WARN:Oct 2 18:22:47:parser: syntax error at or near "" Go * Query sent to backend is " remove index 314159 " WARN:Oct 2 18:22:47:parser: syntax error at or near "314159" Go * Query sent to backend is " remove index nonesuch " WARN:Oct 2 18:22:47:pg_ownercheck: class "nonesuch" not found Go * Query sent to backend is " remove aggregate " WARN:Oct 2 18:22:47:parser: syntax error at or near "" Go * Query sent to backend is " remove aggregate 314159 " WARN:Oct 2 18:22:47:parser: syntax error at or near "314159" Go * Query sent to backend is " remove aggregate nonesuch " WARN:Oct 2 18:22:47:RemoveAggregate: aggregate "nonesuch" does not exist Go * Query sent to backend is " remove function () " WARN:Oct 2 18:22:47:parser: syntax error at or near "(" Go * Query sent to backend is " remove function 314159() " WARN:Oct 2 18:22:47:parser: syntax error at or near "314159" Go * Query sent to backend is " remove function nonesuch() " WARN:Oct 2 18:22:47:RemoveFunction: function nonesuch() does not exist Go * Query sent to backend is " remove type " WARN:Oct 2 18:22:47:parser: syntax error at or near "" Go * Query sent to backend is " remove type 314159 " WARN:Oct 2 18:22:47:parser: syntax error at or near "314159" Go * Query sent to backend is " remove type nonesuch " WARN:Oct 2 18:22:47:pg_ownercheck: type "nonesuch" not found Go * Query sent to backend is " remove operator " WARN:Oct 2 18:22:47:parser: syntax error at or near "" Go * Query sent to backend is " remove operator equals " WARN:Oct 2 18:22:47:parser: syntax error at or near "equals" Go * Query sent to backend is " remove operator === " WARN:Oct 2 18:22:47:parser: syntax error at or near "" Go * Query sent to backend is " remove operator int4, int4 " WARN:Oct 2 18:22:47:parser: syntax error at or near "int4" Go * Query sent to backend is " remove operator (int4, int4) " WARN:Oct 2 18:22:47:RemoveOperator: operator "===" taking "int4" and "int4" does not exist Go * Query sent to backend is " remove operator === () " WARN:Oct 2 18:22:47:parser: syntax error at or near ")" Go * Query sent to backend is " remove operator === (int4) " WARN:Oct 2 18:22:47:RemoveOperator: operator "===" taking "int4" does not exist Go * Query sent to backend is " remove operator === (int4, int4) " WARN:Oct 2 18:22:47:RemoveOperator: operator "===" taking "int4" and "int4" does not exist Go * Query sent to backend is " remove operator = (nonesuch) " WARN:Oct 2 18:22:47:RemoveOperator: type "nonesuch" does not exist Go * Query sent to backend is " remove operator = ( , int4) " WARN:Oct 2 18:22:47:parser: syntax error at or near "," Go * Query sent to backend is " remove operator = (nonesuch, int4) " WARN:Oct 2 18:22:47:RemoveOperator: type "nonesuch" does not exist Go * Query sent to backend is " remove operator = (int4, nonesuch) " WARN:Oct 2 18:22:47:RemoveOperator: type "nonesuch" does not exist Go * Query sent to backend is " remove operator = (int4, ) " WARN:Oct 2 18:22:47:parser: syntax error at or near ")" Go * Query sent to backend is " remove rule " WARN:Oct 2 18:22:47:parser: syntax error at or near "" Go * Query sent to backend is " remove rule 314159 " WARN:Oct 2 18:22:47:parser: syntax error at or near "314159" Go * Query sent to backend is " remove rule nonesuch " WARN:Oct 2 18:22:47:prs2GetRuleEventRel: rule "nonesuch" not found Go * Query sent to backend is " remove tuple rule nonesuch " WARN:Oct 2 18:22:47:parser: syntax error at or near "tuple" Go * Query sent to backend is " remove instance rule nonesuch " WARN:Oct 2 18:22:47:prs2GetRuleEventRel: rule "nonesuch" not found Go * Query sent to backend is " remove rewrite rule nonesuch " WARN:Oct 2 18:22:48:RewriteGetRuleEventRel: rule "nonesuch" not found Go * Query sent to backend is " retrieve (myclass0.a) " WARN:Oct 2 18:22:48:read on "myclass0": permission denied Go * Query sent to backend is " replace myclass0 (a = 10) where myclass0.a < 15 " WARN:Oct 2 18:22:48:read on "myclass0": permission denied Go * Query sent to backend is " replace myclass0 (a = myclass0.a + 1) " WARN:Oct 2 18:22:48:read on "myclass0": permission denied Go * Query sent to backend is " delete myclass0 where myclass0.a >= 100 " WARN:Oct 2 18:22:48:read on "myclass0": permission denied Go * Query sent to backend is " define rule foo is on retrieve to myclass0 do instead nothing " WARN:Oct 2 18:22:48:define rule on "myclass0": permission denied Go * Welcome to the POSTGRES terminal monitor Go * Query sent to backend is " remove function hobbies(person) " REMOVE Go * Query sent to backend is "remove function hobby_construct(text,text) " REMOVE Go * Query sent to backend is "remove function equipment(hobbies_r) " REMOVE Go * Query sent to backend is "remove function user_relns() " REMOVE Go * Query sent to backend is "remove function circle_in(any) " REMOVE Go * Query sent to backend is "remove function circle_out(any) " REMOVE Go * Query sent to backend is "remove function pt_in_circle(point,circle) " REMOVE Go * Query sent to backend is "remove function overpaid(emp) " REMOVE Go * Query sent to backend is "remove function boxarea(box) " REMOVE Go * Query sent to backend is "remove function interpt_pp(path,path) " REMOVE Go * Query sent to backend is "remove function reverse_c16(char16) " REMOVE Go * Query sent to backend is "remove function ufp0() " REMOVE Go * Query sent to backend is "remove function ufp1(int4) " REMOVE Go * Query sent to backend is "remove function ufp2(char16,char16) " REMOVE Go * Query sent to backend is "remove function ufp3(text,char) " REMOVE Go * Query sent to backend is " remove operator ## (path, path) " REMOVE Go * Query sent to backend is "remove operator <% (point, circle) " REMOVE Go * Query sent to backend is " remove type city_budget " REMOVE Go * Query sent to backend is "remove type circle " REMOVE Go * Query sent to backend is " remove aggregate newavg " REMOVE Go * Query sent to backend is "remove aggregate newsum " REMOVE Go * Query sent to backend is "remove aggregate newcnt " REMOVE Go * Query sent to backend is " remove index onek_unique1 " REMOVE Go * Query sent to backend is "remove index onek_unique2 " REMOVE Go * Query sent to backend is "remove index onek_hundred " REMOVE Go * Query sent to backend is "remove index onek_stringu1 " REMOVE Go * Query sent to backend is "remove index tenk1_unique1 " REMOVE Go * Query sent to backend is "remove index tenk1_unique2 " REMOVE Go * Query sent to backend is "remove index tenk1_hundred " REMOVE Go * Query sent to backend is "remove index tenk2_unique1 " REMOVE Go * Query sent to backend is "remove index tenk2_unique2 " REMOVE Go * Query sent to backend is "remove index tenk2_hundred " REMOVE Go * Query sent to backend is "remove index rect2ind " REMOVE Go * Query sent to backend is "remove index rix " REMOVE Go * Query sent to backend is "remove index iix " REMOVE Go * Query sent to backend is "remove index six " REMOVE Go * Query sent to backend is "remove index hasham_index " REMOVE Go * Query sent to backend is "destroy onek " DESTROY Go * Query sent to backend is "destroy tenk1 " DESTROY Go * Query sent to backend is "destroy tenk2 " DESTROY Go * Query sent to backend is "destroy hobbies_r " DESTROY Go * Query sent to backend is "destroy equipment_r " DESTROY Go * Query sent to backend is "destroy aggtest " DESTROY Go * Query sent to backend is "destroy arrtest " DESTROY Go * Query sent to backend is "destroy iportaltest " DESTROY Go * Query sent to backend is "destroy stud_emp " DESTROY Go * Query sent to backend is "destroy student " DESTROY Go * Query sent to backend is "destroy slow_emp4000 " DESTROY Go * Query sent to backend is "destroy fast_emp4000 " DESTROY Go * Query sent to backend is "destroy emp " DESTROY Go * Query sent to backend is "destroy person " DESTROY Go * Query sent to backend is "destroy ramp " DESTROY Go * Query sent to backend is "destroy real_city " DESTROY Go * Query sent to backend is "destroy dept " DESTROY Go * Query sent to backend is "destroy ihighway " DESTROY Go * Query sent to backend is "destroy shighway " DESTROY Go * Query sent to backend is "destroy road " DESTROY Go * Query sent to backend is "destroy city " DESTROY Go * Query sent to backend is "destroy hasham_heap " DESTROY Go * Query sent to backend is " remove view street " REMOVE Go * Query sent to backend is "remove view iexit " REMOVE Go * Query sent to backend is "remove view toyemp " REMOVE Go * =============== destroying regression database... ================= RESULTS OF REGRESSION ARE SAVED IN obj/regress.out running video... PATH=/u/biouser2/aoki/postgres/bin:$PATH sh /a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/video/wholevideo.sh 2>&1 | tee video.out =============== destroying old video database... ================= WARN:Oct 2 18:23:08:destroydb: database video does not exist. destroydb: database destroy failed on video. =============== creating new video database... ================= =============== running video queries... ================= Welcome to the POSTGRES terminal monitor Go * Query sent to backend is "define type city_budget ( internallength = 16, input = int44in, output = int44out, element = int4) " DEFINE Go * Query sent to backend is "create person (name = char16, age = int4, location = point) " CREATE Go * Query sent to backend is "create emp (salary = int4, dept = char16) inherits (person) " CREATE Go * Query sent to backend is "create student (gpa = float8) inherits (person) " CREATE Go * Query sent to backend is "create stud_emp (percent = int4) inherits (emp, student) " CREATE Go * Query sent to backend is "create dept (dname = char16, mgrname = char16) " CREATE Go * Query sent to backend is "create city (name = char16, location = box, budget = city_budget) " CREATE Go * Query sent to backend is "define function boxarea ( language = "c", returntype = int4) arg is (box) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/video/obj/boxarea.so" " DEFINE Go * Query sent to backend is "define function overpaid ( language = "c", returntype = bool) arg is (emp) as "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/video/obj/overpaid.so" " DEFINE Go * Query sent to backend is "load "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/video/obj/overpaid.so" " LOAD Go * Query sent to backend is "load "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/video/obj/boxarea.so" " LOAD Go * Query sent to backend is "append person (name = "mike", age = 40, location = "(3.1,6.2)"::point) " APPEND 181821 Go * Query sent to backend is "append person (name = "joe", age = 20, location = "(5.5,2.5)"::point) " APPEND 181822 Go * Query sent to backend is "append person (name = "greg", age = 50, location = "(5.0,2.0)"::point) " APPEND 181823 Go * Query sent to backend is "append person (name = "bob", age = 18, location = "(0.0,0.0)"::point) " APPEND 181824 Go * Query sent to backend is "append dept (dname = "toy", mgrname = "sharon") " APPEND 181825 Go * Query sent to backend is "append dept (dname = "shoe", mgrname = "bob") " APPEND 181826 Go * Query sent to backend is "append emp (name = "bill", age = 20, location = "(11.0,10.0)"::point, salary = 1000, dept = "toy") " APPEND 181827 Go * Query sent to backend is "append emp (name = "sharon", age = 25, location = "(15.0,12.0)"::point, salary = 500, dept = "shoe") " APPEND 181828 Go * Query sent to backend is "append emp (name = "sam", age = 30, location = "(10.0,5.0)"::point, salary = 300, dept = "toy") " APPEND 181829 Go * Query sent to backend is "append student (name = "fred", age = 28, location = "(3.1,-1.5)"::point, gpa = 3.7) " APPEND 181830 Go * Query sent to backend is "append student (name = "larry", age = 60, location = "(21.8,4.9)"::point, gpa = 3.1) " APPEND 181831 Go * Query sent to backend is "append stud_emp (name = "jeff", age = 23, location = "(8.0,7.7)"::point, salary = 600, dept = "candy", gpa = 3.5) " APPEND 181832 Go * Query sent to backend is "append stud_emp (name = "cim", age = 30, location = "(10.5,4.7)"::point, salary = 400, dept = "shoe", gpa = 3.4) " APPEND 181833 Go * Query sent to backend is "append stud_emp (name = "linda", age = 19, location = "(0.9,6.1)"::point, salary = 100, dept = "candy", gpa = 2.9) " APPEND 181834 Go * Query sent to backend is "append city (name = "berkeley", location = "(0.0,0.0,10.0,10.0)"::box, budget = "250, 300, 325, 275"::city_budget) " APPEND 181835 Go * Query sent to backend is "append city (name = "oakland", location = "(-10.0,-10.0,0.0,5.0)"::box, budget = "600, 400, 350, 500"::city_budget) " APPEND 181836 Go * Query sent to backend is "append city (name = "elcerrito", location = "(10.0,0.0, 20.0,10.0)"::box, budget = "100, 100, 100, 100"::city_budget) " APPEND 181837 Go * Query sent to backend is "append city (name = "richmond", location = "(20.0,5.0, 35.0,15.0)"::box, budget = "300, 320, 340, 360"::city_budget) " APPEND 181838 Go * Query sent to backend is "append city (name = "sanpablo", location = "(35.0,20.0,40.0,30.0)"::box, budget = "50, 60, 65, 70"::city_budget) " APPEND 181839 Go * Query sent to backend is "create slow_emp4000 (location = box) " CREATE Go * Query sent to backend is "create fast_emp4000 (location = box) " CREATE Go * Query sent to backend is "copy slow_emp4000 from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/video/../data/rect.data" " COPY Go * Query sent to backend is "copy fast_emp4000 from "/a/horton.s2k.ucsb.edu/u6/home/aoki/src/regress/video/../data/rect.data" " COPY Go * Query sent to backend is "define index rect2ind on fast_emp4000 using rtree (location bigbox_ops) " DEFINE Go * Query sent to backend is "retrieve (emp.all) " ----------------------------------------------------------------------- | location | age | name | salary | dept | ----------------------------------------------------------------------- | (11,10) | 20 | bill | 1000 | toy | ----------------------------------------------------------------------- | (15,12) | 25 | sharon | 500 | shoe | ----------------------------------------------------------------------- | (10,5) | 30 | sam | 300 | toy | ----------------------------------------------------------------------- Go * Query sent to backend is "retrieve (dept.all) " ----------------------------- | dname | mgrname | ----------------------------- | toy | sharon | ----------------------------- | shoe | bob | ----------------------------- Go * Query sent to backend is " retrieve (e.name) from e in emp, m in emp, d in dept where e.dept = d.dname and d.mgrname = m.name and e.salary > m.salary " --------------- | name | --------------- | bill | --------------- Go * Query sent to backend is "retrieve (city.all) " ------------------------------------------- | name | location | budget | ------------------------------------------- | berkeley | (10,10,0,0) | 250 300 325 275| ------------------------------------------- | oakland | (0,5,-10,-10)| 600 400 350 500| ------------------------------------------- | elcerrito | (20,10,10,0)| 100 100 100 100| ------------------------------------------- | richmond | (35,15,20,5)| 300 320 340 360| ------------------------------------------- | sanpablo | (40,30,35,20)| 50 60 65 70 | ------------------------------------------- Go * Query sent to backend is " retrieve (city.name) where boxarea(city.location) > 100 " --------------- | name | --------------- | oakland | --------------- | richmond | --------------- Go * Query sent to backend is " retrieve (emp.name) where overpaid(emp) " --------------- | name | --------------- | bill | --------------- Go * Query sent to backend is " retrieve (stud_emp.all) where overpaid (stud_emp) " --------------------------------------------------------------------------------------------------- | gpa | dept | salary | name | age | location | percent | --------------------------------------------------------------------------------------------------- Go * Query sent to backend is " retrieve (c1.name, c2.name) from c1 in city, c2 in city where c1.location && c2.location " ----------------------------- | name | name | ----------------------------- | berkeley | berkeley | ----------------------------- | oakland | berkeley | ----------------------------- | elcerrito | berkeley | ----------------------------- | berkeley | oakland | ----------------------------- | oakland | oakland | ----------------------------- | berkeley | elcerrito | ----------------------------- | elcerrito | elcerrito | ----------------------------- | richmond | elcerrito | ----------------------------- | elcerrito | richmond | ----------------------------- | richmond | richmond | ----------------------------- | sanpablo | sanpablo | ----------------------------- Go * Query sent to backend is " retrieve (fast_emp4000.all) where fast_emp4000.location && "(24000,24000,26000,26000)" " --------------- | location | --------------- | (24497,24752,24411,24710)| --------------- | (24738,25458,24656,25362)| --------------- | (24704,25422,24635,25340)| --------------- | (25051,25042,25011,25001)| --------------- | (25044,25088,25015,25005)| --------------- | (25007,25061,25002,25013)| --------------- | (25066,25105,25003,25007)| --------------- | (25028,25012,25015,25011)| --------------- | (25031,25057,25006,25018)| --------------- | (25015,25042,25004,25012)| --------------- | (25091,25049,25019,25019)| --------------- | (25023,25011,25000,25004)| --------------- | (25053,25104,25010,25012)| --------------- | (25058,25001,25018,25000)| --------------- | (25059,25051,25008,25016)| --------------- | (25043,25069,25007,25004)| --------------- | (25006,25101,25002,25002)| --------------- | (25095,25012,25014,25007)| --------------- | (25054,25052,25019,25013)| --------------- | (25108,25077,25009,25018)| --------------- | (25007,25023,25003,25002)| --------------- | (25076,25098,25002,25016)| --------------- | (25030,25077,25012,25006)| --------------- | (25345,24019,25313,24017)| --------------- Go * Query sent to backend is " retrieve (slow_emp4000.all) where slow_emp4000.location && "(24000,24000,26000,26000)" " --------------- | location | --------------- | (24497,24752,24411,24710)| --------------- | (24738,25458,24656,25362)| --------------- | (24704,25422,24635,25340)| --------------- | (25345,24019,25313,24017)| --------------- | (25051,25042,25011,25001)| --------------- | (25044,25088,25015,25005)| --------------- | (25007,25061,25002,25013)| --------------- | (25066,25105,25003,25007)| --------------- | (25028,25012,25015,25011)| --------------- | (25031,25057,25006,25018)| --------------- | (25015,25042,25004,25012)| --------------- | (25091,25049,25019,25019)| --------------- | (25023,25011,25000,25004)| --------------- | (25053,25104,25010,25012)| --------------- | (25058,25001,25018,25000)| --------------- | (25059,25051,25008,25016)| --------------- | (25043,25069,25007,25004)| --------------- | (25006,25101,25002,25002)| --------------- | (25095,25012,25014,25007)| --------------- | (25054,25052,25019,25013)| --------------- | (25108,25077,25009,25018)| --------------- | (25007,25023,25003,25002)| --------------- | (25076,25098,25002,25016)| --------------- | (25030,25077,25012,25006)| --------------- Go * Query sent to backend is "define rule example_1 is on replace to emp.salary where current.name = "bill" do replace emp (salary = new.salary) where emp.name = "sam" " DEFINE Go * Query sent to backend is "retrieve (emp.salary) where emp.name = "sam" " --------------- | salary | --------------- | 300 | --------------- Go * Query sent to backend is "replace emp (salary = 6000) where emp.name = "bill" " REPLACE Go * Query sent to backend is "retrieve (emp.salary) where emp.name = "sam" " --------------- | salary | --------------- | 6000 | --------------- Go * Query sent to backend is "define view toyemp (emp.name, emp.age, emp.location, annualsal = 12*emp.salary) where emp.dept = "toy" " APPEND 188241DEFINE Go * Query sent to backend is "retrieve (toyemp.all) " --------------------------------------------------------- | name | age | location | annualsal | --------------------------------------------------------- | sam | 30 | (10,5) | 72000 | --------------------------------------------------------- | bill | 20 | (11,10) | 72000 | --------------------------------------------------------- Go * Query sent to backend is " create toyemp2(name = char16, age = int4, location = point, annualsal = int4) " CREATE Go * Query sent to backend is "define rewrite rule toyemp2_ret is on retrieve to toyemp2 do instead retrieve(emp.name, emp.age, emp.location, annualsal = 12*emp.salary) where emp.dept = "toy" " APPEND 188315DEFINE Go * Query sent to backend is "retrieve (toyemp2.all) " --------------------------------------------------------- | name | age | location | annualsal | --------------------------------------------------------- | sam | 30 | (10,5) | 72000 | --------------------------------------------------------- | bill | 20 | (11,10) | 72000 | --------------------------------------------------------- Go * Query sent to backend is " define rewrite rule toyemp_app is on append to toyemp do instead append emp(name = new.name, age = new.age, location = new.location, dept = "toy", salary = new.annualsal/12) " APPEND 188318DEFINE Go * Query sent to backend is "append toyemp(name="spyros", age=28, location="(6,27)", annualsal = 48000) " APPEND 188321 Go * Query sent to backend is "retrieve (toyemp.all) " --------------------------------------------------------- | name | age | location | annualsal | --------------------------------------------------------- | sam | 30 | (10,5) | 72000 | --------------------------------------------------------- | bill | 20 | (11,10) | 72000 | --------------------------------------------------------- | spyros | 28 | (6,27) | 48000 | --------------------------------------------------------- Go * Query sent to backend is "retrieve (emp.all) " ----------------------------------------------------------------------- | location | age | name | salary | dept | ----------------------------------------------------------------------- | (15,12) | 25 | sharon | 500 | shoe | ----------------------------------------------------------------------- | (10,5) | 30 | sam | 6000 | toy | ----------------------------------------------------------------------- | (11,10) | 20 | bill | 6000 | toy | ----------------------------------------------------------------------- | (6,27) | 28 | spyros | 4000 | toy | ----------------------------------------------------------------------- Go * Query sent to backend is "create version emp1 from emp " RETRIEVERETRIEVECREATEAPPEND 188529DEFINEAPPEND 188532DEFINEAPPEND 188535DEFINEAPPEND 188538DEFINEVERSION Go * Query sent to backend is " append emp1 (name = "jack", age = 40, salary = 20000, dept = "shoe") " APPEND 188541 Go * Query sent to backend is "append emp1 (name = "joe", age = 25, salary = 3000, dept = "shoe") " APPEND 188542 Go * Query sent to backend is " replace emp1 (salary = 5000) where emp1.name = "bill" " REPLACEAPPEND 188543APPEND 0 Go * Query sent to backend is " replace emp1 (salary = 2500) where emp1.name = "joe" and emp1.dept = "shoe" " REPLACEAPPEND 0APPEND 0 Go * Query sent to backend is " delete emp1 where emp1.dept = "toy" " DELETEAPPEND 0 Go * Query sent to backend is " retrieve (emp1.all) " ----------------------------------------------------------------------- | location | age | name | salary | dept | ----------------------------------------------------------------------- | (15,12) | 25 | sharon | 500 | shoe | ----------------------------------------------------------------------- | | 40 | jack | 20000 | shoe | ----------------------------------------------------------------------- | | 25 | joe | 2500 | shoe | ----------------------------------------------------------------------- Go * Query sent to backend is " retrieve (emp.all) " ----------------------------------------------------------------------- | location | age | name | salary | dept | ----------------------------------------------------------------------- | (15,12) | 25 | sharon | 500 | shoe | ----------------------------------------------------------------------- | (10,5) | 30 | sam | 6000 | toy | ----------------------------------------------------------------------- | (11,10) | 20 | bill | 6000 | toy | ----------------------------------------------------------------------- | (6,27) | 28 | spyros | 4000 | toy | ----------------------------------------------------------------------- Go * Query sent to backend is " retrieve (emp1_added.all) " ----------------------------------------------------------------------- | location | age | name | salary | dept | ----------------------------------------------------------------------- | | 40 | jack | 20000 | shoe | ----------------------------------------------------------------------- | | 25 | joe | 2500 | shoe | ----------------------------------------------------------------------- Go * Query sent to backend is " retrieve (emp1_del.all) " --------------- | DOID | --------------- | 181827 | --------------- | 181829 | --------------- | 188321 | --------------- Go * Query sent to backend is " create emp2(salary = int4, dept = char16, location = point, age = int4, name = char16) " CREATE Go * Go * Query sent to backend is "create emp2_added(salary = int4, dept = char16, location = point, age = int4, name = char16) " CREATE Go * Go * Query sent to backend is "create emp2_del(DOID = oid) " CREATE Go * Go * Query sent to backend is "define rewrite rule emp2_retrieve is on retrieve to emp2 do instead retrieve(emp2_1.oid, emp2_1.all) from _emp in emp, emp2_1 in (emp2_added | _emp) where _emp.oid !!= "emp2_del.DOID" " APPEND 188753DEFINE Go * Go * Query sent to backend is "define rewrite rule emp2_append is on append to emp2 do instead append emp2_added(salary = new.salary, dept = new.dept, location = new.location, age = new.age, name = new.name) " APPEND 188756DEFINE Go * Go * Query sent to backend is "define rewrite rule emp2_delete1 is on delete to emp2 do delete emp2_added where current.oid = emp2_added.oid " APPEND 188759DEFINE Go * Go * Query sent to backend is "define rewrite rule emp2_delete2 is on delete to emp2 do instead append emp2_del(DOID = current.oid) where current.oid = emp.oid " APPEND 188762DEFINE Go * Go * Query sent to backend is "define rewrite rule emp2_replace1 is on replace to emp2 do replace emp2_added(salary = new.salary, dept = new.dept, location = new.location, age = new.age, name = new.name) where current.oid = emp2_added.oid " APPEND 188765DEFINE Go * Go * Query sent to backend is "define rewrite rule emp2_replace2 is on replace to emp2 do append emp2_del(DOID = current.oid) where current.oid = emp.oid " APPEND 188768DEFINE Go * Go * Query sent to backend is "define rewrite rule emp2_replace3 is on replace to emp2 do instead append emp2_added(salary = new.salary, dept = new.dept, location = new.location, age = new.age, name = new.name) where current.oid !!= "emp2_added.oid" and current.oid = emp.oid " APPEND 188771DEFINE Go * Go * Query sent to backend is " define function manager (language = "postquel", returntype = emp) arg is (emp) as "retrieve (emp.all) where emp.name = dept.mgrname and dept.dname = $1.dept" " DEFINE Go * Query sent to backend is " retrieve (mgr_name = name(manager(emp))) " --------------- | mgr_name | --------------- | | --------------- | sharon | --------------- | sharon | --------------- | sharon | --------------- Go * Query sent to backend is " " Go * Query sent to backend is "retrieve (emp.manager.name) " --------------- | name | --------------- | | --------------- | sharon | --------------- | sharon | --------------- | sharon | --------------- Go * Query sent to backend is " " Go * Query sent to backend is " define function raise_sal (language = "postquel", returntype = bool) arg is (char16, int4) as "replace e (salary = e.salary + $2) from e in emp where e.name = $1 retrieve (x = \"t\"::bool)" " DEFINE Go * Query sent to backend is " " Go * Query sent to backend is " retrieve (x = raise_sal("sam"::char16, 100)) " --------------- | x | --------------- | t | --------------- Go * Query sent to backend is " " Go * Query sent to backend is " define function residents ( language = "postquel", returntype = setof person ) arg is (city) as "retrieve (p.all) from p in person* where p.location ---> $1.location" " DEFINE Go * Query sent to backend is " retrieve (city.residents.name) where city.name = "berkeley" " --------------- | name | --------------- | mike | --------------- | joe | --------------- | greg | --------------- | bob | --------------- | sam | --------------- | jeff | --------------- | linda | --------------- Go * =============== destroying video database... ================= RESULTS OF DEMO ARE SAVED IN obj/video.out To run the Wisconsin benchmark, you must kill the postmaster, cd into bench and make runtest.