On 6-3-2016 03:45, Adriano dos Santos Fernandes wrote:
> I see two bugs with your implementation. Both of these commands should
> raise error:
>
> create or alter sequence s1;
Why would this one need to raise an error? I think it would be fine that
if it already exists, nothing is done, and if it
On 5-3-2016 22:28, Lester Caine wrote:
> On 05/03/16 13:32, Dimitry Sibiryakov wrote:
>> Currently parser enforce attribute clauses to have a definite positions
>> in the
>> statement. SQL standard doesn't require that.
>> Do you agree that position-insensitive clauses would be more conven
05.03.2016 18:18, Björn Reimer пишет:
> Hello,
>
>
>> Afaik, gbak will not initialize anything :)
>Yes, that's the problem with the new security concept :-)
>
>
>> Did you try to restore using an embedded connection?
> No, not embedded, but via IP.
>
> But I think it makes no differe
On 06/03/16 08:51, Mark Rotteveel wrote:
>> I don't think that the SQL standard ever imposed an order on these? But
>> > both MySQL and Postgresql seem to standardise on the DEFAULT last :(
> The SQL standard specifies that the default clause follows the data type
> definition. And this is what Fi
06.03.2016 3:45, Adriano dos Santos Fernandes wrote:
> I see two bugs with your implementation. Both of these commands should
> raise error:
>
> create or alter sequence s1;
This command if perfectly ok from Language Reference POV: both START
WITH/RESTART and
INCREMENT clauses are marked as o
Em 06/03/2016 05:36, Mark Rotteveel escreveu:
> On 6-3-2016 03:45, Adriano dos Santos Fernandes wrote:
>> I see two bugs with your implementation. Both of these commands should
>> raise error:
>>
>> create or alter sequence s1;
>
> Why would this one need to raise an error? I think it would be fin
Em 06/03/2016 06:32, Dimitry Sibiryakov escreveu:
> 06.03.2016 3:45, Adriano dos Santos Fernandes wrote:
>> I see two bugs with your implementation. Both of these commands should
>> raise error:
>>
>> create or alter sequence s1;
>
>This command if perfectly ok from Language Reference POV: bot
06.03.2016 14:47, Adriano dos Santos Fernandes wrote:
> Because that is not CEATE OR ALTER, that is CREATE OR
> DO-NOTHING-IF-EXIST and we do not have this command.
>
> It's explicitly designed to raise an error.
ALTER is explicitly designed to raise an error. About CREATE OR ALTER I'm
not tha
Hi *,
looking at this [1] commit followed by this [2] commit makes me wonder
why not call security database just security.fdb? I know somebody might
do in-place upgrade and the database might be incompatible, but I think
that's least of his/hers problem.
[1]:
https://github.com/FirebirdSQL/core/
On 6-3-2016 14:47, Adriano dos Santos Fernandes wrote:
> Em 06/03/2016 05:36, Mark Rotteveel escreveu:
>> On 6-3-2016 03:45, Adriano dos Santos Fernandes wrote:
>>> I see two bugs with your implementation. Both of these commands should
>>> raise error:
>>>
>>> create or alter sequence s1;
>>
>> Why
Em 06/03/2016 10:55, Dimitry Sibiryakov escreveu:
> 06.03.2016 14:47, Adriano dos Santos Fernandes wrote:
>> Because that is not CEATE OR ALTER, that is CREATE OR
>> DO-NOTHING-IF-EXIST and we do not have this command.
>>
>> It's explicitly designed to raise an error.
>
>ALTER is explicitly de
Hi!
Original FB/Java plugin had a security database where SYSDBA could
define JAAS permissions per users.
Since Java can read files and do bad things, it's SYSDBA (server admin)
to define these permissions. And since was SYSDBA task to create users,
that was ok.
No we can have embedded users in
06.03.2016 17:00, Adriano dos Santos Fernandes wrote:
> Not sure if he remembers, but that has already discussed by me and he at
> the time this command was firstly created ;)
>
> ---
>> >I think this command has something weird:
>> >
>> >SQL> create sequence s1 start with 4;
>> >SQL> creat
06.03.2016 17:00, Adriano dos Santos Fernandes wrote:
> At the same time, analyzing the standard, I see they allow RESTART [
>>WITH ] in ALTER, i.e., restarting to 0, and we do not allow this
>>syntax.
BTW, currently ALTER SEQUENCE RESTART reset it not to 0, but to initial
value.
--
WBR,
Hello Guys,
i want to play with the new c++-object-oriented api and I show the examples in
examples/dbcrypt and examples/interfaces of the second release candidate and
see that this examples includes and "firebird.h".
But I can't find this files in the /include or other directory.
Should the
Em 06/03/2016 13:09, Dimitry Sibiryakov escreveu:
>
>For me it rather look like he was against unexpected resetting of sequence
> to zero, but
> I don't see in this quote definite objections against ""create if not exists"
> semantics".
> I, personally, think that this semantic is useful
06.03.2016 18:02, Adriano dos Santos Fernandes wrote:
> For CREATE OR ALTER SEQUENCE alone and hidden in a commit about
> non-positioned clauses, it does not make any sense!!
May be. But before I run to code limitation which will be removed with the
next commit,
I would like to see a comment
06.03.2016 18:02, Adriano dos Santos Fernandes wrote:
> Then you write a proposal and implementation for all commands.
Actually, I cannot remember any other database object that can be created
with name
only, except roles. But roles has no "create or alter" command. Which command
did you hav
Em 06/03/2016 14:39, Dimitry Sibiryakov escreveu:
> 06.03.2016 18:02, Adriano dos Santos Fernandes wrote:
>> Then you write a proposal and implementation for all commands.
>
>Actually, I cannot remember any other database object that can be created
> with name
> only, except roles. But roles
There seems to be something wrong in both Windows and Linux kits...
Adriano
Em 06/03/2016 13:21, Rudolf Grauberger escreveu:
> Hello Guys,
>
> i want to play with the new c++-object-oriented api and I show the
> examples in examples/dbcrypt and examples/interfaces of the second
> release candi
Hi,
is somewhere some "initial" roadmap for Firebird v4.
And is some plans to eliminate 255 contexts limit in the near feature?
regards,
Karol Bieniaszewski--
Transform Data into Opportunity.
Accelerate data analysis in
Hi All,
Not see any message about 3.0 RC2 released on the lists
(devel/general/support). I follow the lists daily, and know from the
great news from the (accidentally opened) web page.
Gabor
--
Transform Data into Oppo
22 matches
Mail list logo
