ORM： Create MySQL table, field type ghost error

[Avey777]

Describe the bug

Special note: Without modifying any code or even restarting the service; The first ID field type was varchar, but after the database deleted the sys_users table and requested again, the ID field changed to int type
(I cannot reproduce this problem every time, but the probability of it occurring is high)

Reproduction Steps

https://github.com/user-attachments/assets/60011cb6-5914-44d8-9931-2b460e64ccf6

Expected Behavior

The data type has always been varchar

Current Behavior

Irregular variation between varchar and int types

Possible Solution

No response

Additional Information/Context

No response

V version

V 0.4.10 9b1937a

Environment details (OS name and version, etc.)

linux

Note

You can use the 👍 reaction to increase the issue's priority for developers.

Please note that only the 👍 reaction to the issue itself counts as a vote.
Other reactions and those to comments will not be taken into account.

[huly-for-github]

Connected to Huly®: V_0.6-22420

[JalonSolov]

Please paste code (NOT screenshots) for complete compilable code so the problem can possibly be reproduced.

Nobody I know will want to hand re-type what is in the screenshots, nor try to create enough extra code to make a compliable example.

[Avey777]

Please paste code (NOT screenshots) for complete compilable code so the problem can possibly be reproduced.

Nobody I know will want to hand re-type what is in the screenshots, nor try to create enough extra code to make a compliable example.

source code ：core-api.zip

I will upload the complete code here because making a demo of the code cannot reproduce the problem. And how to reproduce without finding any patterns。

v -d veb_livereload watch -d log_debug run main.v -f etc/config_dev.toml

rq: http://127.0.0.1:9009/admin/init

[Avey777]

module main

import db.mysql
import log

@[table: 'sys_users']
struct User {
pub:
	id string @[sql_type: 'VARCHAR(255)';primary;immutable;unique;sql:'id']
}

fn main() {
	log.debug('${@METHOD}  ${@MOD}.${@FILE_LINE}')

	db := db_mysql() or { panic('failed to connect to database') }

	sql db {
		create table User
	} or {panic(err)}
	log.info('sys_users 初始化成功')

}


//连接Mysql/TiDB数据库
fn db_mysql() !mysql.DB {
	log.debug('${@METHOD}  ${@MOD}.${@FILE_LINE}')

	mut mysql_config := mysql.Config
	{
		host:     '127.0.0.1'
		port:     3306
		username: 'root'
		password: 'mysql_123456'
		dbname:   'vcore'
		// ssl_ca:   doc.value('dbconf.ssl_ca').string()
		// flag: .client_ssl | .client_ssl_verify_server_cert
	}

	log.debug('正在连接数据库...')
	mut conn := mysql.connect(mysql_config) or {
		log.error('Mysql/TiDB数据库连接失败')
		return err
	}

	log.debug('${conn}')
	log.info('数据库连接成功')
	return conn
}

I have written separate demos here, but I did not reproduce this issue on this demo。

Please note: I only encounter this issue when the structure field is' id '. If I change the field name, I am not sure if the problem will still occur

[Avey777]

I'm sorry, this is my fault. There are multiple processes monitoring 9009 running in the background.