Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2.41, 10.3.32, 10.4.22, 10.5.13
-
ODBC table type
Description
UPDATE 10.5.12 to 10.5.13.
CREATE TABLE pult_boxmdu ( |
id int(11) NOT NULL, |
region_ID int(11) NOT NULL, |
PRIMARY KEY (id) |
)
|
ENGINE = CONNECT, |
TABLE_TYPE = ODBC,
|
TABNAME = 'pult_boxmdu', |
READONLY = 1,
|
CHARACTER SET cp1251, |
COLLATE cp1251_ukrainian_ci, |
CONNECTION = 'DSN=Odyssey'; |
|
|
run SELECT id, region_ID FROM pult_boxmdu; |
OUT: |
id region_ID
|
14 3
|
8 3
|
26 3
|
712 2
|
22 3
|
|
|
SELECT region_ID FROM pult_boxmdu; |
region_ID
|
0
|
0
|
0
|
0
|
0
|
Why "0? How to solve?
Attachments
Issue Links
- is duplicated by
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Olivier Bertrand [ bertrandop ] |
| Description |
UPDATE 10.5.12 to 10.5.13.
CREATE TABLE pult_boxmdu ( id int(11) NOT NULL, region_ID int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE = CONNECT, TABLE_TYPE = ODBC, TABNAME = 'pult_boxmdu', READONLY = 1, CHARACTER SET cp1251, COLLATE cp1251_ukrainian_ci, CONNECTION = 'DSN=Odyssey'; run SELECT id, region_ID FROM pult_boxmdu; OUT: id region_ID 14 3 8 3 26 3 712 2 22 3 run SELECT region_ID FROM pult_boxmdu; OUT: region_ID 0 0 0 0 0 Why "0? How to solve? |
UPDATE 10.5.12 to 10.5.13.
{code:sql} CREATE TABLE pult_boxmdu ( id int(11) NOT NULL, region_ID int(11) NOT NULL, PRIMARY KEY (id) ) ENGINE = CONNECT, TABLE_TYPE = ODBC, TABNAME = 'pult_boxmdu', READONLY = 1, CHARACTER SET cp1251, COLLATE cp1251_ukrainian_ci, CONNECTION = 'DSN=Odyssey'; run SELECT id, region_ID FROM pult_boxmdu; OUT: id region_ID 14 3 8 3 26 3 712 2 22 3 SELECT region_ID FROM pult_boxmdu; region_ID 0 0 0 0 0 {code} Why "0? How to solve? |
| Attachment | my.ini [ 60628 ] |
| Component/s | Storage Engine - Connect [ 10128 ] | |
| Component/s | Server [ 13907 ] |
| Labels | Connect-Engine |
| Environment |
OS MS Server 2019
ODBC PostgreSql Unicode(x64) 11.01.00.00 |
ODBC table type |
| Affects Version/s | 10.4.22 [ 26031 ] | |
| Affects Version/s | 10.3.32 [ 26029 ] | |
| Affects Version/s | 10.2.41 [ 26032 ] |
| issue.field.resolutiondate | 2021-11-26 11:34:28.0 | 2021-11-26 11:34:28.229 |
| Fix Version/s | 10.2.42 [ 26803 ] | |
| Fix Version/s | 10.3.33 [ 26805 ] | |
| Fix Version/s | 10.4.23 [ 26807 ] | |
| Fix Version/s | 10.5.14 [ 26809 ] | |
| Fix Version/s | 10.6.6 [ 26811 ] | |
| Fix Version/s | 10.7.2 [ 26813 ] | |
| Fix Version/s | 10.8.1 [ 26815 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 127522 ] | MariaDB v4 [ 159847 ] |
| Fix Version/s | 10.8.1 [ 26815 ] |
| Link |
This issue is duplicated by |