sym233 opened a new issue, #17317:
URL: https://github.com/apache/iotdb/issues/17317

   ### Search before asking
   
   - [x] I searched in the [issues](https://github.com/apache/iotdb/issues) and 
found nothing similar.
   
   
   ### Version
   
   IoTDB: 2.0.7-SNAPSHOT
   JDBC Driver: iotdb-jdbc 2.0.7-SNAPSHOT
   
   IoTDB Database: 1.3.6-standalone
   
   I found this issue may be related to 2.0.7 driver connecting to 1.3.6 
database. It looks fine when connecting to 2.0.7 database.
   
   ### Describe the bug and provide the minimal reproduce step
   
   
   1. Create a time series with BOOLEAN and FLOAT columns:
   ```sql
   CREATE TIMESERIES root.ln.wf01.wt01.status BOOLEAN
   CREATE TIMESERIES root.ln.wf01.wt01.temperature FLOAT
   ```
   
   2. Insert some test data:
   ```sql
   INSERT INTO root.ln.wf01.wt01 (Time, status, temperature) VALUES (1, true, 
25.5)
   ```
   
   3. Query the data using JDBC:
   ```java
   ResultSet rs = stmt.executeQuery("select status, temperature from 
root.ln.wf01.wt01 limit 1");
   ResultSetMetaData meta = rs.getMetaData();
   while (rs.next()) {
       for (int i = 1; i <= meta.getColumnCount(); i++) {
           System.out.println(meta.getColumnName(i) + " = " + rs.getObject(i));
       }
   }
   ```
   
   ### What did you expect to see?
   
   ```
   === Column Metadata ===
   Column 1: Time, Type: 93 (TIMESTAMP)
   Column 2: root.ln.wf01.wt01.status, Type: 16 (BOOLEAN)
   Column 3: root.ln.wf01.wt01.temperature, Type: 6 (FLOAT)
   
   === Query Result ===
   root.ln.wf01.wt01.status = true (class: java.lang.Boolean)
   root.ln.wf01.wt01.temperature = 25.5 (class: java.lang.Float)
   ```
   
   ### What did you see instead?
   
   ```
   === Column Metadata ===
   Column 1: Time, Type: 93 (TIMESTAMP)
   Column 2: root.ln.wf01.wt01.status, Type: 16 (BOOLEAN)
   Column 3: root.ln.wf01.wt01.temperature, Type: 6 (FLOAT)
   
   === Query Result ===
   root.ln.wf01.wt01.status = 10.0 (class: java.lang.Float)
   root.ln.wf01.wt01.temperature = true (class: java.lang.Boolean)
   ```
   
   The BOOLEAN and FLOAT column values are completely swapped!
   
   ### Anything else?
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [ ] I'm willing to submit a PR!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to