On 2014-07-01 10:49 PM, Brian Craft wrote:
Is there any way to test a parameterized query from the console?
select * from foo where x = ?
and pass in the parameter somehow? Or do I have to replace all the parameters
in-place?
Nope, sorry, nothing like that at the moment.
However, patches
When running CREATE SQL Query as below from a ".sql" file , Syntax error is
thrown,. However if i run the same sql on the console it runs fine.
create alias TO_DATE as $$
java.util.Date toDate(String s,String format) throws Exception {
return new java.text.SimpleDateFormat(".MM.dd").parse(
On 2014-07-02 06:31 AM, Kunal Kishan wrote:
When running CREATE SQL Query as below from a ".sql" file , Syntax error is
thrown,. However if i run the same sql on
the console it runs fine.
How are you running it from a .sql file?
--
You received this message because you are subscribed to th
On 2014-07-01 06:03 PM, Jens Hohmuth wrote:
Calling ChangeFileEncryption with a wrong password will correctly throw an
exception.
Thank you for the excellent analysis and test case.
A patch has been committed to fix this.
--
You received this message because you are subscribed to the Googl
On 2014-07-02 08:22 AM, Gili wrote:
permission has a single IDENTITY column. I am expecting SCOPE_IDENTITY() to
return the inserted ID in the second
statement. Any ideas why this is not happening?
Do you have a standalone test case?
This is working for me:
create table permission(id ident
Hi Noel,
nice! Let me know if you want an improvement.
Regards, Martin.
On Mon, Jun 30, 2014 at 9:01 AM, Noel Grandin wrote:
> Thank for the patch, it has been committed to SVN.
>
>
> On 2014-06-13 07:09 PM, Martin Grajcar wrote:
>
>>
>> Sure. I wrote something (attached), let me know what do
There is always lots of stuff to work on if you're keen :-)
For example, see:
https://groups.google.com/d/msg/h2-database/SL2hdB7VlnY/6RanPmy_WVsJ
which is also a problem I have seen, but haven't had a chance to track down yet.
On 2014-07-02 01:47 PM, Martin Grajcar wrote:
Hi Noel,
nice! Le
On 02/07/2014 4:09 AM, Noel Grandin wrote:
On 2014-07-02 08:22 AM, Gili wrote:
permission has a single IDENTITY column. I am expecting
SCOPE_IDENTITY() to return the inserted ID in the second
statement. Any ideas why this is not happening?
Do you have a standalone test case?
This is worki
When I run the following query in Java with a
PreparedStatement.RETURN_GENERATED_KEYS flag no keys seem to be returned:
INSERT INTO table(id, another_primary_key) VALUES ((SELECT
COALESCE(max(id)+1,1) FROM table),?)
I don't use the JDBC connection with multiple thread as it is being
suggested
Trying to better understand how implicit joins work, I tried this:
select * from table(a int = (1,2,3)), table(b int = (3,4,5))
which gives different results than
select * from (select * from table(a int = (1,2,3))), (select * from
table(b int = (3,4,5)))
Not affecting anything, but it was
10 matches
Mail list logo