sql加了distance<=1000就没有显示数据了

Question

加了 where distance<=1000 就没有数据了，怎么回事？

以下2张表的结构

CREATE TABLE IF NOT EXISTS `v1_db1`.`shop` (
    `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `state` int(1) UNSIGNED NOT NULL DEFAULT '1',
    `name` varchar(26) NOT NULL DEFAULT '0',
    `minimumPrice` decimal(7, 2) UNSIGNED NOT NULL DEFAULT '0.00',
    `addDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updateDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `deleteState` int(1) UNSIGNED NOT NULL DEFAULT '0',
    `deleteDate` varchar(25) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARSET = utf8mb4

CREATE TABLE IF NOT EXISTS `v1_db1`.`shoplocation` (
    `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `fid` int(11) UNSIGNED NOT NULL DEFAULT '0',
    `latitude` decimal(10, 8) NOT NULL DEFAULT '0.00000000',
    `longitude` decimal(11, 8) NOT NULL DEFAULT '0.00000000',
    `nation` varchar(26) NOT NULL DEFAULT '0',
    `province` varchar(26) NOT NULL DEFAULT '0',
    `city` varchar(26) NOT NULL DEFAULT '0',
    `district` varchar(26) NOT NULL DEFAULT '0',
    `address1` varchar(56) NOT NULL DEFAULT '0',
    `address2` varchar(56) NOT NULL DEFAULT '0',
    `addDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updateDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `deleteState` int(1) UNSIGNED NOT NULL DEFAULT '0',
    `deleteDate` varchar(25) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARSET = utf8mb4

Answer 1

我觉得不应该，是连的同一个库吗？ 两次执行，数据表中的数据有改变吗？