Skip to content

SqlsrvDriver compatibility fix for SQL Server 2012 and 2014#206

Merged
dg merged 7 commits intodg:testfrom
castamir:test
Jan 28, 2016
Merged

SqlsrvDriver compatibility fix for SQL Server 2012 and 2014#206
dg merged 7 commits intodg:testfrom
castamir:test

Conversation

@castamir
Copy link
Copy Markdown
Contributor

fixed limit & offset
fixed index and table metadata loading
fixed tests for sqlsrv
changed AppVeyor SQL Server environment from 2008 to 2012 (version 2008 remains incompatible)

NOTE: meta.phpt(20) will fail, because on AppVeyor database, there is schema dbo with 9 tables instead of 3:

   spt_fallback_db [BASE TABLE]
   spt_fallback_dev [BASE TABLE]
   spt_fallback_usg [BASE TABLE]
   products [BASE TABLE]
   customers [BASE TABLE]
   orders [BASE TABLE]
   MSreplication_options [BASE TABLE]
   spt_values [VIEW]
   spt_monitor [BASE TABLE]

Mira Paulik added 3 commits January 26, 2016 13:11
… 11+

SqlsrvReflector: changed constrains metadata loading from
INFORMATION_SCHEMA to sys schema to get complete list of all constraints,
not PK only
@dg
Copy link
Copy Markdown
Owner

dg commented Jan 26, 2016

Great, thank you!

@castamir
Copy link
Copy Markdown
Contributor Author

What's gonna be next? Is there anything you need from me or what can I help you with?

@dg
Copy link
Copy Markdown
Owner

dg commented Jan 27, 2016

Is it ready to merge? Probably the last two commits should be merged together.

@castamir
Copy link
Copy Markdown
Contributor Author

Almost - what about the failing test? Should I skip this Assert? What about Sql server 2008? It is still bugged...

@castamir
Copy link
Copy Markdown
Contributor Author

I've cleaned code to be similar to your code style and I have also allowed sqlsrv 2014 on AppVeyor as well and it seems it's working there.

@castamir castamir changed the title SqlsrvDriver compatibility fix for SQL Server 2012 SqlsrvDriver compatibility fix for SQL Server 2012 and 2014 Jan 27, 2016
@dg
Copy link
Copy Markdown
Owner

dg commented Jan 28, 2016

Thank you very much, it is great!

dg added a commit that referenced this pull request Jan 28, 2016
SqlsrvDriver compatibility fix for SQL Server 2012 and 2014
@dg dg merged commit ed56cf7 into dg:test Jan 28, 2016
@castamir
Copy link
Copy Markdown
Contributor Author

You are welcome.

When can I expect a new tag & release? Is is a question of day(s) or rather week(s)?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants