parallel data warehouse - override default script for initialization of flyway metadata table -

-

i'm working microsoft parallel data warehouse appliance , attempting use flyway handle table migrations in environment. issue i'm running default script establishing schema_version table fails.

here default script far can tell being executed upon calling baseline().

create table [dbo].[dbresult_migration] (     [installed_rank] int not null,     [version] nvarchar(50),     [description] nvarchar(200),     [type] nvarchar(20) not null,     [script] nvarchar(1000) not null,     [checksum] int,     [installed_by] nvarchar(100) not null,     [installed_on] datetime not null default getdate(),     [execution_time] int not null,     [success] bit not null );  alter table [dbo].[dbresult_migration] add constraint [dbresult_migration_pk] primary key ([installed_rank]); create index [dbresult_migration_s_idx] on [dbo].[dbresult_migration] ([success]);

specifically microsoft parallel data warehouse (ms pdw or aps known) doesn't support expressions default constraints.

msg 104338, level 16, state 1, line 1 expression cannot used default constraint. specify constants default constraint.

which causes error when getdate() used default installed_on column.

the alter table statement fail primary keys , indices managed differently in environment.

is there way override default initialization script schema_version?

update

further investigation reveals next failure occurs when attempting insert records schema_version table. current implementation attempts identify current user based on call dbsupport.getcurrentuserfunction(). sql server function suser_sname(). while function available on both standard sql server , parallel data warehouse current implementation of parallel data warehouse not allow function calls within values portion of insert statement. such, following error returned:

insert values statement can contain constant literal values or variable references.

when query attempted logged as:

insert [dbo].[dbresult_migration] ([installed_rank],[version],[description],[type],[script],[checksum],[installed_by],[execution_time],[success]) values (@p0, @p1, @p2, @p3, @p4, @p5, suser_sname(), @p6, @p7)

update 2

i have fork of flyway-core correctly identifies if connecting sql server vs sql server parallel data warehouse. issue have identified sql server pdw not allow ddl within transactions , attempt baseline fails appears attempted within transaction template. evolving question of understanding how modify initialization script need support of new database platform. i've submitted new issue on flyway repo on github here.


Comments

Post a Comment

Popular posts from this blog

ios - RestKit 0.20 — CoreData: error: Failed to call designated initializer on NSManagedObject class (again) -

-
this error has shown on many times, seems. prominent answer issue seems restkit 0.20 — coredata: error: failed call designated initializer on nsmanagedobject class however, solution posted doesn't work me. let's start beginning: i want upload file server. want parse response make sure uploaded. if not, try again later. model has boolean variable called nsnumber *senttoserver purpose (in coredata, bool saved nsnumber ) . because don't know whether sending going successful, save entity coredata model first before sending via restkit. when post request successful, server returns json string this: {"id":14,"created":true} notice that, of course, id not set on coredata model yet, both id , created new informations model. here's model: @interface recording : nsmanagedobject @property (nonatomic, retain) nsstring * audiofilepath; @property (nonatomic, retain) nsdate * createdat; @property (nonatomic, retain) nsstring * deviceid; @...
Read more

java - Digest auth with Spring Security using javaconfig -

-
so i'm trying create digest authentication spring following documentation trying translate xml "requirements" in java requirements. let's have xml in docs: <bean id="digestfilter" class= "org.springframework.security.web.authentication.www.digestauthenticationfilter"> <property name="userdetailsservice" ref="jdbcdaoimpl"/> <property name="authenticationentrypoint" ref="digestentrypoint"/> <property name="usercache" ref="usercache"/> </bean> <bean id="digestentrypoint" class= "org.springframework.security.web.authentication.www.digestauthenticationentrypoint"> <property name="realmname" value="contacts realm via digest authentication"/> <property name="key" value="acegi"/> <property name="noncevalidityseconds" value="10"/> </b...
Read more

laravel - PDOException in Connector.php line 55: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES) -

-
my .env: app_env=local app_debug=true app_key=myappkey app_url=http://localhost db_connection=mysql db_host=localhost db_port=3306 db_database=gestiontaller db_username=root db_password='root' cache_driver=file session_driver=file queue_driver=sync redis_host=127.0.0.1 redis_password=null redis_port=6379 mail_driver=smtp mail_host=mailtrap.io mail_port=2525 mail_username=null mail_password=null mail_encryption=null i've tried password ", ' , without, restarting server every time. i've tried changing localhost 172.0.0.1. yes, password correct, running mysql -u root -p introducing password root in prompt can go mysql. users table: +------------------+-----------+ | user | host | +------------------+-----------+ | debian-sys-maint | localhost | | mysql.sys | localhost | | root | localhost | | root1 | localhost | +------------------+-----------+ i've added homestead.yaml this: database_port: 3306 ...
Read more