[CONJ-533] Wrong value when inserting time data type with JDBC java.sql.Time Created: 2017-10-01  Updated: 2017-10-26  Resolved: 2017-10-26

Status: Closed
Project: MariaDB Connector/J
Component/s: Other
Affects Version/s: 1.6.0, 2.1.2
Fix Version/s: 2.2.0, 1.7.0

Type: Bug Priority: Critical
Reporter: Max Lam Assignee: Diego Dupin
Resolution: Fixed Votes: 0
Labels: JDBC, java.sql.Time
Environment:

Mac, Linux, MariaDB 10.2.6, 10.2.7 (Linux Galera)

Attachments: Java Source File TimeTest.java    

 Description   

This bug is related to a bug which I've discovered that doesn't happen on MariaDB JDBC Driver Version 1.5.9, but it happened on any version from 1.6.x onwards all the way to ver 2.1.2. The main issue is that whenever a value of 5:00:00 is inserted into the column, and later queried, it will become 19:00:00.

To reproduce this issue:
1) Create a db and table like the below:
drop database if exists time_test;
create database if not exists time_test default character set = 'utf8' collate utf8_bin;
use time_test;
set storage_engine=InnoDB;

create table t_time_test (
uuid char(36) not null,
time_field time not null,
primary key(uuid)
);

2) I have attached some codes in Java (namely TimeTest.java). This small program inserts a row with the 'time_field' column value of 5AM (doesn't matter about date or time zone), and later query the row inserted. It turns out that on MariaDB JDBC Driver 1.5.9, the time_field column is 05:00:00, but if I were to run this with MariaDB JDBC Driver 1.6.x or 2.1.x, the time_field column is 19:00:00.

MariaDB's TimeZone through "SHOW GLOBAL VARIABLES LIKE 'time_zone'" is 'SYSTEM'.

Help is much appreciated.

 Comments   
Comment by Diego Dupin [ 2017-10-02 ]

I didn't succeed reproducing this issue, and fail to see how that can occur.

Could you please indicate :

  • URL ( connection string)
  • java default timezone
  • server value of server time-zone ("SELECT @@time_zone, @@system_time_zone ")
Comment by Max Lam [ 2017-10-02 ]

The URL/Connection string is as written in the TimeTest.java:
jdbc:mariadb://localhost:3306/time_test

The Java default timezone:
I just did a System.out.println( "Default Time Zone: " + TimeZone.getDefault() ); and the result is as follow:
Default Time Zone: sun.util.calendar.ZoneInfo[id="Asia/Kuala_Lumpur",offset=28800000,dstSavings=0,useDaylight=false,transitions=10,lastRule=null]

The result of "SELECT @@time_zone, @@system_time_zone":
-------------------------------+

@@time_zone @@system_time_zone

-------------------------------+

SYSTEM +08

-------------------------------+

Hope these help.

Comment by Diego Dupin [ 2017-10-04 ]

Ok, i still see no reason why this could occur.
I've created a small project (https://github.com/rusher/CONJ-533) to log protocol exchanges :

So, if you can run it :
git clone https://github.com/rusher/CONJ-533.git
cd CONJ-533
mvn exec:java -Dexec.mainClass="Main"

This will indicate all needed informations to solve this issue
Thanks!

Comment by Max Lam [ 2017-10-04 ]

Thanks for the effort.

Did as you've instructed, had an error during mvn exec:java -Dexec.mainClass="Main"
[WARNING]
java.lang.ClassNotFoundException: Main
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at org.codehaus.mojo.exec.ExecJavaMojo$1.run(ExecJavaMojo.java:270)
at java.lang.Thread.run(Thread.java:745)
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 51.960 s
[INFO] Finished at: 2017-10-04T16:10:36+08:00
[INFO] Final Memory: 13M/144M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.codehaus.mojo:exec-maven-plugin:1.6.0:java (default-cli) on project conj533: An exception occured while executing the Java class. Main -> [Help 1]
[ERROR]
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR]
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException

