View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001922 | SymmetricDS | Bug | public | 2014-08-17 20:49 | 2014-08-27 12:53 |
Reporter | azarubkin | Assigned To | chenson | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.6.4 | ||||
Target Version | 3.6.6 | Fixed in Version | 3.6.6 | ||
Summary | 0001922: Incorrect conversion of values of type BIT in SQL Server 2005 to SQLite | ||||
Description | The structure of table which contains BIT columns is translated as follows: 2014-08-18 00:44:06,913 INFO [post] [DefaultDatabaseWriter] [post-job-5] About to create table using the following definition: <?xml version="1.0"?> <!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database"> <database name="dataextractor"> <table name="regimes"> <column name="regime_id" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true"> <platform-column name="mssql2005" type="int identity" size="10"/> </column> <column name="regime_name" required="true" type="VARCHAR" size="50"> <platform-column name="mssql2005" type="varchar" size="50"/> </column> <column name="is_special" required="true" type="BIT" size="1"> <platform-column name="mssql2005" type="bit" size="1"/> </column> </table> </database> 2014-08-18 00:44:06,913 INFO [post] [SqliteDatabasePlatform] [post-job-5] Running alter sql: CREATE TABLE "regimes"( "regime_id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "regime_name" VARCHAR NOT NULL, "is_special" INTEGER NOT NULL ); i.e. BIT is translated to INTEGER. But the values are translated as boolean values, which leads to error during reload: 2014-08-18 00:44:42,122 ERROR [post] [SqliteDatabasePlatform] [post-job-5] Could not convert a value of false for column is_special of type INTEGER 2014-08-18 00:44:42,122 ERROR [post] [SqliteDatabasePlatform] [post-job-5] For input string: "false" | ||||
Tags | No tags attached. | ||||
SymmetricDS: master ad5442ce 2014-08-20 18:55:17 Details Diff |
0001922: Incorrect conversion of values of type BIT in SQL Server 2005 to SQLite |
Affected Issues 0001922 |
|
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
SymmetricDS: master eaf28f48 2014-08-21 13:20:42 Details Diff |
0001922: Incorrect conversion of values of type BIT in SQL Server 2005 to SQLite |
Affected Issues 0001922 |
|
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
SymmetricDS: master c63e0669 2014-08-21 13:37:10 Details Diff |
0001922: Incorrect conversion of values of type BIT in SQL Server 2005 to SQLite |
Affected Issues 0001922 |
|
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File | ||
SymmetricDS: master 0af0d316 2014-08-21 15:48:01 Details Diff |
0001922: Incorrect conversion of values of type BIT in SQL Server 2005 to SQLite |
Affected Issues 0001922 |
|
mod - symmetric-db/src/main/java/org/jumpmind/db/platform/AbstractDatabasePlatform.java | Diff File |
Date Modified | Username | Field | Change |
---|---|---|---|
2014-08-17 20:49 | azarubkin | New Issue | |
2014-08-20 22:55 | chenson | Fixed in Version | => 3.6.6 |
2014-08-20 22:55 | chenson | Target Version | => 3.6.6 |
2014-08-20 22:55 | chenson | Status | new => resolved |
2014-08-20 22:55 | chenson | Resolution | open => fixed |
2014-08-20 22:55 | chenson | Assigned To | => chenson |
2014-08-20 23:00 | chenson | Changeset attached | => SymmetricDS trunk r8622 |
2014-08-21 18:00 | chenson | Changeset attached | => SymmetricDS trunk r8624 |
2014-08-21 18:00 | chenson | Changeset attached | => SymmetricDS trunk r8625 |
2014-08-21 20:00 | chenson | Changeset attached | => SymmetricDS trunk r8627 |
2014-08-27 12:53 | chenson | Status | resolved => closed |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master 0af0d316 |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master c63e0669 |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master eaf28f48 |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master ad5442ce |