Skip to content

MariaDB 10.2.7 BC break #6565

Closed
Closed
@bilhackmac

Description

@bilhackmac

MariaDB 10.2.7 and future releases (5.5, 10.0 and 10.1 branches are not affected) just resolve an old bug in SQL standards implementation and introduce a BC break

Ticket that explains changes https://jira.mariadb.org/browse/MDEV-13132
Ticket that confirms (in comments) only >= v10.2.7 are affected https://jira.mariadb.org/browse/MDEV-13341

Concretely, for Doctrine, schema update just gone crazy and want to update every column with NULL default because 'NULL' is return by MariaDB instead of NULL.
I don't find any other issues… for now.

For the moment, MySQL don't have the same issue.

Activity

Ocramius

Ocramius commented on Jul 19, 2017

@Ocramius
Member

Needs a test case though...

sagaraspl

sagaraspl commented on Aug 24, 2017

@sagaraspl

Hi @bilhackmac and @Ocramius I also faced the same issue when I updated with MariaDB 10.2.7

belgattitude

belgattitude commented on Aug 26, 2017

@belgattitude

Same issue too.

baumannsven

baumannsven commented on Aug 26, 2017

@baumannsven

I have the same problem.

lcobucci

lcobucci commented on Aug 26, 2017

@lcobucci
Member

@sabzeta @belgattitude @baumannsven as @Ocramius said, please send us a PR with tests. That helps A LOT 😉

sabzeta

sabzeta commented on Aug 26, 2017

@sabzeta
Contributor

I haven't realy ran into this problem, but it's good to be aware. I'll try to look into it.
Meanwhile, perhaps @sagaraspl could send a PR with tests?

belgattitude

belgattitude commented on Aug 26, 2017

@belgattitude

just published a P/R on doctrine/dbal#2825 with the third approach... Feel free to comment.

mdeboer

mdeboer commented on Sep 6, 2017

@mdeboer

Same problem here, narrowed it down to it being a NULL problem of some sort as removing all nullable relations and fields solved it. That combined with me recently pulling the newest mariadb image for Docker explains it all.

There went another 3/4 hours of my day trying to find an error in my code even though the mapping files validated fine 😭 Using the mysql:5 image now which should fix things, fingers crossed 🤞 .

Hopefully a fix will be merged soon!

51 remaining items

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

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

    Development

    No branches or pull requests

      Participants

      @Ocramius@lcobucci@belgattitude@musicjerm@mdeboer

      Issue actions

        MariaDB 10.2.7 BC break · Issue #6565 · doctrine/orm