So, I'd tried to manually run the codes with SLF4J (binding with jdk logger) on my IDE, the result is as below:
------------------------------------------------------------------------
1.8.0_121
Malaysia Time
Asia/Kuala_Lumpur
Data to be inserted: 05:00:00
@@time_zone=SYSTEM
@@system_time_zone=+08
Query result: 19:00:00
------------------------------------------------------------------------

Comment by Max Lam [ 2017-10-04 ]

Pardon me,

Tried again with my IDE, did get some log now. Here are the results:

1.8.0_121
Malaysia Time
Asia/Kuala_Lumpur
2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read:
58 00 00 00 X...
0A 35 2E 35 2E 35 2D 31 30 2E 32 2E 36 2D 4D 61 .5.5.5-10.2.6-Ma
72 69 61 44 42 00 E2 06 00 00 33 57 3B 61 59 77 riaDB.....3W;aYw
6B 34 00 FE F7 21 02 00 BF 81 15 00 00 00 00 00 k4...!..........
00 03 00 00 00 60 65 5A 75 5C 50 59 4D 58 53 76 .....`eZu\PYMXSv
76 00 6D 79 73 71 6C 5F 6E 61 74 69 76 65 5F 70 v.mysql_native_p
61 73 73 77 6F 72 64 00 assword.

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: content length=225 conn=1762 com=<hidden>
2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762
15 00 00 02 ....
00 00 00 02 40 00 00 00 0C 01 0A 09 74 69 6D 65 ....@.......time
5F 74 65 73 74 _test

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1762
5F 00 00 00 03 73 65 74 20 61 75 74 6F 63 6F 6D _....set autocom
6D 69 74 3D 31 2C 20 73 65 73 73 69 6F 6E 5F 74 mit=1, session_t
72 61 63 6B 5F 73 63 68 65 6D 61 3D 31 2C 20 73 rack_schema=1, s
71 6C 5F 6D 6F 64 65 20 3D 20 63 6F 6E 63 61 74 ql_mode = concat
28 40 40 73 71 6C 5F 6D 6F 64 65 2C 27 2C 53 54 (@@sql_mode,',ST
52 49 43 54 5F 54 52 41 4E 53 5F 54 41 42 4C 45 RICT_TRANS_TABLE
53 27 29 S')

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1762
56 00 00 00 03 53 45 4C 45 43 54 20 40 40 6D 61 V....SELECT @@ma
78 5F 61 6C 6C 6F 77 65 64 5F 70 61 63 6B 65 74 x_allowed_packet
2C 40 40 73 79 73 74 65 6D 5F 74 69 6D 65 5F 7A ,@@system_time_z
6F 6E 65 2C 40 40 74 69 6D 65 5F 7A 6F 6E 65 2C one,@@time_zone,
40 40 61 75 74 6F 5F 69 6E 63 72 65 6D 65 6E 74 @@auto_increment
5F 69 6E 63 72 65 6D 65 6E 74 _increment

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762
07 00 00 01 ....
00 00 00 02 00 00 00 .......

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762
01 00 00 01 ....
04 .

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762
2A 00 00 02 *...
03 64 65 66 00 00 00 14 40 40 6D 61 78 5F 61 6C .def....@@max_al
6C 6F 77 65 64 5F 70 61 63 6B 65 74 00 0C 3F 00 lowed_packet..?.
15 00 00 00 08 A0 00 00 00 00 ..........

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762
28 00 00 03 (...
03 64 65 66 00 00 00 12 40 40 73 79 73 74 65 6D .def....@@system
5F 74 69 6D 65 5F 7A 6F 6E 65 00 0C 21 00 09 00 _time_zone..!...
00 00 FD 00 00 27 00 00 .....'..

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762
21 00 00 04 !...
03 64 65 66 00 00 00 0B 40 40 74 69 6D 65 5F 7A .def....@@time_z
6F 6E 65 00 0C 21 00 12 00 00 00 FD 00 00 27 00 one..!........'.
00 .

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762
30 00 00 05 0...
03 64 65 66 00 00 00 1A 40 40 61 75 74 6F 5F 69 .def....@@auto_i
6E 63 72 65 6D 65 6E 74 5F 69 6E 63 72 65 6D 65 ncrement_increme
6E 74 00 0C 3F 00 15 00 00 00 08 A0 00 00 00 00 nt..?...........

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762
16 00 00 06 ....
08 31 36 37 37 37 32 31 36 03 2B 30 38 06 53 59 .16777216.+08.SY
53 54 45 4D 01 31 STEM.1

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762
07 00 00 07 ....
FE 00 00 02 00 00 00 .......

Data to be inserted: 05:00:00
2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1762(M)
1F 00 00 00 03 44 52 4F 50 20 54 41 42 4C 45 20 .....DROP TABLE
49 46 20 45 58 49 53 54 53 20 74 65 73 74 5F 74 IF EXISTS test_t
65 73 74 est

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
07 00 00 01 ....
00 00 00 02 00 00 00 .......

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1762(M)
3C 00 00 00 03 43 52 45 41 54 45 20 54 41 42 4C <....CREATE TABL
45 20 74 65 73 74 5F 74 65 73 74 20 28 75 75 69 E test_test (uui
64 20 76 61 72 63 68 61 72 28 32 35 36 29 2C 20 d varchar(256),
74 69 6D 65 5F 66 69 65 6C 64 20 54 49 4D 45 29 time_field TIME)

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
07 00 00 01 ....
00 00 00 02 00 00 00 .......

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1762(M)
27 00 00 00 03 53 45 4C 45 43 54 20 40 40 74 69 '....SELECT @@ti
6D 65 5F 7A 6F 6E 65 2C 20 40 40 73 79 73 74 65 me_zone, @@syste
6D 5F 74 69 6D 65 5F 7A 6F 6E 65 m_time_zone

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
01 00 00 01 ....
02 .

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
21 00 00 02 !...
03 64 65 66 00 00 00 0B 40 40 74 69 6D 65 5F 7A .def....@@time_z
6F 6E 65 00 0C 21 00 12 00 00 00 FD 00 00 27 00 one..!........'.
00 .

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
28 00 00 03 (...
03 64 65 66 00 00 00 12 40 40 73 79 73 74 65 6D .def....@@system
5F 74 69 6D 65 5F 7A 6F 6E 65 00 0C 21 00 09 00 _time_zone..!...
00 00 FD 00 00 27 00 00 .....'..

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
0B 00 00 04 ....
06 53 59 53 54 45 4D 03 2B 30 38 .SYSTEM.+08

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
07 00 00 05 ....
FE 00 00 02 00 00 00 .......

@@time_zone=SYSTEM
@@system_time_zone=+08
2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1762(M)
66 00 00 00 03 69 6E 73 65 72 74 20 69 6E 74 6F f....insert into
20 74 65 73 74 5F 74 65 73 74 20 28 75 75 69 64 test_test (uuid
2C 20 74 69 6D 65 5F 66 69 65 6C 64 29 20 76 61 , time_field) va
6C 75 65 73 20 28 27 32 63 35 33 30 35 30 31 2D lues ('2c530501-
32 61 30 61 2D 34 61 66 65 2D 38 62 61 37 2D 30 2a0a-4afe-8ba7-0
35 32 64 66 36 66 63 33 61 35 36 27 2C 20 27 2D 52df6fc3a56', '-
30 35 3A 30 30 3A 30 30 27 29 05:00:00')

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
07 00 00 01 ....
00 01 00 02 00 00 00 .......

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1762(M)
4C 00 00 00 03 73 65 6C 65 63 74 20 2A 20 66 72 L....select * fr
6F 6D 20 74 65 73 74 5F 74 65 73 74 20 77 68 65 om test_test whe
72 65 20 75 75 69 64 20 3D 20 27 32 63 35 33 30 re uuid = '2c530
35 30 31 2D 32 61 30 61 2D 34 61 66 65 2D 38 62 501-2a0a-4afe-8b
61 37 2D 30 35 32 64 66 36 66 63 33 61 35 36 27 a7-052df6fc3a56'

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
01 00 00 01 ....
02 .

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
39 00 00 02 9...
03 64 65 66 09 74 69 6D 65 5F 74 65 73 74 09 74 .def.time_test.t
65 73 74 5F 74 65 73 74 09 74 65 73 74 5F 74 65 est_test.test_te
73 74 04 75 75 69 64 04 75 75 69 64 0C 21 00 00 st.uuid.uuid.!..
03 00 00 FD 80 00 00 00 00 .........

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
45 00 00 03 E...
03 64 65 66 09 74 69 6D 65 5F 74 65 73 74 09 74 .def.time_test.t
65 73 74 5F 74 65 73 74 09 74 65 73 74 5F 74 65 est_test.test_te
73 74 0A 74 69 6D 65 5F 66 69 65 6C 64 0A 74 69 st.time_field.ti
6D 65 5F 66 69 65 6C 64 0C 3F 00 0A 00 00 00 0B me_field.?......
80 00 00 00 00 .....

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
2F 00 00 04 /...
24 32 63 35 33 30 35 30 31 2D 32 61 30 61 2D 34 $2c530501-2a0a-4
61 66 65 2D 38 62 61 37 2D 30 35 32 64 66 36 66 afe-8ba7-052df6f
63 33 61 35 36 09 2D 30 35 3A 30 30 3A 30 30 c3a56.-05:00:00

2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1762(M)
07 00 00 05 ....
FE 00 00 22 00 00 00 ..."...

Query result: 19:00:00
2017-10-04 16:38:34 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1762(M)
01 00 00 00 01 .....

Comment by Diego Dupin [ 2017-10-05 ]

Excellent, this has permit to identify the issue.

Comment by Diego Dupin [ 2017-10-05 ]

Correction done on 1.6.6-SNAPSHOT and 2.2.0-SNAPSHOT.
Could you please validate the correction ?

<repositories>
 
    <repository>
 
        <id>sonatype-nexus-snapshots</id>
 
        <name>Sonatype Nexus Snapshots</name>
 
        <url>https://oss.sonatype.org/content/repositories/snapshots</url>
 
    </repository>
 
</repositories>
 
 
 
<dependencies>
 
    <dependency>
 
        <groupId>org.mariadb.jdbc</groupId>
 
        <artifactId>mariadb-java-client</artifactId>
 
        <version>2.2.0-SNAPSHOT</version>
 
    </dependency>
 
</dependencies>

Comment by Max Lam [ 2017-10-05 ]

Thanks Diego, the fix is good. Verified.

1.8.0_121
Malaysia Time
Asia/Kuala_Lumpur
2017-10-05 21:53:16 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read:
58 00 00 00 X...
0A 35 2E 35 2E 35 2D 31 30 2E 32 2E 36 2D 4D 61 .5.5.5-10.2.6-Ma
72 69 61 44 42 00 00 07 00 00 72 58 44 2B 49 6D riaDB.....rXD+Im
6A 4E 00 FE F7 21 02 00 BF 81 15 00 00 00 00 00 jN...!..........
00 03 00 00 00 27 72 2F 30 43 3F 51 5A 53 6E 50 .....'r/0C?QZSnP
26 00 6D 79 73 71 6C 5F 6E 61 74 69 76 65 5F 70 &.mysql_native_p
61 73 73 77 6F 72 64 00 assword.

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: content length=234 conn=1792 com=<hidden>
2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792
15 00 00 02 ....
00 00 00 02 40 00 00 00 0C 01 0A 09 74 69 6D 65 ....@.......time
5F 74 65 73 74 _test

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1792
5F 00 00 00 03 73 65 74 20 61 75 74 6F 63 6F 6D _....set autocom
6D 69 74 3D 31 2C 20 73 65 73 73 69 6F 6E 5F 74 mit=1, session_t
72 61 63 6B 5F 73 63 68 65 6D 61 3D 31 2C 20 73 rack_schema=1, s
71 6C 5F 6D 6F 64 65 20 3D 20 63 6F 6E 63 61 74 ql_mode = concat
28 40 40 73 71 6C 5F 6D 6F 64 65 2C 27 2C 53 54 (@@sql_mode,',ST
52 49 43 54 5F 54 52 41 4E 53 5F 54 41 42 4C 45 RICT_TRANS_TABLE
53 27 29 S')

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1792
56 00 00 00 03 53 45 4C 45 43 54 20 40 40 6D 61 V....SELECT @@ma
78 5F 61 6C 6C 6F 77 65 64 5F 70 61 63 6B 65 74 x_allowed_packet
2C 40 40 73 79 73 74 65 6D 5F 74 69 6D 65 5F 7A ,@@system_time_z
6F 6E 65 2C 40 40 74 69 6D 65 5F 7A 6F 6E 65 2C one,@@time_zone,
40 40 61 75 74 6F 5F 69 6E 63 72 65 6D 65 6E 74 @@auto_increment
5F 69 6E 63 72 65 6D 65 6E 74 _increment

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792
07 00 00 01 ....
00 00 00 02 00 00 00 .......

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792
01 00 00 01 ....
04 .

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792
2A 00 00 02 *...
03 64 65 66 00 00 00 14 40 40 6D 61 78 5F 61 6C .def....@@max_al
6C 6F 77 65 64 5F 70 61 63 6B 65 74 00 0C 3F 00 lowed_packet..?.
15 00 00 00 08 A0 00 00 00 00 ..........

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792
28 00 00 03 (...
03 64 65 66 00 00 00 12 40 40 73 79 73 74 65 6D .def....@@system
5F 74 69 6D 65 5F 7A 6F 6E 65 00 0C 21 00 09 00 _time_zone..!...
00 00 FD 00 00 27 00 00 .....'..

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792
21 00 00 04 !...
03 64 65 66 00 00 00 0B 40 40 74 69 6D 65 5F 7A .def....@@time_z
6F 6E 65 00 0C 21 00 12 00 00 00 FD 00 00 27 00 one..!........'.
00 .

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792
30 00 00 05 0...
03 64 65 66 00 00 00 1A 40 40 61 75 74 6F 5F 69 .def....@@auto_i
6E 63 72 65 6D 65 6E 74 5F 69 6E 63 72 65 6D 65 ncrement_increme
6E 74 00 0C 3F 00 15 00 00 00 08 A0 00 00 00 00 nt..?...........

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792
16 00 00 06 ....
08 31 36 37 37 37 32 31 36 03 2B 30 38 06 53 59 .16777216.+08.SY
53 54 45 4D 01 31 STEM.1

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792
07 00 00 07 ....
FE 00 00 02 00 00 00 .......

Data to be inserted: 05:00:00
2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1792(M)
1F 00 00 00 03 44 52 4F 50 20 54 41 42 4C 45 20 .....DROP TABLE
49 46 20 45 58 49 53 54 53 20 74 65 73 74 5F 74 IF EXISTS test_t
65 73 74 est

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
07 00 00 01 ....
00 00 00 02 00 00 00 .......

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1792(M)
3C 00 00 00 03 43 52 45 41 54 45 20 54 41 42 4C <....CREATE TABL
45 20 74 65 73 74 5F 74 65 73 74 20 28 75 75 69 E test_test (uui
64 20 76 61 72 63 68 61 72 28 32 35 36 29 2C 20 d varchar(256),
74 69 6D 65 5F 66 69 65 6C 64 20 54 49 4D 45 29 time_field TIME)

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
07 00 00 01 ....
00 00 00 02 00 00 00 .......

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1792(M)
27 00 00 00 03 53 45 4C 45 43 54 20 40 40 74 69 '....SELECT @@ti
6D 65 5F 7A 6F 6E 65 2C 20 40 40 73 79 73 74 65 me_zone, @@syste
6D 5F 74 69 6D 65 5F 7A 6F 6E 65 m_time_zone

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
01 00 00 01 ....
02 .

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
21 00 00 02 !...
03 64 65 66 00 00 00 0B 40 40 74 69 6D 65 5F 7A .def....@@time_z
6F 6E 65 00 0C 21 00 12 00 00 00 FD 00 00 27 00 one..!........'.
00 .

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
28 00 00 03 (...
03 64 65 66 00 00 00 12 40 40 73 79 73 74 65 6D .def....@@system
5F 74 69 6D 65 5F 7A 6F 6E 65 00 0C 21 00 09 00 _time_zone..!...
00 00 FD 00 00 27 00 00 .....'..

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
0B 00 00 04 ....
06 53 59 53 54 45 4D 03 2B 30 38 .SYSTEM.+08

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
07 00 00 05 ....
FE 00 00 02 00 00 00 .......

@@time_zone=SYSTEM
@@system_time_zone=+08
2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1792(M)
65 00 00 00 03 69 6E 73 65 72 74 20 69 6E 74 6F e....insert into
20 74 65 73 74 5F 74 65 73 74 20 28 75 75 69 64 test_test (uuid
2C 20 74 69 6D 65 5F 66 69 65 6C 64 29 20 76 61 , time_field) va
6C 75 65 73 20 28 27 63 34 61 38 30 38 64 62 2D lues ('c4a808db-
36 61 35 36 2D 34 36 36 66 2D 61 39 35 38 2D 31 6a56-466f-a958-1
66 61 62 34 35 32 66 65 36 38 66 27 2C 20 27 30 fab452fe68f', '0
35 3A 30 30 3A 30 30 27 29 5:00:00')

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
07 00 00 01 ....
00 01 00 02 00 00 00 .......

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1792(M)
4C 00 00 00 03 73 65 6C 65 63 74 20 2A 20 66 72 L....select * fr
6F 6D 20 74 65 73 74 5F 74 65 73 74 20 77 68 65 om test_test whe
72 65 20 75 75 69 64 20 3D 20 27 63 34 61 38 30 re uuid = 'c4a80
38 64 62 2D 36 61 35 36 2D 34 36 36 66 2D 61 39 8db-6a56-466f-a9
35 38 2D 31 66 61 62 34 35 32 66 65 36 38 66 27 58-1fab452fe68f'

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
01 00 00 01 ....
02 .

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
39 00 00 02 9...
03 64 65 66 09 74 69 6D 65 5F 74 65 73 74 09 74 .def.time_test.t
65 73 74 5F 74 65 73 74 09 74 65 73 74 5F 74 65 est_test.test_te
73 74 04 75 75 69 64 04 75 75 69 64 0C 21 00 00 st.uuid.uuid.!..
03 00 00 FD 80 00 00 00 00 .........

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
45 00 00 03 E...
03 64 65 66 09 74 69 6D 65 5F 74 65 73 74 09 74 .def.time_test.t
65 73 74 5F 74 65 73 74 09 74 65 73 74 5F 74 65 est_test.test_te
73 74 0A 74 69 6D 65 5F 66 69 65 6C 64 0A 74 69 st.time_field.ti
6D 65 5F 66 69 65 6C 64 0C 3F 00 0A 00 00 00 0B me_field.?......
80 00 00 00 00 .....

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
2E 00 00 04 ....
24 63 34 61 38 30 38 64 62 2D 36 61 35 36 2D 34 $c4a808db-6a56-4
36 36 66 2D 61 39 35 38 2D 31 66 61 62 34 35 32 66f-a958-1fab452
66 65 36 38 66 08 30 35 3A 30 30 3A 30 30 fe68f.05:00:00

2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.i.StandardPacketInputStream - read: conn=1792(M)
07 00 00 05 ....
FE 00 00 22 00 00 00 ..."...

Query result: 05:00:00
2017-10-05 21:53:17 [main] TRACE o.m.j.i.i.o.StandardPacketOutputStream - send: conn=1792(M)
01 00 00 00 01 .....

Generated at Thu Feb 08 03:16:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.