The best I'm getting out of Slick for insert statements is:
insert into "topics"
("id","name","description","createdBy","createDate","state","changedBy","changeDate")
values (?,?,?,?,?,?,?,?)
five times.
>From the H2 logs I see
insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 1, 2: 'UncontroversialKidneys', 3: 'Study
kidneys without controversy', 4: 'ben', 5: 1434573100466, 6: 'Pending', 7:
'ben', 8: 1434573100466};
insert into \"userTopic\"
(\"researcher\",\"topicId\",\"state\",\"changedBy\",\"changeDate\") values
(?,?,?,?,?) {1: 'ben', 2: 1, 3: 'Approved', 4: 'ben', 5: 1434573100466};
insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 2, 2: 'slightlyControversial', 3: 'who
cares?', 4: 'ben', 5: 1434573100575, 6: 'Pending', 7: 'ben', 8:
1434573100575};
insert into \"userTopic\"
(\"researcher\",\"topicId\",\"state\",\"changedBy\",\"changeDate\") values
(?,?,?,?,?) {1: 'ben', 2: 2, 3: 'Approved', 4: 'ben', 5: 1434573100575};
insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 3, 2: 'controversial', 3: 'controversial', 4:
'ben', 5: 1434573100582, 6: 'Pending', 7: 'ben', 8: 1434573100582};
I've attached the H2 log for both 1.4.185 and 1.4.186 if that helps.
Nothing meaningful to me in them, but it does show exactly what Slick is
doing.
Did any of the changes between 1.4.185 and 1.4.186 touch sorting code or
that query-in-a-query?
Thanks again,
David
On Wednesday, June 17, 2015 at 1:46:41 AM UTC-4, Thomas Mueller wrote:
>
> Hi,
>
> You forgot to post data (insert statements). Without those, nobody can
> reproduce your problem. What we need is a complete script that we can run
> that that exhibits the problem. For example (this doesn't show the problem):
>
>
> drop table topics;
>
> create table topics (id INTEGER NOT NULL,name VARCHAR(254) NOT NULL,
> description TEXT NOT NULL,createdBy VARCHAR(254) NOT NULL,
> createDate BIGINT NOT NULL,state VARCHAR(254) NOT NULL,
> changedBy VARCHAR(254) NOT NULL,changeDate BIGINT NOT NULL);
>
> create index changeDateIndex on topics (changeDate);
> create index changedByIndex on topics (changedBy);
> create index createDateIndex on topics (createDate);
> create index createdByIndex on topics (createdBy);
> create index idIndex on topics (id);
> create index stateIndex on topics (state);
> create index topicNameIndex on topics (name);
>
> insert into topics values
> (1, 'f', 'x', 'ben', 100, 10, 'ben', 1),
> (2, 'e', 'x', 'joe', 300, 20, 'joe', 2),
> (3, 'd', 'x', 'tom', 300, 30, 'tom', 3),
> (4, 'c', 'x', 'ben', 400, 40, 'ben', 4),
> (5, 'b', 'x', 'joe', 500, 50, 'joe', 5),
> (6, 'a', 'x', 'tom', 600, 60, 'tom', 6);
>
> select x2.id, x2.name, x2.description, x2.createdBy, x2.createDate,
> x2.state,
> x2.changedBy, x2.changeDate
> from topics x2
> where (not exists(select * from topics x3
> where (x3.id = x2.id)
> and (x3.changeDate > x2.changeDate)))
> and (x2.createdBy = 'ben')
> order by x2.name;
>
>
>
> Regards,
> Thomas
>
>
>
> On Monday, June 15, 2015, David Walend <[email protected] <javascript:>>
> wrote:
>
>> It's hard to get to simple, but I can make it complete. Slick 3.0 is
>> generating this (surprisingly not too cryptic) SQL for me:
>>
>> select x2."id", x2."name", x2."description", x2."createdBy",
>> x2."createDate", x2."state", x2."changedBy", x2."changeDate" from "topics"
>> x2 where (not exists(select x3."createDate", x3."description", x3."state",
>> x3."changeDate", x3."changedBy", x3."id", x3."createdBy", x3."name" from
>> "topics" x3 where (x3."id" = x2."id") and (x3."changeDate" >
>> x2."changeDate"))) and (x2."createdBy" = 'ben') order by x2."name"
>>
>>
>> The internal "where (not exists(select x3 ...)) business is getting the
>> most recent entry for a topic record in the table.
>>
>>
>> The topics table ddl is:
>>
>>
>> create table `topics` (`id` INTEGER NOT NULL,`name` VARCHAR(254) NOT
>> NULL,`description` TEXT NOT NULL,`createdBy` VARCHAR(254) NOT
>> NULL,`createDate` BIGINT NOT NULL,`state` VARCHAR(254) NOT NULL,`changedBy`
>> VARCHAR(254) NOT NULL,`changeDate` BIGINT NOT NULL);
>>
>>
>> with lots of indexing (I hope this part doesn't matter):
>>
>>
>> create index `changeDateIndex` on `topics` (`changeDate`);
>>
>> create index `changedByIndex` on `topics` (`changedBy`);
>>
>> create index `createDateIndex` on `topics` (`createDate`);
>>
>> create index `createdByIndex` on `topics` (`createdBy`);
>>
>> create index `idIndex` on `topics` (`id`);
>>
>> create index `stateIndex` on `topics` (`state`);
>>
>> create index `topicNameIndex` on `topics` (`name`);
>>
>> Again, 1.4.185 is fine, but 1.4.186 ignores the final "order by" clause.
>>
>> Thanks for looking into it,
>>
>> David
>>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
06-17 16:40:20 jdbc[3]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[3]:
/**/Connection conn0 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[3]:
/*SQL t:4*/create table \"users\" (\"userName\" VARCHAR NOT NULL PRIMARY
KEY,\"fullName\" VARCHAR NOT NULL,\"isSteward\" BOOLEAN NOT NULL);
06-17 16:40:20 jdbc[3]:
/*SQL */create table \"topics\" (\"id\" INTEGER NOT NULL,\"name\" VARCHAR NOT
NULL,\"description\" VARCHAR NOT NULL,\"createdBy\" VARCHAR NOT
NULL,\"createDate\" BIGINT NOT NULL,\"state\" VARCHAR NOT NULL,\"changedBy\"
VARCHAR NOT NULL,\"changeDate\" BIGINT NOT NULL);
06-17 16:40:20 jdbc[3]:
/*SQL */create index \"changeDateIndex\" on \"topics\" (\"changeDate\");
06-17 16:40:20 jdbc[3]:
/*SQL */create index \"changedByIndex\" on \"topics\" (\"changedBy\");
06-17 16:40:20 jdbc[3]:
/*SQL */create index \"createDateIndex\" on \"topics\" (\"createDate\");
06-17 16:40:20 jdbc[3]:
/*SQL t:1*/create index \"createdByIndex\" on \"topics\" (\"createdBy\");
06-17 16:40:20 jdbc[3]:
/*SQL */create index \"idIndex\" on \"topics\" (\"id\");
06-17 16:40:20 jdbc[3]:
/*SQL t:1*/create index \"stateIndex\" on \"topics\" (\"state\");
06-17 16:40:20 jdbc[3]:
/*SQL */create index \"topicNameIndex\" on \"topics\" (\"name\");
06-17 16:40:20 jdbc[3]:
/*SQL t:6*/create table \"queries\" (\"stewardId\" BIGINT GENERATED BY DEFAULT
AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,\"id\" BIGINT NOT NULL,\"name\"
VARCHAR NOT NULL,\"researcher\" VARCHAR NOT NULL,\"topic\"
INTEGER,\"queryContents\" VARCHAR NOT NULL,\"stewardResponse\" VARCHAR NOT
NULL,\"date\" BIGINT NOT NULL);
06-17 16:40:20 jdbc[3]:
/*SQL t:1*/create index \"dateIndex\" on \"queries\" (\"date\");
06-17 16:40:20 jdbc[3]:
/*SQL */create index \"externalIdIndex\" on \"queries\" (\"id\");
06-17 16:40:20 jdbc[3]:
/*SQL t:1*/create index \"queryNameIndex\" on \"queries\" (\"name\");
06-17 16:40:20 jdbc[3]:
/*SQL */create index \"researcherIdIndex\" on \"queries\" (\"stewardId\");
06-17 16:40:20 jdbc[3]:
/*SQL t:1*/create index \"stewardResponseIndex\" on \"queries\"
(\"stewardResponse\");
06-17 16:40:20 jdbc[3]:
/*SQL */create index \"topicIdIndex\" on \"queries\" (\"topic\");
06-17 16:40:20 jdbc[3]:
/*SQL */create table \"userTopic\" (\"researcher\" VARCHAR NOT NULL,\"topicId\"
INTEGER NOT NULL,\"state\" VARCHAR NOT NULL,\"changedBy\" VARCHAR NOT
NULL,\"changeDate\" BIGINT NOT NULL);
06-17 16:40:20 jdbc[3]:
/*SQL */create unique index \"researcherTopicIdIndex\" on \"userTopic\"
(\"researcher\",\"topicId\");
06-17 16:40:20 database: disconnecting session #3
06-17 16:40:20 database: connecting session #4 to mem:test
06-17 16:40:20 jdbc[4]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[4]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[4]:
/**/Connection conn1 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[4]: exception
06-17 16:40:20 database: disconnecting session #4
06-17 16:40:20 database: connecting session #5 to mem:test
06-17 16:40:20 jdbc[5]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[5]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[5]:
/**/Connection conn2 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[5]:
/*SQL l:70 #:1 t:2*/merge into \"users\"
(\"userName\",\"fullName\",\"isSteward\") values (?,?,?) {1: 'ben', 2: 'ben',
3: FALSE};
06-17 16:40:20 database: disconnecting session #5
06-17 16:40:20 database: connecting session #6 to mem:test
06-17 16:40:20 jdbc[6]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[6]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[6]:
/**/Connection conn3 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[6]:
/*SQL l:70 #:1*/merge into \"users\" (\"userName\",\"fullName\",\"isSteward\")
values (?,?,?) {1: 'dave', 2: 'dave', 3: TRUE};
06-17 16:40:20 database: disconnecting session #6
06-17 16:40:20 database: connecting session #7 to mem:test
06-17 16:40:20 jdbc[7]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[7]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[7]:
/**/Connection conn4 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[7]:
/*SQL #:1 t:3*/select x2.x3 from (select max(x4.x5) as x3 from (select
x6.\"id\" as x5 from \"topics\" x6) x4) x2;
06-17 16:40:20 database: disconnecting session #7
List(insert into "topics"
("id","name","description","createdBy","createDate","state","changedBy","changeDate")
values (?,?,?,?,?,?,?,?))
06-17 16:40:20 database: connecting session #8 to mem:test
06-17 16:40:20 jdbc[8]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[8]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[8]:
/**/Connection conn5 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[8]:
/*SQL l:132 #:1*/insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 1, 2: 'UncontroversialKidneys', 3: 'Study
kidneys without controversy', 4: 'ben', 5: 1434573620148, 6: 'Pending', 7:
'ben', 8: 1434573620148};
06-17 16:40:20 database: disconnecting session #8
06-17 16:40:20 database: connecting session #9 to mem:test
06-17 16:40:20 jdbc[9]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[9]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[9]:
/**/Connection conn6 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[9]:
/*SQL l:101 #:1 t:1*/insert into \"userTopic\"
(\"researcher\",\"topicId\",\"state\",\"changedBy\",\"changeDate\") values
(?,?,?,?,?) {1: 'ben', 2: 1, 3: 'Approved', 4: 'ben', 5: 1434573620148};
06-17 16:40:20 database: disconnecting session #9
List(insert into "topics"
("id","name","description","createdBy","createDate","state","changedBy","changeDate")
values (?,?,?,?,?,?,?,?))
06-17 16:40:20 database: connecting session #10 to mem:test
06-17 16:40:20 jdbc[10]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[10]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[10]:
/**/Connection conn7 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[10]:
/*SQL l:132 #:1 t:1*/insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 2, 2: 'slightlyControversial', 3: 'who cares?',
4: 'ben', 5: 1434573620274, 6: 'Pending', 7: 'ben', 8: 1434573620274};
06-17 16:40:20 database: disconnecting session #10
06-17 16:40:20 database: connecting session #11 to mem:test
06-17 16:40:20 jdbc[11]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[11]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[11]:
/**/Connection conn8 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[11]:
/*SQL l:101 #:1*/insert into \"userTopic\"
(\"researcher\",\"topicId\",\"state\",\"changedBy\",\"changeDate\") values
(?,?,?,?,?) {1: 'ben', 2: 2, 3: 'Approved', 4: 'ben', 5: 1434573620274};
06-17 16:40:20 database: disconnecting session #11
List(insert into "topics"
("id","name","description","createdBy","createDate","state","changedBy","changeDate")
values (?,?,?,?,?,?,?,?))
06-17 16:40:20 database: connecting session #12 to mem:test
06-17 16:40:20 jdbc[12]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[12]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[12]:
/**/Connection conn9 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[12]:
/*SQL l:132 #:1 t:1*/insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 3, 2: 'controversial', 3: 'controversial', 4:
'ben', 5: 1434573620283, 6: 'Pending', 7: 'ben', 8: 1434573620283};
06-17 16:40:20 database: disconnecting session #12
06-17 16:40:20 database: connecting session #13 to mem:test
06-17 16:40:20 jdbc[13]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[13]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[13]:
/**/Connection conn10 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[13]:
/*SQL l:101 #:1*/insert into \"userTopic\"
(\"researcher\",\"topicId\",\"state\",\"changedBy\",\"changeDate\") values
(?,?,?,?,?) {1: 'ben', 2: 3, 3: 'Approved', 4: 'ben', 5: 1434573620283};
06-17 16:40:20 database: disconnecting session #13
List(insert into "topics"
("id","name","description","createdBy","createDate","state","changedBy","changeDate")
values (?,?,?,?,?,?,?,?))
06-17 16:40:20 database: connecting session #14 to mem:test
06-17 16:40:20 jdbc[14]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[14]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[14]:
/**/Connection conn11 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[14]:
/*SQL l:132 #:1 t:1*/insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 4, 2: 'moderatelyControversial', 3: 'more
controversial than that', 4: 'ben', 5: 1434573620290, 6: 'Pending', 7: 'ben',
8: 1434573620290};
06-17 16:40:20 database: disconnecting session #14
06-17 16:40:20 database: connecting session #15 to mem:test
06-17 16:40:20 jdbc[15]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[15]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[15]:
/**/Connection conn12 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[15]:
/*SQL l:101 #:1*/insert into \"userTopic\"
(\"researcher\",\"topicId\",\"state\",\"changedBy\",\"changeDate\") values
(?,?,?,?,?) {1: 'ben', 2: 4, 3: 'Approved', 4: 'ben', 5: 1434573620290};
06-17 16:40:20 database: disconnecting session #15
List(insert into "topics"
("id","name","description","createdBy","createDate","state","changedBy","changeDate")
values (?,?,?,?,?,?,?,?))
06-17 16:40:20 database: connecting session #16 to mem:test
06-17 16:40:20 jdbc[16]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[16]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[16]:
/**/Connection conn13 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[16]:
/*SQL l:132 #:1 t:1*/insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 5, 2: 'veryControversial', 3: 'Just say no', 4:
'ben', 5: 1434573620296, 6: 'Pending', 7: 'ben', 8: 1434573620296};
06-17 16:40:20 database: disconnecting session #16
06-17 16:40:20 database: connecting session #17 to mem:test
06-17 16:40:20 jdbc[17]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[17]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[17]:
/**/Connection conn14 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[17]:
/*SQL l:101 #:1*/insert into \"userTopic\"
(\"researcher\",\"topicId\",\"state\",\"changedBy\",\"changeDate\") values
(?,?,?,?,?) {1: 'ben', 2: 5, 3: 'Approved', 4: 'ben', 5: 1434573620296};
06-17 16:40:20 database: disconnecting session #17
06-17 16:40:20 database: connecting session #18 to mem:test
06-17 16:40:20 jdbc[18]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[18]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[18]:
/**/Connection conn15 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[18]:
/*SQL l:70 #:1*/merge into \"users\" (\"userName\",\"fullName\",\"isSteward\")
values (?,?,?) {1: 'ben', 2: 'ben', 3: FALSE};
06-17 16:40:20 database: disconnecting session #18
06-17 16:40:20 database: connecting session #19 to mem:test
06-17 16:40:20 jdbc[19]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[19]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[19]:
/**/Connection conn16 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[19]:
/*SQL #:1 t:1*/select x2.x3 from (select count(1) as x3 from (select
x4.\"createDate\" as x5, x4.\"description\" as x6, x4.\"state\" as x7,
x4.\"changeDate\" as x8, x4.\"changedBy\" as x9, x4.\"id\" as x10,
x4.\"createdBy\" as x11, x4.\"name\" as x12 from \"topics\" x4 where (not
exists(select x13.\"createDate\", x13.\"description\", x13.\"state\",
x13.\"changeDate\", x13.\"changedBy\", x13.\"id\", x13.\"createdBy\",
x13.\"name\" from \"topics\" x13 where (x13.\"id\" = x4.\"id\") and
(x13.\"changeDate\" > x4.\"changeDate\"))) and (x4.\"createdBy\" = 'ben')) x14)
x2;
06-17 16:40:20 database: disconnecting session #19
06-17 16:40:20 database: connecting session #20 to mem:test
06-17 16:40:20 jdbc[20]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[20]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[20]:
/**/Connection conn17 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[20]:
/*SQL #:5 t:1*/select x2.\"id\", x2.\"name\", x2.\"description\",
x2.\"createdBy\", x2.\"createDate\", x2.\"state\", x2.\"changedBy\",
x2.\"changeDate\" from \"topics\" x2 where (not exists(select
x3.\"createDate\", x3.\"description\", x3.\"state\", x3.\"changeDate\",
x3.\"changedBy\", x3.\"id\", x3.\"createdBy\", x3.\"name\" from \"topics\" x3
where (x3.\"id\" = x2.\"id\") and (x3.\"changeDate\" > x2.\"changeDate\"))) and
(x2.\"createdBy\" = 'ben') order by x2.\"name\";
06-17 16:40:20 database: disconnecting session #20
06-17 16:40:20 database: connecting session #21 to mem:test
06-17 16:40:20 jdbc[21]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[21]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[21]:
/**/Connection conn18 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[21]:
/*SQL #:1*/select x2.\"userName\", x2.\"fullName\", x2.\"isSteward\" from
\"users\" x2 where x2.\"userName\" in ('ben');
06-17 16:40:20 database: disconnecting session #21
[INFO] [06/17/2015 16:40:20.753] [ForkJoinPool-2-worker-7]
[ActorSystem(net-shrine-steward-StewardServiceTest)] route: Response for
Request :
HttpRequest(GET,http://example.com/researcher/topics?sortBy=name,List(Authorization:
Basic YmVuOmthcG93),Empty,HTTP/1.1)
Response: HttpResponse(200 OK,HttpEntity(application/json;
charset=UTF-8,{"userId":"ben","totalCount":5,"skipped":0,"topics":[{"id":1,"name":"UncontroversialKidneys","description":"Study
kidneys without
controversy","createdBy":{"userName":"ben","fullName":"ben","roles":["Researcher"]},"createDate":1434573620148,"state":"Pending","changedBy":{"userName":"ben","fullName":"ben","roles":["Researcher"]},"changeDate":1434573620148},{"id":3,"name":"controversial","description":"controversial","createdBy":{"userName":"ben","fullName":"ben","roles":["Researcher"]},"createDat...),List(),HTTP/1.1)
06-17 16:40:20 database: connecting session #22 to mem:test
06-17 16:40:20 jdbc[22]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:40:20 jdbc[22]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:40:20 jdbc[22]:
/**/Connection conn19 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:40:20 jdbc[22]:
/*SQL t:2*/drop table \"userTopic\";
06-17 16:40:20 jdbc[22]:
/*SQL t:1*/drop table \"queries\";
06-17 16:40:20 jdbc[22]:
/*SQL t:1*/drop table \"topics\";
06-17 16:40:20 jdbc[22]:
/*SQL */drop table \"users\";
06-17 16:40:20 database: disconnecting session #22
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.951 sec
06-17 16:40:20 database: closing mem:test
06-17 16:40:20 database: closed
06-17 16:31:40 jdbc[3]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[3]:
/**/Connection conn0 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[3]:
/*SQL t:3*/create table \"users\" (\"userName\" VARCHAR NOT NULL PRIMARY
KEY,\"fullName\" VARCHAR NOT NULL,\"isSteward\" BOOLEAN NOT NULL);
06-17 16:31:40 jdbc[3]:
/*SQL */create table \"topics\" (\"id\" INTEGER NOT NULL,\"name\" VARCHAR NOT
NULL,\"description\" VARCHAR NOT NULL,\"createdBy\" VARCHAR NOT
NULL,\"createDate\" BIGINT NOT NULL,\"state\" VARCHAR NOT NULL,\"changedBy\"
VARCHAR NOT NULL,\"changeDate\" BIGINT NOT NULL);
06-17 16:31:40 jdbc[3]:
/*SQL t:1*/create index \"changeDateIndex\" on \"topics\" (\"changeDate\");
06-17 16:31:40 jdbc[3]:
/*SQL */create index \"changedByIndex\" on \"topics\" (\"changedBy\");
06-17 16:31:40 jdbc[3]:
/*SQL */create index \"createDateIndex\" on \"topics\" (\"createDate\");
06-17 16:31:40 jdbc[3]:
/*SQL t:1*/create index \"createdByIndex\" on \"topics\" (\"createdBy\");
06-17 16:31:40 jdbc[3]:
/*SQL */create index \"idIndex\" on \"topics\" (\"id\");
06-17 16:31:40 jdbc[3]:
/*SQL t:1*/create index \"stateIndex\" on \"topics\" (\"state\");
06-17 16:31:40 jdbc[3]:
/*SQL */create index \"topicNameIndex\" on \"topics\" (\"name\");
06-17 16:31:40 jdbc[3]:
/*SQL t:5*/create table \"queries\" (\"stewardId\" BIGINT GENERATED BY DEFAULT
AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,\"id\" BIGINT NOT NULL,\"name\"
VARCHAR NOT NULL,\"researcher\" VARCHAR NOT NULL,\"topic\"
INTEGER,\"queryContents\" VARCHAR NOT NULL,\"stewardResponse\" VARCHAR NOT
NULL,\"date\" BIGINT NOT NULL);
06-17 16:31:40 jdbc[3]:
/*SQL */create index \"dateIndex\" on \"queries\" (\"date\");
06-17 16:31:40 jdbc[3]:
/*SQL t:1*/create index \"externalIdIndex\" on \"queries\" (\"id\");
06-17 16:31:40 jdbc[3]:
/*SQL */create index \"queryNameIndex\" on \"queries\" (\"name\");
06-17 16:31:40 jdbc[3]:
/*SQL */create index \"researcherIdIndex\" on \"queries\" (\"stewardId\");
06-17 16:31:40 jdbc[3]:
/*SQL t:1*/create index \"stewardResponseIndex\" on \"queries\"
(\"stewardResponse\");
06-17 16:31:40 jdbc[3]:
/*SQL */create index \"topicIdIndex\" on \"queries\" (\"topic\");
06-17 16:31:40 jdbc[3]:
/*SQL */create table \"userTopic\" (\"researcher\" VARCHAR NOT NULL,\"topicId\"
INTEGER NOT NULL,\"state\" VARCHAR NOT NULL,\"changedBy\" VARCHAR NOT
NULL,\"changeDate\" BIGINT NOT NULL);
06-17 16:31:40 jdbc[3]:
/*SQL */create unique index \"researcherTopicIdIndex\" on \"userTopic\"
(\"researcher\",\"topicId\");
06-17 16:31:40 database: disconnecting session #3
06-17 16:31:40 database: connecting session #4 to mem:test
06-17 16:31:40 jdbc[4]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[4]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[4]:
/**/Connection conn1 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[4]: exception
06-17 16:31:40 database: disconnecting session #4
06-17 16:31:40 database: connecting session #5 to mem:test
06-17 16:31:40 jdbc[5]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[5]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[5]:
/**/Connection conn2 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[5]:
/*SQL l:70 #:1 t:1*/merge into \"users\"
(\"userName\",\"fullName\",\"isSteward\") values (?,?,?) {1: 'ben', 2: 'ben',
3: FALSE};
06-17 16:31:40 database: disconnecting session #5
06-17 16:31:40 database: connecting session #6 to mem:test
06-17 16:31:40 jdbc[6]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[6]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[6]:
/**/Connection conn3 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[6]:
/*SQL l:70 #:1 t:1*/merge into \"users\"
(\"userName\",\"fullName\",\"isSteward\") values (?,?,?) {1: 'dave', 2:
'dave', 3: TRUE};
06-17 16:31:40 database: disconnecting session #6
06-17 16:31:40 database: connecting session #7 to mem:test
06-17 16:31:40 jdbc[7]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[7]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[7]:
/**/Connection conn4 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[7]:
/*SQL #:1 t:2*/select x2.x3 from (select max(x4.x5) as x3 from (select
x6.\"id\" as x5 from \"topics\" x6) x4) x2;
06-17 16:31:40 database: disconnecting session #7
List(insert into "topics"
("id","name","description","createdBy","createDate","state","changedBy","changeDate")
values (?,?,?,?,?,?,?,?))
06-17 16:31:40 database: connecting session #8 to mem:test
06-17 16:31:40 jdbc[8]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[8]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[8]:
/**/Connection conn5 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[8]:
/*SQL l:132 #:1*/insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 1, 2: 'UncontroversialKidneys', 3: 'Study
kidneys without controversy', 4: 'ben', 5: 1434573100466, 6: 'Pending', 7:
'ben', 8: 1434573100466};
06-17 16:31:40 database: disconnecting session #8
06-17 16:31:40 database: connecting session #9 to mem:test
06-17 16:31:40 jdbc[9]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[9]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[9]:
/**/Connection conn6 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[9]:
/*SQL l:101 #:1*/insert into \"userTopic\"
(\"researcher\",\"topicId\",\"state\",\"changedBy\",\"changeDate\") values
(?,?,?,?,?) {1: 'ben', 2: 1, 3: 'Approved', 4: 'ben', 5: 1434573100466};
06-17 16:31:40 database: disconnecting session #9
List(insert into "topics"
("id","name","description","createdBy","createDate","state","changedBy","changeDate")
values (?,?,?,?,?,?,?,?))
06-17 16:31:40 database: connecting session #10 to mem:test
06-17 16:31:40 jdbc[10]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[10]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[10]:
/**/Connection conn7 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[10]:
/*SQL l:132 #:1*/insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 2, 2: 'slightlyControversial', 3: 'who cares?',
4: 'ben', 5: 1434573100575, 6: 'Pending', 7: 'ben', 8: 1434573100575};
06-17 16:31:40 database: disconnecting session #10
06-17 16:31:40 database: connecting session #11 to mem:test
06-17 16:31:40 jdbc[11]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[11]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[11]:
/**/Connection conn8 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[11]:
/*SQL l:101 #:1*/insert into \"userTopic\"
(\"researcher\",\"topicId\",\"state\",\"changedBy\",\"changeDate\") values
(?,?,?,?,?) {1: 'ben', 2: 2, 3: 'Approved', 4: 'ben', 5: 1434573100575};
06-17 16:31:40 database: disconnecting session #11
List(insert into "topics"
("id","name","description","createdBy","createDate","state","changedBy","changeDate")
values (?,?,?,?,?,?,?,?))
06-17 16:31:40 database: connecting session #12 to mem:test
06-17 16:31:40 jdbc[12]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[12]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[12]:
/**/Connection conn9 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[12]:
/*SQL l:132 #:1 t:1*/insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 3, 2: 'controversial', 3: 'controversial', 4:
'ben', 5: 1434573100582, 6: 'Pending', 7: 'ben', 8: 1434573100582};
06-17 16:31:40 database: disconnecting session #12
06-17 16:31:40 database: connecting session #13 to mem:test
06-17 16:31:40 jdbc[13]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[13]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[13]:
/**/Connection conn10 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[13]:
/*SQL l:101 #:1*/insert into \"userTopic\"
(\"researcher\",\"topicId\",\"state\",\"changedBy\",\"changeDate\") values
(?,?,?,?,?) {1: 'ben', 2: 3, 3: 'Approved', 4: 'ben', 5: 1434573100582};
06-17 16:31:40 database: disconnecting session #13
List(insert into "topics"
("id","name","description","createdBy","createDate","state","changedBy","changeDate")
values (?,?,?,?,?,?,?,?))
06-17 16:31:40 database: connecting session #14 to mem:test
06-17 16:31:40 jdbc[14]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[14]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[14]:
/**/Connection conn11 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[14]:
/*SQL l:132 #:1*/insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 4, 2: 'moderatelyControversial', 3: 'more
controversial than that', 4: 'ben', 5: 1434573100588, 6: 'Pending', 7: 'ben',
8: 1434573100588};
06-17 16:31:40 database: disconnecting session #14
06-17 16:31:40 database: connecting session #15 to mem:test
06-17 16:31:40 jdbc[15]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[15]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[15]:
/**/Connection conn12 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[15]:
/*SQL l:101 #:1*/insert into \"userTopic\"
(\"researcher\",\"topicId\",\"state\",\"changedBy\",\"changeDate\") values
(?,?,?,?,?) {1: 'ben', 2: 4, 3: 'Approved', 4: 'ben', 5: 1434573100588};
06-17 16:31:40 database: disconnecting session #15
List(insert into "topics"
("id","name","description","createdBy","createDate","state","changedBy","changeDate")
values (?,?,?,?,?,?,?,?))
06-17 16:31:40 database: connecting session #16 to mem:test
06-17 16:31:40 jdbc[16]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[16]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[16]:
/**/Connection conn13 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[16]:
/*SQL l:132 #:1*/insert into \"topics\"
(\"id\",\"name\",\"description\",\"createdBy\",\"createDate\",\"state\",\"changedBy\",\"changeDate\")
values (?,?,?,?,?,?,?,?) {1: 5, 2: 'veryControversial', 3: 'Just say no', 4:
'ben', 5: 1434573100593, 6: 'Pending', 7: 'ben', 8: 1434573100593};
06-17 16:31:40 database: disconnecting session #16
06-17 16:31:40 database: connecting session #17 to mem:test
06-17 16:31:40 jdbc[17]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[17]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[17]:
/**/Connection conn14 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[17]:
/*SQL l:101 #:1*/insert into \"userTopic\"
(\"researcher\",\"topicId\",\"state\",\"changedBy\",\"changeDate\") values
(?,?,?,?,?) {1: 'ben', 2: 5, 3: 'Approved', 4: 'ben', 5: 1434573100593};
06-17 16:31:40 database: disconnecting session #17
06-17 16:31:40 database: connecting session #18 to mem:test
06-17 16:31:40 jdbc[18]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[18]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[18]:
/**/Connection conn15 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[18]:
/*SQL l:70 #:1*/merge into \"users\" (\"userName\",\"fullName\",\"isSteward\")
values (?,?,?) {1: 'ben', 2: 'ben', 3: FALSE};
06-17 16:31:40 database: disconnecting session #18
06-17 16:31:40 database: connecting session #19 to mem:test
06-17 16:31:40 jdbc[19]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[19]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[19]:
/**/Connection conn16 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[19]:
/*SQL #:1 t:1*/select x2.x3 from (select count(1) as x3 from (select
x4.\"createDate\" as x5, x4.\"description\" as x6, x4.\"state\" as x7,
x4.\"changeDate\" as x8, x4.\"changedBy\" as x9, x4.\"id\" as x10,
x4.\"createdBy\" as x11, x4.\"name\" as x12 from \"topics\" x4 where (not
exists(select x13.\"createDate\", x13.\"description\", x13.\"state\",
x13.\"changeDate\", x13.\"changedBy\", x13.\"id\", x13.\"createdBy\",
x13.\"name\" from \"topics\" x13 where (x13.\"id\" = x4.\"id\") and
(x13.\"changeDate\" > x4.\"changeDate\"))) and (x4.\"createdBy\" = 'ben')) x14)
x2;
06-17 16:31:40 database: disconnecting session #19
06-17 16:31:40 database: connecting session #20 to mem:test
06-17 16:31:40 jdbc[20]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[20]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[20]:
/**/Connection conn17 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[20]:
/*SQL #:5 t:1*/select x2.\"id\", x2.\"name\", x2.\"description\",
x2.\"createdBy\", x2.\"createDate\", x2.\"state\", x2.\"changedBy\",
x2.\"changeDate\" from \"topics\" x2 where (not exists(select
x3.\"createDate\", x3.\"description\", x3.\"state\", x3.\"changeDate\",
x3.\"changedBy\", x3.\"id\", x3.\"createdBy\", x3.\"name\" from \"topics\" x3
where (x3.\"id\" = x2.\"id\") and (x3.\"changeDate\" > x2.\"changeDate\"))) and
(x2.\"createdBy\" = 'ben') order by x2.\"name\";
06-17 16:31:40 database: disconnecting session #20
06-17 16:31:40 database: connecting session #21 to mem:test
06-17 16:31:40 jdbc[21]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:40 jdbc[21]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:40 jdbc[21]:
/**/Connection conn18 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:40 jdbc[21]:
/*SQL #:1*/select x2.\"userName\", x2.\"fullName\", x2.\"isSteward\" from
\"users\" x2 where x2.\"userName\" in ('ben');
06-17 16:31:40 database: disconnecting session #21
[INFO] [06/17/2015 16:31:40.978] [ForkJoinPool-2-worker-7]
[ActorSystem(net-shrine-steward-StewardServiceTest)] route: Response for
Request :
HttpRequest(GET,http://example.com/researcher/topics?sortBy=name,List(Authorization:
Basic YmVuOmthcG93),Empty,HTTP/1.1)
Response: HttpResponse(200 OK,HttpEntity(application/json;
charset=UTF-8,{"userId":"ben","totalCount":5,"skipped":0,"topics":[{"id":1,"name":"UncontroversialKidneys","description":"Study
kidneys without
controversy","createdBy":{"userName":"ben","fullName":"ben","roles":["Researcher"]},"createDate":1434573100466,"state":"Pending","changedBy":{"userName":"ben","fullName":"ben","roles":["Researcher"]},"changeDate":1434573100466},{"id":2,"name":"slightlyControversial","description":"who
cares?","createdBy":{"userName":"ben","fullName":"ben","roles":["Researcher"]},"crea...),List(),HTTP/1.1)
06-17 16:31:41 database: connecting session #22 to mem:test
06-17 16:31:41 jdbc[22]:
/*SQL */SET TRACE_LEVEL_SYSTEM_OUT 2;
06-17 16:31:41 jdbc[22]:
/*SQL */SET DB_CLOSE_DELAY -1;
06-17 16:31:41 jdbc[22]:
/**/Connection conn19 =
DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;TRACE_LEVEL_SYSTEM_OUT=2",
"", "");
06-17 16:31:41 jdbc[22]:
/*SQL t:1*/drop table \"userTopic\";
06-17 16:31:41 jdbc[22]:
/*SQL t:1*/drop table \"queries\";
06-17 16:31:41 jdbc[22]:
/*SQL t:1*/drop table \"topics\";
06-17 16:31:41 jdbc[22]:
/*SQL */drop table \"users\";
