Comments (2)
Hi, thanks for opening this!
db-sync/src/Hash/HashAbstract.php
Line 26 in d484fce
You can see here that we convert the hex string to a decimal integer, so the situation you have described never occurs. Its actually more like this:
mysql> SELECT CAST(CONV(SUBSTR(MD5('#'),1,16),16,10) as unsigned);
+-----------------------------------------------------+
| CAST(CONV(SUBSTR(MD5('#'),1,16),16,10) as unsigned) |
+-----------------------------------------------------+
| 120467394665419809 |
+-----------------------------------------------------+
1 row in set (0.00 sec)
Are you experiencing some kind of problem that you had thought may be down to this? It would have been good to know what you are seeing when testing dbsync against your database and what you would have expected to see.
Cheers
Joe
from db-sync.
I was not testing the code, merely trying to understand it. Although I believe that since an MD5 hash is set to 2 bytes, this particular line of code does not come into play, thus I may have been hasty to find fault with it.
from db-sync.
Related Issues (20)
- Syntax error or access violation: 1064 HOT 2
- Correct db-sync code for PHP version (correcting DbSync\Transfer error) HOT 6
- symfony/console issue with Laravel 5.2.* HOT 3
- could not find driver HOT 2
- Laravel 5.6 and Symfony Console HOT 4
- Specify options in Php? HOT 1
- could we sync tables with same host but different port for different db HOT 1
- php, php-mysql packages HOT 1
- Base table or view not found: 1146 Table 'TestDatabase;.wp_bp_activity' HOT 4
- Using PHP Non-CommandLine - Sync All tables HOT 2
- Delete from source does not sync to Destination HOT 1
- RuntimeException table does not have a primary key HOT 18
- Error if using a column that is not id as primary key HOT 1
- Support different database names HOT 1
- Table sync sql error duplicate entries
- Feature request: ordering field HOT 1
- Sync multiple tables HOT 1
- ') < ()) t limit 1' added into the query HOT 3
- Column not found: 1054 Unknown column '*fieldname*' in 'field list'
- How to use as PHP page HOT 5
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from db-sync.